Hello - Sorry if it seems like a novice question, but I'm in my first week of using VBA.
I have the following code that I want to run. Right now it's running the Macro and returning all the Values to the sheet that I'm on when I initiate the macro ("Interest Payments"). I want the code to return the values to the appropriate sheet instead. How can I do this?
Please Login or Register to view this content.
You would need to reference the worksheet, which in your case is the variable "Sh", for each applicable line of code. Something like this (you may need to tweak for your specifics):
Please Login or Register to view this content.
Another one...
My guess is you may want to put the actual date in column A instead of the =TODAY() formula. The Today function will change to the current date every day. If yes, change this line...Please Login or Register to view this content.
.FormulaR1C1 = "=TODAY()"
To this...
.Value = Date
Last edited by AlphaFrog; 10-01-2014 at 07:36 PM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks