| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Selecting a cell in a range
I want to select the first cell in an empty row in my range. How do I correct my code? Thanks! ---------- l_LastRow = Sheet5.Cells.Find(What:=" * ", After:=[A1], _ SearchDirection:=xlPrevious).Row Sheet5.Range("B3", Sheet5.Cells(l_LastRow + 1, 10)).Select For l_Count = Selection.Rows.Count To 1 Step -1 If WorksheetFunction.CountA(Selection.Rows(l_Count)) = 0 Then With Range(Cells(Selection.Rows(l_Count), 2).Address) .Value = 2005 End With End If Next -- Coolboy55 ------------------------------------------------------------------------ Coolboy55's Profile: http://www.excelforum.com/member.php...o&userid=26508 View this thread: http://www.excelforum.com/showthread...hreadid=400895 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| How do I refer a Range to a Cell | Excel Worksheet Functions | |||
| Counting spefic cell (not a range) with a value greater than 1 | Excel Discussion (Misc queries) | |||
| How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
| excel locks up after selecting a cell | Excel Discussion (Misc queries) | |||
Linear Mode
