ByRef argument type missmatch error

[Marecki]

I am not very experienced in programming excel but using some books and examples from internet I can create what I need. Unfortunately I've met problem that I can't resolve. Below you can see the little portion of code (not mine taken from the book ) but for me it doesn't work. when I call function it popup with an error as in the topic.
Anyone can help me with this issue? It is part of the program I would like to update range in one of workbook.names used in selection.validation. Range will be taken diferent file without opening it.

-----------------------------------------------------------------

Please Login or Register  to view this content.

[Fluff13]

Your function is expecting a range object

Please Login or Register  to view this content.

But you are passing it a Variant

Please Login or Register  to view this content.

Change Variant to Range & you should be ok

[Marecki]

Hi Fluff13,

but the result of this function should be Variant, and the input should be Range, isn't it

As I do understand

Public Function LastInColumn(rngInput As Range) As Variant

so I put A1 (Range) as an argument when call function

and should get l as Variant

Am I wrong?

It complains about A1 as argument for the function

error.png

[bakerman2]

You have to pass a range to the function.

Please Login or Register  to view this content.

[Fluff13]

Oops, didn't read it properly
Please ignore post#2 it's complete rubbish.

[Marecki]

Now it popup error Expected: List separator or ) in edition mode

Attachment 651250

[bakerman2]

Works just fine.

[Marecki]

well yours works just fine I can see now where I have done mistake I didn't type quotation marks
Thanks for your help

[Pepe Le Mokko]

@Marecki
Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time

[bakerman2]

@ Marecki

Glad to help and thanks for feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.