Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code bogs down at the "If Not FoundCell" statement and I
have no idea why. I was trying to make the code more efficient by assigning all rows that I was deleting to Rng and it worked for all other statements but this one. When I break and step into the code, it gives me a 1004 error for the Set Rng = Union step. Any idea how to make this work? RcdType = Array("TributeCardRecipient") ' "Tribute") ', "NotApplicable") For Each Thing In RcdType Do Set FoundCell = SrcRng.Find(What:=Thing) If Not FoundCell Is Nothing Then If Rng Is Nothing Then Set Rng = Rows(FoundCell.Row & ":" & FoundCell.Row) Else: Set Rng = Union(Rng, Rows(FoundCell.Row & ":" _ & FoundCell.Row)) End If End If Loop Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro lagging when copying columns to other sheet | Excel Programming | |||
Issue removing leading and lagging spaces | Excel Programming | |||
Do until loop with use of another macro in loop | Excel Programming | |||
how to put a loop in a macro? | New Users to Excel |