Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Loop and If module for checking and copying cells
Got it, just changed nRow to nRow + 1 and it works perfectly. And thanks for the explanation of how the code works Cheers Brent- BG123
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop and If module for checking and copying cells
Geoff It works, that is excellent, thanks so much!! Gotta sit down now and run through you code to try and understand it!! thanks again Brent- BG123
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop and If module for checking and copying cells
Geez that was a quick response,thanks for that Geoff. I've just ried to run it and had a compile error come up pointing out that the variable c and nRow were not defined, so I defined nRow as an Integer but didn't know what to do about c. I noticed that c is used quite a bit in your code, what...- BG123
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop and If module for checking and copying cells
I am writing my first VBA macro for Excel and struggling a bit at the moment. What I am trying to do is as follows: I have an old job list (Book1.xls) and a new job list (Book2.xls), I want to update cells in a column on the old spread sheet using the new one. What I have tried to do is write a...- BG123
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
