Hi
I have attached a test data sheet, I need 0.00's in the blank cells with the table A1:BG290 but the table array or size will vary each time I run my macro. Appreciate any help
Thanks
Leanne
Hi
I have attached a test data sheet, I need 0.00's in the blank cells with the table A1:BG290 but the table array or size will vary each time I run my macro. Appreciate any help
Thanks
Leanne
Should 0.00's be put in each blank cell in the above range? Or certain columns?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The attachment is an example - the amount of columns will remain constant but rows will vary- I need to fill any blanks with a "0.00" - there will be columns with data some months then others it will be blank - hope that helps and many thanks for yr help
Leanne
![]()
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks