ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with time VBA (https://www.excelbanter.com/excel-programming/292505-re-help-time-vba.html)

Jonsson

Help with time VBA
 
Hi guys,
As I have about 50 sheets to change,
I choosed to use the one that you suggested Bob, it was easier to copy and
paste AND IT WORKS!!

Thanks, you saved my day!!

//Thomas



Bob Phillips[_6_]

Help with time VBA
 
Thomas,

Thanks for the feedback, but it would be better to keep to the original
thread, it saves people from reading unnecessarily.

FWIW, I think my way is "better" as it rolls off the keyboard better, there
is no Union'ing going on, and it is the Excel (as against VB/VBA) accepted
way of declaring multiple ranges.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jonsson" wrote in message
...
Hi guys,
As I have about 50 sheets to change,
I choosed to use the one that you suggested Bob, it was easier to copy and
paste AND IT WORKS!!

Thanks, you saved my day!!

//Thomas






All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com