Compile Error: Expected Function or Variable

[Shailender]

Hello All,

i have a problem in the code when i try to run the code Lastr = Sheets("Sheet3").Cells(rows.Count, Ac).End(xlUp).Row, in these case i am trying to select entire column including blank rows. But when i am trying to find last row with the same method, it shows an error message Compile error: Expected function or variable.

Please anyone help me out.

Thank you in advance.

 

[YasserKhalil]

"AC" would be put between quotation " "

Lastr = Sheets("Sheet3").Cells(Rows.Count, "AC").End(xlUp).Row

 

[Shailender]

Hi Yasserkhalil,

Thank you for your reply. But my question is when i write a code to find last row, it is showing an error message. It is getting struck nears ROWS, and showing the above mentioned Debug.

 

[Chihiro]

Compare his code to your's.

Basically, when referencing column in .Cells() you need to either reference it using column number or nest it in "". Otherwise you'll receive error message.

Lastr = Sheets("Sheet3").Cells(Rows.Count, 29).End(xlUp).Row

 

[YasserKhalil]

Can you upload a sample of your workbook.. may be you have merged cells or something similar

 

[Shailender]

Hi All,

I am able to run the code as mentioned in the above comments, mightbe i am facing an issue in that particular sheet. I did it in the new sheet.

Thank you for your time and patience.