Excel Programming [Archive] - Page 99

macro don't execute a step in the code
Do not copy code from template
Copying a formula in a blank column as far as data in previous column
Protected Sheet Problem in Excel 2000
Sum only visible cells
Tables from PDF to excel
VBA Code Required to Get Data Which is In Coloums Into Rows
excel video
Running macros automatically
Garbage collection in VBA
Format Decimals and Whole Numbers
compile error HELP !
Blue moon
reference format Range(Cells(),Cells())
How do I edit a selected range then copy the range into an new sheet???
Deleting or Disabling code in Excel
Open Form (VBA Running) and Application.OnTime
How to distribute macro signature certificates in a domain?
Disable keyboard shortcuts in formula edit mode?
time taken open exel file
VBA projects!! Aaaargh!
Custom Dialog Boxes
Macros that:Email,FindNext
Embedding excel files into Outlook emails
Block If
Get info from changing cell to a static cell ??
CommandButton color change on event
Deleting VBA programs
I would like to have a cross in my checkbox rather than a tick
Range().Select not working
Excel Automation from Access
Disabling access to MSquery
Variable in MsgBox?
How to detect MS Word or MS Access calls MS Excel using VBA
Extracting formula instead of result from cell
locked link
Control disappeared problem - specifically, the Calendar Control
how to create a msgbox showing progress of macro
Different syntax for Application.Wait
Format cell based on adjacent cells values
Module Error
How do I format a specific column of cells to have a limit aount of characters?
File exists under directory
Lookup in an array
How to separate words by comma
Disable a Macro
mp3 tags
HOw can I use Copy and Paste Function
Format Page Field
How to update last save time & last author for each worksheet
Removing a Form from VB Automatically
Count multiple condition
Finding String Using Vlookup
Changing Module names
Working with arrays
Run-time error '1004'; Document not saved - intermittent
looking for the empty cell
intersection of named ranges
Variable procedure call
Finding Name associated with Abbreivation
macro to compare file columns
I get run time error '5' when I run this code. any sugestions?
Run xll add-in via macro/code
Hyperlink path into a adjacent cell
Please Help Correct my code
Dynamically obtaining a range from another range
HELP! Get error while saving after password protection
Ignoring reference errors
Format Number to Text
Help with Excel VBA Programming
I need to change this code to copy All files the "customdoc" folde
colors
How can I get rid of the pathname?
Entirerow.delete based on multiple cells
Renaming Worksheets
If statement not working
How do I insert a variable for the file/path in aQuery Table?
Excel Marco Startup Problem: Run-time Error 91
Taxi scheduling database using Excel?
how to copy cells data in every 7th row?
Trust VB projects setting Grayed out
Call secure web services from Excel 2003
CheckBoxes how to remember changes
Syntax in Varying Object Names
Summing cells by background colour
Include Worksheets From Workbooks into ONE new Workbook
Moving post code data to a different column
Get the name of all workbooks open from access
XLSTART doesn't open PMW
Copying worksheets in VBA
Hyperlink
IF statement
it's a question for access
Permission denied in CreateObject(Excel.Application")
Need macro to insert workbook into another workbook using input box
Maintaining formula while clearing the cell
Deleting cells in a column ref a different column
Checking
Launching Excel macro for every workbook opened.
Defining a range and use it's value
Input Dialog Box - Simple Question
Disable Macros when loading a Workbook in Excel 2000
Need pivot table to automatically highlight subtotal rows
Creating an array formula in vb
Text File Encode to UTF-8_Unicode specific
Visual Basic
user difined inputbox
string convertion to date problem
macro for copying formula
Excel range choose button in VBA form
No refresh in target cell when using worksheet.cells.formula = ...
Combining values from multiple spreadsheets
Dynamic pivottables
How to Display the The Insert Picture from Scanner or Camera dialog box
Inserting image
redim preserve
Saving values during installation of Add-In
Timer code
Protection - restrict macro exposure to the workbook, VBAProject
conditional sum
hook into worksheet events temporarily?
Global Variable in Excel VBA
Open another file
matching column and return vlue...
Adding OLEObjects Word Doc 8
error 1004 Range object
How to disable MS Excel Clipboard message when I run a macro
Find User Default Email Address in Outlook
execute a macro
Checking for existing worksheet name
finance functions
I want to change a cell reference based on where the cursor is.
How can send email with Foxmail?
Adding sound clips into Excel
get response data from excel
Copying discontiguous ranges to Word
ActiveX Chart
activate workbook if condidtion is met
Force File Name Convention
Print Form
Macro VBA help please
How do I copy a folder from a server using a macro
why doesn't microsoft excel support inheritance
Help with Loop
Find Next is not working for me.......
Can I detect a KEYDOWN event while in a worksheet
Help with CommandButton vs Excel 2002
Re-number drawing object references
VBA for Home key
Vlookup and Hyperlink
Programming in .Net for Excel
ClearContents or ClearFormats also clears Clipboard. How can I keep the clipboard?
IS there a way to find the name of GIF file over Excel cell
Help: How do I create a column of fixed width data?
SQL UPDATE for "edited" records
Need a solution
Protection Property
copying formula...
How to create a macro that deletes every blank row in a spreadshee
Date + one year
Produce the name of the named range of activecell
RE: How to create a macro that deletes every blank row in a spread
an unanswered question
quick code needed
Macro to delete all blank cells
choose the highest value in a row and return column number
RE: How to create a macro that deletes every blank row in a spreadshee
Show/Hide Userform erases global vriables
Nearly There?
header formatting
RE: header formatting
Event triggered by paste
string values do not equal cells, then return msg
Calling worksheet module from other module.
Merge Workbooks?
return "nothing" from UDF
Finding Links in a large spreadsheet
Program a macro to run at specific instances
how save workbook without Do you want to replace it?
launching an external program or proceedure within vba
RE: launching an external program or proceedure within vba
Forecast function to include seasonal changes
GetObject Equivalent for Internet Explorer?
Getting inconsistent Error 91-Object variable or With block variable not set
Working with application path
GetObject equivalent for IE
Macro doesn't run ?
Toggling Button Labels Between Expand/Collapse
Excel Programming in VB.net
Is there a function in VBA to find out if entire column is empty?
User defined msgbox
How do I use an activecell as coordinates for pasteing?
how to do a comparsion between 2 files with same columns?
Adding cells that meet certain criteria
RE: Adding cells that meet certain criteria
Hiding rows and columns
Change CommandButton Picture
VBA Code for Multiple VLOOKUPS
Importing CSV into Excel sometimes truncates text at 256 characters
How can I easily add an apostrophe to the beginning of an entry in a cell for multiple rows?
Auto Open - Clear all filters
Macro creation
Making it not look like excel????
Trouble with Average function
Formatting calculated totals in a Pivot Table
Windows On/Windows Off
Range(0,0).Select ?
Macro based on check box
Excel settings
Problems of list box property
PasteSpecial
Running a variable macro when any value is entered into a variable cell
Removing reference generates type mismatch error
Exclude specific wks in FOR EACH wks Loop
Text Boxes Disappearing
Workbooks.Open problem
Excel template for a capital project budget?
search and write.
Sumproduct and Beyond
conditional addition
Excel to HTML
Charts in C#
identifying blank cells by a colour
Workbook before close problems
Macro in Excel: pick next 7
Read directly a returned array in the calling routine
Projects remain in VBE even after closing workbook
List Folders using Excel
how to split a string and return array
permanently add reference to ADO library
Hyperlink within Textbox(UserForm)
Opening a large HTML document in Excel - slow
Enabled macros
How to identify text (compare) in one sheet, then move it another
How to identify text (compare) in one sheet, then move it another
Making print range dynamic in macro
Solver
Out of memory error
Looking up dates
Impossible to find error
export charts
Help with find in Excel ...
microsoft.public.excel.worksheet.functions
how to select row according active cell?
Saving or not a spreadsheet
Q: how to use UsedRange correctly?
Outlook express email reader
histogram analysis
Running procedures on events xl2003
DiagramOrgChart in text
callbyname in XL 2K and XL 2003
How can I select random whole nos from 1-16 without repeating?
Newbie Q: Range from two cells
Copy paste not working after save of worksheet
Calling a different worksheet???
VBA code: call subprocedure
Security for VBA codes
Run Word from Excel VBA
Cut and Paste Jumping
Delete row if "Not" macro
How to handle cancel when using the inputbox method
Date in MATCH formula
Need help - track changes code needs tweaking
Exporting VB Forms Automatically
Trying to Append File using the example in excel but not working
Problem with setting Interior Color in VBA
Disable a macrobutton for a particular cell change?
Update Formulas on Consecutive Sheets in a Range
Problem with setting Interior Color in VBA
delete rows
Compare data strings?
ActiveSheet.PageSetup.Zoom
Can a input prompt be added to excel spreadsheet for a value?
too few parameters
RE: Can a input prompt be added to excel spreadsheet for a value?
Excel 2003 won't print a whole workbook to a file. Help?
while loop?
VBA Macro for VLOOKUP
Disabling menus
How do I convert a Formula into Code???
How to stop the 'select sheet' window pop up
Colorindex referencing
Find
VLOOKUP Closest Match Not Close Enough
Auto Filter Question
Comparing Values from 2 cells
VBAProject name compile error, not defined at compile time
GetOpenFilename
auto expand rows
comile error for sheet in office 2000 but not office 2003??
Auto-Filter on multiple worksheets automatically via VBA
Clear Dim Statments
indirect macro
Req: Help requested with Macro problem and syntax errors (any fisherman out there!!)
Insert Header using ASP
no workbooks open
Zipping a Protected Workbook
changing score from number to letter grade
DCOUNT Problem
Checking whether .xls file was just opened from a template
Prevent others from running my macros
Multiple Instancing of certain events
change event problems
Retrun a worksheet from a function
How can I read & write in a Vlookup cell (same as editing an Acces
Find?
Very speciel function
Find text in Column or Range Name
VB Error 'File Not Found' when opening Excel
Invoice directly from EXCEL?
Find File By Name
Deleting rows older than current date and inserting a new row
Setting print area within macro
Code for Printing Discontiguous Ranges
Copying Several Sheets To a New Uniquely Named Workbook
Extract Day of Week from Date in VBA
I need help ASAP!!
Change column width according to specific cell content
Changed or Updated property?
HELP - Automatic Conditional formatting
VBA code to send a system message?
Protect sheet
How do I create a formula to move data to a different cell
Bad code
RE: cell format changing when when using search and replace.
Cell Formula vs Cell Value
RE: Problem with Statistical UDFs
Re: Problem with Statistical UDFs
Re: Original pathname from &path
Re: Macro to change database format.
Aborting Execution Before Error Message
Help Menu for Worksheet
Form Check Boxes an a worksheet
calling procedure
How to disable CTRL key
Overflow
Re: Original pathname from &path
Re: overwrite previous saved data
UDF Question
enable right click
RE: Original pathname from &path
calculating values in cells
Macro to change database format.
Re: How convert a cell subtype? (from vbDouble to vbString)
Re: How convert a cell subtype? (from vbDouble to vbString)
Re: How convert a cell subtype? (from vbDouble to vbString)
Re: How convert a cell subtype? (from vbDouble to vbString)
Re: How convert a cell subtype? (from vbDouble to vbString)
How convert a cell subtype? (from vbDouble to vbString)
cell format changing when when using search and replace.
cell format changing when when using search and replace.
Determine if Integer is Odd or Even
Understanding Menu Item
RE: the most frustrating control
Custom "conditional" format ?
Selection of UserForm through button
the most frustrating control
Need some help
Exporting from Excel
Populating list box with number format data
dynamic control combo box
Commandbar Positioning
Very serious question !!!
How to set the entire selection to a specific value without using VBA
embeded spreadsheet object
Determining if List of Values is present in another list
how to enable macros in excel 4.0
automatically copy first 12 characters in one field to another?
Another Error 91 question!?
Creating a "pop-up" box
Open file pop-up (network)
copy from previous page
Attn: Tom Ogilvy (Please)
Copy Row To Another Workbook If . . .
Opening file saved as current date
user forms
Problem with criteria when usign worksheetfunction
Comparing Cell Contents using a Case statement
sorry left out details (In Detail Please Help)
Convert formulas to values on save
In Detail (what ever works please help)
can we call a Sub in another opened vbaproject?
Declaring Procedure Variables
data validation on other sheet
Count If Multiple Criteria is Met
Displaying Tree Structure in List Box
What method do you use to save/store your developed code?
Vba dreams: insightd needed
compare column1 with column2
How to define a Named Range in VBA?
conditional formatting
sorting data in 2 columns on column 1
problem formulas
Excel has generated Errors
Creating simplest Excel Hangman
IBM thinkpad with projector, Excel crashs
Range Address Memory Variable Limitation
Problems with simple print macros
how do i open a zip file using a macro
Please...I beg HELP
Referencing worksheet controls
How do I write code to preserve variables values for future use.
lookup value and print all instances
Screen resolutions and resizing forms
Adding a Line using VBA
=indirect
hyperlink in cell
Export as Textfile with VBA
Worksheet Sort
DateDIFF
Macro with Essbase Add-in
Pull data from inactive worksheet
Excel Ping Command..via web...
msgbox answer
Timer Event
How to do the following by pressing the down arrow or up arrow key?
Performance Improvements while using RTD
How to copy worksheet layout, values and graph as picture
add a formula to a formula
Concatenate two variables (String & Integer)
Initiate a form on the selection of a particular cell of a workshe
Defined Name Box Shortcut
VBA to refer to a cell in a different file
Finding and Amending a record
WebQuery(local)
Macro to record user name and date/time
cells in clippboard?!?
cell backgroundcolor
How to make created button move with scrollbar?
Help: Activecell within Do loop problem
Form job
Finding the Path to the Program Files Folder
Creating a loop
Question??Searching form
Missing condition after solver called by macro
Cube Root of a Negative Number fails in VBA?
can someone simplify this file listing for me
interpolation in an array
Extracting unique entries and assigning it to a named range
Adding A Date Command Button
What's wrong with this SQL join statement????
Zoom Property - 1004 Error
Coefficients of trendline
Moon rise/set
VBA to allow a folder to be a shared folder
Match
WorkBook links on a new drive
Delete selected range
Update Sheets from Master (two questions)
Offset to New Sheet
Money in the Bank?
Custom Menu Item Randomly "Checked"
how to give values to non-continguous cells simultaneously
Runtime Error 91
Sort all worksheet contents with a macro
Self creating formulas
Display numbers in a userform txtfield as numbers with a comma
Please Help me fix this formula!
cascade combo in subform
Tutorial on creating & formating a word doc from excel
excel
Printing A Worksheet To Specific Printer Name
Move Method
Natural Logarithm in Microsoft Query
Compound interest question
VBA code to populate 1000's of cells?
COMBINE data in several WORKSHEETS with same header row
Search and read registry for particular external application
EXCEL. Print invoice directly from list?
Function to find the address of a cell
Case Select
Counting Web Tables
Load form saved in one work book from another.
Code for a UPC
Creating hangman(word game) on MS Excel
Limiting input with input box
How to optimize my coding..
Create and import filename list into excel
changing button colour
Insert Custom Sheet.xlt
disappearing worksheet_change VBA code - help!
Appears error (424)
Append data from a column to separate table array
Selecting Column Range
Need help on error msg for "find()"
How to Delete All Links to SQL Query in Spreadsheet thru Macro
Syntax to Set variable range
dynamically lengthened combobox
Need macro help to edit hyperlinks
Right click and iterate through selection
Available code
Debuging UDF
Currency Change
How do I set up an ROI calculator in Excel?
Pivot Table - Custom Formatting
Finding the top two in a multi page workbook
Cell value as named range for validation list
Calculate Formula
How to count the number of cells used, but ignor 0
Copying Data
vba code overwrites formulae?
How to detect and view more than 65,536 rows when opening a DBF
Need Unique Only in MsgBox
Addin active sheet problem
Machine specific errors?
Startsector where file is written on
Insering an image on a specific cell
How to change the font size of Data Validation in drop-down menu?
438
calneder
How to access group buttons in Class Module?
Count no of rows with interior color
Open a Word document from Excel and change its password
Duplicate values
Re: Stop Dublication in the same column
Microsoft Excel Flaw Found on eBay
Extracting Hyperlinks
How to remove watermark
Finding amounts equal to one total
How to select multiple sheets in VBA?
How can I link the values EXCEL cell with Microsoft Equation 3.0
Lookup without duplicating
Complex User Input Box
How to change XL sheet names from cell range
Can't figure out passing and returning arrays
Controlling formating from a function
Print only columns (or ranges) that have at least one currency val
Pass text > 255 char. to closed wkb with SQL?
Date FORMAT problem
formulas
what approach/technology?
formulas
Add code to a worksheet programatically
timeout on GetSaveAs?
Does the object already have a value set?
Button to set colour of selected cells & then force sheet calculat
Macro Needed for Pivot Table
Pivot tables and array variables
Storing all macros in one workbook
Enter blank row after subtotal "Total"
An image appears when a cell is selected
Creating Chart using form elements in Excel
Convert Decimal to Time
run-time error
excel/vba & acrobat 7.0 pro -> Print multiple sheets to 1 PDF
How to have a macro simply issue the "find" command or "control f:
Bob Phillips' Colour Counter
Paste Event Check
UDF returns #NAME? error
Inserting Page Breaks
Hide Sheet using Workbook Open Event
collecting data based on dates requirement
Excel Addin Function gives #NAME? Errors
Listbox Value
Compile error:
conditional format macro not working - almost there
General Question re: Jon Peltiers Control Chart Example
Truncating read-in data
How do I refer (in VBA Code) to a column by caption instead of index ?
"Select All" checkbox (or any other form tool)
object doesn t support this property or metod
Need to import text file data without quotations
Need convert from txt file to excel spreed sheet
automatically jump to top of the next column in a form
Comparing columns in 2 Excel files(workbooks)
Excel Macro
Copy file from Excel
vbOK and check for variable
Pivot Tables...
Importing Tabs
Cell description into the chart
sobel filter with visual basic
writing ADODB recordset to excel sheet
Scheduling Field Staff using Excel (perhaps Networkdays function)
changing a string date into a 'date'
Selection.Copy
Combo Box "Selection" Get / Let
Importing web data to a worksheet
shortcut key versus F5
Dialog
Range Efficeincy
Chart Code problem
Selecting a range from a spreadsheet
Cut and Paste range
Don't add item in combobox ...
Deleting Corrupt styles
Excel data messed up after inserting & updating
update record in mdb..
Updating varibales in a worksheet
import file programatically
Determine First non blank cell in col without Macro
Printing worksheets
XIRR in VB
COUNTA msgbox
Copy format from row above for selected cells
How to delete empty rows in multiple column?
date code error, help would be appreciated!
Opening dif format sheet via VBA
** Range Copying Madness **
Openning other files from VBA
Calendar problem with sheet protection?
How to move the calendar object?
Using Access MDB files with Excel
SPELL NUMBER IN ENGLISH i.e 1,000 RESULT IS ONE THOUSAND ONLY
Another question moving rows to columns
How can I deal with a large number of data?
Re: Loop through Column and add hyperlink
Selection Filldown format only
Progamatically Formating Cells within VSTO for Excel Application Development using C#
A curious OVERFLOW problem
changing file names with macros
checking for a blank field
how to exit sub
how do i build a call report form in excell
Drop Down and Auto Insert
Synchronizing development + production workbooks
Shell Problem
Send e-Mail from Excel without Dialog
Associate additional columns with an external query
Referencing check box names in VBE
Copy format of row above my activecell
Date increments by X number of days
edit dqy file (Excel ODBC Query)
Merge ranges based on condition
why is excel so slow
ActiveSheet.HPageBreaks not working
Moving records to a new sheet
charts with #N/A and other "non"-data
If a cell does not contain a formula then...
Password screen to VBA appears with logging Off
Losing hyperlinks in advancedfilter copy to location
Advancedfilter copy in place doesn't use criteria range correctly
Forgotten Password
Advancedfilter doesn't work when Excel opens, but does when run macro
Macro to autonumber cells
email (CDO) with SSL
Protecting Forms
Finding A string
excel help, color coding rows
Error:Paste Special method of range class failed
Disable Border and Other Format Modifications
Search a range for a value
Scatter Chart with point labels
Programming Assistance
Question on Ganttool AddIn Code(formula)
SUMPRODUCT Not Working
How can I prevent this from happening?
What is wrong with this?
detecting keypress(es) in a cell
Conditional Formating Macro Formula
Merging worksheet - ideas
VBA search
changing the caption of a command button
Need help changing rows into columns
SQL limit of 255 characters
3 unanswered questions:
New Line Items at Runtime
Summing user selected records
List of functions used in a particular Excel sheet
can some body help me
macro to be available for some workbooks
Re: Still need help!
Knowing when Solver closes
Printing problem
Macro to replace "0" (Zero) with Hyphen in all Cells
How do I create a macro to insert an audio file into Excel?
No changes during Read-Only mode
date format, looking for a date in column A that is one year ago
last row function
Browse for folder
Extract data from multiple sheets
Claculation in left corner
How to preserve leading zeroes
Re: Excel sheet to Powerpoint slide
Re: Macro that counts cells with a specific value
Looping SQL query w/changing parameters in each loop not working
line input problem-need to return 5 lines after a string is found
Inverted Text in control buttons
Tab Order within a frame
document changed in excel
Workbooks collection is empty even though the some of the document is open
Deleting Rows
disable saving excel form
Multiple IF statements
How do I add a variable to watch in hex?
Macro that counts rows and averages data in row
Calling functions from a xll library
Bottom of spreadsheet hidden by taskbar in full screen view
Executing PL/SQL in Excel
ADODB Timeout
Global buttons
Copying Different Rows from Different Sheets into one sheet
Password Protecting/Unprotecting Via Code
variable column numbers for autofill
Hiding information on sheet behind a form
Print number of copies box
Random numbers generation
How can I track the chart mouse events?
Inserted picture name
reset value in a column
vba editor, alternatives
Hyperlink macro for personal.xls
Making "traffic lights"
body of mail and sheet.
Disable Excel Command Bars and Remove Irritating Grey Bar
problems with loop
looping and copying
Pivot Table - Purge old data
how to pull info from multiple tabs within same wosksheet?
Comparison of modules
Front-End for an Excel Data Base
Applying style to row, getting Run-time error '450'
Selecting AutoFilter option based on ComboBox value
Why Error Message "End Select without Select Case"?
FileSearch.Execute does not find *.eml or *.lnk files
Filter Rowsource for Listbox
Is there a way to access documentation more easily?
Re: Setting Tab Index for Text Fields
Re: Example file to dl for floating toolbar?
SaveAs v. SaveCopyAs with Chinese in filename
Loading Userform
I am soooo sorry
Change Tracker History Log
number to time format when digit length varies
Writing an API for Removing an Addin
Buttons and Validations Disappear
Re: Loop through Column and add hyperlink
Average Formula?
1 column with YES and NO responses. Can we sum for ea. total of YES's and NO's? (Okay to put results into 2 separate cells).
Re: UserForm from VBA macro is not getting properly unloaded
Common Dialog Control
Re: module name, sub name, line number
Formula to write a value into a different cell.
Data format coversion in Excel (long)
Matching Two Columns with Many rows
modify query with value in combo box
variable last cell in pivot table macro
How to Ganerate random words from office dictionary into excel
VBA error 438 - Object not supporting this property or method
Printing to Adobe Acrobat
Tab Order
Worksheet Merging
Re: Hide Defined Names
devide rng of copy
How do you cut a paste a macro or VB language in Excel and make it
VB select code for a worksheet
sending worksheet deletes body of email
big formula?
Creating a named range
ADODB Connections
Re: Sub procedures in commandbutton script help
copy worksheet from previous month and rename to current month
HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
Easier way?
SHIFT doesn't prevent macro from running at startup
FileSearch fails to locate *.jpg and *.tif files
Dialog Box returning Array Value instead of Actual List Value
Re: Excel Power Programming, Bible books
SUbtotal
Re: Initialize HorizontalAlignment from an integer value using VBA
Links don't get automatically updated in a sheet copy?
Can't copy workseet with embedded chart
Renaming files in a directory
Identifying empty cells in VBA
VBA to pull from 2 diff tabs within the same spreadsheet
RE: enter db query results into cells
Find first and last instance
image & picture
Re: execute once formula
Printing multiple rpts via Looping
sort method
Countif then multiply
How can the caption of a (button) shape (not cmd) be changed from VBA
Converting files to excel
Re: function/formula for adding 30%
Re: Enter Data into one cell then automatically highlights the row
Disabling a specific macro
Re: check if file exists
MsgBox Question
Maximum Drawdown in Excel
workbook referencing - how to!
RE: MsgBox Question
Excel/VBA -> Custom print range problem
FIND function driving me nuts
RE: Application-defined or object-defined error on closing
Validate cell value against a list
Re: Loop through Column and add hyperlink
Re: Performing ms word operations from ms Excel.
right mouse click and IF...Then
Re: Change Tag Name Automatically
Re: Application.Quit
How to test if a workbook variable is valid
insert a dash
Hide Columns if ..................
Create index and perfrom function on each and every value.
Application.Run Call Err: 1004 Cannot Find Macro
solving equations using Excel
Suppressing a message box
making directories
Code - not working - Why?
Update links bug in Excel 2003
How to subtract two lowest minimum scores from list
Function that return a a vector or a table
Set range or named range?
Move Column data to rows
Re: FSO question
Renaming rows and columns
Re: Help
Re: Example file to dl for floating toolbar?
Method 'MailEnvelope' of object '_Worksheet' failed
Programming Questions
Re: change the characters entered in cell as a Password charactes
Re: Code for meet cond, copy, pasteSpecial, ValuesOnly
Re: Stopping a Macro
Re: Easy Question about selecting Ranges
Input box and add rows (tricky, for me at least)
#VALUE! in OLAP based PivotTable
Auto-sum (without SendKeys)
Copy/Paste Loop
Importing XML through .NET Web Service with VBA
A problem with dates and I don’t know what to do
How to create a template that creates and saves as sequencial num.
How to get value of variable when single stepping through code?
Transferring data from one sheet to another
Create a New Random Number Every 2 Seconds
Replace Function isn't working
Is updating Excel cells from multiple threads a bad idea?
Programming equiv. of <Ctrl> <Home>
How to Refresh VB Functions Automatically in Excel?
shortcut keys
Sheets("ROIC").Select Fails
Date Picker for Mac Excel 2004
#name in match
Event handler is invalid
Scrolling of UserForm1
Path not found error
Excel / Access Import
Importing text data from the web
Last used cell in column with shading
Excel 2000: Is there vba code to open one subtotal detail
Making VBA code from one WB work on another WB
How to call an event procedure
VB.NET + Office 2002 and Office 2003
Deleting empty rows
Undoing a macro
Macro to enter blank row
Variants vs ranges
Help!! (vb macro in excel)
Open WorkBook & Run Macro
VBA Excel - Textbox disappearing BEHIND listview control - Zorder is useless.
Trying get macro to clear cells when workbook is opened.
Find and Replace
Copying / Collating Data ....
Filtering and Sorting
Display position of Userform
Transform different values?
Trouble with Filtered Ranges
List of VBA evolutions between Excel 97 and Excel 2003
View Control of Form Controls
random integer problem.
change file links or updating formulas
Activate/deactivate Office Clipboard in VBA
VBA and Mail
Microsoft Date and Time Picker 6.0 COLOUR
Moving active window to selected range
Create / Delete folder
Combining cell Ref into formulae
Is there a formula to AUTOMATICALLY highlight a specific month
events
Keydown and SelStart problem
hello again... complicated macro using dates
Re: Relative standard deviation in Excel
Change contents of a cell with VBA
Scrolling columns display
code to FIND value, copy, paste values onto other sheet
get lists of names/folders
dropdown
searching rows and coloumns
Making folders based on list of names
macro stops on "selection.autofilter" line of code
embedding one sheet into an email message
How to Link Small Utility to Object in Spreadsheet?
Excel Flavour in a Named Formula, Regular or Arrayed ?
Client Access to iSeries Automation
Run a macro when a cell is updated
Basic question about web queries
XP and string paths
Selecting Specific Data to copy/move to a new sheet
conditional format problem
To detect changes in a worksheet
Programming popup forms
Removing an Addin thru MSI
Finding & deleting cells that do not contain a certain text string
EXCEL 2003 - IDE
Select a Range Through a Variable
How to enter a value in a cell
How to select last active row
Cubic Spline Interpolation
time between table in word and current date
Extending sub to cover other target cells
thing falls apart by Chinua Achebe novel
Use VBA functions in a worksheet?
Lovely ListBoxes - help!!
copying results to other location
Working with AutoFilter, Find , Sort and Ranges
Computer Lock opens up VB editor
IF / Else Statement?
Print question
TinyTerm, WDS-II and Excel VBA
Excel 2003 - Determine the number of printed pages
Can LooKUP get return value of True or False?
if or
linest function
Macro (attributes?)
Get a deviation reading
Comparing values in cell B to cell A
Copy the first row to other sheets.
New approach
why doesn't SendKeys work consistently?
Hide/Show Worksheet Controls
Select Range using variables
Special Paste Value
How to automate the calculation of the median from a frq distribut
Re: Help requested regarding vba I'm having problems with.
Please Help - VBA Change Event for Excel
Import External Data Wizard
Capturing Maximum and Minimum values
New menu item action
Issue with representing a blank in a logical expression.
Excel 2003 act differently from Excel 2000
Substring of a Chr(10) delimited cell
Resize method fails for 1-D array?
=cell(color????
InsertRow upon each value change
Linking workbooks
Scrollbar single click acts like click and hold
delete rows
Link two listboxes together
Validate Named Range Exists
Adding menu item to Tools
Copying ranges of cells from closed workbooks?
Excel Checkbox Clearing
Next and Loop Question
Calculating with macros
Never seen this
Excel Startup Files
How can I set up a drop down box with a calendar in Excel?
Enter Query Password in Module
Formula, can anyone help
How to obtain the number of Column and Row from selected (active)cell?
Clipboard Question
Autofilter copy
Pass Argument?
Worksheet function or VB?
text boxes & control source
List of invalid sheet tab characters?
Reading Contents of a Directory
make macro run on someone else's desktop
Last list item selected in a Multi-Select list box?
Excel RTD with DCOM -- "Class not registered" error
Range % Increase
Calculation
Arcus Cosinus
Read a .xls file and insert its values to certain lines in a text
This newsgroup is sometimes frightening
how to compare the active cell value to the previous cell's value
Recalculate Named Range After Sheet Changes
Unique File Identifier
Delete only cell and not row?
Floating toolbar and floating comment?
copy rows that contain certain text to a new sheet including the h
Adding text to body of email with workbook attached.
Combobox, Controlling columnwidths i curtain
How to handle "Invalid Worksheet Name" error programatically in VB
last day of the month in a range
Pivot table in Excel MS Office 2002
Deleting "Arrange Side by Side with..." command from Window menuba
UCase Code Solution Needed
Preserve contents of Clipboard when altering display options
Input box for signing off work
Skittish Ne0x address on network printer
Introduce new column using VBA macros
Close excel when inactive
Use execl financial function(Ex:PMT/RATE Function) with ASP
Not close thead when I close excel
Skittish Ne0x address on network printer
COPYING FILES
VBA to calculate charges
UDF code to find specific text in cell comments, then average cell values
Rerieve Images from xls files and save them
How to add comment into cells by VBA code?
unit testing code using vba
Getting Date difference....help (difficult)
Addin Reference crashes Excel
Updating master from 3 shared workbooks
Font color question
I am going crazy with Sumproduct
Finding the current worksheet name
How to remove borders in a range of cells?
adding a right click command?