| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Range
I have a macro for my spread sheet. When I get to Range, I want to say
Range (J ) .Select What can I put after the J to have the range always be on whatever active row that I am currently on, without actually putting the row number down. Range (JActiveCell) .Select obviously doesn't work. Any ideas. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro Range
Range("J" & activecell.row).select
hth Carlo On Jan 17, 2:21*pm, mbnspect wrote: I have a macro for my spread sheet. *When I get to Range, I want to say Range (J *) .Select * What can I put after the J to have the range always be on whatever active row that I am currently on, without actually putting the row number down. * Range (JActiveCell) .Select obviously doesn't work. Any ideas. *Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro Range
And another possibility...
Cells(ActiveCell.Row, "J").Select or Cells(ActiveCell.Row, 10).Select Rick "carlo" wrote in message ... Range("J" & activecell.row).select hth Carlo On Jan 17, 2:21 pm, mbnspect wrote: I have a macro for my spread sheet. When I get to Range, I want to say Range (J ) .Select What can I put after the J to have the range always be on whatever active row that I am currently on, without actually putting the row number down. Range (JActiveCell) .Select obviously doesn't work. Any ideas. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro based on range value | Excel Discussion (Misc queries) | |||
| Adding Name Range to this macro | Excel Discussion (Misc queries) | |||
| Name a Range - Macro | Excel Worksheet Functions | |||
| Use Range Name in Macro | Excel Worksheet Functions | |||
| variable range in a macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
