Looping Sum, If cell begins With

**jonn** · 06-06-2007, 11:48 AM

Hi,

my loop is not working and i can't figure out why?

Also how do i get the macro to find cells that begin with that number and do not equal it?

Thanks,

Please Login or Register  to view this content.

mpeplow · 06-06-2007, 03:24 PM

I don't know about your loop, how is it not working? What is it doing?

About this

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

**jonn** · 06-07-2007, 03:33 AM

hi what does that do?

**mikerickson** · 06-07-2007, 03:43 AM

Please Login or Register  to view this content.

**jonn** · 06-07-2007, 04:41 AM

Originally Posted by mikerickson

Please Login or Register  to view this content.

hi,

can you explain that formula to me

Thanks,

**mikerickson** · 06-07-2007, 05:30 AM

InStr is VB's version of search.

Please Login or Register  to view this content.

**jonn** · 06-07-2007, 05:35 AM

Cool Thanks,

It keeps Bringing up an 'Application -defined or object defined error on the: -

'If InStr(CStr(ws1.Cells(i, A)), "0124") = 1 Then'

line? any ideas

Please Login or Register  to view this content.

**mikerickson** · 06-07-2007, 09:13 AM

A isn't defined, which would cause an error.

Looping Sum, If cell begins With

LinkBack

Thread Tools

Rate This Thread

Display

Looping Sum, If cell begins With

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions