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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: stuttgarter
- Order by date
-
Macro for Excel 2007 (Copy Paste & Loop)
Thank you Andy and Zelgar. Its working exactly the way i wanted. I am just wondering "How long i will take to develop such logic" !! :)- stuttgarter
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Macro for Excel 2007 (Copy Paste & Loop)
I am using the following code but i feel its not the optimal one as same work is done by three for loops. Any suggestings to optimize it? Dim i As Integer Dim x As Integer Dim k As Integer Dim l As Integer Dim m As Integer Dim n As Integer Range("A1:B5").Copy For i = 1 To (Range("D2").Value)...- stuttgarter
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Macro for Excel 2007 (Copy Paste & Loop)
Incredible Andy. Thanks a lot. You have written very clean code. It took 10 hours to hit and try (still unsucessful) and your few lines did it on a fly. I am trying to dig a little deeper Step 1 (Done with Andy's help): 1. Copy the content of cells A1:B5 with formatting 2. Paste it in A6...- stuttgarter
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Macro for Excel 2007 (Copy Paste & Loop)
I am new to Macros and trying to realize the following steps, but in vain 1. Copy the content of cells A1:B5 with formatting 2. Paste it in A6 3. Iterate n number of times 4. n reads the value written in cell D1 any suggestings would be highly appreciated.- stuttgarter
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
