Insert Existing Data
 

hi
we are not psychics. post your code.

regards
FSt1

"Noob" wrote:

Hey,

I'm a noob at this.. How do I get my VBA script to pull information from a
excel sheet in the same workbook? It's giving me a complie error.

Insert Existing Data
 

Sub getExcelToRunScript()
Const columnA = "A"
Const shName1 = "Sheet1"
Const ShName2 = "Sheet2"
Dim sh1 As Worksheet
Dim sh2 As Worksheet

Set sh1 = Worksheets(shName1)
Set sh2 = Worksheets(ShName2)

sh2.Range(columnA & "1").Value = _
sh1.Range(columnA & "1").Value
End Sub

"FSt1" wrote:

hi
we are not psychics. post your code.

regards
FSt1

"Noob" wrote:

Hey,

I'm a noob at this.. How do I get my VBA script to pull information from a
excel sheet in the same workbook? It's giving me a complie error.

Insert Existing Data
 

Your code worked ok for me.

What line causes the error?

Mike wrote:

Sub getExcelToRunScript()
Const columnA = "A"
Const shName1 = "Sheet1"
Const ShName2 = "Sheet2"
Dim sh1 As Worksheet
Dim sh2 As Worksheet

Set sh1 = Worksheets(shName1)
Set sh2 = Worksheets(ShName2)

sh2.Range(columnA & "1").Value = _
sh1.Range(columnA & "1").Value
End Sub

"FSt1" wrote:

hi
we are not psychics. post your code.

regards
FSt1

"Noob" wrote:

Hey,

I'm a noob at this.. How do I get my VBA script to pull information from a
excel sheet in the same workbook? It's giving me a complie error.



--

Dave Peterson