| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting a cell
Hi, using excel 2003. Can you tell me why the following code is not working? Why do I have to perform this action in two steps? Not working: ThisWorkbook.Sheets("Staff Monday").Range("B2").Select Working: ThisWorkbook.Sheets("Staff Monday").Select Range("B2").Select I have pasted values to a large range in "Staff Monday" and do not want the range to remain selected once the code has run. thanks, Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 single cell selecting muliple cell | Excel Worksheet Functions | |||
| Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
| Transfer cell values to another cell by selecting button. | Excel Worksheet Functions | |||
| enter text in cell just by selecting cell | Excel Programming | |||
| Selecting 10 charcters on one cell and pasting to another cell | Excel Programming | |||
Threaded Mode
