Robert87
02-18-2014, 12:12 PM
Hello.
I have a slight problem at work.
I have a excel document where I put data in one column and several others fill in with the correct information.
What I want the VBA code to do:
Find the last cell in the column: AM with a value of atleast 1 and set a thick box border between that cell and B12. Then set printing range to the same cell and to B1.
So..
Thick Box Border = B12:last cell in AM with >1
Printing range = B1: last cell in AM with >1
After it has done that, could it print that sheet, change to a sheet named Listor, and print that one too.
This would be very appreciated.
I have a slight problem at work.
I have a excel document where I put data in one column and several others fill in with the correct information.
What I want the VBA code to do:
Find the last cell in the column: AM with a value of atleast 1 and set a thick box border between that cell and B12. Then set printing range to the same cell and to B1.
So..
Thick Box Border = B12:last cell in AM with >1
Printing range = B1: last cell in AM with >1
After it has done that, could it print that sheet, change to a sheet named Listor, and print that one too.
This would be very appreciated.