Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Data from Selected Cells
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find/replace data in selected cells only | Excel Worksheet Functions | |||
Put data in range of selected cells | Excel Discussion (Misc queries) | |||
How do I clear data in selected cells automatically | Excel Discussion (Misc queries) | |||
Selected cells grow and data entry impossible EXT is dissabled | Excel Discussion (Misc queries) | |||
Retrieving data with SQL and ODBC selected by key values in cells | Excel Programming |