Microsoft Excel Programming [Archive]

Conditional formatting with vba
Pivot table drill down sort
Handling hhmmss time format
Problem with UserForm1.Show
VBA password prompt workaround
how to get the vba code behind an excel sheet
Need warning message before a user changes worksheet
Excel Graphs : Images in X-Axis
create chart with column axis
Retrieve NTFS security groups from network folder
Send mail VBA
Send mail VBA
Exporting data with vba from Excel to an Access 2007 db with password
Re: when sheet is active macro is run
Re: macro for right click
Calculating subtotals
Calculating subtotals
Problems with If function
This could sure help my kids
Hiding a column if a cell has an X
Re: Rename 'VBAProject"
Re: Date reference to another cell
Re: Macro to search a text in a cell and copy the row to another setof cell
VBA Conditional formating for specific text in several columns
Remove data from column
Re: Rename 'VBAProject"
assigning a variable from an image alt text
Re: password for macro
Re: password for macro
Pivot Table Macro with dynamic source data
Excel Template Question...
Chart Title color can't be duplicated (also series color)
Excel macro for general insurance tracking
Check each sheet for Auto-filtering and switch it off
Need help with a simple macro, really lost.
Identifying Machine or Location When a Procedure is Run
Re: How to convert text file into excel using macro vba
Re: How to convert text file into excel using macro vba
Enable Slicer Data Refresh in Locked S/S
Re: hide menu bar
Re: active range to run macro
Re: Separating fields
Re: active range to run macro
Converting macros from Excel 2003 to Excel 2010 - Client Access dialog
FileSystemObject
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names
Only cells with values
Re: active cell to run macro
Re: active cell to run macro
Capture Web Page Source Code
Where are all you MVPs hanging out now??? Pls?
range names
How To Make Pictures Scrol in Text Frame
Re: data labels in excel using vba
Re: data labels in excel using vba
Excel module: Mark records if it contains names out of another list
How to export excel sheet to CSV
How to append data from different sheet and different workbook?
Re: Problems with Activeworkbook.Close
Can't delete sheets
Re: Determine the percentage of a range of cells with a certain value
Re: Separating fields
Re: Copy data from a cell to the next available cell in a range.
Re: Determine the percentage of a range of cells with a certain value
Re: adding vlookup into Macro and table_array is different every week.
Option Button in Excel 2007 and 2010
Print macro using xlDialogPrinterSetup fails to use driver-specific settings
Hidden sheet bleeds through
Excel 2011 Mac - Import Worksheets into a Single File
Ideas?
Conversion from Number to Word!! Aki
Move multiple values in single Cell To Cells of there own?
Scrolling few Pictures at a time in a Frame
forwards/backward compatibility Excel 2003-2007
Re: Create Table with the range of selected cells
Re: Create Table with the range of selected cells
Re: UDF: More than one input type?
Re: select worksheet and run macro
Re: select worksheet and run macro
Re: Create Table with the range of selected cells
Re: UDF: More than one input type?
excel 2003 vs 2007 menu and sheet issues
Re: Create Table with the range of selected cells
Re: Create Table with the range of selected cells
Passing SQLPlus script location using Windows Script Host Object Model
Application.Wait
FIND ALL
Re: Create Table with the range of selected cells
Arrays and Checkboxes
Macro to complete Google search based on a cell?
Shared folder changed path - sometimes S://SharedFolder sometimes T://SharedFolder
Open folder based on cell value
run macro on close
Blank item in listbox, how to remove
Faster way to find and replace?
copy and paste data only to a new file
Formula in other Other Language
Add to Dynamic Named Range
VB.Net ToString Number Format
Re: Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...
Conditional formatting excluding weekends and holidays
Re: Filter ZIP codes into ranges
Addin not allowing thisworkbook.save in before save event
Re: Filter ZIP codes into ranges
Highlight or Mark any values in a column that are duplicates insidethe column
Pivot table code question
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook
Would love to write macro to delete any row that DOESN'T containspecific text..
Sorting columns of data
[Q] For, Next - How to Speed Up
Inserting subtotals very slow
Buttons not always moving deleting rows. Odd behavior
excel spreadsheet functions written in vba
Error: Method 'open' of object 'IXMLHTTPRequest' failed
3 results possible on every day. add up the number of each on each day.
Advance Filter Format
User Defined Function
Copy Matching Numbers To New Cell's
Populating a listbox from an excel column
Aligning related data
how to work with all items in a listbox
How to create a table of multiple combination
=Sumproduct Question
Optimize Slow VBA Code
Sorting Question
Combine Two Different Worksheet_Change codes
New line vs line break
Hiding an Excel file using VBA
Re: Hide/shows raw based on drop down menue
how to export pat_ids to another programme?
Re: Hide/shows raw based on drop down menue
excel 2010 statistical functions
Excel question
initiate a macro
vlookup issue
Managing Cut/Copy & Paste During Program Run
Re: Function for combinations
Re: Function for combinations
Newline character in XML cell reference when creating xlsx from XMLzipped files
Re: Using median if in VBA. Excel. 3 conditions stop running?
Re: Help adding a condition to a print code
Find matches in 2 cols using Collection vs Dictionary
Variable Range, selecting/copying
User defined function
=Trend question
Which Excel event to call when opening a .txt file
Sumproduct Problem
How to bypass password when pasting FROM a protected workbook
'.Copy Destination:=' temporarily freezes multiple instances in Excel 2010
Issue with TextFrame2: Library not found
Delete matching cells
Two digit dates and two digit days
Is it possible to add variables to a pivot datafield name?
Need help with merging Excel worksheets and deleting unwanted columns
Loop & Print
Replacing a hardcoded date
How to pause without being "modal"
Run time error 50290 method 'ontime' of object '_application' failed
Changing mutiple data fields at the same time
Re: Duplicate declaration in scope
Re: Duplicate declaration in scope
[Q] How to create new worksheets based on an array (via named range)
Is it possible to just act on the filtered data
Fade text in a cell, disappeared when we input new text.
Find then highlight in yellow
Re: Data validation trouble
Technique for switching to the VBE
Search function in Excel
Copy sum of two columns from one workbook to one column in another
Filling in some blanks to a data table
Looping through checkboxes
Removing Sequential Numbers
My code need to go on a diet
Get Data set range from closed workbook
Error bar format
Trying to create a mailing list using a combination of data and anaddress list.
Sumproduct with double quoted strings
Reuse old selfcerts (self certificates)?
Transfer selfcerts to new machine?
Extract Records via Userform
List of Direct and Indirect Reports
[Q] How to sort tabs in order of CodeName
setting folders in odc file
Loop has goofy message all of a sudden
Functions not firing!
Re: NFL spreadsheet
Wrong import values from webquerry
Seaching an excel sheet
Duplicate Digits
Re: NFL spreadsheet
Counting rows
Counting rows
Can I send an email too?
move cells up
Copy data - Multiple Word Pages to Excel
manipulate other program using excel macro
Enhancing Explorer Excel Open Icon limitation
Distributed excel apps with add-ins
Break points will be ignored in Excel
MAX and Min value
PivotItem Visible prop
MOVE CELLS DOWN
=TEXT fuction
Retrieve data from encrypted Access
Excel automation fail
Calendar Control for All Office versions - including Office 2010 64 bit
CheckOut/CheckIn from/to SharePoint 2010
Multiple (as in many) regressions
HELP...auto-alphabetizing in excel 2007
Copy specific cells to another tab
End of Quarter Based on Fiscal Year
Replace "A2" with Active cell
row height
ADOBE Connection to open Excel workbook
Closing programs on remote PC - help please
Compare Sheets
Early binding problem
Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse clicked
Copying a range of cells and pasting them by using Transpose function
Find the row for a Hyperlink
toggle between method and source of inputs
Compiling and Late Binding
find newest file in all sub folders
Macro help please
Removing Duplicates from NameBox Table Using VBA
Two-tone color column chart
copy my digital certificates?
Random selection of records based on specifc value
how to automatic adding up 12 rows for one year, and 48 rows for therest of year
Sheet Order _ Numbering
2000 -> 2007: gotchas?
How to Insert Variables into Formula's
how to use stacked line with markers plot to draw point estimationand confidence interval
email from Excel Question for Ron de Bruin (or other really smart people)
use stock plot to draw point estimation with confidence interval
Attendance Tracker
Compiling Error in Earlier Version of Excel
Re: Opening workbooks and stopping the messages
Re: Avoiding cells being included in a chart
function with collection of custom objects as results
Newby, ..Membercode
Re: Tidy VBA Code
Adjust Pivot Table Filter based on a Range
Re: Tidy VBA Code
how to add error bars into bar chart
Form Control versus Active Control? When to use which?
Failure to load icon causes UserForm to minimize to bogus object inworksheet area.
Re: Read .TXT file line by line?
Help with specific textbox entry...
Help: Chart & data
VBA Linest function for polynomial regression on horizontal range
Making .dll files for Excel 2010
Re: Read .TXT file line by line?
Re: Read .TXT file line by line?
Re: Read .TXT file line by line?
Value of True etc
Re: Can this be done with Excel 2007 VBA?
Excel 2007 VBA: Convert laaaaarge number to Hex
Re: Read .TXT file line by line?
Re: Read .TXT file line by line?
Re: Read .TXT file line by line?
Re: Read .TXT file line by line?
use vba to open pdf then save as xml
How to Disable the Insert Worksheet tab at bottom of screen
Button to Save File as PDF
Add-in WITH worksheets??
UserForm - pointing control source to new sheet - long delay
Move cells down
Move cells down
Incrementing IPv6 address
Separating Workbooks
Check a 'Logsheet' for a match, before continuing a sub
cross referencing two worksheets
Don't re-run macro for five seconds...?
creating frame and option buttons programmatically
Is there a way to automtically apply macros in a script
How to apply a macro to all workbooks
Check for file open/closed status
Listbox displaying incorrectly on opening worksheet
formula to filter out blanks
Adding values across files
Variable SUM range
Using IRibbonUI in VBA Excel 2010
Reduce Numbers Down To A Specific Value
Refresh Bloomberg data in an excel file from a script
Can I use a variable contain the name of a sub or function to call it?
Calling a Sub created on the fly
Creating Charts using VBA
Re: search cell
Move cells down
Thanks
search cell
Data in columns
userform exception error 4 textboxes
Tech help
Identify each cell that has dependents
How do I get VBA to make AND print a chart with a square grid
Average If Problem
VBA Code organizer
Duplicate name range error when copying sheet (Excel 2010)
Changing a cell from another cell's formula
Can an Excel 2010 file be shared on the cloud?
How to remove duplication in text string?
Loading pivot table problem
VBA Script useable by like workbooks
How to make rows autofit when cells merge and multi line text inside
Excel 2003 VBA string literal help location
XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet
Find last row and column for 1st page only
Lookup
loop to copy paste
microsoft office web components wizard in office 2010
How to Pause an Excel VBA script without freezing excel
ADODB
Multiple charts in microsoft excel VBA macro
hot to calculate peaks of an "irregular" sine wave
Variable Range Copy...
ADODB CopyFromRecordset problem
Compare font colors
Copy value
Re: "Following Features Cannot be saved" error on LOADING ??
Finding range
Center application window
De-activating Excel 12, Leaving 11 Active?
Re: Is ActiveSheet in ThisWorrkbook?
Re: Is ActiveSheet in ThisWorrkbook?
Script to remove file clutter
Re: Is ActiveSheet in ThisWorrkbook?
Upload files to a Share Point Site.
Can you create a global variable ?
Can you create a global variable ?
Re: Dynamic links to other sheets
Re: Dynamic links to other sheets
problem with finding horizontal page breaks
Change ActivePrinter in a Add-In
Excel 2010. How to copy chart format to all charts in sheet
Re: VB Script not working in Excel 2010
setting one worksheet cell range reference to another worksheet
Checking if a workbook exists
Filll range with "NA" if another cell has certain value
ExecuteMSO on copy
Adding New Sheet, But Carrying Over Previous Sheet's Cell Calls
2 more questions on excel and vba
Cell value on top, inside drawing
How make long string in a cell become text line by line in same cell?
Sorting a string array containing combinations
copy a 2 dimensional array to a range
Re: Adding to Array
Default folder when saving a "Cute" PDF file
Iterating through a ComboBox's values
Tax Form with Merge and Center
VBA Code Writing to Excel Box Name
Is a signed certificate necessary to run macros in a marketed file?
does anyone have any idea how to import this spreadsheet?
MIN in VBA?
Merging 2 sheets.
Changing Cells depending on data entered in other cells
Use userform to select autofilter requirements
Breaking One Row into Multiple Rows using VBA Macro?
Adding a condition to VBA CountIF
Using only variables to reference a range
Combobox date value matching
how to use VBA code to create 'Select Data Range' userform.
Autosum
Deleting Columns with VBA
Range Reference Problem
how to run a recorded macro in many files at a same time
Compatability Checker Question
Template Folder with Excel Macros in Sub-Folders??
Setting a .Range to equal another .Range
VBA's Q? Printing None-Zero Valye ONLY
halt macro execution, inspect progress and then resume execution
display list based on validation
ComboBox value matching
Formatting short times
VBIDE.Codemodule.addfromfile putting code in wrong place
Multi-Dimensional Array
LinEst using arrays
Insert columns and values programmatically with IF statement
Insert page break
How can I Lock a Link?
Error handling
Wait till pivot finishes refreshing
VBA Example of Using WHILE and LOOP?
macro to copy columns from one sheet to another sheet
Newbie help needed please...
Odd Export as PDF problem - Killing me.
C drive size
Copy Multiple Areas from One Workbook to Another
Delete characters from behind if too many
Ignoring a blank cell while running a macro.
Re: UserForm doesn't show?
VBA Compare part of cell to another cell and then calculate
Determining if a query is refreshing
List all sheets in the work book and select by double click
Error '1004'
Pivot tables not refreshing after data source update
Check a Check Box with VB
How to print multiple sections from different worksheets
Mixed-font string both to cells and word document
Syntax in worksheet functions for individual values instead of ranges
Working out of Statistics on Exam Results URGENT solution needed!
VBA API for Outlook and Email managment
Replacing the formula text's substring
Lookup Formula Problem
Compile Error:Invalid use of property
Loop to hide sheet based on cell
URGENT help needed for a macro to place and size command button
Hiding Columns produces error <----HELP PLEASE
Macro to select, set, and print
HELP! Command buttons moving to edge of Worksheet when unhiding rowsand-or columns
Macro to upload file to http://
4 out of 35 data connections running high cpu/memory
Syntax question using :=
Paste to next free column
How to set range to autofiltered visible cells?
Embed information in Worksheet for error checking
loop to copy paste
Pivot Table Refreshing
Looking for all the opinions about Self Certification for macro's
Vlookup error
Find and delete error value
Countdown 1 every workday
Cycling through collection
Out of resources error message - when not...
Deleting backslashs and everything after
VBA SaveAs function generates blank CSV file
Days between 2 dates excluding Sundays only
Put Name's Refer's to: field in cell
Open a GroupWise .NAB File
Sending mail from Excel with CDO by Ron de Bruin
Sending mail from Excel with CDO by Ron de Bruin
Declaring a local variable once for all subs
Not able select list value in HTML
Kind of MAPIfolder
Variable Data Type
Worksheet_Change - compare columns
Vlookup error
Re: Option Question
switching workbooks using variable and wilcard filename
Pivot Table Refreshing
FInding Data Connection Name
Programmatically setting pivot sourcedata
Delete rightmost zeroes
Finding right-most cell.
Copy cell value from one worksheet to matching worksheet in another workbook
Copy from Excel to Word
Re: Magic Excel function or UDF?
Extraction
Excel vs .csv?
Excel startup problem. Possible problem with stdole32.tlb
Open Word file with Excel VBA
count cells with diagonal borders
Find(SPELER, LookIn:=xlValues) problem with hidden colloms!!!
In Excel 2007, color for number format axis not working
Populate TextBox with other textbox value
REMOVING COLUMN FILTERS VIA VB CODE
add hyperlink without changing the cell formating
hope someone can help with excel save with 2003 and 2007 installed on my computer
How to write Left Function in VB
Combining Text based on Values
Check if information exist in one column and if it does, type appropriate text
Reading Excel Table in VBA
Search for empty cells and move cells next to
shorten sheet name
Find and move cells with text
Text To Columns then insert rows
Code for RefersTo property
Deleting Toolbar
Deleting Toolbar
Re: Excel 2003 - VBA Code Problem
Macro to open file and copy information from worksheet
Re: Excel 2003 - VBA Code Problem
formula for payment, time vs hourly price
Re: Add data to a PDF file or form?
Excel 2010/2007 - How much can be done with Custom Validation?
month gaps counting through whole column
Wildcards in SumIF formula
Check font of a cell
Copying Cell Value AND Format into Email Body Macro
colors change in graphic
Global/Public/Universal variables
Use only cells with data in
Modifying a Defined Name's Contents
Alter internal margins of chart title using VBA, Excel 2010
execute .acsup script from VBA macro
Require entry in one cell if data in another
Filter based on cell contents.
Re: Help bringing in hyperlink into Excel from Web
macro to a number + 1 to a cell
how do I link a constant or variable to form
Should I activate workbook before activating sheet when button is selected?
Automatically create ranges and then name them
Auto Detect Data, Auto Print Data, Auto Erase Data Loop
Draw line of defined length
calculating Sick pay entitlement
count cells with diagonal borders
List of items from other sheets
Keeping Conditional fromating When Emailing Using A Control Button
ListBox with 2 Columns
How to change a sheet name without opening the workbook
No program is registered to open this file
Efficient looping
Unique Random Numbers
Directional buttons
Storing Multiple Selected Pivot Table Report Filter Values
Include Layout name with filename when printing to PDF
how to determine duration of meal break in timesheet (working with times)
Controlling Page Break Preview
VBA to set the font size for the axes of a bar chart
Purging Excel's VM Usage
Important Union Intersect VBA Problems
Cannot recalculate
How to parse text in a cell
Looking For A Formula
Iterating through a ComboBox's values
Why does variant not need set?
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed
Comparing dates
Implement time-out
ChDir "F:\dump" - not working
Detecting when a process ends
Possible to refer to a sheet's object name ?
changing activesheet shapes label caption
Can I use loops to enhance this code?
List of methods and/or properties
Wierd Formula Request
Application.Filesearch FileCopy
Obtaining list of all objects on worksheet
VBA: Read picture filename
Re: Average of a column, excluding spaces?
XML and EXCEL 2003 standard edition.
Prevent Sending eMail from Excel
importing Access via code
Convert Objects to Pictures (or Shapes)
Re: VLookup a named range
Shared Workbook Crash
VBA - Copying a Certain Colored Row to Paste in Another Worksheet
numeric value, vba to split out one digit per column
Forcing Excel to Import .CSV data
Spliting digits up to fit paper form
Alt-F8 and Excel 2010
Re: VLookup a named range
Re: VLookup a named range
Cannot display Add-in Macro list without going to VBA/Project
downloading from excel to google
Dynamic rowsource for ComboBox
Need to run a macro on opening a new excel file
VBA module for record data from datafeed
Importing several web pages with macro/VBA?
Excel 2011 for Mac tries to run a file when it starts up
Get CPU Priority of a ProcessID
How to create a variable selected range
Parsing Month WorkSheet (one row/Project) into Folder & SubFolders by Project
Sorting multi-dimensional array
Finding a Value Between Two Numbers and Returning Corresponding Value
Using VBA on Excel Pivot Tables
Excel VBA Replace Data Validation Titles and Input Messages
Enable macros
Loop to copy paste rows base on table arrays
Macro to display Tabular View of Active Pivot Table
Save sheet bitmap to desktop?
No characters data in Hyperlink cell
VBA Go to Today's Date
Saying No to Message Box prompt through VBA
EXCEL 2010 VBA; trying to use INI File stored on local desktop machines
Macro to remove squares from cells
Large Dynamic Named Range Sort Problem
Excel 2003 - Save as dialog box
length of line depending on the value of the cell
Compare and highlight differences in 2 worksheets in same workbookand list differences in 3rd worksheet
only 1 time declaring variables
Error handling
scraping PDFs
VBa Write integer to file
Dynamic Creation of Arrays - Sorting into Bins problem
VB Marco Reverse Variant and paste into other sheet
VB Marco Reverse Variant and paste into other sheet
Function in a VBA prog. or something like that
Transfering Excel Tale into .csv Ones?
Pivot: hiding rows with emty or zero as value
Re: Adding CustomUI Ribbon code using macro to new generated file
Re: Adding CustomUI Ribbon code using macro to new generated file
Change cell type
Run Macros
Creating an ARRAY UDF
Excel timesheet
object library problem
Copy Template with Updated Values Each Time
Object libray invalid problem
Output from Frames - multiple optionbutton groups
Re: Userform Control validity check
ActiveX ComboBox Linked Cell
General question on multidimensional variables
Excel 2010 Charting in Userform - Can't Access OWC11 Control from Toolbox??
EXCEL SQL.REQUEST of ACCESS DATA
Putting the series 1 and series 2 titles from a worksheet
Recode values
wildly varying execution speeds - is it the code?
any ideas why execution speed varies?
MINIF UDF
Improving Nested Formula Calculation Efficiency
Re: Get ColorIndex from Character in String
How to maintain size of array: UniqRow
Re: DSUM not unique records
Macro Excel 2003
Combobox list based on choice in previous combobox
Combobox list based on choice in previous combobox
saving the userform layout
Combobox items based on choice in previous combobox
Re: DSUM not unique records
How to best set this spreadsheet up
import data from a non existing datafile
Retrieve numbers that meet criteria
get column name by ADOX
Produce Random Numbers
Running macro operations in serial fashion
VBA to set dynamic print area
Test Message
Robust Excel addin installation through vba
Using code to edit spreadsheet formulas
Check a value every time excel is loaded
Runtime Error 1004 on Linest
Runtime Error 1004 on Linest in VBA
Runtime Error 1004
Runtime Error 1004
removing personal.xlsb file
Cannot save macro spreadsheet due to ReadOnly = True
Triggering auto_open
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook
Variable Name Changes in Loop Operation
Creating a UDF to search a cell's formula
Stubborn toolbar
When importing text field Excel chops off leading spaces
Re: ByRef v ByVal
Delete named ranges in VBA - by scope?
Re: VBA Search worksheet, find text, change color of row
Re: Excel consultant recs?
Re: Excel consultant recs?
Need : Application Developer - FoxPro Loc:William Street, NY
count shaded cells with a gradient fill
2007 Compatibility Checker states cells outside of range when saving2003 version
VBA code won't run, even with Macro Security set to Enable All Macors
SUMPRODUCT Error
Excel VBA assistance
Runtime Error 1004:Method 'Range' of object'_Worksheet' Failed
Task manager’s system CPU PercentProcessorTime
vsdvfs
Returning the name of a deleted cell style
Deleting a row where characters 34, 35, 36 are 000
Referencing a cell value in a macro
A way to count cells in a range containing text or formulas
Problem with ActiveWorkbook.Close command
Manpower Calendar Distribution, Skipping weekends.
Re: How do you detect a Left click on a Worksheet
Help: Find Matching Cells, If - Then Move Cell With Self
Error 1004 on Range.Text with AutoFilter
Importing a JPEG image to excel as matrix
Keyboard shortcuts
å›žè¦†ï¼šRead back the source data from chart
Read back the source data from chart
Passing Parameter with OnAction
Re: Formula re value in column C or D, calculations made on either in column E?
Workbook_BeforeSave
Re: Formula re value in column C or D, calculations made on either in column E?
Re: Formula re value in column C or D, calculations made on either in column E?
Conditional Combobox
Import Hours as Text
VBA code for Range
Excel Add-In to catch application events
excel cell to text file and text file to cell dir to cells and renamefile from cell
Convert Time to Text
Summary sheet
Copying Value to Range
how to quit in BeforeClose
Find more than a word in a table
Clearing Office clipboard 2010
Change SQL in VBA
Filtering Worksheets by Same Criteria - Object variable or with blockvariable not set
Change Format of Active Cell
selecting multiple cells from multiple worksheets for printing
Sendkeys to external application not working
Excel Bar Charts Issue - How Dynamic can charts be?
How to find sheet names without opening files
Make a crosscast reprot from a tabular report
Help with creating a Macro to copy data from Excel to Word.
Count or Match Help Please
Calc Number of Months PER YEAR Between Dates
Moving data from column to row in groups of 250 per row for fourrows, then skip a row and continue the same throughout the data in column A
xls Compare Software
Searching
Coding
CreateObject Software Versions
Is Range Offset property needed
Re: Close dialogs
Routine too fast for Form to Update?
automation error 440 when adding to collection
how to copy worksheet to new workbook with values only
Count no empty cells at the right of a selection
Problem with printer name while using executeexcel4macro
USB Communication
Match using VBA
Error Opening Workbook
UDF for Aging in excel - Help needed
UDF for Aging in excel - Help needed
Auto-Calculate price based on width x height
Re: Error populating a list box
comboboxes, extracting specific item
Re: Create a password protected Zip file
Re: Error populating a list box
Error populating a list box
overlapping sheets' frames
Have shapes react to events in Excel 2010
Inputbox from another OPEN workbook
Finding Intersection Points between different lines
Finding Intersection Points between different lines
Adjusting alogarithm
Re: Import module
Re: Import module
Re: Import module
Trim leading numbers
Finding, grouping, then copy/paste to new sheet
Adding PivotTable fields with a macro
Best way to make all sheets in a workbook Values only
Why is Cell not an object
Corrupt files due to pivot remnants after saving via VBA
Worksheet appears briefly before UserForm opens
CountA and Countif and Arrays
Protect / unprotect a form
stopping a range from calculating
how to protect a program
Identify invalid folder in VBA
Macro to link data to template
+ / - Percentage Variation
Returning 100%
Save ActiveWorkbook dilemma
=SUMPRODUCT Question
Delete some letters
Duplicating worksheet based on range and changing worksheet name
Using a sub within a function
Cell list value from another sheet
VBE object in 2010
Advance Filter
VBA dropdown vs Validation
Read contents of #Name cell
Unable to change ActiveSheet within Workbook_Open
Nested If / And Statement with Conditional Formatting.
How to Average a Sumproduct() formula
Outlook Code Run from Excel
If then statement based on time of day