Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting a range
After I put my data in cell E10, I want to goto cell B15.
What I have here in the procedure in line 3 is the line from a macro I recorded to try to get an idea how to do this. But this line has the value i input during recording. I will need to input a different value on each use of the ws. I expect I need a variable declared to allow cell value to change, but I don't have enough knowledge to know exactly how to do it. I'm thinking that if I declare a variable, then say activecell.value = Myvariable, that might do it - but this is a newbie guess from other code I've been reading. If this is right, does the variable name need to go in the parantheses in the public sub line? Please help Public Sub Worksheet_Activate() Range("E10").Activate ActiveCell.FormulaR1C1 = "34567" Range("B15").Select End Sub thank you Joanne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help with selecting a range | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Selecting Range | Excel Programming | |||
Help please in selecting range dependent on another range | Excel Programming | |||
Selecting a Range inside a range | Excel Programming |