Excel Programming [Archive] - Page 83

Add-in name capitalization?
Disabling Auto_Open in distributed worksheet
assign dataset to matching dataset
Macro to concatenate multiple rows in a column, without selecting each group manually
Lookup Value in Range/Array and Return Column Header Value
msgBox
Count & List Combinations
Follow hyperlink but don't update links....is it possible ?
Lotus Notes Task
Formatting multi-line text
Find and Paste Program
Referring to cells
Variably Hiding Cells
macro which works in excel 2000 does not work in excel 2002
making charts with vb 6.3
Runtime error 91
Extracting specific data from one column to another column
comboBox properties
After adding a new sheet, wanting to compare cell values
Advance filter question
Use String from another module
Clean Exit from InputBox
looping when checking isdate
How to create chart using VB 6.0
A fast way to fill cells in Excel
variables
Last Selected Cell
Popup box to enter VLOOKUP value
Re:Final days - London Excel Conference Registration giveaway
How to path to user's desktop
Place a User Form on Start Up
IsDate
Internet Navigation
formatting input boxes
Incorporating VB6 RichText control into Excel VBA
Close user form when button is pressed
Open 'n' Hide
Re: Change colour of cell depending on content
Re: Change colour of cell depending on content
Read from text field
Checking data in each cells of an array
Change colour of cell depending on content
show info when workbook opens
Force macro on save
How to check for Internet connection
How to open .xlt containing PivotTable?
need help using send keys
Link to external file
export file to excel
define unique Advancefiltered range
Hi All,
Selfcert and Network
Index number for CommandBar right-click on sheet tab?
Using Controls on a Worksheet
Split a string
creation of name range without selection of cells
Splitting a workbook
Excel, reference a cell for parameter in SQL to import data
Finding a value and going to that cell?
Help! Security when using a VBA macro to access an Excel File
Copy worksheet, rename, merged cell problem??
How do I get a Function to return Null?
Make Excel allow numeric fields as text
need a formula to work out how much ......
data import question
Change from Column Selection to Cell Selection
Can I Select an "Import" Template Based on a Doc's Filename?
Simple worksheet selection question???
Custom View Macros
On Change Event
Border question
Disapearing formulas
Additional Controls disabled
Re: Shapes
roster - printing out who is on
Newbie Run Time Error
on error
VBA created in excel2003 doesn't work in 2000
Multiple Cells
Word wrap issue
Using the ActiveCell function on 2 different worksheets
Problems with Transposing. HELP!
Max length for a menu command name
Paste link With Worksheet that has password
Combining R1C1 and absolute reference in SUMPRODUCT in VBA
quit on error
Multi Listboxes with data dependent upon user choices
good gotos and bad gotos
Empty cell instead of 0
Event: Workbook_Change or Worksheet_Change
What's the secret on scroll bars in textbox
Setting an array range of cells???
Tough - show a hierarchy
Merge Cells in VBA
Page Breaks Macro
Trouble opening PC version of Workbook on MAC
SELECTIVE DELETE
Change Cell Background color Automatically
Create a workbook with only 1 sheet
Macro concatenate formula
Baseball Combinations
VBA - Multiple Array-Enter Command
Sending email with selection of data from spreadsheet
How to create a button to switch to a custom view
How do I identify a range based on cell value?
Re: matching values
How to create a view option (or hide/unhide preselected cells) (Repost from Misc)
How to read filesystem shortcut attributes
How to cause a #num! error
Prorated Average
Ã†ndre dato (tal) 20060615 til dato
invoice template?
Jump to "Defined name" range!
Commas appear when typing
Specify which sheet to paste to
RE: Specify which sheet to paste to
FORMULA FOR EXPERT, PLS MAKE THIS WORK
Mulitple Entries in InputBox
REPOST: VBA Acessing Member Variable in C# Com AddIn
RE: FORMULA FOR EXPERT, PLS MAKE THIS WORK
RE: Specify which sheet to paste to
sort multiple columns of data but not change the data location... Possible?
errors in emailing Excel
Help with VBA export of cells to PowerPoint
ChDir statement
Hourly Macro Help
Help!
Margins in form items
How do I get data validation message to appear using a macro?
Retrieving Data from Multiple WorkBooks
Query PVCS
Run-time error 1004: Too many different cell formats
Transform text in date format
Buttons
Query Refresh without filename prompt
Subroutine calls between workbooks and object references
Connecting button to macro
Pause Code Execution
Canceling a read file function
how to set the value of a cell from another cell
Excel macros for interprocess communication
automating a process in pivot tables
Excel Worksheet Delete "Data may exist"
Adding two cells together
How do I colour ill a cell in excel with a formula?
Returning a value from a form
VBA/SQL Question
More Selecting and Deleting
User form/Modul
Managing Filtered Items
Userlogin for excel speadsheet
VBA Acessing Member Variable in C# Com AddIn
Color Problems
List of macro shortcut keys
Using sheet name of workbooks
3rd stupid question from newbie - autoloading userform
cell not changing
pasting info from workbook to sheet in another workbook
Format Page set up for all tabs in workbook
Macro for Trimming
Cell Deleting and Shifting
VLOOKUP Formula from one cell to 2nd cell
Naming worksheets in loop
hide and unhide rows
Display button
Sheets reference change variable
Checking if Validation exists in the cell
pasting form 1 sheet to another
Checking format on input
Sum in vba only works for multiple values not for single values??
Loops and Events
Merged cells
code for print dialogue
how to see only youre userforms??
code to unprotect sheet with password
Import a CodeModule then call its method in Workbook_Open()
Main first
VNC and Excel
Find + remove blanks if cell contains only numbers
Pre-Open VBA
SaveAs
how to bypass password??
Get data from Excel-cell and check format
Rolling credits list
Clear contents
Insert blank cell and labelling if difference in comparsion
Search for blanks
Search and replace blanks
Charts
Delete Pivot table
executing database
How to link a form to a sheet in excel
Conditional deletion of rows
Replace Function using Wildcards
Opening a file via VBA
filling userform listbox
Excel Menu Bar
List of Different Cells
Re: excel question
Re: matching values
?????.Auto_Open ???
Re: Clean up and Fix Two Macros
Re: matching values
Extracting data from 1 file to multiple files
excel merging?
Save Status Bar Disappers after running macro
Changing cell colour depending on content??
Text Box in Chart
how do i use vba to zip folders?
Application.FileDialog(msoFileDialogOpen) and error 75
Print even & odd pages with different margins
Dynamic Name Labels
Worksheet Navigation Help
Excel VBA Macro stops running when another program is activated
Disable Link Alert
Leftover Workbooks Named "Object" When Opening Excel In IE
SQL? Index? Excel?
use mouseclick to dynamically change chart series? Chart_beforeDoubleClick?
DateTime picker control
Please Help :)
Another stupid newbie question.
Formula appears as =RC[-3]+RC[-1] Whats this?
Document security question
Basic Compile Problem
20 Procedures one Command button
If cell contains text, leave as is
Find macro with wildcard as part of code
If Statement
run a macro when cell value changes
Controlling switching to other sheets
Execute macro many times??
Working with Workbook array
How to find the Dimensions of a Variant Range
Copy Entire Row
Hidden Text Boxes In Spreadsheets
Display of Comments on Excel file saved as .mht
spinbutton In Form
Strange Request
Add 1 to a number each time you print
Having a floating row or hiding unused rows?
Hide Printing Dialog
SUMIF with Mulitple Conditions
xlDown stops at next empty cell, not at last row of data
Find/REplace from table questions...
delete images in an excel sheet
Rename with more than 31 chars an Excel sheet
Display Value in 'Currency Format'
Input Box and Message box Help
Find and Replace within workbook - from Visual basic
Running macro on open of workbook?
need to seperate one cell's formula by delimiters
Change Text Color When?
Help: Excel Macro window run button disabled for all code in 1 module?
Excel, OLEDB and uppercase problem.
Printing all from drop down box
Using Checkboxes to enable/disable vb
Help function
SUMPRODUCT USING <>
slow processing with .find
Formatting Text by when last modified
Searching for a Partial Filename
Copy contents of textBox to Cell in Excel
Duplicated form at runtime
search function without error if not found
for..next statement problem
substitute chatracters within a cell
formula or VBA - would like to autofill cells based on start date and # of months
Saving an Excel file & overwrite (C++)
Newbie-question: recorded macro does not work - why?
SUMIF
Exclude first charachter
Auto delete rows within a specified range
Placing Data in a Range
Save Single Worksheet
Corporate Error Reporting with DW.exe
How to disable all Excel Events and then re-activate them?
macros in network restriction
Looping
MSFlexGrid to display Excel data on VBA form
Hide and unhide rows for multiple areas
Special Cell Selection
create macro - delete all rows with zero in column L
Creating a graph with existing data...clear data after save
Cell address
no builtin chart options for me..(Excel 2000)!!
macros using find/replace
is there a way to connect excel to a pop3 server?
Difficult macros
hide and unhide rows
Import a external data
Pivot Chart Problem
advanced filter and format
Userform Combo box list
pop up box, searching worksheets and running macros help please
Creating cub file using VBA
find values and identifying cell-adress
Passing values
Data program
Extracting Data - Open vs Closed
import and export from SQL SERVER to Excel
student's t table
Importing libraries explicitly in macro code
Dynamically change accumulation links when adding worksheets
Destinct records macro
VBA - If / And Statements
Excel filter does not working anymore
removing commas in csv
autosave on changing worksheet
Copy part of worksheet in VBA
xlb as Addin ?
Filtered Array for Listbox
Save one sheet as .csv with macro
Goto a named range using the contents of the active cell
Accessing a 'column' in a VB array
Using SocketWrench
Undeclared variables allowed in a Module defined with Option Expli
Macro and automatic update
List box deselect
Dynamic Headers via VBA - Probably Simple Answer?????
macro to search for & select ranges to sum
Data Validation
Password on VBA causing problem
Detecting Double Entries
embed?
double freeze pane
Extract Date (04/05/06) into Text (040506)
I would like to get a time stamp that does NOT update upon recalc
Floating Command button
how to format a label to 2 decimal places
How to open a spreadsheet and make changes to it from code?
Paste Special
COM add-in doesn't work
Pull mutil values from one LOOKUP formula
REPOST: Calling Excel Automation Add-In in VBA
Now I want the opposite
Using COUNT value as variable
How to perisist object in Excel
Background color change
Using Excel to generate an Outlook Calendar Event
Protect formula without protecting the worksheet
multiplication
Date and Time
macro to show list of worksheets in a workbook
Hide row if date "A" is later than date "B"
Deleting blank cells in a column
Initiate Macro On Save
Convert numbers to text
Calling Excel Automation Add-In in VBA
REPOST: Automating series generation for scatter plots
Multiple Criteria
Retreiving list of table & field names from Access into Excel using VBA
Multiple Prompts
Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist
list all the find values
keep track of previous excel range value after dragdropped...
Calling Excel Automation Add-In in VBA
Adding sheets and copying data problem
Locking Cells from list
cell with highest value g5 would be upto 80=1,81:160=1.5,
vba encryption
Referencing cell in Named Range in Function VS Formula
unhide rows when cell is clicked
Suppress workbook display
Specific Cell Selecting
Using Macro to copy latest data from one Workbook to another
Conditional Formula
Dynamic Headers via VBA - Probably Simple Answer?????
Checkboxes
Change Application Security Settings
Inserting A row & page break
In VBA, possible ot subtotal without selecting?
Conditional Formula
User defined functions without using VBA.
AutoFill a formula down a column
Copy Unknown Number of Sheets
Auto "Save As" Cell value when data entered in cell
Save WB from reference found in cell D1 to specific folder
Selecting a Pattern of Rows
Is there a way to setup Worksheet Tab Descriptions based on cell i
Passing arguments to userforms
Iteration Calculations between sheets
When will bug 919127 be fixed???????
lookup
Multiple Links from drop down box
E-Mail as Hyperlink
PageBreak in VBA???
VBA Loop Formatting Text Question
Macro Question
cell.replace strange behaviour
Subscript out of range error - save copy error
Subscript out of range error - save copy error
Workbook_BeforeClose
calling a userform
Get FileSummaryInfo for files saved on Intranet
select range between two empty cells?
Why do add-ins reference specific path
importing text from bookmark in Word to excel
Excel Automatino/COM Add-In Question
Resizing Pivot table column
Deleting automatic page breaks in excel 2003
How can I use VB code to execute macro when double-clicking cell?
Excel Sheet.Copy Method (Excel 2003 SP2 )
Delete a Column Based on User Entry
still saving a record to excel even if i press the NO button
2 questions about developing.
Save macro Truncating text
Can anybody help me please?
Can anybody help me please?
Reading Row headers into a listbox
Filter problems
Filter problems
Filter problems
Timer
Put 1D array into column
Seclect Column or Range according to Cell's Contents
VBA automatically change text format into general format?
Query parameters
London Excel Conference Registration giveaway
EXCEPTIONALLY SLOW LOOP ....help!!!
Putting the document number custom property in workbook
Cannot Shift Objects off Sheet....?
search worksheet
Speeding up Array
Read/Write from/to a closed workbook
Query - Data Layout
Message Box Help
How to pass variable between closed workbook
How to pass variable between different variable
Average a range within an array
Delete Unwanted Rows (Help with Range)
Pagebreak and Zoom problem
"" does not return blanck
Problem in linking
Using Range & Cell
modeless
do while loop
Filter is not working anymore.
Paste Values
How do i parse a text string with a date?
Name Manager: new version released
creating form on worksheet
Lock Cells with Specify Range If Cells contains value
Summarise Worksheet Data
making cells change relative to each other, cant figure out
Summarising Worksheet Data
Run Macro after update
Refer to sheet2 - even when named
Change delimiter in import function from comma to tab
PIVOT TABLE DATE GROUPING
Macro to add count forumla with dynamic range
How to program keystrokes other than CTRL+something?
How can I search in this forum?
pasting into a list using a macro
Delete selected sheet
Custom button :Copy data to new workbook
copy and paste from one sheet to another with VBA
Runtime Error 9
No sure why this isn't working
vba select from Active Directory (LDAP)
using variables to reference sheets
Too many gotoos?
Find out if a Value is Contained in a cell
Problem deleting rows by index
Need Help w/ Search or Find Macro
Date from a cell........
huge problem!!!
Trapping error from Empty Dynamic Named Range
I need more help with Absolute Reference
Cell Colors Dependant on Date
MSAccess 2000 Newbie Question...
macro I shared isn't available in any other workbooks?
Macro to replace error values
data capture from screen
sort grouped cells
PageSetup.set_PrintQuality .NET method
VBA - Strange behavior
VBA Error Handler
Formulas not working once macro is used
Formulas not working once macro is used
Stupid question from newbie re: data from multicolumn combobox
selective protection
WorkBook Activate event not working
Macro to find columns to hide
Gathering Data
Case Statement - help required
Set a range for all worksheets in workbook??
Web service to Pivot table
VLOOKUP in VBA
Word crashed after repeated XL macro use
Variable Range/chart
Update Values Dialog
"Too many diggerent formats"
Duplicate prevention from Listbox selections to worksheet
For Each Array Question
excel help
Save Userform as bitmap
add row to the end of a list and data change
modifying formula reference
V Lookup Problem
FAO Mat P:son
Which sheet gets calculated first for iterations?
comparing rows
Macro to copy Column 1 of all sheets to a seperate sheet.
Opening Multiple Sessions of Excel
HELP! Conditional Formatting
Date in VBA
Sorting information
Page# Return off lookup
Opening the Autofilter dialog box
Automate cell selection
Re: Date Picker - "Linked Cell" Property
Date Picker - "Linked Cell" Property
Newbie question
If cell is empty then run macro otherwise skip this macro
Time range to workdays in relevant months
Cell addressing
Copy and Paste select data to another workbook.
use of PROPER function in Macros
Problem with macro for importing data to template
Macro Opening or Looking for Another Workbook
Reg : GUI
formula for finding Friday
Add value to cell...
Is there an "OnOpen" event for Excel
Macro for Row Processing
Update Sheet1
Creating User Friendly Templates
Formatting Excel charts created with VBA
Error 1004: Application Defined or object defined error
Print multiple reports from list validation
VB & autotext
I need a QueryTable.Refresh solution
Making Excel 2003 as the Default over Excel 2007
In SelectionChange Make Last Rwo Dynamic
Collect used areas of multiple spreadsheets into one...
Modifying .txt file using Excel VBA
RTD formula
what went wrong?!
Delete Rows
Re: Sell Program - Screwed by Managers !!!
Countif result in message box
How to diasble save and save as menu but allow a save button
Option Button Grouped
Remove Chart Label with Percentage 0.
Hide whole row when cel C3 is 0 (zero)
Select.Range
Read data
Web Query
MACRO HELP
Number stored as text. How do I keep the number format?
Locate and Format Row Macro
Last week for regular registration - London Excel User Conference - July 19-21
How Do I Modify Pearson's Code to Add "Treat Consecutive Delimiters As One"?
Scheduling Worksheet
fill blank cell with cell above: special case
Programmer to hire
Looping to update another sheet
Command Button on worksheet
how to select a shape
Macro for sorting within groups
Having problems with quotation marks
text in ***
Need Help Importing Text File Using Two or More Spaces as the Delimiter
Help with Object Design
excel close + save by button press. how?
ActiveWindow VBA problem
Running two arguments within same code
Sort out data on seperate sheet
printing special numbers!
Last Column to first Column
Need emplyee time card app, daily in/out, excel vba based.
Fill FAX template in Word from Excel VBA
Self-Contained "Database" file?
Program to resave a collection of .xls files into tab separated .txt files
Alignment of Graphs
Error in code
.xls values, like .pdf
selecting a column
Questions: Copy ranges, autofilter macro, subtotals, & naming shee
Translating numbers into number with color pattern
Read value from combobox (cleaned off duplications)
variant to long?
Add new sheets with code
rng, varinant to long and offset questions?
Delete all rows not today
Trouble with this code
Find last row through a macro
user-level access to pivot table
Upper-case all text in Excel 2003 spreadsheet
Copying worksheet to new file by macro
Creating an image file
Workbook open event
Problem with file finding macro
Case Satement
VBA programming certification
How can I select a range of cells for header?
Changing cell color if date is...
Determining What FormatCondition Has Been Chosen
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row
Embeded Wav
Map/List of folders, subfolders & files
"Force" user to save file with specific name
CommandText
Suming a column to another worksheet
Bringing up sort command
listbox to cells??
Force user to save file with specified filename
I need help with a (apparently) very simple VBA script
Clear cells in Column D if not = Auto
Determining if data is sorted in descending order
Send email based on date value
Orderly Validation Against Separate Ranges
Help Template & Database
Setting Timers in Exce.
Shortcut Key
Populate First Empty Cell In each Row with Text
Excel crashes everytime I send focus from control to worksheet
Excel sheet analyzer/generator
Macro to Paste Items to All but Several Workshets
Code deleting all rows in error
Format prompt in VB InputBox
Extracting data from some files in folder
Simple iteration problem
DATE & MONTH minus ?
Need help with grouped counts
Identify an add-in file that is not installed
How Do I "Toolbar List"
code dropping zeros in number strand
How Do I "Toolbar List"
move to new column after ,
Syntax error in code
CopyFromRecordset will fail if the recordset array data such as hierarchical recordsets ???
Problem with Date Conversion Code
extract data from pivot via vba (Getpivot is not convenient)
Copy and paste data from one sheet to another in a single workbook
Disable all "Refresh Data on File open"
Add-ins passwords
Delete entire rows where there is a blank in column A
VLOOKUP with multiple criteria
SUMPRODUCT - small correction required
VBA replaced ?
Filling out usernames in IE
Help with Creating Email
What in the world is it doing??
Public function in Personal.xls
MACRO HELP PLEASE
Macro help please........
Speed VBA Excel 2003 vs 2007
Change color of text segment in msgbox
How to save a file
Sell Program - Screwed by Managers !!!
Excel 2007 Beta
getting info from multiple workbooks simultaneously
findings text in columns
First of the year
Loops
making text in Title Case automatically
Simple question
Factorial macro or formula.
How to Show Existing IE Instance if Already Exists, Else Open One
Password protect a workbook created and emailed by a macro?
Match columns
next empty row
Find and Replace Values in Range
userform cancel button
Adding a hyperlink to a shape
Macro to paste in the active cell the contents of a cell from another file??
Save a Workbook as "Read Only"
Please help with auto Date and Time with VBA
adCmdText
multi tab workbook
Auto-Format Excel Spreadsheet?
VBA/Excel Add-ins
Easy questions about Auto Save
Code For Date Accepts Text
Creating an MSForm based on a table
Textbox in userform doing weird things
General Quesiton
is a variant an object
Extract data from many workbooks VBA
Concatenating problems
repost: Dynamic chart help
saving website html as string
What function(s) should i use?
Macro Question
socket in excel vba
Hyperlink to Word Template
Combining files and their respective VBA macros
Excel IF function help
More efficient copy/paste??
Determine if folder exists
What am I missing here?
Help needed with Pivot table macro to remove data
Won't accept textbox3
FileSystemObject.copyfile
Automatically update links in Excel 2003 after inserting rows in .
Problem with Formula n VB Macro
Accumulative total
Return ADO recordset to worksheet
help me¡¡¡¡
COUNTIF criteria in VBA
Quite simple macro, but I can't seem to fix it...
Macro to copy specific cells from one workbook to another
How to update an external excel sheet
Application.Volatile
Program to accummulate data on ledger sheet
Macro to Move Excel Button
Updating Data through Webservices using Excel
Is this macro even possible?
macro CopyData Help
Question about a custom defined function
Create an Excel splash screen without the caption bar
how to remove a space after a string?
Line number in error handler
How to count number of pages in a named range
Calling a button event from a .NEt application
how to execute a macro assigned to a checkbox in vba
Excel keeps reformatting floating point values to dates (e.g. March 17)
Macro to Paste
Retriving name of cobntrolelement
Final days for regular registration - London Excel User Conference - July 19-21
colouring the entire row to a color .
Excell sheet help needed
incorrect addition
Data validation dependent of value of option button
Fire events for all comboboxes in my sheet
Find new value and replace with old one
Formatting / centring Text in a Msg Box
find and delete
Context menu
Log file...
displaying the user form data
undo delete
Help with PasteSpecial
RePost - Creating WBooks
Dynamic chart to track progress by date
displaying contents of a user defined directory
Validation list to a Range?
Custom Menu Bar
C# RTD Server
XML Files
RE: xlCellTypeVisible - not working?
RE: xlCellTypeVisible - not working?
Locking cells with a checkbox using a macro.
Double-Click on cell
Passing formula value to variable, hide rows
Excel crashes on simple procedure
Create Named Range in VBA
Wildcard search for string within a string?
Referring to a worsheet in another workbook
Application.Calculation = xlCalculationManual fails
macro for copying a range to a column of cells
Macro delimiting text if column has value
Re: xlCellTypeVisible - not working?
Input Box Size
Complex SUMIF statement
Macro that deletes certain rows only
I hope not a dumb question.....
Retrieve all Outlook calendar appoinments for a day
Active Workbook
Copy Formula Instead of Value
Passing File Name To Macro
Workbooks.Opentext - oldskool '97
Selecting a sub range?
Hello I am trying to write an If/Then statement. Here is the data.
using row autofit but with minimum height
Copy text from Excel to Word
variant to integer format?
Using Pivot Table to analyze multiple variables in satisfaction survey
Count displayed rows
Form Question
Copy formula to a column of cells
Compile error screwing with me
after save event/procedure
how will i create a formula that will copy the content
2 Questions 1 about Macro, 1 about VLookup
Indirect reference to run macro in another workbook?
Macro If And
Conditional Copy Macro Help Needed
Page x of y
Check For Add-in
MailEnvelope
2007 Bug? ChartTitle.Characters.Text not working
Newbie Question on Setting Cell Value in Sheet2
Set Cell Value
Disable drag and drop and cut and paste
extrapolate range coordinates
Auto Hide Task Bar
remove autofilter from some columns
Convert EXCEL to TEXT FIle
Round Robin Tournament Generator
where do I find docs on excel automation programming?
Download from FTP
Newbie Questions 02
Creating WBooks
HELP... AUTOSUM........Add(msoControlButton, 226)
'extra' file in VBE project- can't delete it? XL2003
Detecting key presses
Pivot Table heading case sensitivity
Last Used Row
Embed a Userform into an Excel document
CommandButton Question
DTPicker to be dropped down on initialisation
string parsing w/wildcard problem
is it possible to automatically change the color of the bar chart as soon as it reach
Select a sheet by name in a macro
Delete row problem, could some help me on that?
Two links changed on my site
SendMail Error Trapping
Array from row in worksheet
transpose data from horizontal to vertical in a specific column
Counter variable in For Loop
SUMPRODUCT
Macro If and...
Excel PivotFields/Items
Getting a hook on Toolbar Events
vba check for disabled macros
Finding duplicate values b/w two columes
Path/File access error
Selecting Blank Cells
copy rows based on specific field value
External Reference - Filename Change
Change background color
Set Path for GetSaveAsFilename
Copy and Paste Visible Cells
Solver error
Arranging VBA windows
New to Programming
Newbie add-in questions
A macro that shows updates - PLEASE HELP!
runtime error -429
Inserting new worksheet
Date Format in Userform
Run procedure when value changes
Count number of cells that are highlighted
compare cell formats
CSng adds erroneous digits to the value
Why is this a Type Mismatch error?
Calling a private macro
Newbie question
inserting formula
Can you count a certain color cell?
To delete certain data in excel. eg contains #DIV/0?
Autofilter dropdowns
getting size or setting it?
How to read the Amount and MinusValues of ErrorBars in a series
Printing pages from different sheets in a set order
how to create macro that will display the sub_subfolder
Dynamic Range
Could not sort the first row ??
VBA vs VB.net
custom button to copy a few cells and paste on somwhere else
Flashing Curser
Make a loop to Find a value then move a row of cells
Change the Formatting of All Instances of a word in a worksheet in Excel
Selecting values from a list to add up to a specific quantity
Auto message box
Ignoring Certain Characters In a Cell Using VBA
moving cells to another column based on number of characters
Sort out data with VBA
Changing Value of Cells
Is Excel is now going out of it's way to mess me around?
Create summary WB
Tricky data type error
Validation Drop Down Box
integrating row number in a formula
Need a Matrix diagram - Please help
copy and paste (visual basic)
Read zip file on disc
linking workbooks - expert advice needed!
Determining Whether File Exists
Confused about assigning DIM and such
Dynamically refreshing Pivot Table Range.
is it possible that the data values shown on the data labels be in a duifferent range
Modify database
speed of processing
Array usage
error handling
calculate all possible combination from 10 variables
Help!!!!!! - Find Function not working from C#
End of Spreadsheet
Pulling my hair out
Inserting Values in a Multidimensional Array from Two Different Controls
Macro to Create Sheet & Duplicate Sheet
Converting a formula to its value
Importing/deleting .bas files (a lot)? Repost
how do i enable user logins
Workbook Open not triggering
The Ultimate Problem
Form placement on spreadsheet
Open excel at a set time
Linking Tab Names to a single cell with a worksheet
What is The ORng value after this code is run?
Dim
Range.Value2 is failing for lenghty strings
Dynamic multidimensional arrays
RE: Dynamic multidimensional arrays
code failure
Assign cell value to variable
Find
-2147221080 800401a8 Automation error
RE: Dynamic multidimensional arrays
Microsoft.Office.Tools reference
RE: Find
RE: Find
two lists of numbers
problem to access sheet from add-in
work with invisible sheet
Font of ListBox
Logical operator inconsistency
open workbooks to extract info into one
Populating Cells using VBA
RE: Running the second part of a macro only on Thursdays?
Add Formula SumIf Relative Range D = A*
save and replace
Re: Have 2 Macros run in a specific order...Can This Be Done
Duplicate all Macros?
Have 2 Macros run in a specific order...Can This Be Done
Variable Filename calls
Disappearing Callouts
Running the second part of a macro only on Thursdays?
Runtimem Error 9 Subscript Out of Range
Path/File access error (Error 75)
Parsing a string
Table Update
Before Print - one worksheet only
Refreshing Imports
Changing font color in email
Selecting many Checkboxes to align & size
Data Entry and Display problem
VB Macro to Automate a Search/Replace
for next loops>> basic information
Updating a cell that uses a .NET add-in function
Won't Add Multicolumn Data
Macro to insert lines
Resize Print Area/Pages Macro
RTD value changes not triggering worksheet change event
Changing subject line in email
Does library reference stay with the code?
pull down menu in validation cell
Seach & Replace Macro
Chart Name
Listbox Column Count and Width Dont work. Seems Easy
E-mailing in Excel
Excel VBA
Hide rows with macro
Save column J only using copy/paste & temporary copy
Through a command button hiding rows
Search Spreadsheet - Results in either listbox or new spreadsheet
Why doesn't working? Application-defined or object-defined error
Opening an Access Database and running procedure Via Excel VBA
Exporting data to another spreadsheet
Update E-Mail Data Base
Using solver while disabling auto calculation
Renamed ranges - PART 2
Excel 2003 Performance/Status Bar Quest
Challenging?
macros
Trouver la ligne et colonne sur laquelle se trouve un checkbox
printing selected sheets
Getting Word to work with Excel
Getting Word to work with Excel
Insert Diagram
Macro to open search box?
Excel 2003 vs 2000 VBA Compatibilty
Excel workbooks , internet links
Hide all Sheets
option buttons
Relative addressing with INDIRECT function
Print 2 pages per sheet
RTD feeds into excel not trigering a worksheet change macro
Can this be done?
Command Buttons on Excel Worksheet - font size decreases on click
Excel "price-stop" formula
Calling a sub method
cell copying?
how to log all excel files opened on my pc?
emailing info
Progress Bar Control
Re: Shouldnt this work?
Re: Shouldnt this work?
sum format
Ref. problem after sheet import
submiting from form to sheet
path xml mapping
Excel - Polish version - SUBTOTAL
Function runs more than once
disable range selection
Including an inputbox within a macro
Match and find entry
Insert Formatted Row at specific point within Dynamic Range
Using DTPicker to change date in a cell when user selects cell?
How do retrieve data from anotyher excel file...Pls Help..Urgent!!
Pie chart slices too thin
List of Folders
MFC - CopyFromRecordset - Copy data to Excel
Populating Lists in forms
copy several cells if one cell is set
Lookup or Index or Match, not sure.
copy several cells if one cell is set