Getting the Last Row in Excel: The Most Common Mistake! Speed Tip

Many people have come to me asking why their lastrow or nextrow line of code won't work. Upon examining, this is usually the reason. Here's their code. Can you spot what's wrong?

Custom Ranges and Getting LastRow to Work with Copy and Paste - Excel VBA

Getting the Last Row in Excel: The Most Common Mistake! Speed Tip

Excel VBA Basics #8 - Find the LAST ROW or COLUMN dynamically and clearing out your last report

Get the First Column instead of the Last Column in Excel VBA

Fantastic Developer Tools:

[mariotaz]

Incredibly helpful thanks. I decided to change what Excel wants but going from the bottom up, the to look for the first empty row since I couldn't be bothered to figure it out properly. It works but at least I know what the problem is.

This is a more refined version. Thanks.

[longlegs]

Wow, can't believe that was it! Cheers mate, life saver

[Dopeboyz]

What if it has a syntax but you just wanna copy and paste the formula not both. Is there a way around it?

[DAC_AMD]

Hello!
Can you please tell me what formula to use for reading values (numbers) from the last 10 rows in a column? Periodically is added manually one row in the same column, so the formula would read each time the last 10 rows.
Thank you.

[zarac]

hello, thankyou for your videos- this isn't VBA-related, but say if I have column A filled with 50 populated rows--- row 1 to 50, and column B as only the first row populated with a value for example. Say if I would want to fill column B with this value for the length of column A for 50 rows- the same rows 1-50 but in column B. Without dragging and dropping or using the mouse, once i copy column B cell 1, what is the keyboard shortcut to highlight all of col A, and move the length of the column A across to column B and then paste to rows 1-50 of column B?