Excel Programming [Archive] - Page 122

Error notification
Resize Message Box
MS Excel
Error Message
How to remove "(All)" from pivot table using VBA
Ignore punctuation
if function
Setting a cell comment's font
Map of controls-numbers
Multiple chart copy
SAVE AS menu option
Display toolbar icons on form button
Filling Array from Cells on Worksheet
NCAA Basketball Bracket VBA Color Coding for Winners on Worksheet_ChangeEvent...
Disable alert message when merging cells??
Double Click to open external program
count cells with values
How to fix cell.entirerow.delete?
Getting top 5 values in a list of numbers
Matching cells & returning values
xmlhttp and ie cache
VBA How to set the header and footers of an excel worksheet
How to edit VB code programmatically
Why does macro change print range?
Password prompt appears when closing Excel
How do I define a Format Cell Number Category
name a picture
macros to make macros
ACT Database and Excel
Fishbone Diagrams
Conditional Formatting
Modify calculated result?
lesser equal ?
CONCATENATE-1
CONCATENATE-1
CONCATENATE 1
Automated Saving of File
CONCATENATE
Supressing CHR13 or vbCr write in text file
=TODAY() + 1 format
searching a table - fast!
Calculate page setup zoom value for 1 to 1 printing
Random number generation
Addin question
Re: Fonts on Excel controls messed up in high resolution.
Insert Chart into Word
Custom views error: How to fix?
Number of different items in a column
Creating an access table with ADO
Archery scoring templates.
filter with vb code
Creating a recap of from data in worksheet.
Macro on Mac OSX
How do you define SpinButtons??
Using VB to make certain field or button blink auto on new data
Formulas Help Please!
Help with a formula
Checkbox Help
matching data from table
Excel not quitting - How to avoid global reference?
Excel Data Form
to delete row from userform
Excel Optimization HELP!!!
how to see complete memo field in pivot table drill down detail
Survey
Parse a space delimited string into unique columns
How to tell if Excel is in Browser or Application
Complex Data Validations
Ensuring Conditional formating is not lost
How do I capture the Modified date in a cell?
if a4 has data how can i get f4 to Put the current time in it
sheet select
Making a UserForm to appear!
Deleting tabs in Excel
Macro help
Protect my macros
Macro - relative end of data
Row incrementation not working.
Clear Cell Macro using an array
Replace debug error box
Calculating the last day of the week
Macro to copy sheet
How do I use vb to move from worksheet to worksheet in a workbook.
How to update cells with Data validation in them?
comparing distinct data
Dropdown list for font size, font type and number formats
System variables
print envelope
copy worksheet with formulas and vba function
Link Second drop-down list to a Worksheet
Returning a date from a UserForm
How to create dialox boxes?
Error 1004
Solver: An unexpected internal error occurred, or available memory
flashing screen
Macro to clear error
Caontains.
Conditional Formatting
Macro user defined function row information
loop in range
Arrays in User defined functions
Macros
Can some one help me create a complex formula
Shortcut to unknown Excelversion
Access export to multiple sheets in Excel
Exporting to several xls files
How to get ShowModal property
Invalid Pathname
Preloading value into Option Button
Listbox Question
Exists?
how can I select two different values for a cell?
standard data form direct to an excel spreadsheet
VBA - How to change the decimal sign
EXCEL.EXE is not killed
Date format problem in Excel
owc next version must support datasets
Like Operator vs Regular Expressions
macro to import file (help with a piece of code)
How do I get this multiple of string information to fit ina bookm
charting series that are into different files (prompting each time)
Putting Sheet Names on a list
Macro Question?
how to prepare production schedule
Information building?
Inserting row based on value in cell in Column C
Shuffling a Data List
Printing Address Labels
Bookmarks help
How do I make this string bold?
This application is about to initialize controls that might be unsafe. ...
Combine Strings into One String
Worksheet Specific Code
Listbox Question
Application.SendKeys won't work with Remote Desktop????
Handling of userforms and popup menu's with dual monitor
Log UserID
Linking a range in a class to a cell, with change notification
Where are the temp excel files kept?
Run time Error 402
tough date macro....help needed....
a loop formula that filters and prints?
Conditional formating
Using Code to Adjust Specific Column Width
SubTotal Labels
Printing Labels using Excel
Enhancing Excel's Random Number Generator!
creating macros in excel
why is range empty?
Pivot table creation error VBA XLS
Remove Spaces
Is this possible Yes or no.
Printing a word doc via macro/VBS/Excel
Syntax Error help
network notification from excel macro
vlookup question
using Subtotals in XL-VBA
userforms / worksheets
Use variables in sql statement
Date Pickers on a MultiPage control
Vlookup Error
Querry Range and Add
Using Loop to insert a row
I need a macro that will age receivables
VBA error in Excel 2003
How to make macro start when file is opened
Setting Print Area
Adding code to workbook_open at runtime
to call WebBrowser in a macro?
links update problem
viewing seperate data in a worksheet
Automation
Automation
VBA Project Password prompt on Exit
Viewing a worksheet while a UserForm is active
How do I enable 'ctrl alt x' to open up Excel on my computer?
Annoying web toolbar
summing numbers
Link Second drop-down list to a Worksheet
two word last names
Hide part of Pivot Table
Find Cell and Copy adjacent value to another location
The Pictures Collection
How can I test if a date is a workday?
Data to a specific location into a word document
Modal Forms
Changing pivot table views with a macro
VBA formula
When you edit a macro in visual basic editor, why doesn't it upda.
Column numbers
Workbook_Open macro - what gives?
coping custom menu items
Excel.Application.Quit() method
Excel.Application.Quit()
Getting file names in a directory
Excel file protection?
Hiding Tabs
Setting 'Track Changes' as default
how to copy succeeding rows from source workbook to destination w.
array
Access query from Excel
Multiple Option Buttons
How to get Signature property!
when condition is true, move row to end of different sheet
Displaying the Hourglass in Excel
Microsoft Office Excel is waiting for another application to complete an OLE action
charting series
Shorten Code for repeated function use
CountFunctionality
Re: Time Stamp/Locking Cell Computation
Sheet code
Visual Studio Tools for Microsoft Office System 2003
sorting problem
owc11 pivot table should also be filled by DataSet
How to auto acknowledge a prompt box, Macro
Find Last Row or Empty Row in VBA
Test for presence of chart on active sheet
Excel interacting with HTML Image Maps
Event procedures for controls added with Controls.Add
Re: Error in FM20.dll when inserting userform
How to use Cells property to Range object?
How to Get Reference of CommandBar in Excel?
Spawn Add Printer Wizard from Hyperlink
Print_Titles and mutiple <table> tags: problems during load
String Comparison
Too many different cell formats
Hide graphics export progress bar
How to I put a comma in between each column item from this code
Macro shortcuts
Charts with Xvalue and YValue?
excel employee schedule
Combining On Open Macros
Retain values of combo box
Re: how to show time on the caption of excel window?
Excel to Word
Sharing macros
button to return to top of spreadsheet
Hyperlink question
new macro question
Does Excel have a SheetBeforeChange Event?
Search, Verify, Sum, Return
Hiding sheets
One userform for many uses
COUNTIF data counting
VBA Excel Help - Filename
Hide objects based on value in cell
Changing Cells
Excel automation and Shared Workbooks
"ATPVBAEN.XLA!Random... output
On Close macro
need help sorting data in browser
Sending e mail with attachment from button click
Query that returns a value to variable
Re: pattern matching w/o using VBScript's RegExp Object
userform problems
Multiple test loops
How to find last row/column with vba?
hex conversion table
Using VB to create "conditional formatting"
embeding worksheet from vb into excel
Filter and Print Problem
keep cell as a date cell
limited value in a cell ?
Re: Formal to compare a list
Re: List of all names in EXCEL workbook
populating list
Insert module into workbook via automation?
Range Mismatch
Re: VBE Find and replace with pattern
Using FSO to get Excel data
ToolBar Conflict
2 Charts on 1 Graph: 2 Y-axis?
Code Librarian automation?
RE: Formal to compare a list
RE: various printing from a hiden sheet
Re: Paste range from Clipboard to Excel
Re: various printing from a hiden sheet
Error in Range Statement
Re: Summing N/A's
Centralized Macro
Macro to check for blank responses
RE: various printing from a hiden sheet
Skipping 'reopen' file prompt box using VBA
assigning value in macro
Re: List of all names in EXCEL workbook
Deny change of value of two target cells / enforce use of macros.
Re: Excel in Distribution Package
Pass variables value to Shell
Drop-down list items are missing after reopen Workbook
RegEx to parse something like this...
Re: Save sheet as new file w/o refs to original?
Re: Paste range from Clipboard to Excel
Re: Save sheet as new file w/o refs to original?
Generalising macro 2 cycle thru checkboxes in frames/pages on User
Value not quite the same as formula result
problem in protecting excel worksheet
Auto numbering cells
How to query Excel Data Using SQL?
Finding file names
Programming Line Breaks into Cells
Simple Copy and Paste
How do I transpose entries that repeat in sequence down a column .
Problem with RegWrite (Permission)
Date for ToggleHeadings macro
one last macro question
one more macro question
one last macro question
one more macro question
drop down list item missing
Need to keep text format when retrieving records from database
Range within another Range
macro not working as intended
paste formula without workbook reference
subscript out of range (newbie)
Is there a "key-up" type event for a worksheet?
Protecting certain cells
Merge & align ..left?
error 400, i cant figure this out..
Slow running of Excel macros embedded in an ActiveX
inputing formula
multiple sheets to printer
How can I delete row from userform?
How do I open and print selected embedded .docs in Excel
Loop in a Range
Need help with do while loop
Get list of subfolders
How do I import text file, analyze data, export results, open next file
Making sheets visible / hidden
Making sheets visible and hidden to users
Deleting Rows
Followup question for Tom
excel row sorting problem
re: vlookup in a msword macro returning an error
Another syntax question (different from earlier post)
Retrieve and update 1 record at a time
Aggregating data
Excel efficiency question...
Why does this code take so long to execute.
Microsoft Calendar Control
Definition of a statistical function (CQC) in Excel (maybe with VBA...)
Disabling "Entire &row/&column" in Delete/Insert Cell
Replacing hard code with reference to a cell value
Delete Modules in Macro
Using ADO to CopyFromRecordset to another sheet
Re: I Want to Caculate only ONE Cell !!!
I want to maintain a master listing and accept input and output?
Select cell with upper case letters
vlookups
Order of Excel Addin
help with ActiveSheet.QueryTables.Add Connection:
CommandButton, ControlTipText Need to display like word wrap
match function code?
deleting rows programmatically
For Each cell in Range
Object Requi
Countif with conditional formatting
Datagrid in userform
find cell in particular column
In need of a whacky function
In need of a whacky function-
Creating a Userform using code
Delete a file from Excel Application
Reading the Registry
Identify Full Path of Opened Excel Workbook
HowTo add and name 2 wks to wkbk
import txt files with more than 256 col and other tips
Installing add-in for all users
how do i create a pop up box to prompt the user for info?
CUMIPMT
formula problem
Skip Column when using Tab or arrow
Counting Characters in a cell
ActiveX Controls Look Funky,..?
Number Formating
Sales Help - Plano TX
Default Path for File Open
Simple macro help
Browse and attach file in a UserForm
Open Word Template
Merging columns and adding separators
I want to add a group of cells, using a sumif of another group of.
Varying a Formula in an Excel Spreadsheet
Write-back formulas in comment boxes into underlying cells
SQL server -> Excel
Hyperlink in multicolumn listbox
Creating a Macro
selecting a variable row range
Having A Macro Run When A Selection Is Made In A List Box
Button Help
Spitting data in a single cell
copy macro help
selecting a range of cells
Book 1
Search column - return row found in long text string
Copy range from 1 wks to another w/loop
MACRO - copy rows based on value in column to another sheet
Updating Multiple Workbooks
copy to another sheet based on column value
Column Property, Indirect reference?
Select range of cells and move
copy from closed workbook again! ;(
SmartDoc ActiveX
How do I access the MSNStockQuoteRefreshAll function in VBA code .
Merging files
numerical values for verticalalignment | colors
Working with a range within a range ?
Determining number of values in an array (2 related questions)
Open Workbooks Return
Displaying results of loop in cells
Model = False or vb Modeless??
Help with a sproc using a xml input parm
Macro Question Part II
round a 15 digit decimal down from .05
How to programmatically add a digital signature to a workbook
VB6.0 ADO question
Deleting rows if cell is blank
Excel 2003 will not terminate with application.quit
Select Range
Syntax problem in defining OnAction macro definition held in Add-in!
Summing a range. Please Help!
Hide file path on a text box
mimic Working Days in ATP
vba variable
Another Cell formatting Question.
Editor question
Form does not disappear
stop userform from initializing
Opening An Excel Application and "Analysis ToolPac" does not load
CSV output file
Copy data from a closed workbook (ADO)
Is there a "Set sourceRange =" for all sheets in workbook
Upload Excel to Access
Auto run macro on *.csv file open
sometimes it takes one variable, sometimes another ...
Axes(xlCategory).TickLabels problem
Excel question with variable definition
Usin Picture on userform
Newbie Q: Error handling procedures in a loop
Command for posting entry to the next empty cell
HasExternalLink Function
Autofilter and Copy and Paste
Blank entries on multipage userform
Download ZIP file from ftp using macro?
Why macro slow on one, fast on another?
ActiveX command button
Help with SaveAs
error excel if embedded in word documents
How to insert a breakpoint and run the Workbook_Open event ??
testrl
Dynamic range naming in VB6.3 for Excel
Formula for an Excel spreadsheet
Data from other files & Match?
Pivot tables, using rows instead of columns
translating formulas
Delete Rows based on number of instances
sort
Re: Thanks: select alternate rows - quickly (FAO Frank Kabel)
Error using Word object library in Excel (VBA)
Problem with code about ranges
Backing Up
Area references highliting from addin
Macro to align & compare multiple columns with several rows
dynamic Ranges
'Group by' facility?
animated clip art
On Error doesn't trap Application.Run error
Chart location method fails using sheet name
Table
Cell Address of last piece of data on spreadsheet
link to a DHL tracking site
Automating conform of cell contents so they MATCH
FileFormat:=xlCSV for a cell with =TODAY() gives unwantedamerican
External references
circularity
If Font.ColorIndex = 5 then . . .
how can i use an if statement to run a macro?
Userform with Multiple ListBoxes not working
Named range longer than 255 chars
Using Hyperlink via code
Continuous conversion of data from rows to columns
use of module level variables
Excel XP error message Run Time Error 91
Toolbars
Ignoring Sheet in For Each Loop
Excel into DataTable using OleDbDataAdapter
formName.Show
Clear values
keeping form open
Lookup Formula
Test & replace value
file delete in Excel receives permission denied by Server 2003
Excel to Texfile Help needed
Creating PDF Files from Multiple Worksheets Using VBA
to DAO, or not to DAO
Input Box default value as a date
Passing an array as argument for custom Function
Open Sheet
copy data from a closed workbook
Macros loading under XL2003
Deleting multiple Chart Tabs/sheets
Hyperlink via code
Extract numbers from a string ?
Macro Question
"File Not Found" prompting
Pivot Table Problem
Fill Data from dererent file into one file.
finding a subtotal
Using Hyperlink via code
discover cell causing column width
Using Find and Replace
Calculating cells.
Re-Alphabetize list with hidden rows
Creating a drop down list
copy paste program
excel fehlermeldung parameter
Open Access Database through Excel
Pulling data into text box
How to add a new column with the previous column formula?
How to compare to fields and move data?
Events for controls created on the fly on a userform
Error on select statement
Pulling data into textbox from spreadsheet
Calculate Date
Date Format problem
Another Application is Trying ...
Copy of sheet contains the named 'Control'. Action required.
Problems with Printout Method
Group All Sheets in a workbook
importing info from a website using a macro function
Free rolodex program
Formula won't work on some computers
Paste in WinWord, problems with several processes
what is the VBA code for VLOOKUP?
Range Object with Find and Offset
Vlookup still not working
Counting # of monthly invoices
Best way to import fixed-width delimited text files into an array?
Enable change only with Form?
A bit bamboozeled
SELECTING CURRENT DATE BY OPENING WORKBOOK
Adding icons to a listview on a userform
Pemission to create a directory
PCDMIS To Excel !
Excel control in HTML
Excel control in HTML
Can you automate object library references?
Late binding to .XLA library??
Help with if function
Trying to read in a CSV file into an Excel one when you open it
viewing big charts
How to return row #
Drillthrough MDX ERROR(Error.Number:-21467259) ?(urgent question)
Backing up my folders
Saving question
Changing chart title changes position of chart
sheet protection and autofilter
Last Name First pt2
Conditional Formatting using VBA
CELL CHANGE EVENT
variable path in a link
How to determine Office version
Do loops within Do loops
three line program...
Problem setting font size
Who knows macros??
Who Know Macros??
Handling Server Paths in code
USB NT4.0
Automation / Shared Add-in VS.NET
Find a word in my spreadsheet
If Statement Problem Part 2!
IF Statement Problem
Cannot send out Excel workbook through Outlook Express
Formatting rows using SubTotal
add symbols to DMS
Continued Conversion of data from rows to columns in a macro.
Last Name First
Change function to macro
Userform then export to summary to spreadsheet w. ability to edit
Changing Macro Security
Check if textbox is open
Custom Commandbar
charting code hanging up
File Name
while use enters text in textbox1 I want the textbox to auto compl
VLOOKUP problem
Downloading Excel spreadsheet to client
excel been moved or removed
removeing a ' symbol
export data from Excel to MS Access (ADO) using VBA
Importing from a data range
#NAME?
excel macro with strings
Reference a cell in a worksheet from a userform
vba excel guide
Use of Excel APIs for multiple versions of Excel
Load an array with Sheet names
Optimizing Code
Hardware Question USB & NT4.0
Application.MemoryFree
The VBA code for solver does not pick up 'change cells' and 'set .
Connecting to SQL from Excel
Help - Controls Shift after print preview?
Run some code on a left click
AUTOFILTER QUESTION
Checking a complex userform for blank entries
Check online network availability
Format Data using macro
macro wont work
AutoCAD Help
Store Macros in separate Fiel
AutoCAD
Use a function to format cells?
Conditional Formating planned VS actual date
Set array element to empty
Error on fetching object in OLEObject
File referencing in macro
Comparing values in non contigious cells
Excel - VBA - QueryTable error 1004
Drawing Object
VBA: Reference to a workbook / amount of days
DataSet to Excel/text
how to programmatically display data into an excel worksheet
Replacing a module with an updated version
Why no cell wrap...?
Question about variable scope
Using variables in the Range command
can I list only the protected?
On Error Resume Next
Go to a specific sheet on open
increment dates in alternate cells automatically
CDO Mail
error message with userforms
Grouping
UserForm TextBoxes (with ControlSource set) won't clear in one click
Copy cell and paste in same column
Strange AutoProtecting of cells
Locked sheet
Determine currently selected cells at start of macro
VBA - number of monthdays ...
On open workbook go to a specific worksheet
call function from another wb : problem
Call XLA function in Visual Basic Macro ?
add rows with copy format of previous row
Return part of string AFTER LAST ":"
WORKSHEET CHANGE HANDLER
Static and Dim outside procedure
Calender Help
.onaction macro call won't work
running a macro on every refresh of the screen
Copying of cell text from one file to paste as cell comments in a 2nd file
Fitting text in cell
Filter out bad email addresses
Macro Slow In Execution Under Excel 2002
Backing up work folder
Number of workdays in a month
Text Sub
VALIDATION LIST
can you import an mp3 to VB in Excel '03 to be played when a form.
Convert wind direction to degrees
VBA Macros and Microsoft.Net
Kill all formulas on all visible sheets w/o affecting sheet formatting
Can I control Macro run automatically current worksheet?
Floating userform
Excel Addin altering date format on text file import
find minimum values in recurring ranges--expert
Dave -
how can i insert an e-mail address to a worksheet using VBA
VBA training
Vlookup
hyperlink to UPS tracking web site
Order of Calculation
SaveAs API Call
Excel 2002/Windows XP - PageSetup error
Excel Addin written in C# issue
Time
Basic Q: Field/Array info when importing fixed-width text files
Passing a Cell Range
Adding a button to Excel, need help please
cell comment
getting rid of trailing zeroes
delete toolbar on workbook close
Disable Worksheet Delete Dialog
How do I get a macro to run automatically when a specific value i.
how do I automatically run a macro when a specific value is enter.
Frame Scrolling
if structure help
Can't get combobox dropdown menus to appear when tabbing between t
I Need VBA Assistance regarding passing a variable from Access
Trace dependents
An interesting prospect.
using a substitute value
Cell Selection
Excel formulas and the relevance of this >>> {
tough question--determine smallest time from range with exceptions
Copying last row to a new sheet
File Size Code not working
Call Subx for excel 97 Add-In subroutine
URLs for good Excel/VBA ressources needed!
need help
RTD Bug? or perhaps a feature?
Excel 2000 does not recognize the timestamp
Report Sum Base on ratio
Worksheet properties
How to keep control over page pagebreaks?
A difficult thing to do¡¡¡
A difficult thing to do¡¡¡¡¡¡¡
VBA project is password protected
Using variables in RCs
Can I prevent a sheet from moving within a workbook?
Can I prevent a sheet from moving within a workbook?
Macro to format all pivotcharts in a workbook
Way to Turn Off Error Checking on a Range?
Bug in Excel? Excel Multithreading ERROR
code is not working on another machine
Loop through Filtered Data
Substitute worksheet function
Delete specific cells contents in a row with some locked cells in the same row
Referring to a column
Change macro security using VBA?
formating parts of a cell
Conditional protection or protect a selection
Delete Rows whose value is not between 2 dates
TEXTBOX in USERFORM
Disable protection menu item
Userform & crash
Macro runs in Excel 2003, bombs in XP - Compatability question
Hourglass
deleting userform or VBA modules by makro
The wrong workbook gets saved!
Use a string in a formula
MyODBC & Excel VBA - Too long query ?
Receiving data from a Lan Port
Automated saving - Please Help & Advice
Is there anyone knows PivotTable about "Select multiple items"(Urg
Macro to Access External Files
Getting stored procedure result to excel
build up an array using formulas
Empty Array
Licence Verification
Printing and Page numbers
PopUp menu for sheet and chart
can we list thouse protected?
Text Box
Change cell color based on date
Are there any templates made for cycle count measurement?
Please help with Range Cells
Toggle between excel sheet and user form
Why won't it work when I use VBA to set autofilter criteria to ce.
Defining new function with cell range parameter
Prevent Paste
VBA and toolbars
copy selected rows to new sheet
duplicate declaration
How to assign an object to a child IE window
Passing Variables Between Procedures
Array Empty After Sub Called
Object on userform can't get focus
Repeating Values
Remove subtotal where only one item
Embedded button print macro
Linking worksheets before/after runnning report
Excel - Marco error .......HELP
Hee's another "for each" question
Embedded Optionbuttons
How do I set up a cell in Excel 2003 to blink
Paste Graphic in Cell's Center
FormulaR1C1
Can Not Add a Reference to a Procedure
Is there a way to set up a one-time default date?
insert picture
Remove all keyboard shortcut keys assigned to macros - an example
Sheet Name question
Format Painter and Worksheet Change Event
Excel4Macro Help File
Copying formula to the bottom of a range
Macro in 1 cell vs entire spreadsheet
Link drawing to cells value
userforms
problem sharing an excel workbook when my formulas reference user.
Chart Object Model
module location
min value in range
creating a document from an xl row
It doesn't add up - It's driving me crazy
Delet all row's with "TOTALS"
Tough Macro Question
Spell Checking a text box.
Need a macro to Identify a users IP address
Named Lists and the letter 'c'?
VBA : Excel Range Selection Problem
automatic row
Calculating daily interest expense
Macros in excel
Weird scenario leading to ResetColors crash
Word to Excel
advanced filter error 1004
Range type of question
Inserting custom worksheets
Compiling Excel VBA code increases workbook file size!
Userform, multipage, select a tab
Input Box
Using For/Next Loop To Generate 4 CommandButtons On A UserForm Results In A Runtime Error 91
Name worksheets dependant on Cell entries
How to embed chart in active worksheet with VBA?
Re: .cells help
Different querytable behaviour in Office 2003?
DISPLAYING INFO IN A LISTBOX
Reseting integers
autofilter with range of partial dates
Help with dates
how to access a value from excel option button using visual basic?
Help, renegade command button
Problems Defining Object Variable in For Each Loop
Advanced Filter problem
Multiple instances of a workbook showing in Project Explorer
Excel, Hash (#) in VBA Calculations
Optimize VBA Excel 2003 NextFor loop
Isblank Code
backwards sum
fill format only
Regular expressions in Excel?
Error 91
Getting system directories
Looping Macro for fixed number of rows
Excel App. level events not firing
Running macro on cells that contain formulas
Copy Cell value from one worksheet to another, then delete.
Programing a drive as a variable
Error message when using the Solver in a VBA macro loop
Strange problem: Computer's date changes when importing data
can i create an excel xml map without having an import file?
Cannot load picture from file!
How do you fire HTML events using Excel to automate IE?
Protection
6 column sort
Code for App level event (not firing)
help new to vba - charts??
Macro to automatically move chart data
Autofit row height
naming tab macro error runtime error 1004
Help with Totals Please
copy a link from one col to another via a formula
Macros
How do I add TextBox.values?
File opening from Custome Toolbar
Re: Code: Using Excel Application level Events
Weeknum
Copying comments from one cell to another
Hide Second Row - Relative (row number changes)
Please help with this...
Re: Problem with CSV file
Re: Hide Show Shts
Assigned specific decimal space
Macros
turn dll into xll
Re: Excel formula conditional upon another cell value
Re: .cells help
Exporting/Import Custom Lists
Programmatically pass query params
Chart location and source...
Combining Cells
Not available
Lotus domino form to excel
Copying from one sheet- Cell formating
Form Caption Logo, How?
Template For Printing Address Labels
Tooltip text over a label
newbie ?: set variables, different shts, equal to each other
to delete a worksheet
How to populate Excel Range from Access RecordSet?
HOW DO I USE MACRO TO FIND REPEATING DATA FROM ANOTHER WORKBOOK
HOW DO I USE MACRO TO FIND REPEATING DATA FROM ANOTHER WORKBOOK
How can i insert image in excel sheet (SYLK) format
how can one put the name of the user at the footer of a sheet
Locking Sheet Tabs as Hidden
Use "Paste Link" info in a cell to Jump to source?
Saving one sheet as a seperate file
FindFile
Please help with code
OLE action?
Textbox.caption to cell if empty, how?
Deleting modules in XLA
macro statement will not run a second time without closing and reopening
Visual Basic and Excell
name tab from cell value
eWEEK story about new programming problems with E-Commerce sites
Zoom value
Trying to start a second line ( ie use of enter key) in an output file
Legal advice on selling Excel spreadsheet program file
best way to get data from Access to Excel?
Time Out
Change Color of Cell
how can i run macro when i print worksheet.
Pivot Table update automatically?
maybe to bob phillips -next folder?
Comparing/Matching Values in multiple columns
10,000 element listbox possible? what about searching in it?
Postcode problem better explained
Create Word Document from Excel
255
Code not working when transfered into Userform
rename same entries
Looping thru spreadsheets in a workbook
Postcode splitting problem
Help with form
Minimize and maximize buttons userforms
chart settings
How to set workbook reference - basics
how to combinebubbles chart and distributed charts?
how do we hide via VBA?
How do I cut instead of copy?
VBA Form ComboBox question
how do i create an import library to link to a dll for use in exc.
E-mail address gets Arial-fonted when it's typed. How to stop this
ODBC database access
event to know after data has loaded
Compare Two Worksheets
How do I copy a conditional format?
VBA code silently crashing. Problem with Data Validation drop down lists.
Solve Using VBA Routine
[VBA EXCEL] Application.Close doesn't work with asp.net
PrintOut Method, Set ActivePrinter with a variable
help in syntax
Auto Increment Rows in between numbers
Help with OFFSET Problem Please
destination formating
Increment File Name by 1
How to programmatically determine which rows are outlined using Excel VBA code
sending only one sheet from a workbook
Help with linked files
I Need VBA Assistance looking for End of a file
VBA ColumnHeads Property for ComboBox
Save as Overwrite prompt
Update Query and Local Tables in Excel
How do I return cells that are "adjacent" to the return in a funct
ListBox Add Item based on criteria
Variable in event handles can't be used in module??
Forcing a function to calculate
how do i create a macro to clear checkboxes and display a message.
Same Row merge to Second worksheet
Select data
Calculating percentage throughout a column
Excel4Macro
Index page of power point from excel
Access macros in add-ins
Excel 2003 Custom Function
"The memory could not be "written"."
Macro to Cut-And-Paste Text
Problem with Code Below
PivotTableWizard SourceData question
Complicated One!
how to embed objects from other applications in 1 cell in excel sheet
My workbook doesn't have min., max., and close symbols in the cor.
Populating a Combo Box
Selective control of Option Buttons
Selecting WorkSheets
invisible text boxes becoming visible
Is there a test to see if an entire row or column is empty?
Sum not working on Array
Suppressing an excel message
How do I detect the first empty cell is column A
How do I detect the first empty cell is column A
VBA / VLOOKUP Problem - please help.
advanced excel programming
Generating Reports In Excel
Call Userfor and click button with macro
Automatically respond to message box appearing within a VBA macro
Command Button
Versioning Management
CopyFromRecordset Ignores Filters
Error 450
Function Updates from another sheet
Hyperlink and macro
convert date 1900
Move values
VB and combo box
Dr. Watson error
Problem with Button OnAction property...
Using specifieds in a range
Copying row using if function
What does XLS VB Method 'Range of object' _Global failed mean?
Issue with European Versions and VBA
VBA to alter selection in a Drop Down Box
Web form to Excel
Sending email with VBA - application.displayalerts question
vba code
updating data w/o activating another sheet...
Passing argument to excel
excel charts
Updating another sheet using an On Change event
double quotes when saving in CSV
Move a row to a different worksheet if it a column contains a valu
Message Box - More help please !!
file now available for editing
Prompt message and Automated saving!
Deletefolder
Copy paste
foglio con indice
Removing semicolons