Hi, I am new to this Forum and also in writing Macros.
So, I have managed to write this Macro to copy the value of J2 to K2 and subsequently to L2..M2..N2... where the updated value of J2 is being recorded in subsequent cells at 1 minute's interval.
Please Login or Register to view this content.
My question is, how do I now modify this Macro to also copy the values of J3 to K3..L3..M3..N3.. and J4 to K4..L4..M4..N4... upto J218 to K218..L218..M218..N218... ?
Thanks.
Last edited by Swarnendu; 07-15-2017 at 03:55 PM.
Maybe:
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.Please Login or Register to view this content.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks a ton!! it works perfectly!!
Now, how can I program this Macro to start a 9.00 AM and stop at 3.30 PM everyday from Monday to Friday?
Thanks once again..
Last edited by Swarnendu; 07-16-2017 at 05:30 AM.
You're welcome and thanks for the rep!
I'll have to research your question as I don't know offhand
OK, I'll be waiting.....
Hi again..
I think I have managed to write the code for starting the macro at 9AM
I have written this on Thisworkbook:
And, this works!!Please Login or Register to view this content.
Now, how to stop the Macro at 3.30PM?
If I replace the last line of my "MntCalculate" Macro with
will it work?Please Login or Register to view this content.
And, how to NOT run the Macro on Saturdays & Sundays??
And, How to automatically open this workbook at 9AM???
Thanks,
Swarnendu
Last edited by Swarnendu; 07-15-2017 at 05:22 PM.
I'm Guessing:
Please Login or Register to view this content.
OK, I'll give it a try and come back tomorrow with the result.
Thanks again!!
Swarnendu
You're welcome againHope it works.
OT:
("You must spread some Reputation around before giving it to xladept again."
I understand why it is necessary. But, what if I find no one else to "spread some Reputation around"? )
Back to Topic:
It seems that the latest Macro is working. I'll have to observe a whole week and a day more to be certain though. Meanwhile, I have used the Task Scheduler to OPEN the Worksheet at 9 AM (the one I thought would be the toughest eventually came out to be the easiest,though for now it will run on Saturdays & Sundays also, but I think I will be able to find a solution to that myself)
Thank you xladept for all your help. This is the first time I have tried my hand on writing VBA codes. But, I am certain this will NOT be my last. It's people like you who inspire people like me to always try new things in life.
BTW, if you ever need ANY suggestion about anything concerning dogs, you can always mail me at [email protected]
Swarnendu
Ok, now I am getting an error in the line after "Else", "Ontime" is being highlighted..
SwarnenduPlease Login or Register to view this content.
* There may have been an extra comma in the codePlease Login or Register to view this content.
Now there is a "Runtime error '1004'. Method 'Ontime' of object '_Aplication' failed"
What if I remove the condition "Else"? My program will run from Monday to Friday, what will happen on Saturdays and Sundays?
FYI, I initially missed the Else and subsequent two lines when I wrote it after your previous post, and there was no errormessage.
From what I've read, we need to find a way to stop it.
How about this one? I got it from someone else, who thinks that the Day function is incorrect...
Please Login or Register to view this content.
My bad - it should be weekday.
Maybe:
Please Login or Register to view this content.
Well, these are my latest Macros, and everything seems to be working fine:
Workbook:
Sheet7:Please Login or Register to view this content.
Thank you xladept for all the help you provided.Please Login or Register to view this content.
I'll come back to start another thread if I still face any problems with the codes.
Swarnendu
Last edited by Swarnendu; 07-19-2017 at 06:42 PM.
Great! Glad you got it working! You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks