How to pass cell references to a sub routine?

[RustyNail]

Hello folks,

I have this function:

Please Login or Register  to view this content.

Instead of writing the same thing three times I would like to write a sub routine and pass the cell names and go from there.

How do we pass the cell names ... for example if I want to pass the cell name D7 and then manipulate its value in the sub routine from the cell's name passed in ??

Thanks

[xlnitwit]

Perhaps thus

Please Login or Register  to view this content.

[RustyNail]

hi xlnitwit ,

Ok.... although your example works, how does it know to unmerge B6 to B10?????



ooooopppppssss ok it depends with what area I merged it with... then it unmerges the cells ... ok got it!!1

Thanks a bunch

R

[RustyNail]

Dear xlnitwit !!!

If we want to merge the range ????

Below I tried to remerge the same cells but no luck :-(


I have tried this.... but this gives me error 400 ????

Please Login or Register  to view this content.

Thanks for your help

[xlnitwit]

There is no mergearea if they are not already merged, therefore

Please Login or Register  to view this content.

[RustyNail]

Hi xlnitwit,

Now I have a problem..... It seems like we are working with objects that contain cells packed into a range that we are passing into the functions.
Which is great stuff.

But now, in the code sample below, before I merge the cells, I need to clear them. I have done so in the clearCells() function below.

In the clearCells() function, we are passing the rg range object, and I use the rg.Clearcontents method to clear a series of cells, only this time "horizontally". For example from cells "B6 to D6".

So for example, from within the clearCells() function, the first function call (see below), will clear the contents of cells B6 to D6, BUT before I do this I need to check if
cell A6 contains an "X", if it doesn't I go ahead and clear the Contents, if it does contain an "X" then I leave the contents there.

The next clearCells() function call will clear the contents of cells B7 to D7, BUT before I do this I need to check if
cell A7 contains an "X", if it doesn't I go ahead and clear the Contents, if it does contain an "X" then I leave the contents there.

and so .... for the rest of the cells in range...

The problem I have is, in clearCells() function, before I clear the contents, I somehow need to extract the first cell number and subtract 1 column to the left in order to check if it contains the "X"!!

And I unfortunately find this a pretty advanced maneuver for me. Should you have a solution, can you please let me know!

I am so sorry for all the questions, I'm not fluent in VBA, more of a C programmer!
Thanks so much for your help

Here's the code:

Please Login or Register  to view this content.

[xlnitwit]

The simplest option is to pass the other cell as another argument

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[RustyNail]

thanks so much xlnitwit

everything works

r

[xlnitwit]

You're welcome. Please remember to mark the thread solved.

[RustyNail]

You're welcome. Please remember to mark the thread solved.

Ok can I do this from my phone or do I have to be on my desktop?

I see no soulevés button on my phone ..... Il check Monday

Thanks

[xlnitwit]

Is there a Thread Tools dropdown at the top of the page?