| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Addressing cells on inactive sheets
Thanks Nick,
Problem solved John D. "Nick Hodge" wrote in message ... John You cannot select a cell on an inactive sheet -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "John Duffus" wrote in message news:g%s6f.259490$1i.7890@pd7tw2no... Hi, I 'm still using Excel 97 and have this sub in a module. Public Sub CellsOnInactiveSheet() With Sheets("Sheet1") .Range(.Range("A1"), .Range("B2")).Select End With End Sub If any sheet except Sheet1 is active this produces an error. I would have thought with a fully qualified address it should work with any sheet active. I don't really want to activate the sheet if I can help it. Any help appreciated, thanks, John Duffus |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Formula help for using a range of cells! | Excel Worksheet Functions | |||
Threaded Mode
