Computer Forums - View Single Post - Need help with simple vba script for Excel macro

foxhound · 07-14-2005, 03:40 AM

the way i would do it is make it check if there's something in the cell. if there is, then cut the contents out. then add the 0 you want, then paste it back. then move to the cell below it. and repeat the process (use a do while selected cell <> "" ) .
should work.

07-14-2005, 03:40 AM	#2 (permalink)
foxhound Junior Techie Join Date: Feb 2005 Posts: 50	the way i would do it is make it check if there's something in the cell. if there is, then cut the contents out. then add the 0 you want, then paste it back. then move to the cell below it. and repeat the process (use a do while selected cell <> "" ) . should work.