I am sorry for the general topic of this thread - what is specifically bugging me is the following:
I am selecting a range by the following:
The problem is that sometimes the file that I am running this macro on has null values (ie nothing) which leads to an erroneous selection ie it stops eventhough there is alot more cells with values after the null value. I cannot choose the entire column as the entire range! Does anybody have a clue how to get by this?