What does these two statements mean?

[Phoenix_Turn]

Hi all,

I am a newbie with computing and was wondering wat does these two statements in vba mean?:

intItem = shtProd.Range("F65336").End(xlUp).Row
intRow = shtStatement.Range("A65336").End(xlUp).Row + 1

where the left handside are integeres

and shtProd and shtStatement are worksheets.

Anyone care to explain?

Thanks

 

[Phoenix_Turn]

No, it selects the absolute bottom row, empty or filled. You can't go any lower than that.

So wouldnt it be easier just to type:

Range("F")?

Btw. Thanks JackDanIce

 

[VoG]

That isn't a valid range reference.

 

[Phoenix_Turn]

That isn't a valid range reference.

KK, so im assuming theres no other way to express it then :|

 

[VoG]

There are other ways of getting the last filled row than using the Range("F" & Rows.Count).End(xlUp).Row method but no way of getting to the end of column F other than Range("F" & Rows.Count).Select

 

[Phoenix_Turn]

There are other ways of getting the last filled row than using the Range("F" & Rows.Count).End(xlUp).Row

oh k. Wat could that be please?

 

[VoG]

For the last filled row in column F

LR = Columns("F").Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row

For the last filled row in the entire sheet (where different columns may have different numbers of filled rows)

LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row

 

[Phoenix_Turn]

For the last filled row in column F

LR = Columns("F").Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row

For the last filled row in the entire sheet (where different columns may have different numbers of filled rows)

LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row

okily dokily!

Thank you!

 

[Phoenix_Turn]

Btw ppl,

for:

intItem = shtProd.Range("F65336").End(xlUp).Row,

wat does the ".Row" do here? And how does it contribute to the whole code here?

 

[JackDanIce]

As you stated earlier,

intItem is an interger and therefore, can only hold an integer value

You stated shtProd is a worksheet

You know what Range("F65336") is - it's a cell reference

You had .End(xlUp) explain what it does, it finds the first none empty cell in column F that is lower in value than row 65336

The .Row part returns the number of the row it finds of the cell in column F that is above the (last) cell F65336 and sets intItem to this row number

I think looking at the questions you've been asking, you'd be advised to purchase a book on VBA programming or perhaps try using internet search to answer some of your questions. Maybe do a search in Amazon, I find the Dummies guide to VBA programming very useful:
http://www.amazon.co.uk/Excel-2007-...=sr_1_2?ie=UTF8&s=books&qid=1305480189&sr=8-2

 

[Phoenix_Turn]

As you stated earlier,

intItem is an interger and therefore, can only hold an integer value

You stated shtProd is a worksheet

You know what Range("F65336") is - it's a cell reference

You had .End(xlUp) explain what it does, it finds the first none empty cell in column F that is lower in value than row 65336

The .Row part returns the number of the row it finds of the cell in column F that is above the (last) cell F65336 and sets intItem to this row number

I think looking at the questions you've been asking, you'd be advised to purchase a book on VBA programming or perhaps try using internet search to answer some of your questions. Maybe do a search in Amazon, I find the Dummies guide to VBA programming very useful:
http://www.amazon.co.uk/Excel-2007-...=sr_1_2?ie=UTF8&s=books&qid=1305480189&sr=8-2

thank you!!

So when u meant: first none empty cell in column F that is lower in value than row 65336

it is the first none empty cell at the top or is it the non empty cell and below it are all empty cells?

And what about this:

intRow = shtSummary.Range("A65336").End(xlUp).Row + 1

whats with the +1 here? :s