Hey guys and gals,
In VBA, I am trying to add a formula to the active cell, which would add the cell to the left plus 1. I just cant figure this out. Thanks in advance!
Hey guys and gals,
In VBA, I am trying to add a formula to the active cell, which would add the cell to the left plus 1. I just cant figure this out. Thanks in advance!
A lot of times, people will use R1C1 notation when writing formulas in VBA, because it simplifies many of these operations. In this case, it seems like it should be as simple asPlease Login or Register to view this content.
Originally Posted by shg
Thats great!
I am trying to ask another question with some code in the post, but it will not let me post. It takes me to a site that says it was blocked because an SQL injection was detected. Any idea why this is happening? I attached a screenshot.
Attachment 648632
Do you have multiple Replace functions, or anything that looks like SQL?
Rory
No replace function, and I'm not sure what SQL looks like. Its just 5 lines of moving the activated cell around the sheet to get to a certain cell, then moving one cell over and entering a formula. I'm trying to loop it until the cell that is activated contains the word End. Sorry for the screenshot rather than code, but it isnt seeming to work.Attachment 648638 Thank you so much!
That attachment hasn't worked.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
How about now? Thanks for your help.
It may be all the Select statements. The firewall here is a little paranoid.
Can you explain in words exactly what you're trying to do, as I can't really see the point of looping that? A sample workbook wouldn't go amiss either...
Sure thing.
So the point of this is to insert a new column each day to the right of the most recent dated column, in this case, G. So it would insert a new column in H.
Then it would add the current date, which cant be TODAY because it needs to not change each day, hence the add +1 to the previous day. It would need to do this for
each row that has a date. So new blank column for H, then current date in H1, H9, H17, H23, and H26, then stop the code. I have attached a before and after.
This is a shortened version, there are a lot more dates that would need to be entered, so it cant just be choosing these certain cells. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks