inalRow = Range("A65536").End(xlUp).Row
 

I need a macro to find the final row as --

FinalRow = Range("A65536").End(xlUp).Row

Then to place a text value in the final row.

WHat is the code for this ?


--
ciba1234
------------------------------------------------------------------------
ciba1234's Profile: http://www.excelforum.com/member.php...o&userid=27299
View this thread: http://www.excelforum.com/showthread...hreadid=468027

inalRow = Range("A65536").End(xlUp).Row
 

Range("A" & finalrow).value = "hi there"
but this will really overwrite what's in that final row.
maybe...
Range("A" & finalrow+1).value = "hi there"
to get the cell under the finalrow.


ciba1234 wrote:

I need a macro to find the final row as --

FinalRow = Range("A65536").End(xlUp).Row

Then to place a text value in the final row.

WHat is the code for this ?

--
ciba1234
------------------------------------------------------------------------
ciba1234's Profile: http://www.excelforum.com/member.php...o&userid=27299
View this thread: http://www.excelforum.com/showthread...hreadid=468027

--

Dave Peterson

inalRow = Range("A65536").End(xlUp).Row
 

Hi Ciba,

See response at your previous post.


---
Regards,
Norman



"ciba1234" wrote in
message ...

I need a macro to find the final row as --

FinalRow = Range("A65536").End(xlUp).Row

Then to place a text value in the final row.

WHat is the code for this ?


--
ciba1234
------------------------------------------------------------------------
ciba1234's Profile:
http://www.excelforum.com/member.php...o&userid=27299
View this thread: http://www.excelforum.com/showthread...hreadid=468027