Is it correct (PasteSpecial function)

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Is it correct (PasteSpecial function)

FAQ

Thread Tools

Display Modes

01-07-2012, 03:36 PM

JBeaucaire JBeaucaire is offline

Windows XP Is it correct (PasteSpecial function)

Office 2003

Advanced Beginner

Join Date: Dec 2011

Posts: 51

A FUNCTION() is by definition a formula. If it is used in a cell, that is.

However a macro can be invoked to run on the activecell. This macro will convert the current selected cells into flat values:

Code:

Sub RemoveFormulas()
    Selection.Value = Selection.Value
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Backup PST with correct folders	dmarques	Outlook	2	06-04-2011 09:59 AM
No scroll bar even though settings are correct	Lorretta	Word	2	05-06-2011 07:31 AM
Correct Format needed	TonyB	Mail Merge	3	05-03-2011 01:10 AM
So what is the correct value of PONT_STRING anyway?	DrDOS	Outlook	0	11-21-2010 04:30 AM
Auto Correct to Stay On	sanzlink	Word	1	01-16-2009 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:37 PM.