Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Selection in Macro
Hi all
i am having row number and column number (for example row = 4 and column = 20), pls tell me the method or syntax to select the cell (row = 4 and column = 20) I have used Range("row:col").select, but it is not working. second one is how to store the Activecell content I have used the follwing code for the same Dim Ac1 As Application Ac1.Activecell = Activecell.Offset(0,10).Range("A1") But it is also not working Pls help me |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Selection in Macro
Cells(4, 20).Select
-- Gary''s Student - gsnu200797 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Selection in Macro
Try this
rRow = 4 rColumn = 20 Cells(rRow, rColumn).Select or Cells(4, 20).Select I'm not entirely sure by what you mean for the second part of the question but maybe this myvalue = ActiveCell.Value myvalue1 = ActiveCell.Offset(1, 2).Value Mike "Nesara" wrote: Hi all i am having row number and column number (for example row = 4 and column = 20), pls tell me the method or syntax to select the cell (row = 4 and column = 20) I have used Range("row:col").select, but it is not working. second one is how to store the Activecell content I have used the follwing code for the same Dim Ac1 As Application Ac1.Activecell = Activecell.Offset(0,10).Range("A1") But it is also not working Pls help me |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Selection in Macro
Thank you .
"Gary''s Student" wrote: Cells(4, 20).Select -- Gary''s Student - gsnu200797 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Selection in Macro
Thank you for the solution.
"Mike H" wrote: Try this rRow = 4 rColumn = 20 Cells(rRow, rColumn).Select or Cells(4, 20).Select I'm not entirely sure by what you mean for the second part of the question but maybe this myvalue = ActiveCell.Value myvalue1 = ActiveCell.Offset(1, 2).Value Mike "Nesara" wrote: Hi all i am having row number and column number (for example row = 4 and column = 20), pls tell me the method or syntax to select the cell (row = 4 and column = 20) I have used Range("row:col").select, but it is not working. second one is how to store the Activecell content I have used the follwing code for the same Dim Ac1 As Application Ac1.Activecell = Activecell.Offset(0,10).Range("A1") But it is also not working Pls help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to get a macro to run when cell selection changes. | Excel Programming | |||
Macro - Dynamic cell selection | Excel Discussion (Misc queries) | |||
Macro help on Cell Selection | Excel Programming | |||
Cell selection in a macro | Excel Programming | |||
Cell selection in a macro | Excel Programming |