$$Excel-Macros$$ Enable Selection to Unlocked Cells only

Hi All Not sending this tip in the "best tip for the week" format as this is not my original idea but nevertheless a useful tip In a protected worksheet, a user may want to navigate only to those cells which are unlocked. i.e., Navigation should not be allowed to those cells which have formula (f

$$Excel-Macros$$ Re: 40,000 Days Today

Hi Dave, Good Observation !!! I liked it !!! Best regards, Ayush Jain On Jul 7, 9:33 am, Dave wrote: > Excel's serial number for 7/6/09 is 40,000. > > Since Excel maintained consistency with Lotus 123 by treating the year > 1900 as a leap year when it wasn't, the actual 40,000th day is on > 7/

$$Excel-Macros$$ 40,000 Days Today

Excel's serial number for 7/6/09 is 40,000. Since Excel maintained consistency with Lotus 123 by treating the year 1900 as a leap year when it wasn't, the actual 40,000th day is on 7/7/09. --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ reading and closing a child page from excel

I have the following code: [code] Sub CommandButton1_Click() 'create a new window Dim web As String Dim AccountCol As Integer Account_Col = 5 Switch_Col = 7 web = Sheets("sheet3").Range("B1").Value DoBrowse1 web End Sub Sub DoBrowse1(url As String) Dim TargetFrame As String Set BTS =

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

Hello Mr.CA Narendra Ashara, Try this link very simple.. http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in.html *Calender **is available in all workBooks.* On Mon, Jul 6, 2009 at 9:59 PM, CA NARE

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

Now, if you want to use it with every workbook, it is slightly different. You'll have to create the userform in your personal.xls (or personal.xlsb) file. In a standard module of the personal.xls file, paste the macro : Sub OpenCalendar() frmCalendrier.Show End Sub Use the following macro to

$$Excel-Macros$$ Re:

In Excel, you can compare the cells in two ranges with an array formula. For instance, to see if all of the values in A1:A100 are identical to those in B1:B100, type this array formula: =SUM(IF(A1:A100=B1:B100,0,1)) Note: This is an array formula and it must be entered using Ctrl-Shift-Enter.

$$Excel-Macros$$ Re:

How to write a formula that returns the number of distinct entries in a range? First, let's clarify the question. We're hunting for a formula that, given the range that contains the values 100, 99, 98, 100, 98, 100, 98, would return 3. In other words, this range contains three different values,

$$Excel-Macros$$ Re:

One good use of Data Validation comes when there's a need to "link" two or more comboboxes, making them, dependant. For example, "I have a list of countries (USA, Australia, England), and a list of cities. How can I make than when the user selects USA in one cell, in the other one appear only c

$$Excel-Macros$$ ascii command in excel for ctrl + shift + end

hey guys does anyone know the command when u hit ctrl , shift and end on your keyboard thanks mog --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutoria

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

Hi. First create a userform and put a control calendar upon it. There are 3 macros in the userform module : At initialization : Private Sub UserForm_Initialize() If IsDate(ActiveCell.Value) Then Calendar1.Value = ActiveCell.Value Else Calendar1.Value = Date End If En

$$Excel-Macros$$ Re:

Name: Sastry B Tip: Using Data List How? - See attached file 2009/7/6 Ayush : > > Dear Members, > > Thanks for your great response in the Week 27 competition. It was > again great learning for the members of the group. > Let us begin week # 28 quiz with more spirit. Last Date of Submission > of

$$Excel-Macros$$ V look up error 1004

Attn Dave Daniel Please find the sample file and the requirement --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

$$Excel-Macros$$ Re: Excel Macro : Copy info from one range to another wsheet "IF"...

Thank you Nishant Jain I will reask the question in a more simple way because the code does nothing to my document and I have no idea why. So here is what I want to do: I have 2 sheets : Sheet1 (where the data come from) Sheet2 (where I want the data to be copied) In Sheet1, I have 4 columns A

$$Excel-Macros$$ To make the color of the cell white

Dear All, I have written a code which will copy cell contents from one cell to another. Along with the cell contents, also formatting of the cell is copied. I am not able to code and keep the formatting as I want. For eg. Cell A1 has color yellow. I copied cell A1 to B1. The color also gets copi

$$Excel-Macros$$ Re: Parse through a data range

Jayell, This is good stuff, thanks. Although the spreadsheet shows a count I was actually looking to find which pair of numbers show the most often in a particular row or column. In the spreadsheet it shows if the number repeats in a column and if so how many times this is just for that particu

$$Excel-Macros$$ Re: Parse through a data range

Jayell, This is good stuff, thanks. Although the spreadsheet shows a count I was actually looking to find which pair of numbers show the most often in a particular row or column. In the spreadsheet it shows if the number repeats in a column and if so how many times this is just for that particul

$$Excel-Macros$$ Daniel -- calendar pop-up

HI Daniel, Excel file with date function attached by you is really nice. How do I make it available to every excel file i.e. I want to use it in all workbook. Kindly guide me. Thanks in advance. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: excel-mac

$$Excel-Macros$$ Best Excel Tip Award of Week # 27 goes to ****Aindril De (Andy)****

Hello Everyone, Please congratulate Aindril De (Andy) for winning the Best Excel Tip award of Week # 27. It was really very useful trick to create a validation list from the data in other sheet. Most of us might not knowing this tip. (Atleast I didn't know this) All the tips submitted in week #

$$Excel-Macros$$ Best Excel Tip Award of Week # 27 goes to ****Aindril De (Andy)****

Hello Everyone, Please congratulate Aindril De (Andy) for winning the Best Excel Tip award of Week # 27. It was really very useful trick to create a validation list from the data in other sheet. Most of us might not knowing this tip. (Atleast I didn't know this) All the tips submitted in week #

$$Excel-Macros$$

Dear Members, Thanks for your great response in the Week 27 competition. It was again great learning for the members of the group. Let us begin week # 28 quiz with more spirit. Last Date of Submission of tips : 12th July 2009. PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE CONSIDE

$$Excel-Macros$$ Re: how to recover VBA password?

Hi, Try Passware Kit Enterprise Regards, Kunal On Jun 30, 1:38 am, Haney wrote: > hi guys, > can somebody please tell me how to recover VBA password. im in urgent > need for this pls send me mails also if possible. > arsfan2...@yahoo.co.in > > thanx a lott --~--~-~--~~-

$$Excel-Macros$$ Re: Excel Password Recovery

HI, Try Try Advanced Office Password Recovery link: http://rapidshare.com/files/180568094/EAOPR.v4.11_www.dl4all.com.rar And also if u can search for Passware Kit Enterprise 9.0 its good. Regards, Kunal On Jul 3, 4:31 pm, DEBASHIS BANERJEE wrote: > Dear All, > > I have an Excl file  which i

$$Excel-Macros$$ Re: Outlook urgent

Hello. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject("Outlook.application") Set m = olApp.CreateItem(olMailItem) With m .Subject = "Subject" .Body = "Dear All," & Chr(10) & Chr(10) & _ "Find attached report as of 04-Jul-2009." & _

$$Excel-Macros$$ Change Events - depends on cell values

Hello, I will try to explain this as much as possible. I receive real time data ( Last Trade Price ) of soybean commodity futures through DDE in to excel ( cell A1 ). During market hours A1 will keep updating every milliseconds or seconds. My cell B1 ( =A1 ) will have same value as A1 and will up

$$Excel-Macros$$ Re: Simple Question - Please tell me about repalcement of (*)

Hi Amresh, Use ~ before * i.e. you have to search ~* Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary an

$$Excel-Macros$$ Locking row after entry

hi can any body give me macro that will lock enire row after entering data automaticaly. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video

$$Excel-Macros$$ timeline

how can i draw a monthly timeline in excel to visually tell the recipient where are we now --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Vide

$$Excel-Macros$$ Re: calendar pop-up

Hi Rajiv, It seems to me that, in this way, the calendar control is placed on the sheet. That is what Lynn doesn’t want. Best regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de rajiv_...@yahoo.co.in Envoyé : dimanche 5 juillet 200

$$Excel-Macros$$ Re: Simple Question - Search and Replace for Current Sheet Only in VBA

Is this segment of code in a looping macro that cycles through the entire workbook? Norman On Sun, Jul 5, 2009 at 10:54 PM, Norman May wrote: > Try this: > > ActiveSheet.Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _ > SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=Fa

$$Excel-Macros$$ Point of Sales or Billing Software

Hi, Can anyone has knowledge of Point of sales or billing system of delvelping in excel or access? You will be appreciated for reffering web sites or indicating free download. Thank you & regards, _ More than mess

$$Excel-Macros$$ System derived date & time in excel

Dear Friends, I have a below schedule which contains date wise & 1 hour slot wise areas. can i have its output such that its takes date & time from system & shows me only the specific cell as an output Input Sheet Date 07/05/2009 07/06/2009 07/07/2009 07/08/2009 Time band 12:00-1:00

$$Excel-Macros$$ Styles Lost When Copying/Pasting in Shared Spreadsheet

(Problem in Excel 2003 and 2007) I've got a spreadsheet I'm using to compile/manage requirements for a product. I have a 4-level hierarchy of parent/child requirements, and use styles to format (colour) and set the indent for each cell according to its level in the hierarchy. This has been workin

$$Excel-Macros$$ Re: Simple Question - Search and Replace for Current Sheet Only in VBA

Hi Andrew, Solution given by Norman is working fine. Pls show your code so that we can understand what is the problem. Regards, Swapnil. On Mon, Jul 6, 2009 at 9:49 AM, Andrew Ritland wrote: > I tried your suggestion but the VBA still replaces all occurrences of > "1234" across the entire workbo

$$Excel-Macros$$ Re: Simple Question - Search and Replace for Current Sheet Only in VBA

Hi, One possible solution is u can paste this data in to MS word and then do a find * and replace this works Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of amresh kumar Sent: 06 July 2009 10:51 am To: excel-macros@goog