Macro Needed: Divide active Cell by 10

FrankB · Sep 23rd, 2002, 12:18 PM

Hi,

I need a macro that divides the number in the active cell by 10, and pastes the new number in the same cell - Can anyone help?

Thanks,

Frank

Juan Pablo González · Sep 23rd, 2002, 12:25 PM

ActiveCell.Value = ActiveCell.Value / 10

FrankB · Sep 23rd, 2002, 12:40 PM

Thanks,

That was quick and easy: I would like learn at least some basic VBA skills - any recommendation where to start?

Frank

Sep 23rd, 2002, 12:25 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,771	ActiveCell.Value = ActiveCell.Value / 10 __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sep 23rd, 2002, 12:18 PM	#1
FrankB Join Date: Sep 2002 Posts: 30	Hi, I need a macro that divides the number in the active cell by 10, and pastes the new number in the same cell - Can anyone help? Thanks, Frank

Sep 23rd, 2002, 12:40 PM	#3
FrankB Join Date: Sep 2002 Posts: 30	Thanks, That was quick and easy: I would like learn at least some basic VBA skills - any recommendation where to start? Frank