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
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
ActiveCell.Formula = "=concatenate(a2,a4, a3)"
i forgot to use ""
sorry
thks
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
>
>
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks