Re: $$Excel-Macros$$ RE: PROTECTED SHEET

Hi Sunil, can u please advice how to unprotect my sheet with Add-In (password.xla) in excel 2003. Note: - i used blow mentioned procedure to unprotect my sheet who has one password 1) first i add this add-in 2) go to tools -> Protection -> unprotect sheet but still this sheet need password. if i

Re: $$Excel-Macros$$ Shell Object

Dear Harpreet I have msdn and dump for VBA Shell Object Programming,but it is too large to send on gmail. and i don want to upload in any of file share site. hope my 1'st programme u will like(Accessing any windows application from vba) Hope it will help Happy To Help :) Shyam On Mon, Mar 1, 2010

$$Excel-Macros$$ CodeWarrior begins on Mar 5, 06:00 pm IST. Certificates & Prizes worth 20,000 INR.

Problem Statements of CodeWarrior(http://itbhu.ac.in/codefest/ event.php?eid=4) Round 2 will be released on _Mar 5, 06:00 pm IST_. Registrations are open till Mar 14, 09:00 pm IST. So form your team now, if you have not participated in Round 1. Here is the problems break-up: * 2 Puzzles * 2 Al

Re: $$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

Thanks for your help Chris, The implementation is great. I would now look to convert this to a VBA function or subroutine. Thanks again for your help. Gaurav!! -- -- Some important links for excel users: 1. Fo

Re: $$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

Thanks for the help Shyam, I have a similar code that would work through this problem but then this does slow down a bit when i have around 1 line items to search through. I tried yesterday and using arrays to loop through the values does fasten the search considerably. I am refining the code

RE: $$Excel-Macros$$ Duplicate Values

Hi Sandeep, Sample workbook or copy of code please. Regards - Dave. > Date: Fri, 5 Mar 2010 02:06:22 +0530 > Subject: $$Excel-Macros$$ Duplicate Values > From: sand...@gmail.com > To: excel-macros@googlegroups.com > > Hi , > > I am trying to find the duplicate values from two different sheet

$$Excel-Macros$$ Duplicate Values

Hi , I am trying to find the duplicate values from two different sheets I have this code & works fine until 7900 rowsbut beyond that it doesnot indentify the duplicate records Sheets 1 has 10 records & sheets 2 has more than 3 reords is there any way to resolve this Thanks Sandeep -- ---

Re: $$Excel-Macros$$ Urgent Badly help needed Excel formula

Thanks, Its working fine. On Thu, Mar 4, 2010 at 8:41 PM, ashish koul wrote: > see the attachment r u looking for this but for that u need to create that > temp col in sheet1 > > On Thu, Mar 4, 2010 at 8:14 PM, Puttu wrote: > >> Hello Team, >> >> I need a formula or VB macro where as I have t

$$Excel-Macros$$ Problems with Add-ins

I get the following error in the Tools - references in the VBA editor What is this all about Harpreet -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

Re: $$Excel-Macros$$ Help for understanding VBA

Here is the link guys, http://groups.google.com/group/excel-macros/files cheers Harpreet Gujral On Mar 4, 12:45 am, rf1234 rf1234 wrote: > Dear Ankur > Please provide us link,so that we can perform better. > > happy to help > :) > shyam > > > > On Fri, Feb 26, 2010 at 11:27 AM, ankur wrote: >

Re: $$Excel-Macros$$ Shell Object

Shyam, Do you have the link to download MSDN VBA library Thanks Harpreet Gujral On Thu, Mar 4, 2010 at 5:57 PM, rf1234 rf1234 wrote: > Dear Harpreet > Try to download Microsoft Vba MSDN , It will provide best and > > Hygienic help. > > > > > Hope it Will Help. > Happy to help > :) > Shyam >

$$Excel-Macros$$ How to clear clipboard effectively?

Hi All, I am trying to disable copy/cut/paste functions on an Excel file. I implemented the following code: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Application.CutCopyMode = False End Sub It works fine when clipboard pane is not opened/displayed.

Re: $$Excel-Macros$$ Clever way to transpose required

As Dave said, 3000 rows x 60 columns = 180,000 records, if all cells had contents. Excel97 = 65,536 rows Excel 2007 = 1,048,576 rows So, if you're using Excel97 (2003) you better only have 1/3 of your cells filled! Paul From: Dave Bonallack To: "excel-macros@

RE: $$Excel-Macros$$ Clever way to transpose required

Hi, And just to add that you will need XL2007, since earlier versions don't have enough rows for your requirements (about 180,000) Regards - Dave. Date: Thu, 4 Mar 2010 06:16:37 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Clever way to transpose required To: excel-macro

Re: $$Excel-Macros$$ Attendance Tracker

Hi, I have checked and I do not have a readymade Attendance Tracker available with myself. Please try to build up the tracker by your own and let the "Group" know if you face any challenge(s). -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gm

Re: $$Excel-Macros$$ Attendance Tracker

