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

I am working with a group of CSV files which have been dragged into a workbook. In the end, I put the data together in a single array and then in one sheet.

Whenever I run sub, however, it loads the data in the active sheet

  As the slow start_cell_range range set, How do I show data in a single sheet, how can I show data in a single sheet?  
 ("data_history")) has been started in the form of DMN N for integer ("data_history") with workspaces ("data_history") from n = 0 to 18 initial_gate_orig.phase (n, 1) = Last_array (n) Next n end  

The problem is that before you get the sheet, Determining:

  initial_grade_referenceRange = set (find_last_column ("Data_History")) This is using active sheet, as the car Integer with Yptrkon ( "data_Y history") offers to move the sheet that you want  

just the line that defines the border after the shell you define. Remember to use and with with instead of range block (it's like calling worksheets ("Data_History" ). Range (...)

Here is the full code:

  Range as the start_cell_range range with dim n verticals ("data_history Set the set_cell_range =. ("Data_history") set for n = 0 to 18, initial_gate_orange.offetset (n, 1) = next_ and next with end_array (n)  

< / Div>