Hi VJ,

Dim rgLastCell as range
Set rgLastCell=Activesheet.range("A65536").End(xlup)

Regards,
Sébastien

"VJ" wrote:

Hi,

Is there any way I can find out the last filled cell in a column?

For exmaple I have col A and in that column first five cells filled up and
then next three cells are empty and then again next five are filled up. I
need to find the last cell in the column which is filled up.

Help would be appreciated.

Thanks in advance.