Sorry, I left out a reference to the sheet in the formula.
Put the sheet name and ! between = and Cells(... without
any spaces. This will ensure the formula is referencing
cells on the correct sheet
GS

-----Original Message-----
I have excel table on excel VBA form. There are no. of
cells filled and
need to export to excel sheet. I put a command button to
do that & for
one cell I put the code as :
Private Sub CommandButton1_Click()
Worksheets("Sheet1").Range("C1").Value =
Spreadsheet1.Cells(1,
15).Value
End Sub
i.e. after I click the button, the value is copied in the
worksheet.
This has no problem, bus since there are lots of them to
be copied & my
code will become very large, such as
Worksheets("Sheet1").Range("C1").Value =
Spreadsheet1.Cells(1,
15).Value
Worksheets("Sheet1").Range("C2").Value =
Spreadsheet1.Cells(2,
15).Value
....... and so on.
The cells on worksheet are C1 to C40 and F1 to F40. These
should have
values from Spreadsheet cells(1,15) to (40,15) and cells
(1,16) to
(40,16) respectivley.
How do I make it in simple way ?( may be looping ? but I
am handicapped
with the knowledge)


---
Message posted from http://www.ExcelForum.com/

.