Excel Programming [Archive] - Page 128

Dynamic Named Range count
avoiding VBEopen when using CreateEventProc
How to avoid re-initialisation when Unloading form
Add and rename a worksheet
Listing of Face Id's...
Error after last object in the array when looping For...each
using default excel screens
How to build dialogue boxes into macros
Programmatically switch off "Variable declaration reqiured" in VBE?
Macro: If
Excel and VB6
Range object
Speed up performance for very big array
Random number generation from a set of non-sequencial values
CurDir
Ensuring a cell is copied in text format
Problem
newbie questions
how can one obtain the current selected cell value
Code Still Does Not Work
combobox events
General question about using "worksheet" when select from the VBA Editor?
usings contains in var check
How to create a dropdown list of dates with validation?
Saving to the desktop w/ VBA
How do I save to the desktop across OS's?
ActiveWorkbook.SendMail Security Warning
please help with FORMULAS
link from one workbook to another workbook
Print Orientation Toggle
Re: Strange window behavior
Run-time error 1004
Double prompting of an over-write confirmation when saving a fileof the same name
Default Page Breaks
Will their be a fix for KB 818808 ?
Using Multiple User Forms to pass info from one to the other
Cell Reference to a location
re-organising a table of data
Copying over Rows Once
please need help : collecting data from different places.
Subscript out of Range Q
Closing Other Workbooks
Returning checked Nodes from Treeview form control
Exiting Design Mode
Intersection?
Open event to call procedure ONLY on Monday
macro attached to workbook: to be sent to other users
Multiple Users
Looking for eloquent solution: Determine of any control on a page of multipage has been altered (userform)
Sum active range
How to ungroup a set of controls?
Listbox column headings
Populate and refresh
Not equal to?
Command button on a protected worksheet
how to lmport a text file and save it as an excel file using vb s.
Web Queries - bypassing "no connection / data available" messages.
how do I log events
How do I log everytime an excel workbook is opened?
How to "bypass" run-time error '91'????
finding the first blank cell and then executing rest of macro
disable listitem
Macros not running
this is about excel programing
Date in an excel form
How to clear a form from the screen
Values from another workbook
Excel closing event of a specific file
Populate selected Cell with variable
Database ready
complie error
Put a button in a cell
Sheet Code Module: copying code to
?thisworkbook.VBComponents(5).Type returns 2
FIFO: Share calculation in VBA?
access from vba
User Form
Replacing Named Range Names By Cell References in Formulas
Add Macros to Someone Else's Personal.xls
Storing text in an array
External Links Problem
MSComm locking up Excel
splitting worksheet into multiple workbooks
Floating Toolbars
Custom button, code placement
Scripting Excel - EXCEL.EXE refuses to leave task manager after .Quit and =Nothing?
Drop Down boxes
Read image from excel file
Return an array of values from a function
Excel instance not shutting down
Monitoring Changes
Formula Help Again
populating data from excel into access
Formulas
Command Bar with Number in Name
Custom Toolbar
Move an object not using increment property
Re: Strange window behavior
Excel object - save as csv from Word?
Creating & Naming a New Worksheet
Re: how to run other program's macro in excel?
Re: Read about excel - word integration?
Inserting Cell Contents into a header
RE: how to run other program's macro in excel?
Determine application language in Excel 97
RE: Problem caused by Googels personal index software!
RE: Strange window behavior
RE: Extra projects in VBA editor?
how to stop program in a big loop?
Selecting AutoFilter Rows
Picture
Autofilter Properties
How to Kill Excel application process
Excel 2003 bug? VBA custom menu disappearing
Get a workbook to import data when openeing and export when closi.
getting back to excel
Find Excel path
weird saving of a document with macros resulting with macros being transfered to the copy
Menu updates, Administrator VS limited account
Saving the activecell range for later use
OPening worksheet
Locating Latest Workbook
Last Workbook in A Folder
Web query for pictures and maps
Changing Workbook Property
Calculate Individual Sheets
Unable to Run Code on Specific workbook
Code line not calculating correctly
Late Binding to Outlook from Excel: Outlook modifies email body
Problem with code
setting an excel file to read-only
Forgotten Password
Changing color in palette
Workbooks within a Folder - B-Lists
VBA auto filter question
Transform xsl file to xml file programmatically
CXomparing Job Numbers
Need assist with setting cell values from an addin subroutine
Teaching VBA programming
Line numbers
Sum of value in cell range between 500,000 to 1,000,000
wildcards in tab. names
QueryTable OLE DB with Parameter
Activating Custom Menu
MACRO TO SELECT A PARTICULAR SHEET!
Clearing Form
VBA array - find largest element
Run-Time Error
Capturing deletion of a row
Re: Searching an Entire Workbook
Set Print Area
run time error 1004 naming a sheet
Problem with Dynamically Writing Event Procedure
Looping
Help with if statement
Move cursor down, skipping hidden rows
recording macro to paste a copied ws formula
how to use the divisibility condition in excel with 'if' statemen.
Button doesn't work
Whorksheet Calculate Event Q
Does Workbook need to be open to copy to..from vba
Type mismatch?
Summarising data
Error Handling with Web Queries
Declaring variables (Long, String, Integer) and interpretation spe
Between dates table lookup.
Check Boxes?
How can I default to Paste Special?
How do I make toggling shortcut keys for superscript and subscript?
PageBreak Problems
Excel XP: How to make a reference to a library persistent
Web Query to database
Points measurement problem
Running excel as an application
refresh application.caption
No zero in a cell
getting the sheet names present in a work book????
Can someone give me a simple macro to sort a column?
Make this paste_into_word code flexible to unknown office/word version >97?
VBA WorksheetFunction problem
Prevent Column adjustments?
Option buttons in Excel to perform formulas in a several Absolute.
Macro Secret Key Code/
How to use Subtotal in VBA
S Curves
How do I add a reference to an object library using VBA?
ADODB Recordset Function
HOW TO send data to another program and get back results in Excel?
How do i wrap text in a merged cell in excell?
Background task
Two Questions?
Filters on Data Validation
SaveAs and Hidden Workbooks
Checkbox - Center Horizontally and Vertically
I cannot use Assign macro in Excel. Could before but not now. A.
VB Code Remains In Memory
return used letters in a range function - an example
Web Query running in backg. -how to know when data retrieval compl
Opening 4 files with 1 button?
Simple Thing
How do I turn off macros when programmatically opening a workbook.
Access 2000: Print Database name in Report footer
analyzing poll data
public sub
VBA simple one..
Characters bad when exporting asp.net datagrid to excel
ActiveSheet.Paste error in XP
Code Repeats Itself And Goes To Wrong Focus
Solver
password userform
common functions:where to put them?
Dynamically Assign Objects to Form Objects.
VBA excel programming
Highlighting the active row
Count function for two specific items in vba
WorkSheet Present
SaveAs Concatenation
Validation List Box Locked
Compare Size of 2 files
Populate combobox
update independent column on pivot table
Getting data from sheet stored on LAN
Auto update function in VBA?
Need help similar to a histogram
Macro to combine cells
Newbie at mixing ADO and Excel
Can this be done
IF Functions for Text in Excel 2000
Sort More than 3 criteria
Listboxes on worksheets
Excel Problem
Bulk-Delete All Custom Commandbars
Re: Excel Problem
Returning true if a number fits between a range
Inconsistent error
Excel page breaks
automatic copy and paste from sheet to sheet in a workbook
Dynamic naming of worksheets
Use a variabel
"If Not.." crashes
When to use screenupdating?
Solver32.dll missing
Find first cell in column's used range
Copying ThisWorkBook Events
fatal error
Application.Match Type mismatch error
How to select range of cells
Trap a find error
get cell.address question
Cursor Movement vs. Range Reference
Delete "Cut" row on move...?
printing pictures in excel with VB
Calendar
Searching for text or numbers in textbox
Error Setting Excel's Application.Left Property
Are Excel Macros Adversely Affected by inserting an Object in a ce
Excel query object
protect embeded object
Writing a conditional formula to Search with number ranges
Listbox Selection
Wrong reference showing up as missing
Is it possible to validate date in Visual Basic Editor? If so how.
ComboBox properties---need to recognize comma's in numgers
How can I prevent users from deleting an Excel toolbar from a work
Need help with Treeview control ??
merging worksheets onto one
percent increase
Listing Sheets
date
MkDir and Save As
lock cells
How do I set up a macro using relative cell reference?
userform
Compile error?
Compile error?
Odd problem with charts... narrow!
Data Validation Range Question
Change Cell automaticaly
Collection methods
Programmatic addition of form elements relative to a cell
Personal XLA not appearing on Worksheet Menu bar after Excel Start
Update Links Popup
Check if form is open
Compiler Error
Importing to Excel from an Outlook Form
VLookup Recalculating Every Time - Help
Format
Protect certain cells
"Pick from list"
Excel 97 shared file
Switch() causes strange ADO result
trying to populate a variable from a combo box
Excel Export Script
how can i turn functions written in VBA into an addin?
XBRL in Excel 2003
Personal Macro Workbook
stuck on division
Bring forward conditional formatted characteristics
Copy worksheets without any code
How do I print hyperlinked files when selected from a check box?
Selecting Multiple Cells
User input formula variable
Debug VBA
Add Checkbox programatically to form
Copy data from excel into a web page.
List Formula Macro Needs Enhancement
macro ...if command, I suppose...
Get the properties from a closed file
Creating a recordset over a range
Unique lists
Excel Calculation Issue
Find the occurrences of the particular word and appear one time
Storing various data in .ID property
No duplicates
Stop on variable
How do i find the last entry in a column where every cell is not .
Excel taskbar
Formula
Delete row depending on size of Characters in cell
Business Budget - screen Printing
Filter between dates
budget template, screen printer
Code Module to Add In
Multiple firing of macro from ListBox
Combo Box
Please help
How to source data from multiple worksheets in a PivotTable?
VLOOKUP cannot find numeric values
Worksheets, Ranges & Unknowns
Delete LOCAL named ranges
Turning a Macro into an add-in for Excel?
running-total formulas written from one spreadsheet to another
excel macro inconsistency
printing selected sheets
Using Solver with VB6 Excel Object
How do I register Grid32.ocx
TODAY'S DATE PLUS "BUSINESS" DAYS
Running a macro on mulitple files
Subroutine works but can it be improved?
Save sht as text file - problem
Workbook_Open() will not run
Links using XLODBC.XLA not working after upgrade to 2003
using RANGE object in multiple-area range
Contents of an array
verifying data type
Error when running macro
How do I total data in a single column and then chart off of that
Can't assign a textbox to object
Can't assign a textbox to object
FINDING LAST CELL IN A CALCUALTION
Found Files
how can I open a password protected document through vb?
If Then Statement
Variable Manipulation
Adding tool tip to worksheet button
Advances one Record when I tab...
how do I subtract 2 date fields to get number of days elapsed?
Cell Hyperlink - text, screen tip & link from other cells
[Newbie question] Returning an array from a function
Syntax for Range Reference
Linking workbooks
password protect vba code
Calling a Private Sub
Form development question
Problem exporting as csv file
Querytable refreshing on a protected spreadsheet
Excel/Lotus Notes
Recorded Macro to Set page breaks generates error.
Macro
Pivot table with form elements
Mail Rounting, Need help quick!! I'm under the gun on this.
Code to Save HTML table as xls file on click
UserForm Value
Userform for data pull
Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend?
Summing
Excel Macro to edit and delete one character in a cell
#Name
UserInterfaceOnly on startup
How to create Excel, Access and dbf output files from DataSet usin
Inserting a function
Move text after delete
help on deleting several rows at once
Compile error: Can't find project or library
Setting chart series XValues in foreign language
sum by currency
DisplayAlerts = False fails
How can read object order by useing writing?
Array problem
Closing excel with a macro
"Clone" cell formats between sheets?
How to action on Open Sheet
Delaying until Recalcu code is done.
How do I export excel data to an html file?
Directory listing manipulation
Want Excel Hyperlinks to reuse browser window
Dynamic Arrays
Identifying the Active Fill Color
Problem copying a range to a different workbook
autofill same number to end of file
Populate 2-column ListBox with 2 non-contiguous columns
Copying a cell one at a time
Copy cells with certain info
Recognizing a whole number instead of a decimal
open password protected Excel doc
Selecting rows
help need on VBA code
User Tools in Excel 2002 vs Excel 2000
the sum of cells of many sheets
E-Mailing Execl via Outlook Express
VB code to make Excel open in a specific worksheet
Switch from Office 2000 to Office 2003 error
Importing from Outlook
Importing from Outlook
Updating records by status based on a formula.
Using one subform to control another subform
Unable to set the active cell from within a VBA procedure
Macro to append onto and then sort a pre-existing list
multipage tabs off?
reformat contact data
How do I hide a shell command called from VBA in Excel
Can't resolve external reference on Excel 2000
linking 3 rows into one
setting up multiple timekeepers with multiple rates by period?
find (exact match) ?
Create a Named Range in Excel with VBA
cell addresses selection for chart source
Dynamic ComboBox
Driving me nuts! Row Height, Cell Width
HELP - Have two lists and #1 needs #2's contents subtracted from it
Excel Code
Mail merge does not show leading zero in Zip Code
message property
Write the result of a formula only once then lock it
Reference to IE - but none found?
End Of File - For use in Formulas
Force standard chart size
worksheet function?
How can I compare a list of strings, allowing positive matching b.
Log File CleanUp
clearing memory /clipboard
set variable once
Help with Find
Auotomating "Sort" in Excel
Change Caption of Forms Command Button
LOOKING AT THE FIRST PART OF A CELL
numeric value
How To Pull Access Query into Excel (2003): Reposting
extracting certain text
Can I set up a worksheet as read only for one user
find last row of data
Sorting Excel object?
Convert Excel into a CSV file automatically
Instance of Wizard excel add-in
VB code in excell
Selection vs Objects
SIMULTANEOUSLY adding rows in two sheets
Get VSTO code to run on every launch of Excel
How to store additional attributes for a cell
Macro Needed To Find Product Cost In Another Sheet
Removing a link to another workbook
Seamlessly regroup values for multi-sheet calculations?
Determining Language Version of Excel
Re: Project still in "project explorer" window after file closed down!
Add Check Boxes to Many Cells
Test if application running?
Hide a sequence of rows
Excel Version in which file was created
how to average this?
How do i save as a textfile in a macro?
Conditional Product
lock cells after save
Path/File Access error: "VB3B.tmp
thumbnail
Array element
Activecell Offset
how to clear memory stored in the variables?
Update fields?
How to add more fill colors to Excel?
Simple Table
Variables not recognized
Works if I single step
hide columns based on header macro
Not filtering by date
Not filtering by date
Additions&Removals
Cannot set HorizontalAlignment Property of the Range Class
Can't find Macro code
How do I switch focus from a modeless user form back to the excel.
How do I insert a page break before each change in the cell conten
PivotTable Object - Unable to get the name property
Cell formatting question
VB code to open Print window
Can I run an external program?
Help Needed - VBA If statement!
Determining and presenting unique entries?
Need to save/write ranges to a workbook
Help Authoring and Excel Conversion
indirect addressing? a range of cells
Help Needed - VBA If statement!
looping through selected sheet tabs
Clearing ClipBoard in EXCEL
Help Needed - VBA If statement!
HELP WITH CHART - COMPLEX ONE
Delete Digital Certificates
Help Needed - VBA If statement!
Help Needed - VBA If statement!
Help Needed - VBA If statement!
Common Data in Add_In
can take a look at my code?
builtin dialog box and arguments
row height
Problem Dropping data in first Empty Cell and across the row
can a userform pass an argument?
Identify product not found
changing the currenc setting of a cell or range
make severaly workbooks 1
make severaly workbooks 1
Excel, VB.Net and shutdown
cannot find code
xlDialogs(xlDialogSaveAs)
Macro Help
I cant use englisch function names in a swedich version of excel
how to simplify this process?
Clearing Memory
all caps to lower case
Combine records from 2 tables whenever there are matching values .
How can I create a spreadsheet...
Unable to set NumberFormat property of the PivotField class
Unable to set NumberFormat property of the PivotField class
populating one list/combobox based on the results of another
Order Form Template
change tab color base on cell value
how to do the conditional formatting for this?
Open workbook object
Use VBA to copy a chart from the internet?
Re: Return a random letter
Going down until the data stops....
What's the Difference Q
Opening Excel from Access
Re: Processing non-contiguous row selections
Named Range to Array Oddity
RUN a macro based on a value selected in a drop down box in a shee
How to Rename a Blank Sheet that a macro Creates
Excluding cells in custom TREND function
Mirror a workbook
Combination of data out to two worksheets
I need to find a macro to find data cut and paste to another colu.
can anyone help me with this?? Thanks!
Books on "how to" program macros in Excel using VBA
Re: Find text numbers
Project two - Diffrence Sheet
Find text numbers
Help with code
probing the serial port for data
Fomat change
Problems with ADO from Excel
SaveAs Question
Save Workbook (Blist) as today's date
Multi-Column Listbox properties
Launch a VBA macro with opening a file
Using multiple worksheets to keep track of changed values?
Insert lines when x<> y
Module update
Wht is this Code not Working ?
Wildcard for numeric characters in filename?
fphover.class not displaying in Explorer 6.0 when XP SP2 is instal
How does one return a specific cell in a web query?
how to sort data this way??
How do I set up a Conditional Alarm to ring a bell when a conditi.
Copying Range from 1 sheet to next
convert dates stored as text to dates
How can I find the last time a custom function is called ?
Can Paste-Special-Values be VBA programmed?
Can "Home" key be VBA programmed?
Automatic Lookup/Fill-in
Macro to Copy Cells
UserForm with ListBox
How can I change size of the picture without changing chartobject?
How do I Format a cell to make 1=$3.00 per cell then total?
Insert word from dictionary
just broke up with girl friend we had puter together
How to check if an object has a certain property?
Disable Save and Save As
Selecting Menu Item by VBA Code
How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation
#NUM checking
How can I involve in Rotary member of International?
Command Button’s ‘back color’
Can't find "stop recording" toolbar to use relative references
Re: Change datalabel font size for all chartobjects in a row
Name Check Box in code
Add-ins and Reference library
Perplexed
Excel Copy and Paste into Outlook e-mail
Re: Text Box Format
Tell OS to refresh?
Userform Code
Importing text file
How to specify a range in VBA based on values in cells
How to increment number using vb script
Re: Select Case syntax
VBA VLOOKUP Question
Function to return a previous cell value
Excel crashes when using CreateEventProc towards CodeModule
how do you insert a drop down calendar in excel
Check Box
combo box
VBA Code issue
VBA Project Explorer
drop down menus and repeting
ThisWorkbook.Protect
Dynamic Ranges Q
Disappearing Cursor - please help
Excel Trend Calculation
change existing values
Input Date Error Message
Re: Need help with Word macro
Searching in Two Non-Continguous Columns
Create new excel worksheet
Create new excel work sheet by increment 2 on 3rd character
What does 'Set rng = Range("Database")' do?
Command Button Issue
Re: #Ref! Returned
seperate the character and number in formula
How locate connection information for web query?
Change .txt file to .xls
New Excel Add-In for Analysis Services
Beginner at VBA
How to work around arrays...
Find value, copy, compute, and more
Copying formulas in a Macro
Learning Visual Basic Books
Check Box Show Hide
Force recalc of formulas saved as text
If Neg Number in a cell
Auto Sum cell above a relevant reference cell
Determining a combo box by code
Where is the autosave function in Excel 2003?
I need to split a name / last name cell into two different cell.
VBA AddIn reference in Excel X for Mac
function to calculate area under curve
Copying data relevant to the position of a cell on another sheet
choosing files using an excel list...
Uniqe list
I need to split first & last name cell into two different cells. .
Reset Security Level with VBA?
UserForm_Initialize()
Performance problem with VB Macro in Excell XP
Workbook_Open
Newbie needs macro help please
Can VSTO handle a Picture click event in Excel?
Can I call my .Net functions from Excel Macros
For/Next using Thing
TypeLib Information Problem? Pass a Function's parameter names as string for parsing?
Problem Text Format
export chart - what controls exported chart width
Convert text with special characters
A loop to delete
ListBox Prroblem
Database connected Excel sheet on Web
Locating a value anywhere in a row and copying that row to new she
How to sort the data?
Can VBA be used to clear the recently used file list?
Re: printing a union of non-contiguous cells- help!
Re: printing a union of non-contiguous cells- help!
Design time events
Clipboard
Select Distinct Items in a Column
Re: Fill down formula programmically
Displaying form on startup?
Re: Visual Basic Help
Userform
Re: Return a random letter
Re: exporting to file (switching comma's and points)
RE: Auto Refreshing - values
Update function
Modifying Chart Series Attributes Insights (Color, Marker Type, Et
Weird Problem: Excel SaveAs--> document not saved
"Do not send fonts to distiller" work around found!!!
Updating Exclel imbedded in Word once for both documents
Re: how to sort data?
Database
Check for open workbooks
Run-time Error 40036 on ActiveSheet
Lost Visual Basic Project and Invalid File Format errors
VBA/VLOOKUP Error Message
Formatting a cell calculated by a VBA function
Workbook Open event does not fire
Putting Cell contents into a TextBox?
Too few parameters. Expected 1.
Find first cell in range and expand range -VBA
Checking for Duplicate Data in Worksheets
Create filename based on cell contents
List box multi
How I can to Use False in Vlookup?
Is there any way to reduce excel size which is 2.4 mb now?
de-activating OLEObject
using INDIRECT in array formulas
Data format issue for Graph
conditional formatting odd/even rows
list boxes
Saving Workbook with Variable
setup a range based on a variable
Need to write a program to open a filename...
Macro to update based on format? (Currency)
Copying and Pasting.
Clearing Option Buttons
Calculated Error Bars?
Excel Formatting with VBA
conditional counts across columns
Print merge an Excel document with three worksheets to WORD Docume
IRR
OfficeLinks in XLXP?
hyperlinks without screen tips
Template won't open as a .xls in Excel 2000
How to preserve state of View->Toolbars?
CheckBox in userform
Can VBA clear the Temporary Internet File folder?
Determine current default fill color
how do i freeze columns in excel 2000 ?
Error message when opening file
Summing top 8 marks + display
Setting colors for Controls
Grouped sorting
How can I do it??? (OnAction with CommandButton)
VBA Excel Autofilter Question
Open Event
Macro to run or not run a second Macro
VBA - Disappearing custom menu and custom toolbar
Call Not Working in Excel 97
ADO to get data form closed Excel
How to run a Macro depending on a result of a cell
Cannot move nonblank cells off the sheet
column insert error
Excel 2003
Find a value in the collumn and then in that row
Auto Refreshing: data retreival from webpage
Help Please
fORMULA IN aUTO FILTER
Enter VBA Code Password
vLookUp. Works Manually but not by code.
checkbox dilemma- need larger checkboxes
RTD Getting The Focus
use macro to append records to worksheet
Problems with ChDrive and ChDir
Checking for duplicates: VBA
Excluding sheet from group of selected sheets
printing the list of wroksheets in a workbook
Multiple "if" criteria
Adding ALL Digits in a Range
Quick name deletion line required
3 cells are named together - how refere to them in one chart reference field (a seriescollection(1) )
VAN et TRI sur excel (formule fi)
Remove Automation class
Deleting names with errors
Duplicating worksheet by VBA
Prompting 'Save As' in an Excel Macro
VBA Newbie: Help with Do Loop code
textbox.caption question
Read only notification
VBA - Syntax filename rangename for vlookup formula
how do i calculate a running total in a single cell in excel
Excel 2003 macro
Need help with Transpose paste special
Display Worksheet ASP page pop-up
Permutations
Follow a hyperlink
Hide selected worksheet tabs
open OQY file from http:// folder
Microsoft Excel 97 Developer's Kit
Some worksheet returns NULL for CodeName property. Why?
Auto-Replacing Blank Fields
Freezing sheet names
Work around for limit on entering array formulas?
Print Preview moves command buttons
In Excel, how can I store and append to a cell value as inputs ch.
Detect if a command bar is enabled in View->Toolbars
Needing ideas on how to do this
Problem sorting 2-D array
File Object in Excel VBA
Summing rows
macro to operate in protected cells
How query a disconnected ADO recordset - possible?
Combo Box - Hide Combo Box w/Check Box
Adding nodes to treeview
Is this possible?....
Mouse Over Graph, Capture Information on Click(Double Click)
Code to insert data from another workbook
Date ranges and advanced filter
How do solve window explorer error
Graph Data Range not fixed
Access security and excel external data
How to set up a formula that will give me both positive and neg. .
How do I use environment variables in Excel?
Find a variable
protected worksheet
protected worksheet
convert IP address to XXX.XXX.XXX.XXX
convert IP address to XXX.XXX.XXX.XXX
can I use autofilter with an equation
Excel SUMPRODUCT, but matching like COUNTIF
Edit Macro for GOTO Part No.
summing cells
selecting and deleting a row based on a cell value
Timing of automatic query refresh and macro pivot table refresh
Excel launches in a separate window
Two Problems
List Tool Bar
Unhide
Closing Graph9 from vba
Re: Not releasing workbook reference.
Open Dialog Box to return Selected File Path and Not Open it.
RefEdits and normal forms / forms in a DLL
Goto a control element
auto entry from one worksheet to another
Change graph's source data via macro
pivotcell
Date
Project Locked
Hiding rows
Select all cells NOT in a range
VBA to Save a file to a different format but keep original
Excel File Size
VbOk not responding
Quotation Template that gives options for each item
Shell Command : Extremely Frustrated
MS Query report
how to synch VBA Moduals between PC's
Simulating HTML frames inside a Excel application
Rookie q
Very special
Simple For-Loop gives 1004 error using variable to EntireRow.Delete
Transform macro
Running Macro in Excel
shell command running very slow
AutoFilter
Run-query error
Trying to eliminate multiple copies of the SAME code within a UserForm
DDE command for INSERTING ROW above a below a specifed row no.
How do I specify an existing procedure to run from a control adde.
Saving file with text and csv
Interaction between worksheets
For/Next with an If statement embedded
Re: copy / paste formula to last row
Re: protect worksheet against cutting
Excel 2003 Menu Bar and ToolBars
Loop down rows to first numerical character
Show or hide rows when text is bold or italic
Shell to different app then open file within
entering data on another sheet
Combobox change property
Using SeriesCollection.Extend for a specific Chart Data Series
how do I reuse c# code in excel VBA module?
Worksheet.activate question
Where can I find the preset color index numbers for Excel?
sort problem
Weirdness
Can Excel tell me how many rows are populated via a functions?
How to add a command button and on-click within vba
Code help
determine if a file is an excel file
Validate a date
Can I issue a File, Send To, Mail Recipient command in a macro?
Using ADO to access another workbook
Changing format commanbar
listbox list
Hiding Rows
Using formula problem
Opening a template .xls with VBA code
Challenging project for you!
Export specific cell data to txt delimited file
Programmatically manage pivot table.
Saving User Selections made on a Form
import text file
Filtering Values using a Combobox
Can't select macro button after other button is pressed
Query SQL Server
Solver - won't run Macro in Step Thru - help
command button
Moving data from multiple columns
optionbutton takes two clicks to change value
Re: protect worksheet against cutting
vlookup in VBA
If Statement
Export asp to excel Format number
Weight Watchers Point Calculator script
PivotItems.Count is 0 when items are visible on the sheet
Convert text into Excel
462 The remote server machine does not exist?
Addin opened but not loaded
ChDir - Specify Folder
why my date shows up as 12:00:00 AM?
Code Problem
UNSAVED: VBAProject
Creating a counter for printing
Challenging long ARRAY formula needed - Can this be done?
list the sheets in a workbook
UserForm including TextBox with date (UK format)
[Interops] OutlineLevel and Hidden property
Temporarily override sheet protection
Open Workbook in current directory
Start Excel and run a macro on a given filename?
The Select Objects button
Spreadsheat object
rounding up for number not for decimal
Help with Similar MOD Function Please
Simple programming help for newbie
Cell Colour
How to auto response the dialog
automated data entry to a s/s
delete repeated rows
using MS fingerprint reader with Excel
Second search within primary "Find" gives error ?
Using Excel for organising a seminar
Newbie question - regarding function parameters
Macro Similar to Mail Merge help/question
Findcontrol for submenu item?
Test to see if a cell is within a range
Copying forumla into another Cell.
Overwriting existing data in an Excel worksheet using ADO.Net
manipulating Excel checkbox from VB based exe
displaying ranges
how do i find a Excel programer for hire in my area?
(Today) function can you make it stick
Overwriting existing data in an Excel worksheet using ADO.Net
List Box
Protect Worksheet
Workbooks and worksheets.
convert Excel to "Text Only"
voice recording option on excel
Double Listbox
how can I do this without actually putting into cells
Excel-Finance book coauthor
Getting subsets of data
spinbutton?
Buy Programming Books
Excell files showing "Read Only" access denied
re-order worksheets by sheet name
Compare cells using real time streaming data
Userform CheckBoxes
Help with Search and Replace
Add-In Shortcut key
cell movement
Checking & installing references as part of on_open
VBA Formula Syntax
Macintosh and VB Scripts
RE-End of Page
import files
Excel crashes on exit
Accessing external test equipment using Excel
Reading content of array formula
Export CSV; first three rows contain record map
Check Boxes and Conditional Formatting
Conditional formatting
Changing the default printer...
Stepping through cells
Event 1001 & 1004
I need a spreadsheet to plan a for sale real estate develpment
I need a spreadsheet to plan a for sale real estate develpment
How to force current directory
Check for empty cells in Print Area?
Workbook Open event
End of Page
Superposition error in Dinamics Tables
conditional formatting - for Expert and Gurus
message box
Web Queries Truncated
Saving Workbook
range * constant
Need help using VBA in excel.
Charts not showing or printing.
vlookup problem
relative address in validate
How to change windows.arrange from xlTiled to xlHorizontal and back in one procedure
Another Quit problem
Leave the Cell unchanged
waiting for click on the button
Invalid Qualifier???
Change text to date
Saving Problem Excel 2000 with VBA code
copying cells into different rows in different worksheets
Saving a worksheet without empty rows
VBA Hyperlink calling ASP page
Secure excel spreadsheet
SQL Query
help - how to move cells into an array using criteria
Duplicating a cell (EXACTLY)
resequence worksheet index after deletion of worksheet
Pivot Table Field's Item Listbox
Programatically Creating a Hyperlink Using VB.Net ?
Check if name exist in a list
yyyymmdd date format
Filling Blank Cells
Display range of cells
Workbook_BeforePrint > performs twice ?
Union of Ranges Failed
Problem with VBA code trying to query and access database
vlookup function
Trip to Disney