Checking Offset Assumptions

**ashleys.nl** · 09-13-2011, 10:32 AM

Hey Everyone,

I'm trying to create a check in my Excel Macro to check if my assumptions are correct. For example in a given worksheet I want to find the row labeled "Mouse/Day". Once I've found this row I assume the column "Cat" is one column to the right. But what if it wasn't? what if the columns had been input in a wrong order. Instead of the cat column being at an offset of ( 0, 1) the dog column was there instead. Is there a creative way to check ?

Thanks for your help everyone! You've all been great these past weeks.

Please Login or Register  to view this content.

**ChrisOswald** · 09-13-2011, 03:56 PM

Instead of using .offset with the Mouse/day column, why not just find the column number that "Cat" is in and use that directly? Assuming, of course, that you won't have problems with the word "cat" coming up multiple times in the spreadsheet, in which case you'll want to restrict the search range from .cells to something smaller.

Please Login or Register  to view this content.

**ashleys.nl** · 09-14-2011, 07:38 AM

Ahhh okay, I can certainly use something like this... I didn't know the .Column and .Row funtions existed... I'll have a go at this code later today... but it looks great! Thanks for the help

**ashleys.nl** · 09-14-2011, 10:04 AM

Thanks Chris!

I've taken what you had suggested and added a way to indentify the row as well. but it works great! this is the final code I've created... in case anyone else comes accross this problem

Thanks again Chris

Please Login or Register  to view this content.

Checking Offset Assumptions

LinkBack

Thread Tools

Rate This Thread

Display

Checking Offset Assumptions

Re: Checking Offset Assumptions

Re: Checking Offset Assumptions

Re: Checking Offset Assumptions

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions