pulling data and formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MJHackman@gmail.com - 22 Aug 2007 16:49 GMT

I was wondering if there is any way to pull both the data and the
formatting when using an if function? Assuming there is not, any help
me with the VBA code to do such? Thanks.

Reply to this Message

Ron Rosenfeld - 22 Aug 2007 17:03 GMT

>I was wondering if there is any way to pull both the data and the
>formatting when using an if function? Assuming there is not, any help
>me with the VBA code to do such? Thanks.

Depending on what you want to do:

===============================
Option Explicit
Sub PrnFmt()
Dim c As Range
For Each c In Selection
Debug.Print c.Text
Next c

For Each c In Selection
With c.Offset(0, 1)
.NumberFormat = c.NumberFormat
.Value = c.Value
End With
Next c
End Sub
===============================

--ron

Reply to this Message