I have written code to delete blank rows in Col A
I would like this amended to only delete blank rows above text "Code" in Col A
Please Login or Register to view this content.
Your assistance in this regard is most appreciated
I have written code to delete blank rows in Col A
I would like this amended to only delete blank rows above text "Code" in Col A
Please Login or Register to view this content.
Your assistance in this regard is most appreciated
If I understand you correctly....
The macro above will delete cell A1 to A3,Please Login or Register to view this content.
and shift all the rows below A3 starts from cell A1.
In your case,
the text "Code" becomes in cell A1
the number 98715 becomes in cell A2
Last edited by karmapala; 09-29-2021 at 10:21 PM.
Please Login or Register to view this content.
Thanks for the help
Jindon's code is more suitable for my requirement
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks