Finding the first empy cell in a set range of cells

[jshaw82]

Hi All,

I'm looking for a code that will select the first blank cell in a range "C6:C22". I've searched around an found something but i cannot get it to work. It coming up with error 1004 active method of range class failed

Please Login or Register  to view this content.

Anyone with any ideas.

Thanks

John

[Jakobshavn]

How about:

Please Login or Register  to view this content.

[tehneXus]

you have at least 2 possibilities:

Please Login or Register  to view this content.

regards

[jshaw82]

Thanks for the help guys i actually ended up using:

Please Login or Register  to view this content.