How do I keep VBA from putting output into the active sheet?

Vote count:

0

I'm working with a bunch of csv files that have been pulled into a single workbook. I'm trying them all together into a single report. at the end, i'm putting the data into a single array and then into a single sheet.

Whenever I run the sub, however, it load the data into the active sheet. How do I get the data to show up in the same sheet, regardless of where I am in the workbook?

here's what I have:

Dim starting_cell_range As Range
Set starting_cell_range = Range(find_last_column("Data_History")) 

Dim n As Integer
With Worksheets("Data_History")
    For n = 0 To 18
        starting_cell_range.Offset(n, 1) = final_array(n)
    Next n

End With

asked 30 secs ago

dwstein

909

How do I keep VBA from putting output into the active sheet?