Excel Programming [Archive] - Page 79

.xml files to be saved as .xls files as XML list
excel interop: identifying when excel has "initialized"
How to reconcile a a floorplan account between books and statement
Searching for closest matches using wildcards or range.find
Going through a proxy
Help with combining strings
Run certain macros based on operating system
Save Command Button Help!
Trying to Remember How to Parse a Web Page
Pulling Information from emails/files
Pulling Information from emails/files
User Form question
Understanding change events
Please check my code for conditional formatting
Listbox Multi Select
Running a SQL Update Query in Excel VBA
Have P.O. increment by 1 only on Save As
Function to open file
Insert formula
Save as new file command button
Update Calendar Control
Deleting text file lines
Does "Send" Have an Associated Event?
Renaming Non-Excel Files
Hyperlink Address Length Restriction
Getting Sheet name from Full Range in VBA
How to create a check to allow user to input numerics from the numeric pad
Where can I find an excel template for an activities matrix?
Check for Data series
colouring in bars on a chart to correspond to quartiles
Check Box to Show/Hide Columns
Need help with lookup & sum range
renaming textbox
Renaming sheet with VBA
Copy Chart from Excel to Word using VBA
copy contents of multiple cells into a new cell - Help Needed Please
MErge everything all colums into one
Formatted popup window
How do I shorten a 17 digit field to a 6 digit field?
Send web mail from Excel (VBA)??
excel vba - filters and ranges
Copying Values to another Workbook
How to delete these rows ?
Comparison of 2 excel sheets and put ouput in a 3rd sheet
Merging Excel Files
Run time error '4605' while copying excel range as picture in Wor
Transpose relative cell references
Problems with filtering and output
Finding and selecting text in word from excel
hyperlinks to word documents
Same spreadsheet used for multiple months
Problems with filtering and output
Problems with filtering and output
VSTO 2005 Excel picturebox control question
paste special over copy data
RE: Reset Collection
Macro question - Need to copy data & formatting to another workboo
Re: run macro every time page field change is changed
RE: Pivot Table programming problem
Sendin email with Excel macros
VBA set range according to find
Why does SPI_GETWORKAREA come in too large?
Checking for text in Sheet Name
VB code please
disable closing of workbook
A tricky format question
Re: Using routines to change a number of sheets
ucase 'data type mismatch'
"Enable, Disable macros" window does not pop up, security is medi
Re: Reset Collection
Re: Insert a date from a userform
Re: advanced "Replace" macro => correction
RE: Incorrect formula outcome
RE: Insert a date from a userform
URGENT! Please please help me get smtp mail send working..
Re: Reset Collection
Find Worksheet with Wildcard
Repopulating the Combo boxes from Access database
InStr function
How do I load a file from URL
Basic programming help
renaming a template file on startup
Inserting an analysis toolpak function in a Cell with C#
Office 2003 and 2007
Passwords problem
Copy from AS400
30 year mortgage spreadsheet
msgbox$B!!(B's$B!!(Bposition
Help tracking inventory
Deleting blanks rows based on multiple criteria
Mouse over query
copying and pasting to a different xls file in a different directo
copying and pasting to a different xls file in a different directo
Sum Values when Duplicate ID Exists
Conditional formatting
Help needed from excel expert
Writing A Search Macro With Wildcard Characters?
Enable Macros window does not pop up. Security Medium
Sort by Match
How to Operate the active Excel Window with VB6
Update a formula on an inactive sheet
VBA Formula to Count 2 criteria
Subscript out of range error?
Detecting date format
Find differences between Excel workbooks / version control / Excel Diff utility
Expand range help
read excel with c++ on unix
Conditional Seperation of Rows
Transfer entities from rows/column of one worksheet to another worksheet
Excel Window zoom
Code to Assist with Nested Function, Also Using ISERROR
Good books on VBA for Excel?
Consolidating Workbook Sheets (i.e., Tabs)
"Find" expression won't work
adding more than one button to a userform at run-time
conditional not finding correct results
Using a combobox to eliminate items from a list
Embedding MS Project document in Excel
limit the number of files filesearch looks through
Copy / Paste Easy
Open PHP URL on Sheet problems
stripping out the first space
Deleting row unless certain values in certain columns
Deleting row unless certain values in certain columns
multiline inputbox or msgbox message
Copying Data from several Worksheets to One
Duplicate worksheet creation
I need some help creating a database for my spreadsheet
Formula that knows its display location
Copy Chart from Excel to Word
Charting question
Hyperlink display
Clear Sheets in Excel
Clear Sheet in Excel
Option Buttons with macro and working with 2 workbooks
Using a Form for Parameters
Assign value depending on position in formula
How do I open a empty workbook with no sheets?
Copying data from workbook/sheets to another workbook/sheet
Windows().activate generating obj reqd msg why?
Timestamp And Store Cell Value
Opening a series of files
Sending Variable Via E-Mail
Question about Excel & Access
Copy Down
I hate lunch
Inserting a standard row through VBA
Help, Progress bar with multiple macros
Dynamic List Generation
how to write Ctrl A in VBA
Specifying Range of Dates
Apply Button Enabled
Copy range into email
Variable Formula - both normal and array
chose next page
alpha field getting turned into an exponential number
Toolbar question
Paste Unique Values from Clipboard
Problems when using macro created in Excel 2000, in Excel 2003
macro errors
Code to place value in another cell
Comparison Macro
Comparison Macro
How to popup msgbox in this
Vlookup Limitations
Macro Error Message
Dealing with times in VBA
Looping Program
Compare data of two excel spreadsheets in a third sheet
Sum of $ amounts within a range of dates
Probably something really simple...
ComboBox Issue
Converting a value in a cell to a hyperlink in the same cell via V
Use VBA to find, Group, Ungroup rows
Excel 2003 disliking an old sheet's basic commands
What does this line of code do please?
show value but hide function
VB addin excel can't see any workbook
macro autoexec
Macro protection
Integrated calculator in excel 07 instead of separate calculator
Comparing Columns and getting a respective value.
How to Variable Reference Row Ranges?
Fully Qualifying - ActiveCell.SpecialCells(xlLastCell)).Select
Application.InputBox has annoying cursor key reactions
Excel 2007 extra columns - but transposing columns still not working!
can't make a chart from data imported from txt file
Workbook challenge
Creating and evaluation user created forumlae.
Email VBA in Excel - Small Help
MACROS
event handler list
Copy over formula to specific cell
user32.dll
compare columns
new phenomena?
How to disable dialogue box
VBA Help
Inserting a analysis toolpak function with C#
Can I only show records on Graph that have more than 1 entry?
XMLSS/SpreadsheetML or HTML format for large data files
Copy/Paste to Specific Row with matching Value
Search & Destroy
Help with "double" loop!
Problems Distributing a Shared Workbook
Insert worksheet at end
Cant find project or library
work this out?
automatic replacement macro (follow up)
Hiding of Formula
Sort Columns
Splitting workbooks
condition
Input Button
Open Worksheet
Preventing Right Click On Sheet Tab???
Newbie Question
Search and Edit cell contents
Regroup shape problem
Analyze total
Cannot activate a chart on a sheet
Formula to VB Code
Updating a Add-In on a network
Updating a Add-In on a network
Updating a Add-In on a network
setting userform-screen fit
Prevent disabling of macros?
copy and paste between xls file syntax problems
Question on Hide/Unhide cells
Custom function for max residual from linear regression
How to add picture to the left corner of listbox index
displaying results like a dashboard counter
Edit a cells content via a dialog box?
Cross reference summation and offset <- sorry can't think of better way to describe!
1 click sorting *almost there*
min function
comctl32.ocx
data validation and copy/paste.......
Schedule a Macro
Button to set current time
Sharing a workbook
Help with copy destination
Create Excel ScreenTips for a custom VBA function
MsgBox formatting
>> Listbox selection
Save excel as web page and have htm file update automatically
Automating Splitting one worksheet
Copy worksheet template to all files
Macro to Sort Variable amounts of Data
Ignore Error '1004' help
programmatically change icons on a menubar
Navigating a Queue
Hide/Unhide Help
Enter numbers in closed workbook
Those darn checkboxes!! Please help!!
Excel loop error -- 25 rows okay, but 30 too many
Order of Calculation for Functions in Automation Add-In
specialcells(xlLastCell) and method global range error
Combobox problem
auto_open macro
Sort Rows by Value in a Column
Trap insert row or column in Excel in VBA
Argument not optional Error 449! Need Help
Deleting a Button on a Worksheet
How to catch Run-time error '91'
I need 2 digits (concatenate)
Function that compares dates and returns TRUE or FALSE
Excel Macro Help
Import xls file into Excel using VBA
Form Database
Getting information from Word to Excel...
nth weekday of the the month date problem
help with XLA...
Formula Error-Error Message
Have formulas for sums on a different worksheet update with new information
Selecting ranges by dates
Need a workaround for large workbook (need more formula memory)
Code Troubles
"Add to Selection" , SendKeys, Delete Nth Row
Macros for Printing multiple workbooks
Auto Select Next Item in Combo Box
Help with lOOKUP?
Compile Error: Invalid use of object
Saving only values
Change Filter
How to I reference in VB a button used to run an Excel macro
Unable to get the PivotFields property of the PivotTable Class
International Date Conversion to Values
urgent please. can anybody explain this?
how to use VBA to name sheets ?
how to use VBA to name sheets ?
how to use VBA to name sheets ?
Excel to SQL Script
setting rowsource to a dynamic range in design mode
If statement with OR
Password entry concealed ***
How can I Delete rows were the first cell is blank?
XL2002 - Offset function on inactive sheet...
create a user form to allow for different search methods
Repeating Header
Colour cell (or text) depending upon IF Function result
Remove dashs from macro data
Does anyone know how to create a lookup that will do this?
Emailing a Filtered Range w/ MailEnvelope
SendKeys Trouble
Load VBA on Activated Sheet
Error bars in VBA
[Pivot] Retrieve Data
Combo Box on User Form Question
Using Variables for file paths in QueryTables.Add
deleting corresponding columns on a multiple select listbox
Tickbox value
vsto deploy on windows 2003 server
How do I set a macro in excel to save to a web site
Microsoft Map is no longer supported by Microsoft Excel
"AND" & "OR" operators in VBA
Using VLOOKUP without a sorted list
Delete rows ere first cell is blank but ohters celld have data?
Loss of characters (? instead)
VBA Lock Columns
Dynamic hyperlinks not working
Printing range on combox criteria?
Sort by Cell Value?
VSTO 2005 Excel picturebox question
Last_column and autofill ...help!
search and delete commas
Global session
Macro for searching out side excel??
Excel Automation - Gridlines
Extracting data to another worksheet.
Input mask on a form in Excel 2003
import few text files from subdirectories
Graphic issues.....
VBA / Macro for creating new worksheets and new columns from existing worksheets
change the name of the chart as it appears on the Chart Window
Check for & remove Subtotal(s)
How to copy commandbuttons
Getting unique entries from an array/column
Excel 2000 58 character Filename Limit?
all different records of a column containing more than 1 times each record
How to control radio buttons on a web page?
Please help with a column/row transposing problem
Adding formula to a cell with VB
Lookup String in Text
Series Collection Results in Runtime Error 1004
Last_column & autofill help....
Saving a worksheet
Extra trailing commas in exported CSV
put data in a column into a row
Split all books in a folder
Autofilter always includes last line of data irrespective of filter
Excel 2003: "Workbook.Open with URL does not work
advanced "Replace" macro => correction
advanced "Replace" macro
Form design using Excel VBA
Batch extract PDF data to Excel using regular expressions
Invalid Procedure call or argument
wb.Saved + CustomDocumentProperies problem
Pivot Tabe
Intersect
Automatic new worksheet creation at each change of value in a first worksheet
Null, "null", vbNull, vbNullString, vbEmpty
Autofilter criteria not yet known
HELP: Row Selection and VBA guides
Running 2 projects at same time issue
Macro for "Retrieve" in Essbase Menu
Macro for "Retrieve" in Essbase Menu
Input Button
Find duplicate in a list
Multiselect Listbox - identify if item picked
VSTO and Excel-- End Cell Edit Mode Programmatically?
how do I display username, current time & date on the status bar
Categorised data into different sheets
MSCOMM32 Control
sum of series problem.
HTML to be displayed in sheets
getting close on addresses
Errors With Late Binding
Superscript Registered symbol
Help required with a simple Loop
Looping and inserting negaive totals
Chaning a listbox on the fly
Dragging graph-points to change data?
Finding value and returning row number
Dragging graph-points to change data? (!)
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined
Code Error - Still at work and need help!
Problem Copying DataTable into Worksheet
Concatenate Group of Rows
Summing through spreadsheets
Error Handler only works once
Highlight changes is orginial cell value has changed
exclude a number from randbetween function
problem with replace command
VBA to Rename Excel Worksheet Value of Cell.
Using variables to define a range of cells?
delete data rows in excel by using a macro?
copy data -> txt file with formatting
Word link to excel help!
AdvancedFilter using 2 workbooks
Finding Overlapping Data
Task Pane won't close all the way
excel spreadsheet with SAS
getting pointer to Excel file binary
How to make API call to freeze excel window?
Dont want the deletion option
Sending excel email, then deleting it
Auto-Filling Related Combo Box Entries
Named argument not found
prob with deleting columns
Excel After Close?
Automatic code customizing
I need a Macro?
Resume on Error?
Calling workbook.saveas depending on excel version
vlookup and dates
Dynamic button creation
ActiveWorkbook.RefreshAll
Programming Excel
how to copy and move columns?
Checking activecell value for NA
VBA Coding Error
Calendar Control
Please let Excel sort by string value within the cell/column.
Ciphertext Analysis with Excel?
How to port macros from Excel 2000 to Excel 2003
PivotTable Macro not working
setting interior color - error
filename problem in VB
Import from another Workbook
Removing Dirty Data From an Imported DOS database
Creating an object
Programmatic export to CSV
Conditional format macro
I want to format date cells for the 15th of every month..
VBA Code, My excel macro creates the charts on top of each other
VB select OK from a prompt when running a macro
Maintaining pivot table formatting
Add text in a cell based on colour of text in another cell
Calendar Control
template with data tracking
Sentence extraction
Excel 2007 Beta 2 thinks our Excel 2003 workbooks are corrupted
help with VBA code
How do I break VBA code into two or more lines?
Union
HELP! Network Hung
user variable macro filter thing
Getting started
Help my multiple charts & series are on top of each other; would like to see all
Get name of clicked Shape
Pivottable References
problem
Callback to Excel (xlcOnTime) and worksheet renaming
Call SQL Server Stored Procedures with parameters,
Need Help "Range"
Type Mismatch...
Getting an address - help
Import two worksheets into workbook
Can an excel cell ask a question
London Excel User Conference - Thank you
union/disunion?
Does Shape Exist?
missing file
changing the color of an individual toolbar
Protection.... after reprotect resets to defaults?
vbproper
Add decimal point from last 2 digit
application caller
Paste active link with a macro
Put the date from a Cell automatically in a Chart Title?
Refer to a worksheet from a userform
Arrey formula for non-matching items
automatic choose of dir path
Automatic Checkbox
Refer checkbox by name in a loop
Pop-up Message on error
Auto Updating of Progress Reports...
Userform, Find and Replace - Really Complicated
Excel sheet preview using MFC
String parameter including blank char
Haven't got a clue!!!
Delete and re-arrange cols
Row Height Code
Last row
Summerizing 35 codes in one
Prevent The Cruelty
Problem with set OpenDataBase Statement in SQL
#N/A error matching time values
sum shows (0.00)
WorkbookBeforeClose recursive call
ShemeColor Shape/Group
Giving Macro control to another workbook
Delete method of Range class failed
selecting the first row after a filtered range
Programmically setting Excel checkboxs(Forms Shape object)
Destination Range Names to be deleted.
Open Excel with no workbook
Format number / 1000
Need a Macro?
is there a way to customize data validation list Boxes?
Triggers to buy/sell based on histogram
Combo Box Help
saving files
How to Delete Excel Sheet without Warning - MFC
Use InPut in Hyperlink
Looping Macro to enter negative totals
long text string
VBA Training
How to set the page breaks for printout
Runtime 429
Change multiple object group name
Hierarchy in excel
VBA FormualArray error
trimming
swiwthcing between sheets and viewing pages?
Move a Picture to cell C1
How to popup msg box ?
Match problems
How to add program to hide Excel session
How do I delete an embedded picture on a worksheet using VBA?
Checkbox problem
Drag/fill colums and Delete Columns
Reminder pop-up
Error on macro
listbox problem
close distinct workbook
Disable the Delete Control in the Edit Menu
User Form on Opening of Sheet
How to display the cell it goes to at the centre of the monitor screen
Convert DATA into BARCODE 128 B quickly
Convert Data into Barcode 128 B
Calculate Checksum
MsFlex or dbGrid
userform multiselect listbox problem
Copy Paste overides data validation
Codeing for hiding sheet
Automate an Excel process
Automate an Excel process
Reverse find
VBA Range Property
Error on opening and clsoing Excel
Range missing its target area weirdly
Sum on Account
Code to turn off Share Workbook
How to test text case for Upper/Lower/Proper
Assign multiple cell's values to a variable
Creating an accumulative number
Array formula in VBA
Clear columns or Drap Columns
If statements and macros
SelectionChange userform
Screen Saver Interupting Simulation
concatenate function
Probabilities
Addin Macro in Toobar
macros help needed
Columns letter of selection
Column Headers in my Excel sheet are in reverse order-reg
How to load/show UserForm from other Workbook
Text on User form
Code to change formulae on worksheet?
Can anybody help on an excel formula requirement.....?
making labels
Protecttion + PivotTable Reports option
List of ADO GUID strings
How to combine data and delete rows
Open a non xls file (emulate the double-click from Windows Explore
Macro to alert when workbook saved or updated?? Is this possible?
SQL CopyFromRecordset
Creating a COM Addin
autofill with variables trouble
Series reference on a chart
VBA to show two worksheets in workbook
SUMIF(UDF, E2, L:L)
Make a list from two other lists in different files
renaming multiple buttons
SheetBeforeRightClick stops firing after macro repopulates sheet
SheetBeforeRightClick stops firing after macro repopulates sheet
Delete all but newest file
Pivot table help
To copy data from Sheet2 to Sheet1 in Excel using VB.net
Pivot Tables & Sheet Protection
Jumping in a For ..Next Loop
Findnext problem
Loop a range from bottom up
Last Row
Using Excel Macro to Print Word Documents
retreaving daa from another book
Reference/Book for VBA programming
error can't find project or library
Hide/Unhide cells using VBA programming
Trigger Macro on Cell select
cell formats
Looking for senior Office/Excel application developer in Seattle
clipboard monitor
@DSUM (123) equivalent in excel
using macros to insert and remove calculations a the workbook
Strange range behavior (example from Help doesn't work)
Ok, one more thing, Pull just the Time out of a Time and Date Cell?
Run-time error '02147417848 (80010108)
SheetBeforeRightClick stops firing if macro populates data
Multiple Ifs
Range Parameters
VBA Code to get list of functions in a module.
Disable Warning
Help to work this out......
Date recording on a cell
Excel/Access Macro
Sorry
MsgBox to validate an entry
Replacement
Replacement
Replacement
Replacement
Replacement
Replacement
Any ideas on how to do this?
New to VBA: Compare workbook ranges, merge data and do additions
When Running DDEInitiate, Error - Can't find MSAccess.exe?
If active cell value is 1, run this macro
Macros in Excel and Word
If Then HELP!!!
Concatenating a zero
Add workbook & save immediately (& 2 related questions)
Length
counting drop down box entries
Copying Files From Sharepoints ( HTTP:\\xzy)
Keeping tab on calculated field - urgent help required
Finding and storing
quickest way to copy information to several cells in a very large
Variables... Help!
RE: adjusting pivot table field names to language in use
Data may exist in the sheet(s) message
Open a mail merge from excel: common problem
Open a mail merge from excel: common problem
problem with copy to another workbook
CONVERTING AN EMPTY TEXT BACK TO BEING BLANK
Introductory and Intermediate VBA Books - Excel & Access
need help "worksheet_activate( )"
is it possible... (multiple input+naming)
ActiveX Control Warning
Copy to new worksheet problem
Re: Moving Cell Values
Re: trouble with code to move text
EXCEL 2003 Why have my formulae stopped working uncomplicated work
Code Tweak
Code needed to copy rows.
Re: Function Help
Re: Function Help
Re: Function Help
Re: macro help please
Re: Same action but different codes recorded.
Re: Deleting Rows
Re: Deleting Rows
message flash if sheet incomplete before printing
Summing a range
Active Cell to be used as filter...
Vba Excellence Needed..... Please??
Save Copy Problem
refer to specific worksheet
AddIn Password.................!
autonumbering in a userform
Simple Math Addition
.NET Custom Control not redrawing when inserted as OleObject in Excel
Problem in mail attachment when using CDO
Opening other applications in excel
Opening other applications in excel
Help - Worksheet Function to Code
Advanced formatting operation on a cell
On Cell Drag Event
HTML Help problem
Macro needed to transfer numerical values in cell from one worksheet to another
Trouble triggering an event when UsedRange >=A1500?
How can I link an Excel cel with an Outlook contact?
Automatic Filter Macro
2-line title on a xy line plot
delete row if a cell is blank
appending line to text file
Macro to navigate cursor
Formula Problem
Macro help please
multiline cells
"On Error" problem with a VBA web query
Compile Error with User from
JPEG File Properties continued
Daylight, Magic, Excel2003, and SharePoint
Macro doesn't run...
method 'range' of object'_global' failed
Stuck with problem - looking for help
Using Excel to report the TITLE of a webpage?
Trim special charcters from start of string
How to create a MsgBox to alert user an invalid entry has been mad
Launching context-sensitive HTML Help for a Function in Excel Add-In
Insert a file path at bottom of page with no [sheet1]
RE: Copy and paste tranpose VBA
VBA-Web Print Screen
Copy and paste tranpose
"On Error" not working for web queries
Bridge last night.
vlookup between excel files
Highlight Duplicate Values in a Range
VBA Equivalent of Index and Match worksheet Fncs
Lease Amortization Calculation ?
ComboBox Form for CrossTab Query filtering
counting not blank / null cells
Windows API
regkey to disable Welcome to Microsoft Office 2007 (Beta)! dialog
Relative import locations in macro
vlookup using vba while allowing manual changes
Tell in UDF if Calced Manually
A looping question
Check for Primary Key
Symbol database
Nasty IF Statement
running right click menu bar
Re: Tricky Tricky episode 2!!!
Finding the earliest "Last Saved Date" of Excel workbooks
Filename based on Cell contents
SumIf in ActiveCell.FormulaR1C1 ?
Macro to edit cells
Tricky Tricky episode 2!!!
Selecting Blank Rows
Password protect a worksheet
Works in Microsoft Query, but not with QueryTables
How to import data from Access Database.
VBA Equivalent of Index and Match worksheet Fncs
How do I display a 0 instead of FALSE
arranging multiple custom menus
auto_close addin
About the editor window (fonts and scrolling)
Return contents of cell at Index position in Source Range of Drop
Date format when using Text Input Wizard and recording a macro
Moving sheets to another file
testing for a string type
copy worksheet without including vba code
Macro error message
Please look at the code
Hiding/Unhiding rows
Help with speeding up vlookup macro
Finding files using Dir
Selecting the most recent file in a folder by Macro/VBA script
Saving to text file - tabs from empty cells ignored
Formula expected end of statement error, typing formula into cell as part of VBA macro
Pass variable from module to userform and back
Trying to select rows
formatting a variable
Setting form caption based on global variable
userform only not worksheet
The meaning of macro
formula
modification to existing code to If statement
Select every cell that has a certain value
help with this code
Difficult Question
catch event insert a row or delete a row
URGENT - SUMIF(AND
To copy range of items to the the row below
DatedIF
Code - Clear and Insert & If Statement
XLA Editing Problem "read-only"
Macro in sheet
seraching a certain range
Moving from 2000 to XP
Urgent Help Visual Basic
using pre-selected cells in my own chart macro
Right One Sheet
Re: Select Minimum Field
Select Minimum Field
A msgbox appears on sheet level once, and only once
Find Empty Cell and Paste
Help Needed Creating Hyperlinks from a userform
Search parts of a spreadsheet
Easy Declare Variable
combo box to activate functions in another cell. mayday,mayday,may
Complex Lookup?
Custom filtering has only two entries (and, or)? Ive got at least
Can someone help me with this error?
Automatic Answer
Error trap on Workbooks.Open
SQL Query not returning correct results
How to write a macro to fix another macro
Variable reference
Something "Odd", Sheet Protection, Locked Cells
date traduction
Drag and Drop
moving the cell selection in VB
Printing excel docs from VBA
Filtering columns within VB
Excel slow at loading text heavy workbooks
Simple VBA Question
Need to test for a blank worksheet.
Renaming Module names
Chart manipulation in VBA
Comparing active cell to the value in another cell
Search parts on a spreadsheet
Excel 2003 - Image Display problems
Unhide row when
Automatically Collate Workbooks
Macro to split workbook into several based on cell contents
values in columns where email address is the same
XML output, XSD validation
Auto-save on close
display when touching a selected polynomial trendline
Parse web data on worksheet
simple excel problem....
Ranking columns of data in a series of matrices
take dates from excel & book appiotment in outlook diary using mac
Colour listing..
how to access UDFs from a COM addin?
Complicated work! Any idea??
How Can I Click an un-name IE button via VBA
defining a range
If 3 cells are equal then...
Copying Multiple WorkSheets into 1 Workbook - Ron de Bruin Help
Loading default template
How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel?
Open folder with code
String over multiple Worksheets
preserve the leading zeroes while exproting data from jsp to excel
save a file with current date inserted automatically
conditional formatting via check box
Reverse Pivot
How to write a Macro which could copy a sketch from ADOBE ILLUSTRA
Find & macro code
Control Website from Excel
Need help with using VBA to select tabs in Excel
What is Date() equivalent in Excel?
How can I copy range's style to another in Excel?
hyperlinktext too long, any remedy?
Combo Box Help
Setting columnwidths
macro error
Variable in Macro?
How to reverse this formula?
Deleting a group of rows
Intersect
generate button click
Need to make it modal - like a message box popup!!
Building Excel Formula that Returns the Column of Last Cell with Data
Run-time error '1004' VBA Excel 2003
Problem using protect/Unprotect in excel 97
Rich Text from Autoshape to Cell
Automatically Delete Pivot Table with Macro?
Excel Files with VBA Macros Stored on SharePoint
Find Function
Tricky Tricky!
Transferring data between websites and Excel
Transferring data between websites and Excel
help with match, copy, paste please
Event procedure for change of a particular cell?
Help! i need help.
How to use VBA to drag down
MS Query Results
button on a timer
Cell.value is Empty
military time formatting...
Copy and Paste Loop
Creating a referance via a macro
Binding Service Account to VB code in Macros
Macro to align multiple files by rowdates
Changing font size of cells via VBA code
Shortening a formula
Do Loop for Error check
InputBoxes
Class Collection - trapped events keep repeating!
In Excel make it possible to filter horizontally also.
Base the value of one cell on another
Autofilter each item in a list
Find Row Using 3 ComboBoxes As Criteria
Find error
Macro Help Needed: Compiling data from multiple sheets and then transposing it during the paste.
formula problem
Different Range Lookups
Excel workbook.saveas freezes program
Excel workboox.saveas freezes program
How can I use non-absolute workbook/range references in formulas
Trying to use INDEX function in VBA Code, compile error
How to Delete row with criteria ?
How to Delete row with criteria ?
How to Delete row with criteria ?
Paste special problem
refering to filename in VB
Attribute statements of VBA Classes
how to use isnumber with this formula..
keeping a userform visible
Closing sheets and selecting 'no' automatically
Additional Properties for InputBox (PasswordChar)
Rearrange Data
Refering to a Sheet Name in a macro
Cannot autosum after import
Affect on macros when upgrading from Office 2000 to 2003.
change text in cell
Declaring Constants: objects
# of worksheets limited by memory
The picture is too large and will be truncated
Select All Cells Containing Data
Handle missing values
How to close popup
Writing a serries of values...
Expand Chart Macro to Plot Multiple Series
Array match in VBA
Double sided print macro needed?
Check for duplicate records
Excel 2002 aborts randomly when closing/saving workbook
How to deal with "$0 - $500" in one cell
VBA vlookup error depending on text string & quotation marks
Replace misc character with previous sheet name
Finding the last cell in a series
Supress Informational Error Messages
Creating Same Size Box
Automatic Sheet Generation???
Macro to Count how many recordsbetween each hour interval?
How to delete a sheet without Alert message
Send sheet to selected distribution list using VBA
CUstom color is not showing
Excel loop Need help
Excel loop Need help
From a fixed cell to a variable
Pausing a macro while waiting for an input into a cell
Macro to clear cell data without clearing headings
Pie Chart
File Properties
Event Procedure doesn't run
macro to copy data to other sheet
Print ALL swimmers certificate
automatic file name
Assign several macros with OnAction
finding
Validation with Macro to count characters
Calculating the difference between to dates
loop to excute data
Populate Values
Excel VBA: Automatically activating Private Subs
If else if else statement help
Select first row of currentregion
Userform ComboBox populate using code?
Insert rows (1 to 4) if the cell value equals a fixed word.
Excel "Save as" dialog - when file already exists
Using an equation in a form
If its a date, then...
Copy from word table
delete non-used range names
Trusted VB project
How to filter a 2nd list based on selection in 1st list.
Need Help with a sort
Need help with code.
Scroll bar to change value in cell - PART 2
Selection.Copy - ActiveSheet.Paste to blank cells
Reference Value not Formula in cell via VBA - Err91 prt3
Read Last Inputted Value?
compare data
How to turn a user form into an add-in
excel 2003 common/uncommon errors
ues
I need a VB script for Excel
need to save values from a range of cells based on selection from list
Sum cells with variable number of rows
Creating Message Box Warning
merged cells
Error91- What looks wrong with this code? - ideas?
use of vlookup and IF functions on certain criteria
Last Entry in Colum
Office 2007
Headers
Verify user input box is a Month End Date
copy/paste column remove formulas
HELP: can no longer open excel file in XP
Prompting a predefined filename to be saved
Worksheet Change Problem
format of combobox on userform
Problem with Excel crashing when opening an user form
Combobox question
routingslip truncated filename
Error varying from System to System
Populating a cell based on combobox data
Finding files in a directory
Copy Cells from One sheet to another without Selecting
VBA with real time data
VBA WinInet Code Crashes Excel
Excel VBA Sheet(variable).range... possible ?
"Find" Code
Who or What is Tom Ogilvy?
find user input
I need a Value Picker function
Sheet copy
How to obtain Excel (or Office) FULL Version?
In need of some assistance Quickly!
active cell control using scripts
need help with in excel macro to add date and a number from 2 different sheets
CTRL buttons?
Multiple scrollbars
"Insert row" event?
user Form change
2 workbooks
Declerations
Creating a multi dimensional array using transpose - Is this the best answer?
Excel to PDF
1004 runtime error
Works beautifully but stops half way through