Please help with the following code. Although there may be some others on the code for now I am stuck with the line
If Cel("E3:E") = " Stockwell Motors" Then
Basically, I have many sheets. They all have the same number of rows and column numbers, hence I set up rng as Set rng = ws.Range("A3:R100"). Where I am stuck is when I try to loop throught each each cell in column "E" of ws.Range("A3:R100"). If any cell in each sheet of column "E" has a name " Stockwell Motors", then copy, but I am stuck. i am sure these lines are wrong .
Please Login or Register to view this content.
Please Login or Register to view this content.
SPlease Login or Register to view this content.
Bookmarks