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 |
- Re: Creating a header with non-contiguous rows
- How do I get this VB Call to work?
- Problem with Help file in VBE
- Status Bar and Column/Row Headings Help
- strange error message following INSERT INTO statement
- Test for exact match in string
- How to reference # of copies in print menu?
- Error 91, Object var or With block not set
- Siple but what was the formula for splitting names?
- Two Questions
- Drop down lists
- Can you make a cell on a certain page constant on all pages?
- Preventing User Access to VB code
- expandable listbox
- Identify CD-Rom drive
- Eliminating Duplicates
- Closing
- Re: finding the last column and referencing it by letter
- Vba - generating button into worksheet
- Auto close excel without saving
- My program uses up resources
- Moving VBA scripts to new workbook
- Stupid End(xlup) problem
- Code is not working....please take a look!!!
- creating a drop down list
- GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
- Toolbars
- Modifying FindNext and Copy Code
- Run Macro w/o Opening Excel
- Array question
- Re: Macro to find name of sheet tabs
- Merging two or more workbooks
- GETTING DATA ON TO SHEET2
- SHDocVw.InternetExplorer
- Sheet Group & Formating in VBA
- Passing Variables
- Problem with format()
- loop through form objects
- Get table names from access through vba in excel
- Can I Group Form Check Boxes?
- Moving objects on a form
- An efficient find function
- Picking the latest entries from a column
- Deleting Duplicate Rows
- Is it possible to teach ones self VBA?
- Re: Only allow certain users access to specific sheets within a workbo
- Validatio Problem
- Re: FindNext and Copy Help (Urgent)
- How to paste cells from Excel into Outlook email body?
- Highlighting cells with vba function
- Save problem
- Open all files in a folder
- Re: FindNext and Copy Help (Urgent)
- Running Code From Controls On Other Forms
- recovering linked values in macro
- For Each Next
- Re: Virtual Memory Error when running Excel
- Re: Hide VB Source Code
- VBA - Flexible Sort Macro
- Inserting Rows Macro -- please help!!
- Togglebutton with the triplestate turned to True
- Saving Range of Cells as Image File
- Macro for Custom view
- Invalid Use of Null
- textbox & tab
- Web query & Passwords & Java & HTML
- Re: Personal xls will not open automatically
- combination of numbers
- Auto New macros?
- How can i get the value of the AsktoUpdatelinks form ??
- Create Barcodes in EXCEL 2003?
- Need Comments on Code
- If statement in VBA
- Range.calculate debug, Excel 2000 VBA compatability with Excel XP
- Sheet properties
- Worksheet Function using VB code
- Command Bars
- Starting Easy
- Extra feauture to the following code
- I have a Function Call that won't cause calculation.
- TypeConverter Excel-Automation problem
- User Form to display more than 1 reslut
- Check if clipboard is empty before .PasteSpecial xlPasteValues
- problems with XL 2000 files in XL 97
- Setting ComboBox ControlSource in code
- How can you make an array of objects?
- PRINT AREA IN PROGRAMMING
- Qn: Date Format in TextBox in UserForm?
- Help File
- solver.xla fails
- how to get onkey macro to fire while another macro is running
- Excel – Macro Problem – Appending Data
- Get the list of data inside AutoFilter list
- appactivate
- EXCEL 2002: How do I user/simulate a Timer event in Excel form
- appactivate
- Pivot Table - Subtotal of 3 columns
- Don't want to insert a partial row
- Looking for faster method for Copy & Paste
- Question about removing Web formats and content
- Filtering data out of access database
- Changing only source file of pre-existing text import QueryTable?
- 2003 Secutity Issue
- Select an item in a listbox using code
- cursor position
- MS Progress Indicator Mimicked. Thank you.
- Excel 5 macros
- Copy a range from a CSV file in a webpage to my local worksheet
- Adjusting screen layout?
- Relative time in SQL
- How to launch excel spreadsheet and load xml file from cmd line?
- Replacing keystrokes
- Fax
- list of extended properties for use with ADO connection strings
- Vba - User email direction
- Protected File
- Copy cell without border
- How to declare variable as Excel constant?
- Loops in a range for a more than one ocurrence of samevalue
- looping and copying from onesheet to othersheet
- How to do Cut and paste
- creating Toolbar on Word 2000 using built-in Visual Basic Editor
- XP upgrade and old 2000 macros
- Triple Lookup Formula!
- Lock Commandbars
- the anatomy of a nestled condition
- Comments
- Vba - automaticaly closing userform
- Excel VB help
- properties of object on another sheet
- How to hide rows?
- Counting Days of The Week Only In a Formula
- Hiding Formulas
- Prevent save when content change?
- IsDate Function
- OnAction Variables
- Importing text from webpage into excel and then loop?
- Using Dates in VBA functions
- Double Drop Down List & Corresponding Text Info Disply
- How to input a range in a logical test?
- I want to compute this formula: =IF(Q48=Protected!C27:C35,+Q48,"".
- Delete Folder
- Comment box sizing
- Using Hidden Sheets to populate listbox
- Confirm formula change
- Application.run Macro Code Problem
- File in use open read only
- enter todays date
- transferring data between two workbooks
- Mimick MS Progress Indicator?
- Format Cells
- Extracting Global Address List (GAL)
- Copying row data to another worksheet
- Sharing a workbook
- Tabs
- Delete menu
- Add large ammount of formula
- Change Multiple chart source data
- count cells if >""
- Which PC has workbook open?
- problems closing excel
- Should I keep Trying INSA - VLOOKUP?
- Help Please - User Database
- Is this possible?
- Re: Highlight Button...
- convert cell contents into a comment
- Run time error 70 permission denied
- How to total Items in a List "not that easy"
- Path in footer
- Address Book - Outlook
- Picture or Object Blanking out??
- Qn: Define a variable in Initialize for Userform
- apply conditional formatting
- Manipulate user permissions in a worksheet using VB
- Qn: Plot a position on a Chart??
- Re: Long Text in merged cells not copying correctly with sheet
- Advanced Conditonal Formatting
- Re: Relative referencing
- Qn: Checkbox Enable??
- Help needed
- Still having a problem checking cells
- Virtual Memory Error when running Excel
- Excel 2003 Commandbars
- Excel in network
- LTRIM Problem
- making a timer
- Bypass Replace File
- Excel VBA -Custom function sumproduct
- Copy Array pointer rather than entire array
- Insert Row when data is different
- Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003)
- Formatting using VBA
- Simple way to add a reference to a cell
- Custom Menu
- finding duplicate entries
- Toolbar Buttons and Macros available always
- align a picture/shape in a Range!
- MsgBox2
- Declaring one bidimensinal Array
- Multiple ThisWorkbook's Causing problem
- too many conditions! what to do?
- writing macros to hide rows
- Help with checkboxes
- MsgBox Title
- Update Alert
- Renaming a Worksheet with a macro... but...
- Copying formulas, formats, and sheet names across workbooks
- Countif Error --- Please Help!!
- .Textbox won't word wrap. Why?
- Re: updating charts
- labels and comboboxes
- Protecting / Hiding the Code
- Re: Naming an Excel Workbook
- Re: Quit Application Without Saving
- Re: Quit Application Without Saving
- Is this possible
- Control Toolbox buttons
- Userform doesn't recognize other user form upon re-load
- Excel data to Access?
- Does SUMPRODUCT work with "INDIRECT"?
- q. Using a macro to transfer data from Excel to Word
- Re: copy & paste macro
- paste as value
- Searching for cell values
- Unsupported methods for XL macro in IE
- Re: Naming a newly added sheet
- Re: Naming a newly added sheet
- Pivot Table Name Reset
- haha
- Re: Getting PrintForm to print all Frame Captions
- Re: How to save as a semi-colon delimited file
- Decimal portion to a seperate cell???
- cursor problems
- Lookup Help
- Filling a selected range automatically
- Change Shortcut Key Programatically
- Userform does not show on startup over LAN - problems
- Excel comments field
- Can't stop Excel help autotile :-(
- Cell color change on mouse over
- AutoFilter Criteria VBA
- Custom Menu Bar
- Excel formulas
- Excel VBA - Printing Seperate Graphs
- Becomming an MVP
- Consolidate - Relative Reference
- Signature lines in footer with "No Dupes"
- Prevent Workbook_Open macro
- Urgent help with nestled condition is needed
- J-walk face id menu - Problem
- Excel Mergefield?
- Date/Time Stamp Macro Button Problem
- Removing extended dash
- Footer Memory leak
- how do i copy a formula with different cell reference?
- How to keep a running total on a col that has frequent new entires
- Send mail from Excel
- msoControlEdit
- can it be adopted for a 16 team 4 group?
- script for a form
- Worksheets Add & Naming
- Inserting a variable number of rows in a worksheet
- Count of characters
- Pivot Table - show 0s in empty cells
- The value of a ListBox Item
- Newbie's question.
- Workbook comparison results in subscript out of range error
- SetFocus Question
- Macro Fails to Run Correctly
- Macro/Command Button
- followhyperlink method issue
- Excel menu toolbar hyperlink issues
- Correct Syntax - Collection Key
- How to use Digital Signatures
- "!" at end of variable
- Problem with formula: need rolling average of 10 months
- Macro for "close w/no save"?
- finding non-standard years in a dataset
- Do loop to add a new worksheet
- Excel to select a row based on previous rows
- Excel 2000 VBA date format changes in subtotals
- UpdateLink Question
- RE: Edit Text Import
- QueryTables Error
- MsgBox - Don't Show Again
- Automatic Macros
- control excel from Agilent VEE with ActiveX
- multiplying data
- Time format behaviour
- Validation
- Is Active Workbook ="ABC"
- Creating an installation file
- Automating Fill series Function Multiple times ?
- File Search
- Assigning global macro to keyboard shortcut in Excel 2003
- Automated export from Excel to Outlook
- Load 2nd form - second one not working after hide - help pls
- Set a cell to blank (Null)
- What does this message mean?
- Default Menu
- Re: Trendline Data
- Macro to delete duplicate entries
- Re: Easy Array Question...
- Re: Easy Array Question...
- Re: Easy Array Question...
- Read Only Wrkbook Sheet
- Re: Trendline Data
- ClearContents Not Clearing Query
- Re: Trendline Data
- formulas for pivot table data
- Re: Copy Formula loop based on number of rows w/ data in a col B.
- Sendkeys and wait variant
- updating Excel from DotNet
- Re: copy sheets selected on user form
- sending email with commandbutton
- Re: copy sheets selected on user form
- Qn: Ensure Number is valid for a circle??
- Class module in VBA
- Retrieving a value from a cell
- Exception Access Violation (0xc0000005)
- Setting up default chart properties
- Code Execution has been Interrupted
- Listbox Problem
- RE: VBA-XP-Excel 2000-2003
- Set print Range
- code for converting data format in another format
- Adding columns with dates -
- Re: Put the value of a cell in a variable
- Time format behaviour
- Time format behaviour
- Re: Time format behaviour
- Re: error handling off??
- Textbox
- Any fast method to parse a string into row & col information
- Re: RandomNumber Generator
- Exporting & Importing Macros
- Range
- Adding columns - with tech info
- EXCEL Checkboxxx Props.
- excel VBA problem - setting workbook as variable & opening/re-opening
- q Using a macro to paste data from Excel to Word
- string length
- VBA - find double quote (") in string
- Macro fire at given time, through command prompt
- Excel cannot complete ......... when screen saver is activated.
- Re: Running Event Procedure When Cell Updated on Excel Worksheet
- cell-fill-macro again
- export form??
- Make a built-in toolbar permanently not visible
- UserForm events
- Help with Do Loop that names rows as ranges
- Data from Excel to Access
- cell-fill-makro
- Delete
- Adding columns to get correct results
- Class module to filter textbox entry
- Print Macros
- Read only mode
- finding text
- Loop until underlined border??
- Filter
- code to select a column down to last poplulated row
- Web query on password protected page
- .GetOpenFilename assitance
- Calling Solver from an Excel 2003 Macro
- Disable Customize in Excel 10,11
- Need for Application.Volatile?
- Open wrkBook (auto_open) programmatically
- Offset Range
- repositioning aging categories in a pivot when present
- ChartObjects
- Excel 97 to XP problem
- Merging data from several sheets
- How to use function CELL(Infotyp;Ref) in VBA?
- Excel Validation Help Needed
- Difficult project using arrays
- Commands fail on different PC's
- another lookup!
- Check box - checked or unchecked?
- (Disable macro's while) using the GetObject
- Excel automation through .NET Interop: NumberFormat property looks like NumberFormatLocal
- Move ? spaces to the right
- Macro for comparing 2 values (number and date)
- web page object reference
- [variable] definition
- search for one column values in another col ?
- Device I/O Error
- save w/o prompted and activate a file
- MsgBox position
- Using If Statements to change colours
- Save without prompted and activate external file
- Save without prompt and Activate a file
- Customize Pivot Table
- Pivot Table - Code Optimization
- Find the last Row in a Range
- using a macro to copy cells from one sheet to another
- Convert *.Xls to *.csv
- Disable Macros when opening workbook
- A VBA code that clicks a checkbox
- How could I run my macros in a protected with password worksheet
- Excel error after using macro
- Filling a textbox with text in another cell
- remove help icon from inputbox
- Find...FindNext Problem
- Formatting &[Date] in header Excel 2000
- vba/macro for loop-based summing?
- User Input
- Missing coefficients in multiple regression
- forward and back buttons in EXCEL
- Quick n' dirty code to delete rows?
- Excel Macro question? Column position
- Summary on one page
- Merging cells text
- remove drop down arrows
- Excel 2000 / How clear drop-down list in Pivottable?
- Template behaving like .xls file
- Help with a macro
- Negative numbers
- Auto Edit HTML Page
- Re: Conversion from currency value to currency text format
- Excel calculation
- Closing Excel from VBA
- How to automaticaly hide all toolbars in in workbook when another workbooks are open?
- Tracking changes
- workspace
- RE: Adding Macro Button on Standard Toolbar
- Adding columns
- Link multiple spreadsheets to one central spreadsheet using a macro
- entering formula using variable in Excel Macro
- Control Button stays on screen
- Remove First Row from Variant Array FAST?
- Excel 2003 blows me right out sometimes
- converting dates
- Pivot Table Vba Automation In 2002
- Adding two columns to determine number of days to pay
- Return value of Property Get when using enumerated type
- VBA - Lookup address
- Macro File Help
- Re: Is it possible to get cell contents from another sheet?
- apoligies:changing excel icon
- VBA - Lookup cell address
- Is it possible to get cell contents from another sheet?
- Re: Is it possible to get cell contents from another sheet?
- Hide Sheet If....
- Sound when running macro
- Updating Data to Access Error
- right
- referencing previously selected cells after macro execution begins
- specify the exact size of a chart through microsoft script editor
- MS Query problem
- problem evaluating custom functions
- What is wrong in this Sub?
- Opening an HTML doc - inconsistent results manual vs macro.
- Re: Upgrading to Office 2003
- Splash screen on opening excel
- choose the right volume
- passing reference arguments to VBA function
- mouseclick events
- Re: File specific Auto correct entries
- Excel spreadsheets formatting
- Qn: Position of Cursor in UserForm1
- Qn: Load Data into UserForm1??
- passing criteria via Get External Data from a macro
- Qn: Paragraph or LF in ONE Cell??
- Excel macro recording problem
- Qn: Sound in MsgBox??
- Protecting Cells with macros
- Qn: Display Text in TextBox in Userform
- Shortcut keys for buttons on forms
- Excel Template Wizard?
- Opening an external file
- Opening Recovered Sheet - 3rd Post
- How do I count in Excel?
- Make 1 row into 4 rows
- need to copy row above but different thoughtout data
- Lost the 'Help' menu, urgent!
- VBA Primer
- Suspend code
- New Line Character
- User Defined function - second posting
- How to see if the opened workbook is opened by another user ?
- Removing Dialog Box
- code for select a group cut, paste and delete
- Automatic Activation of Design Mode
- Error Handler
- Automatically Close Excel
- Saving
- goal seek problem
- Reducing File Size - Turning VBA into txt?
- How to suppress the prompt from merging cells
- Refresh Multiple Pivot Tables
- adding new data on new sheet
- cell displays formula instead of value
- Like Sumproduct() but using values from a list
- PUT data in closed workbook
- Visual Basic Text Functions
- I try again with auto tab
- Please help with this filter
- select alternate rows - quickly
- Executeexcel4Macro?? (Dave, I need some help)
- Workbooks.Open not functioning properly
- Autofilter global Show All function disabled in protected worksheet
- Selecting first cell in a colmn after a filter has bee applied
- how to save only one sheet as workbook
- Excel 2003, problem with UK date format, using OLE
- calling an MS Access query from within VBA for Excel
- Get Pivot Table count of rows in VBA
- Timeout problems
- Disabling Right Click Menu
- Worksheet That Works Like Pivot
- difference between 2 times
- excel
- selectfile control
- excel
- Help with applying function to cells
- EXCEL 2002: How do I user/simulate a Timer event in Excel form
- Inputs.
- Re: HowTo Count number of replacements
- Chart question - Walkenbachs book
- Is absolute security for Excel VBA code possible?
- Open a TXT file from WEB ?
- RE: Worksheet as file
- Re: Still can't get it right
- Re: Calling a procedure in a procedure
- Color Text
- Passing data to an open workbook from Lotus Notes
- MsgBox - How to display In Other Instance of Excel
- coloring cells
- Re: Calling a procedure in a procedure
- How to open an html file from within a macro
- Re: Calling a procedure in a procedure
- Running an Access Query From Excel
- Macros incompatible for different versions?
- Populating data from an external database
- Open a Spread Sheet In a Mdi form In Vb.net
- Select a row, copy and repeat on the next row
- dYNAMIC Array declaration, a small correction in my last thread!
- Declaring variable as a dynamic array?
- Macros incompatible for different versions?
- Autocalculation settings when multiple spreadsheets open
- Saving files
- msgbox title
- Re: HowTo Count number of replacements
- Advance Filter problem
- Re: how to open a Workbook and activate a specific sheet
- SELECT ... INTO ... IN ...
- Re: how to open a Workbook and activate a specific sheet
- find location
- Deselect top row in pivot table
- Macros incompatible for different versions?
- Cut and Paste to A Seperate Worksheet
- So close and yet... (Pros Only)
- Verify Totals
- can it be done without using code?
- Combo box help
- Need to do a SQL-like functions within Excel. Need HELP!
- Re: Could not set the RowSource property
- Text Boxes / ctrl-f
- RE: Insert method of range class failed
- Insert method of range class failed
- Divide up Worksheet
- Save file with fields within quotes and comma separated
- Creating a chart (Getting the correct input and output)
- range data type
- Save takes seconds vs. SaveAs/Save As takes minutes
- User Form Template???
- ComboBox Values
- Apologies: access/excel ado via vba - forgot a line
- access/excel ado via vba
- Copying Worksheets from one book to another
- Opening with a password with VB
- vlookup from VBA on a closed workbook
- VB programming interactive macroes
- Conversion to Text file
- Hourly calculation
- Excel VBA- If Then statement
- Dynamic Validation Lists
- Problem populating a multicolumn listbox
- Adding add columns and not getting duplication
- Inputs into equations withwout having to repeat the equation every time.
- Hiding Excel Menus
- Hiding Excel Menus
- Hiding Excel Menus
- Counts
- irrational problem
- can i add a row for (x,y) values and perform its maths?
- How to eliminate any new pivot Items
- Adding - Thanks - in reversing the formula it worked
- Re: VBA To Replace Duplicate Values with Zero (Complex)
- ParsingCellData
- Read all -- Adding columns for paying
- User defined function
- Help with Pop up screens and Error Pop ups
- Need Help With A Loop To Copy
- Windows Explorer Right-Click Extension
- Make Option Compare Text the Default??
- Adding columns for purpose of payment
- Update cell selection of embedded worksheet in Word
- Print Array in Cell
- Repeated validation lists in several worksheets
- How to use QueryTable with insertion sql
- Userform cannot return any values
- Test if Clipboard is empty
- programming the VBE for a new event procedure
- Can I attach a toolbar to an add-in?
- Find Method
- Find Linked Cells
- Using cell references in Excel Macros
- running a webquery after every 5 secs
- Searching text lists
- Password protect excel code
- Colouring cells
- Difficult returning result !!!!
- Search for criteria and count
- TextBox Controls--tabbing
- Insert a heading
- deleting row using macro need help
- Additional feature to code given on August 6th
- Tab Name same as Cell - PART 2
- Naming A Table Array in Vlookup
- Naming A Table Array in Vlookup
- Naming A Table Array in Vlookup
- VBA execution stops at ActiveSheet.Copy -- but only sometimes!
- Help with some code please
- Excel VBA question - Running a autofil
- RE: Access and retrieve data from network workbook
- MDB add-ins for Excel 97
- read text file
- read text file
- Cannot suppress an ErrorMessage
- How can I use web query with a password protected page?
- Read text data
- validating macro
- screenupdating workbook open
- Countif with row criterion
- Autofill
- Sort options by Excel VBA
- Activate button when row selected.
- Recognising cell values
- Paste special to the active cell
- SQL Query Headache
- Switching Names Around
- a faster method in changing cell value?
- How to parse the comma seperated strings into the excel sheet
- Cell Comparsion (a bug?)
- countif usage ?
- Moving between Worksheets
- Re: Cancel return on keyboard
- Excel Math Bug
- Re: Okay, Let's ask this another way
- Combo Box initial set up
- Row Height
- VLookup question in a macro
- AutoLoad Custom Tool Bar
- select row in userform listbox with right-click?
- Changing a text entry format
- Searching an Array
- How to include a double quotation character in a string?
- Animated charts showing change with time
- Variable sheet name in formula
- next empty row
- RE: Formatnumber
- Copy Worksheets from one book to another?
- Display initial value in combobox
- Converting Excel Worksheets into PDF
- Relative Range in a Formula
- code to insert add'l code ???
- selecting worksheets
- Tab Name same as Cell
- Excel - VBA Macro Not Found
- Copy file while in use
- Removing Personal Information (Author etc)
- creating a new dataset
- Cells = Worksheet name
- Reordering with Multicolumn Listbox
- Network Workbook (access data, etc.)
- Week to date
- Need to print different sheets conditionaly
- Input Box Question with Code
- Need help with this reference problem
- RE: Input Box Question with Code
- Re: Input Box Question with Code
- Re: Numerical Input via an inputbox method
- Re: Numerical Input via an inputbox method
- Re: Input Box Question with Code
- How to run an excel Macro in VB?
- Excel on the web using .NET
- Formulas and making info invisible
- Access and retrieve data from network workbook
- exporting categories - excel
- Unloading UserForm not working
- PasteSpecial Values
- Re: List boxes - help
- Searching for mutiple items in txt files
- Editing Code - Help!!!
- Editing Code - Help!!!
- Filter blanks and populate with a series
- Re: Toolbars
- RE: Toolbars
- error message in Vlookup
- Improving data retrieval system
- moving mouse pointer
- moving mouse pointer
- Active Directory? (reposted in case it was missed after a quiet weekend)
- Enabling Line/Column number in code
- CommandButton
- Rename worksheet
- removing words/phrase from sentences
- Multiple personal.xls files found!
- User Indicating the Arguments while code is running
- Add an exception rule
- Running macros in the background
- Multiple persional.xls files making macros NOT work!
- Re: Macros in HTML
- setting the focus using VB
- Can Excell 2000 do queries
- Delete empty array columns
- Currency formatting
- Another Reference Problem
- Checking for Open Files
- Re: Volatility With Comboboxes?
- Change pivot Table color on Condition
- Returning Range Total in VBA
- Delete Password protected macros
- Converting <b> to bold in excel
- Command Button
- set ToContact Outlook security workaround - help
- Numberformat vs string question
- Subtracting dates to come up with number of days
- Excel VBA - go to cell problem
- Error Handling when database not available
- error 50290
- chart problem
- Accessing Server Date
- Userform does not always show on startup over LAN
- Run-time error '91'
- Problem is using any method of Range Object
- PDF converter to xls
- Problem in using Advanced Filter
- Workbook_BeforeSave()
- Open Files by Clicking on a Cell
- Code - Repost
- Memory Leak When Copying Charts
- Problem with removing qoutes from string
- Printing
- Printing
- how do I get data into my *.xlt from my *.xls
- Save As.....
- Clearing Combo Boxes.
- Cell Reference in formula increment
- Active x Calendar control error (-2147417848 (80010108))
- Code snippet storage
- error
- Adding to Chart Popup menu
- Converting From DAO to ADO
- (no subject)
- Need some events...
- Navigation Tree
- Excel 2000 V Excel 2003 and Pivot Tables
- conditions in Excel
- Effecient way to check, add, delete duplicates
- Detecting Applications Run using Excel
- Excel VBA - delete hidden column in mergence status
- How to reset Worksheet Menu Bar in VBA???
- Tony Barla
- Mail merge issue - ghost Excel process remains after closing application
- How to stop having to re-assign macros every time you open a workbook???
- copy data to another sheet
- Display Excel file in Internet - an interesting question
- Charting with VBA
- Userform with Formula
- Insert Rows after text appears in column
- Mail merge issue - ghost Excel process remains after closing application
- Forcing "Macro Enable"
- Populating listbox
- How to leave a combo box?
- Forcing "Macro Enable"
- Delete Rows
- Clear vaidation
- Newbie question
- button to activate userform
- save as loop
- Daily Automatic Transfer of data from one ws to another ws
- Pivot Table SQL Query saving
- What are XLL Add-ins?
- Creating Add-in with library of functions
- Print userform
- working by column name
- using vba to copy from excel to embedded word doc
- Date change macro between worksheets
- Copy textbox contents
- Display sum of selection with SelectionChange procedure
- Data Validation
- Three short questions regarding importing of data. See code
- active directory?
- hiding / displaying the excel application window
- ADO recordset returns -1
- Workbook_Open Question
- combining two cells
- Suppressing Pivot Table totals
- Availability of fonts in VBA
- VBA programming textbook/reference
- Occurances of value
- if its open...close it
- auto no save
- Transparent subform
- Why does this code not create a button when called???
- Create new sheets from data in either of two columns
- Passing IP address from Excel to a Web site Locator
- putting ' in a column of cells
- Workbook VBA not recognising half the new worksheet!!
- Vba - Opening Outlook with Vba
- VBA code for automatic download
- Help with Excel
- Collection Variable
- number format
- variable in a formula
- Lookup Mail Contact
- insert two text values
- re:loop through controls
- looping through userform controls
- startup a userform
- VBA to create PDF using Adobe 6.0
- Hide Worksheet
- ActiveX properties in VB and VBA
- Worksheet as file
- Send a range in Excel as the body of an Outlook Express message
- Macro to sum up the amout?
- Assign Sub to Custom Button
- Dynamic Range Chart Macro Question
- Can Excel use as a VB form creation?
- Insert Text at Bottom of Last Page
- wildcards with sumif/countif in macro/vba
- looping through userform controls changing enabled and locked properties
- Adding in data from another database
- Fox Pro Data Base
- Re: QueryTable's
- opening another workbook
- ordering
- Extracting sub arrays from a 2-D VBA array
- newsgroups
- Not exactly a programming question
- cursor position
- Mouse Over
- Rounding
- Chart Tab Name & Worksheet Reference
- Help with error 1004 in database query
- Data Validation Lists - drop down.
- inputbox Auto response
- ok... but not a solution to my original post...
- *.xlb file missing!
- clarify
- excel.application.run macro1 --> added code to respond "yes" to a inputbox
- Re: Future Value of Increasing Payments
- clarification
- clarification
- A way to create a Command Bar without code???
- Filtered counts
- 2 questions : ordering and placing
- macro problem
- Code for Tom and Frank
- For Each Worksheet Problem
- Opening Recovered Sheet - 2nd Post
- Edit userform
- *.xlb file missing?!
- MSFT Encounters Error
- ODBC/OLE DB to access Excel file and get weired table name Sheet$_
- links update
- Data types Questions
- Clearing all items in a collection
- Run Time Error 1004
- How to imput " " (quotes) in to your cells
- Re: Passing value from Hyperlink
- Need code
- inputbox and application.run macro1
- Re: Populate cell values with sheet names
- Excel Macro Help
- Re: Populate cell values with sheet names
- Erase Arrays
- Changing text color
- Values run out of range
- CopyFromRecordset does nothing
- consolidating records
- How to rename a picture?
- A variable in VB
- Newworkbook
- Code and thanks for/to Tom and Frank
- Save As... prompt
- Re: textarea
- Re: textarea
- Countif in VBA
- Maximum Unique Records in Pivot Table
- IF THEN ELSE STATEMENT
- protect cells
- Macro to force delete tabs
- Automating MS Query
- Paste
- Attaching toolbars to spreadsheet, but macros do not follow?
- Code
- text box reference
- Imported Text File Worksheet Tab Name
- command button color
- Finding Files on a server
- Excel Pivot table on the web
- VBA - Writing in XL XP, executing in XL 97
- Reading data from a database
- worksheet protection
- Trigger an event when a cell's value is changed.
- What next!!!
- VBScript to Change pivot table layout
- Object Required Error
- Need help on blank cells
- GammaDist Worksheet Function
- autoshapes round 2
- Fullscreen
- ActiveWindow.ScrollColumn Sort
- Help Please
- How to use "Transpose"?
- autoshape
- Returning the result of an SQL/Query to Excel
- changing user name on windows system folder
- how to capture data
- Sort a range randomly
- Excel macro to extract information from MS project files
- Speed - or lack of it
- Synchronise 2 dropdowns
- How do I create a user form in excel?
- Selecting autofiltered cells
- Restrict the user from ADDING/DELETING column/rows
- Macro sending Excel template data to database
- Appears that HotKeys have been used, but where in Excel 97?
- Performance Issue with Database Connection
- Find range in one sheet, then paste in the other (one by one)
- Protect Macro
- Lookup Help
- Re: ??Names ranges, charts, and SERIES function arguments
- Populating data from an external database
- Macro that cut and pastes
- Re: Help with VLOOKUP
- Excel Security
- add a reference manually
- Another Outlook question
- Re: Limitation on controls/objects?
- Re: Find last filled cell in a column
- Macro to upload tasks to the Outlook Calendar
- speed up macros
- Open Folder - Ogilvy code
- public macros
- Re: VLookup with VBA trouble :-(
- Help with MS Graph
- VBA Errors Through Webpage
- Excel PivotTable C# problem
- macro that sends email with attachment and address
- RE: InputBox code
- Re: Recordset object loses validity in call between function & subrout
- Convert to military time - part II
- Excel macro script to copy only formulas and not values from one sheet to another
- Re: Help sending mail...
- Data type conversion
- Excel Characters
- Menu/toolbars/macros defined in Excel 2003 not working in other versions?
- calling excel macro
- Re: copy outlook contact information to excel sheet with macro
- Formatting Zeros
- Excel Spreadsheet using SQL.REQUEST - System Requirements
- Data Label Object Position not working
- Sorting multiple range using a macro
- Remove UserForm
- Need help with writing variant back to sheet
- Autofiltering Makes Button Control Disappear
- Re: Recording page set-up macro
- unique copy
- Can a function return two values?
- Vba - Generating Micr Outlook Alert from excel
- URGENT: Alan Beban - SubArray not working - any thoughts?
- Alias FROM: when sending mail in Excel
- SOme problem on VBA Userform
- new worksheets based on list
- URGENT: Comparing Ranges, Selecting Values, and blah blah blah
- Note to Bob Phillips
- Trouble with Workbook_Open()
- VBA and SAS
- An MD5 Hash with a single quote = grief in SQL query
- Writing Macros in Excel
- vba - counting different items
- Data Validation
- Browse for folder - Jim Rech's
- Syntax
- Re: Help sending mail...
- Assigning range to array not working
- Display Alerts
- Re: InputBox code
- VBA date in function
- RE: Pivot Table
- This should be an easy one for most programmers but im having some trouble...
- period of sum of sine waves
- Automate Embedded Word Document
- RE: Using Access DBs from Excel
- RE: Find last filled cell in a column
- Returning number of blank cells
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.