Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA loop cells
Goodmorning group,
Can someone help me with this one. I'm looking for VBA code to do the following. From 3 fixed cells (P50, P71 and P93) I want to select the first, follow procedure and than loop for the next cell and repeat the procedure. Thanks in advance. greetz, @3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA loop cells
Sub DoThings()
Dim oCell As Range For Each oCell In Range("B5,B7,B9") oCell.Font.Color = vbRed Next oCell End Sub Chrissy. Adrie Rahanra wrote Goodmorning group, Can someone help me with this one. I'm looking for VBA code to do the following. From 3 fixed cells (P50, P71 and P93) I want to select the first, follow procedure and than loop for the next cell and repeat the procedure. Thanks in advance. greetz, @3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare cells, copy, loop | Excel Worksheet Functions | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
How do I loop a range of cells until I get a numeric value? | New Users to Excel | |||
Loop | Excel Discussion (Misc queries) | |||
How to loop through cells in macro | Excel Programming |