Hi,
I am using the following macro to get data from one workbook, and copy it to another:
Sub SomeMacro()
Dim src As Workbook
Dim LR As Long
Set src = Workbooks.Open("C:\Users\RuanoC\Desktop\Temp\Matthew\Currency\StudyCurrency_Source.xlsx", True, True)
ThisWorkbook.Activate
Worksheets("Currency").Range("A:B").Formula = src.Worksheets("Currency").Range("A:B").Formula
LR = Range("A" & Rows.Count).End(xlUp).Row
Range("A2:A" & LR).NumberFormat = "00000000"
End Sub
In the last part of my code, I am trying to apply the number format of "00000000", but it doesn't seem to be working. If I click on a cell with the imported data, there are no leading zeros in the formula bar.
Help please!
Thank you,
Carlos
Bookmarks