Excel Programming [Archive] - Page 81

List all the named ranges & the cells they refer to on a blank she
Problems with saving WorkSheets that have External Links
replace VBA run-time error message with custom message
Excel Macro
need to make code more efficient (if possible)
Excel import
Macro using Save As Problem
How do I get dates automaticaly inserted when editing excell
Can't get past Line 3 of code
VBA & User Form modules vanish
Select columns when drilling into a Pivot Table
Loop for copying data, then pasting in a continuous row
macro to print a sheet if a cell is a certain value
Keep calculation time down in large Workbooks
End if with block if - Pivot Table Problem
Loop and name
Configuring Excel 2003 to control access to Trusted Publishers
Export from excel into an invoice template
Event when selecting an item in a combobox?
Got the Copy/Cut Code But what is the Paste Code
Runtime Error -2147417848 (80010108)
better way
Return reference from object function
Global Variables
Search and open feature
Insert VBA code user a macro
Return Array Dimenions
Closing Excel Program correctly?
Chart making
addressing type in FormulaR1C1
Hide columns in macro while protected
Error loop through #N/A values
Quiting Excel program?
Changing the row and column in R1C1 formulae
call macro X by cell value
Macro to extract the data in a certain cell
Can one close Excel progarm with a macro
load event when specific workbook is opened
Legend moves across chart
Function returning null value instead of string value
Help with MAX code
positioning charts
Put worksheet names into worksheet Excel 2000?
TextBox question
How to format cell's borders by using VBSCript?
using a the active cell in a range command....
VBA script to add text to cell.
VBA script to delete content in merged cells.
Can I get VBA script to read a word with both lcase and ucase lett
Opening Excel workbook via automation doesn't fire event procedures?
CommandBar control ID help.
VBA excel using arrays and loops
save as
rounding out "time"
Excel 2007 problem with macros
userform copy data to more than one location
Amateur VBA developr seek Professional similar for exchange of insight
run time error 9, subscript out of range
run time error 9, subscript out of range
WriteReservedBy Location
VSTO Form Issue
Search a range to find cells containing formulas
How to know if a validation dropdown exist
Choosing multiple Series for a XY Scatter (simple?)
Find ALL WorkSheets according to 2 ComboBox Values.... Help with Code
Open Access form from excel hyperlink
Average If statement
Variable IF statement (in VBA)
Matching Cell Colors (Cond. Formatting)
Moving Excel Macro Problems
Breaking Into Seperate Files
Concatenate Problem
Date formatting in Excel VBA Text Box
Using Shell To Get File Info
For next loop carries on after criteria is met changing other cells????
saving email with CDO
UNC Database Query
option view (Sheet Tabs)
Scanning barcodes into a worksheet
Need macro to autofill when there are blank cells
Module, create toolbar/handle clicks
help! user form issues; can't find subroutines; appearance issue
can I use a pivot table and update my source data (like Hyperion)
Loop without Do error
returning the activecell's page number
How do I set data validation in VBA
How to access muliple tabs of sheet as variable of an Array
Variable in function problem
Problems During Load (XML file Open)
Auto Grouping of Option Buttons
Macro Fault - Excel 2002 sp3 Portuguese
how to receive data through textbox and save the same in excelshee
Email Hyperlink
excel and data access
Text alignment in a cell from VBA
odd sort issue with numbers
web query data
Combobox: Make "Enter" = Select
Move Selected Rows To A Different Sheet
Activate cell in column B after performing Find
Sorting By Largest Value In A String
Need syntax for RUNning a Word macro with an argument, called from an Excel macro
rearranging data
Advanced Filter Error
Help needed replacing multiple cells from a list of values.
Print pink sheets
Type Mismatch!!!
Open workbook macro if time is between???
How to extract email addresses to new column
trade tracking
Excel 2007 Conditional Formatting
Faster way to code this
Trouble with Code to change sheet name
Numeric Userform Help
Character Locations in Strings
Combobox: Autoload property: WTH is it???
Running Macros
ListObjects.Add error
Database Connection with Informix using VBA
"Subscript Out of Range" Errors For Ranges
refEdit and Excel crash
Ignoring comma when creating validation lists
Hyperlink in access from excel code
Send Xl Cell info to Word
Placing buttons etc on userform
Macro for Counting the number of records in a worksheet
Listbox not refreshing on update
Pictures.Visible question (after adding many pictures, they stop disappearing)
Remove 0D0A from cell with word
Print Refedit range?
Use excel vba to Call macro from Access
renumbering a column
Save/Load txt files UserForm question
Assistance please. password on opening excel file
Please help! Copy sheet to another sheet from cell value
Automatically Saving A Workbook
Type Mismatch: array or user defined type expected
fill down multiple cells in the same column
Saving and searching Macro
rename cells with a macro
Automating a workbook ???
Automating a workbook ???
ultiple if Statements
Function
finding which cells changed after a calculate?
Force to enable macros
"Frozen columns"
Runtime error 1004
How can I refer to the ActiveWindow
R/T 1004 Error
Excel11.xlb
calculating values based on text in other sheets
Move shape, object, pic to center of new cell based on cell value
Increase columns with interop
how to trace through VC++6.0 code which is called from Excel 2003 VBA
Easier said than done
Changing background color when changing value
Exclusive choice checkbox
Automatically copying rows
check/uncheck a checkbox
Replacing cell ref with active cell
Formula should retain
Help Plsss
Workbooks within workbooks
Remove blanks
Multiple IFs
Excel Automation : numbers Copy/Paste issue from VB6
Userform- Formating numbers in Textboxes
Looping a macro x times(x being activecell.value)?
initials + increment
Copying parts of sheets
VBA CODE: consolidation of excel sheets
disable control
disable control
Indentifying the last row in a sheet with data in it rather than formulae
Changing Sheet("Name").Select Name
macro to delete zeros and formulas
Use a macro to merge cells in a column that are the same
Copy to next empty cell in another workbook
Linking to Excel
Connection object vs. Opendatabse on Databaseobject
Dumb question
Replacement or deletion of data after filter
how to link to DB to update data?
breakeven formulas
Change a row of headings based on other selected cells
Return top 3 occurances of word in list
Rename closed workbook
Selecting Just Data
Date formatting cells w/ VBA
Date format changes...
Page Breaks based on cell data
1.Open workbook. 2 copy data. 3 replace data. 4 save workbook.
Convert IF formulas to their values
Convert numbers (numerals) to words (text)
Simplifying my previous Request for Assistance
Resize DataForm
Removing All Formulae From a Workbook
Pivot tables macro
Excel and VB.NET Help!!!
Invoke Java from Excel
Excel and VB.NET Help
Problem writing formula
DSN Connection with OpenRecorset
excel, visual basic and serial communication
adding and copying rows
import data (html files)
Using Redemption to email cells with Ron's mailing code
closing subroutine
Adobe PDF ActiveX : shame on Adobe..!
Updating Linked Data in Excel
Problem with code for merged cells
Rearranging columns
Contents of Excel11.xlb
Trying to run macro on the BeforeSave event
Execute Macros from Other workbooks on current workbook
One sheet to another..
macro problem???
Compare 3 lists
How do I create a form based on a list using vba in excel
How do I do? A personalized form, similar to Show data Form
Automatically Creating Worksheets
Deleting rows as if there are no qualifiers!~
Temporary file open; not visible at all
One IF, Two THENS
Inserting Rows
Limit Find to a single column
Hide Columns Based on Condition
Hide Columns Based on Condition
Where am I
Return codes from called macros
Script Newsgroup
Publishing Excel Macros to Web Pages
Error Creating Chart
In need of a formula
using code variable to write cell formula
Excel desktop shortcut to cmd button in worksheet
Create programmatically list of combinations for choices from data sets in excel vba
Changing Sequential Object names
One column to multiple columns - with a twist
One column to multiple columns
Type Mismatch error - tried .text & .value
Object Library References not transferring
Error with Calculating date difference using TODAY()
Cursor change during code execution
Open Word From Excel, Different Actions
VBA Script to search for a specific cell - Help needed
Log when cells are copied
Can anyone help finding two obscure commands?
macro for rearranging data
inserting columns, writing in cells
How to get a tick in a drop down menu
Get Properties Of Closed Workbooks
Filters
Populate Combobox with Pivot Table Data
Correct find syntax
Can I insert cell values into an email message this way?
Breaking password on VB Code
Run-time error 1004 - General ODBC Error
Use Excel as a network packet sniffer?
Need some help with a silly error...
Word document.
break line in text cell from ASP
Hidden sheets and macros
How to del clients fm spreadsheet using a list fm other sheet?
Automatic Functions?
Need help with Text to Column in a macro.
Stacked Graph
Excel ComboBox / Copy Error
Excel code for exported spreadsheet
Macro deleting certain cells
Format(Time, "h.mm AM/PM") question
Need Help with Run-time error
How do I calculate the distance between 2 postcodes?
Cannot set ColumnWidth past column 148
Cannot set ColumnWidth past column 148
how can i create quiries in excel from ODBC data source
Count spaces in front of text
Copy Data into Template Worksheets
Force use of standard function
how to write excel macro for repeated dynamic data
Data Validation...A Multiple of a number
Testing a range for blanks
Checkbox connection with Macro
automatically moving data depending on date
Automatic Updates to Spreadsheet - HELP
manipulate color with code
Import Excel data with .NET
Column number
live time on userform or within frame
Column number
only cells that are colored yellow
Refreshing Worksheets
on time macro
Is it possible
How do I update without sheet select
unload userform problem
paste data in cell after user has defined where
Need macro for protecting individual rows in a worksheet
excel runtime 1004
Paste numbers
Efficiently Generate 88 Chartsheets
Simplify Cell Formulas - AGAIN
need macro for create new email message and send it
if macro is made disabled.??
Use of Subversion / CVS / Source Safe
Find and remove blanks
Drop down box with associated passwords
how can vba detect what is currently selected?
coloring columns in pivot table
Is it possible
Userform SpinButton problem
when to use a module & when to use a project
several scripts in one single script
Next without for
Userform Gallery
How to calculate: sumproduct / db??
Is there any way?
Using FormulaR1C1 to find fields begining with spaces
Absolute value
is there not a simpler way
How to protect few cells of the worksheet from editing?and few other doubts also plz help
Close workbook
writing excel
USE OF DROPDOWN in Combobox-a problem
excel vba word merge printer error
Want to connect to Outlook Program; but can I keep my Web Page?
Protect/UnProtect Project (code) via VBA?
Enhance your domain skills required for the job
Multi Dimensional Array
please help someone (again posting)
Remove space and "-" character
Printing Problems
Workbook_Open() and Object Not Found
Command Buttons and not Printing Them
Re: ComboBox Row Source across ALL sheets
Next Known Date
userform multitask ?
ols
Dependent ComboBoxes as Critiria for VLOOKUP or OFFSET
Help. Getting error retrieveing version number
do not allow same data twice
Options Button for Excel Userform
Simple VBA question (?)
Help! Stupid CommandText Problem
conditional formatting and VLookup
column and row autocorrect?
Inadvertent macro
Split date into Variables
Workbook_BeforeSave Event
duplicate data
Case Selection Example
Taking multiple information from one cell.
Excel - how to prevent new office version from upgrading word object reference
Delete Row Based On Two Columns
AutoFilling To A Variable Number Of Rows
How can I activate scrollbars in an own userform?
Macro - IF command
Currency Converter From Website
Date format change
Copy and paste macro
moving data
2 VBA enhancements
Paasing Values from one Array to another
Disconencted recordset for DSN less connection
Using Msnstockquote from excel VBA
Application-Defined or Object-Defined Error
cell name - macro
View values; ignore header database
Modification to existing Code
write in excel
Auditing Code
How to exec a commandbar button while cell in edit mode
Designing a spreadsheet
How to exec a commandbar button while cell in edit mode
Frames and buttons
How to take a range input in a function and find the frequency of data in it.
Change the line color based on the value selected in combo box
Excel add-in that may help the color blind
Frame
delete contents of visible cells only
A 64-bit variable from VBA to VC++ dll and back to VBA
Formulas within pivot tables
Placeing buttons on spreadsheet
Having a cell display certain text or formatting when the worksheet is protected or unprotected
Help with open files
Locking panes
Runtime error 91?
Help with coding please. Newbie.
Digits after the comma in Userform
Form
Is there a way to unlock a project in VBA if you know the password
Manipulating Text File
excel add-in write text
How to write to the VBE of a closed workbook?
Freeze pane
RefEdit problems
Referring to a row or column
Delete blank sheet
NickHK
VBA and Printing
Calendar Control Addin
Disable excel message
Calendar value
Scrolling a Text in Worksheet
Calendar value + 30, 60 or 90 days
Wordart in userform??
Numerical integration to a maximum value using VBA
Modifying a database based on changes in an Excel document
Macro for sorting color data
Add Hyperlink
Expression Difference?
How to run a Macro specified number of times?
Updating a cell based on contents of two other cells
ComboBox Row Source across ALL sheets
Deleting WorkSheets MANY
Keeping buttons stationary when unhiding rows.
Setting Default Save Path
Zip codes and Distances
Catching an error
Open Excel with a XML file and SaveAs XLS
macro for sumif formula
Copy Excel chart into new ppt slide
Math involved. Excel speed optimization question. UDF vs. longer excel equation
Prompt for Action before closing workbook
Event Change Question
My macro won't find the last row !
Check the content of a textbox?
Find and remove blanks
Combining the IF and List functions
"If Yes then Proceed..." Macro
formula that takes part of a cells contents to another
Choosing offset on condition found in combobox change colour of cell??
Syntax Formula help
Get VBA procedures from DB
Date format to decimal format?
Best match macro
Evaluate Range of Cell
Macro to Consolidate Worksheets
Sequence of numbers
executing macros upon opening xls files
MS Access Query Identify Friday's records.
RefEdit problems
Format Part of Text Cell using VBA
Pivot
Dynamic Named Ranges - LINKING
List box VBA script to clear cell in other sheet.
RefEdit ???
using excel to query asp page
RefEdit ???
copy unique rows
msoButtonUp / Down for sub-menu items
Adding a row on Open
Pls Help on from date tranfer amount to month
Adding a row on Open
Is the list of Worksheets limited to "This Workbook"
UDF sharing
Newbie needs help on excel formula
Changing format of cells
query result through array on worksheet
steping through all cells
compatibility to EXCEL transformation
Changing format of data
Chart size
how to execute a macro automatically
Teaching Sub-Levels and Excel Nightmare
UserForm
Excel Icon??
Filling TextBoxes
Linest(known_y, known_x^{1,2,3)
Copying and Pasting Using Row Counts
pull rss feeds into excel
how to use FTP in VBA
Combo Boxes
where can I find the trace precedents button on the toolbar
Macro to "archive" cells
Replacing macro buttons with a new set of buttons
Textbox: Number of Characters
peculiar error with Range() object
Detecting abnormal values in a moving range.
Searching array for date and changing offset colour depeding on combobox content?
Problem with a converted office 2003 file with user defined functi
company calendar: start date problem
How to repeat a macro
Modify Yearly Calendar to Monthly Calendar Excel 2000?
R/T Error 1004
Adjusting individual icon size in commandbars?
Excel experts needed
Converting data from row to coulm
Transfer data as per there date in there month.
Error trapping
Sending Mail using VBA
Row number of a specific value
Using COM objects in Excel or VBA?
protect formula
Loop with Time
Calendar Control
printing macro,want to use beforeprint event?
Grouping objects
Printing labels from names and addresses in an excel
is sheet protected?
Window>Arrange>Tiled - all xls in directory
Linking and embedding question.
Sheet protection
Trouble with lots of IF THEN statements???
How to create a Delete method which frees memory occupied by my object
How to find an excel sheet by its name???
Custom button to call a macro in Personal
Can't get the find statement to work correctly
Last Row In Column..
How to format userform label at design time?
Making changes to most worksheets?
string variables in file names
Problem with macro speed.
Basic VBA Question with Array
moving xls files with macros to another directory?
Command Button from Control Toolbox
How do I stop the SQL Login screen when refreshing a query.
Use of sheet codename in codeline - How?
DATE
Setting "r" to = range selected in an IF statement?
Spellnumber Function
COMMANDBAR MANIPULATION....
Web Querry stopped working
HIDE ROWS IF..
commandbar scope
VBA Code--------!
ChartObjects Macro excel2000
If staement and macro
how do you create custom buttons in office 2007?
VBA Help required..........!
Import tab text data(more than 65K rows) into excel by VBA
find and highlight
Convert an Excel table to a list with VBA
Save button
listbox.value is empty even though there is data!!!
How to automate with macro multiworksheet File using array variable?
"On Error GoTo" syntax problem
macro to open csv file on the web with password
not your average activate event
Retrieving data from Web page 2
Right click event
Formatting numbers in a text box
how to determine if user has Outlook or Lotus Notes
VBA versus Scripting
Community versus Newsgroup
Remove object from memory
subroutine variable decleration issue
#N/A in 150 WS
reading data from thumnails
Cell/function manipulation
Pic Macro
copying all of a row & Attributes
Wrapping text in an Excel Interactive Web page
Macro Code required..........?
Counters
protect Micro
Macro in body of workbook. Can I create XLA?
Copying Formulas Down Rows
Getting 0 to not equal False
.Precedents don't work in UDF
Offset with variable?
Offset with variable?
delete rows with dates between
Filter for 4 criteria only need data from one column
Error when deleting rows
Explicitly passing a .value
Formula to Excel VB
Transposing time series data
Linked Workbooks
Exporting to Excel
Finding the right column
Windows version language and Excel version language
Help with storing data
Dir command not consistent
UDF Can't return more than 255 chars???
Vlookup
Please help
Dictionary troubles. Declaring and checking .exists
Need Help
Validation List
Transposing time series data
How long do variables retain their values
1D Array Problem (Subscript Out Of Range)
Fastest way to get keys from collection
Hidden cells
Considering Holidays
Data Import ODBC at 30min intervals with Macro trigger
Run-time error '1004': Unable to set the CategoryNames property of the Axis class
Run-time error '1004': Unable to set the CategoryNames property of the Axis class
Run-time error '1004': Unable to set the CategoryNames property of the Axis class
Need help with Lookup
Object Variable with Block Variable Not set
Re: Initializing a dictionary and then modifying it.
Add a second condition to loop
Compile error in Excel
Excel VBA's are there but not recognized as macros so they can't b
Copy and paste row based on cell content
opening multiple xls files in a folder
Initializing a dictionary and then modifying it.
Need to get modified date
Need help with changing data after it has been imported.
VLOOKUP
Programming Cells To Change Colors
Standard length of a line of VBA code?
Shell for Outlook
Problem with Auto_Open function
Chip P.
Problem with Auto_Open function
SUMPRODUCT statement only works sometimes
Record the date on which the record is made
pictures in exell
Run-time error 1004 Method "Range of object_global failed
Multipage Part of Form
Printing a Background
How To Maximize A Window From The Task Bar
Form
SpinButton1.Max quick question
Opening a word document
No 'Click' for CommandBarPopups, so what should I do?
How to make a cell containing a macro call to be recalculated?
Macro for Drawing
Elastic array
Macro to insert copy and insert formulas only to next blank row
Control array
Counting worksheets with a particular name
AnyOne !!!!
How do I add a button to an excel document?
Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
LadyHawke
Execl VBA
How to stop all Excel funtions for a period
An old question about Office 97 to Office XP upgrades and Bloomberg
problem with calendar dates format
Irina
This simple userform is driving me nuts
Ending session
Window Object - Subscript out of Range
Detect # scrolled-out rows and column
EDIT>GO TO...>SPECIAL...
Syntax error..
User defined chart
I need some help with userforms
Code to modify find/replace
Need syntax help!
Disable the alert
Help please
How to find Windows login name with code?
The same IF (SE) formula give me two different number: why???
how can i perform interpolation on a data set?
Userform loses its capabilities...reset???
Check to see if a file is already open
Treeview Question
How to programmatically test whether VBA code exists in an Excel file
VALIDATE WB NAME
Coding to make a transpose values button
need codeto view the 56 colors of ColorIndex
public function to sum input and return total sum + 10%
autofilter syntax in VBscript
IF formula with correct formatting in result
Quick Question on This Code
Event Procedure (re-activate automatic calulation if disabled)
Toggle FIND criteria
Newbie VBA Problem
CommandBar 'Insert'
Highlight duplicates
a sensible, descriptive name for activex
Saving Changes to Excel App
macro as and moving files
Hex to ASCII converter in Excel?
Controlling Outlook 2003 with excel
Triggering UDF
DATE Formula
Lotus 123 to Excel
Importing Text Files of 100,000+ lines, many blanks
How do I build an excel query? (something like SQL)
Capture AutoFill...
UserForm to Hide/Unhide Rows
ComboBox Lists
Crystal xcelsius
Retreving data from Web page
Loop & Cell Reference
Using a formula in a SUBTOTAL Line
In excel can I display a cell based on a calculation (eg M(14/2)?
Error 424 Object Required when passing range as parameter
Problem Naming Worksheet
Is there a way to WAIT in Excel without using 100% CPU?
Code to show a graph
Validation of cell results
String Array initialisation
Filter Macro with Cell reference
choose default macros Not Enabled / Macros Enable Setting
VBA select default Don't Enable / Enable macros Setting
VBA function got name error in excel 2003
How to print fitted 1 page width and 1 page tall
Adding Number
Restricting copied text to one Column
MKDir not working
String array initialisation
Assign my own sound from a list to a command button
Referencing code outside of current sheet
Dictionary and saving workbook/ reopening
Hideen Worksheet
Mouvement macro
Locking a sheet & Menu Items
saving changes
Variable Decleration
random dates showing up in userform
File properties (size date)
Missing Help Files
Printing selected pages in a Word document
Do loop error while using FindNext command
Macro to send email through Lotus Notes
Problem with ListItem Width
General Mail Failure for "ActiveWorkbook.HasRoutingSlip = True"
how do i add weekly averages in excel
Adding a counter to ranges
Trouble with dynamic named range
Combo Box - auto complete and the bound column/text column propert
Email From Excel/VBA
veenob3.hlp
Creating Variable for a Sheet
Find Last Value
email in XL XP
Insert & Sequentially Number Column
unable to record macro
Type mixture error
code help
Sheet Name to Cell Value
Print macro
To block "to "eliminate" of the picture of form, information
update all the pivots at the same time
calculation semi auto?
Save a single file webpage of each visible sheet in a workbook
Reg : Excel
set up multiple prices for drop down list
Inputbox Default to be Upcomming Sunday
dynamically assigning QueryTables.Add.TextFileColumnDataTypes
Default Transparent color for bitmaps on cmd buttons
How to loop thru cells in a row
Userform loses its capabilities...reset???
To block "to "eliminate" of the picture of form, information
Call VBScript from VBA, pass variable, return result to macro?
Incrementing a field
Array data to Range: Only first value written
Date Comparison
Shapes into List Box
will 2007 multithreading capability help the vba<-->worksheet tran
Combining two sheets into one
highlight with right click?
How do I set up macro to truncate column/field?
VBA: Date Comparison
Chart placement
VSTO Excel -- Urgent Help
Create New Wk
Custom properties not showing the value when set programmatically
Opening Workbooks in a Folder
Macro help required.Can any body help.........?
Inserting a text character via a menu option into...
Macro help
Automatic File Download using CuteFTP
Can anybody help on Vb Macros please..?
Can anybody help on Vb Macros..?
RTD wrapper functions do not work in Excel 2007
Replace fuction replacing all instead of selected cells
Is MAPI or CDO installed?
Circular Reference?
Count backwards
.ext file
Can anybody help on Vb Macros..?
*.csv to *.xls
Setting size
Making charts
Changing color of tabs
how does a macro use an inputbox ?
How to stop Excel from animating range selections?
Macro to add a combobox?
Charts
Search Goto Feature
Logon Dialog prior to Open Database connection
Change combobox properties
Theuns
Theuns
Small problem with GetopenFileName
Placing charts
Making charts
Speeding up macros
Error while populating a combobox from Access database
Changing color of tabs
New WorkBook Macro Looking to WRONG WorkBook
MouseMove & Click event over an image control
runtime error 75 when I run the application for second time
XP question
How to simulate "Data>Form" in VBA
Can't find Project or Library
To block "to "eliminate" of the picture of form, information
Array? IF? LOOKUP? VBA?
VBA and Displaying Chinese
VBA Function won't work!
different between CreatePivotTable and PivotTableWizard
PivotTableWizard using SQL Analysis Services
Problem with Macros!
Add value when checkbox is ticked
excel applicaton closes showing complietime error not allowing to edit
Compare two workbooks and Copy missing data
Screen Updating on Open Workbook
Conditional Format
Handling the 'Cancel' button..??
Table with Excel
If/Then
Question related to Recursive Formula Execution
Field Data Validation in VBA Forms - Here's a way
Advanced Data Maintenance Dialog Question
sql string, +'/'+convert(char(3)..)
2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
Help with List Box
Swapping two ranges
Reminder Emails
Opening Outlook and PDF from excell
Summary Page
How to send HP printer escape codes from Excel?
OLE automation with PivotTable and external Data Source
A way to simplify this please
Help with Advanced Sorting Macro
keep column's information consistent in different worksheets in same row
NEED a PRO: Screen Epilepsy
Using Excel as a data base
Find next blank row
Macro: Convert to PDF & E-mail. Possible?
SelectionChange and Pivot Tables
~~ Help with Userform and Combo Box ~~
Replace left header
Merging Worksheets
PrintToFile from spreadsheet
How to skip "unrecognizable" msg when opening Workbook
file name on worksheet
VBA Coding: Date Consideration
Set Column Width Based On Total Width Of Other Columns
Working Days
Looking for faster way to find minimum value
selection.value <> "A list of values"
Pivot Table Data Connection
Save as cell with path
Can't get Application Events to work with .xla
Incrementing Cells with Macros
Using a Sheet Name
Select all cells in a column up to a blank cell
Using row() in conjunction with a column number.
VBA Loop Excel Record Extraction
Unable to set the locked propert
How to Get Excel Command Line Programmatically
summing a range in a UDF
Sort Multiple Sheets by Category
copy duplicate rows to new sheet in WB
How to split the active sheets into two different work windows?
macro to delete on a condition
How to capture autofill?
Finding Last Cell that Has Data
Summary Page
Access transfer to Excel
Removing quotation marks in a txt-file
Open Outlook from userform
Assure entry is numeric
How to use PivotTable as a source of selection?
Calculating a growing formula
Save As Macro
Control for selecting cells in worksheets
Loop that Copys from one sheet and pastes to another
Check validation on SelectionChange
How does one create a delete property of a user defined class?
Import Problem
Need help using a toggle button
Find/Replace Macro with format changes to the replacing number
How to read DBCS from a cell in VBA
Need an Excel VBA script written
Identify duplicates and move to new sheet
Find value in bottom cell in a column
VBA Loop
Data Validation Returning only distinct values from a list
ChartObjects
Saving Excel as latest version
Placement of charts
Automatically transfer cell contents
Identifing Locked Cells
Removing a collection item via key name check
Paste Array to .xls : All at once
Updating data from one workbook to another
trying to find #REF! in a formula to replace with a sheet name
Help with using ADO to connect Excel to Access
Searching for exact text
Using Active Cell Value in a Calculation
Copy Paste Macro
event after worksheet unprotect
CopyFromRecordset Error If More Than 911 Characters
Converting number to text
From cell/combo to combo/cell
SUM in VBA
"Automatically" get name of selected autoshape into formula? Impossible?
Cannot destroy Word Object in Excel
Copying Data Between Two Spreadsheets
inserting colon
Recursive Loop -- How to Stop It?
Calculating Rents and Months past in 1 cell???
Get, Set and Let
Counting rows in a range
Name of month
Passing references
Pivot name changes automatically
Making worksheets
word files with embedded excel objects
Macro to paste row number in cell
Bring up an error message
How do I add a search box
Re: Pausing macros
Add-in Description
Printing a Userform
Loop help
How to save the option button value
London Excel User Conference - Register now, it is not too late
Need help with an if statement
Cell adress for next non-blank cell in a range?
slow macros
Forcing user's to use the most current workbook!
Re: Forcing user's to use the most current workbook!
Summary Worksheet with VBA
ComboBox ShowDropButtonWhen error
Select columns of active cell's row
A couple of questions (formating & Collating worksheets)
Named range in a sheet referred to from another sheet
autofill method of range class failed
Addition of a macro to an existing Excel file
get values from combobox in excel.
read string from database and divide result into cells?
Saving Protected Workbooks
insert row on next sheet
Secure Macros
SelectionChange stops working
AS400 copy problem
Creating a macro to open as save other selected Excel sheets
cocatenation
check cell for #REF!
Compare strings in cells and highlight difference
CMD prompt output
Selfcert.exe cannot create a certificate
Keep text color
an earlier post
Validate WorkBook name
Excel 2007 vba question
how to make this in Excel...
Application.Dialogs(xlDialogSaveAs) = res ???
Hide Rows By reference to a cell
How to save compiled version of VBA macro
Hiding rows bt reference
Programmatically defining dynamic range
Data Validation list in Input Box... Possible ?
>> Defining a range
help with IF statement
Dates
Require some codes for variable in formula
Create Calendar Wit Data Auto Fill using Excel 2000!
Altering code to accomodate empty space
Input Box value saves wrong WorkBook file & AUTO Sheet Numbering (1,2,3,4...)
Graph Source Data
Use a button to copy the values of one range to another
help creating helper column
Sub that has an input of an array of ranges... what's wrong?
Paste Append?
Flash a label
Open Hidden sheets to specific point
>> Listboxes on a worksheet
A class with two objects?
Conditional Formatting 4+ conditions, format rows based on cell
Close All and Workbook_BeforeClose events
Unhiding all worksheets
Unshimmed Automation Addin and Shimmed COM Addin in same App Domai
prevent a special cell from being deleted
lookup
Protect sheets via VB6 automation
Application.Transpose in VBA EXCEL 2003
Single Macro containing multiple subs
Volume Calculator - Button
Filter on cell value?
Validate Workbook Name
Little Macro help
Can I use a cell reference to provide a value for a scenario?
Conditional Formating on Worksheet Change
Auto Load an Add-In
Print Format
Using Currently Open Lotus Notes Mail Server Info in Excel Macro
Merging XLS Files
Select sheets based on what is in a range.
Re: I said "Keep this text! Not a date!"
Re: I said "Keep this text! Not a date!"
find duplicates between rows, keep or delete entries based on ranked relevance
Userform initialize combobox using Chr() function.
Searching Database
Countif
Cleanly Trimming text...
Calculate event using chart data
Variable from Userform to Macro