In range find this and do that

[sdez]

I am new to VBA, have did a lot of research....learning, need help

In a nut shell what I am looking to do is...

Have a range of cell with column headings as weeks In the range of cells I want to look for a number, say 1 if it finds a 1 then look at a column in said row for a variable, 2 or 4 whatever Now I want to put a triangle (can be copy and paste a cell) in the cell that has the "1" in it then skip over the number of week variable and add another triangle and keep doing this until the end of the range. Then skip down to the next row and do the same, until the end of the range.

Thanks

I got it to add triangles where the "1"s are but I get an error

I got this so far...

Please Login or Register  to view this content.

I don't want a counter for the second do, I want it to repeat til the end of my range, then drop down a line.
And I get an error when running this. "Object variable or With block variable not set"