shorten code

Hello, I have a macro with VBA for this monthly chart that I make. I have a bunch of repeating lines of code that go for each day of the month but it ended up being too large of a procedure, so it doesn't allow me to execute it. I was wondering if I could get some help to possibly shorten...

Hi, I have a code that excel has generated from the "record macros" function. It doesn't always execute correctly. 1. Please review the macro and correct any issues that you may find. 2. Is there a way that a macro can include a specific printer and printer settings? 3. is there a way that a...

I have 8 macro buttons that simply change the value of one cell - [D13] to States ("NSW","QLD" ...) When this happens (ignoring the other functions) the button text turns white (from Black) all relevant code: '------------------------------------------------------------------' 'Sub...

Hi! I came up with code that filters a set of data and then copies and pastes certain columns(Customer, Project Name, vs) into another worksheet (in columns N, O, and P) Is there a more efficient way to write this code? Im having to copy/paste the same code three times in one sub. Someone...

See code below... This code checks range c2 in worksheet Hours and based on the value it prints the text HOURS to the next available D cell in worksheet Work. It works but it's too long as it goes up to 14. I need decimals involved too so if it's for example 3.25 or 3.5 it rounds down and prints...