slashiiboy
10-19-2018, 06:00 PM
Hello, I have a series of data on one excel sheet, I need to reference this values and font colors to another sheet , since this data is constantly changing and both sheets need to have the same value and font color I was trying the following in VBA:
Public Function Value_color(ByVal cell as Range) As string
Value_color=Format(cell,cell.NumberFormat)
End Function
It is worth mentioning that the source cell has a number format but the receiver cell can be anything such as String.
Public Function Value_color(ByVal cell as Range) As string
Value_color=Format(cell,cell.NumberFormat)
End Function
It is worth mentioning that the source cell has a number format but the receiver cell can be anything such as String.