Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell/row
I have the following code and when the data form opens I want it to be on the
first record. I thought I could enter something like Range("A3").Select - just before the data form line but I get an error - Select method of range class failed. Private Sub CommandButton5_Click() Sheets("Internal Sales Report").Visible = True Sheets("Internal Sales Report").Select Application.Run "ShowDataForm" End Sub Most of you will know that I am fairly new at this so thought I was taking an educated guess! Guess I am not that well eductaed yet. -- Leanne M (Aussie) (Changed Display name from Leanne) United Kingdom (Don''t ask me what an Aussie is doing living in the UK!) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
select cell value based on value in adjacent cell | Excel Worksheet Functions | |||
I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |