Excel Programming [Archive] - Page 119

How to display an input onto excel?
I need a macro to delete unwanted data
Hide range of worksheets in a workbook
VLOOKUP Is NOT CORRECT
Creation date is not right
Need help referencing an embedded file in Excel
Save As csv file between Excel versions
Program Understanding
help in checkbox code
Finding MAX number (excluding a particular number)
checkboxes and code
CheckBox Selection
UK date format and combo box
Can't seem to get Combo Box on User Form
vlookup
ListBox
Userform Help!!!!Please
Roesource problem
Return value of heading if an adjacent cell in a row is not blank
how do I view a .pdb file on windows based IPAQ?
Function (array argument, range argument, string argument) vba
Naming Worksheets with a Macro
Make string bold?
Excel Add-Ins... Distribution and Overwriting old Versions
UserForm_Initialize error
character representation of specific column
Small application needed
Copy number that changes daily with macro
Print if there is a picture
Dates and Combo box
Close file and run macro from newly opened file
Are there any solutions for truckers?
How can I rename a Workbook?
Does Workbook.Open ever run from a Function Call?
Runtime error 91 when assigning range
Add to a string to make it continuous
User Form Interface .... really a simple question!
Worksheet change VBA
INSERT PICTURE IN MACRO
AdvancedFilter to Array
Selection or Recordset to Array
Switch to another application
Is the active cell part of a named range
conditional task in Excel 2003 macro
Combo Box
Passing parameter to a query
Worksheet_Change DDE
Worksheet_Change DDE
User Defined Function - efficiencies.
Count How Many Times A Cell's Value Has Been Changed
Auto Search Archive files
Macro to perform Advanced Filtering
Query
Install 2002 & 2003 on same computer
Code error
sort in pivot table
Workbook.Open doesn't leave an open Workbook
List workset fucntions
Search in row
Lists question
finding corresponding row
How do I create a function into function list?
How do I display calendar days in a row
Excel chart source data
Bug in Excel 2003
Copying and transfering select rows of data
Detecting When #N/A Returned By VLOOKUP
Difficulties with SaveAs method
Milti Column Combobox
Macro to insert rows in Excel
Running multiple queries in Microsoft Query in Excel
Display background color of a cell in a Validated cell
Sorting contents of an array
DEEP IN MUD
Controlling an application from excel vba
ATPVBAEN.xls Not Found
Print From Macro Only
Excel Front End for SQL Server
Help using MS Office Document Imaging
Clipart in Marco
Calculate value based on a cell and inputbox
linking list box
Screentip and Hyperlinks
ClipArt to macro
Default in a textbox and change a module name
automaticaly increase the row spacing in xcel
How do I create validation lists which change based on another lis
Combo column identifier
Transpose Combobox ListFillRange
Help with variable
Re: Concatenate problem
VBA and cab files
Keyboard shortcut for formula bar?
Concatenate problem
I don't understand classes¡¡¡¡
MsgBox date & time
Export Specifications Question
copyfromrecordset not working
How to change a macro while running others?
Print to MODI but not display viewer?
alert
lock / unlock dynamically
Adding Sound to Program
How to copy formula from one cell to a range?
Names.Add - Range Syntax Issue
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you
How to make the column in the excel file as read-only?
Help with silly error
Re: Modify this a bit
Enabling more than one option button
Repost: Activate Worksheet
Licensed User - Changes on its own!
Help on EXCEL-VBA-HAsp Key Encryption
Help with some code please
Macro running time
Msgbox when Excel is closing down.
SOLVER macro
simple question about macros
prevent open invalid Excel file
If Then Else Statement
assigning macro to cell
repost: searcing multi excel files...
Problem with Excel DDE
Limit of objects on a form
Problem on Excel Exit
Excel2000: Need help on UDF (working with arrays)
Saving
overwrite
pre written basic macros for excel
This may seem rudundant...
from menu Data-Validation, with List
Why Sheet1 is displayed in modules as sheet1
PasswordChar
Porting of Excel data to SQL Server 2000 remotely
"SaveAs" Generates error on shared drive
help with speeding this up...
NOT static variable problem
Row from address of range
"=sum(variable:variable2)"
I like to open a folder,auto print,save then close
Worksheetfunction-countA----please help
VB Form vs VBA UserForm problems...
VB Form vs VBA UserForm problems...
VB Form vs VBA UserForm problems...
Searching 5 or 6 excel files for specific data...
sorting a column
Screen flicker when changing Image.Picture source on UserForm
Close workbook/excel
ThisWorkbook.FollowHyperlink to Location in Workbook
Macro Help - copying specific data
How to save entire Cell in a variable and put it back later?
InvalidCastException with .NET
Terminating Forms
A double check, please
Edit to CDO email (Ron deBruin)
AUTO_OPEN and Automatic Data Refresh
Using variables to make a date and using find method to find that.
Decent Excel VBA books and some sites
I get a macro warning when there are no macros attached
Incorrect resolution of path to XLA file when user has roaming prf
Autosave
macro on "mouse down" in graph?
Userform - Formating Text in a Label
Removing apostrophe from imported data
Range of a whole column in Cells syntax
Tab Stops
Enter a formula in a cell based on value in another cell
Days in a Month
Activate Worksheet
Conditional macro to hide rows
Rounding Up a Timestamp
click event problem in excel 2003 only
Range as variable
Copy & Delete
The 'other' status bar - that displays the sum of the selection
RE: Copy & Delete
visual basic with Excel- how to move cursor right
Excel 2003 crashing - turn off autorecover?
NOT allow users to save XLS file when viewing over web
RE: Conditional macro to hide rows
Sorry... no Google results!
Create a word file from XL
Memory Space Due to the "Undo" Button
Objects moving when printing
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you
java icon
Formatting all cells or sheet
Refering to Names
select method of range class failing ?
Passing string arguments that have quotation marks in them
Macro to loop thru sheets & return to a1 cell
Concatenate text confusion
After Print event
Checking specific cell, and identifing how many rows in the sheet
Converting Excel to Tiff
Problems when printing to the virtual printer
Compare Macro
Download files without alerts by Excel VBA
IF AutoFilter is on, turn it off
Call a procedure in the workbook from a worksheet
HELP! limit of objects on a form.
criteria for a given date equal or -greater then-
Call workbook function
Problem with the file format xlCSV and a field separator
Loading a Text Box
Change date format
Seasonal factors
Environ Library Not Working on Excel 2000
VB, Pivot Table, Refresh
count number of workbooks open
applying function depending on condition in other cell
How to identify missing libraries in Excel (Office-XP) using VBA
Tab Colour of selceted sheets not changing
Freezed Panes and CTRL+HOME
Outline.ShowLevels
Problems with sending eMail by SMTP
Problem with number lock
Range names -VBA
Apply Excel Program to a Number of Rows
Pasting values from a closed Excel instance
Other option of InputBox for range selection
Data Validation problem
Macro to to get values for specific date and copy to cells
VBA- Is the cell hidden?
Adding times but excluding a time range
sorting in pivot table
Error routine needed
A lot of easy questions.
A constant array?
Select specific columns for a given cell selection
Effective Method to Detemine the Beginning and End of An Array?
UDF Name Reverts to Lower Case
Visual Component Manager for VBA
play sound when opening workbook
Saving two file names? One with no extension?
Looping question
Find worksheet
calculate time/distance
how do find out the column of the active cell in a macro?
"Open" or "OpenText"?
Excel function to search and access database problem
Invalid Qualifier
Is it Possible to create a Message Box (MSGBOX) with Excel Formula?
Printing
ATTN: Tom Ogilvy or anyone else: send DOS command?
Newbie to VBA, Can someone help me?
find and replace
I've deleted all macros but still asked when opening file
How do I use check boxes to determine which worksheets to print?
How to automate extraction of url, that change daily, from hyperli
comparing two columns, help!
Recalculation of User Function when Hiding arguments
Programatically find Duplicate entries
Data Manipulation
Cell Contents controlled via a scroll bar
UserName
Series values from an array variable
Excel 2003 File, New Task Pane
Recorded macro won't run
Conditional Formatting
Recreate AutoScroll
User Form
Prevent recalculation when opening earlier versions
Excel drop down menu
Convert, export, or save Word as an image file (jpg, gif, png, etc
Add-in crashing Excel
Printing
Can you freeze a result in a cell? (VBA needed, methinks)
How to highlight active row and column?
Displaying the Save As Window using VBA
Outline.ShowLevels
Date Modified from an External Internet Source
delete row if no data, non-contiguous range problem
Copy data from Cell to Cell
Problem with a recorded macro to create two pivot tables from same data
Macro Writing
Non-adjacent area selection
AutoFilter
What's in a (macro) NAME?
convert text to data with decimals
Improve code
Combining multiple Excel files into one html?
Further help on delete criteria found
Another Chart Question
How to get a macro to work in different workbooks ?
finding the number of rows and the first row with a specific value
Floating a Chart Question.
Range Names-VBA
Time format and various users
I really need some help Please !!
Length limitation of cell formulas
Simple scroll and select?
Printing selected rows
Assitsance with writing macro to import text report into Excel
one button for many (macro)
zip a email
Look for value in a column and delete
Spreadsheet
win32+Excel
why a workcheet_change function is not working???
Want to create a search gui on wkst1 to seach data on other wksts
Call VBA function from cell
Feedback To The Group
Marco: Pivot Table
Sumproduct in VBA
How do I retrieve multiple selections from a forms listbox?
Excel 2003 - VB Code - Run time error....pls help :(
Year to date
WorksheetFunction.CountA - Excel 2000, Please help
Flaky combo boxes. Work around?
Closing user form in Initialize macro?
Hyperlink in text
Looping through controls on a MultiPage control
How can I put a cell location (ie. row and column #, not value in.
auto_open macro not performing as expected
Referencing .Net DLLs
Cannot copy addin locally error?
How can I get a macro to execute in excel based on the value of a.
Caption disappears from CommandButton.
Array as chart series data source
Populate multiple cells off one equation
linking table
Parameter query
Data>val question
RTD w/Array Formula fails when moving to new PC
Making An Add-in
Inefficient?
Alert when conditions are met
Code problem with text box
Fix Code: Select Case and "Contains" selection
Is there any books for startibg up with macros?
add method of validation failing
Reference varialble value rather than variable name
Window Handle
VBA and 2002/2003/2000
How do I construct a text box which will pop-up based on a condit.
trying to merge historical and current data using a common id fiel
Input date function.
Does anyone have an excel macro that converts states to 2 digit f.
API Call from VBA crashing Excel
Mulitple Excel Macro Users
How to get a SUBTOTAL field from PivotTable?
Addition to Worksheet Change event (RP?)
OldValue property
make formulas from relative to absolute
Need VBA code for Save As dialog
Add-in crashes Excel
Problems copying Autofiltered rows & SpecialCells
Organizing functions
Stopping macros running?
Displaying enteries of a certain type
Do You Want To Know For Sure That You Are Going To Heaven? The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Heaven
VBA function : How to search a string in another string?
Re: Hide Password Technique ???
IF..Then..ELSE.. ELSEIF
print event
Custom Menu Programming
Assign ShortCut-key To Toggle VBA-toolbar?
automation difficulty
Performing actions on multiple worksheets
test (ignore this one please)
How can I determine who has workbook open?
finding values quick
API commands to turn volume control on
Create folder if it does not exists
Select current region and print
How to select multiple ranges in Excel with vbs
using Windows API Open Dialog/Browse in VBA - center form in scree
How to determine an opened sheet( Read Only)
controls.add
Prevent a file being deleted
entries into random cells
How to set conditional format with vba?
Change formats based on A:A cell value on each row - (not with conditional format!) ?
Macro to copy duplicate rows (not delete)
how to add calander control in excel cell ?
[Help] How to merge two charts?
Re: Disable the "X" close button in an excel application
Excel2000: UDF's parameter as cell range OR array
MS-Excel: keep lines (rows) together
Create a Worksheet by getting datas from the txt file with Macro
Select file.
Find do not work with decimal point
Active X Checkboxes
Active
Excel NETWORKDAYS - incorrect results
Sum based on font color
why Microsoft Excel can't support if() multiple choices more then.
run-time error'-2147352571(8002005)
Remove active module in a copy
Function Help
chart help
I have no idea why this is giving me a error: Windows(dataFile).Activate
Microsoft Add-Ins
Running a Macro from a Hyperlink
userform_keypress event
Need to be able segregate units run in excel sheet using time.
Incorporating Matrix Functions From Excel
Data Validation or Pull Down Menu
Copying from one worksheet to another
Embedded Objects in EXCEL spread sheet
ThisWorkbook vs. ActiveWorkbook?
Mailing List Parsing
matching 2 columns
Can you save options selected in Text Import Wizard?
PDF Writer
Moving workbook with VBA between computers
Rename worksheets
XL97 Private Sub Workbook_Open() Not Working
Combobox data accidentally copied on different sheet
combo box of control toolbox
circular reference in VB
Macro to print a hidden sheet
Adding Embedded OLE Objects on a Spread Sheet
list + macros continued
Date last changed by Row
XML mapping in Excel
print long text
CheckBox Problems
Running a macro based on a cells value
summing comma separated values in a range
How check for No/Cancel Button when SaveAs and file already exists?
determining fractional seconds from serial time
Obtain current RGB settings for color indexes 17 thru 27
Rearranging Data
reading from text file to excel file
Re: Disable the "X" close button in an excel application
label does not show???
Big Honkin' Query
copying a range of cells from one worksheet to another
conditional numeric formatting
Simple Array Looping
Option Button problem
Detect external link from unopened workbook?
Textbox edit
Combo problem again
Chart versus Work Sheet Code Failure
Powerpoint macro inserting pictures
A difficult question
Making Excell formula constant
When a cell is change
Custom toolbar buttons
Automatic Archiving
Ranges in Custom Functions
Date
Re: Disable the "X" close button in an excel application
Simple Question
SetFocus problem
Re: keydown event
combo box problem
Help with UDF Function
Re: How to get value of a excel-fields without open the workbook.
Help - I'm sure it must be simple
Macro working well in Excel 97 but not in excel 2003
Easy question?
RE: Complex reports
remove subtotals from pivot tables
RE: keydown event
Macro that draws a chart
Re: Accelerator keys in user form not working
Protecting chart objects
Re: Complex adjacent row value finder - need help
Macro's
create a folder
Highlighting today's row.
Re: Problems programming to the registry using RegEnumKey
Re: Renaming multiple files from *.csv to *.txt
Re: WorksheetFunction.Count
Re: Renaming multiple files from *.csv to *.txt
Re: Renaming multiple files from *.csv to *.txt
Re: Problems programming to the registry using RegEnumKey
Re: Problems programming to the registry using RegEnumKey
Re: Disable the "X" close button in an excel application
How to select cell and have time or date appear?
Copywrite spreadsheet
Creating a macro
If Cell Not Number Than Specific Word?
Copying a sheet from an addin into an open workbook
how do i use excel to check my lottery numbers
VB for importing data into excel in proper columns
read a Unix binary file
using IF and AND conditions in a macro
Filtering Data
Dynamically create a formula in Sheet B referencing SheetA
roundup, ceiling or whatever
How to increase number of "conditional format"
ISERROR function
Named range
Copy FormulaArray
Printing Word Document from Hyperlink -- Can't get the full path!!! Please Help
Naming vba Buttons
color of active cell
Excel VBA - How to enter a reference to another sheet?
VBA UDF Writing data to spreadsheet
Error 94
User form in copy of original file
Blinking Label on Splash Screen
Formatting chart TickLabels fails to include time with date
Excel Array Conversion from 2-Dimensional to One
Do You Want To Know For Sure That You Are Going To Heaven? The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Heaven
Relative address equations
Deleting cells in a row
IF statement in a macro
FORMULA IN EXCEL
Change event macro
wRITING A mACRO TO MAKE A WORKSHEET PRINT.
Excel VBA for Global Address List
Working with headers in pagesetup
combo box help
Once-only Macro
Excel cells that flash info
Sendkeys
how to display specific data in a Pivot Table
Playing sounds on opening a worksheet or shortcut
Automate Access from Excel
Question about worksheets in an AddIn
Question about worksheets in an AddIn
Remember last selection?
Find method
eof
Date formatting issue in user form
Preparing Workbook for user input
ComboBox Issues
Another ComboBox Issue
Another ComboBox Issue
If sheet not created show a message
Pivot Table - display only sum and count if greater then 5
putting graph as Line
Currency format for combo box in a user form
TAB STRIP CODE
Heeeelp with combos¡¡¡
Adding Qty based on Item
Formatting and sorting cells with VBA
Do You Want To Know For Sure That You Are Going To Heaven? The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Heaven
Problem with find method
An Array Lookup Formula
Formula needed for date range
Form Controls; setting properties based on cell values
Log users opening the VBE?
Which ActiveX DO Lib?
RUNNING WINZIP32 FROM EXCEL
Is there anyway to hide #DIV/0! in an excel worksheet cell.
ComboBox Problems
precision question
Help! I Deleted my File Menu bar Control
Option button
click on cell it goes to formula location??
Default Value?
Request for Excel Formula
Sort Data for duplicates
Relative cell ranges
Switch focus to inactive userform
macro
calling web service from excel 2000
autofill with best match
Reference Calculations
Column conversion
Sort data then delete duplicates
Macro if greater than letter then delete
Need formula to calculate average monthly percentage of change...
Strange Range.item behavior?
Data on the clipboard is not the same size and shape as the selected area..
Microsoft Excel 2003: Clicking on a LINK that takes you to a different cell in the Workbook
Overflow Error
How can I run a query(dqy file) from an Excel macro
blank rows
AutoFill columns
Confusion about how the Window object fits into the Excel object model
No Returns on Fuction Call
Conditional Formatting
UserForm Calculation
Variables
Button vs Command Button
Saving A File
loops ...
Latest date
VBA Project Explorer list
Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range)
VBA command for edit cell mode
Printing to header/footer programatically
determine pagebreak using VBA
Track changes
macro'S
clipboard
Prevent deactivation of sheet
How to store hidden binary data?
lookup for a combo box in VBA
Need 2 create userform that uses data from rows...HELP.
Preventing cell from being empty
Reference.
Fun Excel applications wanted
How do i create a popup window (a macro ?)
Add Sheet - Copy Worksheet
On Events
Form places number in database from combo box
sql query for excel column values
Copying formats?
Duplicating cell properties
Compilers for Excel to create exe programs
Repeat Data
Toggling a Command Button
Comparison or two sheets
Copy Method
Getting filenames via VBA
dynamic input from a text file pavement elevations
How to call a SQL DTS package from Excel spreadsheet
Extract Data Validation Input Messages and Titles
pasting screendump picture in VBA form
Linking cells by cell text.......................TIA
Storing cell location
Reversing names and sorting
ListFillRange linked to named range in a closed remote file
Re: How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
Insert and Delet Rows between pivot tables on a worksheet
Return Activecell row number from another sheet
RE: Cell tests for upper case, and certain #'s
Excel VBA Newbie
Calculate value based on a cell and inputbox
Macro for a comparison
SUM PRODUCT ACROSS WORKSHEETS
HOW DO I program one worksheet to get info from another?
Displaying values on graph
setting a copied worksheet
searchwords in same row?
Re: toggle button & event code
Lookup part of a cells contents
Re: Cell tests for upper case, and certain #'s
present data as hierarchy/tree structure in user form
selecting range of cells - variable # of rows
Re: Need a property that will give me true if a value is close
plz help: creating named range in VBA, loop goes haywire
Move sheets To New Wbk - recover workbook
Re: formula question/elapsed time
having trouble writing string to cell-xl2k
Fixed Decimal point
Re: Pasting pictures from Excel to Word (2000)
Re: how do set up a database to prepopulate details to a form in exce.
Re: Automation Error(-2147467259) in Properties Collection
Re: Automation Error(-2147467259) in Properties Collection
Re: Conceptual Question about ReDim
Re: Conceptual Question about ReDim
Re: Custom Function - Adding Help Information
Re: toggle button or worksheet_activate causing form to open twice
Re: Environ function.
Re: User picks a text file, macro defining the array
Macro better solution than cell formula with date?
how to catch errors from outlook
Re: Application.Calculate & VLOOKUP
Loading a spreadsheet from memory
Re: average
cell vs range problem with formula
Run external program.
Re: How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
Re: Application.Calculate & VLOOKUP
Re: How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
Pivottable Pivotselect string
Hide tool bar
Changing Named Ranges
Put a predefined name range in to a ComboBox in a Form (VBA)
beginner problem: getting selected rows, row by row
how to get some rows and columns on every printed page
Web queries and Excel
Search for Value from InputBox
RE: My VBA code works in the step though mode but not at full speed
I need help writing a macro to replace cell contents. (new to VB)
sendmail works in excel 2002 but not 2000
Missing help in Excel 2003
Printing
Sorting problem
RE: How do I get a form to lookup data for 3 different controls? (co.
Creating Calendar appointments
MS Query in VBA
SQL Server Listing and SQL Databases
Value of next visible mycell within a rng
Do...Loop not working
Re: My VBA code works in the step though mode but not at full speed
Re: FileSearch & .zip file
RE: Toggle Button Updating Concern
Re: Need formula that will read time as min:sec in excel
Data Validation in Cell changes Range ID?
Subscipt out of range
Re: Looping through a Type
using the clipboard to avoid VBA / Interop
Re: Looping through a Type
Using VBA to create (complex) charts on the fly
XY Chart with many curves: Independent legend entries?
Calling an Excel/VBA User Created Module from WSH
Opening Files Using VBA
status indicator on screen
Re: Look up function
Formatting unlocked cells on protected sheet
Multipage Userform Events
Message Box
Re: Saving FileName
Re: 2 Timers
Re: Turn off confirmation messages via VBA
Re: Turn off confirmation messages via VBA
Re: triple state option buttons
Please Help, Newbie VB programmer
Creating a list from 2 or 3 different worksheets
If Checkbox checked/notchecked then
Getting protected external data
Re: Changing cell values
Re: Automation Error in Excel VBA
Move Rows & Append
Select copy and paste
Re: how to call a form
Re: Can Excel interact with other Windows functions
Need help w/ programming an Exel addin
Re: Changing cell values
Re: Trying to toggle visability of button
Re: Running Macros when opening Excel
capture DDE update value in VBA macro
Re: Trying to toggle visability of button
Can I determine in which cell is a listbox postioned?Or how to get the listboxes in a certain cell?
Re: Getting a list of filenames
Re: Getting a list of filenames
xy-chart with dates on x-axis
Excel process stays in memory after Using Quit Function
No control for option buttons, invisible macro??
Re: Running Macros when opening Excel
Re: How to write a autosave macro for a shared workbook?
Macros reassigned by XL?
Storing a column of input data
Re: Flashing Text or message
Re: Flashing Text or message
Ctrl+Alt+Break
Re: disallowing blank cells
Import External Data w/ CSV & Line-Breaks ...
Changing a cell color based on date entry ...
Switching calculation to manual using Workbook_open
variable/Input box problem
Pivot Chart Series description
Using variables when copying values between worksheets
Get worksheet names
Hide and Unhide rows automaticely
Format columns using a variable name
retriveing old AND new value of a cell in code
how to use offset with non-adjacent named range
Save as CSV
Save Workbook Problem
group results by certain value
Excel Data Validation Lists
Change Pivot Table's query
Error control?
Re: copy/paste will work seperately, but not in the function i've writ
locking a cell after input
Passing reports to PowerPoint?
Boolean Question
Getting Data out of a E-Mail
Re: CLEAN Formula in Excel
Create new worksheet from exisitng data
Re: CLEAN Formula in Excel
Worksheet close event++?
Re: Copy same range of data from all workbooks and paste into consolid
problems with a form and a cancel button
Re: Copy same range of data from all workbooks and paste into consolid
Re: Copy same range of data from all workbooks and paste into consolid
Worksheet close event?
Shift data to left
hyperlink with more then 255 characters?
Displaying zeros as dashes on a worksheet
Pivot Table Field Settings
Hex2Bin in VB
Script to insert the next Friday
How do I access a Pivot Table using VBA for EXCEL when the pivot .
RE: excel macro problem
Looking for a Next friday Date Script
ShowModal property
RE: Looking for a Next friday Date Script
RE: excel macro problem
RE: Script to insert the next Friday
VBA: Device I/O error (Error 57)
copy worksheet and replace
NTFS file system
Excel OLEDB format problem...
changing a SendKeys "(^+{home})" to a function
Milliseconds in Excel
Problem with Select Case construct?
Prtinting antoher worksheet
Thanks Bernie
Changing VB Component Names to match Worksheet names using VBE
Combo Box Problems
Customize the right-click menu
What is wrong?
Application is already Calculating during a "Change" event
Count entries when two criteria are met
OpenText Method failure
Cant view excel worksheet in web browser
Pivot Tables : Total Time incorrectly computed
Pivot Chart and EnableItemSelection
variable for path name in ODBC connection
AutoFilter, Looping through the Rows? (Newbie)
Deleting certain string within the string
Creating Charts in VBA Code
Sharing a custom function bewteen workbooks
Protecting (hiding) the Code in an Add-in
Printing List Box Contents
How can I programme excel to create and send an outlook meeting request?
Does ActiveX control on spreadsheet exist?
Can you get the range reference for each page in a worksheet print range?
MS Query - From in SQL
Add-In Problem
Can I print only specified pages from a print range such as pages 1,3,4,6
Decalring Workbook level arrays.
listbox problem #2
Selecting All Text in TextBox
Checking a Date format
Row autoheight for merged cells
Schedule sending an email on a particular day picked from excel
EXCEL AND VBA
External Data from Stored Procedure with parameters
Changing formula programmatically
Compatibility Excel 2002 and 2000 in automation
Max with similiar values within the range
Selecting data from column heading
Patrick- do you still have the file
How Can I send customized email content by Excel VBA
pivot table, vba or ???
Basic info I have forgotten....
find last row in another worksheet
Error 1004
AWESOME MOVIE! << I found this movie link in an AOL chatroom. It is based on real evidence and I give it a big thumbs-up.
Form Combo Box, Protection?
can SUMPRODUCT Do this
Problem with webbrowser control
How do I copy a range of cells in Excel using variables?
IF/OR Functions Together?
Disabling 'File/Save' Menu Item
VB to set a constant in another procedure
vba sorting stopped working
VBA error code
looking for a function
create a fill-in form using a scanned-in semi-transparent overlay
ClearContents command causes routine to stop
Formula's don't work until I "touch" them?
looking for a function
how to automatic upload data between excel spreadsheets
Digital Certification verification
Global range name
Copy a code module
number less than 100
Duplicate data in row 2
Public Variable in ThisWorkbook
Delete row based on letter
Write a bsice macro
using match in vba without assigning a cell
Whole Number Validation in Input Box
Use array to do advanced filter?
Thanks Tom Ogilvy
Macro syntax - how to find them
Change Cell Background color when Cell changes
problem on passing value
Argh, trying to put " and & into the formula is driving me nuts!
ByVal Target As Range
Printing PDF from Excel
Print to PDF from Excel
Email from Excel
Macro help
Calling functions in different modules
Numberformat: automation from MS Access
Change cell color dependin on date ...
Automatically Display a data input form when active sheet changes
Sending rows to another worksheet based on value of cells in column A
Insert comment behaviour on custom shortcut different
What are the values for ColorIndex 's 56 colors ? i.e. green=3 .
Problem with Excel list box
Clicking checkbox Changes the Label Font
How to detect Internet connection
how to set range in excel
Database Querry
VBA Question
Forms?
built-in function doesn't work properly
Microsoft Windows 2000 Scripting Guide
Microsoft Windows 2000 Scripting Guide
Generating another worksheet from existing two
Automatic Downloading of files (PDF or HTML) using Excel
Back color of dynamically-created buttons
CommanButton Caption Orientation
Uninstall Addin
What is the formulae to write a work timecard in Excel
Sheet NameTab Protection
fixing the result of a formula after a certain date
How to dynamically add a reference to personal.xls ?
Test if spreadsheet id open in IE
Build lists with non contiguous cells
I want to be prompted for an entry that already exists in excel
Charts and Userforms
Find string and format 54 columns to right
Conditional sort
job openings for programmers
"Remember" second last clipboard?
List all Addin Project Name
Creating a Database with VBA
numbers in chinese
Object Error
worksheet_change or worksheet_selectchange ?
Excel / Access ODBC connection
XLA versus Reference versus Nothing
Based on Data in One Column, need to SUM another
acknowledge divisability of $20 indicate mathematical results
Application-defined or Object-defined error
Email from macro problem
Lookup Value2
XLA or Reference or Nothing at all
Lookup value
How to use Access tables in an Excelapplication?
On Error Resume Next
Referring to a sheet
can anyone help me please?
Update Chart data Range with VBA
Action after Activate a cell
Distributing an Excel file
simple ? problem with value or/of formula ?
Keeping original data format into a Pivot Table
VBA code manipulation cells
activate marco command
Application.Cursor = xlDefault not working
Re: Conditional Formatting
Looping through visible rows only
Blank progress bar
New from Template Issue
Mapping Tables.Fields from a data source to my MS Access Table Structure
InputBox a date
Evaluate using a variable - Help please
add data to a closed workbook
Opening Dabase with Password
Run macro problem
Controlling the windows taskbar from VBA?
Creating a macro by using Excel
import external data, web query
Break down, rebuild a matrix
Binary numbers longer than 10 characters
Open a workbook
Using a Userform instead of Data Validation
Toolbar Menu problems
Opening files in other programs
tricky one to match between 2 s/sheets
Excel vba
Help with Hours Minutes Seconds Please
Custom toolbar xl97
Please help with code?
Read write non contiguous cells
msgbox yes or no
MacroOptions doesn't stick
Excel 97 Enum
change by value in drop down list
Nameing a range while still selected from copy
SQL.REQUEST Calculation Order
can i create barcodes in excel 2000
choice of reference link option?
Selecting and editing unlocked cells problem
Storing Data in Access Database...
Array / Looping Question
Prompt user for a filename
Date question
Referrencing columns by header and from different worksheets
Shorter Sub
How to get data from comment
Re: GetOpenFileName help
Programmatically creating a map from data in Excel
Prepopulating a dropdown list in excel
IE history
Need Help with a File Search
Macros
XmlMapQuery and XmlDataQuery Samples in Excel 2003 and VB.NET
Trouble using the { } in array formula (for multiple criteria)
Saving space in Array formula Sum(If(())...
Loop through a range
Recording the 1st Change in the value of a cell
referencing a named range from a closed workbook
How do I change the size of font/display in a dropdown list I've .
Print Preview and Changes
How can i read from RS232 using a macro (VB)?
sum column A based on column B
For Each Loop w/ a range
Extracting data from alternate rows
print ptoblem
Save As
Sending data back to parameters
Best way to display a subset of data in a web page
Protection of confidential data
Can I make a cell change colour automatically
How do I count blank cells in a column of dates?
sheet.activate
Import csv files, delete rows, arrange columns ....
Do not display information in cells
cell addresses
eMail problem
Delete Worksheet.
Open MS Office Outlook
Car assign simulation
Automation behaviour - strange but very useful
Simple Tables in Excel
Create/Remove Custom Menu Items from Add-in
calculate remains in status bar
Conditional cell coloring
Simple macro needed to export a worksheet
Need help on "Aligning text boxes in a chart sheet"