Posted to microsoft.public.excel.programming

Mike G.[_3_] Mike G.[_3_] is offline

external usenet poster

Posts: 2

Need to perform action on range

I would like to have a range on a spreadsheet give me a value when typed in.

for example In range C15:G77 I want to pick a cell and type 80, but I want
it to show me only 20 (25% of the amount I put in).
OR
I'd like to type in numbers in cells, activate a macro (Ctrl+q) and have it
multiply ONLY the new information by a factor (25%).

Reply here or

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Perform action on every workbook in a directory	Btibert[_8_]	Excel Programming	2	February 6th 06 07:33 PM
Compare two sheets and perform action routine	wayliff[_9_]	Excel Programming	2	January 16th 06 08:28 PM
How to 'Click and then perform action'	chris100[_7_]	Excel Programming	14	August 2nd 05 02:57 PM
How to perform action in all worksheets	Sethaholic	Excel Programming	6	July 11th 05 07:44 PM
Perform action when cell is clicked	Jason[_26_]	Excel Programming	3	October 4th 03 06:08 PM

All times are GMT +1. The time now is 06:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us