Excel crashing when executing this code

[exceluser90]

Worksheets("Main").Range(Cells(17, 1), Cells(getLastRow(2), getLastCol(18))).Copy

I'm pretty new to this, but basically getLastRow and getLastCol get the last row or column in column or row designated, respectively.

I'm trying to copy all of the cells in row 17 and below.

Any help would be appreciated.

 

[njimack]

Why do the variables getLastRow and getLastCol have (2) and (18) after them respectively?

 

[JackDanIce]

Welcome to the board.

Can you elaborate, I'm not sure I understand what the functions getLastRow and getLastCol are actually doing. Can you provide an exmaple, I'm sure there's another way to avoid using them since that's the only part of your code that I can see having potential problems.

 

[exceluser90]

getLastRow(2) gets the last row in column 2 and getLastColumn(18), gets the last column in row 18

 

[JackDanIce]

And how do you determine what values got into getLastRow and getLastCol . If you're happy with 2 and 18 respectively, then try:

Dim r as Long, c as Long
r = Cells(Rows.Count, 2).End(xlUp).Row
c = Cells(18, columns.Count).End(xltoLeft).Column
Sheets("Main").Range(Cells(17, 1), Cells(r, c)).Copy

 

[exceluser90]

Works! Thanks so much. Definitely saved me a ton of frustration.