Recursive division Macro Mod needed for Char Type

[zeph2323]

Hello,

I need a slight mod to the below code which works perfectly otherwise. What it does is it divides whatever is in column K by 30 and puts in its relative cell in column M( There a bunch of mini tables below each other with blank rows in between). The thing is sometimes there are characters in column K like "N/A" for instance and the macro crashes since its only designed to take into account numerical and blank cells in column K. Any help in tweaking the below code is much appreciated..

Please Login or Register  to view this content.

[VBA Noob]

zeph2323,

Please read forum rules below and amend you're title

See if this helps. If it does remember to mark the thread as solved

Please Login or Register  to view this content.

VBA Noob

[zeph2323]

Hello,

Thanks for the reply. I still get "Type Mismatch Error" when there is a character in column K, like "N/A" or "None" . I have attached a copy of the spreadsheet so you may see what I'm talking about better....In essence column M is dividing column K by 30 only when it needs to.


Thanks again for any help given!

p.s - how would I post a thread as solved? I can't seem to find the option for that. Thanks

[VBA Noob]

Go to first post > click edit > advance > top right of toolbar you will see a dropdown

Try

Please Login or Register  to view this content.

VBA Noob

[zeph2323]

Hello,

Thanks for all the help! The mod worked great..the only thing is "0.00" is showing up in between the min-tables in column M. Any way for these fields to be blank instead?

Thanks again!

[VBA Noob]

Think this works

Please Login or Register  to view this content.

VBA Noob

[zeph2323]

Thank you!!! works Perfect =) KUDOS!!!!!!!!!!