Font and Row Height with multi with or if statements

[sas2007]

I am able to change the font size of my text based on location. However, I am unable to change the row size based on the same If Then criteria. I am unsure what I am doing wrong. any suggestions?!

I keep getting the With object must be user-defined type, Object, or Variant error

Please Login or Register  to view this content.

#vba pro in training

[Mordred]

Hi sas2007, try this slightly modified version of your code

Please Login or Register  to view this content.

[sas2007]

Thanks that really helps. the only thing is that it sets all my rows to 15.75. The rows above A101 are set to 19.

I did add the value statement to the second ("J101") line

Please Login or Register  to view this content.

[Mordred]

Does that solve it?

[sas2007]

no all the row heights are setting to 15.75. I need only the cells that are set to font 12 to be set to row height 15.75. the other cells should be height=19

[Mordred]

Try

Please Login or Register  to view this content.

[sas2007]

oww well that worked well. Thanks!!

[Mordred]

oww well that worked well. Thanks!!

LoL, did it hurt?

[sas2007]

lol not a bit!