looping formulas heeellllpppp!!!!!!!

**'''your code here** · 03-07-2010, 09:36 AM

hi all,

so heres my problem,

im trying to loop some code using vba.
i have a sheet running which displays my sales orders and i need to know by clicking a button which sales orders are behind schedule
in cell a2 i have the formula = today()
the dates for my sales orders are in cells h7 : h238
and i need the results to be displayed in cells L7 : L238
this is what i need to happen, if h7 < a2 + 3 then display "dates behind schedule" in L7
if h8 < a2 + 3 then display "dates behind schedule" in L8
and so on untill row 238

ok so here is what i have so far: sub blah blah ()
if h7 < a2+3 then
range ("L7") = dates behind schedule
endif
end sub

this works but will only apply the results to cell L7
i also dont want the formula in the cells just the results

ps i have basic experience with excel so i know how to insert and apply code to a button.

please help this has been driving me mad for weeks now

**MickG** · 03-07-2010, 09:47 AM

Hi, Try this:-

Please Login or Register  to view this content.

Regards Mick

**'''your code here** · 03-07-2010, 09:55 AM

hi mick,
thanks for your reply all seems to work but i need the result to be in cell L7, at the moment it displays in i7

thanks pete

**martindwilson** · 03-07-2010, 10:05 AM

cant see mick about but
change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**'''your code here** · 03-07-2010, 10:08 AM

worked like a charm thanks for your help

**MickG** · 03-07-2010, 10:27 AM

Hi, If you;ve not changes both "If" & "Else" , alter as below.
The idea is that each time you run the code the old data is removed.

Please Login or Register  to view this content.

Regards Mick

**'''your code here** · 03-07-2010, 10:32 AM

excellent its perfect thanks again

**royUK** · 03-07-2010, 03:34 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.