Anthony's VBA Forum

Try putting in Application.Volatile

In the function code.

Hope this helps.

How many rows of data are you trying to filter?
As far as I know Excel filter has a limit 1000 something

You can open the text file in excel. Just like you open the excel file.
You can even record opening the text file.

When you open the text file you should see a text import wizard in which you can ...

Did you try on error goto 0
This resets the original error handler.

You should be able to do it. But you will not able to get multiple people change macros though.
Alt T T H will let u share the workbook.

I hope this helps.

How about a quick pivot table?

To Copy a formula

You can use the Formula property of range object.

Something like

Range("A1").Formula=Range("A2").formula

will get A2s formula in A1

Or try recordin ...

You would need to write a code on the Workbook Open event.

Something like below...

Private Sub Workbook_Open()
Range("A65536").End(xlUp).Offset(1, 0).Value = Rnd()
End Sub

Yes,

There is a simpler way out.
May be you can simply try to record a macro and see what code you get.

Customise it a bit and you should be good to go.
Let me know if U need further help
...

Try doing the work you want the code to perform while recording the VBA code.

Looking at the VBA code (Alt + F11) you should have some idea to customize the code.

Some of the code snippets that ...

Are U using a Worksheet List Box? Or a Form list Box?

The solution will depend on this actually.

Try

Worksheetfunction.IsNumber

All the excel functions which are available in VBA are used with WorkSheetfunction. and the function...

Hope this helps

Hi Ajay,

Try readin a bit from http://www.ozgrid.com/Excel/DynamicRanges.htm

Hope this helps.

Regards
Ankur

Hi,

May be you can explain what we are trying to do. And I may not need to look at the sheet to understand.

I can not see any attachment link here. May be u can try some rapidshare or something ...

I think You may use a simple Countif function in Excel.