Excel Programming [Archive] - Page 7

loop VBA request
calculate number of days formula
Using autofilter in VBA
slection change to make the selection go down 1 cell
selection change macro to go down 1 cell
Graphing a bounded region with a twist?
protect macro from a different users access
Code in a macro to branch to another macro?
how to brake a excel sheet passward
Make code aware of the workbook file name
Floating Text Box in Excel 2K3/2K7
Select the UNIQUE vendors name
Protection Macro Causes All Workbooks to Be Locked
Extracting First Name from cell with first name and last name
Ideas for an alternate (faster) approach to sumproduct?
Open VBA Editor?
2007 Sharepoint XMLMap
combo box
hidden character in Excel
Need a code
If cell contatin string like .... copy in Offset mode
RowSource
Remove unnecessary rows
Auto Fill Cells
Auto Fill
Excel Macro Problem
Formula to format selective part in a text
Classification
find format syntax
Deactivate macros but reactivate again once another macro is run
Start of macro via desktop icon no longer work
PivotTable count unique
How pass credentials to Access from Excel (for onward use)
find range question
Formulas In Cell Comments
Hiding a dropdown menu
NetDDE
Unhide rows in an Excel Macro
Conditional formatting?
EXcel Chart Size Probelm with Printer - Please Help
Move all except latest to another folder
Stop duplicate record
How to hibernate Windows XP at the end of macro?
Hyperlink to Multiple Documents
Macro buttons
Using a List Box to filter another List Box
Hold shift to stop Auto_Open() not working in 2007
Sorting one worksheet from another worksheet
disable pageup and pagedown
Form and tabbing
setting more than one filter
date data type is not a date??
Listbox ?
Merge Curves in Excel Graph from VB.NET
Retrieve Formula Result when Saving
Unexplained change in variable
how do i change tick marks of excel graph from vb.net
UDF XLA and SQL queries
Excel development tools?
Verify Input
Create a small table from a large table by skipping empty columns
Finding new records in subsequent reports (XL07)
Updating Share Point list from within Excel
deleting unwanted columns in multiple worksheets
.addline error duplicate name
Help with loop-I'm stuck
Excel Save problem from C# application
Excel object model reference no longer available?
Insert comment into cell
Inserting the values of a formula using vb
Programmatically Adding a Worksheet_Change Event Procedure to a Pr
Change to different active printers on different PC's
How do I retain formatting?
multiple crieria searches
email sending to a group name error
Variable Range Sort
Using VBA coding to count color Occurrences
macro to apply only to even number rows and NonBlank cells
userform problems with copy/paste and drop-downs
restrict textbox on userform to mm/yyyy
VBA Pivot Table Change Criteria - Help?!
Excel 07 - doc insp says there's a hidden worksheet and there isn'
From ListBox selection >labels on userform to show sheet cell valu
Keep text box visible
Exclude one folder in a filesearch
Opening .CSV file
Macro to copy and paste all rows of data in between two words
Macro correction needed
Excel 2010
VBA: Insert Page Breaks code is not working in Excel 2010
Workbook properties code in the xla addin
how to disable print button in preview
Simple... Using FIND, I need to get the row and cell
EnableEvents = False not working ???
Self Closing MsgBox
ActiveWorkbook.Save saves to wrong directory
Complex Copy/Paste...Then Arrange Results in Columns
FormulaR1C1 using variables
Word table to excel
Highest Value from Excel Formula
Pairwise comparison using excel
initialize userform code not working first time
Best way to package workbook and UDFs
Need Help With the SUMPRODUCT Formula !!!!!!!!!!!!!!!!!!
Needed Macro and Function Help
Excel Convert text to Number
Deleting columns if value of cell is not matching
RE: VLOOKUP related question
Add an asteric and let user input a number
DSOFile.dll error - The document is not an OLE file
Recommendations
Link error/Warning using macro in files converted to Excel 2007 (.
Sub menu
Put a single quotation mark in front of numbers in selected cells
Borders to every 8-th row
Sheet Cleanup Help Please
Macro to change column width and active window zoom as columns areselected
Consolidating Unequal Lists
How to write to file the contents of a generic array/collection
VBA Editor Menu
How to find default property for particular object.
Faxing from Excel?!
Opeing PDF's withing a MAcro I have written
Match formula to match values in multiple columns
Error
Warning off by deleting a sheet
how to change a figure into word formate in below the column of e.
find by concatenation of cells
Average various variable ranges
How to detect merged cells with C#
Error message : You must select a shape
save a particular column in notepad
Macros missing
Run Time Error '1004' Application or Onject-defined
Help with code
VBA: How to match two sets?
Count previous 30 cells two sheets
Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
Search and Replace, or Add New Row
excel extract data from one sheet to another
autoscale stock chart
How do I make a golf handicapping form in Excel?
AdvancedFilter syntax
Object Browser
Adding code
Macro Order Rank
How do I apply State O Maine 5% Sales Tax schedule to $ amounts.
Find and loop help-multiple columns
Using VBA to create PDF - setting paper size
Substitute c. for something else
input box prompt
inputbox prompt
Solver in vba
Converting a number (17 characters) to text (Scientific Notation)
Paste Name Questions
displaying intermediate results from a function procedure
Progress indicator help wanted
Export from EXcel to jpg with 2007
Convert Function to Sub
Charting the Sum of Two, or More, Series of Data
Need help with Trim function
Deleting Rows
Email Last row to an email address in the last active cell
disable macro/code after date & time
Dynamic Name Range using VBA
Copy a Textbox to a range on different worksheet
Fill in Date based on E1
Basic VSTO questions
Modify Code to format entire row of data
Controlling execution of a Sub Procedure -Part 2 :(
Macro to ransfer data
Computer that can solve Linear Programming problem?
TimeStamp
Code wont work - help please
Cell.Text different from Cell.Value when dates are concerned...
check Wb is open and copy data to it
word to excel
Pivot tables
How to identify Chart Source data as range?
How to store relative cell values in variables & check it
Change cell color
data splitting
Excel 2007 VBA - looping through scenarios not possible?
variable
How to code macro with condition?
2007 Customui - is it possible to control the visbility of a "grou
How to set macro to run every 15 minutes?
Adding code
Lookup and return
Use cell contents to make formula reference
A seemingly simple problem for VBA
Get user inputs
number of seconds timer
macro stopping
such next free rows
Controlling execution of a Sub Procedure
calls to extract data from an open database
Trimming leading character from string and replace underscore withdashes
How can I overwrite the last line data in text or csv file from VB
Sheet name changing dilemma
Specialized Spreadsheet
Active cell jumps when conditions are met on a single row but I needan expanded macro that will do the same on multiple rows
What wrong with the coding?
copy rows in range if data in first cell
Change 2007 excel Autofilter back to 2003?
How can I convolve 2 sets of data in Excel?
Deleting rows when cell has "#DIV/0!" error
disable clipboard alerts
Extracting date file modified from a text file.
Format sheet based on column contents
Code help
Accounting Problem. Complex Copy/Paste and Index/Match too.
template task pane opens when work book opens
RegExp not matching what I want
Run stored Query in Access
Progress Bar Internet Connection
Set color for chart serie in excel 2007/2010
macro to filter data based on selected data
slow code with many loopings
Change synthax of workbook-level names in one go
Totally Totally baffled
Save as variable file name
MAC OS Excel 2008 Visual Basic Programming
Knowing is a workbook's VBA project has password or not
Format a PivotTable
Get Month name from Date value in cell
Cut and Paste
Need help with Workbook_BeforeClose event
Compile error
Assign variable value across files
Fraction to decimal
fractions to decimal
Tabbing in excel-use VBA
Macros
"Move to bottom of range"
A formula for subtotals against each category
Worksheet toolbar
Restricting pasting, except for Paste Values
Problem with referencing a hidden column
Arrange code
Reference is not valid
open word file
Variable counting of rows
Sheet delete event
Excel query insert
Finding Next Empty Cell in a Range
To enter data in columns in required order in some special way and toensure this
.insertlines automation error excel crash
RE: excel 07 Dynamic copy certain cells if criteria is met onto next s
number consequetively
Special Characters
Use of Cell Values Instead of Hard Coding
Does Excel 2003 or 2007 have a Report Manager Add In
page number in word 2007
Sort on Tab Change
Excel 2007 ribbon issue when in cell edit mode
Excel Instances and macros
Pivot table has source data has exceeded 65536 records type misma
Missing References
Clipboard
Save as crashes Excel - sometimes
create range name in the active cell
Filtering by three criteria including top ten value
Re: Help needed editing a script
Custom button image not loading on custom ribbon
Create a new folderand name it the previous month
Re: Selecting a point on a chart in Excel 2007 on Windows 7
how to make macro work even a sheet is hidden.
Re: Help needed editing a script
Run-time error '380' Invalid property value.
Re: Clear all including objects without deleting sheets
wildcard in filenames in macro
Re: Automatically selecting active chart
conditional prevention of check mark in a cell
Re: Automatically selecting active chart
RE: Automated Copy Paste
Can VBA modify Task Schedular tasks in XP
Button image not loading on Custom Ribbon
Re: VBA to superscript a part of a cell
Search and replace problem
Sum of retuned valus as digits
grouping
Listbox Problem
Re: Matching in VBA
Save Macro with date in name
Re: Selecting a point on a chart in Excel 2007 on Windows 7
dynamically referencing ranges with variables
conditional copy of column to another column of same worksheet
Execute a variable as an insertion into a VBA code line
RE: Filter with criteria!
Re: Why CreateObject("vbscript.regexp") doesn't work?
Re: Code to adjust column width
Re: Code to adjust column width
Re: VBA to superscript a part of a cell
Re: VBA to superscript a part of a cell
Re: How do I test whether a string is a valid cell reference?
Linking Page Fields for multiple pivot tables
Re: Sub, Private Sub, Public Sub
Help inserting an image
loop for macro
Re: VBA to superscript a part of a cell
Change code with code?
Shapes and protection xl2000/2003
Array Issues… Please help me….
Re: VBA to superscript a part of a cell
Re: Why CreateObject("vbscript.regexp") doesn't work?
Advanced Filtering top values
Repeating data when data matches
Copy and Paste using VBA.
Sorting or summing data column into correct rows
Using Cell.Replace
Formula-Find Duplicates
Re: Clear all including objects without deleting sheets
Re: Clear all including objects without deleting sheets
Re: Replace code module in distributed app?
Re: Text running
RE: Text running
RE: Runtime error 1004 write data to a cell
RE: Runtime error 1004 write data to a cell
Suppress Worksheet_SelectionChange conditionally
modifying the Userform_Initialize event handler
Check button
Avoid protected cell warning on BeforeDoubleClick WS event
Automatic message
a macro to copy only 2 lines w/i a cell separated by 4 line breaks
thiscell
Refresh Listbox
Excel 2007-Macros
Copy row to worksheet IF
Fill in Blanks
How do you code to get SQL Server data from ODBC Connection?
Rearrange sheet data
Function Declarations !!!!!!!!!!!!!!!!!!!!!!
Feach data according to cell value
auto fill internet explorer
Chart error: plotting series data XY scatter plot
ScrollRow
If specific cell is not empty, copy (or enter) formulas and format
Turning off Whole Word selection in Excel 2007
Turning off whole word selection in Excel 2007
Selecting a Range of Columns for Variable Rows
GetSystemMetrics32(n) Question
lookup list
Help with combining 2 seperate Worksheet Change Event scripts
Workbooks.Open with a network path
Active.Paste Error
Macro to Pivot data in each sheet within a workbook
copy rows with values - not formulas
Passing Criteria to a Pivot Table from combo boxes
Slow Code
Addins with isaddin property to false in excel 2007
Dynamic view of data based on cell content
Fix the size of form controls in a worksheet
Disabling copy/cut/paste for shapes
Working with a worksheet that is not the active worksheet
How to write a macro to hide an entire row
Countif number between x and y
Get data - Multiple criteria
Hi to Low
Look for names when cursor is there..
Cells range into an array, then into msgbox
Excel 2007 Default User Form
need help on refining find record macro
Create menu with Workbook_open : error
HELP: extract certain characters from text string
Three questions about fields in worksheets
Data Entry Form questions
How to Run a Macro From WB1 in WB2 Against WB2
Adding ws information to cell in new wb & saving with ws name
Array computation in vba
DELETE A RANGE NAME IF EXISTS
If conditions for Data Entry Form
Finding Dups in one column then delete leaving one
EXCEL Macro problem
Excel 2007 - Dynamic sheet naming
using write #1 to create a batch file
Excel 2007 dynamic chart range correction
Excel 2007 dynamic chart range
Select not actualy selecting the cell
Help with Formatting Spread Sheet
2-----------------------------------------------------------------
Apply ADDRESS formula in VB
League fixtures setup
Copy sheets to new workbook - subscript error
Code to change a named range
Code to delete rows with varying amounts of data
Find a Item & Copy the Data
Locale issue with union operator string (,)
update user name in excel on open
Suppressing a screen
Copy range from one sheet to another cell by cell
Set destination sheet based on variable and paste data assistance
Average a dynamic Range
update stock prices
Get External Data from Web
Advanced VBA Conditional Formatting & Field Population
How to copy one column values to another column based on conditionthat row2 contain todays date
Generate random numbers - Using initial seed
lookup help
Populate a comboxbox and Listbox in a excel userform with an sql table data
Toggling xlVeryHidden
Copy Cell from one sheet to specific Col value
dynamic sort
Search and filter mutiple vaules
button on macro recorder doesn't toggle
Using xlsm worksheets on different computers
Close a workbook
Insert Image with name and filepath
If/Elseif AutoFilter Macro
wininet & FTP to Mainframe (zOS)
Fill array with Values
Formula to copy cell in Excel from on file to another
Formatting Sheet
Syntax got me again
class modules versus modules
RowSource for my ListBox
Please Help: Append New text to Old text already present in databa
Start/End Cells in a Range
Textbox object event - Help please
Please guide
Max length of variable name?
help needed
Message box shadow
Excel Security
Variable Range with a loop needed
Type Mismatch
folder picker
Get 2 Lowest Numbers from 4 Cells?
Formula from closed workbook?
Total columns Based on another cells value
On Error Goto Function
save as version 2003 problem
Ignoring hidden rows in PERCENTILE function
Formatting from VBE
Automatically Update a Pivot Table Field Used as Column / Row
? offset('activecell',,-2,1,1) in Named Formula ?
Totalling data from different sheets.
Create tables on multiple sheets from list
Function or formula to show currently active workbook name in cell
Pivot Table variable sorce data
Code to Implement Required Cells Not Working
If the cell is empty, copy the value from a specific cell.
How to open a specific worksheet via code from workbook_open
Can't break out of code help!
$29.00 FAKE ID FAKE IDENTIFICATION CARDS, FAKE ID'S & NOVELTY IDCARDS
Variant Array Copy, Array row contains Object
Error than Aborted Excel
Sort issue Sort Of
Sort issue Sort Of
Working in Excel 2003 but not Excel 2007. Can not protect sheet.
sheet2 = sheet1
Compile error. Need Help with this UDF !!!!!!!!!!!!!!!
using Name or other method to add cell values through workbook
Map characters to their relative positions in a cell
Connection with a serial interface
Select Case
Open event failing
Visualization problem .xls file with office 2007
loop through every other and 3rd cell in range
IP address to Hostname in Excel
Managing Macros
How do I change a mouse icon !!!!!!!!!!
ADO performance
Consolidate Item, months and volume
Change Range in macro
JavaScript & WorkBook.PivotCaches
Pivottable reference...
Random selection
Help Designing an Hyperlink process in Excel
Pivot Tables - Multiple Ranges
EXCLUDING DUPES IN STRING ARRAY !!!!
Using Access form to assign values of variables in an Excel VBAprogram
How to add "'" into string?
Populating combox with worksheet names
Consolidate, Lookup and Sum from dates to months
cannot insert object error
Strange problem
Excel macro
Need to Keeping Same Display Value on 2 Workbooks
How to import the links with method="POST" within form?
Multiple User Defined Categories in Insert Function Form
Automation Error. What is this?
Data Validation enter values with VBA
Deleting veryHidden worksheets
Help Needed Fixing Code !!!!!!!!!!
Resize query
Chart Rendering incorrectly in newer release of MSO 2007 12.0.6514
How to select combobx value with vba?
Delete CDO page heading and following matter when printing an emaildocument; to print the document only
weird and spontaneous combobox resizing
Deleting Lines
How to open a specific worksheet via code from workbook_open
Conditional Format Formula to color row based on text
Formula + a variable
Using Object & Worksheet names as variables
SOS:Number of Working days per week/month
Macro to Update links on a network
Problems finding a file on a network drive in excel 2007
on error
How do I insert a radio button using Excel 2007?
Rounding a formula in code
the default worksheet
are there any VBA consultants left ? - will pay for help
'Excel reclaculates formulas' message
Visual Basic in a shared workbook
Updating Pivot Tables using a List
Selecting Multiple columns with multiple rows
GetTempFolder and GetTempFile ?
Dialogsheet Checkbox to Select All Checkboxes
Suppressing Values in Autofilter Criteria List
offset method problem
VBA Opening Access Table from Excel - Permission Error
Message box warns for duplicate use of named ranges when copying s
User Form instead of message box to collect data
Time Out a MsgBox
Function VBA - 3 variables
Extarct limited Excel data from D drive to another excel file
DisplyaAlerts Problem
Move Form to edge of chart window
Use specialcells to identify specific values
VBA to create new data help please
Hide button based on a cell value
Dim As Range Object
Extracting date from cell
Intersect & Hyperlink
How do Excel define the application area?
BeforePrint & PrintPreview Hangs
How to break the FOR loop?
Code to make a Spinner button work with Filters on a Pivot Table
auto run a macro
change colors in a range of excel cells based on another range of cells
How to reverse order on FOR loop?
Excel spreadsheet for weight and balance calc for Cessna 182
Can I run a file with a known extension from Excel VBA
Insert functions diabled in ribbon Excel 2007 Windows 7 Pro
Time Delayed Response to MsgBox
Export from xlsx to csv preserving non-german characters
How do I create an average collum in my spreadsheet?
Syntax help
Macro speed
VLookup in VBA Help Needed
Conditional formating using VBA
A list and chart from two pivot tables
Find files
Looping through Worksheets_(excluding one)
Time Spent
VLOOKUP with VB
Maintaining a form open when selecting a cell
String manipulation in 2007
Screen coordinates of ActiveWindow
Save Text to File
runtime error 91
Point to My Docs in Win7/XP, Excel 03/07
Public Variables
Run make table query from Excel with Access closed
Option Button in form controls
How to delete sheets using macro?
trying to find the previous thursday before running a macro
copy a range from active cell
Create an auto chart using macro
Open Hyperlink in secondary browser ..?
Erroneous Macro Recording
How to export specific emails to excel?
Sendkeys
cell formula
Values of the last date
Send Email(s) by selecting users from user form
How to import a list of links into Excel?
nested find/find next
Circular Reference when opening program
VBA Macro to open excel file and replace VBA module with update
Crane model in Excel
APR calculation for Mortgages with a balloon payment.
filling a form in excel
UPC Numbers
Referencing objects inside of a loop
reset the value of a spin button
Resize a Table using VBA
reading and replacing just the first line of a txt or csv file XL2
Open picture manager and print from excel
make message box appear when cell is clicked?
Check user credentials
If date more than
cancel a combobox change
Can't delete file?!!?
SELECT PART OF A TEXT IN A CELL
Countif using symbols
Data Validation Help Needed urgently !!!!!!!!!!!
Embed pictures and sound that show when needed
2 finds/findnext in nested loops
Error can't Find File
Search and replace multiple values
Help on Custom Task Pane in Excel 2007 using Managed code...
Saving information to PERSONAL.XLS
Email selected sheets
Protecting a sheet partly in Excel 2003
Help with search macro not finding
Median in Excel 2007 pivot-tables
Toolbars in Excel 2007
Data moving 3
SUMIFS in Programming
Copy range C5:Lastrow and paste to two different worksheets
Subtotals for a variable number of rows
Need a little help coping a sheet from one workbook to another.
simple macro to compare lists
Controls collapsed with outline
To prevent a user from deleting and renaming a sheet in a workbook
Macro to copy subtotaled data
PADDING STRINGS !!!!!
I need help with this.
Insert Picture using Macro
Select list box entries in multiple rows?
resequence my worksheets
Highlight Rows
Cut and paste to new sheet
ODBC
Disable PDF add-in
if statement
Excel and MS Project
UDF to Calculate YTM
Conditional Formating (If statements)
multiple processors
Macro Help - Insert row/copy based on criteria
Multiple replace in Excel - macro ?
Easy way to add my custom button on Excel 2010 quick access toolbar?
Autocomplete date for cell based on other cell values
Can I loop this?
Table Name
Testing object value
RE: vlookup loop help
Macro to Find Column
move data from one spreadsheet to another and repeat
Formula Question
Logging an update
Copy some of selected columns to master sheet
Compare two spreadsheets and eliminate duplicates
prevent a user from adding any sheet in a workbook
Table Name
PivotTable 2003 Code is not working
Macro which delets in a cell all characters after comma
delete row off 5 worksheets containing specific value
select a specific ActiveCell by VBA
Conditional Formatting
PivotTable 2003
Change Default Hyperlink Browser..?
Copypicture from Excel to PowerPoint
Extract data from Oracle
selecting all worksheets to the right of specified worksheet
adjust cell width change font.
Pivot Table Filtering - Macro
for loops
copy paste in correct data
Can excel objects be defined as global variables
Tabs on excel worksheets
Refreshing data
Sum Column in Array
Insert formula even cells with data below it
Non standard characters
OleObject not copied properly
Formula to find text and count it within an entire workbook
sort range
Moving from Excel 03 to 07, need help with customizing
IF for inverting true/false
Run macro on selected sheets
named range in macro call
COM add-ins
How to load specific range of html into Excel?
datetimepicker finding the hours between two dates
Codes needed to update wages
Adv Filter fails in macro, works manually
Make a file save and close itself based on the value of a cell
printing a print area to a non default printer
How to use a variable as an argument in .FliiDown
Hiding Rows Using IF Statement
RE: Check Work Books
hisind rows with an if statement
trying to highlight records with at least 3 same value
How to Combine Columns of Text - sounds easy
Excel 2007 Custom ShortCut Keys
Chart.Name lives forever?
Dynamic Table Problem
Macro Message Box
Find a string with a text paragraph
method 'run' of object '_application' failed
Joel - Data Consolidate Limitation
Like a pivot table
like a Pivot Table
chr$
Contract / P&L management tool sought - simple is best
Removing artifacts from a spreadsheet with VBA
Code running slowly
Different password for different worksheet " Help !"
Selecting Multiple Controls
Help Modifying Hyperlink Macro
find sheet
Pivot Table: Get "customized" detail
button name scope and Caption
Random Running of a Script?
if or not if ???
Easy one for you...
Multipage userform
Application.UserName
How to using Address in selected Range
Vlookup
Cdbl and Cstr with a "Type Mismatch" Error
Combo box in user form
Split Alpha/number
Excel UDF implicit range argument
Excel file is locked by User X
series objects; finding specific ones in the collection
MSProject Template failing
Sort by range
Remove h
Smaller Procedures in case procedure
Auto format sheet
RE: Personalizing a macro based on user input
Add New Events to Existing Collection of Events
Getting Rid of Hyperlinks and Restoring them to a double
Entering (NOW) information on click
Bin Packing Problem (1DBPP)
Type mismatch
Unique problem
Workbook to Workbook Paste Special
To insert a picture in a form
Message to RustyOnVBA
How To Exit Macro Without Debug Prompting
Is there anyway of using a calendar similar to the VB version in e
what is the code to close a file for a macro
delete addin in Excel 2007
make dropdown list greater than 8 rows
Printing
Control Z-Order of drop lines in an Excel 2007 chart?
Validation on InputBox()
check if value exists in pivot table
Look up range and return value
subtract times
Convert UTF-16 Unicode to UTF-8 Unicode?
Passing sheet (using codename) to separate sub as optional paramet
Search & Replace
Program a macro to print
named range in macro call
Hovering over an object
Save a date as a variable and run/convert formula against the vari
Copy and paste from WB to another WB
Can someone help me?
XML and SharePoint
Set Chart Legend in VBA
VBA SQL - variable Source Data...
Cut not Copy Appended Data
Strange probem with capitalization of object
duplicating data
Search Directories/SubDirectories and Display in ListBox or MsgBox
Hiding and unhiding rows with if statement macro
Changing Name
Sorting the data in descending order
Excel 2007 Rect type problem
Stop users leaving cells blank
Function to Query CSV file
Issue skiping characters by Regular Expressions searching Word
setting FormulaArray slows down my code
JW Progress Bar after DoubleClick event
Find date
Copy-Pasting row into exact same row on specific other worksheets
Button to take the user in a different place on the same sheet
mailto syntax for text to display
How to re-fresh the import links if it fails?
how to select a column from a cell after find
Alpha Numeric’s bunch together
Macro for changing number of rows
Need To Protect "Tab code"
Loading Data into MultiPage UserForm
Need Syntax for "AND" to Evaluate 2 Cells
Move cells down to match cells
Separating parts of a string in VBA
OnError not trapping subsequent errors?
RE: using cell offsets
Move cells down to match cells
Move cells down to match cells
Move cells down to match cells
Move to match cells
Move to match cells
Move to match cells
Move to match cells
Move to match cells
Move to match cells
Move to match cells
Move to match cells
Move to match cells
Move to match cells
Moving cells to row with matching data
Check and clear Multiple check boxes
How to scrape web page data in VBA
Keystroke macro results . . .
Filling in columns counting by Hex
using Forms and VBA within Excel
VBA Input box (or MsgBox) with pull down or choices
search column for duplicate value during data entry
Looking for a golf league scheduling spread sheet for 18 teams of
SOS-Need to calculate number of working hours per each week of mon
Outlining based on level numbers in most left column
Hide/unhide a button based on selection in a combobox
Preserve XML whitespace in Excel 2003
error -1.#IND
Is possible to upload file to OfficeLive via Code (VBA)
Problem opening an Excel file from code
How to print all columns from a multi column listbox?
Tracking New Tabs in Excel
Paste copied data to specified sheet based on range - variable iss
RE: Autofill of Cell based on contents in non adjacent cell
Copy to specified sheet, values only
Adding Outlook signature to email created by macro
Make a PDF file from Excel Data
RE: Lookup and User form
RE: Edit current row in user form
Measure on the date different
Convert text invoice into a table- please help!
Need to break up my SheetSelectionChange routine
VBA macro guru help needed!
Close msgbox after making selection
How Do I?
Open a workbook and get data from it
simple code not working
Find/Find all
delete rows with header, excluding 1st row
Command button naming issue
RE: open from sharepoint
Stop fill in the blanks (down) at specific row
Fiscal Year Week Number Calculation with a twist....
RE: Error trap X 2
Get cell value
To determine the data type of the selection range
To determine if selection range contains empty rows
How do l get the sheet name from the sheet code name?
RE: Arrow color with Autofilter (with Excel)
RE: Automatic Excel data selection and transfer/copy to another wo
RE: Populate an array with file names
RE: delete cells containing zero after a cell containing a value
Prevent changing a fraction
How reliable is this site!
Find Text String
REARRANGE STRINGS IN ARRAY !!!!
RE: extract data from .ora file
RE: Object not set
Form check box
Like, with worksheet- UDF?
determine how excel was opened
Help with Subtotal Function
RE: Object not set
Picture scroll with active cell
How to ID calling worksheet if it isn't the active sheet?
Excel VBA Project Has Protection?
Case not recognized in Select Case
Image Control
Selecting a point on a chart in Excel 2007 on Windows 7
File name being changed
Error when no records meet criteria - repost
Should be easy...what's missing?
VB help with ExecuteExcel4Macro
how to make data together by VBA
DoubleClick to return SeriesIndex & PointIndex
For each
Select 'used range' except header row in excel 2007
Disable share workbook option in VBA
Chart Sheet BeforeDoubleClick
Copy a particular column of all the Worksheets in a folder in a newworksheet
Alternative way to show 12 tabs??
Opening file by partial name in same folder as master file
DYNAMIC RANGE FOR PIVOT TABLE
Check Workbook name currently opens is correctly
Another 'Copy To The Next Available Row' Question
Vista
Using WorksheetFunction.Find in VBA
Delete OLEObject from Row or Cell
run report on company intranet and import to excel
Help making this macro dynamic :)
invalid use of property message
"Invalid use of Property" message
building a range for SetSourceData
Code to select data
How does Personal Macro Workbook become personal.xls
Repeat a marco with number of times or loop until End
VBA Chart Size Accuracy
Excel message box
INSERT FILEDATE INTO CELL COMMENT
Matching strings with a pattern
FASTER USE OF THE REPLACE() FUNCTION !!!!!
Prevent clicking on a cell
Adjusting time data to nearest ten minute block
Copy Picture problems
macro to run when I hide or unhide rows in a group
Collect value
Updatig the Next Consecutive Empty Cell in a Range
Macro
DoneEx XCell Compiler - comments on VBA protection?
What is the Limit of Text Boxes & Labels a User Form can have?
Showing argument descriptions as an XLL worksheet function is type
simple little loop
How to skip the confirmation on updating link?
select case simplification request
Collect value
ChDrive and ChPath to a network drive
use variable value in a range reference?
Strange behaviour
Need help with simple macros for double checking manual plugs
BUY FAKE ID,BUY FAKE PASSPORTS,BUY FAKE DRIVERS LICENSE
BUY FAKE PASSPORTS,BUY FAKE ID,BUY FAKE DRIVERS LICENSE
Complex If/Or/And formula
Excel VBA recommendations
help w/deleting rows if 2 conditions & calling macro from other bo
Re: How to skip confirmation for macro and update all links?
Redirecting ALT+1 keystrokes to run routine
How to skip confirmation for macro and update all links?
Loop by Group Within Group
Password entry userform
Reference list
Extracting Data From a Chart
unhiding / hiding sheets
Keep getting "Type mismatch"
Insert, copy, update, delete records through VBA
More efficient code wanted
Another Easy Question
Link checker: checking if a URL exists
Sumproduct error
Move lines from one sheet to another
SaveAs in Excel97-2003 format
In what order do installed AddIns open?
Application or object defined error
VBA Calculation with Variables
Picture Form Help
Maximize Excel?
How to run a macro by opening a file?
What IF statement
CDbl and "Type mismatch"
Sort data from every workbook in a folder into sheets in another?
userform control structure strategy help request
VBA Calculation with Variables
Macro Help - Array
A macro to check if a URL exists
formulas containing constants
Locking all text, combo and check boxes
Filter Table based on Cell Value
copy text and logo from protected, hidden sheet
HELP: Email body transcript deleted when receiving response emails
Very Easy...Right?
Macro help needed
add cells
How to group
Problem with workbook on_open event
How do I open a com port using Excel visual basic
Auto_Open Macro
Re: How to reference shdocvw?
How to reference shdocvw?
Saving workbook with a trusted extenstion VBA issue
how to skip open operation
Copy Filtered Data
How to Loop
Syntax to match sheet by codename
Error values generated in functions
Combine two ranges with different numbers of rows and columns
Go to record end, then one across
Hiding menu options
How can I check a collection (e.g. worksheets) collection to be empty?
Re: Trying to read CustomDocumentProperties of an open 2007 AddIn
Importing text file into Excel 2003 - C# - QueryTables.Add throwsSystem.ArgumentException
Programatically format Axis Values
merge all files in sub dirs
Savecopy and saveas locking up excel
Excel 2007 ADO Connection Error
Protecting macros
Exit Sub from Main Sub
UserForm Text Box to display worksheet cell text
Conditionally populate a data table
Code to update links every 30 seconds
Array To View Specific Sheet(s)
Existing File Not Found
CurrentRegion - Usual Behavior?
How do I capture the last character in a string inside a macro?
DATE MODIFIED
Excel hangs crashes when pasting formulas
Max size of user form?
fill several sheets with data from other workbooks matching criter
fill several sheets with data from other workbooks matching criter
run report on web page, import to excel
IS it possible to get the Visual Basic Form to VBA Excel
Date Stamp
Pivot Table and Protection
Reloading and Editing UserForms in Excel - help!
Dynamic radar chart
Identify last row containing data
ListBox / UserForm interaction
Error when no records meet criteria
Copy numbers from an array, each to it’s own sheet
If statement works here, case doesn't
Trying to read CustomDocumentProperties of an open 2007 AddIn
Combobox display 1 value, access another
Add formula to cell to sum range of cells
Concatenate A1, B1, and C1 into D1
Adding a sheet to a workbook
Copy/Paste Import/Export Data VBA Code
Code to look at range and extract data.