Posted to microsoft.public.excel.programming

Rick[_17_] Rick[_17_] is offline

external usenet poster

Posts: 2

How do I make a button to PasteSpecial Values only.

I am trying to create a command button that will copy a
cells values only. Expamle:
Copy,PasteSpecial,Values: B10 to B5.
B10 has a =Sum in it and all I want to copy is the amount
in B10 to B5 and I need a button to do this.
Can anyone Help me.

Thanks
Rick

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
key shortcut for PasteSpecial-Values	Jarek Kujawa[_2_]	Excel Discussion (Misc queries)	1	July 16th 08 01:34 PM
make a cell into a button	RGlade	Excel Discussion (Misc queries)	1	January 28th 08 07:35 PM
Make a 'Print button'	BrianT	New Users to Excel	2	June 30th 06 09:57 PM
Quickest alternative for shortcut of PasteSpecial then Values	rony4icab	Excel Worksheet Functions	2	May 18th 06 08:56 AM
Command Button for PasteSpecial - Values - Transpose	Alisha	Excel Discussion (Misc queries)	0	March 10th 06 09:39 PM

All times are GMT +1. The time now is 07:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us