Excel Programming [Archive] - Page 143

creating a formula in textfield
VBA Stmt Format to Get Contents of Cell in Another Book
Simple way to convert UTM ED50 coordinates to decimal coordinates?
Excel VBA - Win Lose Streaks
inconsistent date conversion
ListBox population from Excel range
ActiveX Textbox question
Program issue w/ VBA on next row
SMS with Excel.
Check to See ( Find ) if a Value is in a Table
Need a function to keep track of total data.
User selecting range from userform via dropdown menue
looping and objects
reading xml fields into excel
"enter" event of activex combobox?
VBA to Email Attachment
DAO Excel to Access
Range Selection
Unable to Lock a Range
Re: Running a macro in another workbook
Storing Cell Values in Access
List box to reference another workbook
parsing HTML table into excel. How?
Restoring Screen Resolutions
Can Excel load data of volume 50 mb and analyse also by adding 25 mb more
External data references in a userform control
search worksheets in different workbooks
download .csv file indirectly from website - long
Changing filenames using theSaveAsCopy method
Beginning forms
dynamically changing chart y axis using spin buttons and worksheet_calculate event
Sort Macro
Help with VB and Excel
Unprotecting worksheets with a macro
Scramble password a little bit
User/pass prompting code
Conditional Row insertion problem
Write to Output Type Formating
Add menuitems to the VBE
PageFields in 'Rows to repeat at top'
Filtered Visible Rows & VBA Non-Filtered Rows Displayed
Can You Re-Create this problem?
ADO
Applying the find fuction to a button
Disable Format Painter?
worksheet change event > error events disabled
Help with VB and Excel
Userform
VBA for changing a defined name reference
Re: Bad DLL
Help! Please!
To cut rows from a sheet with multiple blocks of data
Workbook BeforeClose Bug
MACRO TO EDIT CELL FORMULA !!
count and sum of dynamic range ????
Loop Problem
How to keep excel from crashing?
Network detects if Windows Username is online
After GetSaveAsFileName question
What Is "Me." in Visual Basic Coding?
Print Last Page
Alternative to InputBox
Edit points, how to show that view at the end of a macro execution
Icons
Avoid error with simple subtraction function
question
Application.GetOpenFilename
Re: Automatic Bolding and Background Coloring
Re: Automatic Bolding and Background Coloring
function to return positive number or zero
Adding Code to the This_workbook module of a created workbook
Saving variables in XLA's
ComboBox text resizes on it's own
xldialog
Formula too long
Forms
Run Time Error
Application onEntry with IF then statement
Excel VBA - read a WS and show results on another
CHANGING FORMULAS WITH VBA !
FILTER SHEETS BY NAME
Problems with reading files
Error whil reading file
Querying Password protetected Access DB with ADO
Grater than or less than formula
adding a month onto todays date
Vlookup from a a different workbook with filters assistance please
Using the COUNT funciton to count cells with values
Exceeding Max. (32,000) Data Points in a Series
Re: Variables
ADO Connection stopped working
Re: Bad DLL
Doing it's own thing
Bypass Textbox Validation
Conditional Formatting using VBA Code
Pour ecrire dans une cellule
How do I copy a Form from one VBAProject to another
traversing through a filtered range based on another filtered range
Newbie: Excel Macros and Personal.xls
Hanging Instances Of EXCEL.EXE?
save macro to personal.xls.
Deleting Unneeded Records
Averaging a dynamic range...Help ???
VBE dark red highlight
Weird macro mistakes or goof ups - copy of original post
Conditional formulas
E-mailing pivot tables
Inputbox as Date
activate unknown workbook
Userform size limitation
'portable' UDFs???
How to access ranges in closed workbooks in custom functions
Assign .value with the Mouse
Can you implement a custom format with VB code?
How do I run a macro from a .xlt file
Date Time Picker Control autosize
build POS system using MS Excel
How do I select a range using VBA?
copying values form one workbook to other
Define an array with variable size
Fill series in visible cells only
Finding a Row and cut and copy
Last Resort
Keep Listbox values when closing workbook
Check for Enter key and change focus?
Macro Memory ( Paging File ) Problem
Conditional Formatting question
select workbook
File input though some kind of windows interface
Excel2000: Reading Named Range value from VBA
Help: Election 2004 Project -- Iterative Operations, midmean
After oledb inset in Excel, 'Cannot Access file' error on Excel
Treeview/imagelist problem
string manipulation
How to: check if folder exist, if not, create
Event procedures (and the temple of doom)
Error
Saving sheets with VBScript
Defined Range Problem
Count
Find the table height?
List Box Control out of control
Issue with Excel Macro. Unable to insert quotes before and after the text.
Variables
Convert to a Parameter Query
copy data from 4 worksheets to master?
Template opened while being populated
Solver Reference in Hidden Personal.XLS Crashes Excel 2003
Single quote in a where clause
97 to 2000 Refresh pivot table
Program question
Variables to Comments
How to format a Date to a Real Numerical Date?
call a vb function from a cell
Detecting Text Numbers
Excel VBA Macro - parse data
Runtime Error 1004 - Method Range of '_Global failed'
Update Sheet from Formula.
Re: Digital signature/certificate
programmatically open VBE and go to a specified procedure in target module?
Excel 2004 Can't Disable Auto_Open Macro. What Now?
2 column sort
Install Addin in Excel
Help with Error Message Box code
Can you bypass excel generated pop ups.
Formatting Repeated Values
Is there a way to call selected sheet's name from on deactivate event?
Re: VBA Question - How to print a frame within a template
Sorry about the last ones...And statements with IF's
Re: runtime error 9
Excel 2003 Save as Bug
Timer
Excel Pop Up Code Required
Excel.exe not terminated after spreadsheet saved
Programming in VB
0 with ADODB Recordset
Weekly report help
MACRO: How to change cells to negative value
Re: populating a cell with text w/ line breaks
Printing Pivot Tables
Solver not Using Constraints when called from VB
Reset Variables
Re: VBA Question - How to print a frame within a template
Pivot Table
Prevent copying sheet
How to avoid excel adding a 0 for cells with a formula
problem with Rows.Count and comparing cells
Prevent formula from deletion?
defining an event procedure (lostfocus) that works on a column range
Application.OnKey problem
Excel VBA - getPosition UDF
Excel VBA- Time delaying macro
Database usage within Excel
Query - SQL to Excel
Re: UDFs and file sharing
Help w/code
Import of multiple .CSV files into Excel
auto name sheet w/ macro or function
Combining Macro files
METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file
File Path Class
Macro virus prompt
Error "Permission denied" when printing Web Browser control from button on userform,
Running average without nonzero values or empty cells
PivotCell class
Draw lines in a userform
excel - data merger in two cells
excel - data merger in two cells
Non-Modal InputBox?
verify cell if is the same
Keeping add-in private
How to split column?
Macro to copy and paste
Search and Replace
Re: Default File Path
Saving and returning to saved screen view? (Pan L/R U/D)
Splash
Re: Default File Path
Excel \ Access Time issues
Message box causing error in code
clearing VBA worksheet names
Adding Message to Spreadsheet
Function to loop through a column and return a value based on an x
I dont understand....
Serching in document
problem with macro for pivot tables
Excel version reference problem
Copying formating and function from one Column to another
Excel VBA Access Database Error
PasteSpecial
Re: Macro virus prompt
Re: Macro virus prompt
Macro virus prompt
suspending-interacting-resuming
Undo stack
text case
"Application.Function.Text" doesn't work
PROBLEM FINDING MINIMUM
copying complete column incl. formating
searching for a combobox.value and filling in textboxes from results
Exporting Date to Text File
Combining Macro Files
Named Range - Empty columns
Need to calcualte depriciation
Last open
delete row or col
Increasing the width/height of cells programatically
Excel VBA - go to worksheet "name" based on a cell reference ="Name"
Knoppen en werkbalken
Access closed workbook range in Custom functions
Formatting the linked cell when using a List Box User Form
List Box Control
Finding the last used cell in a column
Adding new worksheet using VBA
Creating a monthly back up using Auto_close??
Testing for an addin?
test cell for text string; return value if condition is true
Array of Values from Worksheet Range - What does it 'look' like?
"Radio" Button help
Access closed workbook range in Custom functions
Addition to existing code
Macro to write to webpage & query results
disable close and shrink buttons
Another FileSearch Problem
Excel to generate reports in Word
FileSearch inconsistencies between Office/Windows version combinat
opening a text file
Strange problem: spreadsheet locked when macro is stopped
Macro for auto deleting row if cell value = x
Change Database name in Query for a Pivot Table
Is it possible to increase Excel's availible memory?
File open with Path Name
hi I want to add the results on comparison with 2 fields.
scrolling through rows
Vlookup Macro to return Values only
Excel 2003 XML row consolidation
Is it possible to increase Excel's availible memory?
A VBA function to give serial date for date and time?
Loop including IF statement
ActiveSheet.ShowAllData shows everything - way to have hidden _not_ show up?
program formula to ignore any cell displaying "N/A"
VB.Net DLL Using Excel Named Ranges
Update Links
Adding "And" clause in SQL string causing SQL Syntax error
Excel VBA - Repeat for loop until blank rows
Nursing shifts
grid references on a map
Dynamic Range in Macro with R1C1
Logging users accessing a spreadsheet
ListBox Scrolling in VBA
Textbox updating other Textboxes
Question about auto_close
Running a macro in another workbook
Macro to email excel workbook with static recipient and auto subject
Re: Creating a Directory from a user input
Dr Watson is pushing my head under the poo....
Events problem
Re: Automatically finding the last row in a SS
Manipulating a Filtered Range - I know its been done
Re: Creating Excel add-ins from .Net
Updating Access from Excel Macro
Vb Application to locate a worksheet depending on the radio box selected
Selecting two ranges of unadjacent cells
NotePad
Re: Automatically finding the last row in a SS
Weird macro mistakes or goof ups
Problems running my app more than once
Apply a Macro to a FunctionKey... (again, but with correct email address)
Re: Referencing cells to VB
Re: Automatically finding the last row in a SS
excel vba problem - function calls from cells
setting ThrottleInterval generates Run-Time error
Custom Command Menu Bar Part 2
Alternate row highlighting with a difference
Jumping to chart based on listbox selections
Apply a Macro to a FunctionKey...
simultaneous run
Re: Edit all footers
listbox shrinks to a line when changing between sheets if I use the visible property
manual adjustments
Re: Macro to remove pictures from cut and paste
Create combo box dynamically
Print Command on a file
Protect Microsoft Query
ActiveX / C++ - Extra menu item
Building a Named Range in a formula with VBA
Message box causing error in code
Taking content from worksheet,loc it in another, and if exists. copy it to a third...
VBA Interchangability going higher?
randbetween function
Backup macro running twice
Line Interpolating from X-Y data set.
return screen view
How to save the workbook1 from workbook2
Many users for an Excel file in the server
Command Button Code to copy data
Close where no password?
Macro for unprotecting/protecting worksheets WITH passwords
Write cells fro one file to a specific place in another
Can I stop Excel program flashing on screen during run
Enabling a menu item
Find last empty row
VB Code to stop cells being deleted
RE: Custum Excel RMB Context Menu
User function and Open Event
Finding last row that is empty
VBA Alternative to Vlookup
Returning the value of a named formula
SQL Combining Field Results
html markup to specify data type of cells in Excel
default mail program -activeworkbook.sendmail
Auto Close and Save
Including a variable number of columns in Excel Sum formula
Online Resources for Speeding Up Code
Searching Data
Parallel Task (Threads) in VBa, is it possible?
copy shape image into image control
Group and Outline by marco?
Determine start column/ end column of Merged Cell
Call VBA Gurus - Help to Optimise two small UDF's
Biff8 format documentation
sorry this is just a test if i can post
Macro crashing on different computer
VBA help on one of Jon Peltier's Charting
concatenating cell names?
Excel equivalent of 'Keep lines together'
Copy sheets from A to B without reference
Getting started programming a UDF.
ListBox Headings - customized!
Print sequence sheets
Input Boxes & getting tied up in knots with strings!
Disabling/enabling events with a button created by code??
Import and Rename Files
VBA Setting .Value to a date does not respect local system setting
Embedding Command Buttons in a Text box or List box
Deleting Row
Disabling Save Pop-Up
Refreshing a custom Function
Shape names
Textboxes
Retrieve Macro description
Insert Character - Built-In Excel Commands
RE: Conditional Formatting Help Needed...
hide
Subtraction formula
Limiting the scope of On Error
Suppress add-in confirmation message
custom command bar question
conditional printing at top of page
Upload/download a file
Macro that changes Drop Down Box
Excel Programming Help
Specifying position of new Worksheets via C or VBA
preventing input of illegal characters in an inputbox
Updating Values (don't want to be prompted)
Saving a file from a command button with user input
Accessing MS Project from Excel
Solution to Mouse Wheel Won't Scroll in Visual Basic Editor
Excel formula
Workbook Open Event
Column and row references of range
Enable References
Matching Values to Zero
Generic Plot of a Bollywood Musical
Sorting 2 Linked Arrays [Retry]
clipboard forgets on call back
How to thread
Editable Combobox?
Excel Formulas to Clear/Match/Filter Entries
Dynamic Chart Range and Chart Update
formula calculation when cells are changed
Re: Detecting Row Deletion
Windows 2003 Hosting
RE: Detecting Row Deletion
Sync scrolling on two textboxes
count value in column and VBA
Counting specified words in a column - macro if possible
Returning the correct value from a pricing grid
Array Formula in VBA
Excel via intranet Display Alerts problem
conditional page set-up
Command Button Question
Prefix macro
Re: Print Single Statement Help PLEASE!
Startup
I need "On Error" help
Countif
Remove multiple duplicate cells
the best candidate gets its first choice
"Copy Method of worksheet class failed"
Macro to create pivot table/ chart
FTP From Excel
Drill-Down Pivot Macro
Draw border above specific text string
Excel VBA - Newbie: Auto deleting cell value
Function to extract values
VBA PROBLEM - Running Macros!
Read variables from AutoCAD
VB activates unwanted function
"OnCancel" syntax?
Calling Excel Macro From Vc++ via DDE
Cumulative Year to Date Chart
Profiling Excel
File systems
E-mailing through Outlook via Excel VB
How to Select a Row in VB Macro
How do I solve this?
hiding toolbars
Excel VBA - Cells Counting using VBA codes and displaying results in msg box
highlight current day in the sheet
MSiInstaller error, when opening excel with Web app
Import Makro
Find and Highlight
COM server timeout
Macro to delete columns and set print area
timestamp
A Macro to change macros? VBA problem
Importing Text file from a server
How to find out the size of a variable-size array ?
Floating Toolbar
Formatting times
Printing Footer
How to use macro to dynamically add the VBA code and data together
Hide rows
Changing a row colour automatically based on a cell input.
Copy cells from xls file opened in browser
"Radio Bottons"
Re: Start Excel from send menu
pivot tables from ASP
Macro to find blank cell
repost: connect two rows of data
Determine the last column of data
Re: Memory problems in Excel
parsing cell format correctly
Quick help - SQL statement in Excel Macro...
Random Sort (Can anybody Handle it)
Excel crashes when copying worksheets
Workbook_BeforeClose
Protecting a book protects too much?!
Thanks renegan
Word Picture Object question
Excel VBA - using yearfrac function in VBA
Macro - Doesn't work in dedicate module
Determine exctent of selected range
Close an Internet Explorer browser window
Extracting Information From Excel To Outlook Keeping Formatting
.visible property causing an error in Excel 97
Inserting rows syntax + row #'ing code in protected sheet?
Copying an Entire row using an IF Statement
Hide Combobox
preview chart problem!
VBA Frequency FormulaArray Syntax
Header Font Color
RE: Changing characters
DDE excel and VC:Urgent
Re: using a macro for a fill
Viewing help for user defined functions
VBA code problem
Activeworkbook.range ---> Not supported by VBScript?
How to programmatically remove an AddIn (xla)
windows for experts
Userform conditional fields
Automating PowerPoint
sum
use of "formula"
Copying an Entire row using an IF Statement
selecting used area
subtotalling using vba
Re: moveing values with macros
use Vlookup for sum all found value?
change cell value, but keep formula
Excel VBA - changing variables during a loop
variable Question
User message
Macro for worksheet protection
Cancelling AutoFilter in a macro
Chart series (not starting at first year)
Excel File Creations thru VB
Problems about the path of the Add-in file(xla)
Re: Copy a range from different worksheets and place in another worsheet
Retrieve item names in ListBox
Counting columns, adding totals #2
Further ActiveX Control (TextBox) questions
Sending text into the cell below
Another code for deleting row
real time sharing in excel
selected numbers to disappear
Format question
Not sure what to name this subject
Macro to update all worksheets in workbook
returning number of subscripts? MyVar(x)
need help understanding syntax for adding a page to multipage
UsedRange
2 conditions in Worksheet_Change event
Combobox list
Summary problem
Opening a Form from send menu?
Memory problems in Excel
ActiveX Control (TextBox) question
Save as PDF Using VBA - Excel 2004 Mac
Code for deleting entire row
solving a matrix in Excel
Prevent Duplicates
Search and Delete
Possible array formula?
Formula
Open excel in safe mode?
Writing a DLL using Visual Studio 6 to return cell address!
Tools | References - information about references
playing sounds from cell value
printpreview freezing
hiding macros
Complex Reference Problem
Dim... As ...
Anyone in atlanta area that can fix up existing excel macros
Outlook from Excel
Need some syntax help, please
Trim or Len help (I think)
Time Calculation
DataSeries Method
Worksheet Tab Click
Formating a Time Calculation Result
Error 1004 when selecting a range
Displaying multiline Text into Excel Cell through Interop
VBA error 1004 "Select method of Range class failed"
1004 error when selecting a range
Re: VBA to check if there is a data series in a chart?
How to find the last row and column
Combo Box Drop Down Area
Macro for Confirming Delete
Reference range in formula problem
print minus value in red
error handling
Strip date from string and transfer datetext to number
Conditional Formatting Issue
Macro question
Insert Code Problem
Macro error 1004
ActiveX Control Properties
Highlight Check box
I need to Sum multiple columns by referencing one formula
Re: can someone help me with this problems please? GORD YOUR A STAR :) thnx BUTTTTTT!
Calling Rob van Gelder - Help needed with Vlookup Macro again
Array formula range size
Distributing All Days Across Months by Chip Pearson
Distributing All Days Across Months by CPearson
Comparing and deleting duplicate cells
Merge Cell Question
Condensing Data onto a New Worksheet
it's a problem about multithread in vba：
Running Windows-Excel macros on Macintosh
Command Button font size increases when clicked
Data validation input message
can someone help me with this problems please?
macro triggered by a change to a cell
Function to resize an array
Saving Excel WorkBook as WebPage Thru VBScript..
Sorry for the attachment. new and just trying to help. It will not happen again.
Simple database w/ vba excel
Help with find and replace routine
User Form activated by a macro
ComboBox
is there a way....
Summing every third cell
Counting columns, adding totals #2
chr(160)
Pivot Table: Show columns with no data
Merge cells, Wraptext & Protect
Save compared results to new work book
Count new occurances and not repeats
RE: hide unused data
display edit | fill series dialog box
Re: Logical test
vba select same cell across all worksheets
Re: Changing characters
Re: Changing characters
Excel custom toolbar / DSOFramer
Searching for zero value within a selected range
Re: Popup calendar
Unable to record (macro)
sum of hours
Accesing vba project from wb that has vba project password protected
Help with Mr Doug Glancy Code - Snake Columns
RE: Problem implementing connection point sink
Re: Make a cell in excel an object in VB
Re: Workbook_Open & Macro
Impossible Date Formatting Requested?
Excel - FTP - XP problem
Deleting duplicate Rows AND the original
Excel Charts - Toggle Series On/Off
Automatic saving
=Sum (Auto Filter)
Setting a range with the last used cell?
Pivot Table Help with Column Headings
Excel VBA Macro
Problem with message box return value
deleting rows that are not equal to a value entered from an input box, Please Help Me
Delete certain rows
Slow calculation
Problems with LN in VBA
Sendmail: Problem when used after a Userform
Application.Quit still wants to save
A small project
Changing the 3D-View in powerpoint using vba
Programming a Hyperlink to PowerPoint
row selection and cut + copy
The Biff8 and Ole2 formats
Find across several sheets and put results in a message box
Test for Worksheet Exists
Automatic Calculation Options ?!?
Automatic makros in templates Excel 2003
After Filter - Move to first cell
delete comment
tks for help!!!
Opening PDFs from VBA??
Dependent list in Combo-Box
Auto Delete rows
Occasionally losing the scroll bar function...weird
Userform Reset After Scrolling
sorting with a blank column
VB code is not working like it should
XML & XSL for two worksheet
Hello, I download historic data from yahoo.
Problems with j-walk data form
VBA Calculation on "only" Filtered Visible Cells
Excel VBA - Cells Counting Problem
Net Send command trough VBA
Fill MT cells in a range
User informatiion
how to copy values to another sheet
AVG Formula
Range deletion
Textbox with currency format
Chart in Userform Option 2
Need Applescript for Converting Upper/Lower Case
Change events and linked cells
Not unhiding rows when pointing to cell to complete formula entry
Chart in a userform Option 1
Loop thru All Files in a Folder
call a procedure using current inputs
converting times
Using Worksheet Codename to Determine Worksheet Existence
Concurrent users to a worksheet database?
Hiding Rows Without Using VBA
setting a range variable equal to the value of a string variable
Large File 56M
Could someone help me to do that please ?
Automatically answering no to save request
Advantage of MapEdit
macro to copy paste non empty data
HELP : ComboBox (Forms), Activex or What ?
Remove Data validation Input messages
ClearContents in event proc raises error
Delete Add-In
VBS Control spontaneously relocates
How find if target is object in Worksheet_Change (ByVal Target As.. ?)
Time Delay
Leo Heuser format cleanup code, and a question
details of a pivottable always in one sheet
discontiguous ranges in charts
Chart SeriesCollection. Problem changing from Excel 2000 to 2002
VB Code to size the comment box
question
RE: Treeview in excel
How do I run a Macro, but not watch it run?
Transpose Rows to a single a Column one below other
Re: Paste Special
Combobox -> to specific row?
Controlling a cell in a worksheet
Re: Paste Special
Web Query with looping variables in the URL
Comment Boxes
Worksheet_Change Recursion ARGHH!
Loop 20 columns Help!
Sort Method question
Sub Total
Auto Number Formats
Use of OR
Re: Treeview in excel
RE: Problem implementing connection point sink
What cell am I in?
Help please with UserForm controls
Re: Print Macro that will Print Entire worksheet except....
Updating
Sorting by more than 3 Fields in VBA
get data from closed workbooks!
changing the constants in the find function
Populating a Range by Code
Using Filtered Data for ComboBox
VLOOKUP problem
Excel macro & MS XP OS trouble
quickest way to remove all duplicates?
looping every third row
Re: Selecting Previously Active Cell
confirmation and close
font color change
Calculate no. of years for Capital Expenditure
scroll barr up & down
Pointing custom toolbar entries to correct macro path on copied workbooks
CurrentUser Name
CurrentUser Name
CurrentUser Name
currentuser name
Problem implementing connection point sink
How to do this:
Cannot seem to Cancel EXCEL App Right Click Event using C#
Solver Help I think
Problems closing a workbook with VBA
Sorting dates in a combobox
Re: Loop never ends
Office Web Component Spreadsheet: C#
consolidate data
Preventing copies
essai
move around cells
Adding references automatically
newbie
Excel VBA - Range.Replace within workbook over several sheets problem
Filtering Problem
Cycling through predefined worksheets
counting rows and columns
deleting wrong range!
IF, Then formuals
Trouble with editing data from a user form
HELP: Link all values in a workbook under same folder on one sheet
Range probelm in VB6
SendKeys
VBA Question
Copy & Paste
Counting columns, adding totals
how does excel store new line and line feed characters?
modification to suit Excel 2000
Function to Place Value in Specified Cell
Survey Problem
Macro to backup?
Track Changes
renaming array of controls
Add/Delete Worksheets and Reset Numbering
Dynamic 2-Dim Array
excel VBA set array controls
accessing constants like msoBarTypeMenuBar
how to remove command bar button
Help : Macro for capturing current system time
good com excel add-in books
Find Matching Data in different columns of different worksheets
Automating Word from Excel
Form Option Buttons and Combo Boxes in VBA
Creatiing various "what/if" scenarios
PageSetup calls are slow
Size and location of an embedded chart
vba code to block review toolbar
Data Consolidation from many Workbooks to One Workbook
Help with Chip Pearson's Code for Deleting Blank Rows
Override/Bypass login for exteranl database
Re: Loop never ends
Re: Loop never ends
Macro in template opens last saved document
Userform disappears when you try to initialize from a command button
VBA - Forms Exit Errors
Excel & Access
Borders around cells
Remove code from all modules closes Excel
Undo functionality w/ VBA?
Re: Solver Help I think
Creating a ratings list in Excel
RE: Loop never ends
Exporting to Excel and Apostrophies
Number of workbooks open
Spreadsheet query
Filling a ComboBox?
KeyPress Events
Re: Passing Macros Between Workbooks
Macros saving files.
Print Validated Only Macro
Macro Help to Copy to Last Cell
Selection of Rows
Outlook - Different Versions
Adding cells
Counting rows and columns (newbie help pls)
Vital: Protecting sheets so macros/buttons still work?
Delete all Rows in a Variable Range
Renaming modules
HTML Objects
Programitically Transpose Data and Parse it
Format
Populating a range
Open ODBC in Excel
Macro to Copy Selection to new Sheets
Select First Active Cell if the cell is in a pivot table
Custom Properties
Activating a Userform in VB when changing Cells in Excel
Opening text file in excel to maintain as "text"
A wacky problem - controls move on the screen after printing
Return value from first row
How to detect optionbutton being clicked?
Linking a Movie File to Excel
Excel iDispatch problem
Excel 97 vs Excel 2002 (XP) Notification Problem with Exce > 97 (2
Column Heads?
Excel VBA TextBox problem
vba and orgchart shapes
combo box macro runs when using "save as"
Autofill from non constant cells
Unwanted freezed screen cause by screenupdate = false
Adressing
Problem with .Calculate
Retrieving Default Chart Type?
Copy format without copy & paste
Data files are corrupt after saving from VBA - Excel 2000
Repost: % Variance
How to do an Access Database Query in Excel
Break/disable a macro when opening a workbook
How To Trap Cell Value Change Event so determine XL calc sequence?
GoTo Worksheet based on which button clicked
Delete range
Folder and filenames?
Need help with inserting hyperlink into worksheet from a form
Re: ListBox - Row Source problem
multiple VLOOKUP
Auto FIlter
let and get in class module
Re: Time formatting
Re: Time formatting
Re: open and activate workbook?
clear cell
Insert Date Comment
Auto-Insert & Delete Comments
Non printing rows and auto height rows.
Excel 2003
Userforms: combobox.value type
vb hide the excel view
Solver won't keep the solution.
Printing non contiguous blocks
Excel - VBA Run Multiple Macros Upon Opening A File
RE: Bold in Listbox
Appending new data to existing data in a spreadsheet
excel 2000 and c# .net
Pivot Tables
Best Way to Plot Graphs Clearly?
Data Entry in a cell still in progress - how to detect and correct
Activating VB form by changing cells
Web style layout
object classes
Does anyone know how to programmatically disable Application.xlcut
Width Property missing from Listview (mscomctl.dll) in VB6
Re: Last Hope -HELP!!
Setting the formula property of a textbox
Re: Last Hope -HELP!!
checking Excel version number
simple code problem
Macro for copying named range to any sheet
Re: How do use VBA to avoid reverting to my default properties for a l
collaboration using excel ???
FileCopy creates two files
Variable in AutoFilter criteria
Calculating # of busn days, not just calendar days, between 2 dates?
Opening multiple text files
Get Open File Name
Change notice
connecting to a WSDL from with VBA
How to Filter Date?
Program won't run when uploaded to intranet site.
Open webpage
Conditional Formatting and programming???
Copying data from many files
File Loading Problems
Summation
Multiple ranges to Auto Filter
Two cells whose contents look alike but aren't
Re: arrays on forms in Excel
Re: Object arrays on forms
Re: Blinking Label
Determining the size of a range.
VBA code to send range automatically via email
Excel VBA moving embedded command buttons
Get Open File Name
Remove border line of a few cells
Excel VBA moving embedded command buttons
record filter
Re: arrays on forms in Excel
How do I open a program(CADD) with VBA
Excel vba query - data integrity
protecting vba code and unprotecting using a vba macro
Re: Blinking Label
Removing all code from a Project
Trim Function - Error Library Not Found
Date/time code, both, accesible by hotkey?
Copying cell contents between worksheets
Userform show problem...
Rounding
2147217900 undefined function
arrays of objects
Duplicate headings in pivot table
Web page link
help to open pwd Excel from Access
Printing User Forms
VBA Codes
Spreadsheet Control on User Form
Expense report problem.
multiple criteria in a countif
Displaying data on a different worksheet.
Lines in forms
% variance
How to use VBA write formula
Adding a simple linear equation
MultiSheet macro, to sum based on condition
Manual / Automatic Calculation
Entering a Excel formula in a Cell through VBA?
Exclude a column from a table calculation
How to hide a Range of Columns?
How to hide a Range of Columns?
Controlling Word from Excel
Copy Values to Below last Populated Cell Q
Sum partucular cells by colour of sheet
VBA Referencing a Named Cell Range in another Workbook
How do you search values and display them in lables/text boxes
Ok now im stuck
VBA: "Volatile" use of concatenated worksheetfunction expression
help with variable
LATE BINDING using Set WordApplication = CreateObject(strApp)
user defined functions
Code for Input Box
help needed with msgbox
what do You say? :)
Changing individual chars within a cell
Re: deleting code by macro
Convert Vlookup Formula to Macro
Code crashes when ComboB = empty
deleting code by macro
Inserting A Row Where Data Changes
transposing and calculating
How do I know from C# code if sheet is protected ?
Checkin into SPS prompts no matter what...
end Macro after cancelling open dialog
Single quote in a textbox disappear when put in cell?
How? - Error message for turning off autofilter with code
Pivot Chart Data from external data source
Problems creating a chart with VBA
Return to xls app's MainMenu when help file is closed
Protect and Lock Problem SOLVED!!
Paths when working with macros
Adding 3rd shift data when missing
Web Query - UserID/Password Protected Textbox
Execute Excel Macro using Java
belblanco i posted a solution
Filtering multiple worksheets
VBA range from cell value
Printing Multiple Pages
Excel startup macros - visibility of...
opening a form from a combobox selection
worksheet_calculate **help**
common dialog control... list vs. detail display
Need Macro to Print Selected Wkshts
List named range per sheet in workbook
Array transfer - 1 dimension v. 2 dimension
Run Time error 1004 Paste Method of Worksheet Class Failed
Am I doing something wrong here?
Challenge...Excel Chart to Power Point
'Save As' function / macro
Set Validation list to show top item