About Us

FSt1

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.

Mike

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

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert New Data in Order on an Existing Chart	CAlloway	Excel Discussion (Misc queries)	5	August 8th 07 03:58 PM
MULTIPLE DATA - How to insert new data into existing data....	Rodorodo	Excel Discussion (Misc queries)	0	December 15th 06 11:50 PM
Use excel to insert data at the bottom of existing data	Mike Lines	Excel Programming	1	October 7th 05 03:43 PM
Insert into existing code	gav meredith	Excel Programming	0	April 21st 04 02:43 AM

Menu

About Us