Is it correct (PasteSpecial function)

gsrikanth · #3 01-08-2012, 09:08 PM

Quote:

Originally Posted by JBeaucaire

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

in below function by giving =sss(a1) in formula bar it well get font size of user

Public Function sss(strCell) As String
sss=strCell.Font.Size
End Function

like that only i need, if i give =sss(a1) remove formula and give flat value

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