Is it correct (PasteSpecial function)

JBeaucaire · #1 01-07-2012, 03:36 PM

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

gsrikanth · #2 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

JBeaucaire · #3 01-09-2012, 01:12 AM

The normal formula =A1 will give you the "value" from cell A1.

There is not formula (or even User Defined Function) that causes another cell to lose it's formula. Only a regular macro can do that, not a function.

gsrikanth · #4 01-09-2012, 01:27 AM

Quote:

Originally Posted by JBeaucaire

The normal formula =A1 will give you the "value" from cell A1.

There is not formula (or even User Defined Function) that causes another cell to lose it's formula. Only a regular macro can do that, not a function.

we can make macro to function now?
i need that function

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