VBA Function to select different worksheet and refresh cell

[English_Bloke82]

Hi!

This is doing my head in now, lol.

I want to create a new function that will select a named worksheet and then select a specific cell and refresh the cell. The selection of the cell is dependant on criteria specified in the function brackets. For example I have a sheet called PC Distance and want to select cell 9, 5. So I created:

Please Login or Register  to view this content.

Now it's not working at all, I've tried to just use the ActiveWorkbook.Sheets part still nothing. Can someone help please

[allenz0rz]

Maybe with:

Please Login or Register  to view this content.

[AlphaFrog]

Are you using this as a custom worksheet function? If yes, worksheet functions cannot select or change other cells. They just return results to the cell they are located in.

[English_Bloke82]

Damn.... back to the drawing board then

Thanks for the reply