Change active cell when pasting date from another workbook

**JBlam** · 04-11-2013, 07:05 AM

Hi,

New to VBA so sorry if this is a simple question!

I have a spreadsheet with VBA that opens up other files (i select), copies one in & closes the file, then opens the next one up and pastes that underneath the first set, closes it and so on. My active cell always seems to be A1 but i want it to change to be the column A of the last row that data was pasted in (+1)

Code so far is

Please Login or Register  to view this content.

Any help is appreciated!

**patel45** · 04-11-2013, 07:30 AM

your code works on my test wb.
what is wsMstr ? attach the 2 files for testing, include a sheet with desired result

**Norie** · 04-11-2013, 07:54 AM

Is there any data in column A?

**JBlam** · 04-11-2013, 08:00 AM

Originally Posted by patel45

your code works on my test wb.
what is wsMstr ? attach the 2 files for testing, include a sheet with desired result

In the 2 files (there will be more, & there will be thousands more rows than in the examples) there is header information that i need to be copied into a column on the main sheet next to all the data. If i can get it to recognise the first cell in the new set of data each time as the active cell, i can use that to copy the relevant data and paste to the side and then i can delete the header information as it will be at the side (hope this makes sense!)

**patel45** · 04-11-2013, 12:35 PM

what is the master sheet ?

**JBlam** · 04-12-2013, 04:03 AM

The master sheet is the one that will end up having all the data from the various sheets in it. The file with the code in

**patel45** · 04-12-2013, 04:26 AM

Please Login or Register  to view this content.

**arlu1201** · 04-12-2013, 04:33 AM

JBlam,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.