Thanks for tip, I may look into the code to see if it os better, however right now the code itself is not the issue, it is just that I would like to be able to call the function and store as a variable to the macro running. For example I would activate Sheet 2 in code, call function then pass variable to the macro being run to be the end of a range and make it a table. Then activate Sheet 3 and do the same, by calling function which would then pass the new last cell values to be used in the macro.