Compile Error: Constant Expression required problem

**el-paso** · 04-29-2020, 03:29 PM

Hi

I am trying to generate a random unique number with the following code. The MAX value will be dependant on the number of used rows in another worksheet so Iv tried to allow for this as you can see in the code below.
The problem I have is I'm getting a Compile Error: Constant Expression required.
Iv looked through Google but to be honest a lot of it is over my head.
Could someone help me out please?

Please Login or Register  to view this content.

**6StringJazzer** · 04-29-2020, 03:41 PM

When you declare a Const, its value must be determined at compile time. You are using LastRow which is a variable that is not determined until runtime. You must declare MAX as a variable instead of a Const.

Please Login or Register  to view this content.

**el-paso** · 04-29-2020, 03:48 PM

Cheers mate, thankyou very much

**6StringJazzer** · 04-29-2020, 04:41 PM

You're welcome!

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

Compile Error: Constant Expression required problem

LinkBack

Thread Tools

Rate This Thread

Display

Compile Error: Constant Expression required problem

Re: Compile Error: Constant Expression required problem

Re: Compile Error: Constant Expression required problem

Re: Compile Error: Constant Expression required problem

Thread Information

Users Browsing this Thread

Similar Threads

Compile Error: compile error constant expression required.

VBA - Enumeration Bugs "Constant Expression Required"

[SOLVED] "constant expression required" error given when setting up an array

[SOLVED] Compile Error Constant Expression Required

Compile Error: Expected expression

Compile error (Constant expression required) when using macro twice

[SOLVED] Compile error: Constant expression required error when merging two Codes

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions