Max/Min Value VBA From Column Not Working

[clattenburg cake]

Hi,

I'm trying this bit of code to obtain the max and min values and print them into Range C2 and E2, however I get a debug error (Run time error 438, object doesn't support this property or method)

Please Login or Register  to view this content.

There must be something wrong with my syntax but I can't figure out what it is! Can somebody help please?

[berlan]

Try,

Please Login or Register  to view this content.

or without declaring rng1 and rng2,

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

You've spelled worksheet incorrectly.

[Richard Buttrey]

Thanks for the rep.

Don't despair! I've received numerous similar T-shirts over the years and am thinking of opening a stall on my local market.