Refresh Macro

[crizzle]

problem is i have a macro that updates this page with info from the other sheets in the workbook.

Please Login or Register  to view this content.

how can i make it so this will only refresh the results from column a-j rows 1-31?

[Kenneth Hobson]

Please Login or Register  to view this content.

[crizzle]

sorry but i'm not sure where i need to insert this code into the existing code. could you show a more detailed example? sorry for the hastle and thanks for the help

[Kenneth Hobson]

I would guess that you want it inside your loop. Replace

Please Login or Register  to view this content.

is what I thought you wanted. If you want to keep that part, just add my code before or after that line.

Until you are sure of the results, be sure to test on a backup copy.

[crizzle]

i put your line in and deleted mine, and it will only refresh the summary sheet with info from A1:J31, but i need the info from the other sheets to update the summary but just a-j, but all the way down as info is put in the corresponding sheet. does that make any sense?