FinalRow in VBA not working

[BobTriesVBA]

Hello,
Can someone tell me what's going wrong?

Starting to learn VBA. I hope I can help you guys back in the future

 

[Joe4]

Welcome to the Board!

It looks like you have "Option Explicit" turned on (which is actually a GOOD thing). That means that you must declare all your variables before using them (which is a "best practice").

So right at the top of your code after your Sub line, just declare your variables like this:

Dim FinalRow as Long
Dim TotalRow as Long

 

[BobTriesVBA]

Welcome to the Board!

It looks like you have "Option Explicit" turned on (which is actually a GOOD thing). That means that you must declare all your variables before using them (which is a "best practice").

So right at the top of your code after your Sub line, just declare your variables like this:

Dim FinalRow as Long
Dim TotalRow as Long

Thanks hero! I will keep the "Option Explicit" turned on.
Have a nice day.

 

[Joe4]

Thanks hero! I will keep the "Option Explicit" turned on.
Have a nice day.

You are welcome!

Yes, it is really helpful with debugging. It helps you catch typos in your variables.
For example, if you had those variable declarations:

Dim FinalRow as Long
Dim TotalRow as Long

But then had a typo like:

TotlaRow = FinalRow + 1

it will tell you that the variable "TotlaRow" is not defined.

And it also helps to ensure that you don't place the wrong data type in a variable, i.e.
if you had something like this:

Sub MyTest()
    Dim n As Long
    n = "abc"
End Sub

you will get a Run-Time error 13, "type mismatch" when you try to run it, since you are trying to put text in a numeric field.

 

[BobTriesVBA]

You are welcome!

Yes, it is really helpful with debugging. It helps you catch typos in your variables.
For example, if you had those variable declarations:

Dim FinalRow as Long
Dim TotalRow as Long

But then had a typo like:

TotlaRow = FinalRow + 1

it will tell you that the variable "TotlaRow" is not defined.

And it also helps to ensure that you don't place the wrong data type in a variable, i.e.
if you had something like this:

Sub MyTest()
    Dim n As Long
    n = "abc"
End Sub

you will get a Run-Time error 13, "type mismatch" when you try to run it, since you are trying to put text in a numeric field.

Thanks for all the information. I got 26 chapters left on the 'Microsoft Excel VBA and Macros book'. I think there will be more questions to come in the future