Hello,
I am trying to use vba to autofill formulas down columns. Here's what I have:
vba doesn't like the use of quotes within the formulas, like "shipment". However it doesn't work to remove the quotes either. I'm not even sure if using =IF in those formulas will work since vba has its own version of IF statements. Those formulas work fine within a cell on a worksheet. Can anyone help with how to enter those formulas in vba?
Please Login or Register to view this content.
Thanks!
Try this.
By the way, you could use TEXT(A2, "mmmm") instead of CHOOSE(...).Please Login or Register to view this content.
If posting code please use code tags, see here.
Please Login or Register to view this content.
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.
Use two quotes to represent one literal quote within a string.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you all for your replies! I didn't receive an email notification so I wasn't aware until now that I had received any replies.
I'll need to go back in and look at this method again, I ended up using array formulas on my sheet instead of trying this with vba. However, I had tried the two quote method after posting my original question but to no avail. I don't recall receiving any errors in vba but it just didn't autofill any of the formulas. Are those formulas maybe too complex for use in vba as string formulas? I was able to make it work using simple formulas like =A+B.
Thanks!!!
Your original code calculated the LastRow incorrectly. Try the code below.Originally Posted by indub
On another note; I used an alternate formula for the Text-Month.
Please Login or Register to view this content.
Last edited by AlphaFrog; 12-09-2015 at 08:12 PM. Reason: Sheet17
Thanks! I made those changes and decided to go with this vba option over the arrays I was using. It still wasn't working at first and I was scratching my head, turns out I do need the double quotes and also needed to remove the With/End With statement. There was no reason for it. Working well now!
I actually have 10+ formulas in my code but those examples above were enough to explain my question. Thanks again for the help!Please Login or Register to view this content.
What can I add into either that code above or the workbook itself to make it execute automatically instead of using a command button? Should I start a new thread for that question?
Last edited by indub; 12-10-2015 at 01:50 PM.
You're welcome.
You could start a new thread and explain what you mean by automatically. What's the trigger? Excel doesn't read minds.
It wasn't as difficult as I thought it would be. I used column A as the trigger so any time a cell in column A changes it'll update.
Not sure if there's a better way to do that but it seems to work for my needs. Thanks again!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks