Excel Programming [Archive] - Page 127

User-defined function clitch ...
Date stamp function
API graphics question
transitioning custom menu from XL95 to XL97
Addin remains in memory!
Macro that waits, then resumes after window is closed
Where does thefiles PERSONAL.XLS go
where does PERSONAL.XLS go
Joystick
Export to Excel API
Export to Excel API
Date problems when importing txt files
select multiple buttons
Freeze panes without line
Send to button
Open ExcelApp in other PC via Network
negitive and positive numbers
Detecting Row Selection
Can this Formula be Shortened Please
access rs232 port with vba
Suppress File Name
Thread safety of Excel
creating autofilter and using them thanks VBA
Are there excel chat rooms
Changing a "Counter" Value from a Sub
Filling combobox with variable length list
RefEdit events
SQL - array
SQL - extracing digits from a number
Looking for templates for a condo Association/secretary/treasurer.
Summing same cell in mutiple Sheets
Compile Error:
Problem w/ Match prop vs. Match method
Variables Held in Sheet Module
Buttons - Select All ?
recalculation - saving
define multi region and sort it using unicity
Correct way to use names defined globally in a workbook, in VBA
connection to internet mysql-database
Can I use AND like this
creating or importing new fill patterns in Excel 2003
Delete cells but not charts
error 400
Detect Excel was started with Windows Task Scheduler
message when activating OLE object
Looping & Dumping
How to lose your work!
Updating a Text Box in my Workbook
Can't query the HTML
Finding a cell
SUmif and declared ranges
Checkbox control
IF....i think
IF...i think
editing strings
Combo Box & Tabs
Final Question
simple formula for next month
Excel 2003 Alert Messages
I'm stuck (again)
if cell contains.....
how can i link sheets in my excel workbook
provide sample excel data in assistance section
Excel crashing intermittently on save or file close - caused by vba?
Looping through columns
Load time overhead of VBA controls
Opening a different application from Excel
Load time overhead of VBA controls
macro in nonactive workbook
SEARCH EXCEL ARRAY FOR NON-VOIDS AND ENTER INTO ANOTHER ARRAY,
Vertical Alignment
If there are no values in row 37 delete it
VBA and the SumProduct Function
Extend to more columns
Protecting Code
Need VBA help
How to count COl3 with criteria in COl 1
Password protect only one VBA code module?
Delete Certain Rows
A recorded Macro to hide certain selected columns hides non selec.
Summing
Formatting zipcodes as text in worksheet cells
sort a range
vba code help
Image with mouseover text
Obtaining OS language
Dull addin menu item
Looping & Summing
copy data from 1 sheet to other sheet.
If Then Statements
Newbie - List Box & Buttons
Device I/O Error ?
Array Printing (Selecting)
Help with odd type mismatch error
counting Sundays between two dates
Border & Sum
auto open, auto close
Find Method
Strange "N/A" Problem
Is there an easier way to fill this listbox
opening a workbook without knowing its exact location
Programming using military time
how to use relative cell references with solver
Error resulting from coding
VBA quick help from a newbie
data transpose function
Previous active cell
Free Rolodex
Function to validate entries in a defined range
Add-in does not autoload on programmatic opening
vba help please
pull down list + value checking
copying from another instance of excel
if G>I i want A seleceted if I>G than i want C selected
Clear range of cells in different worksheet
determine range size after auto filter?
VBA to print Word Document
Using (what goes in here) for sub routine
One instance of ADO.Connection for all procs
intermittent error - ActiveX component can't create object
Search input box
Pivot Table Auto-Fill
Move user to another worksheet with click
Move user to new worksheet with cell click
ODBC Conenction Programmatically
Help, Macro wont run from a particular worksheet
download solver add-in
Userform Exit button
Read EXCEL table
UserForm-Code Problem
Help Processing Worksheet
Test for Open File
Check the value of a cell from VBA?
Pivot Table - Overcome col. limit?
Custom Function behaviour?
Why?
Combobox Problem Re-Visited
Userform Controls
ADO Recordset using Excel as a database. Can't free the memory once opperation is over?
Dynamic array problem
Keyboard problem with Excel vba
Running Access queries from Excel
Color problem
Pivot Tables
Secure sheets
Run-time error '91': "Object variable or With block variable not set
adding usr defined event procedure of textbox in usrform ??
Hide VB Macro Code
referring to tab label in formula
can I adopt this persentage code to use H1 as referance value?
how to modify address of data in chart
Writting a MAcro in Excel
colored baloon chart in Excel
Move to next blank cell in column
Efficiency in my code (a critique from the guru's)
Setting a formula with code in worksheet added
How to Select Range based on dates in cells
Workbook Title Line
Macro buttons tiled after print / print preview
0number
number1+ number2
VBA programs in Excel
How to enter array formula with VBA
question
Exch.Rate >> excel cell
Deleting unneeded characters in a cell
Returning Position Points from the currently selected cell
Need formula for calculating totals to range by using multiple cel
Referencing a cell in the header
excel vb question
Deleting Repetitions
Installing MDAC
why doesn't this caption property work
MDAC & MS Jet
macro to print a Word Doc
VBA Amateur - Need Help!
Cleaning up a web query
disappeared custom toolbar
Problem with basic looping and criteria
msgbox with no buttons
verifying an object exists
Invoice Numbering in Excel 2003
Help Please
Not Copying All Rows
Q about making a function
textbox sort
Userform Local Drive & Network drive question
Multiple column autofilter criteria? Possible?
.xll add-in Error in Windows XP "Not a valid add-in"
Behaviour of VBA ROUND function
How do I get more then 3 conditional formulas per cell
Ugrading MDAC
Macro for Word/Excel to create Photo-Calendars
Control objects in Excel
Loop
Using Vlookup in VBA code
If [something is of the format of.....]
Consolidation
Deploying and don't have CD
Date: library not found???
Find and Select
Combobox and named range as source
Some Help Processing a Workbook
code for combo box
Columns that will grab a value from a previous column, incrimental
Combobox on change event
activeform
Help to correct code
Excel macros occasionally do not run
Button - rearrange column positions in spreadsheet?possible
Formula syntax, "Object-defined error"
Delete rows from outside of Excel application
Loops
Hold closing the sheet...
Listen for a close workbook
Variable Contents Into Cell
Looping and then Consolidating
Paste a file short cut in VB form
Cherecters and fonts in part of cell
Universal procedure for changes
FILESEARCH OBJECT
Remove / Add code through VBA
Setting Excel Cell values using C#
Control Sequence from Userform Control
Userform Control Paste
FORMULA HELP
"XML parse error" in Excel 2003
formular to change data on a certain date every month
OptionButton in a Frame not visible
make a cell empty based on condition
STRINGS AND SUBSTRINGS !
visual basic example of the defunct "Extract" function in Excel 4.
Identifying repeat ID's
Copying array formula to a range of cells...
Link excel field to Acrobat files
Rows.Count
Looping through workbooks in Folder
Summing a range without making it active
Set focus to cell?
Prog. Hide range and indiv. columns?
HELP???
Report from a data table with check boxes
Disable PrtSc
VBA Command Tree
Data entry form with data validation - can I ?
aaaaaaaaaaargh Help! Convert UDF to Visualbasic
Label Caption Problem
vba code
Excel automation
Find & Replace : Keep the original format
sumif acting strange
Application-defined or object-defined error - missing the basics
Excel and AS400 DB2 database
value of chart scaling
Relative Reference in a Macro
FIND AND COPY
API in Excel
vba sentax
vbscript question...
resizing buttons
A file by any other name.......
Hash table code - anyone ?!
Deleting rows based upon Error conditions
macro changes on protected cells
List the worksheets in a workbook
VB for Custmize / Options
Workbook_SheetChange triggered to many times
Excel 2000 vs 2003
multi-functional cells in Excell 2003
String function in C++ called from VBA
Need help
Hiding Progress Bar
Protect Workbook
Excel button :: Filter columns by value - possible? Additionally, hide certain columns
Conversion of VBA to VB.Net
Changed cell row number...
Lose the clutter
Module Limits
set column type
solver errors
Error 424 - Object Required
MoveFile problems
Embarrassing Excel Macro Function
Find cell and determine value in current row
Problem with macro message
CommandBar Controls
ActiveX CommandButton gets renamed when Sheet is cloned running Excel97
Type Mismatch
Error: Nonblank cells cannot be shifted off the spreadsheet.
Nested Count if
Run add-in code when Excel starts
Programmatic font face problem
database with pictures in excel?
Digitally sign VBA Project at run time
Removing blank characters from left of field
LineTo in Excel
Excel and outlook
Macro for system
Lock and protect cells without protect the sheet
Select a range
Internet Explorer question - Refresh
Not deleting headers
F9 doesn't do calculation
Password lost
Option buttons in sync, s/b radio action
Match
Visible=false
Programming Project for hire
Programmer for hire
User Defined Functions
Listing files in a listbox
HELP using simple TRIM function on relative columns
Excel Interop Catch Event for Saving a file as xls and as xml?
Selecting first Unlocked Cell
CheckBoxes on MultiPage
Network question
Re: Error 1004 with Data Validation in VBA
Help needed to write a "SUMIF" formula in VBA
Access Error Using Excel COM Component
I/O Error Issue
Error with Multiple Recipients on .SendMail
Text length and TextBoxes
Data Labels in a Chart
IE User Name and Password message box
Formula with a variable in a mocro
Filling down a selection
Selecting a range
Excel VBA & ODBC Data Sources
& Filename
test
password protected
Looping
Auto generation of 3 levels of running number
Disable drag and drop for a selected range under a certain conditi
Print on PDF file
PasteSpecial error
Toggle a cell
Worksheet update from UserForm
Substitute chr(39)
Editing Custom Worksheet Menu Bar in XL97 & Associtated Macros
Change color of entire row and column examle
Interest that is Compounded Daily at the Bank
VB Script Formatter
Excel and Outlook
Mystery of the moving control toolbox combo box?
Selecting a sheet based on a cell
Spell Checking Text Boxes?
Workbook property telling number of sheets
Out of Stack Space error
programmatically changing priority of running excel macro at runti
PROGRAMMIATICALLY importing CSV data in a SPECIFIC workbook templa
prevent user from selecting and changing a sheet
Indicator
How to copy a CheckBox that is within a Cell to other Cells
No change event on control toolbox combo box when selection is the same?
export pivot table from excel to powerpoint
ebook
with -.find end with method
Problem with Range function after SP3 installed
Pasting ActiveX or Form Controls
Help with FONTS
Can you apply a template to an existing Workbook?
Programatically close a file without saving
How to Get Past the User Form?
Setting Caption for the RefEdit box?
Task Bar & Windows Title changes
List of FaceId codes?
button
Deleting Rows
Macro Tutorial
protected
Widening the Name Box - need help
Determining background color of cell, in &H0080FFFF& format?
Merry Christmas!!
2 more questions explanation
Copy & Paste Freezing Excel
Renaming Text Boxes and Buttons
Why does this not work?
Calculating results when data changes
How to programmatically access sheets in a workbook by code name
2 more questions
R/T Error encounter - Posted originally to functions ng - in error
Write Data to a database
Re: How to set multiple columns in "If Target.Column ="
Excel VBA Getting email Hyperlinks from sahpes into cells
How to set multiple columns in "If Target.Column ="
Code for Routing command
Problems with saving cell values to file
Can't save cell values to text file
Capturing the selected tab in a worksheet_deactivate macro
Prompted to save even after setting wb.Saved=true
PUBLIC DECLARE
atpvbaen.xls
Looping through Cells
sort on not active sheet
AND and OR in Conditional Formatting
Loading data table in a Workbook template
Calendar date in UserForm
Excel > Outlook
what was name of that function/method??
wildcard substitution in formula
Extracting attached files from outlook
Selecting total cells once subtotalled
Converting VB Code for Excel 2000 to Excel 2003
QueryInterface for interface Excel._Application error
Creating a popup via dll in excel
Possible to assign macro defined as private to a form control.
Question about installing MDAC
Deleting rows that dont...
Working with Charts yet again
Calculating totals depending on cell value
USer defined functions
Referencing a Defined Name
VBA: Hide username and password when opening a web page
Why did Excel ask me if I want to save?
Extract Source Data From Pivot Table
Can I reference a dynamic range within a indirect statement?
Protect Sheet with password through VBA
From Excel 97 Programmatically create access 97 or 2000 database and export data to.
Getting open file's directory, captureing user login ID, write access
using VLOOKUP from MS Access
Specify which method is default in custom class
Read Only
VBA: How to specify 2nd cell of currently active row?
Getting a spinbutton / scrollbar to "repeat"
Disable Option from tools in Menu bar
password
lining up columns in messagebox
http://www.rondebruin.nl/
Macro Error in 2003
yield function
Locking excel spreadsheets into fixed format!!!!Help!!!!
Password on Website
How do I change a worksheet in Excel by using a combo-box?
add to shortcut menu
MRP With a Pivot Table
SUM() function not behaving
open up a word document in excel
CODITIONAL FORMATTING
Pivot Table
Consider last 6 cells only
import data
can such a VBA code made?
tidying up VBA
Userform Control Paste
USING THE "&" IN VBA FORMULAS !
Color Entire Rows depending on Text in Column A
Holding form control values within VBA
Wrapping a Collection Class
Web browser question
UNSAVED: VBA Project
Widening the Name Box -- need help
Design Best Practices: Form Control Code in Worksheet or Module
How to capture the event before any sheet calculating in Excel
How to capture the event before any sheet calculating in Excel
Excel workbook saving problem in vb.net
Count specific numbers in a column
is there way to hide function from Excel interface
Drag and Drop Help!
Printing header on all but last page
Loop through Labels and Text Boxes within module code
Hyperlink question
Default macro usage to this workbook?
Late Bound Object Click Events
Re: Keep Chart-Delete data?
Multiple SeriesCollection Selection
ThisWorkbook.SaveAs not saving correctly
Button
Flow of control in VBA Question - Userform Interaction
dropdownlist/AdvancedFilter/shared workbook
Open PDF
sort by bold?
format
Setting properties of userform controls with VBA
Conditional formatting question
Passing variables from Outlook Macro to Excel Macro
Working with Sheet references
Inability to calculate a range in Excel versions above 2000
Average macro/program
inserting an excel document to a website
AutoSave
if cell is greater than "" then run macro
Number entered into cell is dividide by 100. Not fixed by Cell For
scanning and grouping entire rows
Re: Working with Charts
Loop through columns and then rows
VBP Project Password
Open Text
Adding checkbox within a frame
Stoppoing ComboBox Change Event from firing when Multipage changes
workbook open event
array "orientation" in another array
Work Book Security
Macro to Print Multiple Tabs with a Specific # of Copies
Record Macro - Record custom user actions
cell values
Width properties of drawing objects
combobox population
Web query and special characters
Data Types help ... Overflow errors
copy a range from another workbook
Removing a module with a macro
VBA: Download file from URL with password
AutoFilter Program
Better way?
Save from form input
Re: Keep Chart-Delete data?
Unique data in control arrey of textboxes
References changing between different platforms - DLL hell returns!
Unique data in control arrey of textboxes
Book choices
How do you get data to/from Access DB in Excel VB?
Data exchange between a DDE prog and excel
Command Bar position
VBA Code for Multiple Month Spreadsheet
what is the best way to add help to the template
how do I enable marco
Syntax error Q
Re: ATPVBAEN.XLA!Random Arguments
Re: Search filename containing words
Re: SPIN BUTTON MOVES
Re: Open a workbook as another Excel process
Filter by line break
InsertIndent
Re: ATPVBAEN.XLA!Random Arguments
Re: writing Macro in Excel
macro to run only under certain condition - how?
Is it possiible to target Appication.EnableEvents on one worksheet
Auto-lookup values between Sheet3 & UserForm & paste to Sheet1
Version number for Object model for VBA/Excel
Automated Execution of an Excel Report
Create a New Workbook
Dealing with Excel's Word-Wrap Limit
Re: Eliminating duplicates from a variant variable
Validating a long date in VBA
animate autoshapes
excel, dates and days ...
custom icons
How do you say "begins with"
Array Formulas
A couple of questions
Previous value of cell before change
Can I bring up a seperate program with macros? Hit a button and b.
Maybe Outlook maybe excel
How do i make a cell change color depending on the value being in.
How do I Bring a window to the foreground? *outlook warning
FormulaR1C1 syntax
How to use SAS data in a pivot table
Lookup on multiple sheets in file
OnAction Cannot find Macro ??
Print Area
Open an email and attach my excel file
formula question
Lost vba references and adox conflict
Excel range selection tool/control?
Using defined name as a reference
Partial Success with ChangeLink & UpdateLink
ComboBox methods in Excel VBA
array of arrays stored in Name: POSSIBLE?
how to parse data and move onto one row
Copy chart in C#
Design Question
Refresh Data Import Q
automate open/update/close Excel
Export from Excel to Powerpoint
Use checkbox to toggle between formula and manual input
Ref Info Tables
Tom Ogilvy - Delete Non-Selected Rows
Printing certain pages
automate open/update/close Excel
Column index name
Listbox initialized on workbook load
Disable page break preview button
Making Cells mandatory
Select method of Range class failed - but why???
Delete rows with common element
call stack question
experience with Oracle Objects for OLE
Delete non-selected rows
Update scrollbar in code without causing change event
validation - removal from whloe sheet
Simple Inventory Control Programs in Excel
Import a spreadsheet
Calculations
SpinButton Enable/Disable
formatting question
Excel Spinner Control disabled
Dialogue Box to populate several instances
Worksheet _Calculate event handler_how to use
create a form to find next
Tree Data Structure in VB/VBA
How to recover the excel program?
Regular expressions for replacements in Excel?
Varying a macro based on a cell's value
copy data from one worksheet and paste into another workbook
trigger an EVENT when the value in a cell changes?
Check date
problem reimporting a form
Active Directory and UserName
Call Excel from VB6 disabling macros
How to removed the first three char and last char in XLS
check box interaction
Disable Warning Message from Microsoft Outlook in Excel VBA
disabling keyboard
Create a pivot table tutorial for both Excel and Access.
Counting Unique Observations
Macro to check if data has been entered
How do I select a range of cells without doing Range("a3", "f3")..
Accessing classes defined in another workbook
Selecting a range in code
Select a range in code
Spinner Question
detecting keycode internationally
Reversing scores in a questionnaire
Programmatically saving a workbook to a ftp location fails
Cut Paste Coloured Text
format listitems
how spinner increases other cells
Remove "Missing" reference in VB-Tools-References
count non bolded items
Newbie VBE scripting question
I need to change the datevalue to date_text in a formula because .
VLOOKUP Compile/Syntax Error
Button to generate report
highlight non blank cells in column
Password protect parts of worksheet
Updating Worksheet Through User Form
extract info to another sheet..
External Reference removal
Change Logging
Giving Cells a Formula
Create a Helpfile within Excel
Macro Help Needed
Automate calculations
Can you use VBA to query an Access database without importing data
Validating a long date in VBA
RegEx in VBE code editor
Statement to give focus to a specific control on a UserForm?
VBA project password for builtin Excel templates
Message box to return curency with $ and comma's intact
The On Error Error
How to set Printing quality to Draft?
VLookup problem
Link Management
Hide all Excel tool/command bars except mine and reload on close
How do I program in VBA some Excel behaviours like colored-cell-.
Copying Cell Formats
Help with Header
Error Type Mis Match Error 13
Highlight a Circular Ref
Switching between spreadsheets
Select the end of a row plus 1
Comma Delimited Text File Issue
Forcing a Text Box to accept only Numbers
Error problems
Launch Macro on Result of Validation
Arrays
Move Text Up
Code Lookup for Number
How to add a sub-node of a treeview control
Import/Export Text File Tab Delimiter
SpinButton & Date Format
Beginner - Excel - Auto look up values from worksheet 3 from User
Excel.Application.Quit leaving Excel process stays active
When set to route, route with on open worksheet...not the hidden o
VBA VLOOKUP AND No Value Match
64kB limit error
Accessing Outlook from Excel
VPageBreak Problem
Help with Array Declarations
Filter Function for 2-dimensional array
How to create uniform ranges?
Subscript out of Range
Cancel Button on Userform
Assign a Date Variable within VBA Q
Number and date
how to music to excel conditional formula
Subscript is out of Range
Seeking Example Application
export many sheets to text files
Macro to run filter on existing table
funtions using FIND method
Copy and pasting sheets with merged cells
functions using FIND method
cdo
Handle Floating point rounding errors, efficiently
Macros always run
date stamp & appointment tru excel
Macros andfunctions
MP3 ID3 API Calls for excel
Copy and paste of sheets via VBA code that has merged cells
Creating a rectangle on an Excel sheet from VB
Removing HPageBreaks frrom Ranges
Possible to view more than one worksheet in same workbook??
various
opening a tab delimited text file
Unhide
how to handle 'sheetchange' event on 'add-in'
Use of ListBox with VBA
userform
Strange request Automaticaly send spread sheet as an e-mail
How to disable the Exit Button of UserForm in Excel?
How do I watch a variable change value during Visual Basic Code e.
SpellCheck msgbox text in VBE
Simple but frustrating
Just Excel VBA, skip rest
color formatting ranges
Data Import Cell Reference
Run a MACRO automatically by selecting value from combo box
Converitng Numbers into text (4 as four)
pivot table data item
Developersdex
Internet explorer object questions
ODBC / OLE DB QueryTable Editor Add-In for Excel
simple cell copy using VBA
DAY BETWEEN TWO DATES AND TIME
Open CSV files in Excel
Using VBA to run an Internet-based jsp
Office Web Components: No Open Method of Workbooks?
Multiple Level Subtotal Problem
before variable contains a value
Routing - macro to open routing dialog and then stop
Match
How can you fill an input box (user form) with the previous value
zero's in excel cell getting rounded off
Using Macro to Delete a tab in a file
ITERATING A SINGLE CELL!
Setting print area with vba
Tom O thanks...
Problems with application.Dialogs(xlDialogFormulaFind).Show
Move a text box without allowing it to be cut
Supressing Update Links Dialog Box
Shading rows of with similar data
sorting multiple rows at once (including merged cells)
Problem when programatically importing cell that contain numbers and text
avoiding VBEopen when using CreateEventProc:AGAIN
Excel 2003 RTD Server with Visual Studio .NET/C#
Removing Column and Row labels and menus from screen
Code to run on worksheet selection change
Returning Flags from Solver used in VBA
find replace macro
Last Row Variable
To access built-in templates: Software Solutions and Busines...
Finding Last Date Report
Controling Acrobat PDFs
Ordering graphs
Code Execution has been interrupted message
Certificates and Pvkimprt.exe
To to check whether a string is a valid reference
Application.screenUpdating = False
If (starts with ', then delete the ')
Looping Problem . . .Argh!
Data Validation
automate a function
active window
Flip Cells
Collection
cut off part of cell entry
How to call Macro(using ExecuteExcel4Macro) for a particular workbook
Text
Limit search range then loop thru' each cell...a bit stuck...
User Forms - Formating fields
Excel 2003 VBA - setting "iteration" upon loading
Does Excel do "just-in-time" compilation?
Excel 2000 very unstable as a development environment
rearranging data
Application.Displayalerts = value (is not working for me)
excel linked documents password hold in code
VBA Array Formula
worksheet menu bar
How to get my code to loop
blueprints
Selecting Workbooks
Excel Monthly Work Schedule
Question on application.screenupdating
Ranges
Force worksheet to NOT save
Using Advanced Filter through Macro
Merge two lists
Continuation of the listbox question
attaching toolbars to files
go to vlookup location
pay bill online
Two instance of same VBAProject....
VB6 DLL addin trouble
Advice for VBA functions using arrays
Formatting Text
Finding last Date Report
How can I make a 3D model in exel that will move according to exe.
When to code in sheet or userform modules and when to use modules
Macro doesnÂ´t work anymore
Setting Printer Options Programmatically
create a prompt box to perform a function?
Hyperlinks.Delete erases cell formatting
Use ADO to retrieve data from Access Parameter Query
Making blocks of text comments
Check Box Font Size
How to sort ListBox or Array?
How do I set up a user friendly inventory system using Excel as b.
Using Jet to read excel file returns blank for last cell - sometim
OLEObjects .. again
Sending keystrokes to Citrix ICA Client
Setting Onaction for File > Save on Menu bar using item or index numbers
Re: Excel 2002 - Commandbar.protection = msoBarNoCustomize
New to VBS and MSSql
Excel have a currency convertion tool linked to a live cur conver.
command button
Installed add-in promts for a massege??
Name parsing formula..
Need help Cleaning up Code
radio button on protected worksheet
Freezing the data in a column and moving the calculations to the next column
Name Macro
turn off the " replace file?" question when saving excel files
Force no save on workbook exit
Event to call before a opened workbook is recalculated
How would I select output to a file or Debug?
Pivot Cache Memory
linking excel and word files with vb code
Dates in Header
shortcut of macro
Subtotal for each column problem
Variable Range Reference
Links to Docs with Passwords... program in?
Radio Buttons Locked
Conditional Formatting Range
Select text in textbox
Validation
Programming colors on a pie chart.
how to stop program with loop by click "Cancel" button
SpreadsheetML <Data>... question
SpreadsheetML - auto row height
SpreadsheetML <ss:Data> using spaces and cr/lf
BeforeRightClick - XL2K on XP_Home
How to make R1C1 nomenclature work with SUM() in a cell ?
OLEObjects
Check Boxes / Option Buttons....
How can I set up EXCEL to show number without 3 last digits?
Trivial: Mouse scroller doesn't work for VB 2002, but on different PC with 97 it does...
Finding text in a string
Last Cell Scroll Bar Problem
Accéder à Excel en réseau
Add data to a text file
Pivot Items
Opening Multiple Workbooks from a macro with a twist
Problem with Find function in VBA
Dropdown box
Web Query: Username and Password.
Inserting A Row Macro
Printing to File using PrintOut
Event in a add-in called verytime a file is opened
#NAME? when using custom defined function
lookup in a range then vlookup from the found value onwards
Giving focus to a particular sheet
Importing text files
using a password to in connection with macro protectio
Defining Dynamic Ranges in Macro
Error 2015
Determining which template created workbook
formula in cells causing printing issue
How to create pop menu in macro ?
Why doesn't this work ??
Dynamic Arrays as arguments
Excel VBA keywords
Syntax for "intersection of this col & this range"?
savecopyas issues
Cell value while typing
cant find project or library
Excel upgrade to 2002
Making a PDF-file
Extracting the column letter and row number
Subtotal & #n/a problem
Printing a .pdf file
Sumproduct Question
Date Formatting Woes
XL RTD server
Decimal separators in formulas
Selecting Cells using dialog box
Debug.Print in a WITH procedure?
Change value of each cell in selected range by percentage
Macro - Insert&Label Column, if the labeled column doesn't exist
null value cell
VBA for XL OSX
HELP PLEASE
Function returns Range --> error 91
Range use on page
Run-time error 429 after installing Office XP SP-3
"Unable to set the ..." in Excel 97
Generating HTML from Excel 2002...tabs broken?
Colour number...
Radio Buttons
SendMail only one sheet, not entire workbook
Q: Best way to take data from VBA into graphs without writing data to worksheets? (Can a named range refer to an array in memory only?)
setting the caption in a button control
Active Printer Application
Dynamic Named Range repeat on different worksheet
How do I initialize a ComboList Box control from a range in an ex.
VB Project Error
Block REMarks in VBA?
Check boxes
Detect Workbook Name when using GetOpenFileName
Open a Word document problem
Define Range based on cell color
Opening/Closing a lot of groupings via VBA
VBA.NET
Database Question
validating 4 values programatically
Transfering Declared value through procedures
Extracting the Month from the Date in other cell
Special Character
PivotTable-Fields Page
hide negative values from a formula
Range as variable No.2
Excel marco upgrade
Links
Formatting Issue - Zero's not being displayed
it's going to blow!
Format date in footer to propercase?
HOw to create Excel user
Auto Filter
setfocus
Application Events / App_WorkbookOpen
Detecting active customview
Faster AutoFilter?
Referencing Shapes
variable row count 2
Move up text
7 Digits Only
Sheet naming
Data validation: using Custom, NOT List, to get non-blank cells
Need Macro to Find Column Heading -- if none, then insert new column
Keeping text together
saving a macro
Cell not refresh probably.....
? To Tom Ogilvy or others on VBA Listbox
importing a tab delimited file
How do i assure a pull down list begins at the top of the range?
Copying rows of data based on a value in a cell.
FileDialog problem
EXCEL textbook for self study
Props to Tom O.
%SYSTEMROOT%/Temp variable
Problem with VBA "Find" operation
How to track two values and work with the data in between?
Creating an Object on a Multipage
How to Find MAX value with depedency
olap cube (pivot table)
Type mismatch
Loop Through Highlighted Range
"Subscript out of range Runtime Error 9"
How does one get the PivotTable report info that feeds another PivotTable report?
Hide Cells
Headings in a Listbox
Code Does Not Work
Sheet Protect
Subscript out of range
dynamically create userform
set last used for getting directory
Automatically lock cells and hide formulas
Max Value within filtered range
selecting current row information and transfering it.
tick boxes on userforms
problems with XML XSL and Excel 2003
sumproduct problem
Tom Ogilvy or somebody else, please help
Create a search Field within a worksheet to search command buttons
protection
CONDITIONAL FORMULA
Inserting items into the Paste Special Dialog box
What does the "Paste Special Dropdown" popup menu do?
I need a macro that will delete every other row in excel.
Macro Delays
Re: Links using XLODBC.XLA not working after upgrade to 2003
Find two values and select data in between
window size
Question for T.Ogilvy
How to bypass "Enter Parameter Value" via macros
How to use FileConverters?
.filesearch trouble
Borders/Inserting Line
For..Next loop error
Web query - when does error occur so I can trap it?
restriction
Excel 97 to Latest Excel. Repair ?
csv for filetype property of filesearch object
How do I use a for/next loop to preform the same actions to every.
Cannot use .IsBroken property of a Reference object - error 48
Create Database
How select/define cells with FIND method (maybe together with SpecialCells)
Print selective pages - only if the pages's Rows.Hidden = False"
Borders/Inserting Lines
How to setup a program to print on lower bin tray
Help with Loop / Array / Ranges
RE: Points measurement problem
Hiding Cells
List box Setup from Varying 1d Array
macro to add additional lines
Printing worksheet excluding rows with formulas
Changes btw worksheets
Running of a Macro when Workbook is opened