Excel Programming [Archive] - Page 87

MSG BOX through macro
Business Days Including Holidays
Excel for football
communication between Excel files
Ghost Macro
Count If Is Like
Getting Zoom Factor
Add-Ins macros assignment
QueryTable date problem
Internet Table Transfer
runtime error: syntax error or access violation
runtime error: syntax error or access violation
XLA location
Lock a Cell or Row
How to Loop Through This Range and...
problem with 'IF'
Refreashing queries in multiple spreasheets
Adding items to ComboBox in a loop?
Find the value of a cell
Combobox options based on the input of another combobox
Issue with Run Time Error when opening file
help with find macro.
I want to close down excel after 1 hour automatically
Add reference to Acrobat Distiller
VBA and SQL dump changing the cell types in other worksheets
Open workbook Count
Flow Diagram In A UserForm
How to create a comboboxhandler
Select all from filter
Time
Check if the formula is in a particular format/style
VBA Autofilter
searching through a string?
Replace normal paste with Paste As Text
opening zip outlook attachments
VBA + VB Script fails to open the workbook.
copy and paste
little problem with inserting a formula
Macro or method for identical data selection/export
Go to sheet2
Lookup in Excel/Access
Importing data from MS Project
group for VB6
Change font and size of a textbox
Protect workbook
referencing workbook from cells in another workbook
Can project unprotect self?
Click on cell which imports data through web query
vba overlapping conditional formatting
Unlocking for viewing (in VBE)
MonthName function in SELECT statement
Using CTRL+END when number of rows
Unique category with sum
Save worksheet vs workbook
Hourly rate for custom Excel development?
Call Macro using right click menu
Disappearing buttons
If Then statement in macro gone wrong
How do i setup a macro to clear cells in Excel?
Excel Automation problem with AutoFilters
Great support from Microsoft
Data validation problems
COM Add-In Install Location
Source code for source code
Using Macros to Calculate Matrix Algebra in Excel..... I'm STUMPED
macro not working once filename changes
macro performing action if data is correct
help
Save button in VBE
Svae file within macro
WMI OBJECT LIBRARY
text extraction
Need code to replace part of a range within a formula with a defined name
E-Mailing from Excel
How do I hide a command button based on a condition?
Opening workbook automatically as Read-0nly
trying to trap runtime error when opening file without password
Macro for Print Odd and Even page
Newbie here: I have a question about a print macro I am trying to write...
Only print cells with value Part 2
Refresh Code Question
selecting rows using a variable.
acrobat document in excel
Formatting Text boxes for Date Entry
Pasting in code and clipboard message
Writing Fast VBA UDFs - London july19/20
Another Quick Question
Count selected Objects
Controls in a Frame
Main Page Button In excel
Matrix to a Column Report
True/False
Convert Macro .....
False and msoFalse
Counting Color Cells
Set Range Using Selected Cells
help i want to use old vb macro(excel95)with later versions
Delete .csv files in a folder
old vb macro
how can i create a consecutively numbered form in excel
Faktura og dato
Copy and transpose
Removing options on excel standard right-click menus
String manipulation problem
Set up formula to update when new column data is entered
Count Unique Entries
Open specific sheet depending on cell contents
variable not transferring?
Selecting objects
How to get entries on a list box on a form
Undo results
Need macro to filter, create tab on filter and copy/paste
Need macro to filter, create tab on filter and copy/paste
Reducing size of an excel file
Multiline Tooltip
Combobox change event only by UI
Want to prevent users from changing location of shape textboxes
Paste 2 arrays to 1 row
Is it possible......?
Excel 2003. Assign array to range
Lookup with several criteria: VBA needed?
Menu sheet <-> chart
Unable to get Match property of the WorksheetFunction class
Selecting Next Worksheet
Clear an XML Map of all content
Macros for graph formatting
Improve 'Windows(workbook.xls).Activate" statement
saveAS AfterUpdate
Working with Calculate Event
Treeview on a sheet
method Worksheets of object _Global failed
IF in formula
For Each - Next
spliting text
DELETE ROW 3 MATCHING CRITERIA
conditional formatting in vba
Select next object
Uncheck \View\Toolbars\...
How to delete a macro froma worksheet
Export XML via a macro
How do i subtract from a total number?
Only print cells with values
Indirect/Concatenate query
Easy Excel VB question (I think!)
improving workbook activate
userform parameters
Auto Color
Files\folders in VBA
Worksheet Copying.........crashes !!!
get information from other worksbooks
Conditional SumIf
Popup message when clicking on a cell
code question
Adding Sheet Controls
msoShapeRectangle --> Variable not defined ???
Sorting of Data
Delete row if cell has nothing
Macro to read and write data to multiple sheets
How to fill List in Combo Box from Design
copy and paste
PivotTable.AddFields
Get Top X,Middle Y,Bottom Z percent Records
Variable Range Length & .FillDown?
Managing Textboxes in a Worksheet
Pivot Table analysis
In VB how do I reverse a Negative number?
Creating Rules
MSComm help - working but with problems
Macro's no longer getting picked up from XLSTART
Multiple Questions
Width of ActiveCell
how to format double byte data
VBA: Auto Grouping
Removing and Adding Pivot Table Fields
insert menu is dissabled
Combobox | Add items | Object Required
Remove AddIn from list
Leave 2 macros after copy
Dependent List in Data Validation: Runtime Error
Commenting on Code
Convert Excel rows to pages in Word
Grouping radio option buttons
userform error
Print to PDF through Acrobat 6.0
populating cells with sheet names
Cell formula
Userform: Enter combobox value unless textbox contains data
Copying chart not refering it..
userform to display dropdown list of open XL files
Search string in cells for a criteria in a list
Re: export to csv macro
count
Transpose data from rows into columns
export to csv macro
Help with Event macro.....
Find a string between two delimeters and replace with text
Using a macro to select a print range
sending excel spreadsheets to mobile devices
How to close an open image...
sort date/time
check filename
Select a file out of a list of files
Time
mail a single excel sheet
My ChDir Statement doesn't work
Multiple IF statements in one cell
VBA Project still on the list despite the Excel File closed
ADO Connection
matching 2 values with a singel value
Enter formula in a macro
Custom DateTime Format
Using Vlookup to bring over a subtotal
Disabling shapes and controls
Close & save a file at set time only IF the file is open
Use a Macro to Upload Excel File to FTP Server when saving
Transpose Question
ScreenUpdating
Search table, data retrieval
Newbie question, XL2003, VBA deleting/adding modules in multiple workbooks
Select Far Right data in a Selected Row
Macro programming for Creating New Sheets and Copying Data
Numberformat issue
97 code vs. 2000 and 2002
Re: Sending Mail from Excel
Converting Excel worksheets for Access
Sending Mail from Excel
Thermometer Charting
Functions and macros - calling a UDF
Sorting, FIltering & Counting
access and excel
Range.Select 1st pass 13 cols, 2nd paqss 25 cols twice as wide in error?
HOW TO ALPHABETIZE EXCEL LIST OF NAMES
Changing the Negative Sign
Need help condensing with-end with code
Clearing DataFields
Excel Macro VBA Help Needed
Problem with dynamic charts
Help with Drawing Lines Using VB6.0
Possible to create a calendar box?
Questionnaire
questionnaire data processing
Quting excel from within application
Mixing Absolute and Relative Reference in a Formula
Names.add - Test to see if name already exists?
new way to filter
Delete Row
Functions that return multiple values
Do mighty exchange "pixels" on "mm" - cells (width, height)? :(
UK Excel User Conference - July 19-21
how can list data weekly,monthly yearly etc in ms excell
Recognising which is the active sheet
Request macro code - when cell change event
resize(Ubound, Lbound)
Insert Rows with Border Formatting
Cell Selection, Border Changing
Code stops when high lighting (Chips code)
Date distinguish
Result from many excel file sheet
AutoShape Copy and Paste
Cell data depending on column selected.
Query starts a "read only" copy of the source sheet
Forcing names of linkfiles
add button to UserForm programmatically
Searching for a file
Probability Question
Setting Solver Reference-programmatically
VBA & Command Line
Closing excel from a macro
SetFocus?
Excel 2002 (10.6789.6735) SP3 Macro
Save file using part of folder name
Help with inserting a blank line on condition
Parse csv files
Close a File and Excel ??
stop users from saving their file over "master" if same name
Capture range object address
See if a Range Name exists?
Pasting a chart to PowerPoint from Excel
HELP: Formula for combining fields
Max and Min VBA Statement
Excel/VBA possibilities
Anyone know how to hyperlink destination in a cell?
Test if value is between two numbers
Range Type Mismatch Excel vs Spreadsheet 9.0
trim
Immediate Window - Available Commands
Selecting multi rows
Stop a running Screensaver .
VBA Calculation Error
Convert an excel file to an exe file
Problems with calendar control
Split Field content in Query?
expose excel spreadsheet in web page
Santhosh
Input data form with drop down list
Text to Columns
how to use a command button in excel?
call excel macro from asp page
Entering the date before Automatically
Month plus one
trouble getting addin's workbook_open procedure to recognize activeworkbook
How to turn on Shapes conditionally?
Conditional BackColor Loop
Save as XML File msg !! (Macros)
Help with multiple sorts, multiple sheets
Check if named range exists!
If ActiveCell.Font.Bold = True Then ... trying to specify a range, not 'entirerow'
simple question
ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list
form stops execution
OnKey and Range Question
Add All Symbols and charecters of the keyboard to Auto Shape
Help with code
Add-In Madness
Downloading historical stock data from MSN Money to Excel via VBA
copy formulas & format of row above when inserting a row, but only on 1 sheet
how do i find an email and copy the text and paste into excel sheet
Print variable page sizes
load addresses of selected cells into array
Foolproof .find
Workbook open to the same sheet
2000 will Hang - 2003 will Open
Save As ... (using macro XLS)
How do I enable a disabled Autofilter in Excel
How do you get calling cell for custom function
inserting more than 65536 pictures into file using VBA
Inserted row must have the same format as the row above
MMult and MInv
MID function and SQL Query
How do I add a month to a filename extracted from a cell
removing duplicates in lists
renaming sheets
How to reference column by name
Add Database Names, table names & related fields from table in combo box
Find record in database
closest neighbour coordinates
Tom Ogilvy
VB interface
Exporting Excel Graphs
Change Format of Entire Column
Loop through a range of cells to find unique entries
VBA for getting files off internet
ot - Wanted: Excel Programmer Writers in RedmondWanted: Excel Programmer Writers in Redmond
Find and Replace in a DDE string!!!
The Shifty Lie of a Query Table
Statistical formulas across sheets?
Maximum data points for PERCENTILE function?
add a Text Box and a Check Box on a sheet
using variables in codenames
Book recommendations
How do I simulate dealing from a deck of cards?
Number Displaying as Date
Please Help: Paste Column Contents to Next Available Column Without Data
Select a Range of (Variable) Rows
Very weird - Code does not work until after file is saved???
Format Cell Colour if contents are Changed ?
Error opening external xls
Creating and renaming a worksheet from user input
ExtenXLS loads data into Excel 2002 file but damages the Excel file.
Where can I get a btrieve driver for Microsoft Query (DDE)?
Controls names as varible?
paste only if destination cell nonblank
Count number of characters in merged cells + adjusting rowheight
Relative Reference
Relative Reference
Clear Cell using Listbox
Weird range selection issue XL2003- help please!
Autofilter detection
Error using OnTime Method
How do i check if the current cell is part of a range ?
Worksheet Sum Question
UDF setup for a range of cells
Save As Event
Error on Import
VBA Code Reference to Solver Failure !
Disable Macro on real only option
Copy Button Problem
On Error GoTo ... But wait!
Determine if entire row or column is selected
Determine cell value based on list from other sheet
Conditional Button.
Analyst data and display results in new worksheet
Analyst data and display results in new worksheet
Activating an Open Workbook without using the whole filename as a reference
Closing one workbook with a varying name
Copy Special
Adapting an array formula
My customized toolbars/macros/Icons disappear. Help!
Referencing Controls Using Variables
sumif with <> ""
A little help with some code please.
Inserting Open Event code via VBA
ComboBox Change event triggered incorrectly?
How to Open a Word Template from vb.net
creating a macro icon
Copy and Paste Values ..... then Reverse !
The problem with comparison of text as well as the password from
Assign a macro to a hyperlink
Assign a macro to a hyperlink
NOT A VBA Question, I need to delete a row which has a certain cell value, can anyone guide me in the right direction?
named range in
not open xls if macro protection
Unusual Excel error message
Advanced filter in VBA
Printing from userform
Custom function for weeknum to Month i got some issues with this need alittle help
Modify code to insert borders
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER #3
VBA Code HELP PLEASE!!
Re: Project or Libary problem
RE: Format error
RE: Project or Libary
select non-locked cells
macro clash
userform control backcolour.
Range Name affecting speed of macro
NOW() function
Calculating a field in pivot tables
Re: Calculating a field in pivot tables
bi-dimensional arrays
Cancel Addin Install from Workbook_AddinInstall?
Refreshing data when workbook opens
Weird error
accessing worksheets from 2 excel files
Problems with Command Buttons Randomly Resizing themselves
vb.net calling worksheet by name
SubFolders in macro
Extracting only when column contains a certain value
save file
VBA: Generate listing based on another worksheet in the same workb
Embedding Excel graphs in Word
RE: How do you print the whole userform?
Macro Help - Loop Problems
Protecting formatted cells.
ShowWindow and reposition/resize after selecting an embedded chart
Adding a reference programatically
VBA: Tools -> Reference
How do I link one checkbox to update another checkbox?
match
Keystroke identification
XL doesn't like my path?
Using IsBlank in VBA
When a scrollbar is not a scrollbar
Match or Find Function Help Please
Linking using a variable in the path
Check box control
Help selecting a range in vba from userform inputs
Is it possible to ref a cell in another wrkbk w/o having to name t
How can I do date "calculations"?
Sorting data in non-contiguous cells
Run-time error 1004 on variable
checked the equal values from cells
Form to select 2 spreadsheets
Selecting Used Range
Compare 2 lists macro help!
What is Excel CS?
Combine data to fixed product id
Tom.... Please look at Printerproblem
i am working with excel sheet. in the calculation part i want if
Send an Email as part of a Macro
Userform combo box
What Does This Code Do?
OnTime question
Capture user input into xldialog print
Scroll bar - to increment btwn MIN and MAX value.
Max and Min Numbers with text
MonthName to Integer from Current to Previous Year
Next Blank Row
Could someone HELP TRANSLATE this simple psuedo code into MACRO pl
Re: Close an Excel file if is found it open.
Pivottable Field items code -problems
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER #2
Clearing a cell
Excel - global VB macros
How many levels of an IF statement is allowed within a Nested IF?
The x (close program) in the upper right corner is greyed out...
Sort across a single row
Sort across a single row
getting vba shell command to execute batch and save output to a file
UserForm
Working with Arrays, pasing from function to function
Method 'PasteFace' of objetc 'CommandBarButton' failed
Clearing all values in a User Defined Type variable
Printerproblem
Workbook not closed when OnBeginShutdown and OnDisconnection events fire in Excel Addin
Show one of multiple comment boxes based on value
If value is equal, if not a blank row is inserted.
Need help coping a range of data from sheet 1 to the next empty cell in sheet2
auto import a table into excel from a html
password protect macro
Apply AdvancedFilter in more than one columns
Need VBA code for Rnadom Number Generator
Random Number Generator help
public Function Error Excel 2003
Procedure name as variable
Listbox to generate 2nd Listbox
error trapping
inverse formula
Autofill
Data From Web
Mix of relative and absolute?
Passing a comboBox to a sub
Private - seeing macros again!
Looping through a user defined type?
Filter Problem
Hi-Lited Cell trouble
Conditional delete using saved macro possible ?
Neverending lines.
HELP - Stuck in loop
Printing userforms
Advanced Filters with Unions
creating template
External data retrieve timescale
button that opens open dialogs but saves path to sheet
Copy rows from excel sheet to a word document
Retrieving a Name of Cell
Help reqd with adding menu items!!
Macro to get comments out of a spreadsheet
Copying formula cells that really ought to be constants?
Timed Popup Message
How to open a macro?
Macro to copy from workbooks listed as http links
Reduce Flickering using Application.ScreenUpdating
Xls --> Xlt
how do i make a macro that will select all those cells that are empty
Opening a workbook, passwords and error 1004.
Last Row Variable
Tool tips or screen tips
help with macro about data entry with double counter
Truncating to two decimals
Browse for file name code? (Excel 2002 VBA)
2003 version of excel has no path default setup for importing dat.
enableevents in event codes
save in directory
Color of output
Command Button - On Click Event
Excel Macro: Matching and calculating 2 worksheets
Allowing a UDF to
How to add a password check when an excel workbook opens?
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them
User Defined type as Sub parameter?
Userform for time entry: multiple controls/single value?
template for fuel log?
Entering the same text into multiple cells on multiple worsheets
Excell Add Comment
Remove Vpagebreak or move to end of sheet.
Help in finding first empty cell in multiple ranges
protect tab
Ranges, adding a column to a named print range then saving the file
Help!!!.. Fuzzy Matching for Chinese Characters/Names.. is there a Macro out there?
functions in merged cells
code for seperating alpha numerics
splitting strings
increasing the size of a named range and saving it back to the spreadsheetI
Dialogue Boxes
Pivot table look for source data file
VBA scripting in Excel
Conditional Delete in Excel using Macro
color changing cells
Autofit Pivot column by Criteria
Command button to run calculation function
UDF Question
Issue with Hiding Columns
urgent : count of digits in a number
What Range property distinguishes a double from a datetime?
Multiple corresponding Values (Biff.........)
Clear check box macro
copy question
cannot 'save as' file in used excell file
Set Bkg Color if cell value is less than or equal to -14
count of digit in a number
How to stop warning message in Excel "initialize ActiveX controls"
NSIS VBA Add-In Installer
How do I set the time in Excel
count in a string
CopyFromRecordset fails if string > 911?
Run Event Code In General Module
vbCancel
submit button in macro
need help..
Getting the color for each cell in a selection
DDE Module Messing up Other Code
accessing another program from Excel
Getting color of each cell in selection
How so I make a "Worksheet_Change Event" to show cell changes in Excel?
How do I subtotal the same items from one sheet into another?
combobox list item with superscript
VBA "For Loop" Question
Display message box after each line of code?
Zip Code Formatting
Writing and reading from a template Excel file using ADO.Net - results not recalculated
What's the future status of xlDialogFindFile?
Userforms
Move cursor to A1 in all worksheets, relocate A1 to top right, sav
faster way to convert hex to ieee754?
Pause a macro after each line, run next after hitting spacebar?
Get info from Powerpoint 2003
Validate an Email Address
Excel Worksheet Change Event
Floating hyperlinks
external data file locations
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER
Q re program speed, with 15k lines of data
using a filedialog box from a dll
ListBox items paste into worksheet in reverse order
selecting sheets of the same name between two workbooks
Find New Entries in a List
Replace Return
problem with code
Insert and Copy Data to new Workbook Row
Increment numbers in column A by 1 when selected
Replace ^ in web query result
HELP ON SUMPRODUCT() FUNCTION
Circle equation in VB
Return ROW number from qa found range
Return ROW value for range found
Largest number in a column
listobject issue
conditionally adding a cell
Real Time Collection and Display of Data by Excel
Collapsing Grouped rows by Macro
test first character in cell
Display alerts
Excel Process Hanging ( Interop.Excel)
FTP uploading
adding a macro to a cell
Date Format
Resize and Transpose question.
N/A # and error 2015
Pls help me for data transfer from 1 file to other file?
Convert US date format to UK date format
Event handler
Similar to sumproduct...?
Row limit in Excel
how to display different content depends on some conditions?
MSFlexGrid Delete Row
Finding a date & Selection.End(xlDown)
setting print area
copy cell content only
Userform problem (Listindex)
Updating Excel data with a newer version of Excel data
Overview over lockd cells in a sheet.
Formatting Axis
loop on visible cells only
Customizing a menu bar...
How to stop Excel from truncating text to 255 characters?
web query: password protect (plz help)
PivotTable: possible to display Data Item field as it is?
Matching and calculating 2 worksheets
How do i delete all the rows lying below a cell.
How can I detect if the text in a cell is underlined?
ThisWorkBook problem
Identify and differ msoRectangle, option button textbox
Last row/fill in
Unable to Copy Add-in To Library Error
Personal.xls Workbook
workbooks damaged
Trigger Macro on change in cell value
inserting formula
Pivottable code problem
Userform problem
Where to start?
Accessing Tooltip Data in an Excel Chart
How to display Items in ListBox
Accessibility to macros
finding last used column
Get Info From Web
Excel to Word Run-time error 91
Passing Module to subroutine
Allowing User to save file
How to check if a range contains a certain value
Please help this teacher out
navigating to an unnamed spawned window ?
Macro to Simulate F2
How to Select All sheets
Help with Range Reference
CLOSE WB
User-defined type not defined
Runtime Error 1004 Unable to set the XValues property of series cl
How do I trigger a macro by selecting from a dropdown list?
Userform for displaying values from a row
Simple Question from Newbie
Random Name Generation
Importing large file
Cut and paste by reference part 2
Adding Colour
Toggle Subtotal on and off
Read Write Programming
Replace: Object Required
Check and uncheck a checkbox
Replacing "NULL"
Find/replace range
Convert clunky nested If statement to macro
macros
read outlook contacts
Converting Data Types
Track Changes crash when spread contains code or form
Excel constants
Some helpful UDF's
VBE freezes after running macros
Saving worksheets as filenames
Run Macro on Change
Lower case VBA
reference item
Date in VBA
Create Summary WB
read database
selecting sheet name in another workbook by variable (same sheet name)
read odbc data
Analysis between 2 worksheets
Checklist for testing code?
Autofill UP - Is this the Best Way?
Help with Wait X Then Go
Define range with activecell
Querying Excel document with OleDb
How can I create a project estimation tool with excel
Using Checkboxes in Excel
Excel slowness
fix for open/save file problem
Adding to cell ranges
identifying and moving matching values
passing argument in a function as integer problem
Macro Help to Compare Values in Two Separate WorkBooks
double image buttons
Feedback Req'd.
Save As Problem
How do I assign point values on survey answers?
Help with Looping I think
Passing multiple variables through functions
Selecting Different Workbook
improvements in telling loop to stop
A general newsgroup question.
set var to folder path using Open Dialogue box
auto numbering macro
Re: Cut and paste by reference
Macro Help
Directing the Printing using a Macro
Detecting a control in a cell?
How to remove the tab character from an Excel File?
toggle open files
Need a Macro that will delete every odd row starting at row number 1.
Keeping a running time total
Counts more than one
Insert a null value to keep format???
Slow 'FIND' when entering a value in Combobox
How to chain VBA applications
Storing variable values in Excel worksheet
Hide Paste Names
Un Protect in Excel 2000
merge pairs of columns
Excel - Access Correlation
Status of NumLock, ScrollLock and CapsLock
small fuction problem pass arguments
populate data
scrolllock key off
Help with Matrix
Function that makes excel work faster
display array in a range
AdvancedFilter
Help with updating query table from internet
Udf
Built in Data Form
Excel Exception handling Macro
Prevent Excel from going online when opening html file
Excel hangs...
SaveAsUI
Automatically populate combo box.
Find and replace again...!!!!
Re: Retrieve Data from Web site
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook
Create seprate files from multiple sheets in excel
add-in procedures called from active workbook events
passing range from RefEdit control
Row 1
mismatch error and Variants
How to make a file so that it can't be deleted from the system?
Excel Constants
Excel formula for finding next number in a given sequence?
Screen tips
EVALUATE SUMPRODUCT formula
Caculating Sales using If(vlookup())
Macro to sort data, insert a line after each group & then total?
Open filename using workbook property
Macro in a protected worksheet
Setting range object--Type mismatch if template not used
Reading Data From Protected WorkBook
how to create form fields in excel
Problem with Do While loop
trying to insert a formula
Circular?
DTPicker Control: Can you programatically fire the click event?
Excel Web Services in Office 2000
Copy/Paste Macro
Strange results...
Problem with VBA in Excel
naming colors
Worksheet events and a little bit extra code
Text Box Change Script
File Path
dead chart
Stopping Deactivation of a Worksheet
FileSearch - help
Why xl deletes 250+ rows using worksheet_change
Array or InStr Difficulty
Is there a Macro to enable a check box based on the content of a c
Statement to ignore step if does not find text to Split
Looking up multiple cell values
Msg Box on each Loop to Replace text
hi, i am trying to copy data to closed workbook
excel colors
Sending automatic e-mail from Xl
problem with array display
Calling user defined function from C/C++
How do I make a particular column required in Excel?
Lookup Values 2 Vertical variables
Quick Question re For and Next
Vlookup using a cell value as search criteria
Filter function; copy values to another sheet
Find method Returns
Referencing Spreadsheet in VBA
Macro to Select Specific Cells in a Range
Creating an Excel Workbook in Access/VBA - CSV to XLS conversion
error 28: out of stack space call function
Macro to Specific Cells in a Range
Display value linked to Combo Box Selection
autofilter and worksheet protection
dynamic msgbox?
pivot page field item criteria.
deleting form controls by code
how do I recover a deleted excel file or workbook
Getting multiple cell contents using a macro
macro output location
macro output location
Newbie questions - probably simple
Could use some help creating a macro....
Excel performance problem (Excel11.xlb file)
Workbook Variables
Circle in excel
custom number formats - including text from other cells
Retrieve Data from Web site
Comments Author?
Runtime question in vb vs. vba
Reference to worksheet range in R1C1
Show print dialog box
Random numbers appearing, calculations showing as zero
How to stop other macros while current macro runs
outlook vba
Chart Numbering problem
Display on-screen information
acessing text files using excel vba
closing the active workbook
copy calculation onto 300 sheets !?
call a macro from macro
How to count items in a list and group depending on size of list?
two question?
link a cell in the 'Master' worksheet list to a 'Detail' worksheet
UserForm - Last Active control
probability
Move rows from 1 file to other file?
month format
help getting code from ron de bruins site
Hi Need your help
VBA Training
object variable or with variable not set
Adding picture to page setup
Ignore blank rows to populate custom drop down list column range
Copy Duplicate Rows to Userform
RE: Regression results
user form-vba code
Conditional Formatting
How can I get a copy of Excel 97 to test my projects
?Module code copy
Interior Cell Colour - Conditional Formatting
How to later and earlier versions of Excel to play nicely?
Help with Code
What is the CopyOrigin parameter for in the Excel VBA insert metho
excel vba macro Please HELP!!!
FormulaArray problem
Re: Highlight Duplicate Data in each Row
Rename a Worksheet within a Macro
Re: Highlight Duplicate Data in each Row
Basic Excel functionality collides with VBA code.
Giving FOCUS to Print Preview
Using macros updates on Excel Workbook
Running a one macro on all sheets within the file
how to get latest input on an seperate worksheet
Need to protect with Password
how to manipulate text in one column
how to manipulate text in one column
Looping in a range
Pivot Tables-Calculations?
VB copy paste column data to another left to right sheet across sh
Selection.Autofill Destination:=Range(ActiveCell.Value)
datediff help
Re: how to get month and year from date
Re: Syntax - set variable to result of Vlookup
Automated Delete Item from ComboBox List
help to a very special split
rounding up to the 0.97
Instrrev function
Re: date comparison problems
Monitoring cells that have data changed
SQL Work in Access but not in Excel via VBA
year end sales report with old and new customers
Call Issue
Re: Find cell
Re: Date manipulation
Please help with this special macro
How to code with the R1C1 Style of Reference?
RE: How can i plot multiple histograms on one plot?
Editing color/msoGradiant of shapes, option button and text boxes
Extract the n word of a sentence in a cell
how to do that
Can the InputBox Prompt have Carriage Returns?
Application.DecimalSeparator
Re: macro in copied workbook fails
Buttons in lower portion of workbook appear in upper portion
vlookup with iserror
Can I use a formula that finds the smallest number that occurs twice in a column?
If I insert a row in my worksheet, I have to change the row manua
Beyond 1024 cell content limit
Help...code needed to ignore null cells
Incremental Counter Function in Excel
Eliminate blanks before a charachter chain
Active X Control Wierdness...
Active X Control Wierdness...
Would like to getback a MsgBox on error
For Each Next loop Through Userform
Possible to trap an 'Insert Row' via VBA ?
Help: Excel and Shell Command
Re: date comparison problems
excel sum miliseconds
check mutiple files with wildcard name and tally to differnt xls f
SaveAs - user pushing cancel corrupts the file
Re: Selecting a specific cell (that is data validated)
A Simple(?) Macro Question
Protected spreadsheet, but need to add rows
Edit single character within a variable
Data Validation - Accept Only Certain Numbers/Characters
Macro Help
Really slow code (just this one section)
Excel and Outlook Email Macros
ERROR IN CODE
Need a macro to loop evaluation of many textboxes in a UserForm.
Reverting to previous values
Run-time Automation Error
Application.DisplayAlerts doesn't seem to work
Re: Changing time format to numeric
Loading two forms
Re: Have to keep hitting the Continue Button
Conditional Formatting - HELP!
Concatenate error and Date Format Error
Case Statement Question
Is there a construction cost spreadsheet already available?
VBA to update Pivot table
Delete multi columns
Re: Help with using an activex control
VBA Help
Paste from Array to a Row
Display COUNT result in Titlebar
Re: Probably an easy question.
copy entire row to another workbook
if function
Re: Lookup solution needed
RE: CHOOSE function NOT RIGHT????
Re: Insert rows in the middle of the document???
Having to click a Cmd button twice to get it to respond
RE: Custom Date Picker Control
search for worksheet, insert new if doesn't exist
form
Re: CHOOSE function NOT RIGHT????
Referencing repeating non-consecutive rows
Need help find automate way to cross reference two GAINT excel databases!!
RE: optional parameter
Re: Date manipulation
Re: HELP TO FIND MAXIMUM VALUE
Re: Custom Date Picker Control
Re: date comparison problems
Re: Need to Customize Workbook tabs Context Menu
Re: Worksheet Rows
RE: Import
RE: Examples of using Bloomberg API / real time data with Excel VBA?
executing batch files using VBA
VBA doesn't like sharing a spreadsheet
Running a Word macro from Excel problem
Re: Form ComboBox problem
Re: Form ComboBox problem
Update links macro
Re: help me with this marco
Anyone actually get Case statement to work ... ?
PRINTING IN "VBA" (Excel) HELP :(
Man in the middle
Capturing time from server Excel 2000
Macro to add Button
Reposting - Help for Merging rows
List of the colors
Formula and text in one cell?
copy cells and insert them into another worksheet?????
speeding up copy and paste code
Speed of Applications in VBA vs VB