Anthony's VBA Forum Index Anthony's VBA Forum
Where the knowledge is shared
Menu
 Anthony's VBA Forum IndexHome Page
 Anthony's VBA Forum IndexForum Index
FAQFAQ
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesMessages
Log inLogin/Out

Quick Search

Advanced Search

Links
Consulting
Products

Who's Online
[ Administrator ]
[ Moderator ]


Search found 52 matches
Anthony's VBA Forum Index
Author Message
  Topic: Saving worksheet
mohan.ankur

Replies: 1
Views: 9965

PostForum: General Excel VBA   Posted: Fri Dec 19, 2008 3:21 pm   Subject: Saving worksheet
Try putting in Application.Volatile

In the function code.

Hope this helps.
  Topic: vba autofilter hide column
mohan.ankur

Replies: 1
Views: 12913

PostForum: General Excel VBA   Posted: Fri Dec 19, 2008 3:19 pm   Subject: vba autofilter hide column
How many rows of data are you trying to filter?
As far as I know Excel filter has a limit 1000 something
  Topic: extract and compare data of text files through excel
mohan.ankur

Replies: 1
Views: 11779

PostForum: General Excel VBA   Posted: Fri Dec 19, 2008 3:17 pm   Subject: extract and compare data of text files through excel
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 ...
  Topic: Nested Error Handling
mohan.ankur

Replies: 1
Views: 13254

PostForum: General Excel VBA   Posted: Fri Dec 19, 2008 3:14 pm   Subject: Nested Error Handling
Did you try on error goto 0
This resets the original error handler.
  Topic: Multiple users working on the same xlsm - file
mohan.ankur

Replies: 1
Views: 10798

PostForum: General Excel VBA   Posted: Fri Dec 19, 2008 3:12 pm   Subject: Hello
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.
  Topic: Finding the resp. max or min values in a list of categories
mohan.ankur

Replies: 2
Views: 13202

PostForum: General Excel VBA   Posted: Fri Dec 19, 2008 3:10 pm   Subject: Finding the resp. max or min values in a list of categories
How about a quick pivot table?
  Topic: copy a formula from one cell to anothe using any excel funct
mohan.ankur

Replies: 5
Views: 50332

PostForum: General Excel VBA   Posted: Mon Nov 17, 2008 3:00 pm   Subject: copy a formula from one cell to anothe using any excel funct
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 ...
  Topic: record number each time sheet is opened
mohan.ankur

Replies: 1
Views: 9976

PostForum: General Excel VBA   Posted: Mon Nov 17, 2008 2:58 pm   Subject: record number each time sheet is opened
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
  Topic: Lots 'o' Data!
mohan.ankur

Replies: 1
Views: 10030

PostForum: General Excel VBA   Posted: Mon Nov 17, 2008 2:55 pm   Subject: Lots 'o' Data!
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
...
  Topic: copying info from different sheets into a new sheet
mohan.ankur

Replies: 1
Views: 9877

PostForum: General Excel VBA   Posted: Mon Nov 17, 2008 2:53 pm   Subject: copying info from different sheets into a new sheet
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 ...
  Topic: Inserting checked items from ListBox into Excel
mohan.ankur

Replies: 2
Views: 12840

PostForum: General Excel VBA   Posted: Mon Nov 17, 2008 2:50 pm   Subject: Inserting checked items from ListBox into Excel
Are U using a Worksheet List Box? Or a Form list Box?

The solution will depend on this actually.
  Topic: Excell Function not defined ?
mohan.ankur

Replies: 2
Views: 13270

PostForum: General Excel VBA   Posted: Mon Nov 17, 2008 2:47 pm   Subject: Here is the answer
Try

Worksheetfunction.IsNumber

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

Hope this helps
  Topic: can i upload sample Excel file i need to ask my question
mohan.ankur

Replies: 3
Views: 15844

PostForum: General Excel VBA   Posted: Tue Aug 26, 2008 10:52 am   Subject: can i upload sample Excel file i need to ask my question
Hi Ajay,

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

Hope this helps.

Regards
Ankur
  Topic: can i upload sample Excel file i need to ask my question
mohan.ankur

Replies: 3
Views: 15844

PostForum: General Excel VBA   Posted: Sat Aug 23, 2008 1:40 pm   Subject: can i upload sample Excel file i need to ask my question
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 ...
  Topic: Template Worksheets
mohan.ankur

Replies: 1
Views: 10755

PostForum: General Excel VBA   Posted: Wed Aug 20, 2008 11:41 am   Subject: Template Worksheets
I think You may use a simple Countif function in Excel.
 
Page 1 of 4 Goto page 1, 2, 3, 4  Next
All times are GMT - 4 Hours
Jump to:  


Powered by phpBB © 2001, 2002 phpBB Group