Excel Programming [Archive] - Page 34

VB Generated Hyperlinks
xla export classes, modules and forms
Need Alternate Code or Formula
RE: Manipulating Text in Rows with COUNTA and CONCATENATE
IF a condition is met
How can we look for a number in different workbooks?
Custom toolbar, setting docked position
Jim Rech's SheetToHTML function doesn't work in Excel 2007?
Variable not Defined Error for Sorting Excel: 2000
Referencing .NET DLL built for COM in VBA
Excel 2007 Scatter plots
Please help make this Archiving Macro work...
Concatenate /w Chr(10) error
Unhide VBA Toolbar
Map ActiveX
Macro in 2003 vs 2007
Excel 2003 vs Excel 2007
Serial Number start and end range auto-fill into cells
code for printing pages
Re: Problem with drag and drop formatting
XLA development best practices
error on add validation
How to make Computer name as a Password by VBA
simulate pressing enter not working
Getting External Data
Linking spreadsheets
How can we look for a number in different spreadsheets?
Scroll to selected cell
Automatically resest variable values = 0 after runtime
File Browse Function?
AddItem to Worksheet ComboBox
Print + autochange info contained
Picking part of a cell based on cell contents
MACRO TO POP UP SAVE AS WINDOW
Question regarding the use of SUM in relation to text cells
Highlight text in textbox
Conditional formatting based on different sheets
Need help on checkbox and textbox on userform
Cannot open the DBF created from the SaveAs option of Excel
Screen looks strange
Save as DBF 4
how to run macro on opening of file
Popup in excel macro
togglebutton to act like optionbutton
Excel Calendar to ONLY allow for Tuesday's in any month to be selected
Adding Rows
vbApplication-NOT-Modal
Help with Selecting multiple Checkboxes on a form
RibbonX Customization Question
adding data from two colunms
Need help to read data from a text file
How to Display UserForm on Full Screen.
Range.find performance
Find and replace cell values Macro
Stupid array question
ComboBox displays last selection
Formulas into VBA
Togglebutton
Togglebutton
Deploying custom toolbar and custom icons
Populate Deposit Record from another worksheet
Reading field values selected by a Page variable
Run-time error 1004 since upgrading from Excel 2003 to 2007.
Radio Button Size and Print Features
Re: Test to see if Workbook requires a password
Fill down two columns...C & D
Distinguishing 0 formatted as "na" and as 0
Error using..... .Value = .Value
Set StartRange and End Range
How to return a column number?
Setting Range = Array of User-Defined Types
Use VBA to Enter Break-Mode?
Userform input question
Change "With Worksheets" to "Activesheet"
VBA Email Cell Contents When Filled In
printing same tab from multiple workbooks
SQL Query to Excel
Redimming (preserve) a 3D array
Change NumberFormat and Cell Fill Colour in SELECT CASE Construct
Gathering data from multiple, non-contiguous ranges
Like operator in SQL with Excel Driver
Problem with Userform the second time
Copy the value to the next open cell when the original cell changes
move data from rows to columns
Build Pivot Table with VBA; Keeps Throwing an Error
Copy Current Month into YTD Spreadsheet
SheetCalculate Event
Search for strings
submit web form
multiple Insert Shift:=xlDown
Code help
Trimming worksheet name from an imported data source
RE: put the program on server
Countif and
Detect UPPERCASE in cell value?
Last KeyStroke
Send e-mail from Excel macro problem
adding automations to Excel (doesn't seem to work properly) !
macro = Can't perform requested requested operation
For Next Loop Function for Creating New Spread sheets
Use of a range as an email address in a .SendMail array
How could I have saved memory?
Show UserForm ScrollBar
VBA Help
From Outlook to Excel with VBA
Never Looped before
Re: Inconsistent behavior when applying conditional formats
MACRO: Multiple Find / Replace
Command Button
Grayed out or disable?
Re: GetObject when more than 1 Excel is running
RTD DLL not responding on some machines
Change isAddin to false or true
cycling through all the possible criteria in an autofilter column
Data Validation in a Custom setting and forcing Upper Case
Properties Window in VB Editor
Time and Minute formulas
Showing Processing Form while running macros
Find position of a character within the worksheet cell
RE: Clicking on a Cell
Change cell colour based on an IF statment
Add sum to dynamic range in Macro
RE: Copy and Paste Pain
REFRENCE A TEXTBOX ON A SHEET IN EXCEL 2000
Start Excel anytime
Re: Intersect or Union?
Re: Intersect or Union?
macro to Subtotal by Group
Create Hyperlink in Current Cell
Bad code?
VBA code sort problems - recorded macro does not work with userform
Urgent language problem
Getting FileName from Search
random numbers
Data Fields in Pivot Table
Why wouldn't listbox's values in Excel stay selected at restart?
Showing a progress message
Insert row if cell contains caracters
Is it possible to do a v-lookup using similar data?
Evaluate text string as formula
AutoFilter and Sharing
Interactive Find and Copy
Extract first four letters from string....
Hide macro List from Alt+F8 window.
Command Button Help!!!
If tab exists "Yes", else "No"
Clear if "#N/A" and Find End of Range, Fill Blanks
VBA Multiple Criteria Lookup
Looped Find and Array Doesn't Find
Create a new range from existing range
A beginners Elseif question
Workbooks.OpenText - Disable Use of ThousandsSeparator?
Transposing
Copy row to first empty row in new sheet
Auto-refreshing results of module-calls
passing data
Unable to parameters in MicrosoftQuery
Select Embedded Documents
using a formula for a column vs. looping over each row - speed difference?
Verifying a worksheet has no dependants
macro to enter data into different line
How to write FIFO Function in Excel programming
web box address
value in range
track changes
search for capital letter at end of text string
Identify what Combobox was changed to update the correct item on the previous Form
Excel 2007 Solver Addin Error 400
setfocus
Run-time error `91': Object variable . . . not set
PivotTables AddDataField
How do I add additional cities to this drop down?
PivotTables.AddDataField
How to get source data range for each series of an active chart
Return ListItem via HitTest
Nested If/Then Help
COlor Coding specified time frames
Excel VBA AdvancedFilter Question
Excel Macro 'Sheet.Range.Value' Syntax Questions
Excel loses mind clearing VBA global variables
Code not working, copy in Select Case section not copying over.
Printing Problem
form submit
Protection Issue
reference cells related to the current cell
Excel 2007 chart question
Application.Intersect
Trouble with an Array!!!
Pivot table refresh problem
Find A value in a column and count the rows
Need a Macro to create a Pivot where fields may change
how do i use a macro
How to determine if an excel Excel was open by code (automation) ormanually, by a human user
Linking Checkbox to Worksheet
Offset Range
Set initial filename before saving
Assign a single variable to an Array filled with same data types
Print Range Question
sheet name text color
Delete Rows x-n
random permutation of an array
Macro on Password
Very basic VBA questions.
International/Date issue
Invalid procedure call or argument for Dir$ (Run-time error '5') ?
Delete row if value is zero
form field
Excel macro security
EXCEL FORMULA TO VB
Run Time Error 13- Type mismatch
Activate Sheet switching
Looping through cells and holding values
Using built in "mail recipient" with custom command bar
Using mail recipient for support queries
Sorting by only numbers
How to read data from binary file?
Using INDIRECT
Retrieve number from string
'Search' problem
Edit Data by UserForm
background colour.
"Search" Macro problem Help!!!!
Via code, making 2 named Ranges Indentical, upon change
Please help me finish this simple macro
Error Using the PivotFilters function
Wrong columns sometimes selected -->?
finding last space in a text function
Shift constant values in a range left or right by n columns
Splitting Data to new workbooks
using & function
fileformat property compatibility
De selecting a range after a copy and paste is performed
Get the value of selected text (outside of Excel)?
Using Sub RDB_Merge_Data()
license
Relative Formula References NOT changing After Insert From VB
More Efficient If Statement
Conditional Formatting from VBA
Procedure too large
Code Modifications
How do I make the mouse cursor get a value..?
Reference Label from TextBox
set Object = Nothing
Export Data to Text file with fix format
Sorting issue has got me puzzled!
Sorting issue has got me puzzled!
Place VBA in cell on spreadsheet
Reference Label from TextBox
Reference Label from TextBox
Combining TextBox Values With Spaces
If Value is > 0, in a named range ??
Input Question Help
Time stamp multiple cells changes when external database autorefreshes
My Excel macros won't run any more, even Low security
clearing excel memory before saving
Set Cell.Value to the Formated value
Convert Advanced filter macro to VBA
VLookup in VBA?
Listbox
One macro changing another
Switching to a specific worksheet
Adding a commandbutton in Excel 2003
Excel 2007 Chart in VB6 Program
txt-file is in ANSI format or OEM Character format.
linking external data
Learning excel programming
How to output a textfile format in such design
Copy and Paste Problem
Help Excel 2003 code failing in 2007
create exe file
File not found (error 1004)
Error 1004 setting xValues repeatedly
Refreshing a listbox
Re-Post: Embedded Word File
Finding empty cells
XML parses HRef inccorectly
Open a new Browser Window, when using the "hyperlink" funktion
Excel 2007's VBA Project password security
offset row not column
Dynamically set SaveAs folder in VBA
Application.DisplayAlerts problem
ListFillRange
command for save and close my page
Warn if Cell/Column/Row Contains a Range Name
Need to find a value in a range and take action if its there
Excel Programming
Replace microsoft forms message box with something more meaningful
Separating information in a text string
If, Then, Delete Entire Row, Loop, End
how to append and remove dups
Comparing two spreadsheets to analyze changes
Similar Cell Data Comparison?
Query website from spreadsheet
Question about linking Access to Excel.
Macro jumps to combobox
Adding Labels to a XY Chart
Load Pictures in UserForm from Worksheet
Code is skipping stepps
Error when adding custom help file to custom function
Formatting rows based criteria
Ignore First row
.SendMail how do you turn off Alert "This program is trying tosend...
Insert rows without copying borders and shading
Unable to get the PivotItem Property of the Pivotfield Class
Routing slips in Excel 2007
Conditional Macro
Internet Explorer Automation through vba.
Creating Name with variable
How to get access 2003 data table particular data in excel.
Locking / Unlocking Cell with out Protection/ Unprotection of Shee
Select Worksheets, Copy to New Workbook
Why are my Add-In formulas recalculating everytime I open a workbo
Filter specific cells by hughlighting
Sort Range and Sum/Delete Duplicate Rows
Removing Names
looking for a simple question and answer format
Remove item on list box
Two IF Statements Q
Finding out pathname
How can I make Excel copy and paste specific cells every 15minuts
Macro to create seperate lists
Pastespecial Operation:=xlNone
circular reference
Repeat a macro until the last line is empty or repeat it 1400 time
Entering Userform data to worksheet
Cell invisible when printed.
code to automating digital sign
transposing data in excel worksheet
Simplest Question
Tab Selection
Quickly Tab Selection
Modify on close
listbox remove
Listbox
Ways to parse cells in mulitple selected locations
Exit Excel (2003)
deleting named cells
Listbox
Wrong current directory
Run time Error
=OFFSET(MATCH(My frustration continues!))
Import all sheets, without knowing their names
Gridlines
Finding Values of X
Delete shapes in a range
Unzip specific files with .Namespace?
Prevent UserForm by Ctl + Break (Unload Form)
VB code help
Month and Year in Excel 2003
Personal.xls macro that writes to ThisWorkBook
2007 vs 2003
How to? Date Function
Code interrupted
get the name of the currently active procedure?
Comparing data in cells
Error in Workbook_Open
Enumerate all global variables?
Insert a blank row
Alien abduction of VB: "Code execution has been interrupted..."
How to get source range from chart object?
can a userform be 'locked' into position
using border/usedrange in vba
confused and confounded!
Hide/Unhide Toggle
Macros Disabled in Excel 2007
need a macro to edit names in excel
How can I set up an excel file to auto import data from a CSV fil
VBA IDE Settings
Protecting a worksheet
AutoUptade an Image from the Web in a Worksheet
Copying multiple worksheets to a template using vb.net
INDEX, MATCH, AND OFFSET... OH MY!
if then insert and add
Delete first line From CSV file from excel
Run-time error 1004: Method 'UpdateLink'
Inputting UserForm data into specific cells
Page number reference in a cell
On Open using Public Var from VBS?
Connecting to accdb with Excel 2003
Copying text from text box
Get data from excel report into row of csv file
Update workbook without opening it?
Auto-refreshing VBA modules/functions/macroes
retrieving rowlevels
Adding a calendar item to Outlook.
How do I stop formulas from calculating when I open a worksheet
extracting data from columns to summary sheet
logical function template
Copyin Formulas containg Names
running an Acess Macro from excel
How to set values to a range vertically
CONVERTING EXCEL FILE TO DBF FILE IN OFFICE 2007
Open Outllook through VBA
Unable to change security setting from "High" after reinstalling E
Pattern/trend analysis against dates
PLEASE CAN ANBODY HELP
checkbox and textbox help needed
vlookup with a variable
How to add list item to a listview with optimize performance
VBA string funcs on left side of assignment?
Comparing and Reconciling 2 excel tables.
resizing a Combo Box
Inserting Image based on cell value - Help
AutoFit macro that will not affect the header row?
Make function available to all workbooks?
Basic Security via PDL
checkbox help needed
finding data across multiple ws to populate a userform (Need Help)
Assign a project name to weekly hours/pay
deleting data but not formulae in multiple sheets
Hot to change the Excel File Logo (VBA Project)
VBA code to update sheets in manual calc workbook
Simple If Statement
Mobile Office 6.1, Excel Mobile
Hide a Cell Value
Insert line in first row of CSV text file with VBA
How to select a range based on what's in the row header?
Macro Need
Filldown Formula
Sheet Tabs
Keep string without rightmost letters
border for if
Advanced filter with naming range
Delete and Shift Cells up
Can you formulate a cell to add and subtract in the same cell?
Reference/define last cell
TRANSPORTATION PROBLEM
ShowModal, Hide Form, Print Preview Office 2007
preventing access to hidden worksheets
HOW TO MERGE TWO MACROS
limiting number of uses
Chronological Numbering Spreadsheets
Multiple Office Versions
link excel or calc data sheet with access database.
Merging Worksheets together into Master Worksheet
Trim function in macro
Index Creation
increasing Excel spreadsheet iteration time?
Insert Two Lines After Change in Project Number in Column A
Code for OptionButton displaying new frame
Trouble updating a cell's text that has a formula in it through VB
Excel: reading tables with multiple rows and columns
Convert Macro into UDF
Auto Start a Macro in Excel 2007 VBA
? for Ron de Bruin -- NavToolBar
Page set up change it self
Excel Lists
code to check OptionButton selected within multiple frames
Application.Worksheetfunction.Sumproduct
Type mismatch error - New to VB, please help
How to update data between different sheets in a workbook?
Running Macro
Quantities per week??
I need to use a countif but looking a cell value
Automation AddIn (UDF) in C# not able to manipulate XL Objects...
listbox
Chart Property (e.g.: .HasTitle) reset fails with run-time error 1
random number generated password
Error with a boolean operation
Hiding A Text String?
Msg Box
activeworkbook and thisworkbook
if elseif....
ISNUMBER
Remove Sheet
set visible range
Trying to understand FormatConditions in XL 2007??
Finding datasource in Excel worksheet
Deleting sheets
Help! How Do I Do This???
Setting a range.value equal to /part/ of a (3D) variant array?
How to define a drop down row filter in cell C2 for cells C3:C27 ?
Date Calculation inconsistant results
Code Error Problem
Make same picture appear more than once
Major help needed!!!
How to re-sort a pivot table filter
thumb-nail file preview
Error on textbox entry - Go back to text box
Error when selecting date range.
Linked Sheets
delete rows in which the result of the formula is " "
Vlookup
Web Query - Tim Williams xmlhttp Object
Problems tabbing through option buttons
How can I...
Command to prevent "event" macros from firing
Inventory questions
Inserting Values into an existing Row
Combobox Question
VBA to Update Pivot Table
Move to specific sheet and cell based on criteria entered on anothersheet
How do I change the date in a pivot table pagefield using VBA
Mysterious dynamic chart (that suddenly isn't!) issue
Runtime error 438
BOM requirements vba or formula
VBA "Left" not working
Help changing a macro - SImple change please help
Annoying message - anyone know why it's occurring?
Call Variables by String
Call Variables by String
Error importing pasted data
Variable Names Range - Help Needed
2008 East Coast US Excel User Conference
VBA Dates & Cell Dates
how to select entire rows desired by user
Excel RTD - no topics on workbook open
Excel 2007 Pivot Tables - Updated Data Source
**Increase Font Size for Selected Cell**
Show in View-->toolbars
Capture close excel event in .xla
Save as pdf with special name
I am pulling my hair out
Deleted Custom Toolbar keeps returning.
Random Entries Help
Learn excel programming- Any sources
Insert data on sub-header change
Copy column to WKst1 from match of wksht 2 and 3
Enable macro message on VBA Workbook Open then macro ends
Which picture was clicked
Sizing columns and rows in a workbook
e-mail - error message Run-time error 429
Issue with Solver
Problem setting the State of a custom Toolbar button
Incompatibility between Excel 11 (2003) and Excel 12 (2007)
Insert row
maxlength on textbox
Event change listbox
library circulation functions
Saving Workbook Error-Plz help
Re: View Listbox items in the Label
Keeping Leading Zeros
Copy column to new sheet and update
Autofill incrementally within formulae
Passwords
Holding a constant page while the macro runs in the background
Re: delete sheet
RE: ***Challenging Pop-up excel box dealing with user information***
***Cell Shading (Fill Color)***
Iteration Sub wont work with Toggle Button Accessed Indirectly
Update for 5 of 6 links
sorting problem
How to access Visual Basic Editor via VBA?
Re: Calculating flow days help
Sum
Renaming jpgs in a directory using names in excel spreadsheet
Inserting a row
Logical comparison not working in VBA ????
Re: Path/File access error: '\VB*.tmp'
Note: This is for C#, VS 2008
Re: delete sheet
Re: delete sheet
Invert Negative number?
Re: delete sheet
Auto hyperlink between sheets by same number - maybe macro?
Converting xls to pdf problem
Programmatically opening workbooks in macros brings up Enable Macr
Highly specific Exell Problem
View Listrow contents in Labels
Push updates to other workbooks?
Worksheet naming
Excel 2007: How to change colors in TextEffect
Combo Change works in 2K not 2003
Color field if date equals certain criteria
TextBox Event Error
Save workbook To any USB Drive no matter what drive letter
Getting "Permission Denied error 70" on Windows XP and 2003
Compare row contents
Protecting macro code programatically
Formula for getting the breakup of net amount
Re: Kanja Tarpelan mummoluukki
Using lookup
Adding numbers from other sheets?
ConnectCode Asset Tracking Excel Template (v1.0)
Enlarge font & change color when cell is selected
Need help with Array with type, invalid qualifier & runtime error
changing pivot table into a formula table
Window Freeze
Move to a cell based on the address in another cell
Simple "Left" Problem
how to clear cell based on text in other column
Office 2007 Functionality
Address of selected range
suppress compatibility warning dialog during save
Lookup account numbers
copy & paste combo box
ADO Read from Access is very slow...
Find Record in exel worksheet from UserForm
VBA keywords vocabulary
HELP=> Unale To Resolve VB Code Issues !!!
select whole rows desired by user
Textbox Decimile Problem
Automatically bordering in 1500 sheets
autosort
how to transfer data from one workbook to another with VB
RE: Lookup account numbers
RE: Lookup account numbers
RE: Combo Box
a) char(10) and b) asterisks for borders?
Chart title made live?
Creating a macro to print to file when printing to another printer
Equation Editor and substituting vales
Error 459
Excel crashing when calling a MacScript
Selected Cell Problem
Extracting portion of filename
Listbox
coverting numbers to words
Automatic insertion of page breaks
autosort left to right
Spin Buttons For Time?
Problem of Inserting worksheet
excel macro
copy cell contents that meet date and list name criteria
Formula to move content from 1 cell to another
Formulas appearing in empty cells when they shouldn't
XLStart is empty but Personal is still running - sort of
XLStart empty but Personal still running
Creating a macro to print to file
Unlocking and Locking in a Marco
refresh data from MS Access DB not picking up changes to criteria
Any ideas "can't enter break mode at this time" error gone amok
Prompt to Fill in Values
Macro is not working
delete all blank rows in a table
formula in VBA
Want to delete rows based on a condition
What happened to the calculation speed?
File tags for Image files
Get Date from one cell to format another, then...
Can someone help me with this marco
Create a new sheet from an existing sheet
hide/unhide tabs
Question about looping
Formatting Numbers Imports
Do Loop and data formatting question
VBA Macro Dist.
UDF is not executing
How To Disable The File, Print... And The Print Button Functions
Nested IF / greater than / less than help
The Old Rounding Question
Add Workbook As Seperate Window
if/then formula
shape, textbox, autosize vertically 2007
Merging columns based on cell condition
how do I count the total number of characters in a excell cell?
Automation, send email or red flag if cell value exceeded
match identical cols
Copy worksheet with named ranges to new workbook and keep names in
Code string for button
Opening a txt file
Dir Function Sanity Check
OpenAccessProject
finalrow question
Pivot Table - Using If Then logic
Autofiltered cells not "Hidden"
Seperate date from text
Need Help Looping through a file
macro to select range from active cell range name string
Excel Instant Messenger
Why does Excel think it's "Picture 7" instead of "Picture 1?"
tabs in webpage
COMException on InvokeMember
Multiple same rows only one column changes
export into Q BOOKS 07
Web query returned no data - turn off annoying message pop ups!
CountA formila for a varying range
Entering Formula using Array
Can't use COUNT function to count.csv rows?
Database Query
execute code after web query
formulas showing up in empty cells all by themselves
Checking if the sum of a percentage is equal to one
Visible data entries
Creation of a table of n values
setting up excel program for a swimming meet
Runtime error '1004' Cannot change part of a merged cell
Stopping A Macro
Error 91 - Opening Word from Excel
I NEED macro for Combinations , Permutations or Arrangements ??
referencing a checkbox
Formula error
Solver
how do i type something in a cell using vba?
copy Vlookup down
Counting occurences of text string in a text file
Auto Cell Shading
countif across worksheets
I have a created a variable with a loop, how do I find average ofvariable most efficiently?
I have a created a variable with a loop, how do I find average ofvariable most efficiently?
Selective paste
Track tabs
ActiveSheet.name not returning Sheet1, Sheet2
Hopefully easy macro question
Embed Word File
Hopefully easy macro question
Attention-flashing when a value is exceeded
List all e-mail addresses in Contacts in excel
Variable Command for VBA in Excel
Control of workbook
Programmatically inserting a page break
Searching Column and deleting cells -VBA
Send E-Mail with a hyperlink in it - Question
Find Method vs. For...Next Loop
Sending Email notification when a spreadsheet is updated?
Retain decimal places in a concatenate function
Quitting Macro
Help with code please
EXCEL SAYS DISK IS FULL WHEN ITS NOT
Yet more filters...
Selecting the next blank cell.
Count number of times entries are made in a cell
ListDataFormat property been deprercated?
Changing Marco
Changing Marco
Copy Row to Another Sheet Based on Cell Value
Date formula to return two digit year
Inserting Drop down on sheet - Array needed
auto adjusting cell size and row height
consolidating workbooks into one workbook
Insert long formula
Excel Add-on Development.
Merging Blank Cells
Cant connect to Access database from excel using vba
Skipping Blanks
Programmatically determining if workbook is opened as Read Only
**Pop-up message prompting for user information**
Change columns after certain point
Programming help needed
Copy sheet in a workbook
Opening file question
Sum and Counta function in Listbox for UserForm
VBA count number of cells
VBA Programming with Checkbox
List of function descriptions and field descriptions
Sorting makro
e-mail excel files from a folder
Open Excel locked file using password without office installed
Data Validation Question
Anti-Virus Program Deleted VBA codes from Personal.xls
Perplexing string manipulation problem
Opposite of a marco
Sentence Capitalization - Revisited
Custom number format
PublishObjects.Add in reverse order
Editing Marco
how to do these things in Excel with and without VBA?
Call a UserForm based on ComboBox selection
modification of Per Jessen Macro- paste/overwrite
Excel Pop-up Question
AutoFilter or something like it
Hover Text that carry over into Web Format
Updating a Excel calendar based on range values
checking if a sheet exists
VBA Function Not Recognized or Execution Issue
Lookup Table and output three or more entries
Copying worksheets into separate workbook and emailing separately.
How to force close the worksheet without having Excel prompt?
Error Messages: 'Text String is Too Long...'; 'Can't Record Macro'
running an excel program
Code for inserting Comment field with spreadsheet protection
Breakdown grouping
Disable the redX in a form
Delete rows if range is null and not in color...
Excel Screen refresh while VBA is running
.Sendmail to Multiple Internal Addresses
Never used a button before
Column width reset
Column values
Send Mail to multiple recipients in same network....
Look for Sheet name, and then skip...
Makes Changes to Closed Excel File on LAN
adjust .Sendmail for mutiple recipients on internal email network
Source of Data Files?
Excel (not spreadsheet) Screen refresh while VBA is running
Macro to retrieve stock quotes in Excel 2007
Drop Down List Showing Two Cells Info
checking numbers in VBA
Create automated Supplier Scorecard Report from Excel
Hide Autoshape based on Cell Value
calculating difference between date/time fields
Font size and color change for selected cell only
Rebuilding a corrupted workbook
Refedit-automation error
Filling in the blanks methods?
Session Times
In my Excel "active application add-ins" not properly enable
String Functions
Loop Do Until question
VBA Function to Increase the Selected Cell Font.
Copying an unspecified column range
Copying Entries Help
Job survey
The Differences between running a Shell in Excel 2003 and Excel 20
The Differences in the Shell Command in Excel 2003 and 2007
manipulating results of autofilter in vba
how do i call an Outlook Procedures in Excell Macro
Application.EnvelopeVisible=False problem
Page number within a worksheet
strange VBA behavior with named ranges
Grey screen issue - HELP
Problem with ActiveWorkbook.EnvelopeVisible
Reformat & Combine Word Tables, Then Import Into Excel
Chart Macro?!! Help Please
Chart Macro?!! Help Please
Sendmail vs different computers
application defined or object defined error
Marco formatting
Excel List Object Field Types
Looping through clumns and switch to rows
Using Ctrl + Copy and Paste across multiple instances of Excel
Design Mode switching is not working
Insert Image in an sheet
Conditional Statements
Workbook_Open does not run for Addin
255 char limit on TextBox
Autosave doesn't work
help with Application.EnvelopeVisible
if then statement help
Error occur while loading Sheet1811111111111111111" Help Please!
goto statement in VBA
if then statement help
Excel List Object Field Types for SharePoint
Extract data to new sheet
Make a shortcut to a file - code
taking characters from last name and first name to create a passwo
Email to a distribution list in Excel - Simple Version Please
ReadOnly
Creating a hyperlink in VBA for an autoshape
Marco
Application.calculate not working
Runtime error 91
Some changes in a Macro ..
delete last line of numbers
Can't delete sheets in Excel
for each c in range.. how set counter "minus 1"?
Why does Sheet.Range("A1").Select not work!!!
Moving entire column
Deleting Macros in Personal XLSB file
Public Sub For UserForm TextBoxes & Named Ranges
Almost there with procedure error
I hope someone can help me with a formula
Protection So Workbook Can't Be Opened
Manual Calculation
putting info from one file into another using vba
save file with macro - web folder
Check Validation via Excel VBA code.
Getting result from a Pivot Table - Question
Process of records
Function is Excel 2007
comparing rows of two workbooks
Fill Down VBA help please
Open Calculator in Office 2008 by vba
Programmatically retrieving constants
Enable users to edit charts on a protected worksheet
Summing up subtotals according to conditions
vba custom function sum highest consecutive numbers in range excel
adding code in runtime
selection.sort process increase file size by 4.5mb
Saving File
Trace errant formula to stop annoying message
clear rows and insert records from recordset on refresh
User-defined function to give blank cell?
RE: COUNTIF / AND functions
Need Help
Initilizing the New DropDown feature
clear rows and insert records from recordset on refresh
InsertLines Syntax
Custom toolbar adding and deleting
Print format
Hiding two columns
Conditional Format and auto filter
Help needed: Getting all sheet setup data from one workbook toanother workbook
Macro to protect and unprotect all sheets of the current workbook
Macro to test sheet and workbook protect and unprotect status.
Window Trigger Event.
What is wrong with this range???
How do i save a image to the same folder my .xls file is located?
protecting and unprotecting more than 1 worksheets
cpu saving..
Protecting and Unprotecting more than 1 worksheets
opening an excel file from a website using vba
Calling a subroutine with a command button
Insert page number into cell
Importing text file without end-of-line delimiter?
"=" in text file formatting messes with my code loop- more elegant (and faster) solution?
Setting Criteria in VBA
Opening an XLA and then forgetting about it?
VBA SharePoint List Field Type assignments
Combine Custom Function Results
Solver and 64 bit
Copy Sync with Shell
Always accept my changes
matching
Moving the Mouse...
searching in visual basic
sequencing numbers
Deleting duplicate rows when creating a CSV automatically
older version and newer version of excel
Finding Workbook name - HELP
Transposing based on cell value
Line numbering in code
Strange character pops up in my spreadsheet
e-mail
AddIn: IDTExtensibility::BeginShutdown hiding GUI elements too lat
Run Every 15 mins
Grabbing string values from the end of a string of an unknown length
changing views from outlok to excel VB Help
Update multiple pivot tables
Accept EULA ?
Problem with macro in Excel 2007
How to change the text color using formulae?
Excel 2003 - Shapes
Workbook_open Event
Event triggered in Excel's cell by DDE
re arranging data in a worksheet
Sun a macro when a cell is calculated
What are the events get fired when Excel gets loaded with all shee
excel combobox
How to stop UDF in Original ref'ng copied range
Link: Unable to read file
Set row number for Date function in while loop?
Show Last Record in the Listbox when userform Loads.
How to show Last Record in ListBox when loaded.
Comparison Macro + In string text highlighting
Calculating Hours from Textbox Times
Searcing for an Excel event.
I don't know how to write a macro that would update the workbook
Combobox.DropDown not working
Why Excel 2003 VBA program not working in Excel 2007?
Adding a Leter to a Numerical Value on Exit
Little help with "Number stored as Text"
Sentence Capitalizatio
Error: DISP_E_TYPEMISMATCH while interop.excel
HTML INTO EXCEL
How to get variable from a formula
how to display error message?
write a macro to show the edit.find dialog box in excel
unloading XLL files in Excel
do until loop
Changing text to formula in a range of cells
A workbook of macros which runs on external workbooks.
file naming during auto-saveas
Move columns by selecting the day of the week
commission
page number display
Hide Blank rows from ListBox1
Excel Pre-2007 Menus Question
Activate macro in another book
Personal.xls Issues in Excel 2007
special sort option
Can't find project or library
formulas
inserting rows into worksheets
Run a macro from one excel file to another excel file
VB Msgbox result
Passing variables between excel files
Print separate PDF File for each group
Activating mozilla firefox and entering an address
Select....Case macro in Excel 2007
Splash Screen / userform
Print area multiple sheets
Automatically update data validation list
Changing the font size and color in a message box
need some array help
Golf match Leader board spreadsheet for recording up 200 players
out of memory error
Protect the structure of the workbook
Auto-formatting Time with a Query Table
VB Syntax to close Excel workbook not saving changes
Error Upon Opening Excel
Get cell value from other workbook
Difficulty with macro in excel 2007.
Cannot remove password from file
get the sum of the value by filtering 3 columns
Slow VBA code?
Worksheet range copy
VBA for pivot tables
Set Focus On ComboBox
prevet users to view and modify MS query
Data concantating
Visual Basic Applications - Help Files
For Each Next... what's wrong with my code???
parsing Html page
Date Question
Positioning datalabels
excel macro with word
Calculation-problem
LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS
Displayed caption font increases on each click
Comparing multiple rows of data
Modifying code
HELP=> Problems Copying WorkBook Sheets
BIFF / Office 2007 Question
HLOOKUP Can't Search by Lookup Value
HLOOKUP Can't Search by Lookup Value
question on hiding rows
Column password protection
DATE ALARM
How could I make the contents of a Cell "Flash" like a warning.