VBA to remove rows when cell in a column is blank
I want to setup a spreadsheet with pre-set graphs and calculations (with 1000 rows only). User only allow to enter 2 types of info: 1) Data ID (Row A), 2) Data Value (Row B).
Since this spreadsheet will be locked (except the 2 columns), user cannot delete un-used rows (Eg. Max with 1000 rows, but user may need 200 entries only).
I need the user to be able to "hide" or "delete" blank rows, so that the graph axis will reflect only used rows. Eg. 200 entries, not 1000 entries.
Tried to use various equations but getting very complicated. Is there any macro can help me to resolved this issue?
Many thx all.