Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 3 columns in a spreadsheet; data (which can be either numeric or
alpha) in Column A always starts in Row 11 and can go for 5, 10, or 10000 rows (i.e., it varies each time). Data (which can be either numeric or alpha) in Column B always starts in row 2 and the last used cell can also vary each time. Column C is blank. I need a macro that will do the following: 1) Go to C2 and determine if Column A contains any instances of what is in cell B2; if it does, then skip down to C3. If Column A does not contain any instances of what is in cell B2, then enter 'N/A' in C2, and go on to C3. 2) Repeat this action through to the last used cell in Column B, at which time, go on to the rest of the sub that follows. Can someone please help me with this? Looping (and integrating last cell code) is beyond my expertise at this time, but I'm trying to learn. Thanks....Paige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Loop and Find | Excel Programming | |||
Find & loop in VBA | Excel Discussion (Misc queries) | |||
VB can't find my For loop??? | Excel Programming | |||
Find and loop | Excel Programming |