Select cells/ranges by using Visual Basic procedures in Excel

[rizmomin]

Hello:

I have data in column D.
I need a VB Code to select cell from D2:D where D2 is the first cell and D is the last active cell on column D.

For Example, if i have data from D2:D10 then select D2:D10...

Thanks

Riz

[jolivanes]

Is this what you mean?

Please Login or Register  to view this content.

[tigeravatar]

Riz,

Here's the most common way to do so:

Please Login or Register  to view this content.

[smde]

The answers above are accurate -
This is how I use that function to make all sorts of plots for test results - column A - is always the observation number (1---- n)
the other columns are specific values / results (numeric)
you can plot several different series - just by adding three new additional series : as indicated in the code @
' Add series to plot
Note: you will need to determine the last cell for each column that you intend to plot.

Please Login or Register  to view this content.

[rizmomin]

Hello:

All guys are great...
The solution I will use is from Jolivanes.

Thanks a lot guys..

Riz