ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   range and cells syntax (https://www.excelbanter.com/excel-worksheet-functions/14303-range-cells-syntax.html)

mango

range and cells syntax
 
dear all,
can help me to clear my doubt. thanks alot

1) all data in bracket for cells and range must be string?

cells
2) i do not understand if the row data must be type string? why?
Line and i must be string?

Line = Line + 1
Set z = tableB.Cells(Line, "A")

shead = Left(Cells(i, "B").Value, 50)

3) the row for range also must be type string?
rows.count will return a number which is string type?
lastrow also a string?

Set tableB = Worksheets(tosheet).Range("A:G")

Line = Worksheets(tosheet).Range("A" & Rows.Count).End(xlUp).Row

Range("A1:C" & lastrow).Select

Worksheets(tosheet).Range("A1").Value = "Desc"






All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com