Excel Programming [Archive] - Page 11

Auto Re-Numbering in Excel
Userform - summing selected textboxes
Cell Naming
Saving Input on User Form to Hidden Worksheet
Why messages fail to appear on MSNews server
Break Calculation Macro
Set focus on controls of modeless form
Find/Find ALL
How to refer to a workbook?
Using RIGHT to search for Capital M
Request Guidance on Visual Basic Versions
Linking textboxes with option boxes
Copy Order form into EXcel
Using Named Columns in a formula within a VBA Macro
Application.GetOpenFilename
Averaging Time
Open UserForm From A Different Workbook
Limiting files to open to only files with certain name.
in a macro how to make a part of the formula a variable
Excel VB - Testing Month within a blank cell
Arrays question
Workbook does not Save from User Form
select range with resize
formatting textboxes
Problem with hiding ALL sheets?
Excel 2007 split vba modules out of workbook (like Access front end/back end)???
Get sheet by index?
excel calısma sayfası sutunlarının ayrı fıltrelenmesı nasıl yapılı
Sub assistance
2007 Update
FIFO HELP!
VBA Code for converting Type-E UPC to Type-A (barcodes)
modeless userform
ExportAsFixedFormat : differences between Excel and Word
Clear a range of cells given 2 Cell addresses
Find Worksheet Name without On Error Resume Next
Fn = Cn * En
Custom Command Bars
I need a program created for Excel
How to Determine When Calculations are Complete
Automate simple process to run at 8 am daily
Setting font properties using function
Clever way to swap sheet names
Multi controls code
Macro keys to avoid
Print specific range but user to select printer
GoalSeek 1004 Error
Dynamic Range Name Anomalities
Userform with option buttons to print selected sheets
Conditional Formating Issue
Re: insert rows and copying cells in column b,c, and d into new ro
Select method failing
RE: insert rows and copying cells in column b,c, and d into new rows
Dae format
Copying a form to the same sheet using macro
Skip over a (calculated) cell in a Table
Error Message
Need help-For loop
double click not working
Detect "Save" menu event
Automatic Refresh Date and Time
Download a .csv file from a website
Calendar staying open
Close Worksheet and Making Worksheet Invisible - Both fail
Changing Tab order - easier method??
ExecuteExcel4Macro
Help with autofilter and filtering a specific column
instr problem with formula
Losing Quotes
Worksheet function
Automation Security and unexpected program termination
Solver? Maximum number of variables?
Excel 2003 vsto 2005 vb.net - ThisAddIn_Startup problem
set unicode in macro
How can I print a frame corresponding to page margins?
RE: Inputs on one sheet dependent on which sheet is visible.
Better Understanding
Where is the ActiveX Spreadsheet control?
Re: Set focus to textbox after spin-button control is pressed??
Re: Referencing a Forms Button in a Worksheet
Re: Problems with Workbook Before Save Event
Query from Multiple Workbooks
Re: Problems with Workbook Before Save Event
Saving a Workbook cause's Error's
ActiveX spreadsheet control problem
split problem
toggle between 0 and 1
Re: Checkbox variable
Re: Copy whole table into one cell
Re: code to make a block arrow point from cell A to cell B
Stop timer.
xl2007 - Slow Macros Involving Graphics
Help
Re: Declaring an array variable
Consolidate data with text
Copy data from one worksheet to another
Re: Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell)
Re: Copy whole table into one cell
Excel 2003: macro to add data to next empty row
Re: VBA for comparing data within a range for Excel 2003
Click a cell next to an item and have a checkmark appear
RE: Declaring an array variable
Re: Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
Re: Printing from a control button
Re: Disappearing Graphs
Re: Macro to delete rows that contain specific words
Re: Userform problem with "Run Time Error 75"
Re: Copy worksheet from one workbook to another workbook
Statusbar has disappeared - Excel 2003
Re: Type Mismatch with UBound and arrays
how to move sheets from one workbook to another
Using the Common Feed List in Excel
Modify The Code For Importing Text File into an Excel File
Setting range to last occupied cell
Recreating a pivot table using code
Automating adding/deleting rows and content with macros (I suppose
Pivot Table Calculated Fields
Run-Time Error '424': Object required when Saving Document
how to handle tdate and time
Display one sheet or two userforms while code is vba code is runningon another
Refer to sheets without using tab name??
Charts that are Off-Screen Disappear after update
Help with stetting Progress Bar
vba autofilter problem
2003 Macro not working in 2007
MACROS DATES
Write Excel to Access
Update Chart Source Data
Copy from sheet1 and sheet2 and append to sheet3 in different format
"ByRef argument type mismatch" error
USERFORM QUESTIONS ??
deleting blank rows for up to 60000 rows of data
Check if Excel file is already open
Test if "FileCopy" function fails
using For statement for populting textbox references
Problems with a Run-time error of 1004....
Color cells that match on two sheet
Seach Find txt file or close workbook in workbook_open()
Run program on save/close
Change operater in Excel formula
Problem with line of code / syntax
Update Headers & Footnotes from User Form
REPLY TO: how can i creat options in a cell of excel worksheet
how can i creat options in a cell of excel worksheet
Userform Query_Close() question
Get path to current workbook
How to write excel which is on different machine/server
counter in "If" condition
Preserve a variable's value?
Unlimited number of variables?
Saving File with names from Text Box's
Compare 2 col listings n append items in A not in B to bottom of B
subfolder and file creation
Breaking out rows of data, sequentially, into headered columns
XMAS
Form Controls in XL
Search and delete row
Close current workbook
MS Date Time Picker 6.0 question
Right click menu (context menu) for Rows & col not working
deactivate save changes
Bring my modeless userform to the foreground???
Moving data from one sheet to a template, matching numbers
Changing Meassage Box Title
ascii key value
search and return cell address
Run-Time Error 1004 Application-Definition or Object-Definition Error
Problem copying table data as a picture onto chartsheet
.xls is loced for editing
Problem with ActiveSheet code
removing rows but not based on a range
Information Source, Excel 2007 versus 2002 Major Differences Dec0
VBA for Excel 2007 versus 2002, Information
Can't print a PDF
adding lines of code to a macro to delete rows
Message Box Question
AUTOCOMPLETION FOR UDFs
Sheets visible toggle code
countifs
checkif/sumif question
Common Function for getting userform information
Userform question
RE: Trying to determine if macro is possible
Opening Workbook from User Form
Disable worksheet macros when copying a worksheet in VBA
Checkbox and linkedcell question
How to assign Spit to 1-origined array?
How to compress interstitial spaces?
moving a "count" range
worksheet_calculate event changes worksheets, but shouldn't
Windows 7 Corrupting Excel 2007 Files with VB Code?
how to call a sub that has arguments
screen resolution vs. zoom vs. activewindow
On calculate question
Copying Data Down the Column But Only Based on What's in Column A
What are properties of Application.Caller?
Run-Time Error 1004 on ActiveChart.SeriesCollection(1).Values =
disable pushbutton on spreadsheet
Insert Formula in cells from VBA
VBA in Excel 2007, NumberFormat
Solver with If-Then-Else?
if funkcion
how to capture the event changing the name of a sheet
Array Dim
Need to get cell address next to current address
Put parentheses around figures
Extra "." in file name when creating zip file in 2007 with 2003 co
Hiding rows with no content to right of Column B
Hiding rows where text not entered to right of colums A and B
function work with manual update, fails with copy paste > 1 cell
Change The Color of A Ribbon Tab
Modeless dialog box appears twice on screen???
Best way to check if cell is empty??
Best way to check if cell is empty??
Error with combobox control on standard toolbar
copy and paste whole worksheet from one workbook to another
control arrays
Error message when searching for an item not in a listbox
Icons/Macros Missing
Multiply cells and format to currency in text format
VBA: Copy a date and paste as text
2002 vs 2007 MS Office Excel has encountered a problem and needs t
VBA in Excel 2007 date formatting
I'm new to VBA - why more than one Module?
Assign a range to where the User Form places data
How to find the owner of the active excel workbook
Copy cell of one sheet to another sheet
3-level Hierarchical dropdown lists in Excel - possible?
Macro to open file
Adding list box
Sheets that mirror each other....
Writing formula to worksheet...
Variables Initialize
Range created using Union...accessing cells
autofilter values
Variables initiation
Split text into columns
Identifying a Pivot Table
How to populate a template for each customer
Convert uppercase to lowercase
Circular Reference
updating with now()
User to select a range for deletion
2003 vs 2007
How to set the column title in a listbox from Excel
Code to select active workbook worksheet(s) in Excel 2007
VBA to count periods in a single cell
If cell value is greater than another cell value, clear contents.
Excel Macro: insert formula into first blank cell in column & auto
vba code to enable macros
Insert and propagate Rows - based on a format rule
Getting Data from a 2nd sheet to show in a dropdown box on sheet 1
APPLY A CELL's FORMAT WITHOUT SELECTING
Data Bars
Wookbook Update
Countif
Find and transpose adjacent values
Daily Report Template
Comparing Date Ranges in one Table to Date Ranges in another Table
sheet variable
hidden comments boxes
Compare address to a range
Index Questions
Wookbook Update from User Form
Defining a range as a subset of cells in another range
Verifying if new data has been added to excel file ?
vba collection object in Excel
Excel VBA - copy csv info to specific cells
Hide certain columns in range
Goal Seek Advice
help with repeating data from cell above
Macro maximum range lengths
Log of each person that saved a file
CurrentPageList
Filesearch in 2007
Problem with external data and #reference error
How to browse folder and open xls file automatically in vba?
Named range in workseet code
Creating folder names from column data in excel
Using code to insert different formulas
Calender in E2007
Ribbon in Excel 2007: positioning buttons using box controls
Floating Chart?
Return missing features
Create named range of cells with values in row
Refreshing Pivot table
How do i print all visible sheets ?
Network logon
How to make A1 the active cell in all visible worksheets ?
Textbox and SpinControl - Class
Textbox & SpinControls
For you high bandwidth folks to download and evaluate...
How to Copy a VB Module
Analysis Toolpak in multilangual version
For Each cell In Selection.....
Right click in Pivot Table or on Entire Column
why doesn't on error work?
Dot in function names Dutch Excel
Set Userform label text if form is not loaded???
Your holiday donation can be a gift of hope to children in need. Getfree stuff for your baby when you donate to Save the Children, Please help us
Next inside If
How to check if a sheet exists ?
Macro needed
Using column labels instead of column numbers
Hidi keyed input with asterisk
"Coult not find specified object" and "Path-File access error" messages
Help!
Overflow Error But Right Answer is Produced
Combo Box Question
Excel Form "Component Not Registered"
Trouble selecting multiple sheets using RDB code
Newseries; macro to code
Open Excel from a VB6 application then use "Find and Replace" form
Detect whether there is an account configured in Outlook
ScreenUpdating doesn't prevent updating screen on Worksheet_Calculate
Count rows b/w values and insert that # of rows elsewhere
Indicators Bollinger Band in Excel 2003
Severing links to list names when moving sheets between workbooks
How to prevent "Private Sub Workbook_SheetSelectionChange" to execute when a certain sub is executed ?
Excel List
Show only Grand total in Pivot Table
Worksheet_Calculate code in same module as Worksheet Change eventgoes astray
Global Warming and what you can do to against it
Another SumProduct Question
Testing for a Cell within a range
VBA--Suppress error message,corrupt file or unrecognizable format
Resize Table Range to exclude zero values and Input New Range into achart object
Need help with locking columns
Force input in multiple cells in Excel form
Combo Box if... then... else question
Email - Signature with no Picture
DATEDIF(); an alternative available?
Select Case in a Change Event
Exporting Sheets & Naming new workbook & Breaking links
filtering results in excel
Loop with Step
ComboBox match issue
Refer to a named range in a seperate workbook
MsgBox with information on selected cells
open CSV.file
ByRef value not returned to the speadsheet
Pivot Table - ShowDetail property using VBA
Print Preview allows margin change in protected sheet
error handling
distribution problems; users don't have this and misc
Macro to move cells
Macro can not unprotect a sheet in a shared workbook
Coding Convention
Charts.Add - Smart, But Oh So Dumb
Excel Web Query
2003 vba to hide two grouped charts, works in 2007 but not in 2003
How Do Configure Paste Special Selections
Multiple data sets on the same graph
Unwanted MsgBox shows in error
Looking for open source depository of macros for Excel?
Using TEXT function in VBA
VLookUp and DropDown List in the same cell
Recommended Web based or DVD VBA Programming Course
Timed Event
Color in Check Box
The easiest way to copy a sheet of formulas! (Excel 2007)
Importing and exporting sheets from spreadsheets
How do add another code to a current one?
user form
Excel 2003 vs 2007
Trying to determine what cells within a Row have a 0 (zero) value
VBA Editor
variable target address
Summary that links to other sheets
using search function in VBA
Cell not selecting
Prompt to enter a macro name?
Creating several TextBoxes (Shapes) with cell references as contents
Select one cell insteade of a range
Using an Input Box to Unprotect a Worksheet
auto filtering on excel
Selecting Blank Cells then deleting those rows
Copy data from different columns of multiple sheets
Code falling over
moving from sheet to sheet
E-mail Notification Not Working
E-mail Notification Not working.
In VBA, check if file is corrupt or not Excel
Macro to Function
Row Height
Text Box Updating
Can you turn off the Full Screen toolbar?
object variable not set
Conditional formatting in text boxes
Get selected cell on sheet that is not the active sheet
Search & insert
Application.Onkey
Highlight first blank cell in column
Colors of Cells With Conditional Formatting
OLE Problem on Opening
Macro command to move cell selection
question regarding Visible Propery
Excel performance through COM
Copying formulas to other workbooks
Add File menu to custom toolbar
outlook subject from excel cell
Keep cell selection
Data validation on a custom format
PageSetup.Zoom=TRUE
calling up Save / Save As from a userform
Centralizing a command button on a userform
format
typing
Copy data from one sheet to another
PC Serial number recall
Way to import personal.xls from Excel 2003 to Excel 2007?
Limiting formulas based on filtering?
Deactivate button macro if condition not met
Auto Fill Text Box
Copy Active Range from one workbook to another
Copy a table from one workbook to ALL worksheets in a different wb
Code stops for one user, like it has a breakpoint
List all combinations
Storing time formats in strings
Select Field in Pivot Chart
Problem setting text on a userform's "label"
Run .vbs script on client workbooks
Finicky EssVRetrieve
Fastest way to select a sheet codename
store formula in macro then paste it when macro runs
Sorting rows out of order after all rows are numbered in sequence
Select case syntax for continuous range values?
Linking Check boxes to rows in another column?
OpenXML - Excel - How to close without saving
Go to cell based on input
Make pasted value in last blank cell the focus
Please assist. Extract Number from String
Want to create a file open box using a dialog box
image help badly needed
problem using excel function in vba
problem with excel functions in vba
True or False for a check box
Ticklabels Mutliply
append all instead of one
Delete code
datedif; what's up?
Conditional Formatting
vba proj
Digital Signature?
Chart question
How to Creating Array
change cellvalue based on value in adjacent cell
gathering info & importing to another worksheet
verify latest version
Pick a color from the default palette
VBA Project Code
Sumproduct in VB
text boxes
cannot insert object in excell 2007
Sheet activate question
break at space
Calendar Control for Excel 2010
How to do check for factors in formulas?
Insert Zip codes into weather code
Find all the files in a folder
Number Format. Switch Comma to Dot
visual c# excel 2007 pivot filter
User Defined Function Not Does Not AutoCalc
If Formula - Help
Copy-Paste not working after running the macro
Deleting Empty Rows using VBA code without the need to activate sh
OpenXML - Excel - .NET - Rows and Cells
IsNotEmpty Range
Re: Launch program using Shell function
03 vs 07: speed with different methods of referencing ranges?
userform label set enter
Text format as percentage
What are the parameters for print(,,,,,,,,,,,,,,,) excel4 macro?
SQL Query - Time being Removed
How do i select the coordinates of the first column & last row in a pasted range
Sumproduct Question
Adjust row heights of non-contiguous rows.
Can I detect what Control the cursor is at in a form?
Re: Numeric currency to words
RE: Macro slow (worked well until I upgraded my machine)
Macro slow (worked well until I upgraded my machine)
Worksheet change execution ends, but worksheet goes to never never
Re: Strange thing when copying a range !!
RE: RefersTo command uses double quotes
Selecting Sheet By Codename
how to retrive the exact figures
how do I fill in a cell with text in Excel macro (2003)
Common Dates. Is this possible?
Range to change size according to number in another cell
How do i import prices shown on Amazon.com?
Find method skips over cells
empty range?
Blanks -> 0 code
Date "yyyymm"
Hyperlink
Pass a command text in pivot table
Restrict cells selected to specific range name
Solution Required
Copy Selected Sheets' Data On New Workbook!
Copy paste code for a #REF
Stop sheet showing when Using Datapig's Force Users to enable macr
I'm chasing a random quizz template for use in excel 2007
Personal Macro Workbook
New WorkBook With Specified Number of Sheets
Moving shapes around excel using vba
excel spreadsheet for contributions
Expert eye needed
Groupings
Type.Missing vs. System.Reflection.Missing.Value as WSF parameters?
Re: use of integer in .FormulaR1C1
Learning Keywords Customization of RibbonX
Need to automate based on set of values and populate
String to be split
Sort 2 column simultaneously
Using user-defined functions in cells
Re: New time format
Display cell contents in a text box (shape) and linking
image help needed
Help with Macro please...
Rename sheet if current sheet name exists
RangeToHTML as plain text in Outlook
Importing data from Outlook into Excel
User Form / Text Box / Combo Box
Text Box help
imageMso
InputBox for a string of 2 to 3 keywords, separated with commas.
Help on coercing a range
Re: How to remove duplicate text with comma seperated
Edit Links in Excel 2007
Re: How to remove duplicate text with comma seperated
Re: New Win7 computer problems
Re: find function not working with merged cells
BeforePrint
Re: Numeric currency to words
Re: Sum MSAccess field quantities in a recordset from MSExcel
Re: Strange thing when copying a range !!
Bug in Comment.Shape.TextFrame.Characters.Font.Color in Excel 2007
RE: Quick Question
managing events; link?
converting numbers to date format
Shell open Notepad and write text
List Box Change Event
Load Userform on Workbook_Open()??
Remove filter in worksheets before running code
how do i move columns on one sheet to columns on another sheet
V basic codes
Select Worksheet Where Data is Pasted
Preprend Text Where Cell Not Empty
searching the entire workbook after scanning a Barcode
Action to take after autofilter
Syntax to combine MID() and FIND("LastPost:") to extract the LastPost Date ?
Generating Blinking characters in Excel
conditional format code based on lookup from another tab
RE: Check the conditions in "Q:Q"
RE: Check the conditions in "Q:Q"
loop to find text and place text in adjoining cell
Efficient use of sheet "codenames"
How to change chart properties.
Remove All VBA
Sheet to close
Why isn't range variable nothing in this case
is there a property instead of ScaleWidth method
workbook directory where is it?
Printing Only Rows With Values In Them Options
Problem in Saving the Activeworkbook on a network drive
DateTimePicker
minutes & seconds functions
Accessing substrings quickly
Const?
Using functions in string formatted cells
fire an event; SelectionChange
Worksheet_Change() and Range question
Runtime error - goto
Sheet name
Converting Header Rows to Add'l Detail in Rows
GetOpenFilename - Prevent delete
Name work sheet
Show Custom AutoFilter Dialog with VBA 2007
Copy and Paste link between workbooks
Problem with Excel add-in and .NET
Difficult problem (for me !) Lookup or something that i need to use ???
HTML Text retrieval
How can I use this expression "=SUM(RC[a0]:RC[a1])" work in Excel
CommandButton - Created using Forms, Not Control Toolbox
Copy text from cell and paste it in a separate text box (contents tobe linked)
Copy contents of a cell and paste it into text field
Problem with sheets that mirror each other
Range object does not support paste method
date and time picker control in excel vba
VBA referencing disappears with 2007 upgrade
Run-Time Error 3075
Changing the value in one ComboBox also changes the value of anoth
Excel 2007 & Custom Shortcut Menues
Count values in Visible ROWS only
Timer causes run-time error '6' overflow
VBA Loop Code
UDF to return as text
Add number to a list
Vlookup Error
RE: For Next issue with repeated procedure
Fix Column width in spreadsheet control?!
image help
Different Ways To Reference Ranges
Re: For Next issue with repeated procedure
DNS lookup in Excel
RE: Vb Assistance
For Next issue with repeated procedure
Vb Assistance
find match then change cell value
Disable Minimize/Maximize button for Excel 2007 Application
Autorun Add-in
Very Slow Worksheet Calculation
user defined charts
xlsm SaveAs xls
Spin button
Select column that matches a value entered in a User Form TextBox
Date Format
90 day reminder
auto refreshing sheets
Eliminate Taskbar updates
Rename files with VBA
Address Transposing
Identifying anc saving workbooks from more than one Excel applicat
Trying to convert text to number
thiscell and udf
Logging onto a website
Controlling the number excel gives to charts
Range error
Static global varibale - where tu put it?
Interupt code with message before it runs
Declaration w initialization - for dummies
At each change in data apply formula
How to Connect a network Drive
2003 xls(macro) occured error when opening with office 2007
count number of rows in 2 worksheets
get number of rows
Dynamic Data Validation
Piping data to other office applications
Read and write access database
Read and Write Access Database
User form Text Box & Combo Box.
Running a report using a macro
Excel automation, change Category (X) Axis Labels, VB6
Clear Format problem
RE: If *Total* make row white
Some help with a workbook please
Re: If *Total* make row white
Re: If *Total* make row white
Why do windows go blank?
Macro Not Showing in Alpha List
How to flush file buffers or ensure reliable writes?
If *Total* make row white
Does variable set to cell value automatically becomre cell value?
How to overwrite data in file?
Countifs for color format
copy value only...Copy Destination:=Cells(3, 2)
Creating a variable range in Visual Basic
ending "html" or change
Delete all rows where column A is blank
Advanced Filtering Problem
Programmatically copy Conditional formats from one cell to another
Using VBA to assign a macro to button
Updating a workbook from many workbooks.
Possible offset issue
Copy named range based on variable
multiple "IF" statements in function
Writing Data to an External File
Subtotals by Column
Passing parameters to a Web Query
Matching Columns
Change cell value between EMPTY and X when i click on the cell.
Make a Button Blink????
copy-paste information from different workbooks
Formatting Imported Data
Split workbook into multiple workbooks
Split workbook into multiple workbooks
extracting data from a pivot table
If Column M is less than 15
Groupuing User Requirement
excel image help
reference an open instance of IE
Embedded chart location address
Call a cmdSend_Click macro; non-click interaction
charts; myChart.SeriesCollection(10).Name; lots of quotes
How do I add a function category
action on open
Match and Reconcile
Insert a space in all blank cells of the first column
GoToEnd Macro
Excel hyperlink that links to web which opens a new Excel book pro
Set workbook name not working
Making a frame visible or not using a command button
File grows
Collecting data from multiple sheets
Macro filter multiple criterea
Help using indirect addressing in chart series
convert longitude into time
Publish embedded chart XL2007
Format some, not all, text in a comment
Worksheet Change Event - track changes
Text labels on a Userform
Find Total and insert one blank row below
Opening Files
Opening Files - Marcro
Opening files - macro
Opening Files - Marco
General question re Error Handling
ChartObjects Insanity - Excel 2007
Formatting Col C based on data in Col B
question about excel formulae
Color rows based on date in a cell?
ModifyAppliesToRange
Bundling Hardware Request
Populate Combo Box with Access Table Data
hiding columns; dynamic
Remove a "0"
vlookup is not the answer
Linking Combo Box Values to Access Table
Overstrike problem
Formula for vlookup and then sum
setattr
Display a userform and have program continue
finding next number in a sequence
copying sheet name
Macro to concatenate columns
Microsoft Query is not importing all data from an excel file
Locating my personal.xls
Enter key functions differently after different macro behavior
Application.DisplayAlerts = False does not disable alerts
Page footer
How do I calculate number of colored cells?
Name of values
I need an Excel Genius !!!!!!!!!!!!!!! Headers/Footer Changes
User can't see Input boxes
Using Range names in selecting chart series.
VB Help
Automatically opening file saved to someone "Documents&Sett' direc
Catching check/uncheck event accross multiple checkboxes
Hyperlink powerpoint object to excel range?
command button controlling a range of dates
Print Range
How to ignore embedded linefeed in CSV quoted text fields?
Excel 2007 VBA Pivot table fetch records
VBA Excel data to SQL Sever table
How to prevent list item selection
Check for >0, then offset down 310, left 4, Check for = 0
losing date format when referencing date cell on another sheet and
Hyperlink from HTML to a specific Excel workshhet
Move Flagged Row(s) to a Different Sheet
Embedded Chart protection
Change jpeg Picture in LeftHeader
Comparing to tables of data to confirm they are the same or not
How can I specify more than 2 criteria in AutoFilter
How do I Loop and Change Button Color???
Find a vlaue, shade another cell
45 seconds to save a file, why so long?
Userform hide help
HELP: Display a message when one of the names is displayed in a ra
find user's computer name
Reset QueryTable error on empty text file
Arguments within loop
Using an iputted array across multiple worksheets
Change Header/Footer w/ Worksheet Option Buttons
Userform List boxes - editing - then option to save changes (or no
MS Excel VBA Pivot table link cell fetch records
Creating New Worksheets & Sorting Order of Worksheets
Read/Write to OpenOffice
Animated Clipart
Excel 2003 (8316.8221) screen corruption
Range.Value2 in C# (Excel 2007, VSTO 2008)?
Macro to open a workbook as read only
I have to compare two sheets for changes
Syntax of Commands Created by Macro Recording
Working with Excel 2003 from a Visual C++ program
Fun with Userforms!!!!
How to filter the QueryTable from a Web query
How to obtain the row count of a QueryTable from a Web query
Date format converted from UK to US format
Detect Excel minimize and restore?
Calendar and userforms
Screen position of commandbar button in Excel 2007 ?
Code condition
Copy/Paste Controlled by Timer
vba to convert htm tags
Go to worksheet upon opening
Prompt to select from a list in another workbook
User Form Problem
message box - title change
Using custom charts with other computers
Uaing custom charts with other computers
compare two files and merge rows base on a matching word within thesetwo rows
IE code
Coloring a row
Compile Error using Dmax funtion
Problem with Bob Umlas sub total code. Coming up with user define
Find a value and color that cell
XLL, C++ and dates
next column
Characters same length in column
ListBox issue
Use Scheuled Tasks to fire Event Code
Compare two columns in a different worksheet
Excel 2 web
command not found when using excel VBA function format
Pivot table - unwanted lines
Specify certain length(characters) when defining a column
Last used Column
Userform - Title bar formatting options and other attributes
Specify certain length(characters) when defining a column
Specify certain length(characters) when defining a column
Position Chartobjects in Chart sheet
Change font and/or font size in headers, footers and body via VBA
Height of shape
If column contains a value - Error Trap
Hidding zero values
application.displayalerts
Formula R1C1 in VBA - Strange Results (Dynamic)
Closing FIle with Command Bar Button Problem
Saving time on calculate
Hide form page
Find all Hyperlinks present in a sheet
Calling a subroutine - how to?
Problems with add-in after upgrading from Excel 2003 to 2007
different color for duplicates!!! how?
File Path
Get Formula
Copy Formula Down until last row
Buttons in another window
update links in Word from Excel
Changing the text of a label on a Userform
Pivot Table - Add calculated field using field number (index) vs n
Test if a Userform is loaded or activated??
File Path
Sort problem (Excel 2007)
File Path
Keeping from declaring a direct path
Printing Contents of UserForm
Menu Maker and Excel 2007
User Form Appears Blank
Menu Maker and Excel 2007
How to make a number indicat a persons name on another sheet
Time formatting issues
Changing "Office" theme colors
Locked cell Change Message
Waiting for an external app to finish
listbox inconsistencies
Help needed with 'Save As' dialog
excel formats
Enter code by a macro
List Box - part 2
Excel 2007: getItemLabel not working
Trust access to the VBA project: Excel bug?, workaround required.
Set Status bar back to "Ready"
File calculates with each cell input
starting Word with an Excel macro
View Code for pointer?
User form problems
Path and File
Path and File
File Path
File Path
File Path - Macros
When "Save As" is selected
Common dialog not registered
Picture size increase/decrease in size using code
Floating userform appears on task bar???
Is this Multi-Search Macro Possible?
Constantly loaded userform??
How to save contents of cell range in an array?
"Do you want to save changes?" question
If no default printer Open Print Diablog box
Update to Access Multiple tables via VBA
Sheets changing name
Sheets changing names
Password concern
macro help on find and replace
find number and replace after multiplication
excel pivot tables
Unique Problem?
list box help
Excel To Web
XLT vs XLS
Sort data from smallest to largest
Excel 2007 Chart Colors
fill a variable sized range
Excel Query of Access Q
Stopping warning message
User Form Input Question
Can I Have Beter Code For Search Than This
Copy Range and Assign a Defined Name to the Pasted Range
date of JPG photo file which is taken
Workbooks.Open() error handling
passwords - userforms - remembering password has been entered
To Capture the time stamp on entry of a value in cell.
VBA worksheet references
VBA Digital Signature not working
Clearing background color in printed copies
Form load/initalise error
Using a single cmdButton to perform different tasks
All cell contents within a range of cells turns white if Sheet1!A1 =1
Appearance of Controls misbehaving
If Column T contains then
charting, adding a random gridline
Issue with QueryTable.Refresh Causing CPU to Spike to 100%
concatenate formula result with text ?
Where is the Treeview Control in Excel 2003?
If Column T contains then
Read and find
Hyperlink Macro / Hide Tabs
set rowheight property
Convert cell contents to number
UserForm + Dropdown
Grid / Spreadsheet like control in 2007?
Changing the Year in formatted Date
Screenupdating = FALSE not working
Populate TextBox with Change Event
Auto detect the range depending up on the input date.
Next Function in Array
Combine rows of data and use if/then with results
Create a textbox that displays a list of possible items as we type
Updating large pivot source data
Application defined or object defined error - Not Caused by Code
Unwanted Calculation
if workbooks exists delete
Insert formula and copy to a range of cells above
User Created Menu
Updating Header / Footnote in Excel 2007
Excel limits question
macro copy and paste
Parameter queries
Excel date / time picker control
VLookup Formula's
intersect question
Calculate week from current day
Export(Save AS) workbook without macro on browse location
Matching records based on multiple columns
Crash of Excel 2007. Prog. only wil work after manual start in VBA
popup warning
How to update all headers in Excel
Rename a .txt file via Excel macro
summing text boxes but do't include disabled ones??
Command button - compare computer name with a pass code
Deriving a name from variables
Run macro upon opening document
Referencing a cell in another sheet through the use of variables
Skip the Zeros in a chart
Exit For statement in nested For ... Next blocks
Move row last on change of value
Transpose 100 sheets in a directory automaticaly
Create a smart textbox that display a list as you start typing in
excel language version
CountIF by Background Color
How to Filter a column & Indent all but the 1st header record
Dissable Workbook_Open Event in certian cases
Set an Object
Help setting a File Name
Format Shape Using ThemeColors
getting info from a pull down menu and looking up column to get co
Excel 2007 Chart SeriesCollection(1).Interior.ColorIndex
stopping a macro
Hoping a VBA master can help with this...
macro to exit design mode
Re-protect sheet
Multiple Worksheets Protection
Command button - check listbox contents before activating?
Locate Value in a set Row, with Dynamic Column
Progress Bar
pivot table - date problem
xl2k vs xl03 code difference
Saving Multiple Tabs as CSV
disable CUT in Excel
Excel to Visio
Lookup Function in user form
Format text box with check box
VB Code
How to check a list for single letters between text
Combo box listing in same colour as list
Want to blank some cells when an AutoFilter is active.
Reference Global vars in cell formulas?
Merge Append all sheet
Get name of active sheet
Copy range with offset
How to reduce excel file size having pivot tables
what does pvargColumn and pvargIndex mean?
VBA Macros and Windows 7
Copy selected columns from .xls to a .txt file question
how to close Printer status bar
Call up computer name
Data connections properties include column headings
Trapping Error Message
Refer to a named range
rows in a table?
Finding last row
Format Center Header
Find function for a listbox table in a userform
Send Element to Back
vbe-disclaimer
Excel found unreadable content
Deleting rows triggers the macro :(
Find Reference Workbook with Code