Hi,
i am just trying to get grip around Macros, and was wondering, if there is a simple solution to repeat a macro for entire column.
For instance the macro below was recorded for only 10 rows, but it will be useful, if I could repeat it to 1000 rows.
Many Thanks.
Please Login or Register to view this content.
Code that does not do what you want it to do is normally of no use.
Explain what you want to accomplish.
Ok. I have two column here with data in separated by 8 rows. This runs for approx 3000 rows.
Example
NaN 1.2
0.8 2
0.7 2.7
All I wanted to do was to interpolate between the second column, as the first column represents unequal intervals (difference between the two succesive column 2 values).
So my final value table should look like
NaN 1.2 1.2
<> <> 1.3
<> <> 1.4
<> <> 1.5
<> <> 1.6
<> <> 1.7
<> <> 1.8
<> <> 1.9
0.8 2 2
<> <> 2.0875
<> <> 2.175
<> <> 2.2625
<> <> 2.35
<> <> 2.4375
<> <> 2.525
<> <> 2.6125
0.7 2.7 2.7
Regards
Last edited by Deepanshu_S; 02-26-2017 at 07:29 PM.
I do not understand what you are trying to do.
I have tidied up your code for you.
Please Login or Register to view this content.
Last edited by mehmetcik; 02-26-2017 at 07:42 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi mehmetcik,
Thanks, for correcting the vba code. However, it still does not repeat the process on 3000 rows of data and repeats it to only first 10 rows
Any suggestions.
thanks,
Deep
Post a sample workbook with some typical data. It's difficult to follow your requirements.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I have attached a sample file, where a macro is active for the first 10 rows, but I would like it to follow all the way until data is there in range of Column A:BOriginally Posted by TMS
You could try this on a copy of your workbook.
Please Login or Register to view this content.
Slightly less interaction with the sheet.
Could be a little faster on a large range.
Please Login or Register to view this content.
Many thanks @jolivanes. The macro works sweet. This has been really helpful. Will keep track of more forum posts to pick up tips and codes. Cheers!!Slightly less interaction with the sheet.
Could be a little faster on a large range.
Please Login or Register to view this content.
Thank you for letting us know that all works as needed.
Good luck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks