Hi Buktar,
If you entered a formula in cells C1-C40 and F1-F40 that
referenced the source data, the respective cells in C and
F would automatically update, showing the values as soon
as they are entered in the referenced cells. Here's the
formula to enter in C1: =Cells(1, 15) then copy it down
the number of rows required. Repeat for F1 as follows:
=Cells(1, 16)
Regards, 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/

.