Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Data from Selected Cells
..... gives me this error
Object variable or With block variable not set "Frank Kabel" wrote in message ... Hi msgbox activecell.value -- Regards Frank Kabel Frankfurt, Germany Ben Crinion wrote: 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Data from Selected Cells
Hi
could you post the code you have used. -- Regards Frank Kabel Frankfurt, Germany "Ben Crinion" schrieb im Newsbeitrag ... .... gives me this error Object variable or With block variable not set "Frank Kabel" wrote in message ... Hi msgbox activecell.value -- Regards Frank Kabel Frankfurt, Germany Ben Crinion wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Data from Selected Cells
Any clues from the code i posted?
"Frank Kabel" wrote in message ... Hi could you post the code you have used. -- Regards Frank Kabel Frankfurt, Germany "Ben Crinion" schrieb im Newsbeitrag ... .... gives me this error Object variable or With block variable not set "Frank Kabel" wrote in message ... Hi msgbox activecell.value -- Regards Frank Kabel Frankfurt, Germany Ben Crinion wrote: 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) | |||
Get Data from Selected Cells | Excel Programming | |||
Retrieving data with SQL and ODBC selected by key values in cells | Excel Programming |