Microsoft Excel Programming

dictionary keys
File Loading Problem
Loop more efficient ?
Personal.xls..2000vsXP
Excel 97 crashes
Macro editor passwords
programming a hyperlink
Excel Macro
A Macro to autofind a value in a range
DDE and scrolling
Getting Data From ACCESS 2K
hide / unhide range
Getting rid of macro warning window
Paste Special atop original sheet in Macro
Make a Excel Chat through Visual Basic 6.0
ComboBox & ListBox problem
Lotus Notes Q: Copy'n paste from Excel AND place Excel attachment
InputBox - Browse
userform CheckBox print
Change buttoncolor on button on a sheet from VBA
Resetting Combo Boxes
add date to a chart title?
Auto Re-Size Screen View
create multilined invoice (subtotals on each page)
PIVOT TABLE REFRESH PROBLEM
Code to disable "paste" as an option
Excel and .NET
Error accessing external object property vbe
Import from web using query-format problem
What control to use?
Office Web Component Licensing
Copy cell contents to another worksheet
Add Arrow to Form?
Select a value from one list, presents outcome from two lists
Formatting via VBA
Open with VBA - hide passwords in code?
Code to disable Save options
Pivot Table Ordering
userform CheckBox print
Creating multiple folder levels
probrem linking a chart
[Group]
Excel formatting
Numbering files according to existing files
join blank rows
Locking and unlocking a workbook
Logon information
hiding row and column headings
Search Rows in a spreadsheet
Call vs. Run command
userform delete sheet
Re: Thanks and Gratitude
incrementing on inserrt row
help with Msgbox
Filtering and Separating Data
User Forms - passing data between them
datagrid
Re: Looking for Solutions
Re: # of specific characters in a cell?
Changing Data Source
UserForm label doesn't load?
Re: How come this range definition is invalid?
Wierd conditional formatting result.
Wierd conditional formatting result (oops pressed send to soon!)
Activating Worksheet Controls - "Excel VBA Problem"
Copying data from several worksheets and merging into a new worksheet
Re: Making add-in available
Deleting a file, created by macro
RE: convert today() to today's date
Deleting minimized Rows in a group
Re: Customizing the Locked Cell Warning Message Box
getting the cursor to show in a textbox
Querying Excel-Sheets with ADO using Inner Join
Newbie question: Importing modules (.bas) at startup?
Re: How to use combobox contents to get information for userform
workbook name (? function to return)
variable stored in Excel - read only from VBA
Combo Box code
loop random number
Code to transform layout of existing data
Re: Sum Product Formula Issue
Macro to print to 1 pdf
BeforeClose Dilemma
help creating a macro
Removing Macros
Subset Percentile Function
Chart data series
VBA help with Query
Adding Duplicates
entering data to develop a pie chart
Re: Another Late Binding Question
Code to sort/delete rows
Prevent drag copy
Import English Text and Convert to French
One-line bar chart for %
an excel dunce pleads for help
Mid
Hiding Labels
Excel 2000 formula recalc problem
Evaluation of variable before setting it as a formula.
Re: Array is best?
Deleting a Column from a Workbook
Need help with Syntax
Week Ending Formula
Open with Macro
ComboBox Format Problem
tricky Excel/VBA/Access needed
Progress Meter during macro execution
Incorrect formulaR1C1 when activesheet is chart
Page Breaks and Subtotals
Save as Web page in Excel 2002
Split a time entry into shifts
External reference an entire worksheet
cell listbox
Pressing "Enter" to run macro
how to set macro using cell location
using range in formula
Macro as alternative to limitations of data table...
how to code for automatically sorting ?
still can't assign MACRO
Re: Open .txt, Save as .xls from command line
Determining text in a cell
Trouble with filtering form - newbie
Communicate with Internet Explorer from Excel
Macro lock/unlock and Auto Filter script issues
Doing a find and replace in a text file
Run Macro when Cell changes
Is Relational Hierarchy Possible with Excel
Unexpected Internal error when calling a function (Excel/MapPoint)
Little bug in my userform
Function or macro help
Delete Temporary internet files
pivot table refresh
Dispalying A text in Commnadbar
Textbox validation
Creating menus manually without VBA?
Loading Bar
DoEvent
Moving through sheets
Enter a cell value from a VBA macro
Processing Overhead during Cut/Insert
minus
static commandbar Button
Macro to make period visible in pivot table
not able to set a sheet name having two dots.
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
Actively update macro reference?
Recognise filter in macro and ignore.
Advanced Filter - Help
Charting in PowerPoint using Excel
PowerPoint datasheet
A few questions
Can we create pivot table dynamically
VBA- Counting the number of the sheets
VBA - Left Shift to be Activated when Sheet is selected.
Query Tables
Excel 2003 and Application.Quit
Drop-down list in datavalidating dissapeares
Assigning a Macro to a Shockwave File
Field length in Cells
un/protecting VBA project
How to automatically adapt column width with XML format?
script/macro that can compare data of two columns
I have trouble in the hidden sheet range
Default Save Location
Normal Days to business days
Changing text to numberformat via textbox on a form
counting the rows that match in my loop
forcing 'macro enable' on open
Check if value in list
Running a Sub and exiting the current one.
Open up workbook but dont update links
ODBC ControlSource
Text Wrapping Problem
select ranges of cells relative to location and then paste
createfolder
Change format of single word in cell
Reference Help, please
Unlock sheet
Run code based on cell contents
Custom function - argument description help
Multiple windows
Convert value
macro problems with Workbooks.Add Template
Reading from TextBox
Move ActiveCell down 12 then add up 11 above....
Protect ALL cells If Q
RS-232 Serial Communication
Message box- Assign a file name to a variable, from user input
userform delete sheet
List Range
Paste values only
Iteration performance issue
Pivot Table Macro to run in XL2000
Match (Fucntion, Script, or Macro)
Diff versions of Excel!
Repeat Error message
Re: Different Random Numbers
Error in my code?
Error in my code?
Re: Different Random Numbers
Different versions Excel errors
Can't get .value=.value to work
copy & paste to all Sheets to the same cells
Open a new Directory
HLOOKUP Question
Averaging a variable length column
Ontime run at a particular time
How to line a DropDwn w/a Named Range?
Anything I need to load or special tips for Ontime to work
Help Needed: Calculation error
Better Way to Write This?
AddIn installation Problems
AddIn installation Problems
Debugging Timer
Excel VBA - Checking for inactive hyperlinks
same workbook hyperlinks
Nested loops??
Re: Column Headings
Excel Troubles
Deactivate autofill
Cell data to a userform object
error number to determine if shared file is open on "this" machine
Trouble getting used to VBA
Acos Function
How to execute an SQL insert/update from Excel for Mac
More efficient way?
AddIn installation problem
Clean Up Background While Running Macro
User Form sites
Regarding the lstrlen
Variables
Removing special characters and extra white space
What is the best VBA book out there for..
excel calculations
Selecting cell above a #N/A
Select Range every 20 rows copy & paste special
Adding a named range to a cell
Changing values in formulas with VBA
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 ???
Find a day and copy
Import selected lines from an Ascii file
Number of pages
Macro/function to indirectly reference table?
Conditional Information on Printing
Getting Around Heading Restrictions
Error 1004: Unable to set the XValues of the Series Class
Find Last Column, Select, and Bold
VBA Excel - Compile Error: Out of Memory
Password format
More HpageBreaks Strangeness
Saving from form into multiple sheets
Case Statement error
move data between sheets & keep running total
control advancing to cells
VB for copy & paste values (not formula's)
Conditional formatting formula
Hiding Rows
Extracting metatags from a web page and inserting them in a worksheet.
training people with excel
Emailing a selection
Excel VBA - loop code problem
SETTING PRINT AREA IN VBA
ISERROR
CommandBars
how to delete all macros - save file with cell-name
VB.NET to Excel
macros and file security
Keeping an Array Filled and running macro from other workbooks?
Changing the Mouse Pointer to Hand just like on Hyperlinks
graph with sevral datasource
Suggestions on Filters
Move to next cell
Formatting Excel worskheet
Changing field in Pivot Table with macro
Compare and replace values
Excel VBA question
Removing Blank Rows?
Checking for a Task on windows?
Code for new row and specific filling down
quick code request
Using VB, how to check if Excel Row is grouped as well as the level?
Multiple Access in Excel ???
Excel assumes too much
Reporting number of rows on a userform
PRoble with subtraction
How to determine the length of a .prn file.
call VLOOKUP from Macro with Variables
Problem Dragging Formulas
How do you assign macro's to new menu with buttons on Auto_open?
Advice about loop and cell action
Creating Directories
Newbie formula help required pls
Macros and validation lists
xl2002 doesn't understand macro written under xl2000
Set cell text direction (degrees property?) via visual basic
Add-In needs to create CommandBar
Can somone speed up this formula?
why doesn't excel97 winNT vba macro code work in excel2002 winXP???
problem when drawing textboxes in excel using macro
Group/Ungroup Protected Sheets
Changing DataSource of a Chart
Disabling code using a button?
how to get the digital signature for my excel sheet?
opening a shared workbook
List of Excel DDE commands
Is there an add-in or a utility for Excel Packaging?
Autofit merged cells with wrapped text
Detecting Excel 97 using VBA
Re: Split method
Using VBA to track changes in a worksheet - help! Event procedure??
Relative Position in VBA Array
Button Selection OnAction property
Writing Excel Formula To A Cell
TextBox InputMask???
list of commands for excel? where?
Run-time error from my code
Macros that write data to a new spreadsheet?
Debug issue with macros
Changing Cell Contents Based Upon User Input
Create copy of spreadsheet
Arrays as Arguments in Functions
How do I Copy data dynamically to a calculated cell
Linked Excel Chart within hidden Word Application Visible
Sheet Names
trouble removing rows
select multiple items in olap pivot table
Delete line if value in column C = ""
Excel mouse functions?
GETSQL Is too slow
Calculated Formula
Data exchange between vba and excel
Calling a function in another project from within a cell formula
Setting Printer
Phantom Links
Print Preview
Command Prompt to a Directory
Showing a Msgbox in the active application
Adding drawing to index, need to shift everything down
Increment array range
Array difference?
Retrieving the sheet names of another workbook
not found
Consolidating data using a macro - Help!!
trying to combine cells with shortest equation
Transparent problem with frame.
Stumped
Complex Numbers
Populate a series of values
Macro selecting wrong cell range
Excel VBA - determining range
Simple Excel Question
RE: listbox and variables
Intro to VBA
MS Excel 5.0 Dialog
Re: Multiple User Forms
Using Countif in VBA
VBA Question: going through rows in a sheet via vba
Error msg for "ShowAll"?
Re: Saving a file via a Macro?
Run-time error '1004' unable to get the ChartObjectsproperty of the Chart class
connection test
Changing the values of variables
Cancel error
Copy Worksheet without VB code attached?
Find according to sheet 2, Delete rows in COL A
Unable to Set LeftFooter Property Class PageSetup (ASP)
Variable Macro
Setting a default profile when invoking Outlook in a Procedure
Quick! Help With Code Formatting!
Random password gen - Excel VBA
User defined function
Re: VBmodeless
Re: Open workbook - prevent macros
Naming cells using partial cell data
Matching two sheets
Excel/Access Program
Microsoft Certification for VBA
Error number 1004
Re: PaperSize Property in Xl97 via XP
Re: How to copy entire row fm an xls file to another xls file?
Re: Macro Question
Emailing my spreadsheet?
trans-sheet copying
Emailing my spreadsheet?
Re: display in excel stays blank
Re: Name of shape giving VB run-time error
Re: Displaying messages
Re: Can't assign to Array .GetRows in Excel 97
Run an animated GIF in excel 2002
copy insert problem
Help - desparate for an expanded history log without sharing a workbook
Populating a ListBox
Other way to use "Getpivotdata"?
text over image
Re: Autofit merged cells with wrapped text
accessing data from other workbook
Tips for optimising page setup .Zoom and .FitTo properties
Setting a range value to the last cell in active worksheet.
Reproducable Hard Crash in Excel 2003 (and earlier versions) with the following VBA code.
Copy/Paste program error
make date BOLD
Re: unprotect, lock and reprotect file does not seem to work
Combination Models
Outline.ShowLevels
VB MACRO ?
Resizing Comment Box
Excel Table Drawing Data from Access - security??
How To Finish pivot table refresh before cont. VBA code
SELECT, ERASE, EDIT items in listbox
clearing pivot table field values
Code error
value in the 1st col of a range
setting up a Company ordering template
SendMail with Excel VBA - Outlook
VBA search function
Cancel button
Re: Improving Calculations with the Excel Dependency Tree/Table
User function for returning several results
looping through ranges: how to speed up?
SQL n00b needs help!
Type in textbox display immediately in cell - need help on this
inserting a picture from an excel file into an access table
Very challenging
Application.InputBox with Default:=0 testing False
checking what day a date is?
no valuta sign in cell from combo box
Dev tools (VSS) in XL2003
Searching a spreadsheet using a vba form
excel queries
late binding onto Word problem
Disable textboxes
Excel Function referencing another sheet
Array Formula in VBA
Late Bind to Specific version of Application
Excel Frequency Function?
Re: Arrays as Arguments in Functions
Error '1004' (Method 'Cells' of '_Global' Failed) On chart creation?
Excel Macro code help - re pasting rows
Numbering of Charts
compare data on 2 sheets
Application coding in Web Browser
bound columns - listbox question
Insert Todays Date - 3 in file name
why it not writing to target files?
REad large txt files
Copy and paste ranges from a close book using Validation
Using Listbox to specify data in list to enter in textboxs
Re: Require cell entry
How to loop through the data to find the median?
Copying and pasting a worksheet to a blank and removing blank rows
How do i declare a formula with prenamed variable
Macro for Excel spreadsheet into Access table
Open Worksheet Macro
Excel expression "sumproduct" in Access
Macro help required!
From Excel to Access
notepad to excel spreadsheet
Re: Class Instance Identifier
Cell counting question
Calculation w/ Filter
Re: Cell Data Types (Date vs. Double)
Paste Selction In First Empty Cell
Show the excel filename
Re: Macros for worksheets
tri dans un tableau
Excel Data to Web Page
Message Box Execution
VBA Saving code causes SAVED file to be corrupt
Re: VBA Floor/Celing commands
find row that contains certain values
Disable Command Button when File name begins with Customer?
Re: Exporting from Access to Excel
Sorting a 2 column list with VBA using Worksheet change produces 1004 error
Grey Color
Button fails to call macro when open an Excel file from web
Re: Recommendations on where I can get help by month end
Re: Checking for existence of excel
Creating 1 Single Module For Several Sheets.
Deleting duplicate rows.....there's more
Transparent problem with frame.
fighting the type mismatch error
Excel Splitting Up Data By Keyword
Re: creating a demo that expires after time
Help with simple(?) macro
Saving File automatically
text search between workbooks, copy data
How to write a VBA code to select certain rows based on certain conditions
Re: edit box
VBA code for Autosum command
Non text function
Unable to set the Locked property of the range class
naming a range
naming a range
naming a range
naming a range
naming a range
Non text function in two workbooks
Finish one App before closing??
Cell Value
Cell-format and comparison
Deleting the leading character in a series of cells
Rows.Find question
Fill combobox from specified range
Excel format
VB Code for MS Query
Required sum, need values to adapt with changes
How do I retrieve Chart Source (range) and PlotBy
Re: Weird problem!
Chart numbering
VBA Code Interferring with User's Copy Action
Question about print scaling and page header/footer
eliminating #value when computing average
Copying from WB to WB!
Calculating Winning Percentages
VBA Crashes Excel on Compile or Stop Debug
Date created
Conditional statements
VB Pivot Table Refresh Excel 97
Combo Box Losing List Items
Data copying from WB to WB!
Save As dialog box in macro
how to code factorial in Excel
checking to see if a "shared" workbook is already open
Database link to worksheet!
Selective configuration of Manual calculation
How to delete empty rows in a worksheet
Logging on to network drives automatically.
Excel VBA - How to transpose every fifth row to same column on another sheet
How do I get events from a "Split Button Popup" control?
Macro to save excel file
how do i send email from a macro
Linking groups of cells in a row so they will sort together
Forcing a date entry?
Edit Comment Box
Counter & Loop tutorial website
How do i insert "If function" in a macro?
Reply For Ronny
Is It Possible?
Re: Question on Linefeeds/Carriage returns
Web Query
Delete duplicate Name but not the blank rows
Re: How do you assign macro's to new menu with buttons on Auto_open?
Attaching macro to a pivot table drop down
Border around Data Entered in Variable Rows
i have some problem
Need a macro to copy a range in one workbook and paste into another workbook
VBmodeless
Re: VBA Floor/Celing commands
insert HPageBreaks first instance occurance only - an example
adding rows and populating them with data from other columns
interesting pivot table questing
Error 1004 using Shapes.Range().Align
Running a query based off values in col A
2 x Case // Error why ?
Re: Exporting from Access to Excel
changing column button in VBA, need help!
Test worksheet name
hyperlinks
Wrong type of Listbox from VBA
Why does this keep blowing chunks
Pie chart labels
Including Spreadsheet Date in a header
Inserting Entire Rows
diagram with 2 values
Changing Values In A Cell
Are the macros allowed?
Re: Problems with pasted HTML data
CurrentCell
Copy Formula to Last Needed Cell in Spreadsheet
How to find a Chart embedded in a Sheet?
linking
Now Date Formula
Union question
Excel 97 stuck in calculation loop - maximum cells problem?
Copy several range from all files in folder into several worksheets
csv info to excel
Remove blank rows from combobox
Displaying a message in a message box without requiring user to click anything to proceed
Re: Default to SaveAs
How do I delete a group of cells
listindex
PivotTable Columns
Dumb Dim Question
Re: Initializing User Forms
Org Chart Diagrams
New to VBS and VBA
Re: Command to move down one row
Simple Code Help
Record to stay in one spot not matter how rest is sorted?
More efficient than copying and pasting
In need of some dire help...
warning message
Programming Question
Macros
Row/Column letters/numbers - how do you hide?
Excel 2002 Hyperlinks and redundant rows
Appending Info
Protecting Macros -is it possible
VBA Match Error
Workbook_Open Event questions
Macro to delete duplicate data
More Solver Problems
Export to CSV
How do I approach this little Project, please?
WorkBooks.add
Get Macro on one Worksheet to Work on Others
Working with page footers
PDF Writer Error
Run time - % complete
How do I convert from a 'double' valued color to a System.Drawing.Color?
RE: activeworkbook.saveas
Scorecard
filtered range
Macro to add data
Newbie question on accessing data in xls
Is this a feature new to Excel 2002?
Conditional Formatting Using VB
Help with arrays please
Auto numbering new worksheet versions
Check Boxes and Option Buttons
function to print to PDF and save PDF file
For Next loop problem
Updating Hyperlink with sheet name change?
Displaying and Hiding Radio Boxes
Time and If...
Question
User Forms
Sum unknown length column data in VBA
Find row with matching cell and retrieve values (VBA)
Re: Checking for existence of excel
Re: Find and clearcontent
Re: User Forms - Max Me
Urgent Help needed on! Copy and Paste a Formula as Values using a Loop statement
start excel and decimal point
Dates in Excel
Opening a file through input of first 3 digits
Make 2 radio boxes uncheckable if cell " has no value
Treeview control and view of folders and files
Rounding Dates
write two excel sheet
dialog for directories
Variable Macro
Increment a Template
VBA Sort one sheet display another
Re: Turning on Workbook Properties Statistics
Chart help
Creating Charts Using Data from another Workbook
default value for Autofilter
Transpose Columns to Rows
entering formulas on a sheet
Delete Rows and Parse Data
Attn Alan Bedan re arrays
Execute a query from a macro
How to separate fname and fname in cell in excel
find problem
trouble with combo box
Excel 400 and StarQuery
Determining Start & End Points in Selected Cells
Changing Column Order (Not Rows) with Sort Function
Print Preview
Excel VBA - ActiveX Data Objects (ado) Performance
lookups in other worksheets....
HELP to apply a Workbook_Open event
Tools Bar
macro question
How can I do convert letters on "*" using keypress on excel
Button on a workshhet?
Copy on condition and paste to last+2 row
highlight entire row based on date
Worksheet_SelectionChange
using VBA to insert a column of pictures
opentext
Position/Size a MessageBow
Initialize textbox values
Move files from one directory to another: if they are there
If-Then statement with variable range
ComboBox start condition
addinn list in excell
Control powerpoint and pdf writer from excel..?
Delete Rows if Certain Values are listed in a Range Name
user form VBA
VBA noob help with an IF
display results of formula in different cell
VBA newb needing help with an IF
Like Operator
VBA newb needing help with an IF
Easy Listbox to Sheet?
Count maximum consecutive positive numbers
fairly basic excel question (i hope)
using VBA, incerting a row for alphabetical order
Page Numbering
Drop Downs- Validation
Re: using VBA, incerting a row for alphabetical order
simply lost on hyperlinks
Query replace by VBA
I need help, if able.
multiple sheets
need help with vba
Can it be done by marco?
size of user form
Need help with VBA
Excel forum not receiving answers.
Need help with VBA
Pop-up function argument list
ActiveCell.Formula and IF statement
Making Contents of a cell input for a Module
interesting query problem
ListBox - Row Source problem
Recordset.Recordcount Returns -1!
Excel 97 crashes
Dynamic Range
SKIP EMPTY ROWS FROM IMPORT
Deleting Sheets based on checkboxes being unchecked
Excel 97 crashes ?!?
Check if workbook is already open, if so close
merging excel files in different sheets
Row Inserter Macro
Macro to delete Rows 1, 3 and 10
Check if workbook is already open, if so close
How to delete sheet that is referenced.
How to keep an Array 'alive'
Change PivotField Item with macro
Preventing Writing in Combo Boxes
Using VBA code when searching in a spreadsheet
Excel crashes when editing chart
Unhiding columns
referencing a closed workbook
check and/or create sheet "xxx"
OLE ListBox refresh
Storing Macros
Code Help
vB code to analyse list
Dim / Redim of an Array
Re: Make the first row to be fixed and to be printed in each page
Excel takes long time to open
Macro Crashing Excel
Get Open File Name
Excel VBA/macro problem; Export to csv
Copy cells when column contains data
Specifying a countif function within VB
Re: Function to return font style
Re: Outlook attachment
formula arithmetic
Using .Replace
Format Cells dialog box on UserForm
Recalculation using filter