FYI Regards chandrabhan Singh +919711535271 On Thu, Mar 4, 2010 at 5:43 PM, Prabhat kumar wrote: > Hello Group, > > any one have format for HR(Leave tracker format). > > Please send me. > > > > Regards > chandrabhan Singh > +919711535271 > > > > > On Mon, Mar 1, 2010 at 5:08 PM, Prabhat Kumar

$$Excel-Macros$$ Re: Create Goal Seek Function in Excel using VBA

Should be noted in the example above, cell F3 would be the cell were the =GoalSeek formula would be entered. Basically I want the function to assume the "by changing" cell is itself. On Mar 4, 9:23 am, excelCPA wrote: > I want to creat a function in Excel to use Goal Seek.  I am new to > creat

Re: $$Excel-Macros$$ Urgent Badly help needed Excel formula

see the attachment r u looking for this but for that u need to create that temp col in sheet1 On Thu, Mar 4, 2010 at 8:14 PM, Puttu wrote: > Hello Team, > > I need a formula or VB macro where as I have two different sheets with > Same data, when it match the result should show in other sheet nex

Re: $$Excel-Macros$$ Urgent Badly help needed Excel formula

Are you wanting to check to see if the "XX Name" field matches? or just to see if the XX # is present? If you're just checking for XX #, then, you can use the ISNA function with the VLOOKUP function (if vlookup doesn't find anything, it returns #N/A, ISNA tests to see if it is N/A. so, if your d

Re: $$Excel-Macros$$ Clever way to transpose required

Sub Macro1() Dim c As Integer Dim j As Long j = 0 Dim add, l As String Sheets("Sheet1").Select Range("XFD1").Select Selection.End(xlToLeft).Select add = ActiveCell.Address l = Mid(add, 2, (InStrRev(add, "$") - 2)) c = ActiveCell.Column Dim i, k, clm As Long Sheets("Sheet1").Select

$$Excel-Macros$$ Urgent Badly help needed Excel formula

Hello Team, I need a formula or VB macro where as I have two different sheets with Same data, when it match the result should show in other sheet next column as YES If one value match then the answere should be YES in different xl. example XX #XX Name 100 NORTH FAFA 500 NORTHFA 700

$$Excel-Macros$$ Create Goal Seek Function in Excel using VBA

I want to creat a function in Excel to use Goal Seek. I am new to creating fuctions, so I'll need some help on this one. Right now I have something that looks like this which does not work: Function GoalSeek(Target_Cell, Goal, Changing_Cell) As Number GoalSeek = Range(Traget_Cell).GoalSeek

Re: $$Excel-Macros$$ Clever way to transpose required

this should work: Option Explicit Sub Summarize()     Dim R, C, OutRow, OutSheet     Dim rMax, cMax     OutSheet = "Summary"     rMax = ActiveCell.SpecialCells(xlLastCell).Row     cMax = ActiveCell.SpecialCells(xlLastCell).Column     OutRow = 0     For R = 1 To rMax     For C = 1 To cMax  

Re: $$Excel-Macros$$ Clever way to transpose required

Please attach the sample workbook,so that we can help Properly Happy to Help :) Shyam On Thu, Mar 4, 2010 at 5:19 PM, Gerry wrote: > I have a large spreadsheet (say 3000 rows with 60 columns). Not all > cells are populated. Using that data I want to create a single column > capturing all o

Re: $$Excel-Macros$$ Shell Object

Dear Harpreet Try to download Microsoft Vba MSDN , It will provide best and Hygienic help. Hope it Will Help. Happy to help :) Shyam On Thu, Mar 4, 2010 at 5:47 PM, Harpreet Gujral wrote: > Its a good example for learning. > > Can you share any links or resource from where one can learn

Re: $$Excel-Macros$$ Shell Object

Its a good example for learning. Can you share any links or resource from where one can learn, how to use this 'shell object', in a more advanced way? Thanks Harpreet gujral Sent on my BlackBerry® from Vodafone Essar -Original Message- From: rf1234 rf1234 Date: Thu, 4 Mar 2010 11:37:

Re: $$Excel-Macros$$ Attendance Tracker

Hello Group, any one have format for HR(Leave tracker format). Please send me. Regards chandrabhan Singh +919711535271 On Mon, Mar 1, 2010 at 5:08 PM, Prabhat Kumar m...@ff@rPur/Delhi < cs4...@gmail.com> wrote: > Hi group< > > Please give me a format for Leave Tracker.its urgent need. > >

$$Excel-Macros$$ Please Clear it

Hi Dear all, i can't understand pivot table yet. so any one can send me example of it. -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

$$Excel-Macros$$ Clever way to transpose required

I have a large spreadsheet (say 3000 rows with 60 columns). Not all cells are populated. Using that data I want to create a single column capturing all of the data. The number of rows will equal the number of pieces of Data. Help. Thanks in Advance Gerry. -- --

Re: $$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

