The macro will fill in the formulas in specified cells but how can I change it to include the whole range(Marked red) which will vary every month?
Example:
Please Login or Register to view this content.
The macro will fill in the formulas in specified cells but how can I change it to include the whole range(Marked red) which will vary every month?
Example:
Please Login or Register to view this content.
Last edited by Simone Fick; 07-26-2017 at 05:42 AM.
you shall somehow find which row your data ends.
It would be easier to give a good suggestion seeing your worksheet. but assuming (for your first problematic range) that you have continuous set of data in column C which you want to rank, you could use:
Please Login or Register to view this content.
Best Regards,
Kaper
I've changed some of the columns but it gives me an error" Type mismatch" on the last code line
But I've figured out the problem, the "*" in the last row should change to a "&", below is the working code, thanks for the help.Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Simone Fick; 07-26-2017 at 05:42 AM. Reason: Problem found and fixed
Sure, obvious typo. But as there was no attachment I've not tested it.
Glad you noticed and corrected. Thanks also for marking thread solved and for rep. point
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks