View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
[
144]
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- help with user definded function.
- Pattern Matching with cells function
- "Are you sure" Prompt
- Problem Tracker
- Excel Form Issues...again :)
- Help With Counting
- Create folder with a macro
- Removing Leading Zeros from a String
- looping texboxes - possible or impossible?
- Protecting Formulas
- Form help
- Identifying Multiple Selected Worksheets
- Logging on to network drives automatically.
- Re: File already exists
- Adding space to VBA code
- Additional criteria for a countif statement
- = positioning
- Help Required With Snake Column
- Workbook Before_Close question
- Best way to protect sheets and document.
- Help Please
- Empty ThisWorkbook module, but Macro warning problem
- VBA instead of lookupformula
- Toolbar sub Menus
- Command Button run-time error
- Re: zero'n out table values
- Using dates in macros
- Importing Checkbox Values
- Number precision problem
- if statement is true, copy data to another location
- Re: Outlook attachment
- Open Folder from inputbox
- Adding text to the body of an e-mail
- Undo Macro
- Updating Custom VBA Functions
- Auto Open
- Lists within Combo Boxes
- Recalculation using filter
- Using .Replace
- formula arithmetic
- Re: Outlook attachment
- Re: Function to return font style
- Specifying a countif function within VB
- Copy cells when column contains data
- Excel VBA/macro problem; Export to csv
- Get Open File Name
- Macro Crashing Excel
- Excel takes long time to open
- Re: Make the first row to be fixed and to be printed in each page
- Dim / Redim of an Array
- vB code to analyse list
- Code Help
- Storing Macros
- OLE ListBox refresh
- check and/or create sheet "xxx"
- referencing a closed workbook
- Unhiding columns
- Excel crashes when editing chart
- Using VBA code when searching in a spreadsheet
- Preventing Writing in Combo Boxes
- Change PivotField Item with macro
- How to keep an Array 'alive'
- How to delete sheet that is referenced.
- Macro to delete Rows 1, 3 and 10
- Row Inserter Macro
- merging excel files in different sheets
- Excel 97 crashes ?!?
- Deleting Sheets based on checkboxes being unchecked
- SKIP EMPTY ROWS FROM IMPORT
- Dynamic Range
- Excel 97 crashes
- Recordset.Recordcount Returns -1!
- ListBox - Row Source problem
- interesting query problem
- Making Contents of a cell input for a Module
- ActiveCell.Formula and IF statement
- Pop-up function argument list
- Need help with VBA
- Excel forum not receiving answers.
- Need help with VBA
- size of user form
- Can it be done by marco?
- need help with vba
- multiple sheets
- I need help, if able.
- Query replace by VBA
- simply lost on hyperlinks
- Re: using VBA, incerting a row for alphabetical order
- Drop Downs- Validation
- Page Numbering
- using VBA, incerting a row for alphabetical order
- fairly basic excel question (i hope)
- Count maximum consecutive positive numbers
- Easy Listbox to Sheet?
- VBA newb needing help with an IF
- Like Operator
- VBA newb needing help with an IF
- display results of formula in different cell
- VBA noob help with an IF
- user form VBA
- Delete Rows if Certain Values are listed in a Range Name
- Control powerpoint and pdf writer from excel..?
- addinn list in excell
- ComboBox start condition
- If-Then statement with variable range
- Move files from one directory to another: if they are there
- Initialize textbox values
- Position/Size a MessageBow
- opentext
- using VBA to insert a column of pictures
- Worksheet_SelectionChange
- highlight entire row based on date
- Copy on condition and paste to last+2 row
- Button on a workshhet?
- How can I do convert letters on "*" using keypress on excel
- macro question
- Tools Bar
- HELP to apply a Workbook_Open event
- lookups in other worksheets....
- Excel VBA - ActiveX Data Objects (ado) Performance
- Print Preview
- Changing Column Order (Not Rows) with Sort Function
- Determining Start & End Points in Selected Cells
- Excel 400 and StarQuery
- trouble with combo box
- find problem
- How to separate fname and fname in cell in excel
- Execute a query from a macro
- Attn Alan Bedan re arrays
- Delete Rows and Parse Data
- entering formulas on a sheet
- Transpose Columns to Rows
- default value for Autofilter
- Creating Charts Using Data from another Workbook
- Chart help
- Re: Turning on Workbook Properties Statistics
- VBA Sort one sheet display another
- Increment a Template
- Variable Macro
- dialog for directories
- write two excel sheet
- Rounding Dates
- Treeview control and view of folders and files
- Make 2 radio boxes uncheckable if cell " has no value
- Opening a file through input of first 3 digits
- Dates in Excel
- start excel and decimal point
- Urgent Help needed on! Copy and Paste a Formula as Values using a Loop statement
- Re: User Forms - Max Me
- Re: Find and clearcontent
- Re: Checking for existence of excel
- Find row with matching cell and retrieve values (VBA)
- Sum unknown length column data in VBA
- User Forms
- Question
- Time and If...
- Displaying and Hiding Radio Boxes
- Updating Hyperlink with sheet name change?
- For Next loop problem
- function to print to PDF and save PDF file
- Check Boxes and Option Buttons
- Auto numbering new worksheet versions
- Help with arrays please
- Conditional Formatting Using VB
- Is this a feature new to Excel 2002?
- Newbie question on accessing data in xls
- Macro to add data
- filtered range
- Scorecard
- RE: activeworkbook.saveas
- How do I convert from a 'double' valued color to a System.Drawing.Color?
- Run time - % complete
- PDF Writer Error
- Working with page footers
- Get Macro on one Worksheet to Work on Others
- WorkBooks.add
- How do I approach this little Project, please?
- Export to CSV
- More Solver Problems
- Macro to delete duplicate data
- Workbook_Open Event questions
- VBA Match Error
- Protecting Macros -is it possible
- Appending Info
- Excel 2002 Hyperlinks and redundant rows
- Row/Column letters/numbers - how do you hide?
- Macros
- Programming Question
- warning message
- In need of some dire help...
- More efficient than copying and pasting
- Record to stay in one spot not matter how rest is sorted?
- Simple Code Help
- Re: Command to move down one row
- New to VBS and VBA
- Org Chart Diagrams
- Re: Initializing User Forms
- Dumb Dim Question
- PivotTable Columns
- listindex
- How do I delete a group of cells
- Re: Default to SaveAs
- Displaying a message in a message box without requiring user to click anything to proceed
- Remove blank rows from combobox
- csv info to excel
- Copy several range from all files in folder into several worksheets
- Excel 97 stuck in calculation loop - maximum cells problem?
- Union question
- Now Date Formula
- linking
- How to find a Chart embedded in a Sheet?
- Copy Formula to Last Needed Cell in Spreadsheet
- CurrentCell
- Are the macros allowed?
- Changing Values In A Cell
- diagram with 2 values
- Inserting Entire Rows
- Including Spreadsheet Date in a header
- Pie chart labels
- Why does this keep blowing chunks
- Wrong type of Listbox from VBA
- hyperlinks
- Test worksheet name
- changing column button in VBA, need help!
- Re: Exporting from Access to Excel
- 2 x Case // Error why ?
- Running a query based off values in col A
- Error 1004 using Shapes.Range().Align
- interesting pivot table questing
- adding rows and populating them with data from other columns
- insert HPageBreaks first instance occurance only - an example
- VBmodeless
- Need a macro to copy a range in one workbook and paste into another workbook
- i have some problem
- Border around Data Entered in Variable Rows
- Attaching macro to a pivot table drop down
- Delete duplicate Name but not the blank rows
- Web Query
- Re: Question on Linefeeds/Carriage returns
- Is It Possible?
- Reply For Ronny
- How do i insert "If function" in a macro?
- Counter & Loop tutorial website
- Edit Comment Box
- Forcing a date entry?
- Linking groups of cells in a row so they will sort together
- how do i send email from a macro
- Macro to save excel file
- How do I get events from a "Split Button Popup" control?
- Excel VBA - How to transpose every fifth row to same column on another sheet
- Logging on to network drives automatically.
- How to delete empty rows in a worksheet
- Selective configuration of Manual calculation
- Database link to worksheet!
- checking to see if a "shared" workbook is already open
- how to code factorial in Excel
- Save As dialog box in macro
- Data copying from WB to WB!
- Combo Box Losing List Items
- VB Pivot Table Refresh Excel 97
- Conditional statements
- Date created
- VBA Crashes Excel on Compile or Stop Debug
- Calculating Winning Percentages
- Copying from WB to WB!
- eliminating #value when computing average
- Question about print scaling and page header/footer
- VBA Code Interferring with User's Copy Action
- Chart numbering
- Re: Weird problem!
- How do I retrieve Chart Source (range) and PlotBy
- Required sum, need values to adapt with changes
- VB Code for MS Query
- Excel format
- Fill combobox from specified range
- Rows.Find question
- Deleting the leading character in a series of cells
- Cell-format and comparison
- Cell Value
- Finish one App before closing??
- Non text function in two workbooks
- naming a range
- naming a range
- naming a range
- naming a range
- naming a range
- Unable to set the Locked property of the range class
- Non text function
- VBA code for Autosum command
- Re: edit box
- How to write a VBA code to select certain rows based on certain conditions
- text search between workbooks, copy data
- Saving File automatically
- Help with simple(?) macro
- Re: creating a demo that expires after time
- Excel Splitting Up Data By Keyword
- fighting the type mismatch error
- Transparent problem with frame.
- Deleting duplicate rows.....there's more
- Creating 1 Single Module For Several Sheets.
- Re: Checking for existence of excel
- Re: Recommendations on where I can get help by month end
- Button fails to call macro when open an Excel file from web
- Grey Color
- Sorting a 2 column list with VBA using Worksheet change produces 1004 error
- Re: Exporting from Access to Excel
- Disable Command Button when File name begins with Customer?
- find row that contains certain values
- VBA Saving code causes SAVED file to be corrupt
- Message Box Execution
- Excel Data to Web Page
- tri dans un tableau
- Re: Macros for worksheets
- Show the excel filename
- Paste Selction In First Empty Cell
- Calculation w/ Filter
- Cell counting question
- Re: Class Instance Identifier
- notepad to excel spreadsheet
- From Excel to Access
- Macro help required!
- Excel expression "sumproduct" in Access
- Open Worksheet Macro
- Macro for Excel spreadsheet into Access table
- How do i declare a formula with prenamed variable
- Copying and pasting a worksheet to a blank and removing blank rows
- How to loop through the data to find the median?
- Re: Require cell entry
- Using Listbox to specify data in list to enter in textboxs
- Copy and paste ranges from a close book using Validation
- REad large txt files
- why it not writing to target files?
- Insert Todays Date - 3 in file name
- bound columns - listbox question
- Application coding in Web Browser
- compare data on 2 sheets
- Numbering of Charts
- Excel Macro code help - re pasting rows
- Error '1004' (Method 'Cells' of '_Global' Failed) On chart creation?
- Excel Frequency Function?
- Late Bind to Specific version of Application
- Array Formula in VBA
- Excel Function referencing another sheet
- Disable textboxes
- late binding onto Word problem
- excel queries
- Searching a spreadsheet using a vba form
- Dev tools (VSS) in XL2003
- no valuta sign in cell from combo box
- checking what day a date is?
- Application.InputBox with Default:=0 testing False
- Very challenging
- inserting a picture from an excel file into an access table
- Type in textbox display immediately in cell - need help on this
- looping through ranges: how to speed up?
- User function for returning several results
- Cancel button
- VBA search function
- SendMail with Excel VBA - Outlook
- setting up a Company ordering template
- value in the 1st col of a range
- Code error
- clearing pivot table field values
- SELECT, ERASE, EDIT items in listbox
- How To Finish pivot table refresh before cont. VBA code
- Excel Table Drawing Data from Access - security??
- Resizing Comment Box
- VB MACRO ?
- Outline.ShowLevels
- Combination Models
- make date BOLD
- Copy/Paste program error
- Reproducable Hard Crash in Excel 2003 (and earlier versions) with the following VBA code.
- Setting a range value to the last cell in active worksheet.
- Tips for optimising page setup .Zoom and .FitTo properties
- accessing data from other workbook
- Re: Autofit merged cells with wrapped text
- text over image
- Other way to use "Getpivotdata"?
- Populating a ListBox
- Help - desparate for an expanded history log without sharing a workbook
- copy insert problem
- Run an animated GIF in excel 2002
- Emailing my spreadsheet?
- trans-sheet copying
- Emailing my spreadsheet?
- How to copy entire row fm an xls file to another xls file?
- Name of shape giving VB run-time error
- Re: Excel C# AddIn
- Re: Problems with AddIn Installation
- Improving Calculations with the Excel Dependency Tree/Table
- Can't assign to Array .GetRows in Excel 97
- Can't assign to Array .GetRows in Excel 97
- How do you assign macro's to new menu with buttons on Auto_open?
- Displaying messages
- VBmodeless
- List box - how to uncheck box
- Macro Question
- LinkSources(xlOLElinks) address
- Adding new workbook!
- VBA Floor/Celing commands
- display in excel stays blank
- Problems with pasted HTML data
- Cell Data Types (Date vs. Double)
- Cant close Excel App from Power Point
- Re: Saving a workbook as PDF in Macro
- problem opening Huge XLs file
- Error number 1004
- Microsoft Certification for VBA
- Excel/Access Program
- Matching two sheets
- Naming cells using partial cell data
- Re: Open workbook - prevent macros
- Re: VBmodeless
- User defined function
- Random password gen - Excel VBA
- Quick! Help With Code Formatting!
- Setting a default profile when invoking Outlook in a Procedure
- Variable Macro
- Unable to Set LeftFooter Property Class PageSetup (ASP)
- Find according to sheet 2, Delete rows in COL A
- Copy Worksheet without VB code attached?
- Cancel error
- Changing the values of variables
- connection test
- Run-time error '1004' unable to get the ChartObjectsproperty of the Chart class
- Re: Saving a file via a Macro?
- Error msg for "ShowAll"?
- VBA Question: going through rows in a sheet via vba
- Using Countif in VBA
- Re: Multiple User Forms
- MS Excel 5.0 Dialog
- Intro to VBA
- RE: listbox and variables
- Simple Excel Question
- Excel VBA - determining range
- Macro selecting wrong cell range
- Populate a series of values
- Complex Numbers
- Stumped
- Transparent problem with frame.
- trying to combine cells with shortest equation
- Consolidating data using a macro - Help!!
- not found
- Retrieving the sheet names of another workbook
- Array difference?
- Increment array range
- Adding drawing to index, need to shift everything down
- Showing a Msgbox in the active application
- Command Prompt to a Directory
- Print Preview
- Phantom Links
- Setting Printer
- Calling a function in another project from within a cell formula
- Data exchange between vba and excel
- Calculated Formula
- GETSQL Is too slow
- Excel mouse functions?
- Delete line if value in column C = ""
- select multiple items in olap pivot table
- trouble removing rows
- Sheet Names
- Linked Excel Chart within hidden Word Application Visible
- How do I Copy data dynamically to a calculated cell
- Arrays as Arguments in Functions
- Create copy of spreadsheet
- Changing Cell Contents Based Upon User Input
- Debug issue with macros
- Macros that write data to a new spreadsheet?
- Run-time error from my code
- list of commands for excel? where?
- TextBox InputMask???
- Writing Excel Formula To A Cell
- Button Selection OnAction property
- Relative Position in VBA Array
- Using VBA to track changes in a worksheet - help! Event procedure??
- Re: Split method
- Detecting Excel 97 using VBA
- Autofit merged cells with wrapped text
- Is there an add-in or a utility for Excel Packaging?
- List of Excel DDE commands
- opening a shared workbook
- how to get the digital signature for my excel sheet?
- Disabling code using a button?
- Changing DataSource of a Chart
- Group/Ungroup Protected Sheets
- problem when drawing textboxes in excel using macro
- why doesn't excel97 winNT vba macro code work in excel2002 winXP???
- Can somone speed up this formula?
- Add-In needs to create CommandBar
- Set cell text direction (degrees property?) via visual basic
- xl2002 doesn't understand macro written under xl2000
- Macros and validation lists
- Newbie formula help required pls
- Creating Directories
- Advice about loop and cell action
- How do you assign macro's to new menu with buttons on Auto_open?
- Problem Dragging Formulas
- call VLOOKUP from Macro with Variables
- How to determine the length of a .prn file.
- PRoble with subtraction
- Reporting number of rows on a userform
- Excel assumes too much
- Multiple Access in Excel ???
- Using VB, how to check if Excel Row is grouped as well as the level?
- quick code request
- Code for new row and specific filling down
- Checking for a Task on windows?
- Removing Blank Rows?
- Excel VBA question
- Compare and replace values
- Changing field in Pivot Table with macro
- Formatting Excel worskheet
- Move to next cell
- graph with sevral datasource
- Changing the Mouse Pointer to Hand just like on Hyperlinks
- Keeping an Array Filled and running macro from other workbooks?
- macros and file security
- VB.NET to Excel
- how to delete all macros - save file with cell-name
- CommandBars
- ISERROR
- SETTING PRINT AREA IN VBA
- Excel VBA - loop code problem
- Emailing a selection
- training people with excel
- Extracting metatags from a web page and inserting them in a worksheet.
- Hiding Rows
- Conditional formatting formula
- VB for copy & paste values (not formula's)
- control advancing to cells
- move data between sheets & keep running total
- Case Statement error
- Saving from form into multiple sheets
- More HpageBreaks Strangeness
- Password format
- VBA Excel - Compile Error: Out of Memory
- Find Last Column, Select, and Bold
- Error 1004: Unable to set the XValues of the Series Class
- Getting Around Heading Restrictions
- Conditional Information on Printing
- Macro/function to indirectly reference table?
- Number of pages
- Import selected lines from an Ascii file
- Find a day and copy
- Excel 2000: Unprotected cells - how to prevent cursor from wrapping ???
- Excel 2000: Combo box cell link protection question
- Excel 2000: Unprotected cells - How to prevent cursor from wrapping?
- Changing values in formulas with VBA
- Adding a named range to a cell
- Select Range every 20 rows copy & paste special
- Selecting cell above a #N/A
- excel calculations
- What is the best VBA book out there for..
- Removing special characters and extra white space
- Variables
- Regarding the lstrlen
- User Form sites
- Clean Up Background While Running Macro
- AddIn installation problem
- More efficient way?
- How to execute an SQL insert/update from Excel for Mac
- Acos Function
- Trouble getting used to VBA
- error number to determine if shared file is open on "this" machine
- Cell data to a userform object
- Deactivate autofill
- Excel Troubles
- Re: Column Headings
- Nested loops??
- same workbook hyperlinks
- Excel VBA - Checking for inactive hyperlinks
- AddIn installation Problems
- AddIn installation Problems
- Better Way to Write This?
- Help Needed: Calculation error
- Anything I need to load or special tips for Ontime to work
- How to line a DropDwn w/a Named Range?
- Ontime run at a particular time
- Averaging a variable length column
- HLOOKUP Question
- Open a new Directory
- copy & paste to all Sheets to the same cells
- Can't get .value=.value to work
- Different versions Excel errors
- Re: Different Random Numbers
- Error in my code?
- Error in my code?
- Re: Different Random Numbers
- Repeat Error message
- Diff versions of Excel!
- Match (Fucntion, Script, or Macro)
- Pivot Table Macro to run in XL2000
- Iteration performance issue
- Paste values only
- List Range
- userform delete sheet
- Message box- Assign a file name to a variable, from user input
- RS-232 Serial Communication
- Protect ALL cells If Q
- Move ActiveCell down 12 then add up 11 above....
- Reading from TextBox
- macro problems with Workbooks.Add Template
- Convert value
- Multiple windows
- Custom function - argument description help
- Run code based on cell contents
- Unlock sheet
- Reference Help, please
- Change format of single word in cell
- createfolder
- select ranges of cells relative to location and then paste
- Text Wrapping Problem
- ODBC ControlSource
- Open up workbook but dont update links
- Running a Sub and exiting the current one.
- Check if value in list
- forcing 'macro enable' on open
- counting the rows that match in my loop
- Changing text to numberformat via textbox on a form
- Normal Days to business days
- Default Save Location
- I have trouble in the hidden sheet range
- script/macro that can compare data of two columns
- How to automatically adapt column width with XML format?
- un/protecting VBA project
- Field length in Cells
- Assigning a Macro to a Shockwave File
- Drop-down list in datavalidating dissapeares
- Excel 2003 and Application.Quit
- Query Tables
- VBA - Left Shift to be Activated when Sheet is selected.
- VBA- Counting the number of the sheets
- Can we create pivot table dynamically
- A few questions
- PowerPoint datasheet
- Charting in PowerPoint using Excel
- Advanced Filter - Help
- Recognise filter in macro and ignore.
- Actively update macro reference?
- efficiently copy values from a Range of cells to an array (in VB.N
- efficiently copy values from a Range of cells to an array (in VB.N
- not able to set a sheet name having two dots.
- Macro to make period visible in pivot table
- static commandbar Button
- minus
- Processing Overhead during Cut/Insert
- Enter a cell value from a VBA macro
- Moving through sheets
- DoEvent
- Loading Bar
- Creating menus manually without VBA?
- Textbox validation
- Dispalying A text in Commnadbar
- pivot table refresh
- Delete Temporary internet files
- Function or macro help
- Little bug in my userform
- Unexpected Internal error when calling a function (Excel/MapPoint)
- Is Relational Hierarchy Possible with Excel
- Run Macro when Cell changes
- Doing a find and replace in a text file
- Macro lock/unlock and Auto Filter script issues
- Communicate with Internet Explorer from Excel
- Trouble with filtering form - newbie
- Determining text in a cell
- Re: Open .txt, Save as .xls from command line
- still can't assign MACRO
- how to code for automatically sorting ?
- Macro as alternative to limitations of data table...
- using range in formula
- how to set macro using cell location
- Pressing "Enter" to run macro
- cell listbox
- External reference an entire worksheet
- Split a time entry into shifts
- Save as Web page in Excel 2002
- Page Breaks and Subtotals
- Incorrect formulaR1C1 when activesheet is chart
- Progress Meter during macro execution
- tricky Excel/VBA/Access needed
- ComboBox Format Problem
- Open with Macro
- Week Ending Formula
- Need help with Syntax
- Deleting a Column from a Workbook
- Re: Array is best?
- Excel 2000 formula recalc problem
- Hiding Labels
- Mid
- an excel dunce pleads for help
- One-line bar chart for %
- Import English Text and Convert to French
- Prevent drag copy
- Code to sort/delete rows
- Re: Another Late Binding Question
- entering data to develop a pie chart
- Adding Duplicates
- VBA help with Query
- Chart data series
- Subset Percentile Function
- Removing Macros
- help creating a macro
- BeforeClose Dilemma
- Macro to print to 1 pdf
- Re: Sum Product Formula Issue
- loop random number
- Combo Box code
- variable stored in Excel - read only from VBA
- workbook name (? function to return)
- Re: How to use combobox contents to get information for userform
- Newbie question: Importing modules (.bas) at startup?
- Querying Excel-Sheets with ADO using Inner Join
- getting the cursor to show in a textbox
- Re: Customizing the Locked Cell Warning Message Box
- Deleting minimized Rows in a group
- RE: convert today() to today's date
- Deleting a file, created by macro
- Game security code needed
- Re: Making add-in available
- Copying data from several worksheets and merging into a new worksheet
- Activating Worksheet Controls - "Excel VBA Problem"
- Wierd conditional formatting result (oops pressed send to soon!)
- Wierd conditional formatting result.
- Re: How come this range definition is invalid?
- UserForm label doesn't load?
- Changing Data Source
- Re: # of specific characters in a cell?
- Re: Looking for Solutions
- datagrid
- User Forms - passing data between them
- Filtering and Separating Data
- help with Msgbox
- incrementing on inserrt row
- Re: Thanks and Gratitude
- userform delete sheet
- Call vs. Run command
- Search Rows in a spreadsheet
- hiding row and column headings
- Logon information
- Locking and unlocking a workbook
- join blank rows
- Numbering files according to existing files
- Excel formatting
- [Group]
- probrem linking a chart
- Creating multiple folder levels
- userform CheckBox print
- Pivot Table Ordering
- Open with VBA - hide passwords in code?
- Formatting via VBA
- Select a value from one list, presents outcome from two lists
- Add Arrow to Form?
- Copy cell contents to another worksheet
- Office Web Component Licensing
- What control to use?
- Import from web using query-format problem
- Error accessing external object property vbe
- Excel and .NET
- Code to disable "paste" as an option
- PIVOT TABLE REFRESH PROBLEM
- create multilined invoice (subtotals on each page)
- Auto Re-Size Screen View
- Re: Reduce the stock when place order
- add date to a chart title?
- Resetting Combo Boxes
- Change buttoncolor on button on a sheet from VBA
- userform CheckBox print
- InputBox - Browse
- Lotus Notes Q: Copy'n paste from Excel AND place Excel attachment
- ComboBox & ListBox problem
- Make a Excel Chat through Visual Basic 6.0
- Paste Special atop original sheet in Macro
- Getting rid of macro warning window
- hide / unhide range
- Getting Data From ACCESS 2K
- DDE and scrolling
- Re: VB and Help Windows Maximized
- A Macro to autofind a value in a range
- Excel Macro
- programming a hyperlink
- Macro editor passwords
- Excel 97 crashes
- Personal.xls..2000vsXP
- Loop more efficient ?
- File Loading Problem
- dictionary keys
- how to make a chart from formula values? VBA
- Filtered Rows / Numeric Data - Automate Position of Total on Worksheet
- How can you do this?
- The old application.quit problem
- string problem
- Error Handling
- macro from General to This Workbook
- Copy and Paste to Bottom Row?
- Excel - web page interaction...is it possible?
- Newsgroup protocol question
- Displaying Excel charts in VB
- Re: How do delete every second Row
- Re: VB6 and Excel - 1004 error
- Opening and closing many spreadsheets from .NET
- arrays
- Re: The old application.quit problem
- Re: The old application.quit problem
- Create combo box in Excel using VB editor during run time
- How do you hide a row based upon cell criteria?
- creating workbooks(with macros and userforms) programmatically
- reformatting a table
- Import Text File
- Formats in Listbox?
- lookup source for Macro from a dynamic Range
- Converting Dates
- Excel VBA - Action if a cell holds a certain value?
- protection and macros
- two dataset comparison
- Function debuging help
- Excel VBA - Found last row number but can't select it
- Text color question?
- Printing 11" by 8.5"
- Increment value inside conditional format
- Other language
- Re: Hiding cells based on formula result
- Hiding cells based on formula result
- Shared Workbook grows bigger when saved
- Strange behavior Chart.SeriesCollection(n).Values property
- Hiding cells based on formula result
- Setting up deposit account
- using variable inside activeCell reference call
- loop through all named ranges
- Menumaker problem
- Deletion of rows according to background color
- Opening as Read Only
- Where would you like to save - Name?
- Open external book before updating links?
- "what triggered the event"
- Sorting columns with multiple rows
- Data import odbc
- Excel VBA - Capturing a checkbox caption into a worksheet.
- select all & copy in word from macro in excel
- vLookup to another open spreadsheet
- Can't check checkboxes in userform ... sometimes
- About the use of "Getpivotdata"
- Tracking Changes
- Sarbanes Oxley Question - tracking changes in macros
- closing form w/ Maco
- closing form semi permantly
- Sum the first 10 numbers in a 26 cell range
- Rename Files from Explorer
- Navigating To Find A File
- Double click funtionality
- convert whole excel file to vba (tough question?)
- Programming double click functionality
- Can not write string to a cell
- Creating Word Documents with an Excel Macro
- weird date issue
- Counting Fridays in a month
- ComboBox problems !!
- RE: macro does not sheet name
- Copy same data from all files in folder
- Autofit column width of all worksheets in active workbook - an example
- Newbie: Conditional question
- Delete everything after a certain character?
- application.Value(Variable)
- Two Different Columns of Dates
- MS Query
- Creating dynamic (formatted) tables
- Display a picture depending on a value in a specified cell?
- GUID of the Reference
- Copy a range of cells in an unopened workbook and paste it to the current workbook
- FileName
- HLOOKUP Question
- converting to excel file
- if cell empty hide row macro?
- locked cells
- Like Character?
- question on arrays in vba
- comandbars/toolbars
- Run Macro Upon Opening
- Copy And Paste Rows
- Variable File Name
- Tom Ogilvy - 'Snap to'
- SUM Function Yields Zero Result
- Unfilter
- Cell text format
- Using SUM with worksheet range selected by two combo boxes
- Formatting Header and/or Footer Dates
- VLookup
- Date Formats in Headers/Footers
- Re: Calling a function without starting with "Personal!"
- Application.ScreenUpdating malfunction
- autonumbering only when original file is opened
- deleting the last nine characters in a cell
- Excel VBA Format Row on Condition in Cell
- Sort list by color (makro)
- Excel No-Launch
- Newbie needs help with formula
- dynamic list to remove duplicates and spaces ?
- VLookup in VBA
- Same variable name in different projects
- automating delection of certain rows
- trouble displaying as text
- Deleting entire rows
- Selecting Variable Rows
- convert a number of seconds to HH:MM:SS?
- snap to from vba
- Using Validation list to copy from another Workbook
- Combine Closed Sheets
- Capturing Excel Opening
- Error in 2003 which is not in 2000
- Method of protection fault when sharing file!!
- How can i access a listbox?
- How access a listbox on a worksheet
- Need Help on Web Query - Thanks in Advance
- Telling MSGraph which cell I need
- Last valid value in array
- Conditional format cell ranges with loop?
- Why do i have to re-assign macro's all the time
- Replacement CD
- convert 400 word files to excel files fast?
- Runtime error with the sheet collection, which was not there in 20
- Can I "Save As..." an Excel Sheet to an Access Table?
- Address of Merged Cells
- Exel VBA - Sheets.Name
- formula help reqd please
- Pivot table change leaves MSQuery open
- switch on 'snap to' from vba
- Create a xls File on Server without Excel?
- How to schedule a Macro ?
- check folder event
- hiding the headers
- Trust and Signatures in VBA
- Equivalent ActiveCell.Id property for Excel97
- Question of Import Export Files
- Automatically Cut Row of Data and Paste to Other Sheet?
- Automatically define series of named ranges
- Query between worksheets
- creating new folder while saving document
- Hiding rows programmatically
- Enter Key behavior with Userforms
- Using different range names in same function
- Help - This macro converts my text numbers.
- Clearing Cell Contents
- problem with performance of excel macro, pls help
- Can't open Excel2003 workbook containing VBA macros with Excel2000.
- Compile error for macros
- What's Wrong with This?
- error (ComboBox-?)
- Import text wizard in a macro
- A macro to fill in the blank cells
- Filesearch in VB6
- macro and lookup in workbooks
- copy / paste without skipping blanks
- Batch Watermark Macro
- Mail Merge Programming????
- character limitations
- character limitations
- Advice wanted fromMVP's.
- searching for the first few characters in an active cell
- Deleting a Column
- Need to sort based on Check Boxes
- Re: Textbox ControlSource Property - Excel 97
- Write-Reserve problem...
- lookup problem..can you solve!??!
- Custom print macro
- A Macro to Edit Cell Content
- Macro to delete duplicate records
- range selection problem
- formula question for arrays
- Worksheet Event Code
- the "&" in buttons
- asking for a file
- Hide Columns
- Button controls on worksheets
- array values type mismatch?
- Solver automatically in the VBA Reference
- easy question on excel/outlook
- rnd
- Experts help needed
- Generate Excel files on server
- Consolidate
- userform txt box updates spreadsheet
- VBA Valadation xlBetween ERROR
- How does Solversolve Control Macro
- How to write macro for entering mm/yy where it fills to current mm/yy
- Listing Named Ranges
- Macro works once, not twice
- Solver 32.dll
- click functions
- Dynamic Print Ranges
- Aligning login logout times horizontally
- Aligning login logout times horizontally
- Delete a list of rows
- References to XLA files
- Excel
- Conditional Formula
- Increment cells only in filtered range?
- Macro VBA Code
- Counting Dates
- Re: CSV File format problem
- Re: Remove password at the time of opening the workbook
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.