Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox
Hi All,
I am using Excels inputbox in VBA to obtain a cell reference. See the following Dim Rng as range set rng = application.inputbox(Prompt:=prompt...Type:=8) rng.select Say rng was C8 What I want to do is to select C8 on each sheet using a for each statement. When I try it always slects C8 in sheet1 where the user originally selected the rng. How can I generalise this so it selects rng on the activesheet. Thanks for your help. Regards Sadik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox Help | Excel Discussion (Misc queries) | |||
InputBox with VBA | Excel Discussion (Misc queries) | |||
InputBox | Excel Discussion (Misc queries) | |||
InputBox | Excel Discussion (Misc queries) | |||
inputbox | Excel Programming |