Excel Programming [Archive] - Page 95

Error When only 1 row or zero rows of data
referencing range elements inside the macro
Countif?/Vlookup?/Macros???
Restricting Add-In functionality
How to stop print in blank cell?
connect to sql
format column
Default Value to Number cell
Save As Function
Always prompted for Save with function
Is it possible to create variables in a loop..
Office 2000 vs 2003
Assigning a numeric value to a alpha character
Working with protection
Determine Length of Service
Run-time Error '91' Object Variable Not Set
count occurences of font color
Problem with hyperlink with bookmark
Calling a Sub from another
Delete a Row
Momentarily Display Splash Screen
Read/Write
Save Workbook
Excel - Oracle database connection
Data Validation
email based on cell input
Cell value specific font size change
How to Reset Workbook Counter?
error checking Streamlined
Open Words doc from Excel Macro
names of all excel vba help files
No Personal Macro Workbook?
Working with Macros - ActiveSheet.Paste
Working with Macros - ActiveSheet.Paste
Need to find two consecutive identical cells (in a column).
User Input - sheet and ranges
Why does file size grow ten fold?
Global Variables
Macro to create Cell Comments
VBA Cell Referencing
Shouldn't this work?
Font adjusts to size of cell
Why...
Is it possible to have a different footer on each page in a sheet?
Find first non-empty cell ranght from column A
Code Cleanup
Recurring problem - user input date from messagebox doesn't get formatted correctly in secondary cells.
Basic VBA question...
Need a sample or VBA code to open a C# windows forms in Excel using Macro
creating a small array from spreadsheet values/counts
User input to name a sheet?
Workbook without .NET
Filtering daily data
External Cell Reference in VBA?
adding pounds and ounces
run a macro on a certain action
adding up hours
UserForm Active
Random values from a Triangular Distribution
how set default path?
Autorun Macro for ALL Workbooks
Correlating Date to tab number
Excel Macros
Union Method
limit character length when copying or typing
Error Capturing Date and Time Formats
Finding Next Empty Cell in Column
Not excel, but try anyway
RE: Union Method
RE: how set default path?
Clean up help
RE: how set default path?
Very urgent help needed: Excel is still running after closing it!
Looping data out of array
Inserting Symbols via a macro
Moving pictures
Made a button, added code, now what?
Autoadding new row
open another application using excell
Access Excel MsgBox from .NET - howto
detect and repair vs regserver
External Cell Referencing in VBA?
Custom Menus
counting filtering data
Open a template, copy 3 worksheets w ranges and save as workbook
Create Toolbar with VBA
Range Parameters in Function
Form button question
Excel Formula assistance
How to write a data in Excel file dynamically from C / VC++
How to write a data in Excel file dynamically from C / VC++
Loop same formula for different columns?
Excel 2000 Copy worksheet w/ ChartObjects memory leak
Conditional formatting Question
Accessing Page Setup Options from VBA
downloading from the internet
Select first 5 characters from another cell
runtime error 1004 pastespecial method of range class failed
UDF: copy help file, also button image
Disable prompt for newer version
Internet Explorer Automation from Excel and the ReadyState propert
Modal Userform and Preview on Screen
closing a word document
Possible to "group" with statements??!?
how to choose random namber form loop?
Workbook.Activate / Window.Activate problem
Forgot the Code
how to permantly delete a custom menu in excel
delete everything but print area
Automate moving between pages on a pivot table
Command Button vs Form Button
Help me please!!
how to copy named sheets to separate workbooks with same name
Macro - asked username & password and sign into Yahoo Finance
Count rows in a PivotTable
Excel VBA to use worksheet embedded in Word Doc
Best way to delimit text file
Compare date in cell to date in Textbox
Confused about formatting of contents and cells?
Trending checkboxes?
Paste Special between Spreadsheets
Simple average question.
Nested if returning error 1004
How to Copy WorkSheets
Excel and Access database ?
getting data from html, then archiving
Run-time error '1004'
Passing a range of data to a function - Excel - visual basic
Change event copy & paste
Limit Highlighting
Cell Contents on UserForm
Assign a Colour to part of a Cells Text?
How can i apply the validation on the cell with invalid data.
Add ins
Weird gray line at top of screen
Taking data from HTM to EXCEL, and then Archiving
API functions
Getting Data from HTML to Excel, then Saving
ok cancel dialog box
Tree view not displaying any text
sumif weekday
Making a function global
Incrementing Do/Loop, For/Next and For/Each
Fill in contents based on another column
Limit Row and Column Highlight
Date Not Null
Getting rid of decimal numbers
selection.font.color returns wrong color; the first execution
Creating a Userform
do loop
Delete row
Urgent problem needs help in solving
Which Element in Range?
execute stored proc in Excel
re-name workbook?
next closest value in unsorted column
Function Sub Procedure If Not Active Worksheet
Specifying a Command Button on a worksheet as differentiated from one on a UserForm
macro randomly stops working
Floating Vertical Menu bar....Please help
Shut Down PC
indirect in VBA
error messages
countif - I want to enter 2 parameters - how?
Problem with code to print - out of order
S & M equal to 1
how to turn of a series in data sheet of a power point chart using macro
Executing complex Oracle queries in Excel using PL/SQL
Function with parameter "as range"
Autofit in cells with multiple lines of wrapped text.
I am trying to find X in the formula X+(X*i)=Y+S
S and m equal to 1
How multiply hours and price?
My & and TEXT formula is not calculating
sort and matching cells
Rows to Columns?
Help Please
3 dimensional array
Reading a list
Shared Worksheet
shape (with macro assigned) flashes upon click
Save as macro
problems with .Crosses and .CrossesAt
Macro to Insert a row and copy Formulae
Distance/Time calculation
Combo or Checkbox
Pivot Sheet Name Code
Ignoring Message
VB UserForm
Extracting Text Data to Excel
Validation Error Message stuck
use of indirect function in vba
Breaking a UserForm
Help in Keeping Cell at Active Cell
Changing the value of a year in a given format
trigger problem
IDE Immediate Window Limitations
Linear Chart - VBA Code
AddIn - how to create?
tab delimited file n sorting by columns
Can't get Rows to delete in macro
Syntax help with range
??? "For...Next" code only run 17/35 times
How to write a "C" data into .xls file in C
problem protecting word document by macro in excel
???Set cursor away from combobox
Calling macro from UserForm
vba: isDate function
trying to enable top level command bars by context
routine won't recurse
autofit problem
Don't print 1 cell
ListBox: How to determine length of list in different columns
VBA: PLAY and WAIT
Pass date to cell in spreadsheet
help!
Polish my code, please
character limits
OnTime
context for the command bar
Need help one a "complicated" problem
help with sum if formula
Selecting all cells of a certain fill (interior) colour (macro?)
Timing when loading a picture
Sorting a collection. *Leaving Duplicates*
Change text to date and check against date in cell
Select last n rows and delete?
VBA equivalent for SQL 'IN' function
Creating Input box that grap data based on user answer
Data from one sheet to several based on category
Run-time error 91
Adding a Next Record button to UserForm
Creating a TEXT formula to link a word in one cell with a number v
last row query (thats driving me mad!)
Visual basic Code or editor won't load in Excel
Code to make a sheet active
Color code in 2 column conditional
code execution has been interrupted
summing a column up to a point
Delete Rows Where Value in Column V is Less than 2.5?
IF statement to check against list of values
Inserting rows on cell trigger
Copying Question
Database form
Function to Return Mutiple Text or Addresses
Add leading zeros
Querying a range from within excel
Excel closing file problem
Saving custom icons associated with a macro
Compile Error: Loop without Do
how do I open a new Excel file without including my custom menus?
Determine the current cell while inside a User Defined Function
Hyperlink to network address
linking excel to outlook
Kill command using &
Macro to Refresh Data & Print
Sorting with a drop down list
Activate button when all fields populate
Background Cell shading colors
Help with Code
Easiest way to import sharpoint list data into excel programatically
Chart Export in BMP format
Is it possible to protect specific cell even with sheet unprotecte
Call procedure using Application.Run
Import text file - how to delimit (noob)
Checkbox macro question...
loop question in VBA
Getting Host Name
Worksheet_change
Mimicking an GroupBy Clause in Excel
cell value
VB code to concatenate 100+ cells
Multi-dimensional arrays
How to repeat "save as" in Macros
MVP help please - dynamic pathname in ODBC arrays
Automation
Is there a quotient function in VBA that's like Mod
looping through current region
Looping
Format cell color based on multiple variables
Re: Format cell color based on multiple variables
Prevent error when deleting row within Worksheet_Change target ran
MATCH using multiple criteria?
Testing for Slow Routine
supress prompt for named ranges when copying sheet to new workbook
Need help w/ XL macro to open WD doc
How assing unique number in a column based on a combination of two cells
Worksheet with multiple Hyperlinks and Macros
Color Chart using offset
Unable to find project or library - Please help.
Accessing pass through queries from Excel.
pulling from 'line' inside cell- best way to reference in VBA?
Macro to print several worksheets does not work!
VB Question
RE: Error -2147467259 (80004005) Method 'xxxx' of object 'yyyy' faile
debits and credits in one column
auto fill
Can excel documents be formatted to AUTOMATICALLY email?
How to change multiple formulae by looping
Custom toolbar
Complex Formula Solution using Search and IF
Pasting/Compiling Data To The End Of A File
How do I use countif an array for >=45<=50
Removing "hidden" ODBC links
Diabling Target Workboon Macos (if necessary)
Searching for Hard Coded Constants
Creating New work sheets and assigning names automatically
AutoUpdate Links
vba repeat in the next cell down
Help logon to this site with VBA
how can I set a column as text in c#
Search cells from value of Combo Box
get the User PW
Refreshing formulas via VBA
Identifying the name of the fill color of a range
cells name or range name in a worksheet
why the value are out the header...
Checking if the TARGET has been deleted
Removing Spaces within text
function to count in the cell a1=a1+a2
What is the SQL syntax to concatenate 2 fields in VBA for Excel
Automation problem saving Excel as HTML.
Returning the row number of a cell in a range that matches a given condition
Returning the row number of a cell in a range that matches a given condition
Optimizing performance of functions that access a database
copy and paste cells to a different worksheet according to IF results
Locking buttons on sheet
Pivot table "Group and Show Details" vs. "SubTotals"
Single versus Double
How can I export a chart from Excel to Access??
Protecting merged cells via Macro
Rename Worksheet
Selecting Invisible worksheets
program a cell in excell to reference a cell below a referenced ce
Re: EARN OVER 9850 DOLLAR in 3 WEEKS !!!
Where is the FAQ? (for dynamic input lists)
select cell based on two searches
how to cast a Range value to a Date value?
Setting ToggleButton Value
Treeview For Current Workbook?
Re: Vlookup function error
Re: VBA code to locate the command bar number the printer button is on
Vlookup function error
Remove PivotTable Grand Total
Copy non blank cells to another worksheet
Re: Macro Problems
Re: Macro Problems
help with sumproduct
VBA code to locate the command bar number the printer button is on
Macro for removing some parts of data, using LEFT/RIGHT functions
Macro Problems
how to reference last cell value in a column?
Visible sheets
Start Excel at a Certain Time
UDF not returning proper value - circular reference/multi workbook
Control items outside of excel
Drop Down Menu
Sorting
trap error in validation
BIG BIG HELP
referencing forms controls
Paste excel range into a mail item's body
Set Range on ThisWorkBook problem.
Fiscal Quarter code not working
tote programme
Find/Rplace
Macro warning...but no macros!
using a list box
Excel Emailing
builtdocumentproperties=value in a cell
Filters
Formatting textbox in forms control
Datedif
Appending to a cell content loses existing data formatting
Move worksheet within workbook
Saving values in a multipage form
adding content to a cell
Cannot remove item from collection
Object lost somewhere in the spreadsheet - How to find it?
Help With Formula and Macro Please
Renaming a Macro
DDE Command for GROUP
Deleting rows, multiple column criteria
Summing two columns
Continue
Loops in a function
Name truncated in digitally signing?
Event change Macro needed
Very basic VBA
problem with LINEST
dynamic range of formulas
Referencing a chart sheet
Delete value in a string
Remove specified value from string
messages dissapearing
Remove specified string from value
test message
SQL Server Login
Workbook_BeforeClose - Cancel not working
Remove specified value from string
"Linkize" a text box or label
Routine running slow (memory leak?)
Macro
Japanese Characters in VBA Forms
Copy value until next value
Delete Sheets
Excel macro question (Problem)
how do I link optionbutton to column & copy contents to another co
Update A Record In Access. Not Adding But Editing
Extract sum range
Capture Update Links Error?
setting a dynamic path in an excel query
Data - Validation Excel Question?
Whats wrong with this code?
'If' with text values
If function?
External data storage
copy worksheet from xla to xls
Macro Works but not in Debug Step mode
The parameter is incorrect
Shortcut of menu-item
help needed wth cell val ck, increment. insert
Refrencing
Accessing excel via the web
Splitting cell entries of variable length
Add-in functionality with .xml files
Excel User Conference - Registration giveaway
Excel User Conference - Registration giveaway
opening workbook as read-only or write-enabled
align text item in listbox...
Countnumberofdays while function = TRUE
Strange error??
PHP isset function in VBA
Help Help Help Help!!!!!
find date and copy selection
substring matching functions (need a hand please)
Copy a cell from a previous worksheet using a macro
Stuck At Work - Need Help!!!!!
Correcting an extrapolation macro
print a chart in another workbook without opening the workbook?
Shapes object events?
Loop in my macro doesn't seem to be running; however, it compiles fine...
textbox help please
stock screener
opentext method
Import Charts and Data to Access
userforms
vlookup in vba
Syntax to insert an array formula in a cell
filter error
Copy column data
i want display the last coloum value in first coloum
Get Rich
userform question
Removing/restoring toolbars
Built In Support for Sorting Objects
array problem
Bizzare behavior of IF..THEN
Protect UserInterface VS Protect/Unprotect
how to change form border color?
save sheet & print automaticly
Test for blank lines
Custom sort in macro disappears
Make adding a footer optional with message box
Cell Validation
Serial Data to ASCII
Freeze Panes
Modify formula to display Null
Loop and transpose sets of data
How do I get this data from email (Parse)
data reduction--goal:unique time data only
User-driven abort?
Complicated Find Question!
setting caption of field in table in db
Forms - return keyed leaves square
mdb - > xls
Create a dialogue box if a cell contains a number
Update Links
How do I get excel to calculate leave and zero again?
Delete rows with nothing in Column B
Lost all my macros
Cancel Print?
If statement - Multiple Sheets
Userform SetFocus with Exit and Cancel
how to save spreadsheet at a specific time automatically
How can I break down a string with data divided by commas
Search in Excel Dtabase
Thanks to AVVEERKAR, and more on ComboBoxes, please
Calling Excel/Opentext method via ActiveX in a service application
Creating switches
transfer rows between workbooks automatically
Why is excel calling 2 times my fonctions
Format top row, but only non-blank cells
How do I set up a querry that copies and pastes
Import from text file with German Date seperator
test
Macro crashes "Automation error" during copy of workbook with char
Next if blank in For Each Loop
Formula help
Setting pivot field using vba
Maximize Excel Sheet
Complex sum function help - possible?
Changing Code Modules, PLEASE HELP ASAP!! PART 2
ComboBox on a Sheet
Use Select / Case to find certain text
online tutorials?
Assistance with macro to determine if a specific worksheet is pres
Read Permissions
Another Excel 97 Problem: Not enough memory
Add Button Image to Default Images?
dot / comma and string to double conversion
Doesn't work all the time
Selecting multiple ranges
Integration with Microsoft Sharepoint question
Browse for file and set initial folder to search
Reset public variable
if declaration
Hiding Rows in a Range based on column A value
start when activate multipage on form ?
Selecting Cells to enter information
Opening an attachment of a message that has a message as attachmen
Go To First Sheet
ATP or ATP - VBA
showing a date as text in Concatenate
Macro Help. Looping, code change.
File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
Adding Help Files To Custom Functions/Macros
Transfer digital certificate to another mahcine?
Conditional Formatting for Column?
Printing Problem in Word Document Created from Excel VBA
get back data from userform
Automatic CSV saving pains - unwanted rows and columns
Distribute Toolbar to other users
Macros project
Change a # w/decimal places to no decimals, 13 char's, w/leading 0
Import Hyperlinks
If Statement
Number Puzzle
Can I create a dimension with undefined multiple levels, pivot table.
Copying Multiple Rows
Excel, client access & AS400
How does .offset(i, counter) work?
modify the behavior of the enter key?
Auto filter from a cell
offset command protected
convert utf-8 to ansi csv?
Images in and from mdb-files
Script to interrogate the current system time
Problem: Worksheets("New Style 2006").Unprotect Password:="naPrint"
Viewing a worksheet within a Userform
Update Batch
Loop through the columns and extract the matches
xla creating new menu items
Sorting
Copy paste ranges from multiple sheets
Follow on from Hiding 5 command buttons - Excel 97 prob now
VBA to expose details of zip files
make single column of the sheet as readonly
How to Count Months in a Column of Dates
Call a function in some sheets
Apply a macro to all sheets - save me from hours and hours of work
table is be or not be
multiple instances
Import to excel Access database directly to a variable (not using sheets)
Automatically Selecting An Option in a Data Valdidation Cell
Access.Application.Quit - opens Access again then won't close - He
For all workbooks in a folder
Re: Adjusting the Chart area
Make sure that the excel file is still the same
Why doesn't status bar update consistently?
Better / faster solution for OptionButtons?
WorksheetFunction.Round using user-selectable rounding value?
is this impossible
Adding values to a bubble chart
Update Chart by column
GetOpenFilename - dialogue box
Cell value change event
Copying first 4 characters of column
Excel12 and VBA: any peek news?
Emailing Active Worksheet
Help with code please
c# code to add button control to the worksheet!!!!
Q: how to create summary daily lists from another, and reverse
Which commands to use in a macro
Creating a count variable for interpolation
Need help for access to excel via VBA
Location of dll (API-function call)
Command for userform to load website link
GRAYED OUT RECORD BUTTON?
Parsing a Text File
VBA question!?
I'm a newbie, urgently help needed
Measuring Column Width
compare numbers -- recursive?
How to copy only some rows from range based on condition?
Is there an onEnter event?
Excel 2003 VBA Copying Formatting Problem - PLEASE HELP!!
Combining name ranges to create database. Pivot? Consolidate? I've tried and I'm stuck!
Slow data filtering
Loading website from userform
storing value's
How do I hide 5 command buttons
Nine random and unlike numbers
How do I combine data from various Excel spreadsheets into one Excel spreadsheets
auto dropdown menu
Loopy question
Help needed moving a command button
insert picture in a range
Sub will not find Column "A"
code and quantity log
Joining cell values together
How do i SUM data in Excel ex:email that contains "Numbers and Text"???
Joining cells together
How to have a Macro skip code if PivotTable/PivotField is not there
Can a drop-down have multiple selections?
Excel VBA .Find method - am I clueless?
UserForm howto?
Copying Sheet to Sheet
How do I keep Calendar Control from closing?
write a formula to a range
activate excel application after userform activation in modaless
Using if function with cell fill colors
HELP: circular reference
Help
How do I embed stock price link in Excel that updates regularly?
Import and Comparisson
Re: Personal.xls
Automating Extrapolation
Re: text compare, percentage of similar words
Prevent user deleting an XLS file
Re: Writing a simple macro or formula
0yW ***Hot stuff - check this out !!! 0yW
Verify if filename is valid
Excel page width in pixels?
run-time error '438'
Finding blank cell
How to Avoid Rounding Errors
transpose 7 rows/7 columns
Open window - on error
Macros in shared Workbook.
Help to loop Commandbuttons vertically
Help me please with pivot script (Dave Peterson)
TextBox.ControlTipText
combobox question
VBE acting weird - help
Excel User Conference - Atlantic City, New Jersey - April 19-21, 2006
Minimize Excel to taskbar
how do i use a combobox in a cell?
add button to standard menu bar
Copying comments text to a cell using vba
Freezing panes and the top of the screen
How to auto extract data from TELNET and enter in excel
Help with difference in time macro
VBA How to Reset a List box
Make a macro availiable to all workbooks
First Empty Cell?
First Empty Cell?
Autofilter - Remember settings
Help with Error
Re: (Again) Converting rows to columns
VBA Editor
Check VBAproject is protected or not
Functions grayed out. Excel 2000
What could be the error?
Make Search formula evaluate to blank
Equivalent of Minus in Excel. Also Union, Intersect.
select [a1]cell when hotkey(ctrl+q) pressed, after userform load
Insert 3 rows
Suduko Puzzels
How do I set up a variable reference range in Excel?
Delete row that contains keyword
User Forms - getting them to talk to Excel
Can I import many items into an Excel spreadsheet as a calendar?
Convert repetitive IF statements to array loop?
delete everything except e-mail address from cell
Protecting,Unlocked,&Check Boxes
Search range / manipulate cells
How to Create a Header Row
Using the Find function to get Left or Right data
Help - I Need Excel VBA Help With Sorting and New Worksheets
Can any help with a little script
DisplayWorkbookTabs: How to mirror Sheet Tabs option?
Bolding middle of a field programmatically
macro error when shared
Command Button question
Excel 2000 on Win XP
Expose macros with add-in
If activecell is not text
Last Comment
Change Hypenlink Automatically
not enough memory for pivot table in excel
Sort Failing on Some Data
Mac VBA compile error - Help!
Easiest way to import sharpoint list data into excel programatically
if cell is a certain day macro
automate data retrieval from folder
Running Macros without opening file.
What VBA activitys clear the clipboard?
Code for prompts for user to select datasource range for pivot tab
Limitation of collection and dictionary datatype
Lookup In Excel from Access Database
Ever been here?
Application.goto Workbook?
Simple Report is such a pain!
File size problem ???
Triggering Macros
Double Quote Leading to Apostrophe Problem
Send Lotus Notes Mail with excel
Renaming Spreadsheets
Is it possible to turn off errors in macros???
How to configure Excel startup
Embed Folder Treeview Or Windows Explorer On UserForm
Printing a hidden sheet
Error 1004 in Excel 97 when trying to unprotect a worksheet
Changing code Modules, PLEASE HELP!!
Clipboard turn empty running worksheet.unprotect - workaround ?
transpose formula
save picture in a worksheet programmatically
Macro to create a Outlook Appointment from excel cell data
Find the column you are in
Opening Acrobat Reader using VBA
getting activated userform name
Changing the Date format
macro that runs when the value in A1 has a certain property
Excel WorkBook Close Event
help with code please
updating historical prices log (macro?)
Listboxes and select items in it
Autofilter in protected workbook not working
conditional formatting question
Worksheet Change Event
Don't Print Autoshape Macro
formula question
Pivot Table sourcedata string truncation
Evaluate a cell evalute 3 cell based on result
want to create utility for excel sheet!!!!!
how to access excel sheet programmatically?????
Searching for link: Bob Phillips expose on NAMES
Input box for excel tab
Excel interfacing with Attachmate Extra via DDE
Network drive problems
Cannot Create ActiveX Component when trying to call .Net DLL from Excel VBA
Disabling cell resizing, Unmerging cells
Concatenate a Range of Cells
Vlookup with If statement
Trace Dependents Problem
getting selected listbox values
Insert Named Range using Excel Macro
Disabling Visual Basic Editor After Protecting Worksheet/Workbook
Rounding financial statements using vba
Setting a specific cell selection to manual
Trace Dependents Problem
Copy the formula from the protected cells
Comparing lists with misspellings
Accessing the Mail Recipient function
textbox disable scrollbars enable
Class within a class
using a calendar control
Userforms + Listboxes
if range=nothing then
Deleting Checkbox Object in Cell
Enter Text in Cell on Click
Cursor Event
vlookup question
Add Message While Program is Working
Formula Dropping Leading Zeros
Printing a form
Excel 2000 error
Insert column, move data with VBA
Repeat Macros Function/Program
How can I have excel tell me what string appears most in a column?
0 considered as empty
Excel save date
jittery cursor
commandbarCombobox problem
Lookup in Excel but pulling from Access
A Pop up message in Excel...
Error trying to run Excel 2003 Add-in in Excel XP
textbox position
How can we rename modules?
program cell to display any character when cell is active
Run Time Error 1004
is there a way to have excel ask a question after entering #
Speed up Program Process
Help with Custom Dialog Box
Increase and decrease the row height
Updating collection values to use as summary
Simple report from data list
Fail to load XML document
macro total for colums with changing # of rows
on error resume next
Use spinner to set a cell reference in a formula
Selects a letter
Why can't I use XML in the Student and Teacher Edition?
Range ... how to know if it is empty
Match Cells & copy
plucking data from one workbook to another
Changing a matrix into one large column
Deleting all sheets except one
Charts using Chart Wizard based Macro
Problem with setting chart size in VB.NET
Clear all textboxes on a form ?
Load excel range into multi dimensional array
User Form to Filter by Multiple Criteria
runtime error 1004 method range of object global failed
Default Excel FileFormat?
Arrow keys
sending email from excel 97
Macro works in one workbook but not in another
How to unselect?
how can I enter a comment in a protected worksheet?
Macro problems with Microsoft NT/XP
How do I make a check box highlight cells if true?
For each workbook in Folder
Open folder - Activeworkbook location
Custom Formula in Pivot Table Row
find row
Tool for auto loading/refreshing/updating/etc...
Excel User Conference - Atlantic City - April 19-21
TIP: How to avoid losing your arguments in a UDF
VBA Excel “Set” question
Automation:insert number to Excel problem
Form toolbar
"cann't find progect or libary" ???
how do i use lbs and ounces in excel
creating PNG
Enable automatic refresh prompt
Commandbars - again
using range name in Find
Book suddenly opens with no visible sheets
Need help parsing a string
how do i set up a repeating transfer data from excel to access?
rowlevel selecting
udf to hide a row
Changing workbook name in macro
find adjoing cells
Copy To Word
A Macro to search a string in a Word file
Excel text box
How to detect when a named cell (range) is Blank in VBA?
search in first column return value from second column same row
Generating Hex key/password
Differences concerning BackColor and ColorIndex
how to set up master page that will auto update smaller pages
New object/automation error
If this isn't already possible, it sure should be
programmatically retrieve links from web page
enabling chart events for an embedded chart
assign a unique number
How to update an entire column with IF statements in VBA
Is it possible to edit multiple pivots at one time?
Payment of Invoices in comparison with the payment period
Userforms
referencing a cell within a header
Reading H Page Breaks
Macro help required
setting where cursor is
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?
Error closing Excel after running series of macros
Error: Obj variable or With block variable not set
how do I write a macro covering a workbooks with over 40 sheets
Formula Help - Time Difference in Days, Hours Mins & Seconds
Validate typed-in value against in-cell dropdown list
Excel .Net Interop - .Net code not executing. Custom install of Office 2003
Recompile com object while excel is running
Run-time error 1004
Sum Data in Col B, Add % of Total Col C, Add Rolling % of Total Co
Adding OR conditions to IF-Then statement
right click menu, userform show
Change/cycle cell entry to next option from validation list (macro
this Macro is don't correct
How to get a cell location
Loop criteria based on cell value and color
Range Select Macro
Printing titles in workbooks
what formula can I use to link two different excel spreadsheets?
Find Range for Pasting of Records
Ctrl+Shift+Enter for arrays
determining a Commndbar name from a cell
How do i require a user to enter a data in a field in Excel
Please help w/ VBA charting and dates on x-axis.
Array Offset Function
refedit control cryptic returned value
Open an Excel file to a specific spreadsheet
.csv file conversion
Clear autofilters?
Protected sheet and Autofilter?
looping at regular interval
An easy question... Maybe?
Extract Certain character from string
paste values from named dynamic range to another worksheet
Stumped by "Object variable not set" again
Print Workbook Command Button
Creating an invoicing utility
Delete Rows that Contain the Text "Total" and vice versa
label
Creating ATL controls for Excel..
Form Repainting Problem
Dir function to check for file not reliable
Problem with a very simple code in Visual basic
changing size of autoshape
Visual C++ - Problems with users clicking!
Simple line fix request.
Display input message in textbox - with merged cells
Save in same folder
No argument list showing in UDF
Avoid .activate
IntelliSense Problem
Referencing Closed workbooks...Help!
Double Pagebreak?
Problems sending mail from Excel to Outlook
Excel Form - Scrollbar and associated field references
Run this macro whenever the worksheet changes
VBA and Pivot Tables
Interrupting a Loop
Save to Network Drive Problems. Expanding Current code
Stopping errors when a find statement doesn't find!
Excel2000: Insert a copy of row range
Make new folder & save to it
Menu Controls Index
How to trace a function f(x) in excel?
Upload to sharepoint
Transferring data withour overwriting
Run-time Error '1004'
Re: Creating sub menu in Command bar
Documentation
how to close a hidden spreadsheet?
Nominated range not recognised in User Defined Funtion
excel pivot export to access
Email attachment when someone else has it open
Compatibility issues
visual basic conditional formatting produces strange results
visual basic conditional formatting produces strange results
VBA - Tool References - menu freezed
Font format in Word
what are macro commands for...
using macro to change auto filter in shared workbook
Protection and Enable Outlining
Displaying forms in Excel with vb.net
Tax and Reverse Tax
Code execution has been interrupted
Running macro on the perticular worksheet only
Excel run-time eror
Dynamic AutoShape
Generating HTML from Excel
Pivot Table - Overwriten PivotField Label
Insert formula with code dynamically
Capturing what tab was selected
Range based on interior color index?
Running a macro to edit one line in existing VBA
how to round a cell value in formula
Excel VBA project explorer no longer available
Sumproduct with calculated column
webrowser -> excel -> deny modifications
Read cell value with a macro
Importing File with VBA really really slow
Question on a Chip Pearson macro
Sort from row 4 down
Writing File in VBA with Unix line break
How do I display numbers as feet AND inches, as in x'x" ?
Increment/Increment letter in alphabetical order
select range and put range address in variable
Cross worksheet find and paste
How to get network drive mapping
worksheetfunction.vlookup in vba
word <-> Excel automation - Too many named ranges?
my auto cell hiliting procedure kills copy/paste
Getting cell position in points
Sheet name change
Excel VBA Challenge: Creating a callout with exact location
Detecting changes in results of formula
Excel Window
Reading from an open word doc to excel
inserting code into code module crashes
Maximise Box
Workbook Name as Variable
Confused by for/next loops
Lookup from Excel to Access
Changing the macro editor default settings
list or combo
Class Module
Conditional Formatting -- Not after Page Breaks
How to auto Sort list after entering last item in a row.
Excel sheet copy problem
Macro Programming Syntax
Selecting after Find Method
Appending to a Cell doesn't keep format of existing content
Excel file on web with filters
dealing with blank cells in a range
pivot table calculated field with user function
Two Way Cell Value Connection A1->C1 and C1->A1
macro to find data and select from active cell to the last row
Smileys in Excel
How to draw on UserForms???
Creating a questionnaire.....
sliding commission calculation
Data Validation
Code for Arrow keys
Deleting rows with Advance Filter in recorded Macro
Custom Filter using more than two 'OR'