Excel Programming [Archive] - Page 24

visible method of worksheet class failed error
SQL statement not working
How do I set up a macro to help me to do bank reconciliations?
Multiple tabs
Creating a UserForm based on Worksheet data
Testers needed for code page : create and mail PDF files in Excel 2007 with the MS PDF add-in
VBA Help
Automatically add another row when then one above contains data
Syntax problem - select many sheets at once
cannot save macro in excel
Dim active sheet
Test for missing references
Opening embedded Excel 2007 Object in a PPT presentation
Slow execution changing cell value
how do I convert number to text in excel
Microsoft Office Spreadsheet 12.0
Automation: Adding rows and pasting values
bubble Chart bubblesize problem in VBA
Font colour of specific xl treeview nodes - solved
VBA Code to Use "Name" in a cell as a reference
Radio buttons losing cell link in Excel 2003 when user has Excel 2
Set the Header Row
Macros for Merge and Centre
AppActivate syntax - help needed
Macro to increase cell range by 1
Macro that copiesother macros to a new workbook
Automation add-in avaible in VBS,Access,Word,PPT but not in Excel
Multidimensional Array
Get Data source in Chart
commandbutton doubt
A doubt on worksheet.CustomProperties...
Realtime/Streaming data from MySQL into Excel
Dynamic worksheet import to current workbook
Cell length
Edit Save ListBox Records
match nth occurence
can this be done?
Pivot Table connection String
Vlookup finance help please
Sort a Range
Excel - Match positive and negative numbers
consolidating values from single worksheets - how to ?
how to create dynamic web query through vb scrip?
cell formulas
countif with multiple conditions
Add a picture image to the end of a Word document?!!
Programically remove code from a worksheet
hide custom toolbar from Toolbar list
result from userform click...
Sort on 2 Custom Lists
if formula showing Zero
Save 1 file to different folders based on cell.value
VBA Type mismatch error
Using VBA with Access
Insert cell
Retrieve excel data from multiple workbooks in sharepoint
Text Box Question
Sheet name is not visiable.
Efficient If's loop
Copy Row to Sheet If Column Value is between time frame
Re: Selecting Columns
color coding cells by percentage 100% = green 90% yellow etc.
assign action to custom button
line-by-line formatting in a textbox
Difficulty opening Access from within Excel
Populate form checkboxes from list
Code Help
Macro code
Tab Name Reference
If and formula
PasteSpecial Error
Droping .Net component on Excel sheet
Conditional Format search and retrieve
Macro with interrupt for user input
RibbonX - XML Editor
Autofilter & copy results programmatically
Hide Columns
Autofill
Backup Copy of Source File
Unreliable Newsgroup Access
Identify which button called the userform
Manual calculation to Automatic on close - BUT without recalculati
writing a formula using VBA
Copy and paste area are not the same shape error after AutoFilter
Drive Access Error
determine activecell and move to it after running ohter sub...
ListView help
Font of message and input boxes
CDO Mail
Help required to select a cell in a filtered list
MS Query Cell Limit
Memory Increasing
Sort and Extract
Vlookup help please
send mail in excel
RibbonX – Developer Environment
transferring data
how to use text boxes as an array in an EXCEL user form
VBA Equivalent for Excel Function
Export data to Text file without leaving worksheet.
Ribbon - Hide screentip and "Press F1 for help"
Ribbonx - Hide screentip and "Press F1 for more help".
Populate a userform from a worksheet
chg by val
Finding a match- should i use a nested array, my source arrays, or
Need help getting data from large table (get pivot data?)
Selecting Columns
Selecting Columns
Copy all Rows If Column Value X within a Range
re: summing up cells up to the first unused cell encountered
Date file saved to Server
macros to query a database
?Validate Canadian Postal Code
Auto return to sheet 1
length of word
Can't concatenate text and numbers on certain worksheets.
run-time error "381" - Could not set the List Property.
Finding if data in one spreadsheet is in another
inserting pictures
convert date to different format
Macro generated data
Moving columns order
Trouble reviewing attachment in automated email
Named Ranges: Can I do This? How?
Excel 2007 in Classic View?
GetOpenFilename path vs filename
Repeat Macro
0 value in null value cell
Listbox - First item in list "default"
My small code make excel crash
Macro to Keep Only Rows with The Word Saturday
Extract Data from Word2007 Fomat Documents
Subtotal
Pop Calendar in User Form
a serialization problem
Automatically update external workbook file path in macro
Name number program
Calling sheet when usgin xlfCaller
change color of column chart
Comparing Prices in two excel sheets
Capitalisation of First Letter in Name
add-in passwords
Check if file exists on FTP server?
listing file attributes
Connect to SQL with DSN without uid and password
Connect to SQL with DSN without uid adn password
compaing data in columns
Conditions when we can set the excel code calculations to manual andwhen we should not
Changing values in a table
Excel XMLMAPS error handling?
Finding information from two rows - formula or macro?
Submitting an Internet form in IE
fyi-Brand spanking new Excel 0-day being exploited in the wild
Add exactly 1 Year in days to Textbox date
NonMS PDF creators/publishers that allow VBA scripting/naming
Run macro if
Macro to Add Weekend Dates
How to open .jpg picture using Macro
How to get worksheet_activate code to run when a workbook is opened
listbox selections
Rich text formatting gone in Excel 2007?
Use Harlan Groves Pull function with Excel 2007
Combining colums in Excel
Data Validation - Excel 2007
Updating list
Global Error Handling
chart options changed when convert 2000 to 2007
Format Number VBA
hyperlinks().address oddity
HELP: SQL in Excel VBA
VBA macro creating charts
Macro Help, Please!
How do I format a cell in feet?
Go to first available cell in A.
Year showing 1899 instead of 2009
custom toolbar buttons
Converting .txt file to rows
Using SumIF with an array
Want a macro for multiple columns on current macro for column
List referenced columns in formulas?
Determining the last row and column used on a sheet
Customizing a toolbar wit new icons
Cell Reference Problem With Cut and Paste
Help with VBA
List worksheetsheet functions
ActiveX Combo Box Focus
open an image from a userform
Problem with compability.
calculate keeps appearing while on automatic
chart labels from numeric to text
Display tab name in cell
Letter recognition in a Validated drop-down
Excel Scripting (vbscript) doesn't load Excel add-ins
place a formula in a cell with macro
VB NET and Excel
IF statement in formula
Need for speed - Beyond Excel VBA
ListBox List into Range
Unselect or deselect cells
vlookup error
conditional coloring the current cell
automate save as of excel-report to pdf-document.
Copy worksheet and rename to next month
Quotation Marks
Border around the used columns and Rows
working with Hex numbers.... A few gotchas I need help with...
Sub to download all linked files in a webpage to folder?
Warn if no text in clipboard contents
Macro Code
Hard code date in header
PROBLEM OPENING FOLDERS (AAAARRRRGGGGHHH !)
Range into Array and Array Summary into Range
Merging multiple cells into a single cell
select function arguments in runtime
Disable View Code for Sheet?
Stop file being saved
Q&A Macro
Excel - Sharing on a Network
Automate start VB in another instance of excel and continue _without_waiting for code to finish
Protect cells without protecting the entire workbook.
double a 5 by 5 cell table
Run-time error '1004', The extract range has a missing or illegal
Copy Multiple Sheets, Except Q
Importing Txt file into Excel
Clearing Comments
VBA
Spelling case of cell function determined by its first use.
Continued issues
Excel 2007 - Using a Custom Function to Set Row Color
Not enough system resources to display completely
Consolidating datasets from Excel workbook using common feild
Array variables
Macro - Setence Completion
How do I sort a table w/ merged cells
Building xl Add-ins w/ VC++6
Excel spreadsheet
textbox insertion point.
LOOKUP
Extract Name from File Path
Leaving the cursor at a known position on a worksheet
following week
week update
How do i write data from Excel to a table in Access (2007)?
VBA code to RUN Solver mutiple times (on different target cells)
Attach Files Listed in Columns with Email
creating sequential rows
Move to every record on every worksheet
VB.Net Excel 2007 Automation Performance HUGE Hit
Here's how to require user to pass a particular param type to a cellfunction (intercepting #VALUE).
Alphabatizing my worksheets
CONDITIONAL STATEMENT
CopyPasteSortCountMacro
Task Manager (shut down a task if active)
Screen alerts
ComboBox makes Excel hang
Using Sheets.Add after and want to keep a sheet as the first sheet
RE: Input Box Macro Help
How do I refer to a custom toolbar button?
Web Import
search sheet names containing phrase then copy to cell
Shared workbook errors with one user
Open latest file
Shapes and Connectors
formuls using 2003 version
Depositing ListBox Values Into Active Cell?
XL2003 Embedded Charts
File Name string formatting problem
Automatic tab naming
Disable Workbook_Activate inside another macro...
List box value problem
Increase the font size in message box.
Extract duplicates from two list to another sheet
edit directly in cell
Form Toolbox pops up?
Sorting issue
ComboBox Update Question
Random is not really random
skip to next part of program if a cell blank
Range is desselected
I want to know about - Excel Viewer
Transferring Data between sheets automatically
VLOOKUP Comma Separated Values in Excel 2007?
Excel! How can I use a variable in an autofilter in VBA?
Tab Stops
Help! Stop Users from corrupting Drop Down Box Macro
Len and InStr problem manipulating strings
Group Column A data together
SQL ODBC Connection
ActiveX Control changes font
Run-Time error '9' Subscript out of Range
indenting VBA code
Q - Open Specific Sheet
Excel Import External Data Wizard
Screen flikering (even with ScreenUpdating = False)
adding pictures to the end of a word document?!
Retrieving the characters lost
No dupes
Format Value Displayed in Msb Box
Run-Time error 1004 in Autofill method of rangle class failed
hi
Printing macro, selected rows only
Hi
Showing Tools\Macro\Security window
Loop Help
HELP to program a macro to create a hyperlink
eo
OLA
EJERCICIOOO
Problem with VBA help
macro Help
Select range through Inputbox
Set Userform As A Variable
Input Box Macro Help
For Rohit: difference between two dates ...
looup help
Re: Toggle cell value
Can I save the activeworksheet only
Copying data to another workbook
Consolidate many workbooks into one workbook
Apply Macro To Other Ranges
difference between two dates & time by excluding holidays & weeken
Rename Worksheet tab
Underline
How to close a toolbar on exit of workbook - current code not work
save as command in macro
Delete Duplicate Header Macro
Delete Date Macro
Deleting Rows Macro
Excel formula not displaying target data
Reference in VBA to "Maximum change" Value ??
ComboBox_Click event problem
Tap F9 until value is true..
Paste text according to value in corresponding cell
referencing combobox
Iterate over irregular shaped range problem
Worksheet_change event problems
Create Zip file for mailing
Copy different cells from Datawrksht to wrksht1 and wrksht2
Inserting Lines using multiple Macros
unexpected cursor behavior while attempting to control tab order intextboxes and comboboxes on a spreadsheet.
Create Word (or Excel) Reports via VBA
Excel objects changing case
Select cells in 2 sheets to print in one instance
Drop Down Boxes with Macro
I am always getting these errors and I never understand why.
Smartening up an IF formula
Handling a worksheet calculate event in XLA code
String search & extraction from txt file
Insert a fixed number of lines between a varying range of cells
how to use an array and a range
Switching Excel App from Single user to Network environment
Paste Values
a quick way to determine the first and last biz date of the month
Switch to different sheet using cell value
VBA and Text Color
copy worksheet WITH CommandButtons within Workbook
Finding the Max Date In Series
scaling a chart
Data from cells to a Form
Autofill dates when 1 is entered in a cell
comparing name
Opening and closing PDF files
Delete if Three Matches in Three Columns
VB Error in spreadsheet with no VBA code
retrieve Active cell "Name" vbscript
Find next cell that contains
Form return lookup values
Removing vertical scrollbars on listbox
Find a date in a range
Using Solver in VBA in a loop
How to set a button to filter a table using specific from and tocells data
Data Validation Drop Down Using VBA?
Macro Active Page Name
Help with multi dim arrays
Excel charts to appear once i mouse over a certain cell???
Checkboxes and Cobinations
ActiveCell.Value esc or ctl+z
Autofilter on Multiple Worksheets
Influence of IsEmpty function
Windows media player
analysis toolpak problem
Button caption won't update
Time bug, anyone know why?
Enter Data Macro
Making Sub MakeMaster work
Copy Paste Down Macro
Edit my Macro Please
populate combo box from worksheet
Save Macro
Macro
custom sort
How to change directory
Convert cells to uppercase
Insert page break based on change in Cell Color?
find last used cell (row) in a named range
AddToMru if .xls opened by button assigned to macro within it
Changing a named range within a formula
Same sub in two modules, wrong one gets called?
Process multiple rows
Access Outlook appointment info and export into an Excel spreadsheet
Sumif on a filtered column
COLLECTION question
Select new Ribbon as default
Problems of Excel 2003 macro in 64-bit XP
Alternatives to XLSTART?
VSTO unable to rename worksheet
Select used range
2003 checkboxes and sheet protection opened in 2007
Is it possible to choose the mail program/account while using send
Excel Message box, fields that are > 0
Pseudocode software
Mouse Move Event
Macro
Delete rows if column looks blank
Macro to add button w/code to new worksheet
Marco button, Copy and paste depending on criteria
Execute macro when active cell is in a defined area
Macro line too long?
How to Get Files.FullName
Templates
Treeview - Expand all parents of node
Gray out Sub Totals not being used
Insert cells based on duplicate entries
Open and Close Workbooks
Copy data from multiple excel files
Code to change column widths?
Counting Invalid entries
Send Attachment (previous one got away)
Send Attachment
Simply show UserForm
Automation Ole Excel conditional formatting with PowerBuilder 9
Creating Pivot Tables
Excel 2007 macro: Dialogbox for saving a file as type Microsoft Ex
formula bar caption
Help to write the macros given a set of data
Paragrph in Email Body
Send email according to ListBox items
Creating product key
Declaration of array
Select Whole List or Items in List Box
Is it possible to print a named range of data excel
transfer data to as/400
Er...tell me again why I can't pass ParamArray to a Function?
file save as dialog with new filename
Find Empty Cell
Loop thru excel columns
How ignore ribbon code when in Excel 2003
Code Help
Can not save excel files through stored procedure on Server 2008
getElementsByTagname
Hide Excel Window
Create list of macros
getting new row from a field
Detect connection to a drive
Macro to convert date to text
Re: Export each column in a different txt file
Re: combining rows in an excel file
Re: Best Practice - Transfer Data
Re: marco to delete empty columns
Re: publishing excel on web
Position to UserForm TextBox from OK_Click MsgBox
Re: Wierdness on Excel Object Browser
Export each column in a different txt file
Best Practice - Transfer Data
publishing excel on web
C# Excel Interop and Decimal Places
Wierdness on Excel Object Browser
combining rows in an excel file
marco to delete empty columns
How to build macro to do calculations by grouping column A by name
RE: Can Worksheet_Change call itself?
Deleting blank rows which contain blank drop-down list boxes
VBE Toolbar Control
Can Worksheet_Change call itself?
clear formula that does not return a value automatically?
RE: Can Worksheet_Change call itself?
Auto increment & print three copies
Increment Cell Value on Worksheet Change
Quarter vs Month
Cannot find "1-1" or "1-1M
Print Message
ISERROR for Multiple Workbooks
Two List Boxes Item
Conditional Formatting Adding Wrong Formula
List Box Last Item
Incorrect UDF call
Check Boxes
Check Boxes
For next conditional
Copy Data to Cells, but Stop at Next Non-Empty Cell
For next question
code help
Data sort issue
Calculate Textbox value based on another textbox value
Form Lookup & Update Records
macro to refresh from Access and then
Distribute ocx with Excel Addin
Working with multiple columns
Should I use INDEX?
analyzing data with VBA
Events won't trigger if locked for edit and if opened from IE
Dynamic chart title
OLAP
VBA Auto-Completing Lines
Selecting more than 1 named range
Drive, folder and File controls
Merging duplicates in a sheet
"advanced statistics" in Excel/VBA
Help plz
make code less lines
Print a list of defined names and what it refers to
FORMULA FOR CELSIUS TO FAHRENHEIT
Re : Excel Control-"C" to Copy an ActiveCell
Import Data from an Access DB with VBA
Save to all computers on network from Excel 2007
How do you specify the Help file to be used
Combining Single Dimension to Multi Dimension Array
Current Age by years and months
Round subtotals to two decimal places
Rounding Subtotals to 2 places
ecm2001 v5.3 winols shoemaster wilcom bentley amiable xshowsoft086054218130525
Set cnn = New ADODB.Connection
Automated Hyperlinking
macor to split cells
macro error "no object"
Macro for Tab Key
AutoFit Macro to Reduce row height?
Export contents of multi-column listbox
2003: Having trouble with conditional formatting with custom user function (Repost)
Adding Formatting to Code
Help with additional formatting
Correlation Matrix using VBA
VBA programming
Match value from column A to column A on 2nd sheet and then copy R
Line-by-line formatting in Excel 2007 Textbox
Users are adding rows to worksheets
Modifying Chart Slide Show in a Userform, attachments
Modifying Chart Slide Show in a Userform
Application coded in excel 2000 when used in excel 2003 excel doesnot perform well and takes double the time to give the output
Userforms and public variables
Can't read border values in VBS
Programmatically removing code from ThisWorkbook XL2007
Newbie code not working
ActiveX Control Combo Box
error 2042 with vlookup
Help creating temporary worksheets
Formula returns #value! if value is not found
How to get worksheet change code to work on protected worksheet?
Chart disappearing in Excel 07 but not in 03
Named Range?
Activating a renamed workbook
Object oriented programming in vba
Array: Show only min values > greater than "0"
Excel Merge
WorkBook_Open Event Order
Automatically update external workbook file path in macro
VLOOKUP - Tricky problem, help please!
Join 2 Conditions Q
htm to xls
Copy a Value Q
how to use combo box controls to control columns selection?
Saves as button
Excel versions
Insert formulas on data entry trigger
Message Box to Appear if Cell Values In Range Differ
VBA adding time in milliseconds
How to change the row number in macro code?
How to code macro for worksheet?
vlookup function
Vlookup on a formula field?
Installing a Vista Office 2007 developed XLA to XP office 2003 machine
Is Application.Caller valid in Functions but not Subs?
sequential numbering
Macro Questions
Merging cells in a table
count lines of text in a cell
UDF for Two Matches and Sumproduct Results
Convert values to time: Error Trapping
How do you specify the Help File to be used
percent of row in subtotal range
Conditional formats for date Serial Numbers
true autnumbering
run app on database "refresh"
Removing part of a cell
Run all macros in module with one command
SaveAs to existing file
UDF returns different result in worksheet to that in VBA
Combine macros mismatch
Assigning control tip text
How do I write a help file for a custom function?
Range.Find examples
variable nam in VB
Finding the first visible worksheet
Setting print area
Application.FileSearch Error
Userform Positioning
Add/imply fields when importing range into ACCESS
test
Adding i new item to current data validation list
find files from a dropdown list
Looping through worksheets with name change
test
XBRL Tool
Formula building code : what's wrong with this little sub?
Security/Protection
accessing pivot talbes using dom
Incrementing complex data
Macro, how to set a cell value to zero
copy formula across while skipping columns
copy across formula while skipping columns
copy across formula while skipping columns
Variable Step rates in loops
Can text in check box created with form control be word wrapped?
Attaching more than one file to an email with VBA
Get data from Access tbl using Vlookup formula
Sending mail from Outlook as plain text with VBA
Macro question
Macro question
Macro code question
Paste VBA formula into cell
Paste VBA formula in cell
copy cell formula and adjust column spacing
Macro Creates Mult Sheets Based on Summary
A Macro for Multiple Sheets that Reference one Summary Page
Path and File
Refresh from Access not working
Macro to Refresh from Access
Autofill to the last empty cell in a range
Close macro file
Accept username & password once; Use for multiple ODBC logins
Combination help:
define Range in vba using contents of a cell that is named
Help with adding array item to multicolumn listbox
COPY PASTE with FILTER copies anti-filtered results as hidden rows
Macro is not able to identify the value.
Saving a workbook
Help using dll with excel 2007 and vista 64
Copy formula with column spacing
Set the values of set of ranges to zero then restore previous valu
test
Workgroup Macro? Auto-Update?
userform crashes some computers; not mine
Populating a Date-formatted Cell with ActiveX Calendar Control
Selecting multiple sheets
Close Form
Deleting Duplicates Macro
_MailEnvelope still won't work...
Find last row of data and paste
Move selected range to left
test
Excel not closing if I start Thread
Mulitple Filter Selection
User prompt for CSV format
code to loop thro values and save on each
User Defined Range
Can not view VB program
Should this code work in Excel 2007 as it does in 2003?
Desktop Folder To Workbook
print zoom
Select Sheets to Print
Input ID & password once for multiple ODBC logins
application running in excel 2003 gives missing reference in excel2000
Activating a renamed workbook
Selecting data from multiple worksheets
Progress
Progress
Progress
How do I convert xla add-in to xlam.
Convert xla add-in to xlam.
Activating a renamed workbook
Activate a renamed workbook
Auto expand of list/XML table 2003 vs 2007
The " character
Save As PDF in excel 2007
Copying a conditional formating rows with text and values
the " character
the " character
The " Character
Need help with a summing routine
Naming a Range for use in a Non-Formula
Re: Scroll Bar in Text Box will not work
Pasting to Powerpoint
Variant Trees/Lisp Like Lists in a single cell.
date issue
information from Col A:A
steps of Setup and Deployment for C# Excel 2007 project in Visualstudio 2008
return data to access
Accept & Use ODBC Login
Autofill down Vlookup formula between sum?
Save Copy As Problem
beforeclose cancel not working
Macro for Drill Down and Hyperlink Automation
Macro for Drill Down and Hyperlink Automation
Macro for Drill Down and Hyperlink Automation
Macro for Drill Down and Hyperlink Automation
Macro for Drill Down and Hyperlink Automation
Macro for Drill Down and Hyperlink Automation
Macro for Drill Down Hyperlink Automation ?
Ribbon question
Combine Text Files into One Worksheet
Combine Text Files into One Worksheet
Combine Multiple Text Files into One Worksheet
One final task...changing font color
Confusion Using Named Ranges
Combine Data
Combine and Compare Data
This is just a test, please ignore
TEST
test
Programming for Listboxes in Forms
SumProduct by specific weeks of the month or year
SumProduct by specific weeks of the month or year
Macro to insert formula iin column
Formatting cell
Formatting cell
Formatting cells
dynamic pivottable source - limit sheet options
AppActivate syntax and question
Accept & Use ODBC Login
dynamic pivottable source - limit sheet options
dynamic pivottable source - limit sheet options
dynamic pivottable source - limit sheets
search and sum
Sum of different accounts
search and sum
Access RibbonUI object from Application?
If Then
Dynamic PivotTable source - limit sources
Using Option Buttons as An AutoFilter
Run-time error '13': Type mismatch
Returning vars to calling sub
Get Outlook Folders into control on Userform
Returning values to calling sub
macro error
Passing variables in macros
Easy count of custom menuitems that perform an action (macro)
HTML Object Library
Delete Empty Rows Macro
Runtime error 1004 - cannot open the file
Export only Modified Records
Runtime error 1004 - cannot open the file
Conditional formatting using VB and range
Conditional formatting using VB and range
Printing Duplex
Excel chart to powerpoint chart
Excel chart to powerpoint chart
Excel chart to Powerpoint chart
vlookup with 2 different workbooks in macro
Need to get cell references from a formula
Change label name with loop
Macro question
macro question
Macro question
THIS HAS BEEN HAPPENING FOR DAYS WHEN I ATTEMPT TO POST A QUESTION
How to extend Excel with custom data provider?
copy matrix to worksheet
copy matrix data to worksheet cells
test
For net borders
Copying Pivot Table
Two functions of the same name in seperate xla's
ODBC PivotTable Error
ODBC Driver Error in PivotTable
ODBC PivotTable Error
Copy down 1 column to the left
Calculating Time
Control of Access Accounts Dimensions via VBA
Early bind to Late bind
Early bound to Late bound
How excel determine how many rows fit in to every page?
From Early bnind to Late bind
From Early to Late bind
From Early to Late bind
From Early to Late bind
From Early to Late bind
Variable Image in Header
From Early to Late bind
From Early binding to Late binding
Insert line in a text file between 3rd and 4th lines
Macro don’t work
I need some help with Arrays
I need some help with Arrays
How Excel determine row height?
How Excel determine row height?
RE: Excel 2007 Object Model thread safety
Request using XML HTTP object throws "Access is Denied" error
How to code macro for worksheet?
How to code macro for worksheet?
odd issue with a loop
odd issue with a loop
UDF; Two Matches, then Sumproduct of Values
Pick Ref# randomly on an average
delete macro button once file is saved
Deleting a macro button in an output file
msgbox on each value..
Return the values in another sheet
test
Test
Export chart from Excel to PowerPoint
Export chart from Excel to PowerPoint
Export chart to PowerPoint
Cells wont calculate in French version
Don I need help one more time
Inserting a new table row without copying formats
Formula
Third button size for controls?
PIVOT - Reference a cell outside the table for report filtering
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet
vlookup in different workbooks
hide excel sheets
cAN NOT VIEW VB program
Macros and Password Protection
combine chart types using VBA
create pivot table from external csv file
VB program
VB program runs but does not show.
Macro to insert formulas on last row of different worksheets
Find first Empty Cell in a row
Macro to insert formulas in the last row of different worksheets
Macro that will insert formulas in the last row of different works
Macro that will Insert Formulas in last row of different worksheet
Re: HELP PLEASE..Macro for rows
In cell drop list question
Changing tabbing order in Userforms
Raising Events
Determine Excel cell location
Security Alert Macros have been disabled - Excel 2007
Security Alert Macros have been disabled - Excel 2007
Formatting Decimal Places
Another Delete question
Is this possible?
Is this possible
Is this possible?
Append key fields to range for ACCESS import
Append key fields to range for ACCESS import
test
test
Day only
Day of date
test
Is this macro possible?
Help with macro
Simple macro to insert user selected picture into Excel 2003
Speeding up Hide rows code
How to create a simple insert pic macro in Excel 2003
Issue with Multiple sort fields in pivot table
Extract text strings from xls cells containing outlook items
Format
Re: CSV dump
Re: Two marcos, same shortcut
test
Append key fields to range for ACCESS import
Re: Disable Commands using VBA Script in Excell 2007
UIRibbon- XML part
cell links to other sheets
Cannot post
Append key fields to range for ACCESS import.
Append key fields to range for ACCESS import.
Paste or PasteSpecial without CF
Re: Modules not being deleted
Copy worksheets to a different workbook
Array UDF Recalculation
RE: Web query
RE: Web query
if blank go to next
Append key fields to range for Acess import
Append key fields to range for ACCESS import.
Column range to search from a source workbook and then copy/paste
filter/find/highlight/copy/extract a range of data
Sheet change event not triggering macro
Clear Function
Stop the clock
ehandler
Format columns & cells in a protected sheet - VBA code
Storing date and time
clearing a combobox
Dynamic Print Area
Dynamic Print Area
Dynamic Print Area
Dynamic Print Area
Ehandler
Defining a length
Sum Bold and Visible
Word Document that feeds a spreadsheet
convert Week 1 to a date range
Concatenate cells
Add Button to End of Menu Bar
Multiple cells for changing my spreadsheet?
Pivot Table versus Combo Box
Append key fields to range for ACCESS import.
Find not finding programatically
Application.InputBox (Range)
User Form deletes previous entry
User Form's
USERFORM's
VBA Password box appearing at close
Format columns and cells in a protected sheet
XL window locks when working in VBE
Excel 2003 to 2007 issues - Drawing object groups
Append key fields to range for ACCESS import
Append key fields for import to ACCESS
One-cell range as key field to ACCESS import
Name a range using cell contents
RAND() Won't Trigger Worksheet_Change
personal.xlsm issues in excel 2k7
Copy Info from 1 sheet to another
Excel Change Text to Date
access to a server via a macro
find function Help
Help with Find Function
Help with Find Function
Conditional copy
disallow edit in a cell with data
MergedCells_Value
Pause recorded macro for user selection of menu option
Welcome screen...
Find function for a Range failing in excel 2003 and giving subscriptout of range error 9 problem but works fine in excel 2000
Adding Two Columns
vb password forgoten
Keeping track of a business
Copy and Paste Graphs?
message box keeps popping
Programmitically place Total Row of table?
Autofilter / Sort in VBA doesn't work
Advanced data filtering on different sheet
Column A of current row - "Home"
Link Cells & Paste Special Macro
Help with formula
Copying cells from one workbook to another with many sheets
Copying cells from on row in one wkbk to scattered cells in anthr
Form.Close
Can't create an Object (Some sort of ActiveX thing?)
Hyperlink between sheets in same workbook
Value of Merged Cells
List Subfolders Horizontally, seperated by comma, instead ofvertically
Code for copying various cells.
Persisting Treeview in VBA
Share a document
Sharing a document
Sharing a document
Help, probably easy
Multiple cells hiding rows, changing print area
VBA code to Fill Down in a filtered list only to visible cells.
Short cut keys in Excel
VBA code to Fill Down in a filtered list only to visible cells.
VBA code to Fill Down in a filtered list only to visible cells.
VBA code to Fill Down in a filtered list only to visible cells.
Spreadsheet Corruption?
Is this possible with a Macro
Another E-mail problem
Autofilter / Sort MACRO doesn't work correctly
You receive a "Too many different cell formats" error message in E
Help with VBA
copy a macro button image from a friend
Bigger Problem
Digital Certificate Error
DIgital Certificate not working
Autofilter / sort doesn't work in MACRO
Help with this formula please.
Can I get help with this formula please.
Autofilter in MACRO doesn't work
I need help with a formula please.
I need help with a formula please.
Filter in MACRO doesn't work
Filter (number) / sort (date) doesn't work in MACRO
Autofilter 0,00 doesn't work in MACRO
Sum a collection
Run Time Error 91
Printing 2 ranges on one page
Excel VBA Training Class
Is it possible to disable a hyperlink........
E-mail addresses
Cell to Row
Table properties/Table total Row problem
Adding numbers in a range
Automatically adding row when data is entered
Print Command - Array of Worksheets
Application.InputBox error trapping
VBA userform property
DIR not working after first workbook opened.
Excel Forms Properties
How do I format a cell based on the contents of a different cell?
Date Log
Copy Two Columns of Flat File to Final Excel File
Copy Two Columns of Flat File to Final Excel File
Copy Two Columns of Flat File to Final Excel File
Prompt for Start Row
Prompt for start row
Prompt for start row
Dynamic Range Selection
Format data to a different look
Converting data format within a cell
Sort or Filter to discard unnecessary data
changing the color of a cell acording to its value
Chaging the color of a cell acording to its value
Method _MailEnvelope failed
Convert macro code to an addin
ActiveSheet.Name
Dynamic Range Selection
Dynamic Range Selection