Excel Programming [Archive] - Page 120

Autofilter change opens another document!
Adjust the font in Data Validation dropdown box
How to get name of named range where activecell is
shell question ?
Check for Existance of sheet - problem with UDF
Access error to registry configuration
Change XLS-File Format via VB .NET
Exporting Chart to GIF File
Patrick -- 424 Combo Box User Form
Update the time in a form caption
This'll stump you! Problem with Copy Sheet between Excel versions
Personal.XLS file doesn't remain with Excel file when emailed
Filter in place question for sort of unique records
lock cells
SumProduct Error?
change size of object
length of square
Importing Access Tables
Application.Quit en Excel crash
Object range method runtime error
Open Test file with VBA with a changing file number
Help with cell references dependent on strings
Determining if a Worksheet Exists
Printpreview problem - disable various buttons
Hard question - creating a database
Finding Current Path
Can I search a range
disable copy paste
String function
Multiple queries
military time function
Find first and/or last cell that matches data
can't change query definition in MSQuery
VBA modules
Use FIND to return an array of items
Print Excel file via VB
Creating a Pivot Table directly from an Array
ideas for exel
Month/date problems.
Can you build a dialog box to fill a column
Checking difference between the dates
Locking and unlocking a Excel project for viewing
Unprotect a Excel workbook using vba macro
Hyperlink information in Excel
DSCR Error
Finding "last cell"
I need to find the first empty row in a sheet to paste data to
"Open with.. Excel" in vb
Re: Hi,Question about Worksheet Security
Problems with the excel find function in vb.net
RE: help
Text Import Wizard from vba
Array and optionbutton?
Create Message Box containing different variables.
number as text confusing code
Reference Cell Range Using Cell Value
In a Shared Workbook of Excel, how do I change the color of a Cel.
How to declare variable as public.
help!
displaying a col based on nt account.
Range Error
Early and Late Binding Vba Excel
Problem with Do Loop and If
Re: Delete column if ....
OK, so I can't click on a link in IE
sheet code help
Variable holding across multiple subs?
Re: Question about Worksheet Security
Re: Please Help
Re: Please Help
Re: Please Help
Re: Question about Worksheet Security
How can I use the XOR function?
LOOKUP Help!!!
Counting columns using VBA
referencing a name from another book
sort method
macros execution problem
GetOpenFileName method different in Excel
vlookup function
Add-In will not allow worksheet to be opened.
Please assist with TextToColumns Thanks!!
Trouble with VLookup
Enter Text or Date on Multiple Sheets
The Perfect Mix
How do I hide my Visual basic code in Excel?
This is what I want to do: =if(a1 CONTAINS "BIRD","YES","NO", false)
Excel Add-in and Citrix Client/Server
Auto look up
Creating a back key
Using a drop-down list to lookup
Range Question / error 1004: method Range of object Worksheet has failed
Excel Automation using .NET
Help with code please
Excel Find Method
strange problem subtotal
How do I not delete an enitre row when running a duplicate delete.
Run Time Error 424 Combo Box User Form
Why does the error pop up- can't enter command mode?
VBA Closing File
Cut N Paste
Numbers
Modules and add-ins
can't clean up the clipboard in excell
Why autoformat increases file size?
Reading CSV file from Excel (VBA)
Web query in macro doesn't work until you manually edit it
Chart help please!!!
Weird Startup Lines
Application.DisplayAlerts
Delete Rows from multiple Sheets.
OnTime / TimeValue
Search dates differences
Closing Form problem
Lookup using two values - like an SQL in the same workbook
Excel 2k - A bug or bad vba...?
Looping letters (or columns)
problem with formula
automated spreadsheet
Macro to Copy Hyperlink to another file as a HYPERLINK, not text...
MsgBox not displaying right away
Numbers
How can I remove the Excel COM addin from the Excel program?
Add-in removal
navigation keys are turning off
Editing recorded macro code. Referencing workbook name in functio
Chequer-box Pattern
Creating a Log
shapes on a sheet
VerilyHiddenSheet-VBA Editor
Hide Access when macro run from Excel
if statement with functions
Run-Time Error 1004
Cell Change Event
Formula in VBA!!!
Looking for Rod over in the corner...
How do I output a formula into a cell and then autofill using vb?
Temporary Sheet with Cell Selection
Using user defined workbook name in macro worksheet functions
Understanding this code snippett
Macro to create the new worksheets.
Displaying help in a UDF
Help building string for Names.Add RefersTo, pls?
How do I get external web data that requires a password?
Compare 2 lists and if not on list then delete row
Cancel Macro is user selects 'cancel' at save menu
Sum Intermitten Data in one Column
Macro to copy cells from another sheet
Pivot Table Deselect all items
CopyFromRecordset Question
Pivot table reports cannot overlap another pivot table
Open Object as Wkbk opens
VBA problem pulling data out of variant/range input variables
changing pivot selection
Data Validation - Code Not Recognizing Something
Excel macro crashes when it sets a cell formula
need macro: convert formula to value
Same operations on a variable number of rows
microsoft.public.excel
Combobox in each wks
Match and Copy to array
Is it possible to create distribution list for Outlook?
Calling an eventprocedure
Function Creation
subtotal question
PrintPreview slows Code Execution
Copying Outlines
Combobox to choose Worksheet
Problems in Excel 2003
argument in command line
Toolbar Problems
Creating a Function
Working with Charts
Always open Excel file with Userform
what is the formula for adding a new number to the existing numbe.
Need a left pad formula method
generic macro on close of excel workbook
outlook htmlbody
inserting rows and open file dialog
Centered Text Not Working in saved htm
Excel could not save all of your data and formats
Dates
Range naming columns and rows
Use Graphic as Hyperlink
linking
How to restrict the TitleRow only for a specific range of rows?
Reformat existing 4 digit number as hh:mm?
Running a macro on action
activesheet
Searching & Extracting Data
referencing a cell on another sheet
Code to open new workbook, prompt for 'save as' name.
How to associate data with schemas programmatically using .NET
finding last line in macro
Setting Focus not working as expected
automatic vs. manual
How do you hide a row if a certain cell equals zero?
Range Manipulation Question
How to
convert to number
Dealing with Pivot Detail Explosion
excel columns collection?
pivottable or querytable
Olap Cubes - Automatic Select
hyperlink in listbox
Insert code into worksheets programatically??
Numbers vs Values
Polling directory for changes
Procedure too large" error ...DAMN
Combo box values based on other combo box value
how do i program a vb script in excel to tell me which cell has f.
Outputting a formula in a cell using VB
Adding CC: to workbook e-mailed?
Show method (Error 438)
variable code
Books on VBA
2nd Post - Cannot select day on Calendar if ValueIsNull is True
Combobox List - Which Property
How to check for the existance of a Sheet (or not)
Cell.interior.colorindex - does not work in Excel 97
how do i setup a macro which is initiated by a button?
help writing formula
Solver in Visual Basic
Combine "Total" and cell contents
Excel vba code disappears when saved workbook is re opened
Hyperlinks on Protected Sheets
sorting by 4 categories
Muliple Userforms and multiple Stacks
Save original workbook name, referenced by macros in other books?
Different Calculations in Pivot Table Subtotal Rows
Copy data
Need HELP with QueryTable, ADO, EXCEL and EXCEL'S Formulas
Automatically naming sheets
Array problem?
Refreshing Linked Picture
how can i setup formula in excell
I want to use hourly update from SQL query
Puzzling Memory Error !
Changing Chart Series Names
How can I sort a protected page
Ghost of Excel
Passing parameters from excel to access
How to disable drill through on total cells?
Macro to Set width of cells
Macro Templates
Erratic Behaviour of Buttons
VBA color palette
Starting with A2!
excel 2002 runtime error 1004
Setting an Open-file password
Error Trapping
How to exclude a list of number from another list?
Range ID and drag & drop to a cell
Cell Precedents
Excel opens all files in My Documents folder
Scope of variables
copy ???
CDO Email
IF statement
minor modification to macro, need to delete cells
Creating a password form
Referring to a cell in another sheet
Opening Excel from VB .NET application
help with this formula
Click event on listbox
Error on Opening : data may have been lost
Combo Box
date in filename
For each syntax using a worksheet array variable
PivotTable DropBox's - Reset to New Value / Set Default Val
Code is not correct
For loop with letters
Saving copied info while running a Selection Change Macro
Extracting from Access
5461 element limit
Formula for a Rotating Work Schedule?
error trapping
Is it possible to add a 650 character footer in Excel?
Is it possible to add a 650 character footer in Excel?
pdf printing OFFENDING COMMAND: STACK:
How to I use nested quotation marks for 'SUMIF' function in Excel.
Application activation and pasting
How do I print a selection of cells using a macro?
How to round all numbers in a worksheet to, say 1,000s?
commandline argument in excel 2003
Mouseover or Mouse Move events
Conditional Formatting of Rows Based On More Than 4 Conditions
ListBoxes - RowSource
How can I delete 1 from the value of a cell when I press a Button.
Calculate my expenses
Sorting macro
formName.Show is not working
arrays
auto "page of page" requested
Form Focus and SelStart
Fill a combobox on a form from a txt file
removing file->save as option
Dir function resetting
Scenario Analysis... simple
Coloum Width | OS Problem
Undo macros
Custom Button Labels
cacatenation script
Save As behaviour
Sendkeys issue
Return double digit month
AVERAGE IF formula and not equal to ZERO
Help with code
Copy Range Issue
Exit Menu Troubles
Combobox - Sorting Data
Help with macro!
Change the color of a cell change dependant on a result
Time conversion
Zip & Email - VBA
Not visible workbook
programming excel 97 from .net 2003
2 sheets to print
error runtime 9: deleting a worksheet
Run Macro from specific cells
3D sum using VBA
edit cell by macro
Controlling the Footer of Word Document from Excel
Contains function help
Parsing XML data into worksheets
Add new worksheet and assign it to an object variable?
Newsgroup connection test
Last rites declaration of Ioannes Paulus PP. II (Karol Wojtyla)
Emailing Page-breaks as seprate sheet
Drop down list box
Windows Zoom
Loops or Do/ while or STEP !!!! A better solution
Userform Image Control and embedded images
Drop Down list box
help with macro
Called subs versus functions
Re: TextBox
Converting Excel range to JPG, BMP or PDF
Web Services using vba
Web Services using vba
How to e-mail a shortcut to the active workbook
Add and Subtract ranges (with multiple cells) in vba
Help - loop through cells in a range that are not together (several different cells as Target)
Row insert fails to update Sum formula
dialogue box / pop-up upon opening file - URGENT
Add sheet to end
use macro to insert characters at the beginning of a string
how do you set up a progress bar when running a macro in excel?
Check for subscript out of range
Apply CSS Styles to HTM Output
Sorting Protected Sheet
Scheduling sending an email
Paste Small Range into Big Range
Short List
Textbox questions
Merging Excel data from identical copies of a workbook
Trying to get data between dates ranges to analyze
Cubic splines
drop down list/box that has formula built in for other cells
Finding last record in month for each of several types of record.
Copy from one workbook to another
identifying subtotals
conditional macro
Reduce a value by spliting the data
VBA Password Msg Shows Up Mysteriously
Re: Copying Sheets to New Workbook
Excel formula to calculate Target Grade
Copying Sheets to New Workbook
"Private Sub" v "Sub"
Copy, paste to another sheet
How to rename autoshapes on a worksheet
Date Format
Rename Multiple Sheets from a List of Available Names
Custom menu problems
connect to MS SQL
how to place values in custom header
Comparing values in two columns and displaying missing values in n
Cannot select day on Calendar if ValueIsNull is True
Houw to Round
ControlSource
Macro's
RowLiner addin How to Start and Stop
Excel programming
Help can not calc Sales Tax
Tabbing out of Blank Cell
End Excel Application
Disable Macros in workbook programmatically
Pop up windows
Lifetime of VBA variables
Excel should stop promping for OK every 10 seconds
PrintQuality
Paste a hyperlink
Print Preview
Adding Times
A Macro to Delete Multiple Rows?
Search for bad email addresses
Controlling Access from Excel
Index/Match for 2 columns?
Complie Error- Argument not optional
How to either write the macro or manipulate the function
CommandBar Resize
weeknummer
Successive Data Validation Lists
MoveAfterReturn fails because sheet is protected
email one sheet of workbook
Disable "Sheet tabs" check box under [Tools][Options]-[View] tab
Position Wordart in Page Center
Populate
Identify Cell by Column Header and ID in Col A (Track Changes)
Looking for a Black-Scholes Employee Stock Option valuatiion mode.
populate list box
user form & control properties
Install RichTextBox Control
for each error
copying named cells into new workbook
How does the type of variable affect code!!
Opening a workbook with a specified size?
Multiple alignments
Making Macros in Excel
Need a message box that displays loading time.
Need a msg box that displays time status or loading status
How do I auto increment cells so that I may maintain a history?
Menu Item check mark??
Advancing to the next iteration of a loop?
MoveAfterReturn command fails in Worksheet module
Without a chart
Printing Multiple Sheets -- Printer Forcing Landscape/Portrait
Problem with macro: 1004 error
Testing for the presence of an AddIn?
Update data and Y error bars in a chart
how to change (override) enter key behaviour in a cell
using array, Match, trying to eliminate duplicates -> how to return or translate result to a boolean?
button reuser on forms
Syntax for running a macro from an =IF function?
excel userform serious problems
Formatting Data
Connection using ADO
Without a chart
Update Form from spreadsheet
is =if(K25=>K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?
how to efficiently send many rows of data on a worksheet to the database using vba?
Worksheet.CustomProperties
find item in list
insert scanned image into text box
insert scanned image into text box
how appear open file dialog in access
show file path in Print footers
Loading Form on Startup II
how to capture enter key inside a cell
Help Inputting a Name in a Macro
Help with Totalling Groups Please
Excel Cursor
problems with userforms
Laufzeitfehler 9 Indexüberschreitung
Worksheet_Change and range test
Loading UserForm on start up.
Protect Sheet - VB code to specify password
E-Mail
Run An MSAccess VBA Function From Excel
How to put a lock on a file
returning workbook name
Spacing
How do I print alternate worksheets in Portrait and Landscape?
Excel VBA Assistance please.
Import HTML code from a text file.
Removing #NAME? from cells.
Random
Help with code please?
Extract Data from Multiple worksheets
IF Formula to produce coloured statements
Formula Help
X button on userforms
Text Box has the focus
Troubleshoot XML Maps automatically generated by Excel
When code runs...worksheet acts a little strange
ZOrder of two forms
Problem with OLEObjects
find 10 max values in different sheets
How can I lookup cells that match a specific value and return all.
type mismatch?
Excel File Crashes Constantly
Template Placement
Alert message during Activeworkbook.sendmail
Use ADO to transfer data from open excel file to closed excel file
Macro for Page Setup - Repeat rows at top
textbox
getPivotData
color formating
linking cells in multiple workbooks
Why won't this code run??
SaveAs Dialog box
Re: Checkbox
Search and Replace help
overloading a function
Excel Constant for Border All Around Cell
Textbox margin overwritten by auto-margin
Script vs Open_Event
Multiselect listbox with check boxes
How do I permanently delete a macro?
Selecting a range offset from a cell
Lookup?
need to extract data from a pivot table using variables instead o.
filter by month
Problems entering Data validation Programatically
Excel connecting to Teradata
Auto check list box
Cell properties dialog
Autofilter Question
changing active cell
Convert to minutes and seconds
Copying Formats vs Formatting Programatically
Using a Cube to store Histogram information?
Changing Cell Font and Color Issue,
Can't get Workbook_Open event to work
Access Time Calculation
How can I recover from an unsuccessful Find operation?
.Cells.SpecialCells(xlLastCell)
Row and Column from Used Range property??
Merge
buttons on forms
Auto Date range and printing.
Is this possible...Filter list after user selects location
Does anyone have a Template for a Bank Reconciliation or Cash Rec.
Does anyone have a Template for a Bank Reconciliation or Cash Rec.
Need help re Macro
Textbox Query
Open excel file, enter values, save & close
Summing the last records of every month.
.column
how do i select different printer trays using macros
Sort Method more than 3 cols
Determine If An Application is Already Running
interrogating a workbook WITHOUT opening it from VBA
Macro Help
text align code XL2000
macro to alter worksheet code
QUERY ABOUT DATA REQUIRE
Automation: Create Word file from Excel
Removing code in 'This Workbook'
How do I automate the deletion of a row containing today's date i.
Copy From CD
usedRange
Macro
Application.Max wierdness
Copy from CD
MACRO HELP REQUIRED PLEASE!
Cannot create excel file from .Net in Office 2000
Macro recording
Unprotect Sheet - Removal of standard Message
MACRO Assistance Required
pain cell max and min
Pivot Table based on SQL Server query
Wildcard - help I'm stuck
Macro to run if cell empty
Find Value <> 0
Excel controlling Outlook
opening excel through visual basic
SpinButton Change Selection
run code in other workbook
import csv file
How to make a Case Function.
Look up
Refering to grouped ActiveX controls on Sheets
I need to create a custom form in excel
RE: ActiveX Option Buttons all act as one group
Re: Import Dat from Oracle - pls help
TextBox6.Text = Application.??????????(TextBox6.Text)
modify the data in a report
Close Current File Then Open New file
type mismatch error
Type mis-match error
What's it take for Canadian Application?
Re: No file when Save As is executed
Reduce file size by removing comments from code?
Hide Unapplicable Ranges of Entire Rows
Arranging Windows
Reducing file size (for archiving, not active files)
Can't find object
Where is documentation for the C# Office XP/2003 Primary Interop Assemblies???
variable range automation
Detect selected chart point
newbie redim question
Sorting Rows in VBA
Cell Protection Within a Worksheet
end subroutine
References woes
Outlook Tasks assigned from Excel?
Open XML string in Excel using C#
Find & Replace in Multi-Megabyte Strings
link to Access DB
IF Mytest.count>0 then VLOOKUP
windows file shortcut using vb
SumIf using two criteria
Copy Different Name References to New Workbook
Need some help with Exit Event
Trendline Properties/Deletions in Excel VBA
browserflags in registry breaking drop down box value
Hiding Rows between two Finds
Hiding Rows within a Subtotal
Hiding Rows between Subtotal
Adding hyperlink after the existing data in the cell
Adding hyperlink after the existing data in the cell
Pivot Table problems
Add dropdown on an event.
Get Displayed Value Of a Cell
populate a different workbook
center a message
Array Test
Floating Point Functions
Userform Textbox - fundamental flaw
date calc returning #name?
Re: PAssing Values to Excel
Moving data to another spreadsheet...
refer to a cell in another sheet
Macro Help!
list box
diferrent Excel versions connection problem
Printing all Visible sheets
Copy cells down
Linking MS dictionary as data into Excel
avoiding select
Macro programming in Excel
Identifying the last number in a row.
set range
Count number of values
ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
Help with Excel table pasted in Word?
UserForm Question
Re: Open book, check for macros, close book
Exclamation message box opening Excel - Archive not found!
Re: worksheet saveas question
Resolution change
RE: on error goto trouble
How do I write an Excel macro to open a file using the CommonDial.
Searching dates
Re: on error goto trouble
Re: No file when Save As is executed
Excel user-defined functions.
Store Information but not in a Workbook
error in getting system dates
woking with date's
Still Macro Warning w/o Macros ...
Wildcards in Excel VBA - HELP
Re: vb problem
If within an If...
Application.Match
Using code to mimic a find and replace
Need data
F2....
parameters not allowed in queries that can't be displayed graphica
Re: Stop macro from saving changes
RE: Hello
Stop Link Update
run a macro when file is open
Pivot Table
how to add bullet list of text items in cell
Import data from Adobe Acrobat PDF Files
Top 3 numbers in a list
Locked Sheet - Error msg to display to Users
Total a Variable Based on Another Variable Please
Copy and paste special, values not working
Late Binding issues when closing workbooks
RE: What is the fastest way to bulk load data into Excel?
Import text file contents based on path
1-variable Data Table w/ dependency on MS Query fails to update correctly
optionbutton
Inventory a WorkBook
input box upon opening workbook
Drop-down menu in validation list too wide!?
Drop-down menu in validation list too wide!?
Why am I losing macros that I create and store in PERSONAL.XLS?
Change event and calculate event
insert new row & fill down
creating dependent list boxes
Code to mimic vlookup
Multi Column ComboBox
Sheet Information
red point
Search Macro Help
Freeze cells from further calculation?
Project is unviewable
Sort by Variables
Copy every nth row into a new worksheet
listboxes
HELP! cant edit query
create named range in each sheet in workbook
sort list more than 3 keys?
ADO 2.7 & ADO 2.8 beforeprint
all subtotals have summary except one
Sorting after subtotal
Search
If Sheet exists, GOTHERE, else create it
Find end of list - new problem
Printing: Best Fit (1 Page Wide)
Change Message on Protected Worksheet
Statistical functions not tied to Application.WorksheetFunction
Calculating a Grouped Weighted Average Rate
Create RangeNames
Refer to Worksheet Ranges in Code
Excel Solver
Match and Copy
Macro Warning in File w/o Macros?
ADO: Read Excel file that is in use (locked)
Countif in multiple books
Way to have VB code to filter on entries that have cell with today's date?
Time question
export data from MS Excel sheet to external database
Curdir
Removing commandbuttons on "save as"
sumproduct in vba
Excel problem with trailing spaces
Zero Values in a Pie Chart
Find last row
I need a simple formula
Find end of list
Problem with Macro working in new workbooks that I open
Inventory added sub needed
Find empty cells
Programming MS Query
How do I print hyperlinked documents from a cell in excel
How do I print a hyperlinked document from a cell in excel
Set worksheet range runtime error 1004
how do I overcome this combobox 'bug'?
how to calculate time in a payroll worksheet
range picker / selector
problem removing controls
Run code remotely
Formulas for creating a muti-unit 12 mo. bugdet using a 1 store mo
Referencing Combobox with other cells in a different worksheet??
Validation ComboBox Size or alternative....?
Macro problem on, Yellowed line - previous line or next line.
Redefining pivot table source
Can I password protect VBA modules using a macro?
EXPORTING data from spreadsheet to SQL SERVER DATABASE
Inhibit Cut (allow Copy)
Re: Sum in VBA
Saveas where file already exists
Opening a non excel file using vb
unable to set the FormulaArray property of the Range class
Protect workbook?
SaveAs using cell value
Saving Worksheets
Macro to rotate data in cells
debug error
Link multiple worksheets in one workbook to another workbook and .
File Attributes
Data validation - comma
copy formula using vba based on row count
Best VBA newsgroup?
create entries on a listbox on a form
import XMLs
import XMLs
XMLs
Excel Workbook Address in VBA
Sheets Looping ignoring contraints
Code to close workbook
VBA or no VBA, that is the question
Ending an External App from VBA
Cumulative total
Pivot Table Year to Date
SQL.REQUEST Returns Single Cell
Clipboard.GetText
Worksheets not visible in Excel XP
Execute code on server
Rename Modules
External Query questions
UNDO in VBA code???
Help with HLOOKUP Please
global 'path' declaration
Code libraries usable in all of Office?
Copying Sheets
Formatting Performance
LockWindowUpdate
userform-check data type
What properties show on icon mouse-over?
color hidden columns
How to have different columnwidth for same coumn in several parts within one worksheet?
Minimizing/Compressing VB Code in Excel File ...
Excel changes celle when copying ?
Modify sub to output to new sheet instead of via msg boxes
How do I open an aplication and run a file in that aplication use.
NormInv performace in Excel 2003
Find & Replace question
PrintPreview doesn't work
Excel Web Query using a QueryTable via HTTPS??
Can you freely write excel macros in C# yet?
How to protect option button?
xlAutoOpen and GetActiveObject
array to access
Opening ,copying, access query resultsfrom Excel
Problems Converting 1-D Array to 2-D Array
User Defined Function for Wind Chill
i want a macro in execl to wait for an input from the user.
Import a data using a command button
Deleting element in Array
Command buttons and code - help!!
Object variable or With block variable not set?
How do i allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?
Copy ... Paste
copy rows conditionally
Conditional Format and VBA
Pivot Table Field
Duplicate Values on Multipage form
Return to Current Sheet in On (sheet activate) event macro
Can't put common dialog control on a worksheet
Stop Copying at Specific Row
Having problems with a circular reference and the #VALUE! error
Sub
Worksheet Change Event Problem
Write Text File
Forms Controls
running code after pasting data
Save As Dialog
negative numbers
Offsetting losses against profits
modeling offset of losses against profits
Xls protection?
#Value
closing active windows without saving changes
Comperison Data
How do I get a Check Box to set a value in a cell when is checked.
ControlTips not showing.
I need a formula I can't find in help.
Copy some information from sheet1 to sheet2
Looping on Cells $x$y (continued)
WorksheetsEnableCalculation
Help Clear Function
How can I get a negative time in Excel?
Documentation of Excel Object Model and calling it from VB.NET
Re: Program line when charting variances?
Using a form to modify a list
E-Mail Defaultdaten ergänzen
Comparing two ranges and extracting non duplicate data
Copy value problem... if "" then 0
PLEASE I NEED YOUR HELP
how do i set up a web excel worksheet to accept new data?
Loop for a Complex Formula
Whats the Point of Protecting VB Projects?
Export
How do I ensure that all the data is on one page when printing in.
hide / unhide columns
countrysettings
worksheet change event?
VBA Efficiency Question
Data List Visible Rows
Help with adding to a formula
Excel 2000 and 2003 VBA and Macros Incompatibility
Excel 2000 v 2003 Macro & VBA Incompatibility
Excel 2000 v 2003 Macro & VBA Incompatibities
EntireColumn and merged cells
Re: Runnig Excel without visible application
CREATING LABELS FROM 1 RANGE OF DATA
Copy from one workbook to another
upload file name
Query using Excel
LockWindowUpdate
Numbers 0000 will = 0 when converted to a csv file via macro
how to select range when no. of rows depends from text place ??
Error types
Convert listing of events with dates to calendar - Pls help
Schedule taskmanager via code?
Please Help if You Can
Vlookup and no results with the =left(a1,4) option :)
Large Concatenate
resetting custom buttons for macro
Array Parameters as Variants Only
Pivot Table Totals Not Working
Code to fix: 'can't find project or library'
Workbook Row Count Question
Commas in VBE Data Validation List
Re : Excel - Maximum of a Range Row-by-Row
Or...Yet again!
need help for copying among workbooks
Macro / VB / Instert Date Question
How To Call VBA Code from Excel 4 Macro
GetOpenFileName method different in Excel xp/2003 from Excel 2000.
New Function: ConcatenateIF
Performance Impact: By Reference or By Value
Macro filters on different length worksheets
Add-in.
Cell change event
using vba in excel 2003
Programmatically generate name of functition to call
Macro keyboard shortcuts
Time Gentlemen Please
VBA Function that mimics the Access Not Matching Query
Track changes
autofill or copy & paste "till a value"
Copy from one workbook to another
Deleting Contents of Sheets
Exchanging data between Linux and Excel
Deleting Sheets
Finding out whats Protected...
Not enough memory?
counting colored cells when merged
Excel 2002 recalculation while executing VBA Procedure
Excel 2002 With WINXP on a dual processor system
Automation Error
IS functions
Open files in folder - skip if already open
Custom button on custom toolbar wants to re-load "Personal.xls"
Looping on Cells with $x$y
Delete Rows Cut
conditional formatting ... shade cell ... older than today
Deleting Code in 'ThisWorkbook'
End Of Month
Excel 2002 Object Model
macro on tool bar
Delete a Sheet without dialog
Relative cells in different sheets in same workbook
Checking to See if Range Values Add up to 100
fast and simple way to match up arrays
Open JPG and determine pixel width in VB?
Using Public to Pass Variable
Copy a sheet and rename it
formatting based on text
Select specific Data from a cell
Using 'Find' and 'FindNext' in vba
How to deal with Find when nothing is found
Hiding cell values for printing
Select rows and copy to another sheet.
Find Text and put total across from it
cell address within formula
Timer Alarm
Save Workbook without VBA code
Paste into a QueryTable
429 ActiveX can't create the object
"Ready"
Autmatically remove filters from all worksheets
User Form Spin Button
Looping through listbox controls
Further Userform questions
Range problems...
Loop in Excel?
DateValue Trouble
Select column cells to the left/right of active selection - an example
Re-defining Ranges in VBA
Using Date in InputBox for criteria in code
Excel file saved as hex values
Copy to another sheet fails
Problem with Shape Names containing punctuation
Can never edit my projects, everything is always "read-only mode"
If...and... - can never get the syntax correct!
Date question
Chart from VBA
Logical String Evaluation
Call Macro when Cell within Range Changes
Ever heard?
form problems
On Time
Range Values into userform
Using ADO to INSERT Named Range Values into DB
change font of certain cells in row(s) when ColorIndex of Column S changes
average on qty
User Form Questions
Extract and copy Rows where value is Greater than 0 (zero)
Deletion of rows where a value is satisfied for all the sheets
How do I Hyperlink to a hidden sheet in a same workbook ?
UserForm determine WinXP windows style
PivotTable (blank) cells won't display NULL!
How to use SUMPRODUCT in macro?
Invalid Picture Error when user clicks on toolbar
HARALD STAFF - CONCAT_IF
DDE link cache in DDEML library - is it so?
Application.Min - how to ignore zero value?
Text Sum
Need Help - save sheet then hide when....
VBA code help for item tracking.
Extracting worksheet index
Evaluating a Range of Empty Cells with VBA
Pagebreaks problems - Urgent
Find and Replace code in Sheet modules
Visual Studio .Net C# and Excel
Print Same Range on Multiple Sheets?
Pick list on a sheet - multiple rows?
Macro to delete space in front of date
Automation Question
Is it possible to share Excel workbook with a remote user??
Multic Column List Box - Can I add vertical lines to separate colu
sheet name referencing
Whats the difference
Userform Question - is this possible?
Enable macros => HD/CPU issues- help! any ideas?
Creating a "Smart" Autoshape
Reference Libraries
Autorecovery
export excel data to a word template using a macro
Find/Replace based on CF result
workbook in IF statement
Using worksheet_selectionchange to prevent null cells ???
Consolidate data from several worksheets via pivot table
RTD, how do you stop/start it from pulling in data?
Textbox/Userform question
Horizontal line on line chart
search columns, set variable value
loan amortization template
Flash a MsgBox
Question as to why this will not run?
My entire Excel worksheet scrolls down when I hit the enter key. .
Macro question