In case the cell you need data from is not the active cell
use something like the following:

myvariable = worksheets("Sheet1").range("A1").value

or

myvariable = worksheets("Sheet1").cells(cRow, cCol)

where cRow and cCol are integer variables you set
dynamically depending on your need.

Hope that helps!

Kevin
-----Original Message-----
Hi

I have added a button onto a toolbar and now i want to be
able to get the
data from the selected cells when the button is clicked.

I cant work out how to do this and any pointers in the
right direction would
be greatly recieved.

Im using VB6 to create an AddIn not VBA.

Thanks
Ben Crinion


.