Passing cell value to sub routine perform action on relative cells

**glinch** · 06-10-2010, 08:02 AM

Hi there,

I'm fairly a novice at excel vba but im trying to understand how to perform the following.

I would like to run a sub routine that would perform an action on the relative cells for the cell that is passed to the sub, such as:

Please Login or Register  to view this content.

Apologies for the basic errors here, but would anyone have any advice as to how to perform such action or a recommendation for a good tutorial covering this.

Any help or advice greatly appreciated.

Cheers

Noel

**DonkeyOte** · 06-10-2010, 08:07 AM

You're pretty much there though you would use a Range variable

Please Login or Register  to view this content.

You would in turn invoke the above passing the appropriate range reference

Please Login or Register  to view this content.

**Domski** · 06-10-2010, 08:08 AM

Maybe something like:

Please Login or Register  to view this content.

You would then use it on your worksheet like =TimesTwo(A1) and it will return the value in A1 multiplied by 2.

Dom

**snb** · 06-10-2010, 08:10 AM

Please Login or Register  to view this content.

**DonkeyOte** · 06-10-2010, 08:12 AM

snb, not very practical nor very straightforward for a beginner.

Why the use of Split over a basic Array ?

**snb** · 06-10-2010, 08:18 AM

@DonkeyOte
Did I comment on your suggestions ? My suggestions are meant for the TS, not for you. Let the TS decide what to use.
Passing variables to functions or subs isn't for beginners.

**DonkeyOte** · 06-10-2010, 08:22 AM

You didn't answer my question as to why you used Split ?

I was curious to know if there was some solid reasoning behind it.

Regards passing variables - I based my response on the title of the thread.

**Domski** · 06-10-2010, 08:37 AM

Originally Posted by snb

@DonkeyOte
Did I comment on your suggestions ? My suggestions are meant for the TS, not for you. Let the TS decide what to use.
Passing variables to functions or subs isn't for beginners.

I'd like to think everyone would be glad to learn if there's a better way to do things. Nobody ever taught me programming so it's only by looking at other people's suggestions that I'm picking it up. If folk can't ask you for an explanation it's not much point making a suggestion.

Just my opinion.

Dom

**glinch** · 06-10-2010, 08:56 AM

Thanks everybody greatly appreciate all the advice, and alternative methods, great way of learning as Dom said. There is nothing wrong with a little discussion either

Really big help, cheers

Noel