| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
| S1.Range("D65536").End(xlUp).Select | Excel Programming | |||
| RANGE("A65536") | Excel Programming | |||
| Question about "End(xlUp)" property | Excel Programming | |||
| Question about "End(xlUp)" property | Excel Programming | |||
![ciba1234[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
