| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change Selection to specific Range
I am trying to change Selection in my code to a specific Range.
I want it to be: Range("B31:O31", [Last]) When I try to replace Selection in the code below I get an error when I try to run in. If Selection.Rows.Count 1 Then Set Rng = Selection Any ideas? Thank You. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selection of specific cells | Excel Discussion (Misc queries) | |||
| Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
| Range name: Change from sheet specific to global | Excel Discussion (Misc queries) | |||
| Specific datapoints selection | Charts and Charting in Excel | |||
| specific data selection/pasting | Excel Discussion (Misc queries) | |||
Hybrid Mode
