Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting UDF to run against the sheet it's been entered on...
I've got a problem with a UDF that I've written where it's running against
the active sheet, rather than the sheet that it's been entered on. Is there anyway to limit the function so that it runs against the sheet it was entered on rather than running against the active sheet? I've tried looking around for this and have discovered the following which don't seem to work...unless I'm using them wrong :-) Application.Caller Application.ThisCell.Worksheet Any ideas? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting UDF to run against the sheet it's been entered on...
Can you post up your UDF code?
George wrote: I've got a problem with a UDF that I've written where it's running against the active sheet, rather than the sheet that it's been entered on. Is there anyway to limit the function so that it runs against the sheet it was entered on rather than running against the active sheet? I've tried looking around for this and have discovered the following which don't seem to work...unless I'm using them wrong :-) Application.Caller Application.ThisCell.Worksheet Any ideas? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting UDF to run against the sheet it's been entered on...
So close -- try something along these lines:
Function ShowIt() Application.Volatile ShowIt = Sheets(Application.Caller.Worksheet.Name).Range("A 1") End Function On Oct 10, 9:29 am, George wrote: I've got a problem with a UDF that I've written where it's running against the active sheet, rather than the sheet that it's been entered on. Is there anyway to limit the function so that it runs against the sheet it was entered on rather than running against the active sheet? I've tried looking around for this and have discovered the following which don't seem to work...unless I'm using them wrong :-) Application.Caller Application.ThisCell.Worksheet Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expand sheet as information is entered | New Users to Excel | |||
data entered in each coloumns of one sheet to be extracted with r. | Excel Discussion (Misc queries) | |||
Updating VB for info entered in a sheet | Excel Programming | |||
Excel: have add'l rows entered in sheet 1 always show up in sheet | Excel Worksheet Functions | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) |