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!
-
For loop with integer
Your message Also, why are you coding the same formula within a loop? If your FIRST formula is coded properly, than all you need to is COPY if and PASTE it into the range. However, your formula does NOT seem to be properly coded with the necessary ABSOLUTE refences to row 2 for N2 & O2. The...- ajkingy
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
For loop with integer
Well thats just being a complete and utter noob for you. That works quicker! Cheers skip- ajkingy
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
For loop with integer
Cheers guys works perfectly!- ajkingy
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
For loop with integer
Hey I'm stuck on this for loop with RC formatting. Probably easy? Dim x As Integer x = 7 For x = 7 To 379 ' This next part the range M x+2 works fine but when I put the x into formula it doesn't work, tried with & and "" but not fully sure on how to write it. Range("M" & x + 2).Select...- ajkingy
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
