| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a cell without selecting it
Hi,
Cells(curRow, 3).Interior.ColorIndex = 36 HTH "John" wrote: Hi fg, You're virtually there with just the Cells object: With Cells(curRow, 3).Interior .ColorIndex = 36 .Pattern = xlSolid End With Likewise you can get and set a cell's value by Cell(r, c).Value = .... Hope that helps. Best regards John wrote in message ups.com... I'm a developer, but new to Excel coding. One thing that I can't figure out... is there a way to change a cell without selecting it like below? Cells(curRow, 3).Select With Selection.Interior .ColorIndex = 36 .Pattern = xlSolid End With I don't want the cursor (cell selection box) jumping all over the screen while I'm doing things behind the scene. thanks, fg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Range in Forms Drop Down Without Selecting | Excel Programming | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| prevent user from selecting and changing a sheet | Excel Programming | |||
| Selecting & Copying a Changing Range | Excel Programming | |||
| Selecting a constant changing Range | Excel Programming | |||
Threaded Mode
