Set Activecell

[odsmith]

I'm trying to figure out how to stop typing "activecell" in my code.

I would like to be able to set a variable like "AC" for activecell in memory for every excel file I open. I always have an open workbook in the background hidden with ADHoc code. I would like to add a statement that would abbreviate activecell to "AC" or activecell.offset to ACO.

Any help would be appreciated.

Thanks,
Oak

 

[ranman256]

make a function that becomes the Activecell, then call it. Usage: MsgBox AC.Value

public function AC() as range
set AC = activecell
end function

 

[odsmith]

Thank you.....That worked when I placed the code in the workbook that was current and I was using. Is there a way I can make that work when the code is placed in a hidden workbook, and then execute it in the active workbook?