Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using search function in macro
cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)"
What is wrong with this formula? How do I use this type of cell reference in a formula? |
#2
|
|||
|
|||
Look in vba help for using functions in macros or just use the FIND method
in vba instead. Also in HELP. -- Don Guillett SalesAid Software "tam" wrote in message ... cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)" What is wrong with this formula? How do I use this type of cell reference in a formula? |
#3
|
|||
|
|||
Try this:
Range("A1").Formula = "=Search("":"",Sheet2!cells(1,1),1)" "tam" wrote: cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)" What is wrong with this formula? How do I use this type of cell reference in a formula? |
#4
|
|||
|
|||
Thanks, David. However, when I used this formula, I got "#NAME?". It looks
like the formula doesn't like the type of cell reference Cells(1,1). If I changed cells(1,1) to A1, then everything worked fine. However, I have a long list and I need to do a loop later on. Regards, Minh "David Hepner" wrote: Try this: Range("A1").Formula = "=Search("":"",Sheet2!cells(1,1),1)" "tam" wrote: cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)" What is wrong with this formula? How do I use this type of cell reference in a formula? |
#5
|
|||
|
|||
This should work for you:
Worksheets("Sheet1").Cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)" "tam" wrote: Thanks, David. However, when I used this formula, I got "#NAME?". It looks like the formula doesn't like the type of cell reference Cells(1,1). If I changed cells(1,1) to A1, then everything worked fine. However, I have a long list and I need to do a loop later on. Regards, Minh "David Hepner" wrote: Try this: Range("A1").Formula = "=Search("":"",Sheet2!cells(1,1),1)" "tam" wrote: cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)" What is wrong with this formula? How do I use this type of cell reference in a formula? |
#6
|
|||
|
|||
Depending on what your loop looks like...
Maybe you could do it like this instead of the loop: Range("a1:A99").formula = "=Search("":"",Sheet2!A1,1)" tam wrote: Thanks, David. However, when I used this formula, I got "#NAME?". It looks like the formula doesn't like the type of cell reference Cells(1,1). If I changed cells(1,1) to A1, then everything worked fine. However, I have a long list and I need to do a loop later on. Regards, Minh "David Hepner" wrote: Try this: Range("A1").Formula = "=Search("":"",Sheet2!cells(1,1),1)" "tam" wrote: cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)" What is wrong with this formula? How do I use this type of cell reference in a formula? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
VBA Search function | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
SEARCH function #VALUE! result | Excel Worksheet Functions |