Run a worksheet function from within a macro

Hi, I was wondering if there was a way to execute a worksheeet function and return it's value inside a macro. I want to use the INFO worksteet function to get the cell that is in the top-left corner of the visible screen.

Application.WorkSheetFunction. .....
' see your Vba help for a list of all the worksheetsfunctions and what they do

Is that the only way you can run them? I did try that property but it didn't have the INFO function listed.

Is that the only way you can run them? I did try that property but it didn't have the INFO function listed.

Hi there, yes the INFO function does not seem to be available.

You could use:

ActiveWindow.ScrollRow
ActiveWindow.ScrollColumn

this should give you the data you want.

Ahhhhh Thanks! Exactly what I need! :cool:

Okay, another little problem. I'm using the ActiveWindow.ScrollColumn/ScrollRow properties to position a box at the top left corner of the screen (it’s like a little menu). But I was wondering if there is a way to update its position when the user scrolls the scrollbars in the window. I know I could just use a loop to check and update the position but it's not very efficient and can cause excel to run slowly. Are there any better ways to do this?