Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range.activate
A simple question.
When i press s userform commandbutton, I want it to activate the firs empty cell in the A collumn.. But how?? I can figure out as much as range(xxxxx).activate... But how do I ge it to recognise the first empty cell? I have thought of a countv(A:A)+1 But I cant get it to work properly.. Rune Dau -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
range.activate
With worksheets("Sheet1")
.Activate if isemtpy(.range("a1")) then .range("a1").Activate else .cells(rows.count,1).End(xlup)(2).Activate End if End With -- Regards, Tom Ogilvy "Rune_Daub " wrote in message ... A simple question. When i press s userform commandbutton, I want it to activate the first empty cell in the A collumn.. But how?? I can figure out as much as range(xxxxx).activate... But how do I get it to recognise the first empty cell? I have thought of a countv(A:A)+1 But I cant get it to work properly.. Rune Daub --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't activate an add-ins | Setting up and Configuration of Excel | |||
Activate Hyperlink in Named Range | Excel Worksheet Functions | |||
When to Activate? | Excel Discussion (Misc queries) | |||
Activate cell at end of range | Setting up and Configuration of Excel | |||
activate control | Excel Programming |