'VLOOKUP PROBLEM WITH MULTI ITEM OR VALUE 'WORK FINE FOR DISTINCT ID/VALUE Suppose we have client id along with purchase id,such as,if we have multiple of client id Then applying vlookup will not give required result. Client ID Purchase ID uw001 cd001 uw002 cd002 uw003 cd003 uw004 c

Re: $$Excel-Macros$$ RE: PROTECTED SHEET

Hi Chieu, Download password.xla from this link and folow the instrutions http://www.straxx.com/excel/password.html Regards, Sunil On Thu, Mar 4, 2010 at 10:08 AM, Vikas Chouhan wrote: > 2003 > > > On Wed, Mar 3, 2010 at 7:06 PM, ankur wrote: > >> which version of excel you are using? >> >> On

Re: $$Excel-Macros$$ Macro web query based on selection list

Dear all please download http://13342376753845663081-a-g.googlegroups.com/web/Open_Url_N_Search_Text_In_WebPage_AsWB.xls?gda=T2QW4F0AAACO89hzdz5JfSmEgWFmmILQKnbI4PlePF1OUsyPfjZ5DRfPpGLH7gU4kjeZ9rtcRsbXX6lqGa3v4JbZ0VEeiu4MCj585kqr0mDybXhWzWiC-OU2_747KStNgkfeVUa7Znk macro u can open your web page,w

Re: $$Excel-Macros$$ How to update excel in network by multiple users

Dear Guru 'use case i.e 'user 1 have password1 to change range1 'user 2 have password2 to change range2 'user 3 have password3 to change range3 Case Is = Password1 ProtectCell UnprotectCell MyRange1 CleanUp Case Is = Password2 ProtectCell UnprotectCell

Re: $$Excel-Macros$$ Data in variables

Thank you so much shyam for your immediate reply Cheers Harpreet Sent on my BlackBerry® from Vodafone Essar -Original Message- From: rf1234 rf1234 Date: Thu, 4 Mar 2010 11:24:33 To: Cc: Subject: Re: $$Excel-Macros$$ Data in variables Dear Harpreet I have attach the example showing th

Re: $$Excel-Macros$$ copy cell from source to target - not by advancefilter

Can y attached file for more clear ? Worawat Excelbeginner 2010/3/2 OSAVentures Calamba > Hi All, Basically i have a list of dates and numbers. > > What i want to do is to copy each numbers from source worksheet based on > the criteria date which is located

Re: $$Excel-Macros$$ How to Recover a Corroupt File of Word 2007

Dear Vikas It depends when you created using 2007 or 2003 and what was the format. If sender send the corrupt message,then how any 1 can decrypt without using key or say method. I hope it will help. Happy to Help :) Shyam On Wed, Mar 3, 2010 at 12:41 PM, vikas gupta wrote: > Hi Excel Gurus >

Re: $$Excel-Macros$$ Shell Object

Dear Harpreet You Can Communicate with. 1.windows registry 2.shell programme. using shell object in vba. '

Re: $$Excel-Macros$$ Data in variables

Dear Harpreet I have attach the example showing the proper usage of access public and private variable. ''Module1 '''

Re: $$Excel-Macros$$ Macro web query based on selection list

Hi Tom, May be below link will help you. It easy to get web query by existing menu. *http://www.exceluser.com/explore/webqueries_1.htm* Good luck Worawat Excelbeginner 2010/3/2 birkepab > I have a huge request. How to write a macro to retrieve data from a >

Re: $$Excel-Macros$$ RE: PROTECTED SHEET

2003 On Wed, Mar 3, 2010 at 7:06 PM, ankur wrote: > which version of excel you are using? > > On 03/03/2010, Chieu Ang wrote: > > Dear all, > > > > > > > > Anyone can help: How to unprotect the sheet( that has password)? > > > > > > > > Thanks > > > > > > > > Chieu Ang, Tan > > > > Finance Dep

Re: $$Excel-Macros$$ Shell Object

Hi shyam, Actually I am very new to excel VBA, I have seen some codes which use shell object in order to make use of some other application. Idea is to learn how to use shell object Harpreet gujral Sent on my BlackBerry® from Vodafone Essar -Original Message- From: rf1234 rf1234 Date:

$$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

Hello, I have tried this for sometime now but maybe i'm missing something. I'm trying to use VLOOKUP and the range that i'm searching in could have multiple occurences of the lookup value. I want to get all the instances of the lookup value. I have tried to use array formulas with VLOOKUP and MATC

Re: $$Excel-Macros$$ How to update excel in network by multiple users

Dear All, i am also using this type of excel sheet in network mode. but i am facing one problem like i have one excel sheet , i protected whole sheet except two columns. Can u please advice how can i give user lever editing right to work e.g. one user have only right to open file and second user

Re: $$Excel-Macros$$ student due list easily work

Hi dear, Can u sent excel sheet for same. Regards, Guru On Wed, Mar 3, 2010 at 12:23 PM, ram wrote: > I am working Fees section. I want Student due list easily taken with > excel format how any idea, fees details all in excel format only > > -- > > --