Nader
12-01-2011, 02:05 AM
I'm trying to print data from sheet1. row.cells selected to sheets.cells
But I don't know how to do
I tried to make this but didn't accept
Dim cel as Cells
For i as Integer= sheets(1).Cells.Rows.Count -1
set Cel= Sheets(1).Cells(i,1).Cells.Value
Sheets(1).Cells.Value = cel.Select
But I don't know how to do
I tried to make this but didn't accept
Dim cel as Cells
For i as Integer= sheets(1).Cells.Rows.Count -1
set Cel= Sheets(1).Cells(i,1).Cells.Value
Sheets(1).Cells.Value = cel.Select