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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with Cells.Find vba
What does it actually do? Have you tried stepping through your code with F8?- StephenJR
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Problem with inserting formula in cell. VBA
Not quite sure what you're doing but doesn't this do it? Range("q1").Formula = "=SUM(B28:B" & 28 + Range("p1").Value & ")"- StephenJR
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How can I make this code faster?
Listen to Skip!- StephenJR
- Post #11
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy Rows To Sheet Based On Cell Value In Range
Don't mind me, I think Skip's is right. I was thinking you were only copying columns E and F but I re-read the question and it seems you're copying A to E. Apologies.- StephenJR
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy Rows To Sheet Based On Cell Value In Range
Replace rCell.EntireRow.Copy with rCell.Resize(,2).Copy- StephenJR
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
