Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I modify the following code so that the response to the
InputBox can be entered in R1C1 notation? The workbook is set to use R1C1 notation in formulae in cells. Sub Input_Range_Select() Dim SR As String SR = InputBox(Prompt:="What is the Range to be Selected?") Range(SR).Select End Sub A1:J400 works as a response. I would like to be able to type in R1C1:R400C10, which does not work. TIA Fred Holmes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
refedit controls and R1C1 notation | Excel Programming | |||
Sumproduct with A1 notation instead of R1C1 | Excel Programming | |||
R1C1 Notation in VBA | Excel Programming | |||
Using Range with R1C1 notation in a macro | Excel Programming | |||
R1C1 Notation | Excel Programming |