Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a program which reads data into columns C-H. The number of rows
varies from case to case. I want the user to select a starting cell from the dat in column C I have the following which seesms clumsy but works: rw = ActiveCell.Row cl = ActiveCell.Column Range("c2").Select lastrow = Range(Selection, Selection.End(xlDown)).Cells.Count + 1 If rw < 2 Or rw lastrow - 1 Then MsgBox "Start cell outside data range" Exit Sub End If If cl < 3 Then MsgBox " Start cell in wrong column" Exit Sub End If Before exiting the sub with an error, I would like to reset the active cell to the (incorrect) cell the user selected. Can someone tell me how to do this please? Or suggest a better way? Thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using activecell in vlookup | Excel Discussion (Misc queries) | |||
Set ActiveCell at the first column of the same row... | Excel Discussion (Misc queries) | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
Activecell value | Excel Programming | |||
how to set activecell? | Excel Programming |