Unfortunately this is very slow. When I try to simply select the range and set the value equal to my data i.e.:
For x = 1 To UBound(N_Data) Cells(x + 1, Last_Col) = N_Data(x) Next x
it dumps blank values. I think this is because the values in my array need to be transposed...
Range(Cells(2,Last_Col),Cells(Ubound(N_Data)+2),Last_Col)) = N_Data
|Generating a graph via Excel||3||28|
|Copy/paste a range in one worksheet from the same row when a cell in an identified column changes from blank.||10||26|
|Excel - Duplicate values in columns||4||16|
|Excel VBA - Use of double quotes in string||8||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
27 Experts available now in Live!