Offset Problem!

**watzmann** · 09-09-2009, 06:23 AM

Hi All ,

i need to know how to make offset for the cells to the row -3 in colum B

Please Login or Register  to view this content.

i have tried it like that but it doesn't work

Please Login or Register  to view this content.

could you help please to do that .

Thank You

**D_Rennie** · 09-09-2009, 06:29 AM

Please try

Please Login or Register  to view this content.

though it would realy depend on where the found cells are. Somethink like (-3,1) would only work if the found cells are in column A.

If that does not work. Post a workbook to see what can be done.

Hope this helps.

**watzmann** · 09-09-2009, 06:33 AM

it is too big to be loaded here .

the founded cell is C1

**DonkeyOte** · 09-09-2009, 07:01 AM

in which case

Please Login or Register  to view this content.

though of course if C1 is found cell then you can't move up 3 rows as there is no row -2 ... can you explain more thoroughly what it is you're trying to do ?

**watzmann** · 09-09-2009, 07:25 AM

simply i'm trying to find a word named "Total" in my sheet then to move to another cell and copy it .

the other i'm trying to reach is not in constant row but it's in constant column ,

the problem is the word i'm trying to find "Total" is located in a merged cells so it combines three columns "BCD" and when i want to move left with one step it goes to A and if to right one step it goes to E . , so what if i need t go C

i tried by unmerging the cell but still the problem

**DonkeyOte** · 09-09-2009, 07:29 AM

going back to D_Rennie's post - create a watered down version of your file that contains nothing other than the pieces of interest (ie keep small) and subsequently attach to a reply - we can then visualise what you're working with.

(and yes as a general rule of thumb avoid using Merged cells - particularly when it comes to horizontal ranges as you can achieve the same effect using "Centre Across Selection" option via Format)

**watzmann** · 09-09-2009, 07:43 AM

o.k , i have attached the whole excel sheet here with just the part of code i have problem with .

At sheet 1 you will find the cell i need to reach filled with Yellow
and the cell i'm using to start with name total :

the file is so big and the yellow cell is not constant , the only constant cell is " Total : "

**DonkeyOte** · 09-09-2009, 07:49 AM

OK so perhaps

Please Login or Register  to view this content.

**watzmann** · 09-09-2009, 08:04 AM

yes it works

i really apperciate this help , could you plese tell me how to reach this level of programming ability ? do you think i can reach this level by using video tutorials and practice as i don't have much time for books

i'm already a C# developer ,

**DonkeyOte** · 09-09-2009, 08:14 AM

I've been coding VBA for a fair few years on and off and there's still more I don't know than stuff I do... in short, practice, practice & more practice. And time of course. If you're proficient in C# I understand that the syntax is probably odd but the basic premise is hopefully not too alien so you will pick up quicker up than most.

I myself find it equally challenging when I have to do any non-VB based coding... like yesterday where I spent a day (an ENTIRE day!) trying to get the Google Maps API working with some server side web code... any code that utilises { ; ! tends to make me run a mile!