Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ref Edit
Hello,
I have a dialog box where I use the Ref Edit to allow someone to enter a cell range. They can enter a range that is not on the active sheet. For example, they are sheet1 and can enter a cell on sheet3. The address I get from the form is something like Sheet3!B3. But when I try to select that range using range(Sheet3!B3) I get an error message. How can I select the sheet and cell they entered? Thanks, Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ref Edit
Application.Goto Range("Sheet3!B3"), True
-- Regards, Tom Ogilvy "Bill" wrote in message ink.net... Hello, I have a dialog box where I use the Ref Edit to allow someone to enter a cell range. They can enter a range that is not on the active sheet. For example, they are sheet1 and can enter a cell on sheet3. The address I get from the form is something like Sheet3!B3. But when I try to select that range using range(Sheet3!B3) I get an error message. How can I select the sheet and cell they entered? Thanks, Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA edit | Excel Discussion (Misc queries) | |||
F2 Edit Key | Excel Worksheet Functions | |||
F2 Edit Key | Excel Worksheet Functions | |||
fx-edit | New Users to Excel | |||
Why can't I edit my excel document? Edit buttons shaded. | New Users to Excel |