Excel Programming [Archive] - Page 37

Re: change the appearnce of a userform
variable not set
RE: export visible rows only
Conditional Formating Issue
Create calculaed members in Excel 2007 Pivot tables
TO ARM REPORT FROM BOOKS CLOSED - ADO
Re: Variable Syntax
VBA - checking for existance of a property
accept fractions from textbox
Error 424 for sample code?
color formatting from vbe
macro adjustment
Shortcut key to commandbutton
Excel Macros
Excel CDO mail
CDO mailing from Excel
looping through comma delimited text
VBA and VB6 functions return different answers?
Enumerate cell formulas
remove Add-In?
Find Help
Selecting File to do VLOOKUP From
For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3
find a value in a column then copy next few rows
Checkbox works in one window but not another
passing column character as subroutine parameter
from VBA to DLL VB6 for security's sake:recommendations sought
2003 2007 Code
Need a macro
Testing Blank Conditional Formatting
Conditional Formatting
Insert text from Comment in 3/4 TextBoxes in a Form
Remove Columns with header in row 1 but no data in remainder of co
Display a Line w/ Caption instead of Frame w/ Caption
Manipulating Multiple Versions of Excel, c#
Print Formating using VBA
Select a column within a query
How to avoid warning pop-up dialog boxes
UDF for dynamic custom lookup?
UD
Excel macro to copy row from one tab to another based on certain criteria
Referencing a row with a maximum value array?
referencing the actual row number? How?
Macro - move active cell to another column; same row
How do link the prolog output to an excel sheet.
How do link the prolog output to an excel sheet.
Data Source, auto populate rows and columns
ADO connection not opening in Excel 2003
Newbie here .
Pulling out numeric number from Activecell.Address
Passing array elements to a function
Turn display alerts off then back on at close
Choosing Active Cell
Fixed 'Find' or 'Look up'? cell - is it possible?
Writing a Sort Macro
Newbie w/question
Workbook Properties
How to retrace the execution path?
How to knwo the current statement
Copy value from formula result on event change of cell value
using application.filesearch for searching text in PDF
VBAProject Protection
Avoid Prompts on Workbook open?
Conditional Formatting through VBA ODBC
Should I use Excel or the OWC11.spreadsheet control in a web page?
Hi all,
new Freeware Excel add-in for importing from ODBC data sources
Protecting Sheet
Delete Page Breaks -
Copy paste without selecting sheet or range
Open txt file without changing date
Using VLookUp
Excel Wscript Selection Problem
Handle an "Excel cannot complete..." alert window withVBA
remove VBA codes while saving
epression REPLACE
username and password when login
help me(indirect function error)
Validations with messages in userform
Macro to look up and match names?
Is it possible to link an Excel Workbook with a data base?
Globals Go "Poof!": Workarounds?
Finding attachment point for comment textbox
Excel 2007 - Format of New Documents
VB Macros for Charts - Fails (Office 2003 on WInXP Sp2)
Importing Microsoft Word to Excel
Security settings for Excel 2003 are lost on Vista 64 bit OS
Is it possible to change and entire worksheet to text?
profit margin based on prices
preselecting in combo box
String Comparison
task scheduling
Help with transpose?
Are you telling me all a virus has to do is run from XLSTART toovercome Excel macro security?
IF statement
Logging data to worksheet
Insert a Row - Variable Location
Which references will I need to reinstall on a new machine?
Unprotect entire sheet
Custom menu items in a copied workbook
Creating a macro to filter data on multiple sheets
Set Pivot Table Pages
Copy and paste every x number of cells
Application.FileSearch Problems
If cell 'a' matches cell 'b' then copy cell 'd' to cell 'e'
List all link cell to other workbooks
Run a Macro just after i open a workbook EXCEL
Help with Autofill
referring to a textbox on a different userform.
RTD Links retain previous values in certain conditions -- bug?
Run Time Error 3343 - Unrecognized database format:
AutoFilter Trigger Calculation
Pagefield - select "(All)"
Sum column values and insert result in last cell with VBA
Saving w/ Stronger Encryption in Excel 2007
Change in cell disabling events
send email macro with Outlook running
paste file name of an OFFice program into a cell
last record
Vacation Accrual
VBA - Copy paste all Modules
Duplicate in Row
Excel 2007 data query parameter issue
Sendmail, XL97 vs XL2k
Evaluate text formula in VBA
Duplicate removal macro keeps newest record
Sumproduct with Autofilter
Starting Outlook via FollowHyperlink event
activate code upon save command
VB Help If Statement in Selection.ShowDetail = True
Macro not running anymore
Sum all Cells with Interior Color Index not equal to 0
Is there a steep learning curve for excel 2008 VBA as opposed to2003?
How do I use VBA or a function to do a certain type of string work
Pagebreaks vs page numbering
Problem with Worksheet_Activate event
How come code written by a macro won't replay in excel 2008?
Collect data from Excel files
Automation error
View workbook
Function that groups together Overtime hours by 7.5 hrs
Automatically Update Excel Graphs
copy data to combobox value sheet
List Problems
Use VBA to display record with criteria
Pivot table - sorting
CommandButtons have stopped working
How do I modify this macro to print the currently visible chart?
Viewing hidden data
Command Button
Place TextBox Behind Other Controls on a Workshheet
Filesearch won't clear
>= Greater than or Equal to Not working
Excel macro security fails in directory XLSTART.
Font color in userform controls.
User form- protection and password.
Does a Pivot External Source to SQL Server stay connected?
Open Office Outlook & Insert e-mail address
override old format
conditional format question
Problem using internetexplorer object to open a url
Easier Method
Difficulty with copy and paste
Concatenate
Date Format HELP
VBA Structure Charts
Adding images to cells via VB.Net
How to add an array to a combo box with Excel 2003?
Formatting Comments
xl2007 speed issues
Inserting Formula moving down each row
Update Add-in
Splitting cells
Event Fired when Calculation Mode Changed
Signature Authentication
Relative links to worksheets
Comparing
Search and Find Missing In Action
User Defined Functions to separate full names
Listing Occurences of a date
SharePoint Versions
Selecting Shapes
Adding Data Label value with VBA to a chart
Error 1004 - Unable to set invertifnegative
Conditional Formating
Dependent Validation List
Alternate row shading
Is there a way to skip lines (insert value every other line)
Locking Cells
Processing a Message Box w/in a Macro
VALIDATION FUNCTION HELP 2...
import multiple CSV files into one Excel file
CLEAR FIELD TEXT ON CLICK?
End of Statement error
how to access column 8 in my Range
VALIDATION FUNCTION HELP
Goto ("A1") in non active sheet
Adding up range of cells exclude hide cells
Excel Workbook.SaveAs xml spreadsheet gives garbage number
with a macro open a workbook without the Auto_Open running
Publishing a static table using jscript (Excel 2007)
formula in code
Delete last sheet in workbook
Color Change Syntax
Lookup from a list of numbers
format the cell Comment
Date field in user form & Loading a user form on opening workbook
copy row based on match and multiple criteria
2nd TRY: Up from 2003 to 2007; code now throws error creatingobject??
How do I make a cell truly empty using an "If" statement?
Multiselect listbox if no selection
vba - Select Used Range minus the top header
Run-Time error '9' New Question
Programmatically add worksheet function
excel 2000 to excel 2007
Procedure level array not recognised at module level
Limiting access to registry
1004 Error on Workbooks.Open when run from inside IE
Autocopy instead of autofill
accessing Outlook Address book from Excel VBA
Array function not working correctly if I use an "or - statement"
Need worksheet Event for Sum
Build data from Invoices.
first space from the right
Date Field Problem in Userform
Start Word within Excel 2007
VBA "Excel & Outlook" **************
triggering Workbook_SheetCalculate
Copy subtotal results
programming issue when using Excel automation
Macro doesn't record action on a chart
Super Hard Question
Re : Excel Chemistry Before and After
Finding cells with matching data
Replacing column values with formula values
don't want column width change after refresh
why does s.TextFrame.Characters.Text work only sometimes?
PrintPreview problem in 2007
Run-Time error 1004. Help Please!
how do find the actual macro file on hard drive to send?
url content
Fast Way to Delete Rows from Big Spreadsheet (Using VBA)
url content
Excel file on Treo to dial phone numbers
text in file
Excel 2003 Markers
2007 Copy Paste Disabled
Getting Worksheet_Change to Ignore First Row
Highlight row any random color using same random color with duplic
Setting a spreadsheet to auto sort data entry
Auto select rows
RE: Vista won't run macro in excel
For...Next not copying text from Worksheet to Worksheet, but no Er
Ranges and Number Combinations
Ongoing Issue - I have tried to clarify so that you understand
Strip 2 Numbers from a Hyphenated Range
Sections of Excel 2003 pivot â€œblanked outâ€ in Excel 2007
Autofilter icons shifted to top row in Excel 2007
combining worksheets
Problem Setting Worksheet
How to Populate an Array with a Discontiguous Values
1004 Error in VBA Conditional Formatting Code â€“ Fails in 2007
VisibleRange references
Adding the next month to a daily volume tracking sheet.
Textbox problem in Userform
Probably a rather basic question....
changing date format
does the "Range"object in excel2007 vba still have 65k row limit?
Active chart screen visible coordinates
Loop through sheets and get number of records per sheet
Writing a VBA program
remote references and external link values
Help Loop question
select range
How can I automatically split values over specified time periods?
Displaying Data in Matrix
Combine two workbooks into one
Creating a custom toolbar add-in in Excel 2007
Workbook_SheetCalculate twice
DB2 timestamp format
Make Sheets.(Range 1) = Sheets.(Range 2)
Options for error output in custom Excel functions
Counting colored cells
Loop through sheets & filter main sheet using sheet name
Determine which variable was used in a calculation.
Data check
Count difference in days input box
Closing a recordset error : Operation is not allowed when...is clo
For To / Next loop doesn't update...
Macro for popup window " update values"
help with chart script and data labels
Using SendKeys to ‘activate’ a tab on 2007 Ribbon
Get templates files and copy data to it
RowNumber corrupts formatting of Querytable
Help to create worksheets from a list
Matching cells (Excel 2007)
Invisible sheets
Using Data>Validation cell formatting to drive OnEntry/Intersect m
VBA equiv. of Ctrl-Home w/Freeze Panes?
Autoshapes on Excel user forms
VBA, Search!!!! Help
Error handling error # 1004 Run-time error
File on taskbar
Catch name of range
VLOOKUP with two Workbooks
Delete all object
Conditional Formating
VBA Sumif *********************** Help
Check if data is inputed.
"Workbooks.Open" fails with 2007??
Code Needed for to check data input
sort entire range with exception of last row
VBA Time comparison not correct
Looping
Workbook Reopens After Close
cell color change with click and record the the time and date
Can't Click Anything
How to calculate a Max / min in a matrix
adjustine the range of a selected cell
Comma replacement
Excel crashes when I add VBA code programatically
missing modules in personal.xls
Conditional deleting of rows
Problem with code - Help needed please
Const and VBA values
matching multiple columns on different worksheets
Macro to Hide blank rows
Forms TextBox Vertical Scrollbar
setting delimiters
Error Cell "#N/A"
Combobox Error message in UserForm
Center text in a shape textframe
how do i separate addresses and place results in another cell
Advice on code
cells function
find & replace
Anyway to detect a new page
Macro to copy and paste to another sheet, based on if-then-else
how to declare a public workbook?
Bind Event Prior to Print Preview
Force CommandBar Position
Check if file exists
Remove Validation Input Messages
Sql probleme on emty cell
UserForm specs
Print preview / full screen view problem
always on top
Sheets() and Window() Objects not working?
how to add up string or text together
Select one checkbox to Deselect another
Vlookup
error - select method failed - (columns.select)
dsofile.dll changes lastsaved of non office files
VB for scatter graph help
Importing data.
Auto Open macro go to beginning of week
Inserting 3 blanco rows
ParamArray passed multiple times in nested procedures.
comparing two excel sheet and providing the outcome in a 3rd sheet
comparing two excel sheets & showing matched data in 3rd sheet
Using SetFocus with Frames
Referencing the worksheet name in an excel function
Programatically adding code to a worksheet
social security number problem
VB and Word
RE: Unexpected result from IF statement... Help with formula.
Find, copy then paste problem
Clearing Duplicate Entries
Combine two Codes into one Sheet
Click event sort ascending then descending
Combobox_change event fires when a workbooks is saved
Crystal Reports Newsgroup
Mail merge macro: select recipients from Excel during merge
Excel 2007 to SQL Server???
Subtotal
How to code a macro to sort a list of string?
Replace string
Urgent... Getting error in accessing named ranges in excel 2007...
Create Pie Chart with Percentage and Show it on Userform
Need help Finding row number of the last row with data.
Just type the particular word
Macro to generate worksheets
pivotitems updating pivottable.... help!!!
Find and display only duplicates
Protect View Code?
Excel export Issue
InputBox positioning
Compare cell and msg
Date Formatting Within A Combo Box On A Userform
duplicate vb projects occur when reopening a sheet
Change enter key direction based on range
Getting Path Of .XLS?
.NumberFormat not getting applied?
Hyperlink Base.
Active sort / Copy
Opening .XLS In VBA: Getting "Do You Want To Save..." Prompt...
Problem where end time is less than start time
changing properties of offset cells
Running macro on multiple files
Web Query
Adding values stored at relative cell references
PivotTable
A cell is in which named range?
Re: PageSetup is very slow
launching an external application within excel using contents of c
How to bottom-align a control on a UserForm?
formula error
StatusBar not updating after Shell call and wait
Query to look in default directory
TreeView node is Selected but grayed out--how set focus?
find a designated value in all workbooks in a designated folder
Navigating Indentured BOMs (Parts Lists) in Excel
Excel 2007 VSTO 3.0 Intranet deployment issue.
Arrange Icons on Taskbar
Excel does not get the FOCUS
OnChange event attached to tick box
Excel Medical Template Help Needed
Excel Medical Template Help Needed
object library or invalid reference
Max of a range help
how do I display the greater of 2 values in excel
Position of MsgBox
Handling Print Preview Event
Range of Cells
Problem using Interop.Excel in a web service
Splitting up one's highlighted selection as if you had used to"control" button for each selection
Excel limits
test
Convert text file into columns
COUNTIF and programming
move.worksheet command
auto row insert where TRUE in column A
Error 1004 - PasteSpecial failure
Open TXT file
Macro disable message
need help modifying ron de bruin email macro
SELECT CELL AND SEND THAT INFO TO ANOTHER CELL
auto line inserts needed
Turn on reference within a macro
How do I enter data on one worksheet and have it appear on another
Opening a file whose name is continuously changing
Include cell text in MsgBox ??
Macro available to multiple users via network
Macro Programming problems
variant array with formula strings to range formulae
HLOOKUPs returning an NA value
Fill cell values on Interiorcolor conditions
Select the Add-Ins Ribbon tab using VBA
Excel to notify date of birth
Dragging form
Trouble with "Create separate sheet for each horizontal PageBreak"
Number of cells in merged cell
for loop with step increment of 0.1
Error 1004 on long For loop, adding hyperlinks. What's going on?
Buttons Object
help needed! excel formulas above my head!
How do I retrieve a specific record into excel from an external db
Start value listbox
Temporarily pause macro so that changes can be made on a workbook
Startup Tab
Change font to Italic
Executing macros in different programs
Copy in a range
VBA HELP! MsgBox & File & Sumif ******
WinAPI Resources
Button Text Problem
Object variable or With Block variable not set
DLL calls from Excel VBA in Vista
vba calendar
ShellExecute
Find row referenced by a formula
Help - simple but doesn't work.
Move a single combo box from one cell to another...
Another Conditional Formating. NEED ANSWER TO FINISH PROJECT!
Cell Entry Dependent on Option Control
How to have another worksheet do the calculations
Need to fill a column if the column next to it is not blank
Email worksheet with outlook 2003
Excel sample with ADO / SQL
Re: Disabling Text Boxes without Greying them out?
trouble shoot Selection.AutoFill Destination
Conditional Formating
Subtotals + Autofilter
Custom Macro
Paste Excel2003 to Word2003
macro to copy rows and paste-special to another workbook
Control not added to "Object/Plot" command bar in Excel 2007
Formula Help Needed (Sum and If Then)
Macro code to dll and vba code trouble shoot.
Automatically resize a cell
Multiple Product selector
Re: winzip - rondebruin's instructions
Stop Symantec AV from quarantine my VBA
VBS for excel named ranges
How to know if an external link is working
help with code
Update links only if file exists
RE: winzip - rondebruin's instructions
Re: Fix charts as embedded pictures
Automatic Updating of Changing filenames
Re: Calculation slowdown at the bottom of worksheet
Creating formula to bring back a value.
Re: Fix charts as embedded pictures
RE: Help on mail
Re: Give array values
Macro to copy and paste
RE: data validation trouble
Re: Press F2 with vba
I need a "0" when cell is empty
Re: Adding up Time in a text box on a userform
Need to open HTML Document
open HTML document as text file
RE: select column
How is Worksheet_SelectionChange Work Different From Worksheet_Change?
Code to create a list of records in another sheet, based on the entryof the word "Terminated" in a given column
QueryTable Refresh Failed
xlDialogColorPalette argument
Listing months between two dates
Creating charts in Excel 2007 through VBA. Any examples/tutorialsout there?
auto add to list
SQL Delete Record using Excel VBA
Macro needed for billing purposes -- any general code ideas ?
Complex allocation of workdays within Gov. fiscal year
How to get values for Range.Validation dropdown from a second work
Copy a row of data from ne worksheet to another
Need Formula to Calculate Time/Overtime (2)
Change Web Page Drop-Down To Fire Code
Time sensitive please help!
Runtime errors relating to unreleased references?
Concatenate columns, variable number of rows
Can I graph an auto updating cell
Help ... what wrong with this code
test
Help ... what wrong with this code
Help with VB Script
open HTML document as text file
Exit event/textbox/frame
exporting data to the middle of a text file
code to SAVE
e-mail using addresses in Excel
web query tables destination
Excel VBA UDF Math Expressions
Macro to copy and paste
vba comment box
prevent carrige return from being pasted
GetOpenFilename
XL2002 - Sort xlAscedending / xlDescending
copy data from one sheet to another
VALIDATION FUNCTION HELP
active cell range
reposition combo box **
Creating an Auto Sort Indicator
Random
Saving an XML file to a sharepoint location using VBA in excel
Setting up the same Ranges on Multiple Tabs
Excel Access Violation
2007 is coming - what will happen to my macros?
Macro to Hide Rows
Macro to merge and format selected cell
Strange Range Behavior
Combobox.value reference
Change a Variable Name in a For...Loop
efficient code to copy/paste
Sheets Loops error
Macro don't run when workbook copied to new machine
Async UDF
Excel/Outlook Email Notifications
can .range return a 1D array?
Check a collection for objects that may or may not exist within it
Re:Closing an excel file without saving it.(look through the code ple)
Totally confused about forms + macro
SQL String
What Shape was Clicked ?
Nested VLOOKUP in IF statement
check selection
Input message problem for Date textbox
refer to a named range in this.workbook
Data from a network location
Trying to use udf in add-in
Form Update
VBA Excel macru - Instanteneous Currency rate update
Deleting Null Rows
Nested IF statements - Help
Urgent Help Plss
Extracting Column Letter
Getting rid of #DIV/0!
Need formula or macro
cell subtraction problem
Lookup copy and update master workbook
Reference to functions in Conditional Formatting
Problems with substitute
Using conditions to determine field references - is it possible?
declaring
Print page 1 portrait 2 landscape 3 landscape 4 portrait etc
Extracting a string out of another string
Possible to return values that equal set amount?
Custom Tab Order
matching a format in a lookup
Formula help for a newbie, please
Excel 97: Copy Range with all formatting to another Sheet
Loopinq question
VBA code help
This should be simple if I knew any better...
How do you open web links to excel in excel
User Form
VBA Chart Error
VBA "Code execution interrupted" error on End Sub and End IF c0mmands??
How to hide rows, but not blank rows used for formatting
Custom toolbars and Excel 2003 - 2007 portability
UserForm - Stop updating the caption after I click on.
Refer to 1 cell relative from named range
help with macro vba
Print macro to bring up print options
Print macro to bring up print options
Simulating Forms Checkbox click
Run time error 9 (Subscript Out Of Range)
Phone book formatting
Disable Control Checkboxes based on Option Button result
Insert One Outlook Contact Name & Address
Looping thru ComboBoxes on a Worksheet
Input box sorting?
documenting all UDFs in an XLA
Help with code to change file name PLease
Caluculating and Posting to a summary sheet
4 conditional format
Problem with an estimating program
Excel 2007: blue is no longer 0000FF
User-defined type not defined
REALLY need help automating
Linked cell
Need consistent path name for Excel-->Access query; Excel keepschanging it
Identifying Linked s/sheets
Simple Action. Please, could someone tell me how to do this?
Summing cells
Excel spreadsheet functions
save worksheet as per the active cell
Keep Cell Unlocked but Don't Allow User to Change the Text in Cell
Enable Property of Multipage Control Pages = CheckBox.Value
time frame restriction
Run time error 9 (Subscript Out Of Range)
For...Loop to verify at least one checkbox = True
Can we zip a file using macro.
Can this be done?
code for sorting data
XL2002 - Group / Outline / ShowDetail...
Help with Excel and Sharepoint
Help.........
Restriction for the Date Field in UserForm
PASTESPECIAL THE COPIED DATA IN " With Sheet " STATEMENT
Macro issue
how to block sending mail from excel workbook.
Excel 2007 insert HTML with images
Setting the row height based on a cell value
RE: help
help
help
List Box Item Format
Maintain image selection
is RND really random?
hi
help
Populating cell from database (1031 characters)
Syntax problem with code - chip.gorma
Troubleshoot Overflow
Dropping Data When Copying
Variable dependent Custom Dialog boxes
Find optimization
Paste selection minus the first row....
Macro to compare columns and output the results
build text file
Selection/Filtering Question
Macro to fill column with SUMPRODUCT formula
build text file
Rounding Up
Need Macro to Print Current Page Only (2)
Floating Command Bar &/or Buttons
merging an excel 2007 ribbon items into exisitng classic excel too
Selecting data programmatically
row by row comparison using a "countif" and "and" condition?
Help with Code
Imbedded Picture Names
Review of Microsoft.Jet.OLEDB.4.0 Connection
Splitting up timeperiod
COPY BY MACRO DOWN TO LAST VALUE CELL IN COLUMN "A"
coding help to set a specific time frame
Check if file is excel file
Insert new Worksheet with name, and insert the sheet into itsalphabetical / numerical location
Creating new Powerpoint object and opening
VBA Type Mismatch
How to Genarate random letter
Uploading data to database
Multiple Criteria for SumIf
Workbook Unshare Error
Excel 2003 - change cells depending on answer from drop-down menu
sort an array on selected column
Inporting and Deleting Sheets
Lock Unlock cells in VBA
retain Selection
Right-click cell and open filename in explorer program
Clearing contents
odbc help!!!
Modify Function Category Names and Contents
Excel
How do I ? Macro - cont'd from 5/9 posting
what is the event for sending mail thro VSTO Excel Addin.
Excel smart tags programming with .NET - recognizing formulas?
VBA functions
Excel VBA process increases exponentially with more records toprocess
Loop Through Sheets, Copy/Paste if Match
Excel keeps running after closing on server
Clear All from last row of data down
data time frame
Find value with the help of macro.
Logical functions
Remove Duplicates in ComboBox
Loop
date finding loop.
Disable user forms being displayed in the VB editor??
Nested VLOOKUP in IF statement
Code is not detecting the date.
open .txt file
Excel form to update data from MS Access data table based on criteriain excel sheet
Change font size of header on every sheet?
Count funtion
Pivot table - Unique values
in excel 2003 what is the replacement for the old extract formul?
Excel Solver in VB
Data from Access
Updating Data
Vlookup, several tables, one sheet
printing of linked picture includes buttons not included in area
obscure array sort
Data Validation for % input in userfom
batch editing a document
Copy chart to clipboard
Determining if a cell/range is in error?
External Data refreshment
Enable Macro - default //
Date vs Date$
Finding Characters in a String
Referencing mso enumerations (e.g., msoLineSolid)
All Pivot table include different pivot field to save as individualworkbook
HELPPPPP Please - Comparing Data
Insert characters into String
Time format in userform textbox
[GetMacroRegId}
RE: Is there a way to make the text blink on and off using Excel V
Text - Blink //
textbox font style
Macros and data analysis
Form Objects in an array?
short key to invoke command button in userform
number of types
Want to learn macros in excel
formula
VBA question: How to extract cell values in different languages
Excel Services Chart Generation for SharePoint Dashboard Display
Div/0 error
Any macro programming sample for accessing database through Excel?
"Method 'Add' of object 'INodes' failed" in TreeView.
Macros: Strategies For Where They Live?
Series of custom dialog boxes
"Breaklink Problem"
SUM columns based on 2 pieces of logic
How to replace the image on the Office Button in Excel 2007?
Drag and Drop
need VBA to clear dependent data validation lists in several rows
Using a variable in a formula
Listbox
compare 2columes of name
Do not execute Double Click Event when UserForm is Showing
Macro to Insert Object with browsing ability
Change Excel query with a inputbox
VBA and Pivot Table Query for Text values
Conditional Formating
Is there a test for an empty string that returns a boolean?
Macro - How do i....?
=sum doesn't work properly
Function Call to check Workbooks.Open
Calculating Cells
Open to today's date
need help tweaking Debra Dalgleish macro
Checkboxes and Arrays
Formula for selecting highlighted cells only
currency formatting of cells with code
Record Macro Window.
worksheet menu bar
Any sample to connect a remoted database through Excel?
Getting folder size information into cell???
VBA formula too long?
Merge muliple sheets in multiple workbook below each other.
workbook / worksheet change event
Pulling data from 3000 files
My code enters break mode but there are no breakpoints
Macro to show/hide rows
Variable Input
Macro Error Help!!
Count function?
Appending Contents Of Multiple Spreadsheets Into One
What's the API call to kill the KB buffer?
TreeView's pos on UserForm changes by itself.
ListBox Displaying With Some Items Already Selected In 2007
Checking if a cell contains a string that is not case sensitive
updating pivot table data via external xls file which is replaced
Numeric data
Cell references and merged cells
Excel 2007 SP1 VBA Help
Help to speed up this macro
How do you collapse a TreeView?
WM_SETREDRAW doesn't work unless...what?
Confrimation of copy paste operation
Capture paste from Office Clipboard
Modeless Form help please
Can i link various text in a cell to a picture
Thanks to Stephen Bullen for fixing VBA's miserable UserForm.
Excel 2007 - How do I ...
UserForm ShowModal Problem
code to extract data from a website runs of XP but not Vista
Automanipulating IE drop-down list in VBA/Excel
Create a Macro with a List
I am not sure
How to execute macro based on a users computer settings
How best to break up code
VBA Additional controls
Controlling how a second excel file opens
Checkbox
Running Macros Remotely (.tcl file)
Combo Box and smart key selection
Working with Arrays
Selfcert no longer working correctly
Check access right to folder
Save Date
Userform: what happen to the sub who launched it?
Excel VBA Query Across Databases
Copy rows from multiple workbook into a different workbook (sheet)
Staff resource query
Follow Hyperlink in Cell
Comparing 2 sheets
Text Box - Initial Content
Application.Run
VB/Excel query
Compile Error in Hidden Module: Module 1
Variable length named ranges
ms excel 2007 Filesearch
Math Operation: Set Subtraction
Select Column based on Sheet Name
Help with Grabbing Cell Value from Range
Tracing where spreadsheet is opened from
Sheet Protection Question
Userform Initialize Problem !
Retrieving the values of Excel check boxes in .NET
worksheet SaveAs WK4 in background
Please help!
Setting up Sum ranges inside a macro.
Checkboxes with the same Group Name not Responding
Identify shape in cell
Iterate rows of spreadsheet(s}\Get values
Help with match function, i need to tally
ADO help: Only get first 255 characters of field...
distributing a spreadsheet with macro buttons
Easy Worksheet Function help
UDF Function to calculate mean moving range (control charts)
Trying to create Macro to delete duplicate Rows
Optimising Code
Multiple checkbox selection
Excel2000: Avoiding loop in Worksheet_Change event
Automation add-in - UDF to multi cells...
List of email addresses
Open several files and copy the contents
One Workbook to Several Workbooks
How do I exit from a macro when a condition is not met
Userform coding problem
Upgrade PivotTable drop-down selection box
Grab all filtered rows for some action
Macro defining dynamic named ranges
Drop-Down Arrow in AutoFilter
Running code.
Automatically Change Row Height Based on Cell Contents?
Adding a divider to an add-in using vba in excel 2007
Problem in excel - possible MACRO solution ?
Counting and adding values int two different columns
Adding items in one row if criteria in another column is met.
Option Button FaceID in a custom commandbar
Warning message while macro runs
Sum Column Y at first blank-bottom cell.
dual zero conditional row deletion
stuffing japanese text into a variable
Pivot table not recognizing same field values
Find & Copy Files Listed in Excel Worksheet ?
Find and Replace Question
Runs once and only once
Entering a formula
Copy past function on cell containing selective formula
closing a variable file name with macros
I need a way to pull a list based on criteria a user inputs.
Refer to Column with a variable
select a list, then sort #2
tabs by dates
Range to array excluding null values
locating excel file
If sh.Name <> Sheet1 Then
Macro to insert repeat comments
Remove On Activate Sheet Event
open Workbook path
Change Save Dir in IE (VBA)
Programmatically call a menu item from a menu from a Add-in
Analysis Toolpak Loaded or Not
Advanced Filter problems using VBA in XL2007
if then formula
Scrolling columns in lockstep
Cell should display, login name.
Conditional Drop Down List
Triple Filter? Ron de Bruin Code.
Copying Worksheet Formatting (Rows to Repeat at Top)
How to: IF FALSE in 2 Cells, Then Obtain Value From 3rd Cell?
How to call a workbook Event..
Hyperlink within formula
number seperation
With Application; Me.Top = ...
Range.Group Method - group rows, not columns
Excel CDO
Is there any way to solve this problem ?
match and offset
Minimize Ribbon
Object Required Error
Spreadsheet or Table Control for Form
passing ComboBox to subroutine
Get From Clipboard
Macro to Refresh child pivot table
Automation
List Table or Spreadsheet Object for Form
Selecting rows using defined reference as end row
Return list of file names from specific directory
Selecting cells using a defined reference
Icon Sets in Conditional Formatting
find textbox insertion point
I need help with macro
caps in cells
Importing excel data into vector graphics programs
Getting the position of an item in a pivot table
"Freezing" Conditional Formatting
Circular scripting between sheets in the same workbook
Using ranges with Visual Basic, stuck...
Month:Date:Time:Seconds
Excel 2003 stripping out line feeds
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE
Trigger CAPS LOCK ON When Wk Bk is Opened?
organising staff rosters with 3 teams
Use event to catch the running of a macro from an add-in
Pivot Table Issue...
Floating Command Button
Need Macro to print curent page only
Need a Macro to Scroll to the left
How do I set up a column to automatically number the next row
Compare 2 excel workbooks
Data Validation problem still remaining
.OnEntry Macro does not fire when pasting
Linked Workbook Files
Vlookup Question
Data Validation List Problem
Woksheet spliting
Autofilter Range
Random number generation
VBA to VBS Translation - References
lookup folmula i/e n/a
list box dialogue msgbox
Microsoft Map is no longer supported with Microsoft Office Excel
Same page setup across multiple sheets (Excel 2000)
Problem sorting file dates in an array
RE: password in a cell
Solver Macro
Bitmaps on forms
Solver Macro
Connecting to an Access database
Setting conditional colours for cells
Naming Ranges
random sampling TEXT
Set group of wksheets to top of page
Batch Processing Macro
UserForm is missing the most basic Win controls. WHAT the?
Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_
Macro Halting During Execution
Unable to assign FormulaR1C1 correctly
Auto-increment file name
extracting embedded or Ole Object data
Reference active worksheet from macro in personal.xls
"Subscript Out of Range" Error Question
Notify users by email of document update
Worksheet protection VBA
Select Range and Find Values ***Maybe Loop?***
Formula for CF
Built-in Dialog box for folders?
Auto Filter Problem
Changing the Colour of a Line with VBA?
Windows XP Office 2003 Run-time error '9'
Sum using Variable
Custom toolbar - how to save in file and show on demand?
Macro Help
Run Macro on all WS in active workbook..
hiding columns in excel based on formula result