VBA to copy from first sheet in a workbook only

[anj123]

Hi,

I'm a VBA beginner and have a macro to copy data from specific cells in a worksheet into a worksheet in a master workbook. I will be using this macro for multiple workbooks in a folder.

My problem is that every workbook in the folder has multiple worksheets. I only want to copy from the first worksheet in each workbook (the name of this worksheet varies for each workbook but is always the first tab in each workbook). I've been able to find solutions to copy from all worksheets in a workbook but not from a specific worksheet. Is anyone able to help?

Many thanks!

 

[DocAElstein]

.......

My problem is that every workbook in the folder has multiple worksheets. I only want to copy from the first worksheet in each workbook (the name of this worksheet varies for each workbook but is always the first tab in each workbook). .......

Are you looking for something along these lines...

[color=blue]Dim[/color] ws [color=blue]As[/color] Worksheet
[color=blue]Set[/color] ws = ActiveWorkbook.Worksheets.Item(1)

. Provided your first Tab was the initial first Tab ( Sheet1 ) in the workbook, than this would access the “first” Tab in any workbook just opened, regardless of its actual name

Alan

 

[anj123]

Many thanks! This is what I was looking for.

 

[DocAElstein]

Many thanks! This is what I was looking for.

. yous welcome
. Thanks for the feedback