Compile Error "Variable not defined" in VBA Excel

Question

I am new to VBA and trying to solve a problem in VBA Excel. I am using "Option Explicit". Every time I run code in VBA a compile error appears. It says "variable not defined". How a variable is defined in VBA?

You are getting that error because your variable is not declared and you have used Option Explicit at the top which forces you to declare your variables as a specific data type. You may want to read up about it in To ‘Err’ is Human. See Point #2. Also when working with Excel rows, it is better to declare them as Long rather than Integer else you may get Overflow error. — Siddharth Rout
– Siddharth Rout, Commented Jun 29, 2021 at 8:02

Gustav · Accepted Answer · 2021-06-29 08:18:56Z

0

This is very basic ...:

Dim i As Long

So, you need to study a primer "Beginning with VBA" or similar.

edited Jun 29, 2021 at 8:18

answered Jun 29, 2021 at 7:12

Gustav

56.5k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Siddharth Rout Over a year ago

It is advisable to use Long rather than Integer when you are working with rows in Excel. Dim i As Long

Collectives™ on Stack Overflow

Compile Error "Variable not defined" in VBA Excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related