if between two numbers

**mattmac** · 01-20-2011, 05:21 AM

Hi Guys,
Bit stuck on something. Basically I've got a sheet with 3 columns ....

a - the name of a zone ... b and c are two numbers. there are 22 rows in this sheet (say sheet1)

I have another sheet (sheet2) with an unknown number of rows (will change). one of the columns (say F) has a number in it. If this number is between columns B and C in sheet1 then i want sheet2 column D to = sheet1 column a

quite complicated to explain sorry! anyway here's the code i've done but i get object required error at the "Set CheckCells = Sheet.CMDB.UsedRange" line

Please Login or Register  to view this content.

**Armando Montes** · 01-20-2011, 06:14 AM

See if this helps:
http://www.mrexcel.com/forum/showthr...aracter+number

Please Login or Register  to view this content.

**mattmac** · 01-20-2011, 08:17 AM

Ok thanks for that... i've changed my code.

Getting an overflow at INCR = INCR + 1

Please Login or Register  to view this content.

**DonkeyOte** · 01-20-2011, 08:52 AM

I've not reviewed the code but change INCR to Long (from Integer).

Row numbers can exceed Integer's upper bounday (32767)

**mattmac** · 01-20-2011, 10:45 AM

Thanks, changed that and I'm no longer getting an overflow.

Code still isn't doing what I want it to though, infact it's not doing anything

**mattmac** · 01-20-2011, 12:00 PM

Updated code but it's still not working

Basically it's just copying cells 1 to 22 from the CMDB sheet and pasting them in the SDC_PROC sheet in D2 - D23. Not sure what I've done wrong

Please Login or Register  to view this content.

if between two numbers

LinkBack

Thread Tools

Rate This Thread

Display

if between two numbers

Re: if between two numbers

Re: if between two numbers

Re: if between two numbers

Re: if between two numbers

Re: if between two numbers

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions