Microsoft Excel Programming

Re: Run macro in one open workbook only
RE: Code fails if ran more than once
Re: conditional questions
Re: Error 1004- In a PC with softwares in German there is no Error
How to Create Control Array at VBA Excel
Re: Control array problem
Running SQL queries for Access using Excel VBA
Need sample code
Re: Replacing subtotal with a formula
Re: Validate InputBox entry
Re: Messages at end of file
Calculate Time
Help importing data from a closed workbook
Worksheet_FollowHyperlink
Deleting sheets
Cell update to run macro
Deleting Pictures
Need a copy macro
Entry in One Cell Updates Another
Re: Modify code in UDF
RE: Help! Limit on number of Ranges you can use at one time?
turning selection into a range
Re: copy value from unopened workbook
Re: Number variable loses format on write
Re: Speeding Up Code
Re: Write Data from Sheet1 to sheet2 Until
Re: How to lock the clipboard
Re: Addressing specific textboxes on a form
Re: number of copies in a print dialog box
Re: find and copy cells to different workbook
Pickfolder Method with Userform
VBA to unhide columns
Drop down in local Gujarati fonts
Re: Quotation Marks
Macro for coping cells from one worksheet to another
what is an OLE action
Sendmail not working when computer is locked
Re: building new workbook from sheets in different workbooks
Excel Automation/Using xla file
Re: Validation List Question
Re: OnKey query
Re: Event Triggers
Goldmine
Re: Vacation Spreadsheet- formula not working.
Re: Casting in an Excel ADO SQL Command
Re: Whole Fraction
Re: Transfer selected rows to sheet
won't select cell on another sheet
RE: Select method of range class failed, Run time error 1004
RE: copying values in a range
Delete then Concatenate
vba problem lookup in a matrix
Re: Excel Macro to change row and font color based on column value
Re: Excel Macro to change row and font color based on column value
dropdown list...where did it go?!
Re: Dynamic userform. Problem with format, events and returning values
Re: Can someone help me with this slow code
Re: Keep y-axis aligned
Need Help with excel
Re: Directing a Save As in VBA
Re: Detecting when a user deletes a row
Re: Modify a excel link
Re: setting range().hidden=True causes range error 1004
Re: setting range().hidden=True causes range error 1004
Re: how can hide and show columns using macro?
Re: find and copy cells to different workbook
RE: Error in Code - Pasting Values
RE: Change in cell from formula to auto run a macro
Re: "cut" textstring
Re: Version issues
spreadsheet with multiple worksheets?
Or Like
Re: Macro that unprotects worksheets, transfers data, then reprote
Re: "Insert" Macro
Re: multiselect listbox backcolor
Re: multiselect listbox backcolor
Re: Directing a Save As in VBA
RE: move a special character
How do I find all named ranges in VB.NET?
Re: LastRow function - #VALUE
Possible to hide column headers???
Re: Application close problem
Calculations
Re: Group Action of CheckBox Control in Excel 2000
RE: How to execute a macro automatically at startup of Excel?
Re: userform and spreadsheet formulas
How to write a function or macro to copy
Macro function needed for varied searches using a data filter
Re: Count every 5 row that contains text or data
Re: Rici
Re: VBA - Entries Into Properties
VBA - Base 34 Conversion
Cursor cell in colour
Re: Flashing Cells
Re: SUMIF
How do I exclude zero's from an average of five non-adjacent cells
Transparent picture background
Re: Baby steps
Doh!!
** 60 GIG Photo iPod, Why Pay for it? When u can get it FREE! 100%Legally! ** Super Easy Proof inside!
VBA Code works in Excel 2003 but won't work in Excel 2000
Re: Capture a cancel button
Files and Folders check
Re: v-lookup error
Re: Disable Tools, Protect, Protect Workbook
Re: closing userform automatically
RE: Telephone number data type?
Re: Remove Autofilter
Re: userinput is wrong (check in vba)
Re: error message: compile error, argument not optional
Re: how to keep focus on txt_box in userform
Re: Using a Macro to delete all rows containing #N/A
Re: VBA Code works in Excel 2003 but won't work in Excel 2000
If, or on 3 conditions
Re: Copy and paste between workbooks?
Re: access specific areas of a protected worksheet
Re: DLL Entry Points
my first attempt at R1C1 in vba
Re: Animated selection border
To Multiple Excel Files
Re: Email question Please.
multi text search question
File encoding problem
Export Linkedcell
I need to verify data from 2 different worksheets how do i do it
I want to verify data in 2 different worksheets
Error Handlers
Inserting value with increment by 1 from previous value
There has got to be away!?
Re: CREATING E-MAIL ATTACHMENT WITH 'BeforeSave Events' IN CODE
Re: help me write this table retaining table spacing and formatting
Option button help
Re: Retrieve individual cells from a range changed between a range
Know exact position of a cell in the Sheet
Re: I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN
Insert right pointing triangle
Tips for copying picture?
Re: Lines in cell?
Re: Sending Email From Excel Help!
Re: Import data from two workbooks with similar names
Re: Custom menus in chart sheets
VBE causes excel and word to crash when closed
Re: Freezing the top line of a sheet with visual basic
Re: Option Buttons/Refresh
form.show switches to debug mode
Re: Disabling the red X on the top right of a form.
Re: SetSourceData Source = pivot table on same sheet
Generate auto increment number from VB form
Names of Grouped Shapes
Range names
Make date show
Re: Option Buttons/Refresh
partial derivative of a function
How to run a private sub in the workbook from another workbook
Re: Modify the last active row
Enable grouping in protected worksheet
Re: Modify the last active row
Formating X Axis on Chart using VBA
Copy outside Clipboard contents (html page) to a cell in Excel
Parent Folder
Print all pages in a Multi page userform
Sight Unseen
Fix or touch up heading so that it could be imported by Access97
Save Worksheet as Text File
VLOOKUP 2 CELLS
Create mirror workbook???
re : Possible ???? Pls help
Sheet scroll based on variable
automatically copy selected data from one excel to other excel
Re: Simple multi-password access
find first data entry in range
Save file as sequential
UserForm PrintPreview & Print buttons
Value or formula in cell depending on input...
CubeField Member Properties for Excel 2k?
Data validation with several fields
Excel 2003 changes protection when saving
Generating inserts out of 1.5 million records CSV file
Select specic no. of rows down
Add a tamplate sheet automaticly when I have copy in a new sheet
Excel Userforms Textbox query
Macro To Create Hyperlink from html text
Range.Insert query
two space rounding
Using a macro to delete all blank rows
Re: What is the name of this function...
Re: Can't run codes linked with Userform
Using VBA Functions in a worksheet
need macro\method that would allow user input to a data filter
How To Create a Document in Excel from a Template, Using a Macro
Sumproduct.....
Re: Formatting Data Columns of various length with Macros
Re: Using a Macro to delete all rows containing #N/A
How can i combine combo boxes
Re: Make a cell value include number formats
Re: How can I assign a varable to equal an array? (it allready has a name)
Need help with Add-ins!
Toolbars: Hide now, display later
Return Information from Shell Command
Autorun a macro
Conditional formating
Control Not Licensed Error
Distributed Addins
Last record in collumn.
Re: How to avoid saving over an excisting Workbook.?.?
Excel Filldown problem
Re: Definite mind-twister for an Excel MVP
Formula
Re: Combobox question
Excel and VBA how to call a procedure from an excel "cell"
save as latest excel format
Re: How do i read Selection.Shapes.Range(Array(i)?
Running VBA Code not written within the currrent worksheet
Easier way to insert columns
Macro help...
Empty Date
Beginner needs help, Look inside!
OLE or Automation Printing of Excel
Print Sheet Array from List Box
More combobox questions
Macro Help - Deleting two characters per line!
Keyboard shortcut to auto insert $ sign into formula?
Copy and Past to Differerent Work Sheet
Tough Excel/Access/Windows Problem, need Help!!!
Problems with a formulas
Question about intervals and results
Can Anyone Explain This?
Excel VBA Need to rotate players - find / copy last 3 rows and move to the top
Update and Add
Time Help
Input Box Help - Validate Date Format
Combo box
Re: disabling a cell in excel
Trying to revive this question... Help :)
Re: Excel throws exception if cell being edited
copying value into alphanumeric table
Re: MultiPage Form data not displaying when Value property changed
colouring cells that are between two dates
Shade cells with links to external workbooks
Exclude some worksheets when using UsrSht function
Re: Module name change
Excel 4 macro conversions
Re: Find, highlight, mark, cut and paste macro
Please help with Macro
Re: For Each x in Range
Re: MultiPage Form data not displaying when Value property changed
Log uses of Excel
Application.WorksheetFunction.Match
Working with an array
Stumped - What am I doing wrong?
Re: For... Next
Re: Security setting on Low, but Macro will not run?
unique filenames in macros
Function Key F5 - go to reference
basic
Modify a Worksheet
Simple constraint problem...
Auto Open sheet function
Using workbooks
Separating a string to two fields
Command Button Freezes on Reopen
How can I delete multiple sheets in VBA...
List of File Saved
Mesage based on table
Re: End and Sort methods adding blanks
Re: Ignore Other Applications" setting
RE: MSG Box - Stop Macro
how do i set up a Cobol Comp-3 data field in Excel?
Sorting with a list
RE: problems with a userform
RE: Activitate sheet 1 and make all sheets read-only
RE: macro that opens a number of workbooks and close them
RE: problems with a userform
Suppress Save Dialog Box
macro that opens a number of workbooks and close them
MSG Box - Stop Macro
Save As selection in Active Sheet
Row Color
RE: spelling check on a protected spreadsheet
Activitate sheet 1 and make all sheets read-only
Printing Selected Worksheets
problems with a userform
search and extract within text
Defining a Property
spelling check on a protected spreadsheet
Worksheet Protection
USE MACRO TO SAVE WORKSHEET SELECTING FILENAME FROM CELLS
Circular reference error
dynamic combobox
incorrect Format Date mm/yyyy in excel 2003
Expressions in Microsoft Query
How to remove and old Add-in from list of avaiable Add-ins
Excel split window refresh problem
Programmatically putting text in title without using labels
Re: Prevent Sheet Deletion
Selecting Columns
Re: Invoking New Workbook in Excel Task Pane
VBA for excel
Re: Disabling the red X on the top right of a form.
Getting my VB custom functions to support usage within an Array Formula - How do I ge
Excel VBA Library
Excel VBA Library
How can I specify workday capacities in a dynamic calendar???
Dealing with a Locked Cell
separate text and digits within a cell
Pass a variable into a range?
Wait less than a second
Printing multiple ranges w/o page breaks between
AdvancedFilter on cells with formulas, returning values and not formulas
How do i know the name of current view?
MsgBox To Read A Value of a cell
don't want to have page breaks in union
Re: "currentcell.value" not working when numeric? => ...
summarize
Newbies and Menu Bars
Allow disabling of password, but no setting of password
SaveAs Maceo - Specify Folder it Autoselects to Save In
Show values only in a pivot table
Class module question
Re: Copy a row from one sheet to another and not all columns copy
Macro to copy internet page
Trouble with Arrays / Collections
Grrrr...Range on another sheet trouble...
using offset in autofilters
Why can't i filter two different columns with different criterias like this
Deleting an entry from a ini file
Custom Menus in Chart Sheets
R1C1 riddle
RE: Range Value ie: (A1:A100) The Option of?
Working with files in directory...
Re: Command Bar Tools, Protection Protect & Share ID
If statements
If Then Else
Re: Runtime error 1004
Range.FormulaArray drops relative reference ?
Shading Rows
Re: Excel Command Line Options
Sorting a column
set up a pause in a print macro for user input
Listbox columnhead
create a pause in print macro to allow user to select printer
Re: Simple Declaration Question
XLStart and VB
RE: Simple Declaration Question
Re: Excel Command Line Options
test for field that just has spaces in it
XML mapping programmatically
Compiling Excel 2003 application written in VBA 6.0 Code
Time displaying as decimal
CHECK BOX HELP NEEDED PLEASE
sheetname search question
Error Code 6
Sort by colour
Re: Inserting rows at variable points
Re: How to click the button from module?
Excel file as an executable?
Re: Macro help
Retrieving Data Problem
Re: Macro help
Help
Need Help: 'sheets' function with a variable in a formula
Hide AND Exclude?
Re: Delete a selected area from a non-contiguous range
Re: VB for conditional formatting more than 3 conditions
Adding image
Re: Question
Data Retrieval
Re: EXCEL VBA tutorials
Re: How to disable the scrolling in worksheet
Pagesetup. Is there no way to control the LeftMargin of the LeftHeader ?
Re: Copying values from cells if another cell contain value
Re: Application.wait... won't!
RE: Application.wait... won't!
RE: Using ADO to run an action query from excel
Automatic saving of worksheet with unique names
RE: Any comments on TurboExcel?
Using Find/Replace in Visual basic to adapt the code
Re: Excel & VBScript
Possible to have sheet to convert roman numerals?
2 Things, CommandBars & Windows
Run-Time Error 424 - Object Required
Capture Network Domain Name
Deleting rows with VBA
Print Button
Re: Application.wait... won't!
How to make chart embedded in active sheet?
Comparing Text to Numeric Vals
Re: Format of CSV File in export
Re: Test for an empty selection
Clear Clip Board Memory
Re: Test for an empty selection
Pls Help Me!
InputBox
Re: Character Limit
Re: "Outlook.Application" vs "Outlook.Application.11"
Re: Personal Macro Workbook
Re: Macro execution time
Selection
Re: How to delete all page breaks?
Re: Activating workbook without naming it specifically
Please Help!!!!
C# open xla file with automation
Create Format documenr from Web With out Installing Excel in Serve
Re: CHECK BOX HELP NEEDED
RE: I'm just starting to play around with VB and would like some h
Function Call Specified at Run Time rather than Compile Time?
Module name
Removing column borders from an invoice
Sort Question
Greyed Out Graphs...
XL - Oracle Connection error
VBA fault finding
error
Simpel commandbutton question
If a formula is too long then refer to the cell after a TRUE resul
Finding the last nonblank cell in a column in VBA or VSTO
Help with VBA Password
Conditional Formating by truncated values....
return data to specific columns?
Re: To copy from a range in another sheet to the active cell
Extract data question
Re: Duplicates, Comparison and Condensing
SourceData for graph
Re: tranfering value if...
RE: Incrementing Rows in columns
Runtime 1004 Sort method of range
Re: Format of CSV File in export
Re: saving option
Application run help!
Efficient Copy/Paste
Creating TWO-WAY E-Mail Attachments with 'BeforeSave Events' in Code for 2nd E-Mail
GetSaveasFileName
PivotTable Pivot Fields CurrentPage
Macro Security
Deleting Cells
Re: Find, highlight, mark, cut and paste macro
Excel 2000 VB
Re: Excel & VBScript
Add Password Using Access
Passing Arrays in User Defined Objects
Listbox and Collections (Again!)
On open, resize page
Delete Unwanted Macro1 Sheet
Links Utility
R1C1 Helper Instr / Mid
Macro / Custom View
Tiering Macro, Should be easy?
Disable Sharing mode in VBA
VB script to sum up amount
Need loop help
search and offset?
Re: Saving macros
Re: Write " to a string
Confusion with security
use macro to hide or show bitmap image
Why doesn't this code compile?
Looping
crash on second pass of loop
Problem with Workbook_BeforeClose event
Is this possible?
Macro hangs my excel (not responding)
Are 2 dates between today's date
Inputbox question
Keeping excel visible
Insert Picture Macro
how to replace drawing with text in that cell
Re: Error Trap
What is causing "Block if without End if" error?
Rounding currency
Automate a button click event
Type of macro (Excel Version 4) that cannot be disabled?
Question about ExclusiveAccess
VBA Macro Versions
Why isn't this macro giving me proper results?
Need help writing Excel macro to solve a cell in each row of a spreadsheet
Copying Data
Need formula - conditional formatting - ran out of conditions!
user-function not returning any result (newbye)
Re: worksheet looping with varying labels (aka Need to Find the John!)
Re: excel autocalculate result in status bar
Compare Multiple Numeric Values
RE: LOAD userform
My Microsoft Office Excel 2003 disappeared
Include Excel Application Inside Winforms
combo box pupulating macro
commandbutton_click problem
Like to put it in VBA please
I have no Idea how to do this in Macro.. or if it can even be done easily
HELP! - Can't Copy Cells With VBA
saving changes to addins
Closing a external legacy program using VBA
Adding and naming new worksheets
Copy two sheets
Need a way to display a descrete number of rows from a list.
Code to different object models
How can I remove all traces of XLM macros?
Looking for Excel VBA gurus
how do I create a macro in excel?
excel object in visual studio
How to make a new function category?
Re: Closing Excel Safely within a Web Environment
textbox trouble
RE: Automatically Create XY (Scatter) Charts
Adding Objects to PrintDialog
Return to Excel after shell an application
Put MsgBox text in a worksheet for printing
check if file already is open
Verifying Printer with Excel VBA
Record a Macro through VBA
Automatically insert signature in worksheet
restructure long to wide
crystal32.ocx
Run macro on cell edit
Resize Comments Box
how to open xla file in automation way with disable macro
List of all Macro's in Personal.xls
method 'open text' of object 'workbooks' failed
Dynamic pie chart color
Scan a Directory
cell validation with list drop down by using a makro - Excel bug?
Change year value in a date column...
Fill Down
Time sheet with 52 tabs
User select row?
How to modify loan amortization template
can com port data be imported & sorted into cells?
add column of numbers for each row
Reference Issue
ListBox value limit
Add value to conditionnal formatting
Macro to clear combo box values
Pass parametres from Excel to Access query
Is it possible?
Automatic top of sheet?
Subject: Excel VBA .Lookin Error 9/9/2005 7:14 AM PST
Printing Multiple Pages Based on Different Cell Criteria
Arrays problem
Interact with Spreadsheet Model via the web.
FOR Statement Issue
Toolbars
Class Module vs. Arrays
control formula with a macro?
Run-time Error '1004
Macro codes security
error on second pass of loop
Spreadsheet with multiple tabs, same headers
Importing excel values to word document
Macro add Hyperlink formula
How can I run my spreadsheet on someone else's computer?
Create new book..paste data..save..close
Date Copy and column adjust macro
How to make a multi-column label?
Adding quotes around text, i.e. "text"
protect/unprotect worksheet
SetFocus problem
Creating PDF Files
error '438'
Hiding a Button
List box ' VBA
Run macro but let user update spreadsheet while it runs
Linking Multiple Cells $$Hire?
Automating production book creation - many procedures to run
Password Protect Macro?
Thanks a ton, Bernie!
prevent saveAs dialog
Macro for copy Word into Excel
Syntax of If statement in before print event
Is scripting the way to go here?
PASSING VARIABLE TO .xlT FILE FROM .xlA FILE (CONTAINS 'Auto_Open' PROCEDURE)
Forms
compile error: Expected: = ...Why?
Excel forms button "click"
Question - Repost
Encryption of data in cells using AES 256
Copy Cell from Row Above
ComboBox Problems
How do I remove a non-toolbar custom button from a sheet?
Need help writing a printing macro
VBA Excel: Problem w/ Loop
webquery-cookie problems
Trouble with Formula in Cell
Opening Excel - File Error
input box that ask for...
Formula Help with Lists
Autofilter protected sheet
copy rows programmatically from one worksheet to another
Unable to set installed property of addin
Buttons click in Code
Input box that ask for web address..
Checking dB for New Records Using DAO??
Worksheet_Change Not Detecting DDE Updates
Change reference style in line of code
0.25
Range problem
Saving ranges as GIFs
Sum Formula
How to reference a Class Module located in an add-in or another workbook?
Excel <> HTML Web page - How ?
Picking up Date formats for use in Filenames, Etc.
Hide and Seek
The missing link
Add to sheet
Creating an If/Then macro?
selecting multiple sheets in a macro
Calling variable files
If column width is 8.43, what should the row height be to make a square?
Userform
Select non-consecutive cells for deletion
Trouble with Declaring Worksheets
running excel macros on remote computer
create custom menu with addin connect/disconnect
Excel app as child form in VB.Net
Email from Excel with Outlook Express
Why this code works and other do not? Newbie here.
Re: IF function based on True result with large formula.
File dialog box
Filtered List as Listbox RowSource
Forms
how do I get: What number _____*11.2%=19.86 ??? Thank you!
Stop Execution
Passing Procuedure to Userform
Getting information from a file
Create UserForm programmatically
Date Stamp Save
VBA calculation question
Status Bar : Display both Sum and Count
Cater for unregistered DLL
Help with messed-up code!!!
Match cells by columns
Loops are Great as long as they work
Question about querytable vs copyfromrecordset
Sheet Checkboxes clear
Copying Data Another Try
Text File to Excel Cells
Getting Forms button caption
VBA Code To Import Historical Stock Quotes In Excel
Hide/Unhide in Code; Protect, Unlock, etc.
Re: Delete a selected area from a non-contiguous range
Tax calculation formula
For...Next Loop question
RE: Identifying Blank Excel Sheet through .NET code
RE: Identifying Blank Excel Sheet through .NET code
Finding Text Occurrence With C#
return sheet name to cell.
cell references
Pass string value to another form
Call other sub in the same module
Exclude one range from another
Database access & querying
Problem using pivot tables in win forms
parameters AddTextbox
scroll
replace in a string
Array Code to Delete Worksheets
Test if the active cell contains a shape
Blocking Error 3021 No current record
option button?
Test
Subtotals macro
Set Focus on Cell D8
Values from a ListBox
Tab Order
Return to Main Page
how to link excel cells across the internet?
Adding and using a calendar
Push range against right screen edge
UserForm-New one or Reuse Original?
Running Excel module within Access
Detecting if OLE object is displayed as an icon
Collection Object, 255 item limitation
sumproduct question
Do not email sheet if nothing on it.
cell reference in C-API xll
add and remove rows from a called range
Code needed big time!
adding rows across multiple worksheets within a single workbook
New Line in code to worksheet cell?
Dynamically adding a macro to a new worksheet
Hide worksheets at startup
Sorting records in Pivot page field
can pictures be inserted into comments
calling excell from an external program
Prevent / Disable Worksheet Copy or Move
Add to CmdButton
Auto Sort
Strange behavior of InStrRev() function
Dumb question of the day.
can you link a hyperlink to a macro?
Function to calculate an average
A mixed request
Inputbox's and Prompt value
Drag and drop event
Re: Common Formulas in VBA
Calendar problem
Make a Better Userform
Macro works, identical Function doesn't....why?
Exporting excel cell contents to word document
Convert a wokbook to shared mode
Evaluating Conditional Formats
VBA Dates help
Re: Existing file ?
Userforms
ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method
Draw a circle to select a desired collection
Draw a circle to select a desired collection
Excel Time issue
how to open xla file in automation way with disable macro
VB or C#
Forcing recacalculation
IF or LOOKUP
Delete columns not required
Looping Problem
Why do I receive OLE errors when saving an Excel file in VB?
For Next Question
Size Limit for ADO query?
auto filter
excel programing error?
Naming a sheet
Help with Formulas
Copy Cell from Row Above
'Send This Selection' - in VBA?
Userforms
How do I calculate hours worked on 3rd shift?
Oracle database login
Re: Bug in Excel 2000? (CurrentRegion property triggers events)
Re: Writing values to worksheet from array
link cells in multiple worksheets same workbook with excel vba
Re: Extracing Data from Unopened workbooks
Re: Conditional Formatting to HIghlight named ranges - error
A value between 2 values
Re: Deleting Rows with Sum of "0" in 4 columns
Data Analysis Question
RE: Retrieving Names of Worksheets
Re: Web toolbar moves
printpreview
Re: DATA VALIDATION - for data which is the result of a formula
Re: Writing values to worksheet from array
Re: formatting a specific character or number in each cell within a range of cells
Re: Range Comparison
Re: Last day of the month
Re: Last day of the month
Random range averaging
RE: Running a Script upon Saving a File
Re: VBAProject still visible after closing workbook
macro for clearing autofilter
Loop problem
Message box for cell change
RE: Printing a Word doc from Excel VBA code
Re: ListBox MultiSelectMulti mode
438 - Object doesn't support this property or method