3 quick questions

2 Quick Questions;

1. using;

Please Login or Register  to view this content.

How do I offset by 1 additional row in order to create a tally/totals row?

I am currently creating the tally/total row after each Next i but thats slowing things down, I'd rather just add the tally bar to the end once Next i has completed.

2. I am trying to make specific set of columns hide depending on which macro is run.

Maybe there is a way to do this differently, radio buttons, checkboxes, maybe a string of nested IF statements or something else?

Please Login or Register  to view this content.

and 3.
Is there a way to use radio buttons, check boxes etc without using Userforms? or ActiveX (my work does not allow ActiveX to execute)

Can anyone offer a suggestion?

Q1: after your next i loop is completed add the formula for your tally/total to the next row.

cells(Range("C" & Rows.Count).End(xlUp).Row+1,3) = 'Enter your tally/total formula here.

Q2: You could probably use a Case statment which would assign your ColA and ColB variables depending on which subroutine was run. However without knowing how your code decides which subroutine to run before the HideMe sub it is hard to know if this would be more effecient that what you show in your example. If the Sub run depends on the date 'April, May, June' you could simplify things by assigning a vairable to the month and using that in your case statement.

Q3: You can place optionbuttons and checkboxes directly on the worksheet without having to use a userform. however I'm not sure if this requires Active X or not.

HTH

Thank you very much..

now that that part is solved, on to the next step.

Cheers
Aurbo