That did it....Thanks
Ian M

"Andy Pope" wrote:

Hi,

What type of variable is rrows declared as?
If you have used Long or Integer then the decimal information will not
be stored.

Cheers
Andy

pcor wrote:
I have some VBA code as this:
rrows=lastrow/4

if lastrow is 138 then rrows should be 34.5 but I always get 34(no decimal)
How do I fix that
Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info