I've tried that but I get overflow. Guess I need to play around with it some
more.

Thanks.

"Gary''s Student" wrote:

Multiply or divide by a power of 2.
--
Gary''s Student - gsnu200902


"TheWizEd" wrote:

How do you perform a bitwise shift in VBA (Excel)?

I have seen an operator in some VB code like this.

x = y << 8 ' I believe this mean shift y 8 bits to the right

But this is not in VBA. Any suggestions?