Excel Programming [Archive] - Page 60

Formatting a TextBox on a UserForm
SQL Syntax Error
Displaying part of a worksheet in another worksheet
Loop & Accumilate e-mail addresses to send to
Attach Macro to single worksheet
code cleaner
ChangeLink with Worksheet Named Ranges as Arguments
Sort Macro
Column Autofit
How do i set the value "TRUE" as "YES" in excel
Dumb as a rock concerning VBA/Macros
Primary Programming Language for Excel 2007
Data Connection
macro to copy and paste
how to remove linebreaks in cells with VBA
find replace within sheet or workbook
Simple addition problem
Borders
Sending task to Outlook from Excel
create chart in worksheet but hide the data from user
How do i create a list of files per directory?
Excel
Excel crashes when I try to save workbook
Help with code (delete range)
new worksheet with 4 columns only
Using Solver with Excel 2007 VBA
Find 1st empty cell within each row
Returning a value forom a Module to a Userform
AutoFill Row Numbers & Print Area
Required Fields for many Text boxes on a userform
REPEAT NTH ROWS
Getting data for pivot table from another spreadsheet
parsing a string
Re: Changing cell text color based on cell number
Re: Changing cell text color based on cell number
Numeric or null value
Excel formula not displaying a number
Obtain Cell Formatting in Cell Referencing?
Cut time from string ?
Connection from Excel to SQL
stop application {on keys}
for Tom Ogilvy Please
Excel solver newbie question
Dynamic Userform Controls not Displaying
Passing table to web service
No Dir in Spreadsheet Referencing of Cells
Updating original data from vlookup screen (macro?)
Removing selection and maintaining formatting
Error 91: Object Variable Not Set
error 91: Object Variable not set
text trigger
faster way to save/restore a worksheet in MS Access
Remove validation
Calculating Commissions
Copy Merged Cells to Single Cells ??
Code for Select a file and save it in a different location
Worksheet events
Date format in an XML export
CAN I ADD CONTROLX BUTTON TO CUSTOMISED TOOLBARS
OK I admit that I can not make a Command Button work
How do i hide the main title bar in excel 2007
NOVICE with text and list box queries
I am so close....if null add new problem
Finding a Minimum Number other than Zero within a Range
Offset from end of a selection
Excel cursor
Check available pagesize
please help!
column copy
Selecting last pasted object
Column lookups of specified numbers
problem with code
Userform Position exactly adjacent to Cell A 46
Create a copy - Worksheet
Parsing Data String from text file line
Find and Replace Row
automatically deleting a worksheet (without warning prompt)
removing links between workbooks
View panel
how can add a wordin the same sheet
ActiveCell
Close workbook without alerts
HELP
Capture cell address in UDF
Check if a workbook has an "open password"
IfError Help
Bitwise comparison question
Macro's
Active Cell Filling
Exporting code modules
Group a range - closing the group does not hide the controls....
macro v active x control
Dynamic chart
UserInterfaceOnly question.
confine text to cell
Resizing Userform
Looping through a specific column
Multiselect on Listbox and Click Event
Turn off highlight on Listbox after click_event
Remove Trailing Comma
top values within subtotals
Insert page break & merge text in 2 rows
Pop-up calendar with protected sheet
Using Cell Data in Multiple Places
Control Hierarchies in Userforms
Exporting XML data (encoding question)
Selecting an entire column
Advanced Filtering on an inactive sheet
FormulaR1C1 problem
Having problems w/ Solver code
Loan calculator- Payment
.Find and With stmts
Activate previous Workbook
Adding text to Formula result in VBA?
How to calculate Number of rows in Excel ?
Getting reference to an OLEObject from another cell?
Validation Drop Downs within a List
Validation based on digits in the middle of a string
range.offset(0,1) is OK but range.offset(0,2) not
addnew
Listing
Needing Help
Tooltip for Shape/Picture?
Predictions with Excell
Copy chart to clipboard - VBA
1 Dynamic Userform vs Multiple Userforms
Help with a "delete rows" Macro
Vlookup "contains"
Protecting VB Code
A Sheet by any other name.....
Excel Stored Dates
Spinner and Date What the heck is happening?
delete macro from vbs
webquery URL with brackets
How do I find cells with invalid data and true conditional formatt
Projects accumulate in Project Explorer
Adding two characters in front plus three in back
Is there a way to do this?
Sending information from a cell in excel to a task in outlook
application run - macros within macros
Calling sub from CommandButton knowing which sheet is active
Command Button Tooltips
Biggie for me
Excel macro that deletes all rows which doesn't contain the character "|"
Yet Another Macro Question
determine if Pivot Table field item is hidden
Copy values (loop) from TXT file to excel
Running code from form button
addnew
Strange Formular for OLE
Excel Macro, slow performance on terminal server...
Excel 2007 Ribbon Check custom buttons
Check Box Control
Propogate information based on cell contents
Problem with Vlookup
Command button
Search Folder for Files
starting Solver with VBA
script to send data from worksheet to multiple workbooks
Random Numbers
Need help with checkbox to select recipients of an E Maiil via Lotus Notes
How unprotech .XLS if we dont't have password?
Selecting the one with the bigest amount
PivotTable CommandTimeout
Unload a Userform created in VB6
open all workbooks in a folder
Another Stock Macro Question
BRAND NEW USER -: PROBLEMS WITH LIST AND TEXT BOX INPUT
Publish as Web Page with Password
Adapt sheet Protection
calification analisys
If cell is changed clear all cells to the right in that row
ComboBox1 is DELETED(!?) when Me.Pictures(1).Delete runs in my macro
MailEnvelope
Trigger Email with Excel File Closed
toggle button in excel
How to locate Cell in which control resides
Create characters
Windows.RangeFromPoint method is not working properly
Pivot table showing #Num! error - SSAS2005 SP2
Shift + F2 problem
detect shape overlap?
automatic sorting selected data into acsending order
Re: can someone help me with these 8 lines of code
Excel training from Rockhurst University Continuing Ed. for free
updating Excel.FormatCondition
can someone help me with these 8 lines of code
Double clicking a Cell Programatically
Time
Help Please !!!
For-Each loop, I think.
Currency List Dropdown for Worksheet
Referencing Cells in another worksheet in same workbook
Macro not working in personal.xls
Error 1004
Transfering records based on a condition
Sum based on variable text
How do I keep color and font btwn tabs in Excel 2003?
have to open csv files with possibly more than 65000 rows of data in them,
How to select cells with checkboxes?
Combo box with Data Validation feature
Error with Using Macro for XYScatter plots
Password Protection
External Data-Changing Numeric Formatting
Remove Cell Contents Macro
Opening a 2nd workbook to get data from, need an easier way
Show A userform on selection range
Copying Range gives object defined run wrror
VB Code to return to top of page
Autosort on an Array
Inserting VLookup using VBA - Problems concatinating contents of cell & variable
Copy Macro and Forms/code
Selecting Items from drop down list
Null exist in Excel
load a PDF file with VBA
Error'9': Can I create a msgbox for the user?
How to speed up response to scaling axes with code?
Using macros in an external worksheet
How to use CompareSideBySide method?
Copy and Split Macro
Macro to compare then copy if string found
Mod function
Calculate marketing mix
copy tabs into new workbook, save, and close.
Unlocking specific worksheets
Real-time character counter
Apply custom chart type - VBA
Challenge of the day part 2
Pivot Table
Reports in Excel?
Creating Multiple Charts from Same Pivot Table using macro
Error on loading userform
Excel vba chart build problem.
Always keep first part of text in a cell
Challenge for the day.
lookup and copy certain value in a loop
Run Time Error on activate coding
Set A1 on Top left Corner Q
List worksheet names
Looping and copying from a list
ascii to character
To thank or not to thank
Quick watch...
Cutting/pasting from Excel.Application object - missing the obvious?
Excel - Stock Macro Help
Macro Help
Special Http Response feature?
Should be simple: Lookup a picture from a folder based on a cell value changing
Search for name of a file in a directory (http path)
Can Turn Off Internal "Undo" Stack in VBA?
Running DDE functions within VBA subroutine - Any assistance appreciated
Add loop to Vlookup
Compile error when using Res=Inputbox
Text Files
Kill Function
Strange Excel Bug?
Limiting a worksheet's selection range.
messagebox help
summing cells on a different sheet
Macro Optimization - 25,000+ Rows
Rather tired and need solution please 4 Vllookup :-D
Create a reference to a workbook which is already open
Worksheet functions in VBA
Userform and Checkbox - will this work?
Pivot Criteria Capture
BRAND NEW USER -: PROBLEMS WITH LIST AND TEXT BOX INPUT
Hiding Code in Workbook
MessageBox Assistant
execute macro from command line
Extremely long SQL Array
How to Summarize between step?
Time Sheet End of Month
Sending e-mail from Excel
XL4 error executing Page.Setup function
Shape selection
New User......Please Help
Problem opening file from a server
Check Box Status
Saving files one level up
ADO Recordset include Field names
Populate one combo box based on the selection of another combo box
write a program in xl
Finding a date in between a range of dates.
Macro to locate today's date from a list of dates
Skip Read-only message
Cell passwords
Launching Macro when Cell Changes
Returning the number of comments in a workbook
Combobox Code, Wont Copy and paste?
Entering Data into Column C based on word from Column A
I can't find the YIELD method
Updating a Piviot tabel when Excel data updates
User Defined Function giving #NAME? error
RE Define Named Range.
Required Fields in Excel Application?
Delete row if 3 columns have empty cells in a row
Reading Text file into an array
Averaging not Summing
Open Word from Excel
Combobox Hiding Text behind
Checking for a duplicate value
Runtime error 1004
Excel 2007 Macro security problem.
Question about the TextBox control
ActiveWorkbook.ChangeLink
Excel to Powerpoint pastespecial date problem
Sheet protection
Excel to Powerpoint pastespecial date problem
convert object name from string to object
Macro. XML -> Excel
Font color setting problem
Problem with Splash Screen user form with updating status
Excel Find and Replace Problem with Array
Using Dynamic Ranges in Get Data command
Password Protecting a command button
Password Protecting a command button.
File save macro error
Quotation marks within a formula
How do you create a macro to auto number in excel 2003
help hiding excel application
How to
dynamic formula? not sure if it's even possible to do this with Excel ...
Office HTML: Excel headers and footers metadata erroneously transl
ranges
Delete Row
save on condition
Error handling and escape key
Message Box Q
How to move to column B1 from column Z1
referencing inputbox input to worksheet
all the check boxes should be checked if i check a particular checkbox in that row
Macro Loop to Count Copy
Macro runs OK for me, but not for the other users
Trying to create a macro to auto number blank (excel 2003)
Help on solving the linear programming model using solver
command button function
How keep user form constant
lisbox reference and calculation
Copy Excel Files to new directory
Value Change Range of Sum in Another Cell
Which Excel Version Best for Creating New Applications or Add-ins?
How would you design this application???????
Resizing and Printing a UserForm
Sum , multiply betwenn 2 comboboxes
Automatically updating external data sources
MSXML2.XMLHTTP: "Access is Denied" - works on IE 6 SP1 but not SP2
Help with creating a custom function
User Form Question
ADO data access to excel
To thank or not to thank
ASCII CODE of a character...
How to fix .sort in Excel 2007
Here is a challange for someone... Needing to "step through" and combine data fields
Create appointment
Tab Indexing Behavior on a Mac
Macro to save file in changing directories?
Calendar Control missing
Change dates from dd/mm/yy to 6 digits being ddmmyy
Drop Down lists
Displaying data on Excel Statusbar?
Split Cells
Protected project
convert .csv to .xls for very large file
How to use INDIRECT
Conditional Formatting, copy for rows
error handling message help
MSXML2.XMLHTTP Works with IE6, IE6 SP 1 but not with IE6 SP 2 - wh
Opening an ACCESS db from the VBE in EXCEL
if AddIn_1 isRunning vbcr application.enableEvents=False vbcr end if: how to do this??
Date Issue
Putting woirksheet name into a variable
another macro is running ... how to recognise that process in code???
Selecting the first blank cell in a column
Automaton error/Unspecified error
xlSortTextAsNumbers inconsistent? Excel 2003
Problem with Spaces While Editing in VBA
Open File - Need an warning to appear if file cannnot be found
ScreenUpdating is always true when stepping through code ! ....
Need Help with VB6 and Excel
conditional formulas in Excel
conditional formulas in Excel
Why oh why!!!
excel formula and vba
Hide Cell contents
Converting Excel Calculations to C# (or VB.NET) code and assemblie
Reading command line parameters in a VBA program
Matching lists
Editing existing data
Excel 2007 encryption
FTP a file to UNIX server using Excel Macro
Access embedded forms controls from VS2005
Call sub with array
New and exciting things
Simpler Macro
Drop down menus
finding the last row for a macro
copy specific rows to a new sheet
Pivot Table Calculated Field / Item
second biggest in array
Copy destination
Protect Worksheet / Workbook in BeforeSave Event
Sub to strip away "Sheet" prefix from names
Problem with rank function based on a non-worksheet array
Blinking text
Need Help am Brain Dead today.
read and check cells in loop
len limit of 255 of function. any workaround?
Post to a Sheet Depending on a Value within a Cell Q
sort numeric array
check if valid and size array
Searching for multiple words in a cell
Using an excel addin to call macros in current sheet.
pivot table restore
if with or
Identifying the user that has a workbook open?
msQuery: is JOIN command possible in Excel?
shorten connection time <<Macro Tweak needed>>
Last Modified Date & Time
Calling DLL functions in Excel VBA
need advise on mycode
summarising information in a workbook on a new worksheet
Command button calculation from Userform and Cell reference
Clearing a Sheet
how do I get excel to round to specific numbers?
NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS
DP use when sheet protected
function tweak?
RE: if condition is met, shade cell [WORKS] but if value changes:
COM Addin Security
Selecting data to copy and paste
Textbox and Bullets
Scheduling by workdays only spreadsheet problem
Coding a filename into a macro
Recording a range of changed cells.
Create Harvey Balls in Excel?
Print Preview + Coordinate Problem
Looping through a spreadsheet
deleting rows with VB
Lock cell and reprotect sheet after save
activating a workbook
Change ws designator
Charts Sheets to Powerpoint
tabbing in code
Function for RowHt. How to create
Opening text files
Can I Atomatically Split Cell Contents
Hide / Unhide Workshets on Print and Open
setting the range of cells to be used for customtype errorbars
Repost of Question on Preventing 2 cells from having the same valu
Creating a macro to swap cells but retain formatting
Listbox Help
Correct syntax for hiding a chart sheet
Search for Quote
Protect sheets when activated from ShowSheetsList application
Adding Date to another Cell
Conditional CCP entire row
Format from Row Source
Embarassingly simple question regarding VB Editor
Parsing into different sheets
Footer Color
sql RETRIEVING DATA FROM TWO TABLES
Excel date input inconsistancy
Rename Multiple work sheet
SAP interfaces
Digitaly sign my Macro code
web service as external data source?
Form Updating
topmost modal form
Function select second lowest
Putting comboboxes in an MSFlexGrid
Referring to sheets wiht variable names
move to the cell on the right, my code not working pls help
want to advanced to cell on the right but my code won't work
want to advanced to cell on the right but my code won't work
Close specific workbk
Unprotect VBA-Code using VBA-Code?
singel cell reference
Setting the CodeName of a new worksheet in the VBE Editor
Array Argument Parenthesis
Chart font
remove msg box prompt
TextBox.Visible = True ... not working
Help with Search Range in Function
IM A NEW USER HAVING TROUBLE WITH CODE
custom toolbars to exclusive files.
Circular Express when $ added
How to get mutally exlusive cells on mouse click
Change Event programming
Sub to transform table into cols
NORMAN JONES - WHEREFORE ART THEY ARE YOU
Updating references in copied excel work sheet
Combo Box Form Control
excel b74=b74+1 when b4-b54 ="Y"
Mouse over pop up
Change current directory to the directory that the workbook loads from!
Help - How to check if value exists in closed workbook?
Rename multiple controls.
Automating the copying of a line
Rename multiple controls.
Is there a workaround with #REF error message?
How to count dates in a column between 2 dates
Can I link multiple Listboxes to one Scrollbar
Wath means
Combination question
Trouble formatting a date variable to contain a time value
Stop error message
Array function with more than 29 arguments
Help with Case Please
Need Help Pls - What's wrong with this?
Array function with more than 29 arguments
Finding and transfering data
Need help with Array
VBA to SQL DB with user input and results to worksheet
Watermark image
My Macro does NOT Delete ROWS??
I need help with cell returning number as credit or debit
Result code for SaveAs
turn off recalc in PivotTables?
Naming files
Coping data from excel to word
Tax Table Formula in Single Cell
Disabling Button Commands in 2007
Create pivot table
Accessing VBProject causes the program to crash
"Form" to add data with?
Can i sell my vb program
ENTER instead of TAB
Showing userform
Date check for expiration
Excel VBA resize picture in powerpoint
Extract 5 digit number from string
Change image for Ribbon items
Need simple 'Paste' macro code
filling a combo box with two Columns
Advice on optimizing spreadsheet
HELP WITH A COUPLE OF SIMPLE FORMULAS FOR A NEW USER
Return sheet name from an address range
User selection of folder and open all .xls files within folder
Return cursor to previous cell
"Excel has encountered a problem..." error
WHO CAN EXPLAIN THAT "macro problem"?
how do I tell a macro to move to the bottom of a collumn plus one
Dynamic Data Range from External Text File, Filter
VB Code Highlight Rows Based on Color Index
Adding scroll bars
delink all charts in worksheet
problem in watching the comments tags when making protection to sheet
array question
Re: Saving workbook causes new sheet and lockup
MS Query Not Returning Data to Excel
DLL Vs. EXE?
Prompt user for input
Run Time Error 1004: Application-Defined or Object-Defined Error
Appending data and dates to a merged cell
Recursive Classes - Design Pattern needed
How do I modify Cell Comments from VBA?
Form help
How to Insert Rows but not Ripple up others
Saving workbook causes new sheet and lockup
Export Specific Sheet in Listbox to New Workbook
Counting Specific Number of Days across Multiple Months
Recording macros/Compatibility Mode Office 03/07
XL2002: Button Labels & Sheets...
Using a macro to create a report on another worksheet
Test if there is data in a cell or not?
Copy from clipboard in excel/vba: size limit ?
how do i make a visual basic function calculate every cycle?
Using CASE Statement to Derive Months from Numeric Dates
NETWORKDAYS thru 2020
Question: Can't pass an Array to a class
Macro to Outline based on Indent Level
Excel: Self-updating cell
EnableEvents
Get address of found range to use in a formula
Updating Links Error on Buttons that call up Macros
Placeholder in find code
Making the macro's execution faster
Check a value in a range
Protect Excel VBA Project from another Excel Macro
VBA code crashes Excel 97 - Help please!
Cumulative totals
Mailenvelope Gives Error to Only One User
Clear Contents at 5PM daily
Time arithmetic
Automatic adjustment of Cell height?
Changing the font size in the charts
Re: Help with combo/Listbox
How to use RTD + Bloomberg/Reuters
Help with combo/Listbox
MACRO to Copy incl. hyperlinks
Returning a zero value in an average total
Find value and replace cell below
Disable Move, but not Copy
RE: Terminating Excel
Compile error: Method or data member not found
application.screenupdating = false not working
Making array in DLL available in VBA?
Runtime Error 1004
UserForm does NOT save changes to design (Excel 2000)
Export to Excel 2007
Userform does not load
Blacnk Cells in Excel
Pivot table formulas
Excel doesn't acknowledge formula as an operation
Force a Date variable to store a time value
copy data from excel 1 to excel 2 when different dates and columns
Argument value, application.run
Defaults for 'Find'
About Officemenu(RibbonX)
Corrupt/ Bad Recordset
Help Please !!!!!!
Date problems
If blank, insert adjoining cell value
code to select first sheet
Add-Ins aren't loading
Re: Populating a calendar with VBA
Macro Suddenly Stopped Working
Use Cell Values to Create Tabs with specific names
Using VSTO to Print Excel Document without Empty Pages
Re: How to use automation to save xls into pdf from office 2007?
Macro - update the cell to the left after a find
Build a range from a cell
is there a way to avoid repeating yourself in an excel if formula?
How to update datasources of a pivot table ?
Backwards-compatibility problem with OpenText
Tabstrip and Treeview
Border question
What is wrong with this macro?
How to trap an error with onError in a for i loop
Sheet Protection Bug?
search an array for values contained in another array
RE: Worksheet_Change Triggers on "Delete" but not on Data Entry
Putting an Icon on a CommandBar Button
Late binding
SpinButton problem
Macros Referenced in Custom Menu Fail after Save
Best way??-one WB, many users entering only their own info
Re: How can I programmatically add a hyperlink to a cell in the excel ?
macro changes sheet location
Using Vlookup with IF statements
Auto Filter
Autofill in VBA question
Custom String Format
scroll to activecell?
Can I simplify these IF statements
Validation Error - Please Help!!!
Is there a more elegant way to macro this?
Using Vlookup for IF statements
Keep getting Errors in Code
vbscript and Excel
Split string into seperate cells
Must I VBA?
Lookup to return multiple results in one cell
How to "Step Back"
Copying text from website OR selecting and coping certain text within a cell
RE: Need stopwatch function
How to Print out Code
select fields with more then one dash (-)
Xl 2003 Sp2 error message
Collate information from different files via a macro
Looping Thru Worksheets
Question: "myself" in a Class
Summing occurrences within a list
"Number Formatted As Text": How To Avoid?
Pop up based on criteria
Running Macro on Multiple Worksheets
Error on input box
Loop through range and add each cell contents to a string
Hide sheet - Help
EXCEL SPREADSHEET HELP
Prompts to Discard digital signature while saving
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste
Problem with Excel 4 macros (I think)
Drop down list/Combo box?
Custom Add-in - How to Manage
Controlling media player in VBA question
Count non-zero cells
Calendar Pop up issue
Updating from internet
RE: FileSearch parameters locked
Re: 3rd party software for building add-ins and help files
referencing to matrix labels
Merging Cells
truncate numbers
Find ID Number
Scope of variable
Where's the Excel 2007 SDK?
Bug - Programmatic copy/paste other sheet to activecell
SaveAsCopy generates error HRESULT:0x800A03EC
New site for all IT students
Stop
Turn off ThisWorkbook Code?
Listbox to display ALL Available Printers to User on a Userfrom
Re: Worksheet_SelectionChange stopped working
Adjust Windows Date/Time from Excel VBA
Charts with Combobox
Re: Send SMS from Excel
Pivot Table drilldown and protecting workbook
Summarise data by average in OLAP cube
ADO Excel to Access - bulk transfer of array?
Object required error...
Solver ignores constraints in protected sheets XL 2003
Re: Is Auto Filter On
Re: Creating a Dynamic Array from list that may change in size
why only 1 Excel window available since 2003?
Add Page x of x based on sheets.
Re: Find in a column
modifying Ron DeBruin's menu macro
Labelling a persistent object
weird excel 2007 bug
Re: 'Option' Buttons
Creating charts in non-English versions of Excel
Fill a combobox preserving characters format
Customer Add-In Management XL2007<-- Please Help!
How to label an object that persists in memory?
Populate Excel Spreadsheet and Preserve Cell Formatting
Loading DBF into existing sheet
Change ColumnWidth for Multiple Columns?
Calculated field in Pivot
Re: Macro Use
Need Help
Delete a Comment/Note/Macro
Preventing a cell value based on change in other field
vbide
Linking Excel files with part of a file name.
DeleteDuplicatesViaFilter From Chip Pearson's Website
Opening Workbook to a specific sheet
Conditional statement
Setting the Headers and Footers in Excel 2007 when exporting Information from Cobol program
Workbook.Range Problem
CommandBar not Visible on Chart Pages
Save as method generates 1004 error
Code to make only certain sheets visible
vbKeyCapital
RE: Locating data from a list
vba Code Performance
If Worksheet is active then...
Populate ComboBox list with Access data
Secure Add-ins
RE: New Book Template
pivot refresh hangs
select columns by text in first cell
Add values from two columns into third one in another worksheet
Sub menuing
RE: PRIMARY KEYS
I can't figure this out - please help
Re: Rerunning Macro takes longer after each consecutive use....Why
word userform using xl database
Re: Microsoft Query - pull data from Access "Too many parameters"
rs.find or rs.filter
Excel 2002 Verisign Digital signature
Re: Generating report with VBA
Help with dates
Automate IE right-click "Save Target As..."
RE: VeryHidden causing a problem...?
input string into a column based on the value of a cell
Number Formatting
RE: retrieving the day of the year
RE: Place a list box in a cell
Re: Specifying a string in a range
loop problems
Re: Place a list box in a cell
Re: Why Checkbox count = 4
RE: Subtraction by row
comparing spreadsheets spreadsheet compare add-in
Re: Why Checkbox count = 4
RE: How to get all number combination from a list
Re: Worksheet_SelectionChange stopped working
creating popup menu when user right-clicks on cell
Cutting cell with object
Simplify this into a loop
Formatting Numbers
How to install a new version of an Excel program - Import file does not allow replace to modules
Imperfect Matches
combinations
For-Each-Next Freezes Excel
need to speed up some page formatting code
make VbA invisible
Checking 2 Ranges
add 1 day to date variable
Subquery Confusion
Excel attachments in Outlook automatically print when opened
Cycle through pivotcharts
Extend Excel C API add-in for using RibbonX API
Creating a range stack
File Not Found Automatic Cancel
print macro is slow
Failure at File Save
Search column for a value
VB Statement for opening multiple files of type?
Code modification help please
Excel97 to 2007
Must I Always Click Twice to Return to My Document from a User Form
Use External Function
not sure on constants
code to deselect a chart modified by VBA
Application Status Bar circular
Slow chart problems with very large data sets
Find postion of number character within a string
BeforeClose Event
How to add filter to email macro
Cell Value to String and Trim then Delete un-needed Rows
Change numericals in alphabets.
Shared Workbook - Freeze Pane & Hidden Column Issues
Email Booster from Excel
Adding/deleting ranges and renaming accordingly
VBA Sumproduct for External Source
Addnew
Validation check
Using the Dictionary object
RE: Help needed with Inputbox problem
Filtering data via VBA code
Re: Help needed with Inputbox problem
Application Status Bar Scroll
How to find and count # of files in a directory
how to add a macro
Togglebuttons in a Userform.
Grouping values
is application open?
drop down list
Enter data in correct row from form
Excel Macro Question - correction
Excel Macro question
Unattended Installation WindowsXP and Software
Code for Work Sheet
looping through one range to fill another
MSXML2.DOMDocument
sendkey problem
Convert Text into Formula in VBA
copy chart delay (musa.biralo query)
number transform right at data entry
Compile 6 identical ranges(size and fields) into a text file.
copy column cell data onto another worksheet
Userform enable/disable
calling/running a macro on another worksheet
clear picked cells
Pls Help! Sending data to an IE web form.
Pivot Table VBA question
WORKBOOK OPEN
before double click
newbie question
looking for repetitive information in a report
looking for repetitive information
Find Programming Job?
Excel 2003 vba hiding totals for some pivot items and not others
Hiding Empty Rows
Custom Footer (Dynamic text with Static text)
Comparing Two Columns on Two Worksheets and then Adding New Info.
InputBox that obtains Workbook, Worksheet, and Range
Cannot debug
Excel saving with unknown extensions: .rcv and ht_
How do I run an external command from within VBA
Using a worksheet as a table in an SQL query
Array formulas + more than 255 chars
Replace...
I need a macro that fills in a cell with an "X" if I click it.
copy and pasting header information
adding date with double click
Compile error
Need to replace existinf graph for new graph with the same name
combine vlookup and hlookup
How to copy a file from internet to local drive on VBA
Opening Workbooks
remove the border for all series for all charts
macro to increase a value and print
Automate Copy and Paste
Flashing highlighter
excel loading add-in..
DisplayAlerts
about the limitation of bas module
Making modifications to macro module from R. De Bruin
Delecting Rows
zero to the left of a number
Open a file in the same instance with ShellExecute
Windows in Task Bar in Excel 2003
macro-written correct formula returns #NAME? and #VALUE?
It works but I need better code...
Trouble with SENDKEYS?
More Excel 2007 Speed Issues
Problem Saving with the 'Must Enable Macro' workaround
Check for existence of a file
Copying data based on certain criteria
Format to Value
macros and collections
Find Last in Range & Insert
Copy paste to another Workbook, Error 1004
Vehicle Insurance Premium Calculation
How to work with only one colum of a variant
count rows till cell is blank
Modeless Userform Not Displaying
Date Format Frustrations
Control G
isempty close
Strings to Numbers
Modifying hyperlink beyond default options
Locking all cells of a given color in a given range
Type mismatch error in Find method
Sending emails with VBA is somehow getting stopped - help appreciated...
# sign doesn't work with between-date searching
.xla removal
Convert hours to days-hours
Refering to Active Wbk from VB6
Program for Fan Balancing
Changing the CONST Variable
Cahnging the CONSTR Variable
Userform change question
Problem in Range VBA excell...
second event
How can I count BOLD letters in a cell?
SORT (Excel) doesn't work in a column created from a LOOKUP functi
import access dates into xl "calendar"
Resize the image in excel 2007
SaveAs command doesn't save extension
Write VB6 code to be used with VBA
Formula req for macro
game in excel
probably really simple for most, but not me
formula or code?
complication between VB syntax and Object Value with [-] minus character
Save worksheet as new workbook
Apply bottom border only on filled cells, leaves blank cells without border?
Toughy...
Disabling events within an event handler
VBA equivalent for WScript.Sleep
Combining a Text or picture into another picture
How do I determine what key was pressed
Automatically add a textbox to a user form based on user requireme
Can I add this VB script to a VBA script?
Selecting print range
How can I add scrollbar to a number of cells
Address of first visible cell
Deleting cells
Highlight active cell and de-highlight previous cell
addresses
Add-in does not load
EXCEL VALUE PASTING
Major 2007 Excel Problem
Macro Help
show daily sales as a percentage of monthly sales target
Macro converting Wind Direction from text to degrees
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
Web Query
printing
65532-65536:Hyperlinks
Declaring a variable as a range in another worksheet
How to programmatically set a focus on the selected cell?
How can Excel check that a text string is even-numbered or not?
Paste as Excel object (not as picture)
Audible Alarm Marco w/Pop-up Message
upgraded from 200 to 2007- modify macro menus
Live chart in a userform
Errors of Adding OWC10 Spreadsheet reference
Edit Chart Macro Help - Skip ActiveChart Selection if no data
Calling a VBA add in from a macro subroutine
auto filter macro
calculate hours using start time & end time, excluding weekends
PointsToScreenPixels Documentation Incorrect
copy cell
telling a macro to go back to where it came from
Delete Worksheets Named Sheet1, Sheet2, Sheet3, etc.
summing based on multiple array criteria
Merge Multiple Workbooks
Object required error 424 why getting?
Microsoft.Office.Interop.Excel Texttocolumns C#
Losing worksheet calculations reference when deleting a sheet
Choose Which Macro to use
Read from a terminal application
Check if Excel file is password protected
load/parse large text file
Find repeated values in multiple worksheets and create summary worksheet
ADO recordset
Name a sheet using letters from a string?
clearing columns in VBA
Prevent an Image from being removed
Macro to copy text between delimeters
Activate an open window and send keystrokes to it.
code for selecting 2nd visible row
Time
Adding counter to new worksheet
Equivalent of Workbook_BeforePrint in C++?
plz plz help me out with this
Open a file - Application unknown
Filling a ComboBox range on focus
Update a file on AS400
Supressing "Do you want to save the changes you made to <file>?" message
Tree View Design help
Hyperlink not showing complete file path
Help sought re vbmodeless form rendering a class module useless
Help with disabling items in the menu
Help with Command Button
Arrays and picture
Hiding Rows Error - "Runtime Error 1004 - Unable to set the hidden property of the range class"
Need help with a repetative task
Assign kbd shortcut to a macro using vba
Formatting issue
autofilter criteria
Display "Activate" dialog from sheet navigation context menu
Import data using QueryTable somehow change sheet cells references
Copy from one workbook to another
Can I get information