Return Specific values in msgbox avoiding blank cells

[yashagarwal]

Im trying to return specific values in a message box using Excel VBA. Please have a look at my data in the attached file.
This data is first selected, then the macro is run.
The macro should return a Msgbox containing values in this order:
8mm- 13.05,9.34,0.08, 10mm-3.19,6.005, 12mm-2.53,6.67, 16mm-17.34, 20mm-0.97, 25mm-8.

Ive written a code by myself, which only return the values present in the first row.
Kindly help me out here.

Please Login or Register  to view this content.

[bakerman2]

Please attach file instead of image.

[yashagarwal]

Please attach file instead of image.

Ive attached the excel sheet as well :D

[mike7952]

Heres one way

Please Login or Register  to view this content.

[jindon]

Try this

Please Login or Register  to view this content.

[yashagarwal]

Try this

Please Login or Register  to view this content.

Works perfectly,
Can we define the entire result that comes in the MSGBOX as one Value say "A"
so that if i say MSGBOX A, i will get the result?

[jindon]

Sorry, but I don't understand what you are asking.

[yashagarwal]

Sorry, but I don't understand what you are asking.

I mean to say that "IIf(Len(msg), Mid$(msg, 3), "No data")" can be represented as one letter. Like Setting "IIf(Len(msg), Mid$(msg, 3), "No data")"=A. And i can see the result in the msgbox by entering the code MSGBOX A

[jindon]

And i can see the result in the msgbox by entering the code MSGBOX A

Where are you entering to?

[yashagarwal]

Where are you entering to?

Ive a code by which im sending the result as an email. Need the text to come in the emails body.
I figured it out.

The thing is that, the code is static to only this data. Since this was a sample data its working. In my original workbook the same table maybe located elsewhere. The original workbook has 100s of such tables. My aim is to select the specific table i want with the mouse pointer and then run the macro on that table to extract these specific values. How can we make this code dynamic to run on any selected table/range?

[jindon]

You mean something like this?

Please Login or Register  to view this content.

[yashagarwal]

You mean something like this?

Please Login or Register  to view this content.

yes, something like this.

But how can we make this code dynamic, In my original workbook the same table maybe located elsewhere. The original workbook has 100s of such tables. My aim is to select the specific table i want with the mouse pointer and then run the macro on that table to extract these specific values. How can we make this code dynamic to run on any selected table/range?

[jindon]

Then just change to

Please Login or Register  to view this content.

[yashagarwal]

Then just change to

Please Login or Register  to view this content.

please see the image attached below:
Untitled.jpg

when the code is run on my original sheet, it gives this as result. But when i copy the same data to a new workbook and run the code there, it give the proper result. How?

[jindon]

Can not replicate the issue.

Upload your workbook.

And you should not full quote of my post unless it is really needed.
The forum doesn't ike it.

[jindon]

You probably have same header just below the data area.
change to

Please Login or Register  to view this content.