I want to delete blanks row in a file that I am reading in so I check for blank cells. I then try to slect the row by the row number. this is where it hangs up.
CURRENT_ROW = 7
Rows("CURRENT_ROW:CURRENT_ROW".Select <= hangs up
because I know that
Rows("7:7".select
works
any help would be great thanks
CURRENT_ROW = 7
Rows("CURRENT_ROW:CURRENT_ROW".Select <= hangs up
because I know that
Rows("7:7".select
works
any help would be great thanks