worksheet functions

[Random NumNuts]

Here's what I'm trying to do:
I want a macro that will hide certain lines based upon a code in column A.
There will actually be 3 macros which will hide different sets of lines,
with overlap. I thought of using values:
1 - include with case 1
10 - include in case 2
100 include in case 3

sum together for overlap: 101 -- include in cases 1 & 3, etc.

so far so good... now I wanted a macro that could read this value and figure
it out.

For example, to find Case 2 in a spreadsheet I might do: if(mod(Ax,100)>=10)
then true...

But I couldn't find a worksheet.function for mod. Any thoughts on how to
accomplish this?

Many thanks../RN

 

[Earl Kiosterud]

Randy,

In VBA, you can use the MOD operator

a Mod b.

You might consider changing your handle for these newsgroups.

 

[Randy Numbers]

Earl,

Thanks for the info -- and I took your advice ;-) Randy