it ends up on the other sheet as 0.00E+00.
("MergeRecords").Cells(n, 3) = CStr(myArray(2))
myArray = Split(ResidentID, "-")
|Copy all Sheet1-Sheets into a newly created workbook using VBA||8||33|
|Excel 2010 - Populate a formula in multiple cells||6||26|
|the code is not looping through||11||35|
|How do I crate a Pivot table in Excel||2||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!