Excel Programming [Archive] - Page 51

set rng=
Find first empty cell in column J. Copy, paste special, value from
Worksheet_SelectionChange allow multiple ranges to be selected
Clear Contents
Inserting a "row" in an array
Filling up Forms
exporting the result of the SQL sentence(query) to excel
R[1]C[1] with a variable
replacement for filesearch in excel 2007
Check duplicates
Run vbacode if OLE-update from Word, but not on 'Workbook_Open'?
Persistent Data Structures in VBA
Beginner - Loop
Page Break Save
Problems designing combo boxes in forms in Excel 2003
Icon from arrow to Sand hour
error 336 (visual basic) ActiveX component not correctly registered
Utility by a MVP for comparision
Dynamically change the database a PivotTable references
copy formula
How to impose expiry date on MS Office files?
Cell goes invisible/visible at random without being referenced.
UserForm TextBox Font Size
Time Format
Date Format
how to set the zoom property
going to Today's date with a macro
add controls
Set rng for Column A only (ignores other columns)
conditionla format based on cursor location
Excel and HLLAPI
date reverts to serial number
excel 2007 windows class name
Tools/Macro/Visual Basic Editor
How to call this DLL?
Help on some simple code
End routine by clicking 'X' on Userform
A message without the box?
VB.NET & Excel, Inserting and Sizing Pictures (An Answer)
Copy Visible Sheets to New File
Open WORD doc from EXCEL using VBA
ShowAllData doesn't work with Protection
Compare two spreadsheet
macro code to open a file dated yesterday
udf
how to export data from excel to visual basic
Need a time stamp on Pivot Table refresh event
Excel to Access create new record
Help a Swim Team, worksheet function issue
APIs FindWindow and GetWindowText
Caption on command buttons shrinking
How to have textbox font color change?
XL03 - Cell Text value not saved
Saving / Reading dynamic arrays to / from disk
Custom Menu
2 dimensional array (variant)
Excel 2007: Macros not working in password-protected workbooks
Microsoft Office Division Getting Into OS X and Getting With the Program!
Help using TextBox Value
Help using value in a Form TextBox
For Each Next, Case Select
Spreadsheet performance
Excel crash when exiting with the Workbook open
Eudora does not play nice with either Excel 2003 or Word 2003
Find arguments
Copy and Paste LAST ROW of data
Re: Concatenation prob
Re: Concatenation prob
grade book
Protect and Share
Last Numeric in a Column?
create quotation template
Programatically Extend The Formila In A Cell
Open Workbook, Go To Worksheet ABC, Find XYZ In Column B
Insert blank space
Delete last row from range
Macro to re-number data
XL 2007: Conditional Formatting not saved
SAP download Web page to XLS
Finding data links
RTD C# implementation on vs2005
VBA, How to make data dynamic growing along with another sheet
ADO SQL Query, Possible to leave the Recordset open outside its Su
Menus with sub menus...
calculate average from multiple columns and put results in a new s
find cell address of first non empty cell in a row
Macro help
Adding custom icons to toolbars
[OT] Norman Jones?
Linking Cells
I need help with macro's
Best way to make column lists out of row of cells?
Password for a module only
Page Header to Include Variable Values
Activate macro after clicking on a particular cell
ARX Load issue
VBA help w/ look & fill in data
Code to Ignore Certain Cases in a Looping Function
Inputbox with a drop down?
Error with macro after recording
Excel 2003 Bug regarding autofilter
Problem Loading Addins - Excel Started through COM Interface
Web quieries and memory
Locat a cell
Is this posible to do?
How to delete individual rows according to criteria?
Array Pointer
SumProduct Function
Before Change Event?
RE: I want to create a Year to date button for a pivot table
How to run an AS400 macro from an Excel macro
VBA Excel
Email Excel VBA/CDO
Copy-special pasting a table via an excel button into a word doc
Change offset to same row...
macro writing formula
A tricky one: anything like an array of functions?
Cell input to automatically divide itself
Insert two lines each time a value in Column L changes
Copy and Special pasting into an existing word template
is there a vba way to search for ### in columns before printing
Vista slows down simpel printing macro
Using Web Services in Excel 2007
Collating data from two or more "Workbooks" into another "Workbook
Highlight/remove duplicate rows
running varibiables into vba
UserForm Initialize Problem
Windows XP zip problem
Validation error when worksheet is protected
Supressing MsgBox poop-ups from VBA
Set Range with Variable
VBA WMI Intermittent Error
Insert a cell into a defined place (or bookmark) in a word doc
Best practice for deploying a VBA system used in multiple locations?
Copy a Sheet & Rename based on Cell Value Q
macro to run go to
using a cell reference is Vloopup to access external workbooks
add new row
security warning
Unpredictable results with Macro and VBA
command button in a frame: strange phenomena
Sorting Data
Can you do an Autofilter on defined names in a worksheet?
case
Rename and save without overwriting the exisiting file
Incrementing numbers
Deleting range
Looping and deleting thru cells which values offset
Finding Start Date
How 2 convert all of the excel tabs in one xls to a word file
Cannot click twice on custom menu in Excel
Excel 2007 problem trapping Mousup event?
HELP: Use the autofilter result on one workbook to filter the next list on another workbook
Filter on Color
Procedure Too Large
How to write the macro for not match two excel sheet
combo box value position instead of text?
VB controls fail to "load"/show
Macro to Export to a Fixed Width txt file
Help regarding random sampling
checkboxes
Data lookup on 2nd excel sheet.
Macro that moves to a cell using two variables See below
Seclec
Strange behaviour of autofilter
Replace 1 word without opening Files
Print Custom View Macro
hiding columns
check for #N/A
Passig a variable from one module to another
Joining similar rows macro
programme fucntioning problems errors
Excel Crashes When Importing Data File
VB.NET & Excel, Inserting and Sizing Pictures (An Answer)
Copy cell from Excel file and paste into control on internet page
Find Multiple Occurence Of Text In A Column
Weird Macro Happenings
Multiple print-area
Forms,dialog boxes with lables.
Capturing 'Cancel' on Applicaiton.Dialogs(xlDialogOpen).Show FilePathAndName
fill down cells (column) using ctrl-g
Memory Protection fault
Delete Spaces from text download
Excel VBA
2 sheets and code
Autofill is overwriting the column title.....
Application.VLookup Problem...
How to change data in a formula
smart doc
multipage control
Excel VB
Passing variables back to main procedure
Refer to control on userform from code module
If Checkbox
multiple webservice calls on same server session
how to write to macro to only delete rows under certain conditions
Auto-calculate after a cell is filled in - Macro is looping!!!
Activate code when sheet is deleted
select range of specific hidden worksheet of closed protected work
Hiding individual worksheets with code
Comparing cell to array
Select ranges of data with a macro
Text box - Accounting Format
Macro's to select an increasing range of data
Transposing rows/columns in an array
Run existing macro (in module1) from new button (on a worksheet)
multiple cell reference
Select for printing
Copy / Paste Value
Add Menu Items
Excel undo stack
Auto-calculate after a cell is filled in - macro shouldn't be loop
Contract VBA Programmer
error calling webservice from excel
SUMPRODUCT with a Twist
drop down menu
How to Compair two Excel files using Macro ?
HLOOKUP on Two Ranges
How to select a full column in excel using C#
Find in row
variable cell index
Excel RTD Server
veriable to constant
Date type
Macros for WEB Query with password protected site
Do you want your PowerPoint presentation to really stand out.
Rosters
Using MATCH function in VBA
Loops always trip me up - and here's an example
Save vs SaveAs
Input Box data validation
What is the difference between for..if, case statements, do..while?
Add 2nd condition to Find
Set text color to interior color
Events To Execute Code
Command Button On A Worksheet
Transfer Variable from Form to Module
Page Breake to left
Excel VBA. Setting the default path for GetOpenFileName
ignore blanks in dropdown
Runtime error 1004
is referenced
Insert Command accidentally deleted from Cell Menu
pseudocode help please
Problems with ClearContents in Excel 2003
Is Multi line possible with MsgBox
vba code format
Change from userform view to excel workbook view
Display **** instead of password
do something for each sheet
where do you put programs?
Help with Lookup
compare
Transpond text to public statement
adding border from userform
Macro to move row to last row
Add column # dynamically in row 1 of a particular worksheet
Aligning Two Sets of Data That Share Only Some Values
Using a macro to input data
Toggle between Desin and Run mode
Set a worksheet object on Open that doesn't die?
Simple macro to hide and show detail - Grouped Rows
formula correct - display is funny
Input Box Vs Cancel
Move cell contents along using vba?
open ftp with password
Auto Copy based on criteria in colum
File size of web file via url
Macro to grab "inbetween words" from a text
Making a row coloured if spacific data is anywhere in it
Test For BLANK Range
Fast way to add two array in VBA
XL 2997 Quick Access toolbar icon size
Search All Files Find Newest One Report To Excel 2007
GotFocus event
Calculate
Compare cells in different worksheets
Need help with For Each c In Worksheets("CV Table").Range("B:B").C
Applying formulas if certain cells are changed
Subject: Setting a range from a refedit control
Manipulating Word Range object in Excel
RTD only alive when Excel is active app?
How to use VBA to automate sorting, cutting & pasting in Excel?
DTPicker Default value
Set as default
Position of X-Axis (Top, Left)
Displaying graphs on userforms
Can I auto move a row to the next worksheet if criteria is met
Add-in developers input needed
Using a custom function as a spreadsheet function
Macro Runs when the user changes any cell on the work sheet
Disable macro's
Chart error
graph range varying depending on dates
Changing inherent sheet name NOT tab name
Select variable range
Iterate Thru Cells
How to cretae a web version of an excel/VBA program ?
Help Needed-Error Code 429-Excel 2003
Lock Keyboard input
Copying across workbooks
Running "String" of Code
Refresh Ms Query Every 30 seconds
hi all
Formula in userform textbox
Move down the cells in a column
Move through the sheets of a workbook
formula needed to copy named range to another worksheet
Call to a property is setting all items in collection, not one
Running Macro
Change data value in a range of cells
Time Triggered Events
Classes and Userform: Passing it around
get all cell address
Custom Form Closing
listbox
suppress unwanted rows in a Pivot Table using VBA, dropdowns & Vlo
UDF + range object and Offset formula to Value problem
How to protect a textbox in VBA/Excel 2003 ?
Wild Cards
option button question
PIVOT POINTS
Saving Totals Row to Separate Worksheet - Next w/o For Error ?
How to programmatically determine actual page count in Excel 2003?
Sharing excel reference
J can't delete old macronames on the list
Put Value From Solver In Memory
Check value on another sheet
Deselect a Commandbutton
date form and workbook with autofill for date
appending worksheet records
Need urgent help
Do...Loop syntax help?
Entering Dates MM/YY only
Copy Invalid Dates records to separate worksheet
Parent/Child Field
application defined or object defined error
Locked for editing
K factors (tolerance limits)
Making a camera picture appear/disappear
Automatically move to new cell after keystroke
select for choosing
image control
Imprt data from SQL based on cell input
Disabling row and column headers option
Cube analysis addin with macro
Fastest way to reset to zero an array
Displaying an image while code is running
filling dataSet
Translating a list word by word.
Is there a way to read lines of a module
Converting cell content into comment
Assigning named range to a 2-dimensional array
Excel Import - data limitation
putting a dynamic report on the intranet
Ctrl-Alt-Shift-F9
Error Handling Problem calling Macro from Other Worksheet
Extract a YearMonth value from a Date
Run Hyperlink by forms button
Create new agenda
Getting values from desired sheet for printing.
Common routine for many menu buttons
Change cell value to next in series upon opening worksheet?
cshap
automation error the object invoked has disconnected from its clie
a code to trace pure numbers formatted as Text
2 different fonts in chart title?
time sensitive file?
Insert formula into cell
Extract DB2 data to text files
Pull-down list for chart filter?
Vlookup in VB
Advanced 'filtering'
How to draw a raffle ticket?
Excel 2007, ThemeColor Light and Dark reversed
Pop up calender issue
Prevent user moving the userform with mouse
creating functions
Excel 03 crashes if explorer settings for showing file extensions are changed
Copy once and paste five times
Launching animated video file from within Excel
farve Ã¦ndring pr auto i cellerne
Copy unique entries
How to Autofit column when cells have Wrapped Text?
Running multiple SAS jobs using VB
How to change where ctrl-End goes (last cell of spreadsheet)?
excel 2007, setting .maximumscale is very slow
import database tabase
Getting data from excel sheets on different machines ??
Find instances of value in another sheet, copy row and highlight cells
Discretely open workbook with password?
copy and paste formula +1
Hiding VBA code
Run macro ever 5 seconds and turn off?
filter by column instead of rows
Force VBA countif to find string, not value
Why is this looping
.Select
Font Picker
Font colour change based on Rgb codes given in specific cells
Opening Multipe Files Via VBA
Win
Win
count the days between 2 dates and convert
Using variables in Rows.Select
UserForm TextBox
Referencing UserForm event in module
Where to start - need external app to update spreadsheet
Sheet vs. Worksheets
running a programme
Search cells code not working
Selective Automated Printing of External Files
Code reqd. to generate Loading Slip
how do i amke fuctione
How to retrieve subs and functions names of a project using VBA ?
How to copy automatically from sheetx to sheet1
Update multiple sheets at once
$ dollar signs causing issues in Excel VBA - HTML
Programmatically using Range to update chart
Insert sheet.
Empty space as "zero"
CheckBox to select pages to print?
ProtectScan
enum - howto make columns correspond to numbers?
Vlookup, hlookup, match ???
How to reset the values in a Form
Count the Number of Variable Rows
Simplifying Excel Recorded Macro Code
Memory Leak With ADO kb=319998
How do I remove data connections with VBA
Position DataLables on a pivot pie chart realative to their Points
how to send a html message from excel
Userform on top z-order?
Unwanted procedure
print a static date from a barcode
How do I coppy a range from 1 sheet to another via IF statement
E-mail XLS file
Cannot kill a WINWORD.EXE instanciation - Sorry for reposting ...
Pull stock price from web, format in Excel 2000
a
Application screenupdating not working for everything?
"Hot spot" in a spreadsheet that will duplicate the cell's entry to another cell, or to activate a macro
Stopping a Macro from opening an Excel File More than 1 time.
get min and max from array...
ERROR Checking Before Running Program
Invalid Links
VBA changes my date format
convert Microsoft Excel 5.0/95 to ms excel 2003
Detect if an excel file is open
Weight Watchers Quick Tracker
text centering
Hyperlink question
Help on coding
Misunderstanding of Objects please clarify
excel 2007 chart programming tip
show input box info in a message box
UDF -- Application.Caller problem with RAND()?
Multi-column combobox - allow text to span columns?
HPageBreak and crazy error (Excel 97)
weird macro
Insert columns and split text
whats up?
whats up?
HELP Why so few contributions to office.developer.web.components G
excel
Sending Email via VBA
Cannot debug RTD Excel
Annunciator alarm time stamp
Check for same Names in cells
User-defined Function With Varible Number of Inputs
Mass File Column Insert and Name
Find same value in continuous Cells
Problem with Error Handler routing?
Fetching 2 values from 20 excel files
InputBox value in formula problem
Changing Font in a Cell
dropdown
Finding unique entries in a column
P & L Calculation Help Needed
Hiding Rows in an Automation Addin Function
Resize the radio button
Missing Macros from Workbook
Creating a drop-down list
If Then and Copy/Paste
Copy worksheets form one workbook to another ...
Populate Worksheet from ListBoxes
How can I display a warning if calculations indicate original data may be wrong?
Geting data from Excel .xls file
Getting Cell value to another worksheet
Excel auomation Performance problem!! Need help please!
help!!! macro request
Programmatically signing Excel VBA Macro
Referencing range name in calculation
Restricting available dates in calendar userform
Save as
Column Widths
How to make a trendline invisible?
Need to save changes in a external linked file
VB Editor
Edit Word Table from Excel using vba code
Is there an object containing the sheet names for a workbook
Sort Without Knowing Last Cell
Print pooling
how to make moving headline in excel
How to retrieve procedures ans functions names in VBA ?
Print problem
evalute error
Code Reqd. to generate Loading Slip
Copy Paste all data tough filtered
Coding Standards
Hide formulas in cells
User Form for Survey
Finding Print Range
Need help with adding a range name
Problem with UserForm
In VBA Excel, how can I restore individual cells?
RE: Complex Question - XML Validation in Spreadsheet Web Component
calculate the time between to dates and times
'Floating Bars' chart type removed in 2007?
Saving a paragraph of text onto a sheet
prevent second workbook opening
Programming an excel workbook to work in Word (not a programmer)
Efficient way to drtermine if a string contains digits?
Help with loading multiple files from userform
Unable to share workbook because of hidden module on userform1 err
Loop problem, I think
Macro Error when I leave sheet
Convert SQl to VBA so that it executes in VBA
cleaning up text macro by Alan Barasch
Almost done, stripping/cleaning workbook for posting
shape object
How to align cells in a column to match the entry in col A
Open new Word file via Excel
Add values in formatted cells
multiple if's
COUNTA error in Excel VBA
Clear clipboard memory
Showing 2 series on the same chart
Automation Q
Wait for called program to finish
"Order Custom" sort option
Modified Date lookup
Creating multiple formated text in a textbox.
MsgBox without buttons
Page Break while sizing to fit page
Copying Excel table to Word, with Formatting
MVP Certification
Copy Range while CutCopyMode=xlCopy
Retrieving Info from workbook on ftp site
multidimensional array
delete row countif result
Works in module but not in project
problem with percentage in cells
Loop Problem
Right mouse paste
Divide by zero
Email/CDO/VBA
Need contigency plans for data transfer ...
time comparisons with now()
Printing multiple (selected) workbooks
Macro to delete a macro
Problem with SUMPRODUCT
Requesting virus scan
How to execute a program and return it's output to me in VBA.
Count from cell b71 to last cell
Excel Help
Extracting Year from date cell
Disabling Paste Options
Highlight row if condition is met
how to parse through pivot filtered items
Throttling DDE's Thread Count or CPU Utilization
Modify existing code to dynamic code
Excel remaining open on workbook exit
Converting Paste to PasteSpecial Values
Cannot kill a WINWORD.EXE instanciation
Adding vs Concatenate
Inserting Row
List & Text Box Problem
Last updated cell
Sheet.Select is not working - why?
Workbook_BeforeClose trouble
How to open a *.Vba file
caption property in command bar (excel 2003)
alternating format
action upon selection
sorting language
Send file to Bluetooth using Excel VBA
Preserve Excel undo stack
Open Folder Help required
Open a folder
the go to formula
Accounting Software Import
DSUM vs sumproduct
Custom Toolbar Icons Ugly in Excel 2007
Help with code to sort worksheet, please?
Cell displays ################# instead of the text
Position DataLables on a pivot pie chart realative to their Points
Add formula to cells in a column through VB
Display and Hide a text or Auto Shape box
Programmatically delete Module1 from a workbook
Macro independent of newbook name
Problem entering percentage on form
cell value storage
Help with CreateObject
Template Files
Some Files Can Contain Viruses........
View Code
Protect Cells
Pivot Table Columns
String Comparison Not Returning Expected Result
Using Paste Feature with out Activating Sheet
How to calculate based on Validation LOV items?
Any library issues when giving XL2003 wkbk to XL2000/2002 users?
Change pointer to hand over button
Updating OLD code
have calculations from sheet one calculate in table on sheet two
Pivot Table Update - Data from GP Dynamics
ABMS like sim stores model
Select a range in an unselected cell
Compare Range Totals After VBA Manipulation
Delete Space
Open file on password-protected FTP site
Stacked Bar Charting help needed
Stacked Bar Chart
Daily Updating
How to display columns in the right order from a SQL DB query
to make pictures move in excel
Using a "SHELL" Command
controlling excel recalculation in VBA?
Automatically update a sheet from another
"Too Many Cell Formats" when merging files
Rename rather than overwrite existing file
Making Excel 03 count product usage by month
Adding comment to cells not working with merged cells
Border around each printed page
Referencing across projects
Restrict user's ability to paste into cells
Macro to Save (As) a file
Recommended header when hiding multiple columns?
VLOOKUP
IE automation, Frames content reading problem, excel 2003 and 2007
Shared Workbook - Slow opening of shared workbook.
ActiveX warning after control is deleted
Modification of existing code
VLOOKUP
Need help with COUNTIF in VBA
Protection using Username
Inserting pictures into cells (Excel 2007)
Get page orientation of active sheet in Excel 2007
searching in the list of dates
selecting cell under a button
sÃ¸gning i liste af datoer
Select chart object in Excel 2007
Change Sheet Format to Tahoma
Application.DoubleClick question
how to create the formula for that attached explanation
macro to disable auto refresh
Refreshing user defined functions
Unable to close 2nd user form
need help
need help
Excel 2007 Menus
Start/Repeat/Stop Macro at specific time/interval
excel 2007, problem with msgbox and custom help file
Excel/VBA source book?
Data types Cells
How to stop calculation on open?
Help
Universal time
DoubleClick on embedded object(shape)
Cummulative total in Userform
Desable "Cancel" event
Compare Column Headings
Keeping code dynamic when adding columns to a list of records
Just upgraded to Vista Macros unstable
Loop Not Working
Code to open links
how do i protect a worksheet without disabling drop downs lists?
How to write late-binding code in XL VBA for Word objects?
VLOOKUP
VLOOUP
Terminating autofilter removes commandbuttons (xl2000, not in xl2003)
¤â¾÷²M³f¦U´Ú¦U«¬¸¹
Conditional printing
chart source data code
Conditional Formatting based on data in adjacent cell & restrict save without required data
Manipulating Notepad from Excel
Are objects slow in VBA?
Close doesn't always close
add check boxes in a list in excel
When does DoEvents return?
Highlight selected cell
synchronizing folders
Get Last Row
Frustrated rookie trying to create a custom form
Call an addin Macro from Workbook_Open event
Delete Duplicate row and Copy to another sheet
VBA program to limit date
trying to count the pagebreaks in the immediate window
Inserting contents of a Word document into a Userform in Excel
Selection.ClearContents for data only
Can I have two worksheet_change events in same worksheet?
vba
object required
Functions that return arrays
Macro to password protect
Excel Sheets Opens Itself Again After ADO Query ! Please Help It's Urgent !
Select case or If then
error 424 object required
Looking for help with a sorting macro.
copy cells
copy cells
Evaluating 3 Variables
update file list code for excel 2007
Email on value change (Formula)
issue with RefersTo in non-EN languages
Mkdir with 2 variables not working ....
import text to Text box
Print multiple files from File Open screen
macro opening a file
Identify open Workbooks
SAYFA Ä°Ã‡ERÄ°SÄ°NDE
Using a macro to do a calculation
Automating Calculation of Lagged Cross Correlations between Variables
Application.GoTo.Reference query
Excel and VBA - If and Find Expressions
Generating a column based on import file name
Stating an area in vba
Sumproduct in VBA
How to get the screen resolution in VBA
NOT ABLE INSERT CHART
Selecting non adjacent cell ranges
Using Indirect Function to Intersect 2 Named Ranges
excel 2007 Seriescollection.Add bug
Data import, carriage return
Data import, carriage return
Excel 2007 ListObject question
VBA code for pressing "down arrow" in recording macro
Ranking and real time manipulation
How do you store data in Excel as a database?
Need Help
Condition form
Accumulating values from one page to another.
Adding Columns in Excel 2007 (2003 Compatibility Mode)
Question about rounding.
Do Until Loop Help
Problem opening a word file from Excel
Do Until Loop Hlpe
Hyperlink from cell value
AutoFit
Deleteing a worksheet
How Can I reference a the * cell in a list?
Turn off error dialogue
Find Last cell copy UP
Importing many text files into one excel worksheet - how to?
Extending Selection of Column to the next Column to the Right
data table function
Rows outside of current range being saved as CSV
vba autofilter two columns
Website Excel Spreadsheet for Non-Excel Users
Variables into autofilters
Reducing Color Intensity in Excel?
Row number changes in conditional format formula during VB executi
Using "IF" with a "NAME" search?
What is Add in
Collection::Item runtime error
lookup multiple values
Selecting tabs in a multipage form
How to delete the duplicate name on columnA
Requesting Help (yes again) Translating a Macro into VB.Net Code
Get cell name into MsgBox?
ODBC excel Macro help needed
Payroll calculations
Sync
Read Variable from Another Module
Custom Cell format
TESTING FOR EMPTY ARRAY
Extract Values from a String
excel workbook time log
Select range of rows/Columns?
Tools/Add-ins displays unable to read file
Compacting or a Summation of several different lists into one
Excel object "Access denied" error
.HTMLBody
"is now available for editing" problem with Excel-automated mail merge
Using Find on nonactive sheet
Lopp Formula
Executing a command when clicking on a tab
Loop from a to z
Need elp comparing two columns in VBA
command button for open sheets
Start macro "on load all information"
display hidden controls once check box activated
Web Page Hyperlink not executing from Access 2003 query export
Find values from one worksheet in other worksheets
Programmatically turn on Track Changes
Pivot Table Refresh Speed Issue
effective rate, debt issue costs, loan interest with varable payme
Programming Function
userform for multiple sheets
eliminate N/A error when using Vlookup
External data and password
Internet connection check via vba?
Is there a way to release the memory taken by a Recordset Object ?
Update hyperlink value with cell value
Move multiple worksheets to a new workbook
Using a macro to open an existing workbook
Using ADO to Query Excel
Using ADO to Query Excel
set a range thats not allways the same size.
Array formula in a makro want work
Macro doesn't run under Vista
How to determine order of row fields in pivot table
Finding a user's My Documents path
Overriding the overwrite confirmation prompt
Unauthorized Movers!
monthview calendar question/ want the calendar to display weekdays only..
A Pictures Puzzle
a defined name not working in Excel 2007
Help with Macro
Set up a time line tracking schedule
Isolate Numerical Data in Cell
Move data from a worksheet
ExclusÃ£o e InserÃ§Ã£o entre Planilhas
How do I select the 2nd sheet from the Right in this code Q
PasteSpecial method of Range class failed
activity duration
LOOKUP filename construction
Counting data
Multi-threaded calculation and VBA
counting data
Get Cell Contents Including Formatting
Re: Opening Windows Explorer
Some Help Please to Translate an Excel Macro into VB.Net Code
Open Workbooks, Used Area on Sheet
Copy worksheet
Macro Help in Excel 2002
Text parsing - Extracting data from inconsistent data entry format.
Transfer userform contents to Sheet
Search for Partial File Name
Delete a row based on more than one condtion
how to copy workbook names and worksheet names to columns in acces
Sorting Issues
User form return values
Can I Designate Cells "Not Available" Without Raising an Error?
Programming
Impossible to close excel without saving message in internet explorer
Running another program out of excel
sorting text in a string
how to select multiple charts on a worksheet in excel 2007
custom format syntax ques
Joel, Would you contact me on your reply please? Thanks
Trying to close Excel file nut get error msg
Closing Excel
Find text in column
Deleting duplicate rows
dynamic clock in excel
Incremanting text
Opening Excel Workbook More Than Once
Formula to get number
Copy down Multiple cell
Excel 2003: Stop Screen flickering
Excel 2003: Freeze Panes with list boxes
must read
PACKAGING & DEPLOYMENT WIZARD/FEATURE
Position DataLables on a pivot pie chart realative to their Points
Help in Excel 2002
Change Log with prior and new values
Macro syntax problem - Dean
Status Bar
how to copy content AND formating with vba
Adding cells with programmed data
Custom Menu For Each Sheet In A Workbook
How to Delete VBS code via VBA
Insert > Field control in Word; Link to Excel Sheet
Pass listbox values to autofilter
DOS access from Excel
Activate speech when sheet is changed
Format Date in Save AS function
Making a footer 2 lines
Automation works with Excel 2003 but NOT Excel 2007
strange...
strange...
chart works in excel 2007, not 2003
Cond Format if cell contains Values INSTEAD of a formula
Save As with Cell Verification
TypeName of a UDT
Format Cells for binary or hexadecimal numbers
Creating separate workbooks based on filter
Status Bar
update links
Help with mastersheet
Any way to programmatically make pivot tables behave more like data tables?
Pivot table calculations
Open File Using A Wildcard
Add VB Reference
Calling for a particuler item of Excel 2007 help
Font ColorIndex, Ws Change Event
Parsing names from one column into 3.
copy cell format
Sub that will not end
Looking for help with a sorting macro.
more excel automation trouble with ms access
How to get username during workbooks.open macro
ms access 2k automation problem with selection
Autofilter Criteria not filtering when using NOW()
Running time of procedure increases
Enable / Disable Command Button depending on a cell's value
Setting worksheet properties
track whose make changes
reduce if statements
Does a worksheet exist
HELP...anybody got any ideas why this is running so slowly......
TinyGraphs - Open Source Excel Add-in for Sparklines Generation
Duplicating Formulas
Avoid Startup Prompt on Excel 2002
The same event handler for two CommandBar buttons
Preventing Copy-command
query after refresh question
VBA code outputs currency value rounded to 2 decimal points
Using user function (vba) with sqrt(array)-only first answer
Getting vba code (macros)
Barb - don't worry, I got it working...you are a lifesaver!!!!!!.t
Sum cells, excluding hidden columns
2 Questions
Creating a Running Count
"Bouncing Bar" progress indicator control?
Creating number formula to count number occurences in a data set
Make non-modal form an inactive window
Validation Font Size varies
Clarification
EMail Outlook failing
Unprotect a workbook while opening from Access
Very Slow code
Deleting alternative rows
Creating Reports in Excel 2002
Conditional format over a Range
1004 error on function for printer
speech function and variables
Code to cut and paste text from continuous cells to make a document such as a memo or narrative
Array or Something in VBA
Trying to shade cells
2003 user forms in 2007 macro
¤J¾¤À°±æ
¤J¾¤À°±æ
Excel Error
Working with data in Excel
Pivot table creating isue regarding columns with the same name
auto sorting data validation list
Security - Post user infos on the internet
Copying a Range When Rows Are Long Variables
Best way to do this-fill down formulas, cond formats, etc only in certain columns?
Delete worksheet row based on condition
Stack area chart - keep the same color for each item
Repost - Autofill today's date Everyday
Scrolling Message BOx
Vlookup code needed
Deleting Rows Based Upon ListBox Selection
Date Macro if B is populated then date in A
E-Mail Importance Flag Q
Collating of data from 2 or more sheets into one sheet
Macro to Insert New Worksheet
LOOKUP VALUE
Conditional naming of copied worksheets
Duplicate Pastes into a table for a draw
Using Find in VBA
UserForm VLOOKUP result in textbox
Find and replace "?" character
A Sub/Function to cause another Sub/Function to Exit
"sumproduct" ??
Find date, create new workbook, copy lines with same dates in column H
Converting a 2007 document to a 2003 version
Run-time error question
Disable moving sheets
Add attachment to CDO email
Change passwords on fly
Custom toolbars in Excel 2003
Bottom Cell with VALUE
Run-time error '5':
Excel / Access User Conference - Oct 24-26, St Loiuis
Import Data from web-sites
Pressing TAB doesn't exit TextBox
Dynamic Stacked column charting with VBA
VBA 2003 and XP compatible?
A "+=" Operator like in C?
Formatting Active Cells
Slow Function
Subtotal function
Populate dataform with combobox1.value
Update links without warning
Dropdown event in validation cell
Convert any documents(Word, Excel) into BMP, GIF, JPEG, PNG and TIFF image
Poor humaneyes
valadation malfunction
Poor humaneyes
Poor humaneyes
No Blank Cell
Control Toolbox Design Mode
Reference 2 separate workbooks!
Evaluate vba matric