Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi everybody, I have the follwoing code which works on going to the first blank cell in column A ONLY .. I want to adjust it to go to the first blank cell in the current cloumn ... wether it is A or B or what ever. Code: -------------------- Sub Blank() Cells(Range("A1").CurrentRegion.Rows.Count + 1, 1).Select End Sub -------------------- I hope my question is clear. Thank you for all. -- LoveCandle ------------------------------------------------------------------------ LoveCandle's Profile: http://www.excelforum.com/member.php...o&userid=28612 View this thread: http://www.excelforum.com/showthread...hreadid=486621 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell or column highlights when other cell is selected | Excel Worksheet Functions | |||
Last non blank cell in selected cells | Excel Worksheet Functions | |||
getting value 1 column to right of cell selected in pulldown | Excel Worksheet Functions | |||
How to highlight row and column of the selected cell | Excel Discussion (Misc queries) | |||
how to know the column/row of a selected cell in vba? | Excel Programming |