Excel Programming [Archive] - Page 97

Select item in drop-down list in Vbasic
Why doesn't "private" work?
Using excelObj.ActiveWorkbook.SaveAs("C:\MyWorkbook.xml" , FileFor
preventing macros from clearing the undo list
Simple Sound Macro
Complex Query Not Able To Get Results in Excel
Full xpath support in visual basic?
Collection as parameter
Macro (can do a save as.
VLOOKUP formula
copying worksheet
IF = text Show "NIL" ..?
UserForms, mandatory completion of fields
Print Preview
SaveAs Code
VBA
Digital signature
Date and Time Formats in UserForms
Create Function like Sum()
??? Combobox auto go to selection
lines in user forms
Can i use lines in a user form in excell
how to add column with the workbook-filename
check exist of filenames in column, mark red if missing
Macro Help for Deleting Blank Rows & Clearing Cell Contents
macro creation to format mulitple rows in a list *difficult*
Macro slow after 2003 upgrade
Error using VSTO and ImportXml when cell is being edited
Saving worksheet Data only
FILTER ROWS THAT MEET THE CRITERIA IN THE LAST CELL OF THAT ROW?
hierarchys - can you build an elegant hierarchy using vba
Paste Value Multiple Sheets
currency macro?
Go to what I just typed
Find Macro
try [code] next
VBA
Colon in code?
Multi Colum Listbox in UserForm
Application.Run problem.
Copy a range to cells above range
Shared workbook opening and saving very slow
Help with lookup or if functions
Return WB to original state
continued issue with countif function
Macros within formulas
a strage kind of graphic
custom toolbar for each sheet in workbook?
Help with Macro for work
Macro to name ranges for selected worksheets
Help - Excel Automation: Turning off all dialog boxes (prompts).
Remove blank rows without hiding them
Recent File List Problem
Useform Cascading Like the Solitaire Cards when I try to move it
If cell = number ?
Manual Calculation not working?
using countif from a vba macro
Copying static cells in a loop....Paste Special problems
Macro signature disappears.
Paste Special issues
Automate Page Break
Drop Down Boxes
Export Date Format
.Find Method for Excel 2002
Not Enought System Resources
Hiding and Unhiding Sheets
XML Refresh Code
xl4 command
Adding read receipt to CDO code?
Code to search and replace info on modules
Option Button - Cell Link Issue
Outlook Event Entry
Hiding and Unhiding Worksheets
Why is this a number?
OnTime
Excel macro to insert blank rows at a ever-changing interval
Sorting Multiple Sheets
Open Word Document from Excel Userform
Diable Ctrl+Break
countif AND countif something else too!
countif AND countif something else too!
Go to 2nd row below last row
Pointing directly to a cell in a range
a strange graphic
getting error out of memory
Update Links
Using a database to create new worksheets based from a template
matching 24 different values to a specific value
Is it possible?
remove vba and functions when saving worksheet
Data Filter Function in VBA
Getting a cell reference
Close File
xls file requires Domain Admin to save locally
Auto reszie a row with wrapped text.
macro open files
Drop Down Boxes or Macros?
Passing variables between workbooks
Paste blank cell row loop
Text box pop-up
Students and Courses
SOS: Excel custom Toolbar
Programmatically make cell pointer invisible
Put variable into text ?
If Value Problem
Button not showing graphic.
Run-time error 1004
Brain lock: using array formula within VBA?
Sequentially run macros
Macros
help with this function
checking a sheet for identical items
Variable in formula
Macro for multiple charting of multiple datasets
Open a semi variable name with a macro
copy paste values only using destination:=
question about Web Query
Making sheets with a macro
A strange kind of graphic
Another cell formatting dependent on cell contents question / message box popup?
Excel macro, editing recorded cell.. not current
formating cells
exclude international and national holidays into conbobox...
the macro don't execute
Protect cell pls help...
Changing Background Colour Based on Cell Contents
Copying the data from the other worksheet
Putting a search box
Template path
Create new workbook, temporarily name it and copy sheets to it
Extract Target path from a shortcut
Repeating some code on all worksheets
How do I trap errors when excel (not a workbook) launches
help with graph
Macro again..
1004 and Cells
Paste All Problem
Pivot Pagefield multi-select? (Excel 2003)
Timestamp - automated based on the next cell
type check
macro with external script.
syncronising workbooks
File copy
Cells Range Error - URGENT
getting data from excel worksheet in to a script
Workbooks.Open fails
Macro to replace another macro
saving backup
copy and paste formulas that apply to multiple worksheets
Open Access Database from Excel
run a macro in excel formula
Multiple selection
Subscript out range error when redimensioning dynamic array
Excel Add-in for SQL Server AS - Documentation re Calculated items
How do you Export Excel data permanently to Access
Copying entire row
Loop routine fails after 10 cycles......
Help!!! I have problem deleting 2500 rows of filtered rows
run-time error?
run time error
Conditional Printing of worksheet
Dynamically Activate a Combo Box
copy and over write *.jpg files
Any news from Bunny / TRA on how we did in court on 1/10/05
Comparing two coloumns text contents & extract different values
Searching for patterns in text split into adjacent cells
Capture Find Settings
Is there a way to install Excel if I use XP?
color for last day of each month
WorkbookBeforeSave
Number formats after breaking links
two small questions
Closing a Workbook
DateTimePicker
excel input date format
How can I do AND operation on two binary numbers in MS Excel?
problem determining a cell's value
Need help re VBA for Worksheet Open Event
disable message box during VBA code execution
Convert cells to HTML
Merging Columns, keeping text
Merging Columns
1004 "Application-defined or object-defined error"
MSForms.ReturnInteger assignment
How to export/save the track change history into another worksheet?
Help with "Selection.End(xlUp).Row"
FORMAT CELLS
Pulling up the Find and Replace Dialog via Code
Maintaining Column Widths When Copying
Excel 2003 addins don't automatically open
Chart VBA Question
Updating links
Creating an Excel sheet with Addresses using a Macro
Code created in a Macro not working for a Command Button
Macro not working
Splitting text document into chunks of 100 characters
Concise border removal method
how to remove blank rows from a sheet using visual basic sode
Determine whether a wrkbook have been changed since the last save
Macro Writing
Excel keeps converting my %s to Time format
Sum all cells with interior color...
Help on VB Excel
Exporting CSV Files
Linking question
Number format locale - XL2003
Unloading / closing a form with the escape key
Replace CR character in text pasted from Access database
Format Excel Column via code
How do I attach just one Excel worksheet in an email
Change Shape Name
Textbox Date formatting problem
EntireRow.Delete, Causes Problems In ComboBox In Another Workbook
Conditional Worksheet Access Problem
Change Event Problem
animated graphics in excel visual basic
Using the Solver in a VBA function (not a macro)
Help with creating a formula...
Solver does not solve when called from a macro
Mail_ActiveSheet and DeleteAllCodeInModule
automatic exporting of data
Database Search Form Help?
And/Countif formula
Need help with Macro in moving columns
Format subtotal rows
Macro Open Files
multiple comboboxes to change displayed images
Creating a Purchase Order Form
Merging data revised
Function Not Recognising Values in Populated Ranges
Subtotals
Wrong Number of Arguments or Invalid Property Assignment???
Select number of rows in a graph?
Wildcard to pull all data
Row from database in Excel sheet
How to add a new sheet with a name
Scrollbar flash
colouring a cell
vba code to record a macro
Can I do this with arrays?
Pulling files in using Macros
Defining sheets to be created
Inserting foreign/special characters from a database
Multiple "IF" statements every cell in range
Can Visual Basic 2005 be used in Excel 2003?
PivotField AfterUpdate event?
Worksheets.OleObjects
a letter equal to a number
Count if with several areas/conditions
Subscript out of range (Error 9)
How to evoke a hidden userform?
Group controls
Form not unloading before next code line
Range names in a Excell macros
RESIZE USEDRANGE
re-calc
appending some text/html to the "discription" field
dimensioning variables
excel to word
Button on a sheet always visible
splitting information into 2 cells
Sorting code
checking Column for matching value
Need Help with Dynamic Chart Worksheet Change Macro
Macro problem...Will be a real challange
Can't see all of one of my sheets
How to distribute Macros/write add-ins in Office product
Validation List advise....
Duplicated occurrences of class variables - VBA in Excel
Duplicated occurrences of class variables - VBA in Excel
Auto notify a list of people via email when excel file is closed
how to match/compare cell values
Data validation, alpha or numeric characters
bug in Excel 12?
Create Hotmail Msg from Excel
looping through chartobjects returns deleted charts also
Excel PageSetup Error even when a printer Exists
empty cells
Email Help Please
EssVSetGlobalOption , 6
Command Button Date/Time Stamp
Merging Macro - GetOpenFilename & Workbooks.OpenText
Import Text File Into A Spreadsheet with over 65,000 lines
Retain Format When Coping Visible Cells Only to New Worksheet
How do I turn on relative reference(?) in a macro (97ver had butto
Using DSUM on a Recordset
BackStyle Property misbehavior
VBA - remove all empty rows in a worksheet
Can an Excel macro be automatically run based upon data in a cell?
copy row and paste to another worksheet
same info different sheets different cells
Emailing an Excel sheet?
optimization question
File Could not be Found
Automatically enter custom worksheets?
Last Saved By property
VB 255 character limit for strings
Copy Sorted Coloumn
Displaying Multiple values with message boxes
Displaying multiple values in a message box
if statement
Rounding Numbers
OnKey
Clear selection?
inputing data
VBE Module Names
MS Query - '' is not a valid name
How to populate an MSForms.ReturnInteger value
Multipage questions
Problem copying sheets
Text Export/Append
active cell
VBA Deleting in database from list box
Test User before saving a file.
Eliminating Multiple IF/THEN loops
V Lookup w/ unreliable data
Forms - Named Range as the RowSource
Required fields
Merging data
Macro syntax to open file in current explorer folder
RE: Divide Monthly Sales Budget to Day budget
Macro Location Problem
Call Excel Macro in VB.NET
Issue in VBA functions
Refrence to Listbox in form
Copy Sheet
Excel 2003 - Keep a Macro Running While the Workbook is Open
How to pop up a Macro when the cell in one column is selected-urge
Mail_ActiveSheet()
Notification
get data from an Internet Explorer Table
Return Array from Function
shifting data in excel (logs)
Double lookup count
runtime error 424
Searching for and Pasting Data to a new file
is there a way to do this
ORACLE SEQUENCES IN EXCEL
VBA Code
Error Handling on my program
PHP's fgetcsv converting ¿0a to \n ?
Inputing data twice into a Query
Only Printing Header on First Page
Looking for the truth !!
Userforms and Checkboxes
Turning Off Circular Refrences on open
Opening an excel workbook doesnt work
Adding an Add-in to a menu
Writing a macro
event triggered by cell format change?
Adding an OFFSET condition to a COUNTIF??
How to disable Max button on the Excel Workbook
Selecting all sheets and sheet methods
Macro finishes faster when left clicking during execution
export excel data to another sheet
crate formula in VBA
Unlock a vb code of a workbook
Excel to open word document -basics
Why do VBA and Excel floating point results differ?
multiple range using GetRange()
Deleting in a list box
vba
adding code to a workbook programmably
inputing data using vba
IF Clause
Copy rows from different worksheets
Returning the index of an array value?
Save as file name and specific field
Populate word doc with excel data
'Cell is protected' after VBA runs
Decompile Excel VBA code
Hyperlink multiple Images in at one time
Control Tip Text on Excel Command Buttons
Excel-Web Queries to Babelfish
corrupted .xls / Copy Modules???
Code to Advance filter a list in a shared workbook
Coding questions about UserForm TextBox
add comment to object
Excel template in Public Folder opens actual file
Late Binding Issues - My Bad
Help with UserForm textbox code
writting data in the next available column
Late Binding Issues
Creating spreadsheet of Outlook emails
Need to compare values in two colums and delete accordingly
Dynamically change cell range in formula by background color?
Show value of variable on mouse-over in debug mode - bug?
Copy method of worksheet class failed - help!
lock button position
AutoFill Weekdays problem
Setting The Print Area
Define User Access Levels to Workbooks
How do I learn to write Visual Basic into an Excel Macro?
File Error - data may be lost???
Toolbar should not be on its own row!
Compile Error
Help with UserForm textbox code
ComboBox Range
Re: Variable range of rows
How to Combine Data Regions
Linking a cell to a textbox
Insert Hyperlink
SAP Late Binding Problem
Insert leading spaces
Corrupt Excel File
Code to hide Entire row based on criteria
Sum Question
Zoombox
Remove ' if not followed by two digits
How to Connect Data with ComboBoxes and Dependency on each other
Posting times to an Excel spreadsheet
Custom Number Format
How to wrap text in a ListBox
Print Macro
ADO Recordset.Filter in Excel 2002
Performing Action On Multiple Values In A Column
Marking Dupes
combining two worksheets into one
Enter Formula via VBA
migration issue - OpenText method crashes Excel.
Is there a list of VB addressable fields for Excel ?
HOW TO: Name Range?
Run-Time error 1004
Return selected option from a control
Runtime Error
calculations based upon months
Userform Status
Identify the column of a range by letter instead of number
Syntax for Logical Operators to Limit Input?
Missing library in Object Browser
Modifying an Old Excel Macro
Check for duplicate values?
Macro To Scroll Worksheet Automatically ?
How to exclude certain cells from a range?
Selecting a range from second row onward
Changing save as file format for excel from VB.net
Excel VBA: Automatic grouping same entries
Concatenating text
USERFORM DISAPPEARS ON EXCEL MINIMIZE
If number then... how?
Protect cell and remove row datas
FollowHyperlink failing
Macro for counting the number of filtered rows
ITeS and BPO jobs or Projects
ITeS and BPO jobs or Projects
New to accessing mysql dbase in excel vba
Save As
Refedit gets mad with touchpad
replace one tag in content of one cell and format not changed
Excel Got FOcus event
Keeping a named range between 2 dates??
Fill empty cells
Multiple column Combobox
Connecting to Simcorp Dimension
Moving worksheet
Shell command to post to notepad
The form name changes everytime we open the page
interesting solver problem.
Help in Pasting from 1 workbook to another in code
Code help required
Copying a range to a new tab
VBA Excel Chart DateFormat Language Settings Locale
Need Help using/calling a Reference
Alphabetize when data changes
Compare data between 2 worksheets
Need Help using/calling a Reference
Scriptin.FileSystem Network Unavailable
Scripting.FileSystem Network Unavailable
macro to input data on a specific date
Need help with this formula in a macro, please
Re: Calling a DLL Trouble
vba range in vlookup
how to loop thru cell in 2 columns
How do I automatically calculate dollars earned with time worked?
how many Fridays in a specific month in Excel
Macro for importing data from one file to another
How to pick the first day in and the last day out in a PivotTabel?
VBA code for different versions of Excel
export as vba macro
How to print specific worksheets
Identifying duplicate content in column
Excel problem using DisplayAlerts
How can I alter this Macro?
Executing a subroutine from within a loop
Calling a subroutine in a loop
empty cell
Pivot table question
Pivot table question
How can I alter this Macro?
Resource Planning - How to Model?
Search multiple sheets, then paste results in new sheet
What does the '#' character mean when appended to a number?
Alter mask of image on button
Writing to a range of cells
Looping
cloneing cells in different worksheets
Simulate Access' After Update Event
Protecting worksheet within an Macro
Using macros on different versions of Excel
Need Help using/calling a DLL
validation
Help with ammending a script
Need Help Using/Calling DLL Please
Disable events
EXCEL: put_DisplayAlerts fails if user is entering data and clicks toolbar button
Customize ROW/COLUMN header
Error 400
Arrays and Join Function
Dependency problem
Web Query Error 1004 - Cannot insert columns...
imitating cut and paste
Creating Multiple Scorecards/Files and Compiling data
Calling a DLL Trouble
Marco and command buttons
Is Excel VBA best for me?
Mapquest Web Query issue
Cell value change to trigger macro (worksheet change event?)
Rounding
Web Query: Obtaining source link from a cell in a macro
Put a Formula into a Cell with Index
compare two col data & add info
Accessing specific items in a range
Formula in a range which varies in size
Integrate Word and Excel
Prevent Duplicate Validation List Entries
Copy the 14 cells and transfer them to another sheet loop
Keeping the exponent at a fix value in Excel
Re: How to share files
Pivot Table help!
PullDown List with two Columns help!
VBA Help: delete whole row if the cell does not contain string "*"
New custom FaceID for automated button
Worksheets
characters and values
Conditional Formatting
Built-in Excel constant for maximum number of rows, for columns?
ERACE MESSAGE FROM GROUP
Can't open VBA-Code Window
How to program an auto incrementable number in a cell, at each ope
vb help, convert excel formula to vb formula
Please Help!! DD:HH:SS to seconds driving me mad
Removing and Restoring Excel toolbars
Is it possible to create a patch or update an Excel Program?
VBA Code
Inserting a formual with " in it
Remove screen 'flicker' on executing code
Variable Picture in a Form
Search Range for item in seperate range
Page setup
Excel
Master reset code bug - stumped again
Elapsed Time
Is it possible to embed a dialog in a Form?
macro to insert rows & copy cells
Object variable issue
I don't know if this is possible to do but....
Maximum number of worksheets in Excel 2003
string
Share:Fix a time not to be exceeded
printing ppt (to pdf) from excel
"Enter Key"
create formula to compare cell 1 with a range of cell
Absolute Worksheet References
size FaceID picture on commandbutton
Excel 2003 Power Programming With VBA
Master reset code -stumped
Finding Asymptotes from a set of data in Excel
"Excel 2003 Power Programming With VBA" John Walkenbach - pls share
to previous location
how can i call macro in powerpoint file from excel file
Using a Macro to Change the Value of a Check Box or Combo Box
Using "Equiv" excel fonction in vba
Application.OnKey syntax for + and - keys
Selection of data in a sheet
Color Palette
save and closing when hyperlink accessed
Scroll through Range
Excel Form ????
Prevent UDF from calculating when opening file
How can I get Excel filtered data into a word mail merge using a m
I'm not even sure this is possible anymore!
Error 1004, Application-definded or object-defined error
Excel error when called from vb script
Excel error when called from vb script
Macro to access data in an array?
User Interface for Viewing a Collection of Data Files
How to trigger a macro at regular intervals?
Transform table
Finding cell closest to textbox
Disabling or capturing a Delete Sheet command
csv files not opening in full excel.
updating all links in powerpoint presentation
Sharing a workbook breaks VBA code?
Add new entry to list
Mail a row to each person in a range (HTML) - by Ron de Bruin
Modify a process priority
Change Order of Inserted Worksheets
Finding the first empty cell in a column
Testing Range to see if value in another Range
File as TSR
Combining cell values in a list
Adding the VB Timer Control...
Copying Data from various spreadsheets
Creating a year of weekdays automatically?
Offset
Break link between excel and access
Changing Sheet Names
Prompting a user to open Read Only
Copy From One WorkbookTo Another
VB Code For Macro
Multiple versions of excel ...
Editing an Excel MAcro
Excel VB Programing
freezepanes
How to compare values in different columns and indicate outcome
Combinations from group in Excel
merging multiple named ranges for validation list
QUERY: API/SDK for Excel
Quickie... How to change a name with a macro?
Protected Excelsheet
Drop Down List
Trying to autopopulate a Save as filename
A macros for listing information
Rightclicking with 'sendkeys'
file error: data may have been lost problem
Save a cell location and return to it
Problem with Dialogs(xlDialogWorkbookNew)
Checking for the border style of a range
Searching through the contents of a Folder of text files
Excel Functions - Recursive
Runtime Error
a
Help with Macro. -- User input for sheet name
selection.copy - how to emulate Paste command?
Hide Rows meeting condition Amendment
Saving backup file on file open
cell formatting
Importing data from text file
diff toolbar for diff workbook
add numbers to a list on a conditional basis
Work out Days Between Two Dates
Pivot Tables
How can I use a macro to hyperlink multiple files at once?
How to copy and paste in VB
Help needed with setting up a complex directive
How to color pages of Multtipage
excel help --- urgently
copy data from a specific range to another sheet
Excel Average Function help
Subtract 1 year from todays date
"Show Placeholder" feature in options/view doesnt work
"Show Placeholder" feature in options/view doesnt work
How to create a formula with ListBox toa othes Sheet
Compare and Lookup
Multiple Columns to Freeze
HTML
combine data from multiple worksheet
Positioning Numeric Values Resulting from 6 Column Array Formula
Macro to edit Range Name
Creating a .EXE to run excel macros
Macro to import from one closed workbook
worksheet change
How do I find out if a cell has my word in it?
converting ppt to pdf launched from xls
Excel Analysis ToolPak - Bug when installed from Code
converting ppt to pdf launched from xls
I don't want to see scroling which VBA does, adding a progress bar
On Time Function
using Formulas in VBA
Could someone please debug this short macro for me? I'm stuck!
Macro To Move Cell Over
Automatically Update Cells bases on another workbook.
Cut & insert columns not working
What's wrong with this code? Please help.
Temporary Folder Location
Excel User Form using 2 Combo Box with 1st Combon controling the 2
changing font type in a footer
Is it possible for a single chart to have multiple Y axes scales
How can I move a sheet to the end of the workbook in VB?
vblf and vbcr one last question
Programatically Unlocking a Project in the VBIDE
Pulling apart a string
Worksheet_Change
Sum in a dynamic range
Print List Box
Can't see opened workbook
Picture Cropping Challenge
Releasing reference to the Application object before exiting
Run macro from name stored in variable?
Assigning multiple text strings to variables
Can macro display a diff't screen while it runs until it stops?
how to call a function procedure
left padding + blank
Having trouble with "vbcr"
change type of a file
Datepart problem
NEXT/PREVIOUS OPTIONBUTTON
Please help with Application.Wait ( )
Excel User form - print landscape
Trouble Passing An Array
Format data
If statement formula/challenge
empty rows in range
How this function is read?
Code to tranpose table
Checking the existence of a reference workbook
How to delete row if column is blank or certain text
syntax for range selection
validation help with drop down
Need Excel to use a 5 Day Week
Does a worksheet exist?
Deleting blank values from an array
Removing Cell/Row Values Condition
MultiSelect Popup
Chart DataLabel Alignment / Word Wrap
undo date format questions
Grabbing text from just part of a cell
VBA conditional formatting
Macro to save Excel file with date and time in the file name?
VBA: Group Pivot Table and Combo Box
Excel and VB6 COM -- Isolated Error 438 & 430
Single command to toggle a Boolean?
Macro for opening new files and copying from them - please help!
Street numbers
About going through all the cells in a sheet....
Positioning Numeric Values Resulting from 6 Column Array Formula
Customizing FaceID options
how to catch a value in the format like "0E085"
Select Case Question
Excel Spreadsheet 10.0 - Scrolling Down - HELP
Extract selective data from a spreadsheet
HELP: print macro woes :S
Linking if-statements in a macro to different workbooks in Excel (using VB)
Excel: How to create a form to search for rows in another sheet?
Subtotal database based on column with faked date
Box to select printers
Highlighting cell if content is duplicate
Essbase Combobox
Page Breaks in Excel
Replacing dots with commas using macro
Max/Min for variable length columns
change type of a file
Can you share a personal macro workbook
Deleting duplicated values
copy worksheet
VBA to open .exe file
Determining if a named range exists
Intellisense does not pup up?
How To, Drawingobject Text Boxes:
Macro That Deletes Columns
Table to Table
Automation on a spreadsheet
Error locking cell
Excel to SQL db
Vanishing Command Buttons
Looping macro needed to find intersections of rows and columns
Notification upon submission of data?
Listview Question
Reseting controls
Unique identifier
change type of a file
Code error!
Progressbar during the CalulateFull execution
Macro copying cells between sheets
I am using visual basic express edition 2005
create function with passing parameters
extracting data
My excel buttons and formulae disappeared after running macro
Copy Rows from one worksheet to another by entering the Name of the Staff
User Defined formula, selecting range
Newbie Question - vlookup, I think
Trying to append to file using an array
Convert a string value to numeric and sort
formatting dates
searching a large database with a long list of search terms
Making the drop down list of a cell depend on another cell
NEED A INVOICE PROGRAM THAT REMEMBERS VENDOR'S NAMES, ANY IDEAS?
This is embarrassing - I lost my Macro recorder button!
Adding Numbers
deleting worksheets corrupts files
Strange CPU deadlock in very short macro
drop down that refers to another drop down in excel
rename all files in a folder
Setting visible range
Userform problem, bordercolor not changing around images
setfocus in textbox on multipage
"Show Placeholders" in options/view menu does'nt work.
"Show Placeholders" in options/view menu does'nt work.
range average code
Convert Adobe Acrobat (RDF / PDF) file to Excel through code
Inserting Last Date Modified in Footer
Randomization of groupings based on value
VBA - Text To Columns
QueryTables command
calculating hours
ControlTipText in a ListBox, doesnt refresh
Get Relative Data from result of MIN function
Adding a Chart Datalabel with a Webding
using personal graphic for faceid
identify little squares for Alt Enter
Multiple Menus
Loop in Excell with VBA-code.
Finding duplicates in list during UserForm entry process
how can i use the ISNA and Vlookup funtions in a macro?
Sort problem - part2
Clearing cells
VB to produce a record of all files in a directory
Breakpoint ok, no breakpoint messes up...
Sumproduct to count
VBA Referencing a cell
Excel Add-In Release/Test Procedure
Excel Add-In Release/Test Procedure
macro to change date ranges
Macro for button - copy and paste rows
VBA dynamically format Row1
How to reference list using a drop down menu, displaying the list
Subscript out of range error
Looping to fill ListBox
access excel control from vb.net
ASP Page not opening a new Excel Spreadsheet each time.
ASP Page not opening a new Excel Spreadsheet each time.
Project Unviewable???
Copy Specific Cells depending upon cursor location in Excel
External database causing problems?
drop-down list changing according to choice made
activating cell which is in rowMatch, columnMatch of two given val
if & and code problem
Is there anyway to do this?
Entering variables on Msgbox prompt
Shell & VBA
Copy Paste Macro
Copy Paste Macro
Suppressing Remote References Problem
No duplicates in column
subtotal based on ref no
Creating Loop to Paste Array
Moving left/right from active cell
Line Wrap Problem
Renaming Invalid Defined Names
Global Names Issue
Why these commands make erros? (Breaklink and SaveAs)
Linefeed character creates runtime error in Sweden
Reading Active Directory from VBA?
Filtering merged cells
Average if
find sum in list of of numbers
Range names are created with the English format : for ex. _15_Feb_06
No permit dupes in listbox...
sql query from excel
Activate Workbook
what if the configured proxy server does not connect
Find Macro across workbook
User form - print Landscape
Multiple tests for a condition
Transpose rows to columns with varying numbers of lines per record
a macro to run for each file in the same folder
a macro to run on all the file in the same folder
Filename from the result of a Filesearch
Different Behaviour of Public Object Vars in Worksheets vs. Add-In
Setting Cell Type From Word Macro
reading data in to Access From Excel
Macro Path
Import Macro
Multiply Y ases Scales
Windows Common Controls
how can I assign a password to a command button
Concatenate Macro
How do make a macro activate the next sheet?
A Mirror Copy of a Sheet with Different Outlook
"Delete" method of a worksheet object
Importing into Excel from FileMaker
Comparing Cell Value With A Reference
Quickly determining whether any values in a range are empty
Value# in VBA script with reference
Modify a macro
Ensure single class instance but with multiple references to it
copy 1 array to another array
Excel Web Query not working!
Microsoft Error Report - Excel with VBA
Find, Copy and Paste question
SQL Select Statement in Excel
how to select a Row based on contents of a Cell
UserForm ComboBox RowSource Problem
How to Copy a project plan to Excel through macro or batch file?
Unhiding specific worksheets in VBA (Excel 2003)
help with a formula for counting
Opening worbooks with a variable file name.
Import External Data Macro
Repetitive Spreadsheet Formatting Automation
Prinout function
Multiple Range Selection
Delete an image from the cell
Can't programmatically set a large array string to a range.
Selectionstart
Mac Excel for 2004 macro date problem
Substituting cell content into a formula
"Record Macro" toolbar in Excel 97?
"Record Macro" toolbar in Excel 97?
Update a range within a macro using an input box or similar
how do i program excel to add two times together
visible zeros
Runtime Error Paste Method of Worksheet class failed
Set the selected range myrange
Combine a Dlookup with DMAX function
UserForm1 not getting removed using VBA
Interop problem with VS.NET 2003
Simple Find Text problem
How can I automate filling in a Web form with Excel data?
How to reverse data in an Array
Help: Converting Pluses and Times to Sum and Product Functions ???
displaying data that does not meet criteria
Learning Excel programming
Input$ Userform
Print Macro V
Lookup/sort values
Excel 2000 GETPIVOTDATA
Why is my macro looking for the original file I created it on?
How do I isolate the Fractional part of a number in Excel VB?
Userform button setting variable from formula
Userform button setting variable from formula
Filling an array with a Loop
Cell fill color. Row to match specific cell.
Excel bugs? Experience with paid ($245) phone support from MS?
Excel Viewer for Windows ME
Same code - different results
Show Modeless Form
Protect sheet
VBA Macro to Clear Named Cell Contents
Intelligent picture cropping
Workbook Open Event not triggering
How a function can modify a value from some cells ?
Subtotals
Print Macro
Concatenation problems...
Setting a maximum field value to 100%
Problems on Protected Sheet
Updating a database table
need assistance with some find or lookup related code...
Set MyRange for non-adjacent cells and iterate through?
easy solution, just cant remember how to
getline from a macro
Closing a referenced workbook
Problem with Excel Header/Footer from .NET ???
Highlight text in textboxes
Need some help please
Can I place "On Error GOTO xxx" into module level?
Userform data retrieval
How do I copy selected cells in excel and paste into word table
Sort of a problem?
Range - select row
Application GoTo
can i use sumproduct this way in VB?
Help with SaveAs prompt
Dynamically changing font size of combo box
Display a macro at top of macro list?
keypress
Max Max
VBA - naming modules
Excel Date Problem
Trendline Coefficients
Would like to retrieve data from spreadsheet to userform
Horizontal sort??
Add macro to excel toolbar from worksheet
Sort by Alpha, ignore blanks
to open a pdf file from a macro in excel
Clear events scheduled with Ontime method
little help: "quick comment"
Finding a match and removing if found?
Distributing a workbook app with References
Specifying table in Word then creating it in Excel
Range address from Excel in C#
Printout
Using Excel function with variable
Difine a range with variable
a question
Why unable to set cell's ColorIndex property?
Can't seem to find the error with this code
Moving The Selected Record From One Sheet To Another
Rename Multiple Sheets - Help with Mr Dave Peterson's Code
Formula problem in code
Run time error (Copy Method of Worksheet class failed)
Tracking client contacts
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB.
Basic forecasting and scenario comparisons
Question about PivotTable
calculate date diff in a cell
Error trapping for the Form_Activate() event
Save a variable value outside a macro
Collection from Range, tag cells on error
HOW DO I USE THE GETSAVEASFILENAME METHOD?
VLookup or other?
Cells.Find method and Boolean operators
Changing a constant
Variables and graphs
http address for shared files in web mail
ListBox Click...
new green cell comments in Excel 2003
Passwords etc
Moving Rows Up - based on contents
how to create xls from CSV files