Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addin active sheet problem
I wrote a search form which works well as an Excel file, however, when
I converted it to an addin it throws up this error... Object variable or with block variable not set When I click on debug is highlights this part of the code Set shtSearch = ThisWorkbook.ActiveSheet Locate TextBox1.Text, shtSearch.Range("A:IV"), blnGotColor, lngColor I researched as much as I could on Newsgroups and see that an addin does not have active sheets but I could not find out how to fix the problem. Can someone help please? Many thanks Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addin active sheet problem
Are you actually wanting to search the addin workbook or another workbook.
It seems to me that ThisWorkbook should probably be replaced with ActiveWorkbook, -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... I wrote a search form which works well as an Excel file, however, when I converted it to an addin it throws up this error... Object variable or with block variable not set When I click on debug is highlights this part of the code Set shtSearch = ThisWorkbook.ActiveSheet Locate TextBox1.Text, shtSearch.Range("A:IV"), blnGotColor, lngColor I researched as much as I could on Newsgroups and see that an addin does not have active sheets but I could not find out how to fix the problem. Can someone help please? Many thanks Tony |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addin active sheet problem
Good man Bob - worked a treat!
Cheers Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XLA - Addin Active | Excel Discussion (Misc queries) | |||
Excel addin problem | Excel Programming | |||
Select all pivot table areas/ranges on the active sheet problem | Excel Programming | |||
addin problem: sheet mismatch by function parameters | Excel Programming | |||
Addin problem | Excel Programming |