Programming
in [Excel]
|
Alphabetize Macros in a module Hi All........ I have a module with nearly 100 small macros in it. Is there any way to automatically alphabetize their order in the module by their name? TIA Vaya con Dios, Chuck, CABGx3 ... 17 May 2010 03:44
Skip condition if cell is blank I have 4 conditions 1) If Sheets("Details").Range("H" & lngRow) > Date - 90 And _ 2) Sheets("Details").Range("F" & lngRow) = Sheets("Search").Range("C2") And _ 3) Sheets("Details").Range("J" & lngRow) = Sheets("Search").Range("C4") And _ 4) Sheets("Details").Range("I" & lngRow) = Sheets("Search").Range("E4") Then... 12 May 2010 08:03
Macro to delete entire row Hi, I am using this formula =IF(COUNTIF($A$6:$A$33100,A6)=1,TRUE,COUNTIF($A$6:A6,A6)=COUNTIF($A$6:$A $33100,A6)) to highlight the last row item for cells with duplicates. I need to delete the entire row of all rows that were not highlighted by this formula. Hope this makes sense. Any help would be a... 12 May 2010 20:21
SendKeys with enter hi all i'm trying to use SendKeys to simulate rutine action. i'm doing the actions on web based system but from some reason after using the enter in the sendkeys the rest of the actions are not working this is the code Dim i, J As Long Range("A1").Select While Selection.Font.ColorIndex = 4 Selection.Offset(1, ... 12 May 2010 08:03
Startup files open while login. Hello Everybody, I have many files that open while login to the the system using Start-All programs-Startup. However, I have noticed that whatever files that has been saved at the end of day are not reflect the same(whatever data i have saved) when i login to the system a very next morning. Could you pls he... 12 May 2010 04:49
Open files while login, Pls help Hello Everybody, I have many files that open while login to the the system using Start-All programs-Startup. However, I have noticed that whatever files that has been saved at the end of day are not reflect the same(whatever data i have saved) when i login to the system a very next morning. Could you pls he... 12 May 2010 02:40
Figuring out MAX LEN in a given column Hi. I'm trying to redesign a database, originally done in Access 2003, so exported tables to Excel to analyse existing records, and in this instance, maximum LEN in each column that's text. I want to program a macro which: 1. asks, via InputBox, which column to analyse; 2. starting from the row after the he... 13 May 2010 09:23
How to map a shortcut key to a routine in COM AddIn for Excel 2007 1. Background: I have a COM addins developed in Visual basic 6.0 for EXCEL 2007. The COM addin has its toolbar visible. It exposes customized 'Copy' as a button on the toolbar, which will call MyCopyAction routine in the COM addin. 2. What I want: I want to map a shortcut key for the customized 'copy' op... 29 May 2010 16:51
Sort by one column then another. I want to do two sorts one on column "B" and then by column "E" for a specific range. Below is the sort for the first sort. How do I do a nested sort along whith the below sort? ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range ... 12 May 2010 00:30 |