Hi folks, I am a newcomer here and trying to get to grips with Macros.
The following macro (supplied by someone else on here) almost does what I need.
It searches the whole of column C and if it is not empty it will execute another command.
If Range("C" & ActiveCell.Row) = Empty Then
MsgBox "Cell A5 is empty!"
Else
Call copymacro_name
End If
However when I test it this seems to also include the first cell which is part of my data header (the whole of the first row). Is there any way to skip that?
Also what I want to do is once I find a cell with something in it I wish to create a blank row below it
For example if something is found in Cell C row 3 insert a new row below it so row 4 is blank.
Then repeat the search for each cell in column C until I reach the end of the file.
Is this possible? Anyone have any suggestions?
Bookmarks