Excel Programming [Archive] - Page 140

IF ELSE with an AND?
excel macro help
Excel dates seem to confuse me ...
Invoice template with pivot tables
how do I get the name of worksheet I just add in macro
Change Pivottable layout through VBScript
Variable Types
select cell
activex
Re: VLookup with VBA trouble :-(
Re: CALCULATE A LINK to a value
ontime Method
Ftp from VBA
Re: Advanced DDE
Need help finding unique values and transforming an n x 1 Array
Use of Solver outside Excel, from VB6 - without using Excel.
Don't plot zeros in chart
Excel/Access ADO
Resubmitting a question from yesterday...formula
Two little problems
2 Questions
Foreign characters aren't processed in a macro
Fill with zero
Chart objects
Adding a counter to a User Form in Excel
Charts smooth lines
using arrays in vba
Problem with creating numerous shapes on a single sheet
application.worksheetfunction.vlookup
Subclassing the EXCEL7 window
Change to excel settings launching an event
Save local copy of webpages
hyperlink to pw-protected files
E-mail Code
Disable Customize in Excel 10,11
Cell Comment
Help to hide rows, SpecialCells(xlCellTypeBlanks) doesn't work...
standard function in userfunction?
Result
How can I find out the Maximum Outline Rowlevel?
Excel Notation for Documentation?
[URGENT]How to mimic the toolbar zoom button from code
macro to process rows in a selection
Re: Date in danish
Sheets Array
Result
Renaming folders
restict format replace in a cell
returning values
re: InputBox code
.Net Managed Code - Excel
RE: formula
checkbox help
Task Pane
Excel VBA - Chain of Input boxes
Renaming Files
editing code in modules through VB
Run MACRO from the valve of a cell?
Re: Dir () code -- Dave Peterson
PIVOT TABLES IN VBA
Re: Sorting range multiple areas
protect sheet in VB
Command Button keeps moving!
Re: Password protected
Data Type question / Sort
Help creating a Macro or Formula
Re: Referencing
E-mail from VBA not working anymore
Re: Export chart to .bmp
Re: Excel VBA + SumProduct + not working!
Re: Save As B2
Re: VLOOKUP or...??
Re: Password protected
Q317109
Trivial VBA and Google issues/doubts
Re: Multidimensional Array
Show/hide cells code
Compressing pictures with VB
Question on worksheet protection and breaking macros
Excel 97 - extract data from COMBO BOX to Database
Accessing information from second workbook
index in vba
Problem using "Find" WorksheetFunction in Excel VBA
VBE COM Add-in Shell
Re: What do i wrong here
Re: What do i wrong here
Re: Problem selecting a named range
Books on Excel Programming
How-To suppress a warning dialog
need help
OLEObject GetFocus
need a simple code
Re: Sizing a UserForm
Two level web query?
Flashing worksheets behind a userform
Defining Variables that pass to other Subs
XLUP FInd Error
Function works except with January and February?
excel script question --> numbers to words
Re: Detect If Excel WB Is Shared?
Vba - securying a folder
Creating a Validation List Through Macro
spreadsheet commands in macro
"deselect ?" a range or change state from edit to ?
Re: Alt + Enter Character Number
Re: Sizing a UserForm
Re: Disable Excel Control
Replace a warning message...on protected cell
Combo box value disappers
Combo box value disappers
Select all cells in a range with a certain numerical value
RE: Disable Excel Control
VBA 97 does noet have Replace: anything similar ?
User Form Doesn't Show When Tab is Added
Runtime error 91
Runtime error 91
InsertLines and AddFromString crash excel
Create a reference
Vba - Checking existence of file
Maintain date once entered into a field
Calling a VB.NET exe/dll from excel
Place a SHELL Window
AutoCalculate and UDF
Auto Filter
Re: App Defined or Object defined error
How to change color
Copying an entire row of formulas
Closing Excel from a Macro
Sorting range multiple areas
Reading a specific Folder's file
Missing a line (Simple)
Filter question...
troubles with ActiveWorkbook.Save
Reading files on a specific folders
Re: Delete Rows where all cells = 0
Paste Special Macro
Coding for printing (without preview)
application or object defined error - 5922
Re: Delete Rows where all cells = 0
Forcing MS Query to run before macros
How to break dsifferent sections of the list in Excel into different files
Protect object vs. Protection from menu
Count no. of filled cells in a column
create pivot table linked to another pivot? possible?
how do I detect an error
Code problem emailing range as html in Outlook body
contact
Removing comment marker
Share/Unshare work book
Message for Brett
Read comboboxes into array
can this not be done?
Change Filename
Excel as Web Page in body of Email
Multiple Worksheet copying to a master worksheet
calculating an average based on criteria
TabIndex property
Compare ranges
Vba - Removing workbook
GroupItems - different results starting with 2002(XP)
Running A Access Macro From Excel
User Name From List
Using VBA to calculate some data
Need help with formula
Sorting range with areas
Microsoft Visual Basic for Applications Extensibilty 5.3
TRAPPING PRESSED BUTTON
Class module creating OLEObject
Deactivating Printing Message
Addressing a text box in a chart
Application-Defined or Object Define error? Help please.
UserForm positioning
DDE Channel
modification of hyperlink name
Extracting addresses from spreadsheet
Excel VBA Formatting cells by Date Range
Positioning a DOS Window
Message Box Duration
Using a CASE statement in another spreadsheet?
How to identify which cell in a row first becomes negative.
Re: Pivot Tables
VBA Glossary
Disable Customize in Excel 10,11
Select statements on the same sheet?
macro for inventory ageing
Worksheet change suddenly not working
How to get back the control
Advanced filter - counting the number of rows returned?
Re: On Change
Reducing A Number By 1 (one)
Check my Conditional Format Formula
Programming worksheet
Overflow Problem
Sum Columns
Protect Sheet but enable cell ranges giving Error 1004 Unable to set
How to get the original data in a cell after it is modified
How do I clear all Checkboxes on a worksheet on open
Multi-column two-dimensional quick sort
Creating a Validation List Through Macro
How do I apply LTRIM to entire Sheet?
Autofilter with Loops
Programmatically create combo boxes
Dynamically assign items to a list box
excel formula
Prompt before saving
Need help w/program to randomly sort row data
97 vs. 2000
Custom Toolbar: ListBox on.action not working
formula
mail excel to outlook problem
Re: Unable to use controls when sheet is protected
Closing a workbook...
...dispatching an input-synchronous call.
textbox value copying
search for line break in cell
Internet Connection
Re: My files don't work after I got new computer
Easy one: On Open selected cells in a worksheet are disabled.
Picture the same size as a cell
Save As Web Page
ODBC error
finding a value
Add Autofilter to A1:Z1 on workbook
array formula
Ignore Filtered items in actvecell.offset
Im stuck in VB!
Add-in
Re: Macro to re-write all cells in a column
Re: Macro to re-write all cells in a column
How do I Remove Virus Scanner
send email message
Re: Macro to re-write all cells in a column
String Parse
Open File ?
problems with advanced filters
getting VBA to pause while external data loads from web
Learning Programming
Excel Query
Function return by reference
Dynamically assign items to a list box
Re: Worksheet Comments
VBA, Macros, functions, or formulas
Embedded VB Forms Font Problems
Finding the last cell in a range
Re: Worksheet Comments
Do Until Loop
Add-in
Zoom property
How to put a 'return' in Msgbox?
Copy textbox contents to a range on a sheet
Cannot empty Clipboard problem
Finding worksheets by using variable names
Missing Links???
Get a List of Worksheets
Workbook_Open and Workbook_BeforeClose not working
Newbie question about accessing Excel sheet from the web
Vba - restricting cell vallue
Re: Prevent the Macros to be opened in 2nd xls. Sheet
RE: App Defined or Object defined error
how do I get a cell to blink in excel?
Range of columns
RE: Macro showing just certain rows
Show userform without it taking focus?
click with code
Retrieving previously entered userform data from saved spreadsheet
Re: Unload the form on esc key
VBA list all worksheets
Re: User form or embed in a worksheet
Userform
RefEdit control
Run Macro on true statement
CurrentRegion
checkboxes and option buttons
Re: RangeFromPoint Undocumented Returned Object
connection to oracle with excel
Re: Unable to use controls when sheet is protected
excel
SaveAs Result?
Macro to ajust columns!
Option Buttons
Activating a worksheet
Using VBA to print to a PDF
On Change
Date
pulling data from an excel workbook
array formula
Unable to insert a form design
Questions from a beginner
Locate cell in Named Range
Protect / Unprotect Sheets
Can any body help me out?
help with debug
Graphs??
How can i trap the rename event of an excel sheet?
funny calculations
xllastcell vs xlcelltypelastcell
I get two copies of pictures in the loop instead of one - why?
Turn off menu options with vba
old makro (excel 95) should work with vba-modules
Dimension Level & Member Browser Control
Need Code For Selection
Prompt before saving
How can i Create
Adding named range gives error "method range of object _Global failed "
Delete if blank...
Using listbox
Thx CoRrRan, Bob Flanagan, Harald Staff
Variable sized combo box
Multiple Discrete Columns Selection
Save changes on Excel Web Pages
Fin the most frequently Cell in a Row
textbox question
Fill a listbox with data from variable range
Print signature lines as footer
Print
Versioning/tracking changes
Previewing a form combo box
Writing data back via a userform
Error while downloading Excel File with macros.
Look up problem
Autoshape coding
Is column selected
Finding Names associated with a cell
Select Visible Cells only copy & Paste
vba doesn't trap errors?
Copy Code From a one excel to other through Macro
Xml Export Question
Arrays to replace very slow loops ?
Import Data from Access via DAO
Re: save as text
Re: Dynamic validation lists
Calendar conrtol issue
Worksheet name in Macro
Column not copying
Listing ActivePrinters
Find and Delete full row macro (with exceptions)
Increment outer loops
Selecting all cells
Instancing on Classmodule on Excel 2002
need help with IF statement
Excel/Access connection via ADO
Excel/Access connection via ADO
Popup when saving or closing
Excel workbook creation from ASP
Menu???
exporting a worksheet for backup
Code Speed Up
If active cell found in another sheet
recovered_sheet1
Simple macro - show all data
Calling Excel from C++
Starting userform
Type mismatch in VBA LinEst function if range too large
printing to a PDF file from xl
Writing Range to Array
importing files with a macro
toolbar buttons
Problems calling a procedure in another application
stocks/funds
RE: SendKey Question
Excluding week-end days/hours
Workbook_sheetChange event
Shortcut way for indicating comments in block of code.
Looping to create Variable Names?
Do while empty colomn
visual basic
Data match using VB script
Text font for comments
Move to next cell using VBA
Can' find error
Undo not working with macro
VBA - Loading a certain page when firing up a form
Excel Data Format
Splash Screen
unload userform from within one of that form's beforeupdate events?
Problem with copying chart using VBA
FileCopy problem
Replacing Formula
Assigning User Names
Set custom ToolBar Position on Excel Loads default to zero value
create dialog box within macro and use value chosen
Matching Column Entries
Excel Icon
Extract data after comparison
Evaluate conditional formatting in code
macro printing question
empty cells - best way of testing for them
Delete characters
Sorting
vba - using multipage
Column Autofit Problem
Control array - does it exist in VBA as in VB?
using decimal numbers in for-next statement
Launching file in excel not internet explorer
Simple Question: Hiding a CommandButton
2 combobox change vlue
Append form data to worksheet?
UserForm Problem
registry subkeycode
Can i disable the warning when i open the my VBA application
Userform.show '1004 Error'
Combobox in userform
Grand Totals in Pivottables with details
MSGBOX can be formatted?
CREATING GRAPHS
Managing User Changes
urgent question: how to calculate value with a string formula
Run other files from Excel
Text alignment in out look message
Sheet code module question
OLEObject on worksheet. Trying to get value from it.
More SaveAs trouble
SaveAs Errors
Help! with edit boxes!
Code not going to next unused row
Need a method or function
excel vba loop performance
Put a CommandBar on the left up corner of a cell
Cell formatting not updating
Canceling a print job
Re: Calendar conrtol issue
GetOpenFileName bug
Dynamic range not resized for RowSource usage
--- Problem, How to do DOCKING WINDOW IN EXCEL !!! ---
Static Variables
Macro Button
#value! when cell is blank
Jump to cell in other worksheet
random text
random text
word scrambles
Commandbars
Macro autorunning
custom function for the day of the week
(A repost) Automatic transfer of data between 2 workbooks
Re: Calendar conrtol issue
copyright symbol
display callout on click
Excel VBA - Courses in Toronto
Reset Used Range, Debra Dalgliesh's code
The existing filenames are too long.
How to update a subroutine in another excelsheet with a Macro
TO DEFINE AMBIGUOUS RANGE !
Fit to page
Excel VBA Problem
Auto macro
VBA : get a period - fill cells in calendar?
referring by index to adjacent cells
IF.. Then.. Post to specific cell
repost: error 'document already opened'
checkboxes
File Search
RE:Listing of one cell controlling the listing of another cell.
UserForm: force to update controlsources
Need help trying to open a file and stream data into a sheet...
how to access programatically added controls
Get Folder Path
Dynamic variable Reference
Deselect two objects after all selected
excel customised function with help
How do I get the total to show up in dollars?
How To Make a Locked list Automattically Expand
refer cell using c
Array multiplication?
Confused with variable
Running Macro on every sheet in Workbook !!!
copy sheet again again
Macro to Paste to a Variable Range - HELP
change a table to 3 columns only (Rows instead of Table)
Currency Formatting to 3 decimal Places
Help with referencing a .dll
picking data
Example: Generating a Range String from numbers.
Send Keys query
Application.OnTIme
Help on "With"
Excel VBA - How can I extract the hyperlink from a cell
Thank u Tom Ogilvy
How do I move between sheets in a workbook?
Changing code
More than 65,000 rows
Auto-generate controls on form
need help with With statement
Mail a row to each person in a range?
Need help on With statement
How to find out the residing directory of the opened workbook using VBA code ?
Inderect.Ext or copy -- Combobox
Macro won't work on other PCs - HELP!
DotMatrix printing from Excel
Did anyone know about "Shell" function?
Close a the current workbook and load another specified workbook
Programming Question
Populate the sheet with date
Color Index
Command Button
Activecell address
how do i move from one column to the next?
Replace function with array formula
How to run a macro many times simpler?
Replacing formula
Excel to pdf to email
Excel to pdf to email
Appending Text
Help with vb Find
How to Increment columns
Auto selecting the number of rows!
programming checkbox properties
A question about Counting in VBA
Pasting a worksheet function in VBA.
Urgent, help needed on range selection!
how to roll/scroll/log (??) real-time data ?
New Line in MsgBox
Delete Spreadsheet without Error
Disable Combo Box On_Change Macro
SQL.REQUEST linking Excel to Oracle - file dsn vs system dsn?
Advance Filter critera range
Force code to compile
check Isnumeric, doesnot work well
testing file availablity
VBA Code Assistance
Dynamic Copy/Paste Special Formulas/Paste Special Values
Calendar Control help
relative reference button
Refresh Pivot Tables
Custom Footers
Compare.xla
Performing a second order polynomial linear regression in VBA
autofill column data
Problem with MS Query criteria
What data type for Variable?
easy question : textbox
file location, defaults
Last column?
Protect and unprotect Pivot table
How to create a bar chart from a text file? Help needed please
automate regularly recurring entries
Randon Number Generation - HELP!
Download for external data
coding for external download
Re: Converting Lotus 123 Release 9 to Excel 2002
Re: Sheet Name
Re: Sheet Name
Re: Sheet Name
Re: How to change Text
Using a variable as a Row number
Delete Columns based on a condition
Re: Converting Lotus 123 Release 9 to Excel 2002
Multi Sheet Macro
[vba] ActiveCell in Online xls document
Command bar woe
Re: This one has really got me stumped..
Re: Printing Text from Excel
Re: Create and Send e-mail using macro
Re: Printing Text from Excel Automation
Edit Links
Searching for double quote in a string
Help to Indentify a drive letter
VBA Matrix class
Re: Bob Phillips
Text box physical string length
Check who's using a file
change attributes of numberous textboxes
Excel 2000 VBA Help File
How to use OLEDB and Reserved Chars
Edit message of a file search to a Cell
Associating data for auto fill in from dropdown list
How to delete duplicate entries
Hiding a range prints blank space
Find cells question ?
Function tests OK but doen't work when called
Find and export
Hide Code
Remove transition between sheets
How to add Tooltip text to Treeview
Excel to Outlook Small Question
How to know whether sheet1 contains any data in it?
Find a worksheet
Getting There...Almost!!!
reporting directory info into a spreadsheet
Back Up
Converting XLA to COM
Worksheet Names
Cannot Set the Orientation Property of a Pivot Field
DDEInitiate hangs
Re: Ftp from within excel
Declaring a constant to the Workbook Name?
vba crashing
overwriting a file
VBA to change chart colours
Using a MAcro to generate new sheet & Calculation
Tweaking Code - Experts Only!
Migrating Lotus 123 (*.123) to Excel 2000
Inexplicable crash in VBA
Using query from Access
entering data and updating the list
Close dialog box
Capture Current Selection in a Combo Box
Looping through charts in a worksheet
Excel VBA - Need help with a _calculate event
Duplicate Row Removal Solution
filter inactive records
Capture changing cell contents from DDE links
Xpath For Xml Map
Q. Can I save 2 copies at the once?
Re: sort (on part of) string - originally posted under Tricky Sort
Closing VB triggers closing Excel
Running Win Macros on Mac
Custom Header
Static variables
Static variables
Saving Workbook
Error: Unable to get the OLEObjects property of the worksheet class
Vlookup - column index number - create as variable
Consolidating tab-delimited text files
another look-up problem(three variables)
Lookup and Count I think
Unique ID
Macro running at certain times
Re: Group Sorting
Clearing Contents of all "unprotected" Cells.
Transferring data between 2 workbooks automatically
VBA Acting "Funny"
Re: Disabled Macros
CommandButton caption title
RE: Excel Workbook automatically (by design) runs a macro
Help with Posting Login to webpage from VBA
extracting from "show pages" pivot tables
Dollars in a text box
lookup problem in excel
Storing appostrophe's in SQL
excel vba browse file
Re: Oversættelse engelsk/dansk
Errors Detected Error Message
Re: 'Saved' Property not working
Excel 2000 VBA Code not working in Excel 2002
Sheets with VBA controls won't print.
Subtotal problem with Excel 2003
Using the Sort Method
number of days between dates
how to extract from this column
Convert Text Formated Numbers into Numbers all in VBA
excel vba browse file
Create PDF from Excel File
Lookup possibly?
dynamic formatting of cells
Re: Excel Workbook automatically (by design) runs a macro
rounding down
Shared drive
Excel 2000 Macro failing in Excel 2002
Re: Adding Calendar Control 10.0 to an Excel worksheet?
Save without changes
Can this formula be placed in CELL AT3 and insert the "x" into CELL B29?
RE: What a Paste
Re: I can import Access Tables. But, I can't import Access queries
Multi-conditional user defined function
Formula in Cell with VBA
Urgent Help Request...
Controlling Powerpoint through Excel
Run macro in active cell
Find Intersection
VB code to sum up all the figures in a column
When using an Option Button can I...
Add a number based on list of criteria ???
Calling a macro in another worksheet
Fast reading/writing of CSV files
File Names
Help with updatelinks:=3 etc PLEASE
Excel data match
Re: Copy sheet from one workbook to another workbook problem
macro to add alpha character to cell contents
Re: Excel's draw tool to create a Macro Button
Copy from Multiple Sheets
Calendar Control
File dosn't always close?
compare ranges in different workbooks and copy "not matching values" at bottom of range 1
Function or method
Automation error
Open File with Spaces in Path
Show / Hide CustomToolbar
How To: Macro Command To Reference Populated Cells Only
Parameters for Find method
Re: button to open a file
Create button to open a file
Formulas
sort problem
Softline break in cell
need a function for numbers to characters
Close excel
buttons for pause,forward,rev,run
Create simple commandbutton for manual recalculation
Q. Autofill question: Can I autofill alpha characters like I can numbers?
exit sub
Need to import multiple files with a macro
Links between VBComponents and Sheets 3
Hyperlinks and the Display field
Delete macro to stop importing data
FAO Chip - re: open windows
Cutting off numbers to two decimal places using a SCRIPT
Userform Maximum?
Code to set NamedRange for all application-Languages
Macro Magic Wand
Compare ranges n copy at bottom of first range
Protect sheets from editing but allowing macro to do so?
How to create a VB macro in Excel from Automation...
SendKeys Method ignore parenthesis?
Comparing Lists to Partial Lists
formatting issue
Viewing Multi dimensional array
Viewing Multi dimensional array
Bar Chart in Excel
How to keep showing full menu?
API GetTickCount and API for sound
Clearing cells of numbers, but not cell references.
Which windows are open?
Define Certain Exact Range
If field in column is blank, delete if....
Question.
?Conditional protection
to find values between two values?
Tricky user form question
Conditional protection
properties of excel button/checkbox
Create a pivot table in VBA
Re: where to find all excel constants?
VBA problem - prevent event to occur when certain button is clicked
combobox
Re: where to find all excel constants?
Nesting information
Re: where to find all excel constants?
Event for changing color
Write command including unwanted quotaton marks
Spelling check
is this possible
Problem with xlTextPrinter?
Lookup problem
Bizarre Project Explorer in VBE
creating an exe file with visual basic (installation file for Macros and Userforms)
RE: Dropdownbox
Extracting text to the right of the caret
Help with inputbox (Distinguish OK from Cancel)
Adding items to a ComboBox in Excel VBA
Problems Using DSL to Post to This Forum
Reading Super Large Ranges from Worksheet into Array
Re: Formula Referencing Worksheet Name by Variable
Type Mismatch in Vlookup?
HPageBreak count problem unless in page break view
multi-page control questions...
Opening Size of Spreadsheet
Use Procedure Instead of Macro
Subscript out of range
Message Box
Radio Button
Practical use of Window Hide
Named Range Question
VBA commands to open email
RE: Formula Referencing Worksheet Name by Variable
Setting pivot table field (current page) to a chosen value
Message when workbook is opened
Excel Formulas - COUNTING PROBLEMS
Finding a formatted cell
Msgbox text hard return
Microsoft Calendar Control 10.0
Ftp From Excel
Tricky Sort Issues
change default file path in Save As dialog box
Analyze Excel files structure
Help: Comparing two values
Concantenate and align info??
Dynamic range selection
Worksheet help please
Macro to Unprotect Sheet
Dropdownbox
Repeated - Page numbering in a report comprising of a number of views
Large size posts in Newsgroups yield lesser responses ?
Re: Dropdownbox
Re: Dropdownbox
Macro to Unprotect Sheet
Ref:Previous post
Dynamic charting
Request ..
Analyze Excel files structure
VBA command to say "yes"/"no" to popup window
Improve ADO code, Export Excel to Access
Find cell of equal value of a range and give result of ajoining co
Event Macro?
switch excel/reflection for windows
Getting a number from the end of a string
Drop Down List in Every Cell of a column
Named Ranges
Delete Rows & Capture Range
Help: Impot Text File to existing worksheet
Excel 2000 VBA - Removing leading zeroes from negatives
Sort in Subtotals
Macro to remove empty rows
user form-on open event? keydown event?
Compiling values based on selection criteria
Compare columns of value
cut and paste variabe ranges in one sheet to different sheets in workbook
Compare to columns
Goto Sheet based on Cell Value
Re: Extracting data
Re: what cells add to a value
Re: what cells add to a value
Links between VBComponents and Sheets 2
Textbox & Save file problem
Compiling an Excel Spreadsheet
Re: Links between VBcomponents and Sheets
Re: Weighted Avg - Complicated
Re: Extracting data
Re: Selecting a Cell inside a range
Re: where to find all excel constants?
Re: Selecting a Cell inside a range
Re: Selecting a Cell inside a range
Re: Selecting a Cell inside a range
Re: Circular Reference
Focus
Re: Macro to replace and updating sheets in workbooks
urgently required..
Userform Question
Event macro
Macro to automaticaly save a book under an specific name
Macro Help...Copy form txt file
Re: hex to decimal
hi i reall need help with autofill
Test fileOpen
Lookup problems
Vying for the focus - Worksheet Vs Forms
Search function in Vb
mathcing and comparing
excel 2003 browser control??
VBA Problem going from Excel 2003 to Excel 97
How To Iterate a range of cells?
search function
function names multilingual
Re: using vba code to find the square root of a number
Re: using vba code to find the square root of a number
Re: using vba code to find the square root of a number
Self Cert Transfer?
cal number of days
E12 conversion
File Dialog
Keypress Event
GetopenFilename & Files with special characteristics
Control content of text boxes on a userform
VBA cannot see data in Range("G1").select - but its there!!
Graphic Thermometer, Linked to Data Cell
Automatic creation of Hyperlinks
Re: Find Next in a selection, how to stop it when it returns to the fi
Cell Search Calculations
Copying files
Shell "mkdir"
UserForms and workbook manipulation
Checking a cell
FileDialog Help
hiden sheet
Open files...
Opening files...
look up and ISNA in vba
Worksheets("name") vs Sheets("name")
Date Formatting Problem
Reversing the order of the bars in a PowerPoint Bar Chart
PowerPoint Graph Size Changing
Fit to page in macro
Re-using Web Query Data
Display Many Excel files into one UI with Tabs
formula for ranking participants of a contest
Independantly running code
Automation Error when deleting command bar button
Automatic Cell population
Copy
Type mismatch problem?
change
calendar control
open power point foils via excel button (link)
Storing additonal information for a cell
Problem mapping procedure using OnKey Method
macro to select sheets
How to get data validation list
Re: Grpahical selection of points on Excel charts
#value
a question about cell text wrap
Application.WorksheetFunction.Index syntax
GeFormat function in Office 97
VBA Authorization in Win2k
Dependent combobox
Column sort
Excel Versions and defineing word.application
detecting row or col insertion & deletion
Unhide part of Full Screen button
Running .bat and .exe in Excel
ActiveWorkbook.SaveAs Problem
Email FIle Using Lotus Notes
automation object type library reference
Sumproduct wont work
Expand column to copy
Pivot Table
Event Macro
reformatting data
Opening WORD from Excel
export Chinese correctly to text
Page numbering in a report comprising of a number of views
Copy and paste data to a new sheet
Shared Workbook in Excel XP or greater
loop in a textbox
Pasting data and dates
Run-time error '5'
"Find" Macro not working for some
Run
Calculating Averages in VBA...
To display message in 2 different lines
Combo Box Help
byref errors
Freeze Table
OnTime events
Text Data Series
Populating worksheet with data from Access
Save Excel without macros
What's wrong with this code, please?
ComboBox Controls
Macro for Synchronizing time from the internet?
OFFSET Syntax
Bypass "DISable Macros"
Counting string length
Sti / path?
Help with combo box
Add Search Box to Spreadsheet
user friendly filter
Create a New Menu
Worksheet_change - Murdering syntax
Combo into calender?
Unable to get the Vlookup Property of the WorkSheetFunction Class
multiple nonlinear regression
Variable Ranges for Print Areas
To exceute a Macro when worksheet is deactivted and data is changed
VBA Word
Sending cell data in E-mails
Delete rows
Password Entry
Error when runing macro to create pivot table
Macro to copy only certain text
SEARCH & REPLACE MACRO
Userform resizing
ComboBox
C++ instead of VB for excel macros
Re: Why doesn't Selection.End(xlDown).Select always work?
Re: Why doesn't Selection.End(xlDown).Select always work?
Hyperlink
dynamic reference for chart
macro security issue
Replace text with numbers.
Re: Email addresses
Re: Permission Denied Error 70
Transform MS Excel Workbooks to Web-based Application
Transform MS Excel Workbooks to Web-based Application
Transform MS Excel Workbooks to Web-based Application
Transform MS Excel Workbooks to Web-based Application
Problems with IF's
Re: Returning a text value
ComboBox Problem
IeTimer events not working in modeless Userform?
optimizing a macro
Sorting Sheet1 from Sheet2
Updatelinks
finding duplicates?...
Keep format in Pivot Table
First Column Value Changes Row
Deleting a module
VBA version problem
How to create a Excel Workbook natively
multiple chart indexes
How to retrieve and write data to a webpage
Copy Conditional Formats
Sharing Workbooks With Macros
Re: How to change Text
Find That Date
how to merge two databases
how to merge two databases
VBA routine to assign first name only to a variable
Excell VBA - Class Modules problems
Change the name of an unsaved workbook?
Mail a row to each person in a range (HTML) Index?
Inserting a formula into a cell
Error document already opened
Help on printing only selected hyperlinked documents in Excel using VBA
userform syntax
Adding text to a cell
Declaring variables - Option Explicit
Step back
Transparent Text Label
Excel marcos firing on file save as but not file save
Linking To An Autofilter Arrow
How to trap KeyDown Events For Worksheets ?
Importing email from outlook
clean up selection optinons in pivot tables
Classes, and the For Each construct in Excel?
Print form
how to get Procedure..
Excel 97 printing error.
Error in loading DLL
Out of memory error