runtime error 16 - expression too complex

[markcruiser]

Hello All

i'm a newby here
but not really to excel

i just got a spreadsheet with VBA in it

it works fine on a XP with Excel 2003

i copied the file onto a USB and try to run it on Win7 with Office 2010, it gives me the runtime error 16

Please Login or Register  to view this content.

if there is more code needed, please let me know

[6StringJazzer]

What range does "guage_spec1" refer to? What data or formulas are in that range? Can you post your file? I have not seen failures in 2007 that work in 2003, and I am not familiar with this particular error, so this may need a little detective work.

Also I think you have misspelled "gauge".

[markcruiser]

i hope it worked with attaching the file

i'm using a Win 7 and Office 2010


the xl-sheet ran on a Win XP with Office 2003

[JosephP]

I'm not real sure why it fails but you can replace your select case with an if...elseif...end if and it works fine

[markcruiser]

I'm not real sure why it fails but you can replace your select case with an if...elseif...end if and it works fine

can you explain, please

[markcruiser]

I'm not real sure why it fails but you can replace your select case with an if...elseif...end if and it works fine

can you explain, please

[JosephP]

instead of

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

[markcruiser]

didn't work


i have no idea where the issue is
i'm playing around and back and forth
nothing

[JosephP]

it does work for me. what actual code did you use and what happened?

[MarvinP]

Is your named range of "gauge_spec1" a single dimension range? I don't think you can use a range that is a rectangular array/range.

[markcruiser]

see the file, i uploaded it

[MarvinP]

Look at http://www.ozgrid.com/VBA/select-case.htm and see that all the things after "CASE" are static. You have a variable in your code.

I'd go with JosephP and convert the case to If Then construct.

[markcruiser]

is there any change to give me hand how to wright this

i have a huge blockage right now and my head is with estimating
have two huge jobs to price out and i need this sheet to calculate the amount of sheetmetal for duct work

[JosephP]

corrected code

Please Login or Register  to view this content.

[markcruiser]

Thank you a thousand times JosephP

it works - of course
u saved my day

Happy Holidays

[JosephP]

you're welcome :-)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save