Macro (Excel 2003)

Topic

New Reply

I was wondering if someone could help me with a macro in Excel – it isn’t counting the Disciplines like it is supposed to. Thank you in advance.

Reply | Quote

Replies

You’re looping through the non-blank cells in column F (column number 6), starting at row 23. But there are no such cells – column F is blank from row 20 down. Perhaps you should use column H (column number 8) instead of F. But then it’s not clear what you want with the rest of your code.

Reply | Quote

Hi Hans – again I get asked to fix something – just because I know a little bit about Access & Excel. Thanks for your help. The spreadsheet is supposed to Count the Disciplines when you click the Current Total button – then put the result in F3 to F10. Someone else created this Macro and I tried to fix it.
Thanks Again

Reply | Quote

Apparently, two columns have been inserted but the macro hasn’t been updated accordingly.

Use Edit | Replace to replace:
– all instances of , 11 with , 13
– all instances of , 10 with , 12
– all instances of , 9 with , 11
– all instances of , 8 with , 10
– all instances of , 6 with , 8

Reply | Quote

Hans it still didn’t work – What are the green parts of the VB Macro?
Thanks

Reply | Quote

The green parts are lines that have been made into comments by inserting an apostrophe in front of them. Comments are not executed.

In what sense doesn’t it work? Please try to be specific.

Reply | Quote

If I do a filter on Elec in col H (Discipline) I get 22 but on the Totals col. in col F I get 16. Can I send this to you again?

Reply | Quote

I’d use formulas instead of a macro – it’s very difficult to maintain the macro.

See the attached version.

Reply | Quote

Hans as usual you are wonderful. Thank you so much it works great.

Reply | Quote