Hi All,
My Code:
In this code, I take the address of the Active Cell.
Extract the row of the Active Cell.
Find the last column with data in it, in that row.
Set a cell address to Last_Cell_Address of the row of the Active Cell but the column being the last column in that row with data in it.
The problem: The line
returns Error Code '1004' - 'Application defined or Object Defined error'.
I've tried declaring my variables differently but end up with different errors still on the same line.
Thanks in advance all!!
Bookmarks