Excel Programming [Archive] - Page 101

IFSUM macro to an other book
Problem with macro security
AutoFill a Range
Need One combo box row source to change based on the value of anot
Unable to delete a worksheet in a workbook.
Source data for chart
Unable to delete Active worksheet
listing directory files in a spreedsheet automatically
Macro for Range Names
Excel/VBA/Internet Explorer
Tabulating on worksheet's comboboxes
Copying rows/formulas
Advanced Excel Function
Macro to concatenate previously selected cells
Forms - how do you get them to disappear?
Conditional SUMMING
Printing multiple sheets to file
VBA Excel: Can't show, import or export userforms (error: &H800040
Get Info From Another Sheet
Input Box
Showing alias for PivotFields
Testing Print Macro
Define Range in VBA
definition of the range containing content
Position of CellCursor on Screen (absolute position)
Range - setting a value in a cell
How to multi-select worksheets?
Get Name of Selected Range
Macro confusion
Syntax error
How do I get dates into an inputbox ?
Help with a macro.
formatted link
VBA assign macro to button from a different file (simple you'd thi
UserForm
Selection of several records
Macro after Update of Links
Export with save as dialog
Finding last cell in column containing formulas using VBA
auto_open-macro
Msgbox text properties & Spacing
Check if cell values is in one range
Macro for hidden sheet access
sheets.select
Close msgbox ?
Opening Workbooks in a Folder One by One
Searching a text
How do I refer to a freeform name and number on a chart using VBA
Saving Images In Save As Xml Spreadsheet
Excel 2000 Import Error
Selecting an initial directory
Implementing digital signatures
Help, Input int different excel sheets
Need to delete rows relative to selection
Insert data automatically
How to remove a drawn chart object using VBA.
Select the next row
Microsoft Spreadsheet Control?
Losing "merge-cells" formatting when populating Worksheet from VBA
Why it can work in Function but ok in Sub
Code Does not Realise equal values
Re: VB script for converting each worksheet into individual pdf files.
Re: Visual Basic Question
CopyPaste
Opening and Closing workbooks in code
Can I have a text month and a "=today()" in same cell?
be validated or not validated in a cell
Workdays Counted - re-articulated question
alphabet to numbers?
Cell References in functions
Minutes to seconds
help me on rearrange cells based on its numerical values without repeating any number
Multiple Excel Sessions
How do I calculate total time (24hr) with timesheets?
disable screen refreshes
Problem with Find Method
AutoNew
Execute a ping command
Moving files via code
A VB problem with a if structure
gui
change list in combo box
Export Access Tables to Excel Workbook
Help With a Loop That Deletes Rows
Change order of Shapes with a click
Monthly Schedules
Toggling between a macro running a "Form" and Excel
Exporting a Varying Row to a CSV file.
Importing worksheets to a database
Using Indirect in Sumproduct formula
Select from multiple macros
Protect worksheet - do not allow select cells
Hidden characters
Re: error: Code Execution has been interrupted
Please help with a Loop...
Activeworkbook Error
find
Where to insert code?
pivot table: divide data columns with same data field
To protect a column
new worksheet name
Deleting Blank Rows
Help on repetetive row inserts and copying????
Compiling VBA as .exe to run within Excel
Use index to get range for dget to use
Refresh current work book?
Sheet View Position
macro to copy cells from one workbook to another
Extracting A Portion Of A String
Form TextBox Transfer to Spreadsheet
change from page1 to page2 of MultiPage object
Validation Question
In Excel I need to send a spreadsheet to email as attachment?
Building a zip code database
Populating a listbox with values from a sheet.
SendMail
Multiple data query using time reference
Printer Capture
count and arrange cells have numeric values
Visual Basic Multi-Stepped process
Function MatchCommentext()
Cell value as parameter for VBA access query
unknown type mismatch
Deleting Excel Macros
Deleting Excel Macros
Range until last value of a column
find range name for active cell
Equation Miscaculation
vlookup, match/index ????
Excel gets hungup when Copy Paste
Global (Module) Variable Problem
Automation Error
Upload file on a server
Creating a list of aproved/not members
COUNTIF in VBA
adding ranges
Custom menu
Printable Userform
Book about excel programming...
Excel Vba Training
Change the canned Routing message
Is It Possible in Excel ???
Detect Prcentage Format in a Cell
Use excel as database
Deleting duplicates i.e. "Anne Bell"
Excel 2003, Web Services and Remoting
How do i use webquery on a protected sheet?
Reference lost when newer version opens file
Input box range - output range
Why it can work in Function but ok in Sub
Recalculation Done event?
Workbook level recalculation
Stopping Code from Running whilst in Loop...
Converting IF Formul To VBA
ranges in combobox
remove leading zero in numeric field
set second cell value based on formula in first cell?
Installing .XLA on file open
Open Directory
Find Next problem
Identifying and counting duplicates
Dynamic sizing of a chart object
Copying Drop Down Lists
What UDF's are being used?
How to change chart properties given command from cell
XLL performance in NT and XP
how do i sum dollars & cents in different columns
User Forms
MyItem.To query
Pasting help
Finding a number in a list specificed on a worksheet
Skeet scores
Update Pivots Dynamically
problem with putting borders around cells with macro
Question On Excel Formulas
Controlling the Excel application with VBA
Problem with macro recorder
change font color of cell based on critera
Printing with a message
Combo Box fill
ADO Recordest.Filter "NOT LIKE"
Dispaly message
Command Button to copy conetents of one cell to another
SQL from VB
Sum numbers in userform
Copy from Word on clipboard
Gif Image
Excel "Add Ins"
Going to the first blank cell in the selected column
Problems with cascading combo box, appears to only be 1 column's numeric values (zipcodes)
CheckBox assistance?
increase limits for conditional formating for different dates
excel formula
Can the column index in a cell address be made variable?
Problems with a finding macro and copying a range of cells
return a cell address?
Unlock protected worksheet
REPOST: Please help with Output - Going across instead of down
Creating A sumation formula
Attempting to reduce userforms
Web Query Errors
use com technology to build excel addin for free distribution ?
Excel Popup Menu Control
changing cell value by double clicking it with out vba/macros
Accessing data from combo box from VBA
Can Access stored procedures be executed from within Excel
Printing multiple sheets with different data
Change top line data and remove lower lies
Conditional Formatting not working
Worksheet Change event
Change top line data and remove lower lies
Tab Names
Weighted Standard Deviation
Beginner question about importing data from Access into Excel
XL File on DeskTop cannot be openned
Change Routing Message in Outlook when Excel File is Routed
TIME reference - Excel 2003
field alias when running SQL on sheet ranges
RE: Turn off Printer Messages
Help Files
Userform to enter values and shown in same userform in list
Code to unfilter one field only
setting delimiters for pasted data
Format a rangeafter usining a userform
Array of formulas (regional difference)
How to add up time
Macro to change information and then delete it
run macro step by step. excel 2003
Automatic Save As
Update Style in non-active workbook
ComboBox Population
Quick, general userform question
Printing a cell range with a macro
Challenging Macro to perform evaluate function on each cell
Creating Multiple GIFs from Multiple Range selections -- I need a volunteer to test my code to see why it fails
Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails
BeforePrint help
Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails
how do I add an option button in Excel
concatenate problem
SmallScroll error in macro
conditional Formatting
Scrolling worksheet
Code to access a hidden worksheet
VBA access to Active X Scroll Bar
Counting occurences in sorted cells
Inconsistent results with function call....?
Copy data from one workbook to another
Loop with dynamic range
Setting size of comment under macro control?
Chart looks good on Excel, appalling on OpenOffice.org's spreadsheet
Pass a form Listbox as an object
Changing File Names and Linking Cells between workbooks
error in input
Import automation, selected mdb fields from server to Excel
Macro confirm to run
Find Empty Cell in Row
check input in cells
search all sheets in book to find value and activate sheet with va
Last Filled Column
Conditionally hide rows
macro question
how to make a form self disappear
Making excel functional on computers without excel???
Decimal type in Excel 97
selection range
Selection range to last non empty cell
Hiding command bar
Connect to Oracle using Microsoft ODBC for Oracle
Deleting last letter if a cell
How do I paste information to hidden worksheets?
Issue Copying Data from one workbook to another
Worksheet change event I think?
reading comments value into a string variable
date format
Loop with activecell.offset
Macros validated on Save
Macros from Excel 4.0 to Excel 2000
Move files
How to append data in Excel
Worksheet_Change macro locks up Excel
Background
Macro Help Please
Minimum value ignoring zero
Print Multiple Ranges
Find Excel Version
Getting Access Query Data to Excel
Re: Preventing macro from .xlt from executing in a .xls
delete rows w/o hardcoding numbers
Auto Macros
Printer Selection
opening & copying to a workbook
cell message with option buttons
Removing Data
Masking an input box?
Help Me I'm Stupid!!!
question on macro
Help Me I'm Stupid!!!
Compile error: Loop WIthout Do
Copying multiple items (searching)
filters
i want to lock a tab in excel, and unlock in another sheet
How to copy cells value and not formula
pasting a formula without so much automation
Save excel pages as seperate files
Change Font Color in cell Based on another cell value
Help with UserForm Code
Speed up the search?
how to Match and arrange data
Number of Worksheets
Macro to calculate total quantities
User Defined Function Properties
Toggling between macro and excel
VB Controls
Search text of external files and import
rename label captions
RE: Macro to calculate total quantities
RE: Toggling between macro and excel
moving an Access form to Excel
calculating time
Currency Format for label in UserForm
VB Functions in Excel
GoTo Reference
RE: Search text of external files and import
RE: moving an Access form to Excel
Loop with variable
name of month in national language
How Can I conver date i.e 18/11/2005 to 18112005.?
Worksheet Events Not Working
extra controls do not appear
Anchor button to cell?
excel and database question
from VBA open text file in default text editor application
Searching in a user form / List box
Script to find the word END
want VB6 to edits Excel in background and not become visible when I open another excel file
vb code stopped running
Ensure Workbooks in the same Excel Application
Variable VBA Worksheet Name
strange behaviour - no feedback!
Placing action on a button!!
Graphic in Excel Workbook
howto print a system font (wst_engl) in microsoft excel?
Macro - Pivot Table - Select Items
Solver in macros
How do I delete "Type A Question for Help"
Varying Data Sort Macro.
Excel to browser file
Kopieren sheet
Get a Range from all wk in a folder...
Convert VBA code to VB.NET
How to tell what textbox got the focus
color with duplicate data in 3 worksheet
Problem in InsertLines and CreateEventProc
Compile Error - Wrong number of arguements or invalid property ass
Downloading multiple files
Prevent Excel crash when running
Product Key
How do I set formula?
Using macros to "find" data and use that as a reference
Switch cells on input
Error 1004 with PivotItems.Visible
How to call a sub defined in macro when double click a cell?
return 2 or more variables from a function
Automate Pivot Table Report
range variables for chart x axis values
Show picture
using variables in the range of source data
Export and save
find text
setting visible (ie displayed) part of the worksheet
how i get the value of active cell into other cell automatically?????
Positioning a chart on the worksheet
Copy Dates
Unable to copy another spreadsheet to the current spreadsheet with
Handling of multiple entries in key cell
ScreenUpdating stays TRUE no matter what?
Solver with values not stored explicitly in cells
Use merge fields as in Word. Print sheets with 1 change
Path of files
Comparing then Replacing
Chging Filters on a Rpt
File size is huge
Excel macro to name ranges always start in A and end in U
Printing a selection of rows
Mode Between Two Serial Dates/Times
change row color according to an if statement
Registering Function Macros
Help Buttons Won't Push???
selection.delete skips a column
change button text color
VBA excel - problem with having clause in sql with adodb.connection/recordset
VBA & Coding a dynamic range
Repeat patient name for radiology charges
merge text from a column into on cell seperated by comma's
Match and sort
How do I get focus back on an Excel file?
How do I programmatically get access to a picture or graphic?
for each sheet
Help with Macros
Text boxes in Spreadsheet
trasfering value from sheet to other sheet
find all combinations of cells that add up to certain number
Sender?
Crop Text to Col Width
How do you keep source values on a Pivot Table w/o formulas?
2 questions, 1 easy about "" in VB, 1 very difficult
output to txt by COL.
Sharing personal macros and buttons that accompany the macro
Search and move??
Excel 2002 Startup Macro
Workbook closed by VBA not Closing Properly
Lookups
Vlookup and forecast
How to get a macro to run that uses a protected sheet
Use info from excel to update my database
Excel 2000 Text Box Issue
I install de Sovler Add-In but it never appears in my tools menu
"Find All" Function in a UserForm?
Get data from ext. file when i choose an option from combobox
I need to remove passwords from a list of files.
Fill Color based on Comment Text
Stopping the "Next" command when a blank cell is reached.
Find Folders
run macro after yes to data validation warning message
Print content of cells to a text file
File Launching and References Problem
Change excel width after publishing
2 excel windows opened
Help with CountIF formula
Workbook_Initialize
Get the total sum from various files
Rowsource Question
Macro Select only cells with data in them
Finding a comment text
Send Mail Merge Auto-Emails based on date
Load List from External Excel file
Close Button Error
Open workbooks - filenames change daily
Grouping data range
run a macro before a workbook closes
Custom date format shows "051117.Thu" for today. Way to have "051117.Th", instead?
Email automatically every time you print document
Deselecting a check box if cell value changes
Disable Right Clicking of Excel logo on Standard menu Bar
how do I get the reference of the cell where a picture
See conditional formatting Color value in vba
averging prices real problem
Copy rows
Array Formula Using WorksheetFunction
Using excel for serverlist
challenging "share stock" average prices
Little problem with the REPLACE method.
Getting the Date Format Being Used By The Operating System And Exc
Shareware for Writing HTML Help files
Closing Files and Reopening them in VBA
Run macro
Shipping price, maybe challenge of the day
Protect worksheet before sending
Excel Cell Criteria Effect
Querying host of excel files stored monthwise through VB 6.0 interface and programming
trend analysis - historical probabilities
Deleting a menu in BeforeClose but user Cancels the Save
Arrays
Using Macro to save data in new excel file
Cut rows if contains "Done" from sheet1, and paste onto next available row in sheet2 in the same workbook.
Clearing the clipboard
Push value to a cell attribute?
mid$ in VBA
Re: Need excel macro
Need excel macro
Need macro bring internet explorer window to front
Forcing users to complete a form
Programatically copy cells with dates
All Worksheets
Remove blanks from list via VBA
resetting options buttons
Visual Basic code inversion
Strange Shapes.AddShape error
dynamic range selection
Vlookup Question
Deleting PageBreaks
RE: Deleting PageBreaks
sorting data
RE: Vlookup Question
Sort Data in a combobox list
Documenter in Excel?
How do I make Command button ( Save & Exit) for Excel
Need Help with SendMail
HOW TO: One name range to work for multiple sheets
RE: HOW TO: One name range to work for multiple sheets
Sime function to find files
If Statement Help
Cannot find file when running macro
Converting A Quarterly Dataset to Weekly Dataset
can't print what i want in excel shared workbooks
VBA password request upon exit
RE: Vlookup Question
Formatting a row of Cells
RE: Sort Data in a combobox list
Re .FIND()
Tooltips won't show up in custom popup menu
Date format in userform
PERSONAL.BAK, PERSONAL2.BAK
how do I set up combo boxes in ecxel
This is not working because I didn't write it correctly
can Excel connect and download data from a Stockmarket Website?
global variables
Selecting part of a column
Menu Help - cell reference
Creating a "Defualt" macro that is available in any and/all workbo
Copying data between Workbooks
Alter Account numbers
vlookup and calculations
Search/Compare VBA Help
PivotFields problem
Move to first blank sheet
DDE - calling Matlab Functions
Moving Beyond VBA - The Development Next Step
RE: Deleting PageBreaks
relative path in shell command (excel)
Finding Data in one sheet & transfer to another
Presto - Excel Vanishes from the taskbar, but is still open. Why did it disappear?
Worksheet_Change
Documenter in Excel?
Formatting Question
Macro Help - Loops
Excel should let me clear cell contents without clearing formulas
Need macro to change date from yyyymmdd format to mm/dd/yyyy forma
Find empty rows or columns
FLOATING CELLS
Working with options from within Tools Options clears the Clipboar
date time picker control
Import Text File
hiding a control depending on a cell's value
Error if 'name' already exists
Worksheet Change event
Vlookup and forecast funtions
Referencing a range within a workbook
Menus Delete vs Reset
activate a workbook without using its filename?
RichTexBox1_KeyDown Event Not Working
consolidate workbooks between two other workbooks
How to delete tables with a certain string in the name?
Custom Comment Combo Boxes
VBA code for chart
repeat macro for all rows
How to move to next row?
Call a function when a cell changes
How to I return the position of a selected cell in a range?
Question on automating Dialogboxes in VBA
Backwards execution of sendkeys problem
Override dialogs on SaveAs (tab-delimited)
Cell Address
drop down boxes in Excel
insert rows
John Walkenbach - Ensuring that Data Validation is Not Deleted
Pages Count; Plan B
CommandBar problem - Question
Double Quotations
VBA to hide columns
Disallow paste in range of cell containing validation
Left 25% of Screen Disappears?
Change color on active cell
Mouse-Over State on Graphic Button
Connecting Modules in VBA
Create a button to Save As the workbook
Blinking Text
create a button that previews sheets
create button that can hide/unhide sheets and hyperlink...
variable question
Name an area that changes
Formatting text in specific cell
Put cell contents into header
To duplicate a row
Input box Copy Paste Range
Excel makes it possible:celverwijzing to a remark on another page
Cells within Cells formula
how to use find() to search in the selected columns?
userform and printpreview
unput dat question
on workbook open in Excel 95
how to get an excel sheet in a userform
Declaring 2 dimensional arrays
problem with VBA to draw vertical lines
How to Calculate a Projected Finish Date based on Work Week and Holidays
Finding completely blank rows
Creating sequential variables on the fly
A problem with Set (Range)
Find list of sheets of an unopened XLS file
Extremely complex problem: showing a value as an 'axis' on a circle
IF statement
Code or Formula?
VLookup Problem
Search files, confirm presence
Averaging a Value Between Two Serial Dates
Anyone ever try shared workbooks?
Pivot table recalcuate disable
Excel VBA - conditional formatting
permission denied
End of data loop
Help with complex VLOOKUP
Dynamic range
Delete every other line
Delete every other line
UserForm ComboBox RowSource Question
How do you change the sign (e.g. +3 to -3 OR -3 to +3)
Open a Workbook Q
Run .vbs from a Excel macro?
macros for printing
input box format
range variable won't assign (chartobject.topleftcell property)
Parts List comparison report
Search & extract from multiple workbooks
Loop through records
RE: Averaging Random Selections?
Notify when file is open?
Won't accept password to unprotect
Create a new XLS from a standard XLS
Re: Import text file problem
Before Save w Addin
Toll bar disappears...
uploading excel data to sql
upload data from an excel worksheet to SQL W/ a command Button
Recalc Time
range method failed
formatted numbers to CSV problem
Convert an Excel date to a date of my format in VBA
Querying websites -beginner question
ATPVBAEN.XLA!Histogram - macro not found
VLOOKUP() Bug in VBA?
Populating cells
VLOOKUP using a range variable
Pivot Problems
Change worksheet formulas from button on chart sheet
EnableEvents BeforeClose
this is a test
syntax for using Excel worksheet function
if statement
Statusbar not updating when autosaving
RE: display an info ballon or message box while a macro is running
Software Requirements to run a .NET Excel automation application
RE: Loop: Copy and paste range that changes with every iteration
Problem when attempting to save Workbook with VBA project protected
Solver - Minimize an absolute value
Outputting filenames in excel from a particular
Cell formual result change - Message
Using Functions in VBA code
How can functions be called randomly?
Charts
Populating 'Comments' with cell value
SUMPRODUCT excel ignore div/0
#REF! in while loop
Copy Pivot Table Data and Paste into New File
How do I not print or count pages? Excel97
Re: UDF only works when focus is on a specific sheet - Help!!
Save Excel Spreadsheet to PDF
Re: UDF only works when focus is on a specific sheet - Help!!
Re: UDF only works when focus is on a specific sheet - Help!!
Excel Macros
Add and Delete rows
Re: part of string
Re: setting source data
Loop Column letter A to Z ??
Retrieving the formula contents of a chart title
CHECK END OF WORKSHEET DATA
How do I turn around 'Circulation Reference' msgbox?
da@pd
How do I sendkeys to Interner Explorer from Excel?
RowSource in ListBox
exporting to excel
Re: commandbar management
Saving A Read Only File?
Combine two linked fields in one cell
ADO: Empty field
How do I remove repeating rows automatically in excel?
Error of old type library or unrecognized HRESULT
How do I return a number for a formatted cell value?
Fading Form
need help righting script to sort rows alphabetically then seperate them to line up
copying and pasting range problem
How can I find vaues of cells using 2 search criteria?
Create a Button that will print sheets
Need help adjusting selection ranges
Stuck addin loaded
Re: Creating QueryTable from VB6
Matrix Operations in VBA
Removing textbox padding, how to please, Excel 2000/2003
UDF needed
Object required?
help me on condition issues
Detecting if a value "fits" in a cell.
Re: Removing Conditional Formatting
Re: Pivot Table Question.
Re: Inspecting cells in a row in a named range
RE: Unwanted "quotes"
trim left of a found word in a text variable
Is there a Limit to the Amount of Data you can Link to?
Referencing 0 generated from IF(isna(Vlookup) formula
Network Days Count accuracy
ActiveX alert message
replace the letters (for collumn) & numbers(row no.) of cell reference only
executing an autofilter in VB
Copying Cell Value
Copy range to range
logon name in footer
selectin all the values in a column including null values
Faster way to do this?
Validation Formula
Check Integrity Of Files
need a way to set value based on fill color of a cell
Move/Shift cells left or right in a row
Need to add blank rows based on 2 fields
Launching macro externally
Selectig rows inside a group
UpdateFillOnly
Using Two Monitors
Help: How do I fill a selected row with data?
Hidden cell problem
Extracting/copying files from a folder using VBA
ActiveWorkbook.SaveAs problem
Speed-up Script
vba-password prompt on close
VBA - Excel Security
creating hyperlink from cell data
Querying a SQL Server Database
Add in for removing duplicate rows?
Filtered info, into next sheet
How tochange color of MINIF cell ?
MacroOptions Method
Changing Cell Values
how to open an Autocad file in Excel using VBA
Fill Cell by filtering item from large list
Create new workbook when macro is run
Command for present sheet
Select Sheet - Variable
a little complicated programming, help would be appreciated!
Delete or Add Data into as per Codeno.
Replace Column Letter only
workbooks.open problem
Copy whole of chart to existing chart
Hiding/Unhiding multiple sheets in VBA?
Replace Column Letter only
Vlookup errors
If SheetExisit then
Problem with the FIND method looking for dates.
How do i make excel open a new workbook and run a query from sql
Pulldown list with macroes...
Macro help
listobjects and querytables
Command Bar
Protection sheet
Clearing cell contents on CellUpdate
Internetconnection
formatting background color of a cell with custom colors
Help!! copy worksheet and assign a name to new worksheet.
Inserting Hyperlinks to each image in a directory
Copying from closed files and IF statement
Date Format Question
Application.GetOpenFileName() question
visible counter
Multiple Identical UserForms
Simultaneous user question
toolbar won't go away
cell address
Looking for intersection
date warning
Random Number Generator
Help with copying selected row to new sheet
MsgBox pops up twice. Any idea why?
Referring to multiple elements of an array (VB)
UserForms - making responses mandatory
How can I make a cell reuired
Picture show in image1
setting a print area
personal macro workbook must stay open for recording
open *.csv file as *.xls makro
Symbols for playing cards
userform hyperlink question
How count these combinations ?
Random Number in VBA
Not allow user to select a locked cell
Checkbox locked and will not unlock
best way of distributing toolbars
Copying aenother workbook's sheets
autofill data from excell dbase into html form offline?
116 minutes convert into 1.56 min
Calculate, Copy, Paste
What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
Set Function to False -Why??
hiding picture while printing
menu display
Convert range values to correct "hh:mm:ss" format.
Disable Userform button
Assign macro broken after reference removed
help me on if function please
How i can create hyperlink with email
How bring over result to sheet 2
VBA Clear clipboard
userform addition
I need help with a labour costing system
VBA, matching values and time synchronizing
Templates
Copy Paste not working from Add-in - Error 1004
VBA code to set a reference
Set column widths to match specified sheet
Threads ... possible in VBA
help excel
Subtotal
help
VBA to find next Monday
lookup functions
code for 24hr clock?
Time stamping each entry
Prevent Pivot Table Resizing
date time stamp excel activity log entry?
create a micro for Auto Column Width and put on tool bar
Where can I find a full list of "mso" constants?
Adding a Bookmark
Automate a list?
Counting Date Changes
for each question
Advanced Filter to Dynamic Range
Add-in UDF to Catagory
copying data from one wb to another
Dexcription of Variables
Any template to track multiple projects with changing deadlines?
Controlsource Puzzlement
Macro List - personal.xls
Chart Datalabels.Position
Novice Macro Help
Query Table and SQL Server
string within formula
c++ equivalent for Selection.Copy
text to number
So many option buttons
How does Userform get initialized by this?
Checkboxes on forms
How to Calculate Combinations ?
How to connect two columns in Excel VBA
Add ROWS
need help determining a row number
chart links
This is hard... well for me...Need help with a macro to summarize
Recalculation taking a massive 11 seconds
Delete Non-Randomly Chosen Rows
excel arrays
Find Last Line Code: Let's Make This Better
Check box making a command button work
how to monitor the selected value of a Data Validation list
Combobox issue!
Macro inserting quotes "" in a cell
Need help creating a simple macro
option buttons in a form
If statement
sumif or sumproduct range
Can't get screen resolution
VLookup returns #N/A
How do I reference VLookup returned Cells that have "#N/A
how do i summarize data in multiple workbooks?
VBA array problem
Huge Worksheet
.NET Framework 2.0
how to effect multiple sheets at one time.
Trying to Avoid Selecting Sheets
Lock out manual input to cells?
security warning richtextbox
DDE link mystery
Creating body in email
Gradient form background
Microsoft Visual Basic
Open Sheet, Run Macro, Extract data
Can't concatenate
Double Dashes Causing problems in downloaded records
Trapping Erros on ChangeLinks
Self running spreadsheet?
newsgroup issues
counting and sumproduct formulas
Read-only protection on Excel Worksheet
Pecentage with 7 sale types
controlsource cells in listobox
Using multiple XLTs
Comparing worksheets
summarize table
VBA Color Date if Past due
Controlling Access from Excel
Add cells with a specific format?
Multiple If Statement problem
Vertical bands on Excel graph
Autolist Members Does Not Always Work
Workbook_Activate question
How to use "CONCATENATE" function in VBA
Splitting data into columns
Incrementing columns
Trusted Publisher on wink2k and winxp
Disabling Key stroke Short-cuts
Excel Email: Address and portion of body in cell
Center Align
Set Focus to Worksheet and then a specific ROW
Excel newsgroup search tool
Toolbars
Compare and align columns of data
Lock Header Rows from Editing
help with auto numbering an invoice
.Formula = help needed
Disabling effects of cells (temporarily)
best way to get reference to all used cells
text stye, value depending
How to add a fixed point to a dynamic chart
Column into Row in EXCEl
Re: There must be a way!!
Protecting cells by coluor
Compile Error: Can't find project or library (missing Add-in)
macro only run if cell is not empty
how to find if diagram is selected?
Can we use the mouse wheel in the VBA module editors?
Copy sheet and prompt for sheet name
Excel 2003 crashes if VBA is locked for viewing
Add Macro to Excel by Automation and check if it has run successfu
Using array data for combo box
Icon Macro
Upgrading 2K to 2003
Trim function in a macro
A disturbing behaviour of DIM (for variable declaration)
Importing from CSV over multiple sheets
Bind Columns
what would be the best way to do this?
Excel Import problem
Macro behaves differently then when recorded and stuffs dates (or date formats)
type of selection if selection is chart
Run macro multiple times
TopLeftCell.Address for buttons from forms toolbar
Range: changing interior color
Change Print Command or add a new print command
Opening Excel Document in ASP.NET and having issues...please help
Excel Add-in for SQL Server Analysis Services: interrupts my Macro.
Evaluate a Variable Name from a String
Always Open to the same worksheet
Listbox data display problem
worksheet select using variable
Trying to save a .XLA file that's Read Only
using Vlookup in code
how to stop the 0 from dropping when saving exel to a .csv file
formatting combo box on custom menu
Array
Numbers and Letters
shortcut key to see a macro running "step by step"
read protpetry of user from a distribution list..
Help: How do I fill a column with values if it is blank?
import from distribution list
Prevent input of formulas
Hyperlink to a folder
Disable Edit > Fill
import property from outlokk distribution list
Saving a single Worksheet w/o redundant prompts
Clearing public arrays
Chart Zooming
BeforeSave question
cell values as label captions
In History sheet (tracking changes), date (in column B) is 38,666 (instead of 11/10/2005)
Cell that shows "sum" of filled cells?
How can i display the source of an MS Query list?
Unhide sheets
Calculate Mon-Friday (8AM-5PM)
accessing data in a cell
VB error
Start and Open in Page Break PreView
Bug in Excel VBA compiler?
Problem with userform controls created on the fly
Standalone attribute XML export
AutoFilter Summary Macro
compare array of values against value?
hide/unhide macro
Get time it takes to run program!!
System variable for "changes made"
Font Filter & loop Macro not quite working
Open sheet "LBUD*", how
How do I select last cell in column plus 1?
UDF Add-in New category in "Paste Function Dialog Box
Copy Worksheet from closed book.
Programmatically Set the Workgroup Templates location
Code before Print but not Print Preview
How do you step thru a macro?
how do i restore a file saved as an addin (.xla)
Excel 2000 question
How to define and select a range
error with macro to name new worksheet with cell from old worksheet
VBA format on conditions
VSTO: Sheets collection a 1-based array(?!?!?)
Creating Nodes
Square Root in VBA
Automatic Manual Calc When Opening!!
Linked Workbooks - How to Allow for Growth in source books?
Stop Macro
Vanishing ActiveX Controls
VBA reference
How to EXTEND listbox entries
File Name Causes Runtime Error 1004
Insert two rows in one line of code?
File copy