Can someone please help me with the next peice of code required for this:
I want to go to the last row of the sheet and add some BOLD and Colour formatting.
the TOTALS range is C26:X26 (although the amount of rows change on a daily basis)
I have all the code working, and have got as far as:
Which adds "Turnover" into cell B**, I then want to format the subtotals to BOLD and highlight the cells as GREY.
Please Login or Register to view this content.
Can anyone help please?
thankyou.
Last edited by Robotacha2010; 04-15-2011 at 08:21 AM.
Like this:
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
thankyou greatly.
Can you just answer 1 more question for me please?
where you have
where 22 refers to the column (X), what is the '1' doing?Please Login or Register to view this content.
This refers to the range C26:
Please Login or Register to view this content.
This resizes the range being referred to 1 row tall (same as it already is) and 22 columns wide (across to X):
Please Login or Register to view this content.
Dom
thankyou.
hate askign questions, and I am learning from everything Im told,
Could you possibly add a little more code for me?
I want these newly formatted cells, to also have borders?
I have tried:
Please Login or Register to view this content.
You were nearly there, just didn't need the selection bit:
Please Login or Register to view this content.
Try and get using Select and Activate out of your head when writing vba code. They are the manual actions that you perform when working on a spreadsheet and as such if you use the macro recorder it translates them into code but they are not needed and best avoided.
Dom
Again, sincere thanks!
I can now add this macro button to a colleagues computer, schedule the raw data speradsheet to be emailed to him, and he can do the work himself! now saving me 15 minutes each day :D
all thanks to you.
regards,
"a happy" Michael.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks