Excel Programming [Archive] - Page 164

Assigning Style to ActiveCell which is part of Merged Cells
How do I return the name of a Range?
Re: running Word/Excel in silent mode with Office XP PIAs
Retrieving User of Last Save
Trouble w/ ActiveX Controls (no userform) Excel 2002.
Referencing funciton to workbook
compare names and delete duplicates
Numeric formats
custom icons
Deleting specific rows
Range to combobox- forget the blanks?
Help on Run-time error after "Save As"
insert row below activecell
Recording Macro -- find max value --- create chart
Insert Rows
Unable to read file
Range name box
Use of Selection.Find & ActiveCell
3D Range Parsing
Conditional Formatting
Workdays
=proper
vlookup
How to program multi-select list box?
Nesting a formula in a macro
Macros not running after Upgrade to Excel 2002
Preventing users from deleting worksheets
Disabling Macros After A Save To A Different Filename
Re: Help: HTML Table not displaying full text
Alias for a Pivot Table Column
Accessing Pivot Table's Data in VBA
Accessing Pivot Table's Data
Upgraded to Excel 2002
Importing and Finding Matching data
Stepping through code gives different results than running it!
"Invalid internet address" during ADO
How to pagebreak
rounding up
highlighting only filtered rows
How To:
Code advice please...
Auton open
Re: Ole automation with Excel 10 from Vb.net
Import to Access
Create Printing Macro
csv to xls date US/UK format
How Do I Automatically Detect Cell Changes In Excel
win api function
Toggle Macro with KeyStrokes
"Object disconnected from clients"??
Expenses claim form
How can I insert a space before the last character in a range of cells
Unlikely Error Message
Function Vs. Sub
.ListFillRange as Variable ? in Listbox
Merging Data
deleting duplicates
Deleting Rows
Work around Calculated Field limitation
Row insertion macro
help
Distinct Data In Combo Box
Access menu item from VBS
Newby question: use a worksheet but not show?
Function
compare value in cell and copy cells A through S of same row to a new worksheet
Declaring variables
Autofilter
Re: DEclaring variables
Login ID over a network
exporting spreadsheet to GIF or JPEG?
Trimming Excess Data
Macro to delete duplicate data in row
Detrmine which command button was clicked
determine cell is part of pivot item or pivot field
One more question...
Where am I going wrong
Colours in Drop Down Menus
a script/macro to copy a block of cells next to specified cells
heres one for ya..
How to calculate a page number
VBA: Writing an array function (like MMult)
Chart question
Worksheet Password Recovery
DEclaring variables
Worksheet_Change function
Formula property of a series in a chart
Sumproduct with Or
calling modules
Function LoadResPicture ?!?
Time Between 2 intervals
Launching Excel from a web page
Changing a scrollbar value to 0
How to change shortkey in a complementary macro ?
Copying multiple tables to single worksheet
Summary Help
VBA code to show a save as dialog does not work
Accessing PowerPoint datalabels from excel VBA
Copying and Pasting Formula
Excel printing
Can't access to a Workbook
Select Columns based on cell value
Import module with vba
VBA shortcut
Increasing the Data Refresh rate for Web Queries for Excel 2002
Catch-22 with Error 59
"Jake Marx" - Thanks!
Highlight Cell Macro
Macro on a data validation list
changing focus
Help with ADO and VBE
button focus
VBA or MACRO to prevent someone from printing the contents of an Excel worksheet
userform1.activecontrol.name
workbook creates desktop shortcut...HELP
Advice for a newbie
Macro to add a number of rows after being prompted
Click event on cell triggers a macro
how to create a user form programmatically
Add-In Manager
Visual Basic
Importing data from an Excel file on a web server using ADO/VBA
Dont intersect
Not very printer friendly
Disable the name box
access violation 0cx0000005 in vba excel
Help with Macro error
Copy and Paste Between Workbooks
blank userform
Referenced Workbooks
Arrays
Macro to delete duplicate data
Combo Box Inside a Form
WorksheetFunction
DDE Formula To Look At Cell Info
Range.Copy and error 1004
Hide Worksheet
Finding and Deleting last row
List of Macros
macro cuts off decimals!?
Duplicate Project in VBE
Microsoft excel is waiting for other program to finish OLE Action
Print Area Resizing
Excel locks up
Delete a module in VBA?
Microsoft Office 2003 issues with Visual Basic
Color in Cell
ActiveWorkbook.Close
Customized symbol ?!?
Path and Acrobat ActiveX
Hiding my macros
Sorry, But Getting Desperate
Intrastat reporting
Excel / VBA / SQL DB
combobox
How can I Merge Worksheets from different Excel Files into one Worksheet?
Inserting Rows
Early vs Late Binding - Word
Excel Addin
Value of Combo Box
accessing text import wizard in VB
Plz help me ...
Is entire row empty?
Save sheet as .TXT out of Workbook
SendMail File linked error
IF(ISERROR(MATCH - need value where match was found
Question Using SaveAs Method
ODBC error linking to Sybase database
#VALUE!
Simple yet.....
DateAdd function
Testing for a currency ..
copy-paste in a userform
ADO Issue
Re: Cell range selection after calculation
using a range with isnumber property
Need help saving as tab-delimited file
xlDialogSendmail (bug?)
Execute a batch file from inside Excel
Button macro from filtered data
Simple VB question
Is it possible write a self-defined function in excel that connect to SQL server to get data?
Application.Path in Excel 2k and 2002
I N D E X menu via Tabs Popup
Calculate cell reference
Excel Textbox limitations
Application.Path
duplicating macros
Opening workbooks from UDFs
Range in FindMethod?
Grouping Data
Detail on formula language bug
Set a Range to all of the first row
Pop Up and Audio alarm running as background tasks.
Copy & Paste
Filter specific information and format
Macro to change a number to text
Loops to delete rows
putInClipboard errors on mac
Can I launch the Calendar Control from a Comand Button
send attachment using file path from hyperlink
How to select a row to delete
Excel Language bug formulas
ADO and text file
data range box
Conditional Formatting - number of decimal places
VBA in excel to update Powerpoint
macro works on F8 but not auto
VBE Issue
Find & Format Using Macro
Conceal functions and subroutines?
CopyPicture
Custom menus
Combo Box
AutoSizing TextBox
Cut and Paste Macro
VBA SUM
Automatic SaveAs Worksheet Name
Need interpretation
Bar Chart
Help with Data Extract
ByRef question
Findformat
Can anyone help, me and my bud here in school?
Summing last row in list
VB Round( ) function
compiling VBA in Excel2000
Highlighting last available cell in bold
disable pivottable refresh message
Re: data validation help neded asap
data validation help neded asap
Application.OnTime and Visual C++
Appending data from one sheet to another.
default number format in pivot table
customize right click
finding variables in a column
automatically create another spreadsheet from template
Macro
Entering mixed font strings
Help Im crap at VBA
Please do my homework for me
Delete Worksheet
I can't see a Workbook in WorkBooks.Count
ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]"
find method?
How I can determine a base class of a procedure's incoming parameter?
Make a graph with for cycle
Userform - dispaly graph as image
Checkbox
Help -- Loop or Array? How to identify?
Form buttons and macros
I need Help in a form
Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools
Shareware
Implied Option Explicit in XP??
Generate numbers for labels
Excel Macros help
Setting a range using VBA
Comment Boxes
Combo Box Help?
Getting specific cell to be in upper left ?
ShortcutKey assigning in VBA
Urgent: VBA Command Button Caption Problem
Autonumbering Formula for Columns
Why is it that RTD is only applicable for Excel 2002 and 2003 and not Excel 2000
Macro adds 1 to Cell in excel
How do I Add an Addin to Toolbar
File Names
nonduplicative merge
FIND Command
Hiding columns in VB
using forms and modules in multiple workbooks
VBE Issue
Instr function problem
record of records count for display...
Count of workbooks in a directory
First blank row in a column
Sum visible rows with text and numbers
Filter Refresh
Run-time 1004 error on range select
Macro shortcut from XLA
Drop down menu
Formatting on more than 3 conditions
How to use Excel formulas in VBA
Getting rid of warning messages
subfolder Loop? But, only one....
locating charts
UserForm help
help with database connection - urgent
LinEst embedded in VBA Function
Can a workbook be 'Tagged' as follows:?
Finding last non-empty column in row...
Macro to paste to other sheet
VB Script Help
parsing field
DDE and VBA
Limit on Number of Lines of VBA Code?
Check if (part of) a row is blank.
counting
Problems with event handlers
ADO
VBA Code- Row Insertion
vba - check if cell is empty
Changing betwen workbooks
Easy way to edit Name Range formulas
ScreenUpdating not effective
Command Button Code Stream lining
Assigning VBA code to a Toolbar
Adding + 1 on each click.
Help Retrieving filename without .xls attached
test if a control has or doesnt have focus?
Macro to change a number to text
Re: Macro to change a number to text
Handling CSV Files
Assessing File's Properties
Query Results
Find and blank cell then Do this.....
Calling a module function from a class method
Add-ins configuration and startup
Count Cells
Macro Help. Please read...
Code for Opening a Closed Workbook
Shared workbook inactivity warning
DataList or DataGrid link to Recordset or External Data
Excel VBA to VB
Picture in the cells
Rescue Me
Annoying hidden names
VBE Issue
dynamic average for cells
Unauthorised Use Of Macro
Maximising Application
Export to Excel
Forms Display
Macro for copying entire raw
How do I do a HTTPRequest "get"?
shortcut key not not running macro's all of a sudden
Using .NET in Excel 2000
how is use worksheet function mina( ) in macro?
how to fill gaps in Current Region?
Forms and Modules
USERFORM in Excel2000
Out of Memory Error
Out of Memory error
Creating Object Variables - and passing them as arguements
newbie - how to save macro for use on another machine
Saving And Checking
Encryption to change contents of a cell
Call Object_Exit : Type mismatch
Countif to use like sumif
New sheet from the cell contents
Macro to go a WEB site and enter a password
PivotTable, Pivotfield selective invisible, too slow
Update Inventory
Displaying a Message and a Beep
Help: foreign key reference in Excel
How can I avoid excel saving xla combo data?
Excel automation - formula
Excel 2000 - Which VBA project is ActiveProject?
Select all the unlocked cells on a worksheet
Looking for 2 values in a data table? Please HELP!!!
Holy Macro!
Code
Function
Create macro for formulas
Function
Display selected rows and columns in a pop-up window.
Speed Issues again
Copy with criteria
Validation question
Environ()- help
Checkboxes
Repost:replacing data on a non focused worksheet with calculated data from the same sheet
Macro for forms function
How to get rid of string which contain a substring like 'PO BOX'.
Max Size???
Change Excel Menu
Fill Array from a CSV File
Taking focus off a Control Checkbox
Using a "Data Analysis" add-in function in a macro
Total No of Columns in Worksheet
Cut and paste cells
Find the smallest number in a column and change it to red
OfficeXP PIA compatibility
Can you place a combo box in a custom toolbar?
Function Problem.... Return Value
Combo Box
Select rows contain Xin Column Y
Excel XP macro problem
How to validate in code the contents of a cell?
worksheetFunction isblank
Re: Macros and Outlook?
Userform Image help
Greying out(disabling) textbox from being typed in
bring up dialog box from command button?
How to 'click OK button' automatically in excel
WindowStyle not working in shell command
Closing a workbook by a button only
arrays
Median of an Array
Command buttons
Sum cost column based on date column and vlookup cost
Note Code Help
Re: Texbox values based on Combobox Value(more detail)
Editable Excel Spreadsheet Online?
Using Outlook98 with Excel97
Trim string vII
Access Recordset with Built-In Function
Export Personal Macros
VBA
Truncate last five characters
Chip Pearson
Disable Macro at open by an external macro
Good guide for Excel/Query/SQL
moving to CLIPBOARD
Printing an error report
Insert comment command
Specify date range
Auto-entering the start and end of a month
Data ranges for Graphs & pivot tables in macros
help with excel macros getting daily averages from 10 minute data
Excel Menu Dissapeared
"delete" key activates Sub Worksheet_Change
formula help please
data problem
Select All and copy and paste
Avoiding Run-Time errors when sending emails from Excel
".printform"
recalulating when hiding rows
Splash Screen
saving excel workbooks
Re: Select a range of columns based on active cell
macros
Rogue vertical pagebreak
Convert row data to Column data...
Re: Use VBE Sheet names in code
automatic notify
If statement with multiple conditions
Replace sheet formulas with value
Concat + dates
Sum Calculation
MaxRows 65536 in a sheet - A Code Snippet
vba array question
Copying custom views from one worksheet to another
I'm new to excel and need help
Refererence to a value in a cell
Save As - Multiple Sheets fails to save as text file
Right Hand Column on Screen
Sorting by highlighted cells
Newby question: how to add icons to message boxes?
Possible to assign an array to a SeriesCollection
Excel menu programmed in .Net through PIA
Offset Problem
Opposite of Auto_Open
Format + Data
Zoom Not Resizing
Adding/removing rows in Excel
Window Errors
Remove Cut & Paste Options
Save "Range-Value" to variable?
Open Access
Add Formatting Code in Macro
bad file name
Open Workbook from VBA
Use macro code from external xls file
Books
Date...
Stating ranges in formulae
macro buttons
Vlook accuracy
Automatic Macro Start
Range Class falure
EXCEL LINKS
how to run macro of closed excel workbook using VBA
Hiding/Protecting vb code in excel
Excel-SQL Connect
how to add 2 ranges
Macro to "Stop Playing" wave files
VB how to connect two sub's
legend display in a graph in excel
caption sensitivity
print with data
Thanks Trevor Shuttleworth
Display a Message box while opening a XLS file
How to display a msg box while opening a sheet
Excel custom plots and custom trend lines
Can't update the data from internet while running macro
Sheet Protection Oddity
Maximum file size
Excel Scheduling Calendar
impossible to change the activecell???
importing a module
Pivot Table - Multiple Pivot Field Selection
Using IF Formula
Microsoft Excel 97 Reinstall Question
Time Lag
VB Code that will copy color coded cells to an invoice when activated
Add control to the Chart menu of "Chart Menu Bar" commandbar
Question about ).End(xlToRight)
Texbox values based on Combobox Value(more detail)
Combo box controlling visibility
3 textbox values based on value in ComboBox1
Combo box match required
userform image from picture in worksheet
French Password Encoding - cant open workbook!
"Sheet" versus "Worksheet"
Error in using "Frequency" function in VBA code
Labels in a user form
Using Macro to convert > 240 to PRN
auto close while MsgBox is open
Save file to Web Server from Workbook on Web Page
Having data populate text boxes based on Combobox Value
A Thank You note to Pio Sjoblom
CurrentRegion Failure. Please help!
Search and replace 9000 times?
SQL queries with Excel in VBA to populate a spreadsheet
Sending Emails according to sheet name
Is range a valid address?
Are you sure popup box
Combobox populating based on Option Button
Formulas with Counters
Insert comment command
Determining Office Version
Devious multiplying Forms DropDowns
backing up file in directory
Transfer Range to Array
excel 97: if then and for next loops help
send file by e-mail
Changing font of part of text in a cell
Move a drop down via VBA?
Excel - huge file sizes
Scrollbar settings in a UserForm
repeat post
GetOpenFilename w/default starting directory
Re: Excel 2000 math question, repost
Debug Step vs Run Mode
Closing Wookbook with items in clipboard
Auto Numbering
Deleting Worksheet - No Confirmations ?
If Target="" error
Looping a solver
Printing Question?
code in VBAProject will not run
Excel programming problem
Password to access a worksheet
Delete zeros in light yellow cells
How to Close Telnet Session using VBA
additon of values automatically
Launch a Sub Worksheet_Change Event from inside a macro
C# - Excel Hangs When Opening Workbook
C# - Excel Hangs When Opening Workbook
split a cash amount into two separate cash amounts
Formula with quotes and ampersand
Columnwidth of a merged cell
Simple use of Len?
Controlling Word template from Excel
Automatically including the Form and Code in all the user file
Reference last entered value in a column
Defining Range Question?
Excel - Web Save Problem
Select Text in Text Box
Sending array data to Word with DDEPoke
Saving files with names from ranges
xlfTextref
Shortcut for the "Custom AutoFilter" window.
find sheet from list.
overview of postfix vb variable notation
toolbar macro for esp. worksheet
Re: Move selection after Enter
Circular reference and Naming sheet
Creating something like a file manager in Explorer with Excel Dara
Application Problem
Why Excel 2002 crashes on simplest Workbook_Open events?
Worksheet_SelectionChange stops working
impossible syntax??
Is this done within Excel
proteger celula
Counting a colour that is Conditionally Formatted
Can´t Convert Formulas to Values with Deactivate event
Can't insert form objects
Go to the Last Row for Counting Purposes
2 Copy Sheet ?'s
Confused on MS Products to Create COM addin
Using Basic Excel Functions
Launching a DOS box from VBA
Re: Excel Com Automation
Excel to PDF
How to Delete a VBAProject
Re: Sheet names in VBE
how to step thru only one subfolder of a folder to find like files
Protect Macro Coding
Color Rows Automatically
Updating Infos
link to Perl/Java
Disounts Help Please
Search, find, copy from sheet1 and paste into sheet2
onditional formatting
printing window pops up when Visible field is false
Precedents Property
Read List1 and write List2
Basic Offset Function Usage
VB code
testing cell value
email OLE objects
How to make toolbar buttons larger?
Excel's database features
>_< investigating the programing for 'combined cells' >_<
Help with Time formula
Creating an Excel Database!
truncate data on cell ?
range("myrng"), names("myrng").RefersToRange??
Call up a Windows Message from Excel
Protecting VBA Code
Whats wrong with this VBA statement -ActiveCell.FormulaR1C1...?
Switching Selections
VB code for disabling
Editing Comments
using Cells.Find between 2 sheets
How to stop Excel help auto tile
Using variable to call worksheets
MACRO OR VBA CODE TO PREVENT USERS FROM PRINTING THE CONTENTS OF A WORKSHEET?
Trace Precedents
Manipulate all DropDowns on a Worksheet
Re: Identify Forms DropDown as it is triggered
Connection issues
Re: xlfArgument?
Help with data sorting - macro?
Code for a progress dialog??
intercepting password routines
Referencing Procedure in Personal.xls
Dynamic Selection of Pivottable Drop Down Items
Excel VBA Question
Splitting Rows
importing mulitple files
COMBINAISON
Getting Column width using macro..
Re: Excel binary file format
After OpenText all pastes from external apps use format from OpenText
Alternate row coloring
check range for certain value
code librarian
Enter key text symbol
VBA: using ignoreblank property
Excel 2000 and Memory
Mixed variable problem
size of module
Send array data from Excel macor to Word Doc using DDEPoke
Name of Event for Sheet
Solver won't work in macro, Excel 2002 SP1
How to access ACCESS from Excel!
Listbox--moving items up or down
Re: Get a part of a filename
Re: help with macros for getting daily averages from 10 minute increment data - MS2000
Is it Possible??
cell, vlookup, same values
Re: help with macros for getting daily averages from 10 minute increment data - MS2000
Thanks
Locked Sheet
How many rows fit a page
piggyback cell from formula function
Macro Help Please
Counting checkboxes with a true value
open workbook by VBA
Double Subtotal Problem {Excel 2000}
Sum formula
Calendar Control
save on exit message box
save on exit message box
Dynamic charts with VBA & graphics?
Selecting File and FilePath
calling an external vbs file on the worksheet close operation
reference vlookup cell
Pivots using other pivots and dynamic query problem
Re: Insert rows on multiple sheets
highlighting row
Input Box Drop-Down List
Can't run workbook with a macro from an 'at' command
is it possible for an html/asp page to access Excel directly
Screen Area
Unable to get the NormDist of the Worksheet Function
Automatic Macros
Funny macros
Switching between worksheets
Replace
linking text box with seperate combo box list
How to read data from xls files?
Generate .txt file from 2 cols of data
Looping question
finding macro containing excel files
combination box to cell
File Attributes / Save As New File Name
Pivot Table Copy Paste
Code mod to add name
settings and resettings
Automating a date field to change on certain action
Pivot Table Strange behaviour
Hiding macro
Re: Combo Grief
Select from table and listbox
Excel programming
Looping Question?
formatting text in TextBox in UserForm
treeview drag drop
Hyper-Threading Technology for XP with Excel 2000
annoying bell when trapping errors
Date format when using combo box
Sort by Manager
Compile Error: Next Without for
Setting Pivot Table Page Field Names using VBA
Setting Pivot Table Page Field Names using VBA
Linking drop down lists
cells protection
sending one sheet by e-mail
Modules and Forms II
creating Shapes
Deleting Cell Name from Macro
Macro assistance required please
MZTools install help
open workbook problem
Running a Excel Macro from Windows Scheduler
extracting unique values with a formula or with vba
closing an excel worksheet inside vb .net
Reading from file
MsgBox Useage
find & replace help
Putting a Border On a Partial Row
Cross Referance
Excel Query and Cell Formats
MSVBVM60.dll HELP!!
Here's a good challenge for someone to work on
Combo Box question regarding range
Calculating a textbox on a userform
Do you know how to create a new sheet in a file by macro?
How can I send data from excel thru smtp
Inserting # of rows depending on value in Column
Inserting Object in Excel Footer
distribution curve
Non-contiguous Range limit?
Re: REPOST: Software recommendation (Recording software)
Range Names
DATA LINKING MACRO !
Bad DLL Calling Convention (Error 49)
Specific question
Can I prevent users selecting multiple cells?
Security Level wont change...
Serious design problem
Data management for csv file
transpose: long column -> many rows
I would like help on my function
After Workbook closes all my combo boxes do not retain dropdown list.
protecting a csv file
Open Method of workbooks class failed
Re: Autoexecute Macros
Retrieving URL
Re: Range Names
SQL against AS400
Pasting to new worksheet with formats
something like autofilter?
replace a number with a string from database
Rotated Text and Line Spacing
Non-Functioning Scrollbar in Excel User Form
Cannot install MSOffice XP SP1
working with positive and neg numbers
Delete/Collapse Rows Not Selected
Non Working Cells after command button
Formula Referencing Problem
Adobe PDF Writer error
Highlight the bad stuff help!!
cell value
msoBarNoCustomize
Problem with VBA Help
"Proper" string function
Color Coded Cells
Get rid of deleted macros in Excel
adding sheets together
Combo Grief
Populating combo boxes
how get rid of upper left green triangles?
Tracing method calls
VBA Autofilter Criteria
Class Question
Can I set a spreadsheet so that when it is opened, a particular toolbar is loaded.
Need to modify one small peice of code...
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc
Re: how get cell value from different worksheet?
How can I find Duplicate Cells or Rows
how get cell value from different worksheet?
Network error
deleting workbook names in excel
If formula question
Duplicate entries
Modify cell from function
Re: Help with "if" statement formula
Any automation calls gets hung when the Excel workbook has an active cell.
URGENT - Need date format for SaveAs code
Re: Help with "if" statement formula
Patch Panel Matrix
Copy button images
Excel 97
Date format when opening a .CSV file programmatically
automatic macro execution
HELP relative ref command is gone
Restricting Menus
Hyperlink --- misswritten....
Irregular areas of numbers
Branching Macro
Excel - SQLREQUEST - #N/A
Find a String
value interpretation
lookup and vlookup
VBA - VLOOKUP Sub
VBA code to automatically close file
What have I got wrong? (Macro),,,
how to break passwords
Using subfunction in a function
copying rows one at a time to another sheet ones a criteria has been forfilled
Is there a way to turn events on or off?
Hiding macro execution
Modules and Forms
loop problem
Different colors for combo items
VBA Report How?
excel 97 HELP
Creating a SHORTCUT to a file in XLSTART
Selecting a random number from a set criteria by clicking a button
code to find dates
MACRO TO LINK DATA !
inserting sub rutines
Combobox Visibility Problems
Date Formats
Listing the contents of a directory in a spreadsheet
Help me please...
Re: Using VBA to rename Pivot Table Query
are these groups monitored by MS
Edit/Find
Hidding rows with 0 as the value
make button - assign to cell
EXCEL automation ACCESS VIOLATION vb
Possible to automate Powerpoint from within Excel of Visual Basic?
Using worksheetfunction from macro?
Using Sub-procedures w/in a function
Finding max value
Copying Formula's
CopyFromRecordset - Is there a way to filter data that's copied?
copying selected cells to another sheet
Workbook Protection
Print Preview Causes Crash
Tom Ogilvy - Request for follow-up on previous help offered
Can I make some thing happen if I get a "reminder"
Count Records & Display MsgBox
Drop Down box displays only first list item
Reading an Excel file after upload
Multiple joins in an Excel Query
V-Look Probrem
MsgBox Popup in Excel
Hyperlink written to worksheet produces error
PivotTable columns not going Invisible
populating multicolumn listbox with an array instead of...
0 "0" ""
Automate the Userform option
macro usage in Excel through a VPN
Design Q: XL XP, 97 and multiple users submitting data over intranet
Transposing one column into three
Re: Open text files as Worksheets in a workbook
Newbie : Find / Find Next
Advanced filter
Dynamic Filename From Macro
How can I get into VBA for a custom toolbar - Excel 97
assign paste to "cntrl b"
Auto Expand Combo Box
Dynamic Macro Input
Limiting Data Imported from Access to Excel
import email from Outlook
PivotTable question
Determining new category number
Excel ignores VBA commands
YIELD Calulations
Cycling through worksheets
Re: Problem with SheetCalculate Event
Data Refresh Errors
Locking Visual Basic Cell References
Processing a UserForm from an AddIn
merging excel program with tdc finance program
Worksheet_Change
No match on Advanced Filter -- how to detect?
RE: Resetting Screen to Full
Minimizing application from VBA
RE: Resetting Screen to Full
User Form Initialization
changing directories
Page Tabs
IsInArray function speed
Chart & ms Query issue
Help Stop Resizing Excel!
Re: Resetting Screen to Full
Re: Hidden Columns
Re: Resetting Screen to Full
Re: Hidden Columns
Launch an external telnet application
Re: Remind me to set Error Trapping to Break on Unhandled Errors
Help with Select Case or Best Method
A question about Nothing
Calendar Control 10.0
Why, when I create workbook-level name does it jump it to Sheet-level ?
Protect workbook for Excel 2002 and Excel 97
Why is my clipboard empty?
Code to search the Internet?
Excel function wizard categories
Exposing Class Module from VBA Excel 97 SR-2
How to update Access Table with Excell Data
automation error -2147467259
replacing data on a non focused worksheet with calculated data from the same sheet
Using the Microsoft Spreadsheet Control as ActiveX
430 Class does not support automation
Units for Application.Height?
SaveCopyAs - Userform disappears
Check For Open Workbook by another User
Control ComboBoxes & Worksheet Protection
simple count or sum function??
PivotTable and connection string
formatting results from mysql query
libXLL now available for .NET
help to get output from message to the current cell
Answers please to my query
Total by Selection by Column, Help Please.
Excel solver addin.
VBA: rename a variable
Linking Text boxes on worksheets???
How copy format, font, color and border without copy/paste?
external data with a password (take 2)
16384 bug
Form lists influencing other lists
commandbuttons properties
Formula for Subtotaling
Prioritised listbox
Macro run order
HTML TAGS that format Data for import into Excel
how do i ignore cells with font color?
Check to see if cell value exists
How do I open an Excel file in the Web components spreadsheet control?
Macros
VBA Date Function formatting
content coloring
Autorun macro on opening spreadsheet
Textbox on excel sheet do not update with VBA
Horizontal aligning of more than 1 excel sheets
countif (problem: text, number)
Getting started with a User Form
Validate Alphanumeric
VBA code Help needed
Export extension
VBA Syntax Question?
Sorting a date range of data
USer Defined Function
Crash in excel.exe
Colour cells with dupilate numbers
group cells.......
Excel Versions
formatting headers
How to cycle through pivot table column labels?
Help in classific a group of numbers
automated import of csv files into excel
two identical scripts, one with problem, the other with NO?!
How to package macro/VBA for commercial use?
How to package macro/VBA for commercial use?
Request password during Protect macro
Using VBA to rename Pivot Table Query
Adding events to newly add Menu
Make a cell into a Macro button
Need help with advanced filter
How to display a message box
simple question workbook size
Keep display steady while macro runs
Macro doesn't start up
Macro doesn't start up
Alternative Text for shapes
Excel Macro Program assistance required
Setting up Reference Library using VBA
How do I make a button to PasteSpecial Values only.
Messagebox: Alert user Worksheet is Unprotected
Opening Excel Workbook from Word using VBA - Always Read Only
Re: PasteSpecial problem
PivotTable and connection string
RE: tracking user activity on worksheet
Enter a constant into Ten Workbooks
Tab backwards
Custom dialog box on protected sheet
Edit table to have more of a DB structure
Code to check for active worksheet
formatting headers
change a cell formula
Password set/clear macros - help!
Passing ARGUMENTS between event procedures of a USERFORM
Highlighting locked or unlocked rows, Searching cells
Chart.Export throws COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC.
How to merge excel using vba
Modal User Form
extracting info the best way
Excel COM Addin
size of file