LinkBack URL
About LinkBacks
Hi
I'm after a macro to copy a formula down in column d based on if there is data in the corresponding cell in column a.
Eg
if a1 to a11 had data the formula in d1 would copy down to d11
Regards
Hi
I'm after a macro to copy a formula down in column d based on if there is data in the corresponding cell in column a.
Eg
if a1 to a11 had data the formula in d1 would copy down to d11
Regards
You are not thinking clearly.
To do what you ask you would need a for next loop and an if then statement etc etc.
You can do it a lot faster as follows:-
Please Login or Register to view this content.
If you do not want the user to see the formulas being pasted and then cleared then turn off screen updating.
Please Login or Register to view this content.
Last edited by mehmetcik; 02-15-2017 at 02:17 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.
Hello shrubfact,
Another alternative approach.
Putting it all together is shown in the attachment.Please Login or Register to view this content.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
As I'm new to VBA I think I understand winon's easier at the moment and think I can adapt this to work for what I want.
Many thanks to you both
Hi shrubfact,
Thank you for the feedback.
You are welcome, glad I could help, and thank you for the Rep points, it is much appreciated!
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks