Seamus2626
asked on
Amend code
Hi,
Two members of EE kindly provided me some code.
I would like a slight amendment.
Where it subtotals ColF, i would like it to copy the rate from above and paste it down.
E.G instead of F5= 0.00005771 Total
F5= 0.00001924
and so on.
Thanks
Seamus
Example.xls
Two members of EE kindly provided me some code.
I would like a slight amendment.
Where it subtotals ColF, i would like it to copy the rate from above and paste it down.
E.G instead of F5= 0.00005771 Total
F5= 0.00001924
and so on.
Thanks
Seamus
Example.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sure. What do you want there? Leave it blank?
Sid
Sid
ASKER
yep, blank is perfect
Thanks
Seamus
Thanks
Seamus
Just Add this line
.Range("D" & I).ClearContents
in line 25 in the above code.
Sid
.Range("D" & I).ClearContents
in line 25 in the above code.
Sid
ASKER
Thanks!!
ASKER
Thanks
Seamus