Excel Programming [Archive] - Page 125

Copy pasting a range in to a single column
VBA 2003 cut/copy | paste values only
Form Date picker
disable F1 after F2
Count between Hi and Low
VBA NumberFormat
How do I use a password to protect an Excel file from peeping eyes?
Extra Quote Mark
about xll
Permuting compound words - With or Without SPACES
possible until 5461
Overflow error
ADO method for getting highest ID #
Change negative sign from end of number to the beginning of the number.
Immediate window - Compile error
Change default path to personal macros
Speeding up writes to cells?
VB question- please help!
how to find and copy values on sheet 2, based on a list on sheet 1
Removing Duplicates and Pasting
Sort IP address.
Trying to set default Worksheet file name from C++/MFC
Tricky... Macro Security!
Easy VBA question: range control
OLE Combobox MatchRequired property not working
Row Color
Bad performance
how do you send a email from an specific excel column (database)..
passing range to c#
UserForm usage
OLE Combobox: Excel breaks down when it has focus
Consolidate multiple spreadsheets
Automated spreadsheet Consolidation
text box with standard text
Event handling...
getting a list of users with permissions to a workbook
deleting 2 rows
ActiveSheet is blank
Help w/ VBA code
Save to directory and create if not exist
Minimize a form
ShowAllData in all workbooks and sheets
Lock and Unlock Cells
how do i display a value in a user form as a result of a selectio.
Execute a program from within VBA
Referring to the base workbook in which the module is situated
Cleaning up the syntax
Testing to see if windows application iis running
Scrolling through Auto List members list
Template Update
Using the Application.ScreenUpdating = False?
Using the Application.ScreenUpdating = False?
How to use workbook_open()?
VB coding to go to last cell at end of any given row?
Editing Number Input on a User Form
Changing direction of cursor after hitting enter - toggling with toolbar macro??
(",) Good News for Google Groups, Usenet and Other Users
can't open excel - user.exe error
Import files on a mac
Implementing late binding for VBA
Prevent "Opening..." alert when opening from VBA
How to insert Calendar for Userform
Filling in a Date Series using the Fill | Series menu command
Pivot Table Events
Running a macro Upon Closing
tab color
Get Last Day of Month
xl instance
Excel cell formatting
re: vlookup in VBA
Question on "Programming a MenuBar"
SaveAs text file from VBA Getting Error
Closing form turns off commandbar control procedures??
Add msocontrolbutton to commandbar problem
How you decimate data using EXCEl (i.e., remove every second or t.
Proper Syntax for Date Modified?
option buttons' values = false
Auotomating Hyperlink?
Using Vlookup to pull data from another workbook
Copy and Paste Macro - Simplifying
How come the XLA worksheet becomes visible?
Close a foreign application - ADOBE
Macros to Open & Update Files
Excel Selection in VBA
Memory Usage
When I email an Excel spreadsheet to a co-worker it is distorted,.
Detecting Security Level
Modify "pick from list" to read named range
(",) Good News for Google Groups, Usenet and Other Users
Print Chart Worksheet
Drag&Drop over an UserForm
Recognize Names of other Workbooks
Pass a Variable List Of Values To Subroutine or Function
how to change de data base of a dinamic table
Comma to period
Vlookup
How to stop sheet deletion
Auto Open Excel
How to disable the "Insert Copied Cells" context menu item
Only works on One Worksheet, When Looping thru All WS
VBE file open coding
XL Free Floating
Multiselect list box
How do I delete a workbook after the vba has run?
F8 and Yellow pattern for compile error
go from input cell to input cell
Select a sheet and activate a Window
Using loop for selection macro
adding hyperlinks
Playing around with Syntax
DropDownBoxes Which update base on other dropdown values
hyperlinks
String Arrays
security of code
PasteSpecial
Help???
how do i change the expense statement template macro
MsgBox Font Size change
Remember SelectionChange range in the Change sheet event?
Using a VBA listbox to populate a worksheet
worksheet functions language
EXCEL-Renseigner Cellules par clic sur cellule, qui ouvre ComboBox renseignée par liste dans feuille de calcul ou d'Access Trié Filtré
Lock Screen to current view
Worksheet audit
Cell contents is a macro
vbModeless user form crashes Excel
Programming
control mozilla firefox
Huge sheet into smaller sheets
Controls Toolbox control vs Form Toolbox control
Converting dates to years, months & days
Excel should allow formulas embedded in text.
Can't clear saved data in Pivottables
Running macro when cell contains text
hyperlink navigation using combo box or list
Error getting Row number
(",) Hello, I Have Good News!
Stop prompt for password when Excel closes
ThisWorkbook.Path not updating
Sum Formula
Setting a Date variable
IP address format
Does Excel 2003 knock out add ins?
PC to MAC VBA function problem
Macro to Manage Blocked Senders
displayfullscreen = false not working
VBA with Adobe
Loading a Reference
Split Sheet
cell comments
(Un)usual "cannot set Xvalues" error message
Summere totalsum fra 1.januar - Ã¸nsket mÃ¥ned.
Vlookup with 8 sheets-please help!
DIR Function Question
help with hours minutes and seconds
Excel 2003: instances not closing
How check if form is loaded?
Merge multiple files into 1
Move sheet to another document with variable name
Use Toolbar Button to Toggle Addin
case select and a range
modify formula
advice needed
vb scripting -- copying web page, paste as text
How to Determine PrintJob is Finished with VBA
Macros that only run once
Add a Row
alerts
Copy/Paste Merged Cells via Macro is not working
Images
Export CSV File, set Windows Read-Only attribute
Macro for formatting columns with dates, weekdays, and widths?
Delete all Characters "except"
Accept Overwrite Automatically
Not getting the object structure of VBA Excel
INSERT into named range using ADO
Contents of a TextBox to HTML
No negatives
Total up a column as the value change on another
Delete Sheet
filesystemobject
How can I pass an array as TextToDisplay to a hyperlink?
Extra reference after opening a file
run a macro from asp??
Can I perform tasks on a closed Workbook
Quick userform question.
Lookup Value
PDF issue when converting from Excel
Validate data
Filling a cell based on the content of another cell
Button to move rows to other tab
Macro trying to open second Personal?
Format command
Best way of copying text to Word from Excel
Fixed decimal point.
Sheet Name
Where For Art Thou DIM?
Simple Clear Contents
What is the best way to Track Employee Absences on a spreadsheet?
Open form on Enter
Command Button Caption
Range.Resize from Visual Basic in Windows to Excel
Reorder items in listbox
Define array of sheets by inputbox
Function tool or programming...Help please!
Macro help anyone.....
Compiling vba code as stand alone exe
Program to add a row?
Combining multiple sheets onto one
Customizing right click menu
custom right click menu
count how often a name exists
Combo Box lookup
Repost - Extracting a table from a cell
Tell if workbook is opened in IE
Macro does not refresh on the "Calculate" command.
Cycle through controls with similar names
How to get a variable range
Opening a directory using code
Unload all addins in VBA
Using custom template with Excel.Workbook.SaveAs
hide macro
CommandBar ActiveX
Problems with Dr. Watson
Problem with printing from VB-script in Excel
Finding most common word in a list
Combo box hyperlink navigation
Data Entry Dialog Box
Data Entry Dialog Box
Data Entry Dialog Box
Get the row number that matches my value
Find cells without multiple spacebars and format...
Is there a "generic" Error Handling method
badly struck! how to pass values from asp to excel
Display a message whil eprocessing
Re: Setting Password & WriteResPassword
Re: Calculation Mode
Re: Application.OnKey
Please Help
Re: Password Question
Purchase Order with Drop downs that will Auto fill typical informa
How do you update a public constant
Present Value of Remaining Cash Flows
Count Autofiltered Rows?
Dim vs. Public
Informational userforms
Excel 2003 won't run simple code that Excel XP and Excel 2000 will run
Generic Sheet Names
Programaticaly update webquery - help
Reading a Range to an Array
Need to use answer from combobox selection as listfillrange for s.
Is it possible to prevent opening of workbooks in the current instance of Excel?
Lost VBA extensibility library reference
Cell Calculation taking to long
R1C1 versus A1 in VB code
error when using variable name for workbook
combing cells
row background colour in html
Combo Box ListFillRange Property - Non Adjacent Cells
closing opened workbook/app in memory
Setting size of icons
Invoking Local Cube Wizard
Programaticaly update webquery - help
Listbox textalign
How do I modify rounding rules in Excel?
maximum variables within sub
Unable to Record
Spinner
How do I use a variable name for a workbook in vba
Understanding declarations
Macro to delete un used styles in a workbook!
Button to move row and delete old row
HOW TO PLAY SOUND.WAV FILES SIMULTANEOUSLY UNDER EXCEL
Need Sample VBA Code
Syntax for Accepting Worksheet Formulas in VB
Can Excel read from a USB port?
comments shown halfsized
Attaching One Worksheet to Email
Consolidating Code
Routine for checking if file exists
Change Workbook Event
Login and password automatically entered in a web query
Automating Excel
Help with Address property in nested loops
Using macro to save as todays date
Excel workbook will not close due to VB Reference link
Looking for help with macros and chart making.
Help finding error setting range to Visible Cells
Prevent Error Message
Capture Screen to *.gif file via VBA Macro
Replace Code Programmatically
Deleting rows after copying data
When workbook is reopened, macros are disabled
3D charts and contours
Comparing data columns
Soup to nuts listbox help needed
Inop Macro
Worksheets("Brackets").DropDowns("Game10").Click
go from input cell to input cell
Unable to set the XValues property of the Series class
File open on Erro question
Re - GGVT Excel Copy of a WorkSheet Takes Mighty Long Time
i need icone foe special paste-value
Help with Run-time error: "Type Mismatch"
excel might let me have more than 1 color police icone
Protecting spreadsheets for coping
Compiling A Workbook
Webquery datafield naming changed between excel versions 97 and 20
Copy a form from excel into a new word document
If, ElseIf
working with strings
IsError Function
Deleting blank rows
show VBA source line numbers
how do I use SQL within vba for excel?
how do I use SQL within vba for excel?
Scary
insert scanned worksheets,then apply formulas, similiar to backgr.
Copy Destination:= Code Stops Here
Excel in MSIE
error message with Pivot Cache
copy values based on date
Ogives on excel?
Beginner's help
Excel Database Query String Too Long
URGENT: Creating a drop-down menu to perform v-lookup function
Sorting
thumb size in scrollbar control
password protect project with VBA code
Saving a File
how do I calculate a mean
Multipage Controls - Experts Only
suppressing a footer only on the first page of a printout
number as string and adding spaces to it
Identifying excel
suppressing a footer on the first page of a printout
Copy data from one workbook to another of same name
Looping Thru Objects in UserForms
Erase Data on Sheet
Select every "odd" column
Another change event question
With Statement
Worksheet Change Event
Posting again. Please Help! How to "track changes" using VBA
EXCEL Macro Available?
Copy & Paste formulas
Adding certain cells
Print Area & Page Set Up
Creating a local and hidden name; Parameters
Best Way to Distribute and Upgrade a Spreadsheet
Excel VB Buttons Disappear
Updating Worksheet Names for Rolling-12 Report
List worksheets
Adding Cell Commnets together
Copy from website to Excel
ODBC Connection
excel
Stop Error Message
Worksheet Controls in design mode
Design/Logic Comments
Generic Sheet Names
VBA and Trim
protecting a sheet in a different workbook
master sheet??
How to randomly distribute rows from sheet 1 to sheet 2 & 3 with V
Macro Name problem when I change workbook name?
Changing Macro Name?
What Excel 4.0 macro command do I need to use to delete a range na
General Question
Automating Word - Print one page not entire document!
formula to get the file save date in a cell?
Help With Total of Values Please
Enter a formula in column A, if a condition in column "B" is met
Sub in "thread"
Using Range object as created
workbook saveas function, xlText file format
Missing cells
Spreadsheet screen flickers for a few second when using a condition
Pivot Table Programming
separate modules for each sub routine?
Enable/Disable Menu Items
Copying an entire row or Rows based on column criteria
Excel Link Question ?
Error problem
Simplify CrossJoin function
is there a way I can have excel shade a cell a color based on tha.
How do I import data from Calendar into Excel
Query with cell reference.
Detect NULL (??) range?
Find Findnext in selected range
External Data from Sharepoint
Conditional Formatting Counting Colours
How to check Excel file already Open
NetDDE in Excel 2003
drag and drop and Worksheet_Change
Align text for labels in user forms
clearcontents, worksheet_change, cell validation
Searching for Archives
Problem with create an add-in
shorten value in a cell
problem with Worksheet_SelectionChange
onClick in Excel
Fill values into a listbox matching selected values from a combobox
TAB Key doesnt work.
Microsoft excel weblogs
Access to Excel combining criteria
data validation to restrict input in cell based on value of cell above that cell
Using Workbook_SheetChange for single column
'For - Next' question
Query to DB2
running macros/vba code in a shared environment
Testing for named cells (i.e., ranges)
Right click detection
How do I use an If Or function
A MACRO TO BUILD BORDERS
Calendar in worksheet
passing a value to another function
Getting an exact match
Groping by column
vlookup problems
Put in clipboard, but keep the current content
Use button on sheet to transfer data based on todays date
MsgBox keeps popping up
alerts
Strange problem with ActiveX component and Excel 2003
Suppress double click behaviour when a picture on a worksheet is active/selected
checking for a connection to the web
Building object reference
Further Clarification with Event Handlers & Class Modules
OpenText looses leading zeros for zip
How can I get Excel to flag the need for recurring updated data?
How can I get Excel to flag the need for recurring updated data?
Hiding a sheet
building a list in a col...based on another col
How to make 0.5 same as .5
Looking for a way to control...
Count occurences
select and nonselect ??
Pivot Charts, auto formating and macros
Find WorksheetFunction - finding text within text
Strange behavior with text box values . . . help!
check boxes
RE: Frank Kabel: A Sad Day for the Excel Community
Using "InstrRev"
Help with VBA Input Validation
Excel cmd button
Open file
How do I convert a nominal monthly compounded rate to a quarterly.
Trouble Programming from DotNet Against Multiple Excel Versions
currency formats
Calculate Median with a macro
Using Application.match against one dimension of a multidimensional array?
VB code to total up a column as the value change on another
Excel Function Addins
VB code to total up a column as the value change on a nother
Re: Looping through and linking
Message Pop Up Box
Workbook Sharing
Set module-wide objects?
Worksheet protection problem
Is the formula an array formula?
How to generate a file copy of the Excel Find results list
Macro Error
textbox automation error
Declaring array constants at module level
Importing CSV files in Excel
Calling Excel 4 Macros From VBA
Pasting text from Excel to Word (macro)
"IN" comparison operator
Vertical scroll bar in a MultiPage
Macro crashes if I run it twice
disable events while macro is running
Delete selected rows data
Opening all files located in a specific directory
deleting an AllowEditRange
Chinese
Deleting worksheets
Deleting zero values
How to Open file as read only
macro to save and increase invoice number
Help to convert one row of a sheet excel in one page HTML
move all files in a directory into another
Filtering ODBC data
Help with emails from Excel-add via Outlook 2003 (mistery apostrophs)
Re: Frank Kabel: A Sad Day for the Excel Community
RunTime Error (Automation Error)
Named Range Fails in VBA Code
Workbooks.open method fails
custom function - with built-in function
Re: Opening Excel from an ASP file (VB works, ASP gets ASP 0178 error)
Creating table from cell contents
Calculation problem
Problem with hundredth of seconds
summing ranges
BackColor, Forecolor, Bold, and Font Size for ComboBox in Commandbar
How do I create a For loop within a For loop?
Print UserForm A4 size
Print UserForm A4 size
combo box or list
BackColor, Forecolor, Bold, and Font Size for ComboBox in Commandbar
Export file problem for TXT file.
Interacting with EXCEL Solver via macro
Combination of Getopenfilename and Inputbox
Date format - ADO query Access to Excel
Default value in data validation
Macro's - inserting a worksheet and having upload data
SetFocus does not show cursor in initialize (Excel VBA)
I cannot open microsoft excel help
New Excel user needs help with simple Macro...
How to disable delete operation
Complie Error Help
Code required please
What syntex to find text
Macros & vba
FileSearch Object - Cannot assign to variable
format textbox in userform
Defining a Function
Handling ubound on an uninitialised array
0% = blank
Removing last three chars
Variables in VB Code
Looping Data = TRUE to a MsgBox
Relative reference in macro
OPen and close file
Divide by a count to give daily, monthly, quarterly results
question data validation and delete/clear behavior
ADO Recordset Problem -- Left Join
Using Events with the Application Object & XL 2003
missing toolbars
Get Last Day of Month
Font to change color automatically based on value in cell.
Pivot table in HTTP-served Excel worksheet
Method 'COMAddIns' of object '_Application' failed
VBA Crashing XL on reload
How do I make all VBA routines offlimits until a user enters the correct password
Three Cases
Comboboxes
Total up a column on change of another
Read a range to an array
Nested If statements
Deleting/Changing values
How do I remove unwanted add-in names from the XL Tools list?
Visible WorkSheets
Variable For Worksheet Name
Why no hints after typing .
Inserting/Deleting Rows when values are added /cleared
MenuItem.FaceID
Workbook_SheetSelectionChange
Redefining the Ctrl [ and Ctrl ]s short cut with OnKey?
Collection of Face ID's available somewhere?
get the data from the last row with data I am trying to get the da
Excel 97 search macro help please
Inserting a row when a value is entered
UserForm position other than center of the screen.
Recalc CTRL+ALT+F9 not work
Problem with IF statement
Modify Excel's Sorting Procedure
Inserting row when option is chosen
cell validation list reference to a different worksheet
Relative Addresses in equations
Trapping the "Can't find project or library error"
Re: Deleting Rows with Listbox
Re: Deleting Rows with Listbox
My equation is too long!
build a word search puzzle
Removing duplicates testing in 2 coloms
How to disable the delete key after deletion is made
DataObject and cliboard
Personal.xls Where is it in 2003?
If ..Then statements
How do I set up an income calculator on excel that specifies clie.
Number Format Syntax
Prevent sheet add or delete
Re: Creating Charts
under
Need macro to parse function into longhand
iserror(Timevalue())
how can I get the letters A & S to add 1 in excel
Case Sensitive Duplicates in Lists
formula returns #N/A
stop error message
How to prevent a 'copy' from opening
R: help, simple question about variables
List of printers
Dynamic use of Access query
protected sheet but automatically refilter
How can I link a drawing object to data in a sheet in Excel?
Macro to edit another Macro
textbox in userform(vertical center)
Autofill functionality with Validation
How to auto increment a template in Excel & Word
SUMIF with multiple criteria
ActiveX control in Excel
Excel 2003 & XML
Excel 2000 VBA Arrays
Excel 2002 controls move after printing sheet
Date error
Trouble saving a worsheet to a file using macros.
Re: Changes not saved in xla module
Re: Changes not saved in xla module
Delete Columns For A Range
Re-write "track changes" of Excel in VBA
Filtering Column Duplicates
VBA Cell Filtering with conditions
Interfacing with web site
Deleting Columns with String
Remove macro from autoshape
Pause code for data return
stop error message
Clear blank cells
Make Macro go to Next Workseet
Tabstrip tabs entered programmatically disappear after form unload
Return no of rows per page
hide or decrease taskbar
alerts
Format Cell Background on Condition
DataTable number format
Freeze/Split Multiple Panes in one Worksheet
Can I invoke excel automatically from .bat or other means so that.
non case specific
Formatting convention for code
Confirmation of file
ADOImportFromAccessTable
Public declaration
find next finds too much.
Filtering in VBA
Deleting multiple rows contain 0 in excel 2000
Can I specify the absolute path?
Summing different # of rows
AVERAGEIF Function out there?
Help with Copy and Paste
Add a worksheet using VBA
UDF - case sensitive argument
EntireRow.Delete
Excel Global Template
Embedding VBA in New Workbook
Excel spreadsheet is closed
Visible Row?
Protecting Sheets with VBA
Open browser from excel
Array of Public Arrays
Data tables
Resetting the array size to Zero.
Using Find with dates
Pointers to doing a HTML Post to Excel
macro to increase invoice number and save
Changes not saved in xla module
Export an excel file as text without change of document type
Is it even possible?
Embed Function
Access Query
Dim Appword As word.application
How do I replace * as a character in a string in Excel?
learning event procedures
stay as do it - userform
Fix this Code?
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
How to Sum cells in a variable raw using VBA?
Property let / get question
If, Or and an And
VBA code to enter extended characters onto a worksheet
Need a simple VBA code to automate a repetitive task.
Hello.. need help!!
Auto Populate sheet name of active workbook in Combobox in Command
Hide Columns On Condition
Advanced Database Query using VB Script
VC++ 6.0 and Excel
ERROR 91 with FIND in macro
Counter Failure
Help With Formatting Timer Please
Deleting blank rows
RE: Frank Kabel: A Sad Day for the Excel Community
UserForm Initialization
VLOOKUP and Missing Values
Upper Case and Lower Case
Access Data import in Excel with QueryDefs
Conversion of giant sheet into smaller ones
Variable as argument in filter range
Count almost empty rows
copying and paste data from each worksheet to a summary work sheet
Faster Cycle through Cells
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
"Worksheet Change" Question
Input box to update combo box
using of progress bar
Help needed with priority level
Data from Programmatically created Excel into SQL Server
error trapping
Match function, N/A error, how do I get around it?
Changing the displayed information in a series of cells.
Automatic Borders
Scrollbars & Userforms
Need help with countif or another count function
Additional Controls
Re: Make a visual basic form fill a page
ActiveX add-in?
Exporting the same Excel macro to 60 workbooks
Pasted text from Excel to Word replaces previous paragraph
RE: Frank Kabel: A Sad Day for the Excel Community
word mail merge from excel
RE: Nested if....?
Setting column width
Windows XP and MSFlexGrids
Problem copying cells to another workbook
Automate Cut & Paste Rows to different tab in Workbook
Re: Macros make file saving extremely slow.
custom help files
Declaring a Public variable as a Range and its lifetime
Setting a column to Text datatype
adding row when user reaches the last available empty row
help
Formatting an excel sheet created by a dts package
New menu item OnAction can't see macro?
help, simple question about variables
Hidden Row Detection
Excel not visible and get Not enough system resources to display completely
help in refering to a range named in a cell
Comboxbox in Commandbar
Macro
Programming With Multiple Excel Workbook Objects
Excel from a Server
Re: chart id number
Re: Cell protection problem
RE: Frank Kabel: A Sad Day for the Excel Community
RE: Frank Kabel: A Sad Day for the Excel Community
Shell Method
Nested if....?
Display error?
Using a cell reference in a macro
Procedure Run Order
Help with Grand Total and Positioning Please
capture right mouse button click event on cell
Writing a CSV file
How do I determine how excel was launched
progress bar problem still
Range's comment text
view data into userform
hyperlinks
Connection losed in Excel2003 Add-ins when copied it to other comp
Filtered Count
Right Justify List Box Entries
Weird error
How To CreateObject In VB To AutoCad
View Routing code
Placing Optionbutton Value
Test for value and set row height
What macro is run by a button???
Lost control - how to find?
RE: line controls
Elseif code
Using a time value in a macro
How to delete Custom VBA Menu
Fonts missing from latest Excel mess up my files.
Halt recalculation
Making a form into a file...
Linked cell auto update???
how to write vb code for multiple combo boxes
MS Spreadsheet 10.0
Windows Log Off
Delete Column Containing String
Re: macro
Add items to VBA-created menu?
Re: macro
New Chart
RE: shell commands
Loss of Speed During Copy Operation
Error trapping & Handling
Web Query with a twist
RE: Retrieving the Collection of Ranges in a Workbook
RE: Retrieving the Collection of Ranges in a Workbook
Re: Frank Kabel: A Sad Day for the Excel Community
Freeze pane Prob & Activewindow
Re: Frank Kabel: A Sad Day for the Excel Community
Re: sending e-mail notice after any updating in spreadsheets
Summary sheet
"Application.Calculate" does not always update/recalculate the for
using a range of dates
Reporting with arrays
Access query in VBA
unhide cells programatically
Re: Un guru nous à quitté :-(
Collapsing Rows with subtotals...
Saving workbook with frozen panes as web page htm
using relative named ranges directly in functions
workbooks.open
Hiding Rows progamatically
Can VBA read the row-col location of a selected cell?
Web query .Refresh BackgroundQuery:=False problem
Import csv file into excel programmatically
QueryTables Add
Finding Ranges
Subtotal Function...
Excel & Reuters Power Plus Pro
Button Macro - One command but does two things ???
movement between cells in excel
movement between cells in excel
Create New WB, Not Read Only
RE: Frank Kabel: A Sad Day for the Excel Community
Help Fixing Coloring Macro
Pivot Table
How to run a macro based on an If formula?
Re: Data Entry Listbox
CDO_send can't communicate with smtp server
Can This Be Automated?
Help with using custum functions
Input Data from user in correct Format
Simple VBA question
Mark files and sheets for identification
Re: Class module
Re: Un guru nous à quitté :-(
Play avi file in a Frame
Developing TEXT scrambler kind of FUNCTIONS in Excel
progress bar second question
Prevent changes to cells but let user move columns?
Excel 2003 Issue with UsedRange.Copy (code works in Excel 2002)
Re: Trend Line Disappears
Formula
Re: Frank Kabel: A Sad Day for the Excel Community
Defining a variable Range for cells with values in them!
Re: Loss of Undo from .NET Addin
Re: Frank Kabel: A Sad Day for the Excel Community
progress bar
Index / Lookup query
Comparing columns
VBA Trim and Application.worksheetfunction.Trim
Re: Frank Kabel: A Sad Day for the Excel Community
Disable Warning Message from Microsoft Outlook in Excel VBA
Disable Warning Message from Microsoft Outlook in Excel VBA
Re: Un guru nous à quitté :-(
Export Excel data into Visio
Buttons, onAction and Parameter
Sum in pivot tabels
Saving tick data
need assist with save as csv code
Dropping Tables into Worksheets
Offset question
Re: Delete cells without selecting?
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Defining a Variable Range
Re: Frank Kabel: A Sad Day for the Excel Community
Accessing custom document properties in Word?
RE: Frank Kabel: A Sad Day for the Excel Community
Adding menu items
Is there a way to Trigger a Macro on a workbook save event
Re: Insufficent resources to display a form
workbook.close savechanges:=True problem
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
linking 3 levels
move cell
RE: Frank Kabel: A Sad Day for the Excel Community
Copying a worksheet
help with formula
Re: Frank Kabel: A Sad Day for the Excel Community
Re: Frank Kabel: A Sad Day for the Excel Community
RE: Frank Kabel: A Sad Day for the Excel Community
Multiply cells in range by corresponding factor
Cause userform to update?
Frank Kabel: A Sad Day for the Excel Community
Printing
MSFlexGrid
How to test if an Excel spreadsheet exists in VBScript?
Return day name from a date
copy data from a range of worksheet
How to get sheet name in formula or macro
Up 1 Row
Reading data from an excel sheet and writing to another
Hyperlinks
Can I move files From Drive to drive using VBA
Re: Custom Function being called when it shouldn't.
Protecting VBA macro from modification by users
Excel workbook generation slow
Deleting rows using VBA
Hide Userform
Range Selection
problem copy/pasting pages.
Test is cell contents are a URL
Re: Problem with txt
how to allow macro to write on a protected sheet
Re: How to select columns in loop
Re: Userform Answer Validation Problem
Re: Userform Answer Validation Problem
Re: Custom Function being called when it shouldn't.
Re: How to select columns in loop
Text Validation
Why page too large for other printer?
Running code after a picture has been inserted?
Select option button when have the name as a string
Equivalent VBA for MID/FIND formula
Changing Names of Pivot datafields
Moving Macros with Sheets to New Workbook
First column with non zero values
Disappearance of assigned value of varaible when working with form
Expanding Gray Bar That Covers Excel Cells
Web Browser Control won't refresh
Update a sheet
NG Posts Database
Importing/saving multiple files in Excel w/ macro
Port 119 for NG
combo boxes
Simplify Code - Select Case
filesearch not finding files
Auto insert/delete on other sheet
excel errors
excel errors
Trace all the changed cells range...
.Net Add-in needs to catch cell edits prior to committing
number only
finding the parent row of a cell in VBA
Finding WKends Between two Dates
Userform
Cannot edit workbooks saved to CD
programming VBA
problem using isnull() to check a value in ADODB.Recordset
Disable Macro automatically when a sheet is deleted
Disable Macro automatically when a sheet is deleted
Copy/Paste to email
Character (13)
Formula Screenupdating
Printing A PDF From A CommandButton
algebraic formula to calculate "net uniform series" (NUS)
View Routing Recipients
VBA in Win 2K
Referencing cells with input boxes.
Copying a Cell
Can't 'see' all of a cell's contents across columns
Questions about ADO
Pick a row
Cell Entry
hidden columns and row
Cell validation
is it possible? please
Customize choices when right clicking
Delete Columns based on Strings
Deleting Repititions
Find and Write data
Last empty cell
is there something i'm missing?
GoalSeek Method failure
Problem with Running VBA code on Cell Change
MSG BOX PREVENTS SET FOCUS POST 2
Listbox1 to Listbox2?
Adding Cells to a grand total
Return Items from Listbox
Command Buttons - can't click or open properties
Loop through Pivot Table drop down menu
How to only print row labels on alternating pages of a worksheet?
MSG BOX PREVENTS setfocus HELP
What is the location of my first horizontal page break?
Returning the location
Thank You Group RE:Application.FileSearch not working? 1/16/2005 10:59PM
Marcro to copy sheet out of workbook
Script to recognize hyperlinks?
confirmation of file before opening spreadsheet
Need Excel macro for exporting data to Access
ToolBar
Screen Resolution
Macro eliminating named ranges
Concatenating Cell COmments
created objects look different
Error when exporting data into Access
A function of reverse complement
Shapes and Events and Custom Menue
multiple pivot charts
cell value swapping
Is there a way I can find the time difference between two dates a.
Write Data to Excel Database
Dialog sheet / Checkboxes
Calculate all sheets
How do I force a browser based excel hyperlink to open a new windo
Mail Function
automatically changing font size
Restricting Macros
Automatic transfer AS400- > Excel
Formula
Creating PivotCharts from PivotTables
EXCEL 2003-Need seperate totals for - & + #'s in a cell range
VB script and disappearing information
Find a string into another string
checkbox "Always trust macros from this source" shaded out
Generating Data Reports in Excel
Cell Comments
using the excel range object
using the excel range object
resetting the autofilter for users of a workbook
Class Modules
legendentries
Download of the file from macro
Update on change
VB TAB doesn't move activecell??
Intervening in a "hidden" spreadsheet process.
Formula for last row and last column on a worksheet
Date format with other text