... purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.
Sheet1 contains the following:
A B
--------------- ---------------
seize
spell
fence
total
thank
fight
noise
terms
thigh
tasty
light
swarm
shelf
allow
unity
press
board
wreck
shake
decay
Sheet2 ...
... _
CopyOrigin:=xlFormatFromLeftOrAbove 'or xlFormatFromRightOrBelow
End Sub
' Now copy the header row
Sub CopyToAllSheets()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Sheet1")
...
... Properties panel for this.
Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$").
Using the example above:
Sheet1$A11:AL12 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.