| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Selection Range
My VBA sometimes works fine with
range("A1").select Bt sometimes, it shows an error unless I include a "activesheet" in front as below : activesheet.range("A1").select Anyone please help me know why the additional "word" is needed ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| random selection from a range of cells | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
