vba loop help

[13lack13lade]

hi guys i wonder if you can help me, i have a loop going for some stuff however it works in activesheet so the sheet thats open however if i try to define the range to worksheet 3 which is where i want it to go all the time, it didnt work properly and started looping to the cells above instead of down, not sure what ive done, here is a snippit of the code if anyone can help me out. - I thought i defined it in Season_Formula however when i tried to run it in another worksheet and it ran over to that not to on the worksheet3 which is where im wanting it to go.

Please Login or Register  to view this content.

[wenqq3]

Hi 13lack13lade
Please wrap your code, using forum tool, so is readable

Edit: And please post a sample workbook as well. Thanks

[13lack13lade]

attached is workbook, basically i want to make sure that the loop created always pastes the content into sheet 3 (rates) so it doesnt matter what sheet the user is in when the script is run. I am also wanting to do the same loop on sheet4 that is on sheet3 however using the formulas for sheet4 with it creating lines for X amount of lines that are created for worksheet3.

Hope that makes sense? any help would be great, it is hard because i dont exactly know how to specify to work in a specific worksheet and with sheet4 how to use the count from sheet3 to creat that many amount of lines as per date bands in columns a&b. VBA isnt my strong suit, manipulating formulas however.. lol


PerPersonTemplate1.xlsm

[wenqq3]

I no sure what you asking.
1, you have problem of running Sub Season_Formula() at sheet 4?
2. Where is sheet 4?
3. What you want achieve in sheet 4? Can you manual do a before and after with some sample data?

[13lack13lade]

thanks for your help however i have found my solution, i simply copied the loop for worksheet 3 into worksheet 4 and changed the range formulas to suit my needs

[wenqq3]

Okie, that good