Since its focising on sheet1 you got to delete that part...
Just put hyphen before the line and before end with line.
You may simply delete it also.
Hth
Vabs
On 28 Jun 2013 22:47, "Thiago Souza" wrote:
> I'm trying to make it work on the workbook for all sheets, I pasted as you
> say and didnt
I'm trying to make it work on the workbook for all sheets, I pasted as you
say and didnt work. So i tried to change With ThisWorkbook.Worksheets("sheet1")
for With ThisWokbook.ActiveSheet or With ActiveWorkbook.ActiveSheet,
neither of them worked. I dont want to run it on a module where I hav
Fastest way to learn is try to learn from queries posted here in forum. I
have learned VBA thru forum participation.
Thanks for Acknowledgement.
You can paste code in This workbook so as to get result in all sheet.
Alternatively, you can also use in standard module where you have to run
this cod
Very nice, Thank You. I would never get there. I only know the basic
programming language for fortran from eng. School. How do I learn VBA like
that? Any book you recommend?
Backing to work, I made the total days dont count the blank cells, for now
everything is perfect. Thank ou so much for your
I need some help with a code to the workbook uploaded. I'm having a hard
time in finding a way to start!
The workbook is to control day works of employes where they cannot work
more than 183 days in the last 365 continuous days.
I need a code where based on the selected cell it shows me anywher
