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

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

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

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