prisonmike
New Member
- Joined
- Oct 26, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am very new to VBA so I apologize in advance if this question and code is a bit amateurish.
The code I currently have is
Function CUSTOMSTYLE(TargetCell As Range)
TargetCell.Copy
ActiveCell.PasteSpecial (xlPasteValues)
ActiveCell.Font.Color = RGB(255, 0, 0)
ActiveCell.Font.Underline = xlUnderlineStyleSingle
End Function
Basically, I want to be able to take the value in any cell and reformat it in the cell I am currently working in.
Any thoughts?
The code I currently have is
Function CUSTOMSTYLE(TargetCell As Range)
TargetCell.Copy
ActiveCell.PasteSpecial (xlPasteValues)
ActiveCell.Font.Color = RGB(255, 0, 0)
ActiveCell.Font.Underline = xlUnderlineStyleSingle
End Function
Basically, I want to be able to take the value in any cell and reformat it in the cell I am currently working in.
Any thoughts?