Selecting multiple cells

[neo87]

Hi,

I am new to Excel programming.

I wanted to know if there is a way for detecting the multiple cells which i have selected in my worksheet using a macro?

The cells can be in different rows and columns and may or may not be adjacent to each other.

I used the Selected method but it just gives the first selected cell and not the rest of them.

Someone might have posted a solution earlier. If so can anyone point me to it or if not can someone help me.

Thanks,

[stnkynts]

Hello neo87,

Could you be more specific on your request? Maybe supply the code that you already have. Do you have a specific example you could give us so we understand better?

From first glance it sounds like you are trying to select multiple cells. While not the best example this is one way.

Please Login or Register  to view this content.

[neo87]

I meant something like

I manually select the cells 1, 3 and 5 in Column1 and cells 2,4,6 in Column 2 in the excel sheet

In the Macro i just created a MsgBox(Selection).

What it does is it just gives me the value in the first cell which is Cell(1,1) and not the rest of them. I want them all as I want to create a string form the values in them and query the DB using that String.

I don't know if I am clear enough. If I am not please let me know

Thanks

[stnkynts]

While the message box is only showing you the first cells character the selection is still complete. If you wanted to display all the cells values in a message box you would need to do something like this:

Please Login or Register  to view this content.

I am still not sure what you are trying to do. Are you wanting to search a database for each value that you select? If so then there might be a better way to do it.

[mikerickson]

"Detect the cells"? yes, Selection will do that.

Please Login or Register  to view this content.

But with a multi-cell range (continuous or otherwise) getting the values of those cells into a single string would require a loop.