Compile error (Constant expression required) when using macro twice

**flunzy** · 04-01-2014, 10:29 AM

Hi guys,

I'm trying to use the macro below (twice but with different variables) but everytime I get the error "Compile error: Constant expression required". Does anyone know why?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Kaper** · 04-01-2014, 10:49 AM

At a first glance - try changing [E1] (and N1 in next one) to

Please Login or Register  to view this content.

you do this within scope of With Sheets("Totaal") while form: [address] refers to active sheet.

**flunzy** · 04-02-2014, 02:38 AM

Dear Kaper,

I've tried it but unfortunatly I get the error "type doesn't match". Any other ideas?

**Kaper** · 04-02-2014, 10:35 AM

Hi,
I tried several times, but dont get the error.
So probably attachment would make further studying this case easier.

Compile error (Constant expression required) when using macro twice

LinkBack

Thread Tools

Rate This Thread

Display

Compile error (Constant expression required) when using macro twice

Re: Compile error (Constant expression required) when using macro twice

Re: Compile error (Constant expression required) when using macro twice

Re: Compile error (Constant expression required) when using macro twice

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Compile Error: Expected: expression

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

[SOLVED] Compile Error: Expected Expression, Syntax Error

Compile error: Object required

creating a public constant by concatenating string......gives compile error

Bookmarks

Bookmarks

Posting Permissions