ByRef doesn't work? (1 Viewer)

[smbrr]

Hello everyone.

Technically this is on Excel VBA since I open Excel from Access and work with it, but I don't think it matters since the problem here is clearly the passing into my function by ref.

I don't get my issue at all, and I'm even pretty sure it worked just fine until yesterday and I literally didn't touch anything.

Here's my function:

Public Function MaJBFE(ByRef slctn As Range)

Here's how I call the function:

ElseIf Selection.Rows.Count > 1 Then
            MaJBFE Selection

The problem is that once in the function, my "slctn" object is "nothing".

I tried all of the following and more:

Dim rng as Range
Set rng = Selection
MaJBFE rng

Call MaJBFE(Selection)

MaJBFE (Selection)

The selection never passes into the function. What is going on here?

Thanks.

 

[JHB]

Is the below code running in MS-Access?
If yes then I think you've to set the reference to Excel, then Range, Selection etc. is unknown for MS-Access.

 

[AOB]

Can you confirm that Selection (or the range variable that you set to the selected range) is present and correct before you call the function? In other words, if you debug and watch Selection.Address (or rng.Address) at the point just before you call the MaJBFE function, does it hold the appropriate address? Or is it Nothing there as well?

 

[smbrr]

Well, I seem to have wasted everyone's time and especially my own.

I made a typo within my function and tried to access "sltcn" instead of "slctn"... the selection was passing through since the start.

Sorry guys.

 

[AOB]

D'oh! (Are you using Option Explicit at the top of your code??...)

 

[smbrr]

D'oh! (Are you using Option Explicit at the top of your code??...)

No but I know I should! :banghead: