Change XLUP column

[munkee]

With the current code:

The xlup utilises column A for data, However I have data in Column C at row 9.

How do i edit xlup to look for the next empty cell after column C row 9?

Please Login or Register  to view this content.

Altering ActiveSheet.Range("A22") does nothing =[

[JeanRage]

Hi,

To find the first empty row in column C

Range("C65536").End(xlUp).Offset(1, 0).Select

HTH

[munkee]

I tried the code but keep getting an error here:

Please Login or Register  to view this content.

[JeanRage]

Hi,

You can test following possibility ...

Please Login or Register  to view this content.