| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
some functions doesnt work in macro?
hi can any one plz tell me that why functions like Find, Search, Concatenate dosent work in macro? do i need to add any reference? plz tell me thks in advance -- ExcelPower ------------------------------------------------------------------------ ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964 View this thread: http://www.excelforum.com/showthread...hreadid=514121 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
some functions doesnt work in macro?
ActiveCell.Formula = "=concatenate(a2,a4, a3)" i forgot to use "" sorry thks -- ExcelPower ------------------------------------------------------------------------ ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964 View this thread: http://www.excelforum.com/showthread...hreadid=514121 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
some functions doesnt work in macro?
FIND works o.k. on a range:
Sub Macro2() Cells.Find(What:="a").Activate End Sub Concatenate may not be available. Use: Cells(2, 2).Value = Cells(1, 1).Value & Cells(2, 1).Value Not all worksheet functions are directly available in VBA. -- Gary''s Student "ExcelPower" wrote: hi can any one plz tell me that why functions like Find, Search, Concatenate dosent work in macro? do i need to add any reference? plz tell me thks in advance -- ExcelPower ------------------------------------------------------------------------ ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964 View this thread: http://www.excelforum.com/showthread...hreadid=514121 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
some functions doesnt work in macro?
many functions have VBA equivalents. However, precede sheet functions with
WorksheetFunction. note that some functions, eg VLookup will raise an error if the value being looked for doesn't exist in the table being searched ... so you need to trap these properly. HELP is quite good with examples for the FIND method "ExcelPower" wrote: hi can any one plz tell me that why functions like Find, Search, Concatenate dosent work in macro? do i need to add any reference? plz tell me thks in advance -- ExcelPower ------------------------------------------------------------------------ ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964 View this thread: http://www.excelforum.com/showthread...hreadid=514121 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro that opens file named in cell doesnt work | Excel Worksheet Functions | |||
| My first macro - doesnt work - function not recognised | Excel Worksheet Functions | |||
| Please help : Macro doesnt work on other PCs | Excel Programming | |||
| Assign Macro to button in Excel doesnt work Any ideas? | Excel Discussion (Misc queries) | |||
| macro code doesnt work in command button | Excel Programming | |||
![ExcelPower[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
