Microsoft Excel Programming [Archive]

Re: MS Query
VBA Macro to customize Right Header
Re: Columnwidth in milimeters?
Re: Columnwidth in milimeters?
Compare shorter date range against longer date range
Re: Loop thru folder and get similar names
Re: VBA Loop through Specific Subfolders to find files (drill down 4 levels)
Re: VBA macro delete row - Help needed
Re: VBA macro delete row - Help needed
Re: VBA macro delete row - Help needed
Re: VBA macro delete row - Help needed
"NxtRow = Cells(Rows.Count," giving me fits
Adjust code to run anywhere on sheet
Re: Question about a range
Re: Question about a range
Re: Question about a range
Re: VBA help with selecting multiple data ranges
Re: Macro to Publish as PDF
Re: Undo a select operation?
Re: Undo a select operation?
Too W i d e
Re: Determine if a userform is visible
Re: Determine if a userform is visible
for each in a range
Re: Deleting Lines
Re: Deleting Lines
counting number of columns
Re: From where is my UDF called?
Add sheet and name it unless it already exists
Web Queries?
Re: Macro to Copy/Paste Multiple images
Re: Save preview picture
Assign a sound to a variable
Re: Save preview picture
Password Cracker for Excel Worksheets/ Workbooks
How to Restrict my addin usage to one pc only
Copy hyperlinks
Double click fails to run the code, just selects the cell
Get rid of need for F2.Select
VBA - Run same logic on values in columns 2 & 3
Digital certificate for VBA code signing in Office 365
Re: Addition to current VBA - Keep text format
Strip out certain rows that have merged cells
Re: Load data from Word into Excel
using 1 through 9...equal 23
Re: Access to Excel format
Re: Intricate Cell Formatting Question
Re: Time format
Snake pre-defined range from multiple worksheets.
Re: No need to password protect a sheet?
Re: No need to password protect a sheet?
copy and save as csv
Re: VBA Copy & Paste multiple ranges
Re: Deleting entire row
Re: Custom pop-up menus?
Copy & Pasting Problem ?
Re: create ramdisk from VBA
Ctrl-Click to change TRUE and FALSE in a cell
Userform Calculation
Defining a dynamic table_array for vlookup
Re: Highlight a cell after update in a specific range
Re: Copy cells to different sheet if value found
For-Next by a row Counting consecutive Zero in the column
Tranfer data from Excel to word (Docx) via VBA in Excel
Sheet to sheet code Type Mismatch
Re: VBA code to import worksheets from other workbooks
Attendance sheet
Compare two workbooks and hi-light matches
increment IP address.
Copy/paste in based on duplicate value in previous row
How to make web image on Excel worksheet permanent
Re: Copy and paste from one tab to another with certain rules using VBA
Col widths
Re: Pop up window with totals?
Re: Pop up window with totals?
Conditional Formating: MAX & MIN
Re: Quote constant?
Re: Quote constant?
VBA code for for telnet
Re: Avoid compile error if userform doesn't exists???
vba code to filter the data like a group with group header
Re: Return a value from Userform.Show()?
How to execute a command in VBA
Re: Return a value from Userform.Show()?
Selection.AutoFill Destination:=Range
make use of cell defined data validation in vba
Hyperlink to Same sheet but after that want to hide link sheet
Re: Double click a range
Re: Double click a range
Re: Double click a range
Pulling data from one workbook to another one using VBA
Re: Delete a row that is double clicked
transformed vloopup
Plot Polyline using XY coordinates
best way to validate data in forms; 2010
Copy adjacent Sheet and name from a list
Re: Select method failed - Error 400
Excel Update
Re: How to get a value from 1 table to a 2nd.
Permutations andText to column problem
Shifting rows down in a table
Re: ScrollBars in 6.5
Loop returns only one value, does not loop & an assignment to columnhow-to problem.
Re: Input Box flaw?
Re: Transpose data into a single cloumn
Re: Input Box flaw?
Re: Input Box flaw?
Anyone has a Template For Aoristic Analysis?
Re: Transpose data into a single cloumn
Re: Text boxes moving to Cell A1 on top of each other after turning off AutoFilter
VBA code for pasting links -- modifying RDB code for summary workbook
Code with hidden flaw ERROR 400
Re: select data entry by typing first letter which causes drop down list
Re: select data entry by typing first letter which causes drop downlist
Re: Copy, paste to active workbook?
Sheet name=Cell value
excel tables, searching via sql interface?
Combobox Rowsource
Process dumped into an array...and then back to sheet
Re: Conditional formatting within macro?
Removing Objects
userform textbox returns changeable date
Copy FROM - TO Object/Block variable not set
Ranking without skipping ranks and percentile
Import sheets with picture
Run-time 91
Draw two lines at given angles
Gears
Re: Reference must be to a macro sheet?
only the date part
list box remove item by combobox
Absolutely turn off all messaging/alerts/debug - ontime()
Re: Quicker way to enable macros?
Re: Sheet Selection
How to use variable while dividing value in formula
How activate "NUM" thingie?
Re: Userform to query?
Re: Sheet Selection
contacting .... press escape to cancel
VBA Code to monitor standard toolbar buttons.
VBA and SOAP in Excel 2010
I'm trying to do a "count" function at the end of a dynamic pivot table
Keeping formulas on an insert
AllowFiltering vs EnableAutoFilter
Run-time error '6' overflow
Range passed to a function - trying to just move through the range
Re: Automatic cursor move
can't see VBA code, although it's working
Re: Automatic cursor move
Re: Quicker way to enable macros?
What is going on here? (macro mystery)
Re: Quicker way to enable macros?
Conditional Validation In Excel
Re: Automatic cursor move
Re: Path to desktop
Re: Path to desktop
Re: Path to desktop
Re: How to copy only the numbers that are between quotation marks in new cells
Somewhat complex code to copy data from one sheet to another
excel auto dial cell phone via bluetooth
excel dial phone via bluetooth
Re: Cell Auto Lock After Entering
quick way to prohibit all editing/changes to workbook (2010)
can variable names end with a $ or &
hyperlinking to charts in file
UPDATE through a QueryTable? Or?
PlaySound error (Chip Pearson site)
Copying a Picture From Cell Comment
Worksheet_SelectionChange & Worksheet_Change results in different Targets
Re: Macro stops running if date is not in past...
Macro storing as a date?
index function in vba
VBA to VB6
Convert numerals
Re: Working with Word Documents from within an Excel Macro
Re: Right justify a string
Re: Working with Word Documents from within an Excel Macro
Re: Check if there is a space in a string as test for IF
Re: Right justify a string
Re: Check for values in column A and if found then column B must have value.
How to use Sumifs with vertically and horizontally criterias
Re: Use a listbox as a dynamic array?
Re: Use a listbox as a dynamic array?
Change event to add button
execution speed issue when closing files
Macro to restore previous content of clipboard
Macro to search range for a portion of a specific value and if findit - then paste formula in another cell.
Inaccurate count with code
Re: String centering
user defined function which increase consecutively while passingbelow cells
Convert to Excel Macro
Convert to Excel Macro
Re: Slight VBA hickup
Re: Pivot Table Management
Macro for Creating Word Document!!
Re: Pivot Table Management
Collect User Input
GridLines Inadvertantly Goes Away with Macro
Number stored as text
How to differentiate two images inside the excel ? (only 2 type ofimages, needs to differentiate as boolean)
Re: Blank Spaces on ComboBox
Searching for a word and then copy the whole row
Finding Next Largest Number Based on Criteria
Which numbers are missing?
Re: Input, copy, new book?
Name the range AFTER copied to new sheet
Send mail code from Ron
InputBox to name a range
Remove Hyperlinks Without Changing background shading
CSE with function returning an array?
Code Snippet - Data Filter
If .Column > 7 And .Row > 25 then go to B8
Re: Spread Project Costs Over Months Using Bell Curve
Throwing #Value in a UDF written in Excel VBA
Re: Override protected sheet message?
UDF does not show up in Autocomplete
Key Card Software (Auric)
string compression
best way to express the range "column N to column M"?
Cut bottom 300 rows to next sheet & repeat
check the value in cell
Re: MOD giving different results???
Close na "on the fly" created Listbox if ignored by the user?
Automatically copy with save?
Macro Related to Paste Values
Excel Help! Duplicating info from other tabs to a Master tab
Re: Date Stamp by User and cell value
Excel 2010 Sendmail .Display works, but not .Send --- Please help
using defined name in UDF
function works okay, unless I save personal.xlsb
Re: how to have 2 drop down lists filter rows
Re: how to have 2 drop down lists filter rows
Re: leading zeros using ActiveCell.Offset().value to insert row and value
Re: Excel 2007 Conditional Formatting
Sort The Date at the center of string with VBA
Toggling save warning message on or off
Set a Range to a variable
Transpose cells
QueryTable inserts empty column?
Date formatting in VBA
Copying cells and formula from closed workbook to all sheets in open workbook
Variables in a Popup prompt
revise CONCATENATE code
CONCATENATE code
Re: Chinese New Year
Re: Chinese New Year
Re: Chinese New Year
Custom Document Properties in Word documents and Excel workbooks
get calendar item of another user (not in present in public folder !! )
all above entered first
comparing two columns in vba
using vlookup in vba
Problem with multilingual VBA Programming
Re: Test if a string contains only whitespaces
Transpose code has ceased to transpose
Re: Cell value that changes previously entered value
User Agent to get source code
Re: Deleting rows which are not highlighted
Re: Deleting rows which are not highlighted
Re: Return a string by reference?
Perplexing IF statement
Re: Check for invalid file types?
Re: Test if a string contains only whitespaces
Re: Test if a string contains only whitespaces
Re: VB Editor Access
Re: VB Editor Access
Re: Check for invalid file types?
Application.OnDoubleClick
Re: Moving cell data left
Re: Let user choose multiple files?
Re: Macro to Consolidate Data from Various Excel Files
Autofill a dynamic range with a formula.
Object range failed
Re: Help with copy/paste sub
Re: Let user choose multiple files?
Date match problem
Changing the test of checkboxes (shapes) programmatically?
Re: Runtime error 1004 Application-defined or object defined error"on data sort
Re: Copying row into new sheet if it contains certain text
"Runtime error 1004 Application-defined or object defined error" on data sort
Fill both cells if one cell has a negative amount
Fill color if amount is negative
Currency formatting (Issue with globalization/localization)
How to copy data from an excel cell into a field in access table
Fill color when negative
Concatenate when pasting.
Re: Make long strings visible?
Re: Time within time
Re: Make long strings visible?
Need to embed a graphic, then make a call to it
Re: Time within time
Re: Make long strings visible?
Re: Control printing?
VBA Read-Manipulate-Save Text File
Excel 2003 with VBA - "Can't find project or library"
Altered pasting functionality
Fixing Error 2029 (#NAME?)
couple subs I need help with
Re: Auto Calculate selected worksheets
Couple subs need help with
Code Optimization
School Athletics Inter House Meet
Re: Problems with VBA mailmerge
Re: Hide Co9lumns based on cell value
Re: Converting UTM to Google Earth coordinates?
Re: Converting UTM to Google Earth coordinates?
Re: Hide Co9lumns based on cell value
Re: Automatically email from spreadsheet?
Re: Automatically email from spreadsheet?
Re: submit button and auto update for workbook?
Eliminating cells
hiding blank rows
Re: Help Needed
multiple column filtration
Excel Geography Game Example Using VBA and MapPoint - StateIdentification Game
Re: Copying Solver results of each iteration to a given location in a workbook
Re: Macroto delete extra space in a cell
Re: Macroto delete extra space in a cell
Re: How to obtain the transit time
Conditional format if difference in cell values greater than 0.50%
Time Now() minus ten minutes
Sort on 3 columns when number of rows vary daily
Code to insert a coma
Convert A1 value to a sheet name and copy to it
Re: Change fomula in multiple cells
Re: refering to a sheet by codename
Re: Special language request
Re: Special language request
Re: Special language request
Open Windows Explorer from Excel and select specific file
Re: Insert a link to a pdf file
Excel 2007 and Security key cards
Re: delete 2 dynamic ranges with VBA
Re: Formula error when created via VBA
Re: Does anyone know how I can concat duplicate cells associating info?
Re: Formula error when created via VBA
select all cell containing any formula and not text or number
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows
Unique value of Excel file
List sorting and macros
how to detect host id of a computer using excel
Re: Duplicate last row and other progressive numbers
Graphing Negative Time
ie certificate error click on overridelink
Re: Maximize VBE Window?
Need Help with Excel Cross Reference Formula
Re: Excel freezes while running macro
Cration date
Sheet name to cell
filter column unique for alphanumeric
I really need help
Re: Macros to Rearrange Data??
Delete rows if time is greater than present time
Set Up Calendar To Account For Leap Years
Compare dates
Finding and Replacing Data in a Header Row
i am unable to post on group can any one tell me the group's e-mail id
ActiveCell.Offset(i, 0) = Chr(ActiveCell.Row + 62) returns all A's
= CHAR(Row() + 61)
Chip Pearson UDF returns #VALUE! error please help, just cannotfigure out why?
Re: Transpose columns to rows in groups
Finding Date in an overseas format
VBA to surf and login certain website
VBA not adding elements to Solver model
Re: Excel New Tool
Re: Searching for specific name on main sheet then copying row dataassociated with name
Re: Chop picture in VBA?
Re: write usb flash drive information in to excel cell
Link, drop link, relink
Apply cell formatting using VBA
Excel 2003 - VBA to get a list of Module names in the project
Re: input info when pasted in cells
Control of cell comments lsot in Office10
Find #N/A in column D
Sharing xls file with macro (xlsm)
Date subtraction
MRound
Disable/enable or lock/unlock cells in VBA dependent on other cells values
sum character
Dynamically Rename Files Using VBA
Re: OnTime LatestTime Use
Re: Runtime error 438
Help in Complex excel formula!
Re: VBA Help needed
Re: Calculated Field - vLookup
Re: Mass covertion from faction odds to decimal odds
Looking for a Date forming function
Re: Extract image paths from within html in a column
Re: Mass covertion from faction odds to decimal odds
How to count cells with same fill colour containing same text...JoeMoe
Averaging Formula
Query of List Option
Re: Add to existing macro
Comparing two workbooks - Excel 2010 - not using Add-ins
Sheet synching
compare dates with different formats
Can you decipher this timestamp?
email workbooks to three people
Using the OnTimer event to lock out users between specific time window.
Re: Macro to delete row if cells greater than certain value
2 dimensional date sort
Re: Help with MACRO for opening workbook
Re: LoadPicture into UserForm
avoid reset after CodeModule InsertLines
Only work if target is in particular col
Re: UDF in personal.xlsb is not recognized
delete selection in pivotcolumn
linefeed in msgbox
Problem using &
new v/s createObject ... IXMLDOMNodeList
VBA call xlfit
Curious general format rounding
Re: Macro to choose data and export in another workbook
excel sheets to PDF
Top 16 World Excel Finals (This Weekend @ Microsoft New York 2:00pm)
Deleting Duplicate Data in Excel
processing time (revised and re-posted)
Hide column based on data validation
Processing time
Re: help needed with borders
Newb: Asking about a tweak in code
Case Sensitive SumProduct
sorting: cleared/null v/s ""
Re: Copy to Next Blank Row of Different Workbook
autoincrement number
Problem sorting a range of columns using VBA
Email Macro-using range for email address,ccc,bcc,subject and body.Office Outlook as email
How to implement subtraction from a range
Re: Sort in striing?
Re: Need help on macro to do ranking
Re: Sort in striing?
International Date formatting
help to understand 'querytable'
Re: Identifying common data between 2 cells
vba code does not run
Re: Issue with OLE DB Query - Date Search
Re: Macro to copy row based on value into new sheet of same name
Where did all the newsgroups go?
problem opening file thru code
Re: Delete rows in Table
VLookups and processing speed
Prevent loss of SetPixel changes by window repaint
export excel chart to image from C# without using interop
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart
Re: Monthly view calendar
Re: How to get all the possible 6 number combinations from numbers 1-36
hyperlinks to folders - flakey?
Re: Range.Find problem
Re: How to get all the possible 6 number combinations from numbers 1-36
Re: How to get all the possible 6 number combinations from numbers 1-36
Re: Trying to summarize same values
Re: How can i not copy the headers?
Re: How can i not copy the headers?
Re: Specified formula cannot be entered bc it uses more than 64 levels of nesting.
Re: Specified formula cannot be entered bc it uses more than 64levels of nesting.
If Cells.Find returns run-time error '91': Object variableor With block variable not set
Re: unic no
loop help
Open and save blank workbook with Command Prompt
macro not register my conditional format formula
conditional formatting suddenly disabled
Chart label alignment
plot excel chart against datetime
How to display an "icon" instead of cell value
How can I branch from to
Number and names of courses may change later
Weird ignoring of one item in a loop
Re: VBA to clear multiple ranges from list of sheets
date corruption? 00/01/1900
execute assigned data validation in vba?
Re: Get text from last and first cell in a column
Is it possible after creating a new sheet to insert code in it?
Re: Multiple criteria in same column
Lost days in Powerpoint
Returned position address on protected sheet
Alarm 2
Re: insert new row every day.
Error message 1004
Change macro button text when macro is invoked.
Re: importing cvs file!!
Re: How to write a macro to selectively output certain data to adifferent table based on
Naming non-contigent cells with vba
Re: Help with loop
Re: Help with loop
Add up cell from sheet 1 to show on sheet 2
Dir function on Excel 2011 for Mac
Re: Slight Annoyance
Re: Several Password
Re: Repport bugs to Microsoft?
Re: File Dialog Folder Picker open to particular folder
Cannot find path!
Autohide rows based on formula in another sheet
hide & unhide toggle button
Audible Alarm
Re: Save and closed excel workbook from the sheet
Re: Masking the character in input box
Help Required
macro to find bottom of column
Cause and Effect chart convertion
Re: Move rows based on cell info
Open print dialogue box when click on print icon in tool bar
Re: Data from excel range to User form in textbox
Changing sheet name based on a cell in another sheet
Re: Auto run macro
Re: how to apply the code to the whole of the worksheet?
Printing issue
Re: Find values of a column in another and paste range of rows
Re: Command button wz 2 function
Wildcard Filtering on ADO Recordset
Re: macros to hide sheet with protection
Re: Count down a certain number of rows?
Re: Count down a certain number of rows?
Average Ifs in Excel 2010
conditional format based on column statistics and loop over columns
Search , then copy and paste from multiple worksheets. VBA help
Re: Data from excel range to User form in textbox
>_< Excel 2010 Assistance Please!
open sheet more than once?
excel 2010 forcefullcalculation = true does not work
conso macro
Re: VBA Filter
Re: VBA Filter
Formula Array Help in VBA
comparing two arrays
Re: Unprotect sheet when Saving As
Forcing xl2K7 Column Count back to xl2K3 size
macro on different reports CTRL+F in formula
help with array
End process at last row of data
DES Decryption
Comparing two worksheets and highlight unmatched Data
Help - Creating Tip Pooling Worksheet
Re: Count the duplicate string in the cell
Re: How to delete item from listbox?
Sumproduct to populate 0 if cell is blank
Re: Loop through named workbooks
Excel template that is able to collect data from other excel sheetsbased on different criterias
Re: Trying to do a refresh type function
Re: Dynamic Autofill Error
select case syntax to other sheets
SaveAs using VB
Re: using replace to get the desired value?
Re: using replace to get the desired value?
Re: formula to format text with single quotes
Re: Macros replace if arguments
Re: Macros replace if arguments
Re: Open a workbook in VBA using UNC pathname
Re: calculated form field
Update this macro to make it generate a counter as text
Getting the FULL text of a Comment
Data Cleanse Macro Running Very Slow
Subtotal Formatting
Re: Formatting automatically filled cells
fill in data that is not empty
Macro to copy A1 tp J(bottom)
Querytables.Add problem with destination Range
Loop doens't work properly (Error Handling)
How to blank the colored cells?
Buying mathematical algorithms vs. programming
help with VBA program to import and add formatted files to one file
Pasting to visible cells only?
HPageBreak not working - More info
Remove Duplicates (Macro)
HPageBreak not working
Array Formula In IF Function
Date formatting issue VB
Re: Macro to copy top 3 value in column
Re: How do I add a break after each subtotal?
Is there an incompatibility between language?
Bottom Up search for multiple entries
Re: Search the list of Ids in the records
VLookup using VB
Automate Nuance PDF Converter Enterprise 7.3
Re: Excel VBA to delete records in Access table and reset the Autonumber
Training in VBA
How to exchange data?
Custom Images not showing in Ribbon toggle button
Re: Excel Automation using OLE
Re: VBA Macro to Create Sheets Based on Column of Values
Re: Skip copying empty column where remaining rows are filled
Find and match text and return column and row reference
Re: Excel Automation using OLE
Macro will not be assigned to a toolbar button.
Converting currency value into text
this code is VERY slow, is it the code or perhaps a worksheet issue
Changing 2 pivot tables source name per sheet x 15 sheets in Workbook?
Re: Excel Macro Programing Problem
Re: Excel VBA Macro to input data on website - problem with HTML language
Re: Excel Macro Programing Problem
combo box
Language independent VBA - hiding "blank" in pivot?
run a macro in excel when moving data
macro to set bottom and top values for randbetween
filter that yeilds no results
How to make a VBA Function return a value in percent format
Time Data Conversion
SelfCert Cannot create certificate
Copy & Paste Conditional Formatted duplicates w/vba
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server
adding hours and minutes to a time value.
correct syntax for LEFT in vba
Subtract all individual elements of two matrix
VB Code to Auto Save Multiple Files
Excel 2003 file gets 25% bigger after changing TP source with VBA
Batch Pivot Table update
Re: Set Folder path for entire module
Userform to Select what worksheets to print
VBA formula update?
Re: Compare textwidth with cellwidth in Excel?
Re: Code Improvements
Please help! Cannot open pivotTable source file....
Re: Copying specific rows to another sheet
Playing back a Pivot Table macros
group filtering
Re: How to create multi chart beside the data?
Macro to print specified range of several work sheets
Problem in adding macro to ribbon through Add-in
Compare 2 excel sheets -Error Checking of entered names
Re: Code Improvements
Re: [HELP] Download images from a list of urls (in excel sheet) tomy local disk
Looking for some help launching files from COde & Ribbon control
forcing specific sheet opening upon launch of .xlsx file
Getting Excel Find to Default to Searching Workbook not Sheet
Change Shapes (countries in map) based on conditions
Re: Importing multiple text files and getting certain figures.
Check a range to see if a value exists in it
Find last weekday of the month with vba for all months
Retrieving a range of values from a closed file
How do I find what is in a spreadsheet
How to assign a worksheet in VBA
Go back to last step in programming
How to force macros refer to ActiveWorkbook
Find Text using VBA
DIM in VBA
Open workbook(s) using VBA
Re: Excel VBA Macro Training
How to call Excel add-in macro from a button…
Re: Loop through cells to find a string and copy/paste the matchingcolumn to a new wkbk
When something in module is shown as a macro
Unhide sheet
CommRead data with unknown length
Re: Unexepected error (40230)
Customize Quick Access Toolbar
How to split an excel workbook in code and data
Re: Type Mismatch Error on IF conditional
Help on Code Snippet Error {Val function}
Re: Coding Equivalent of CRL-A?
Help me5
Help me4
Help me3
Re: ListBox Item Row Number
Another question 2
Function Pointer in VBA.
sort macro not working
Re: Quickly count used rows?
Re: Quickly count used rows?
code help
Mid-Month function help
Help me2
Run-time error when copying entire row!
Double Fields Lookup Issue
Macro to hide cols
Re: VBA quick print function?
Re: Macro for converting Excel list to QIF?
is there a macro that I can use to prepare bank rec?
Excel as a sign in sheet
Excel as a one step time clock
Linked pictures to cell dropdown
Cell format crosstalk
Disable the sort commands in autofilter (Excel 2010)
Help me 1
Re: Something like vLookup for duplicate values on other tab
Undesirable sorting behavior
Pivot Table Question
Another Time Related Question
Time Function
Another question
Help me
i need 1 macro button in master file to refresh data from all files
Extract data from XML file and populate them into cells
countif - unique values only
Run time error specifying range for sort code vba excel 2010
right answer has value 1,wrong answer has value 0
populate cells using select case
Macro to update pivot table data range
Re: FFT in a macro
Chart Question
Re: VBA - Hyperlink Function Combined with Find
Re: Trying to work smarter, not harder
Re: VBA - Hyperlink Function Combined with Find
switch to another worksheet, then return to original sheet
Re: Copy files from website?
Re: Iteration Macro
calculate(f9) event at workbook level?
How to dynamically change the list in drop down list based on thevalue of another cell?
Re: Remove duplicates in one column within a range of dates inanother column
Re: Iteration Macro
separate questions and answers of a test
from to 3 rows to 12 rows (please macro or formula)
Highlight Selected Range Only
Userform dropdown doesn't go away
Column heads on second row
Time Calculations Help
Code snippet works but is a bit 'clumbsy'
Trying to create a list of prices from a web page
i want to add footer in all sheets wen i save and close any workbook
adding footer to all existing sheets in workbook and also to newsheets which is added
Re: how to use Solver in Excel VBA
PDF the Excel Report
Re: Listbox search question
Re: Help with Nested IF Then statement?
Re: Marco is not working
Re: Autofill Dynamic Range of Cells
Re: Listbox search question
Re: Create survey
Re: Auto Row Height Protected Template
Re: Autofill Dynamic Range of Cells
Re: Help with Nested IF Then statement?
Hyperlink in Excel 2000
Disable Cut/Copy/Paste in Excel 2010
VBA insert column with two workbooks open
Re: Chart title: Text and Formula together? VBA
Re: Copy range from multiple files in multiple folders to singlesheet in master WB
Re: Send Workbook as an Attachment Via Gmail - Code Review
macro to run in event of cell value <>""
passing a non numeric cell for numeric comparison
Using START, CALL etc commands in Shell gives me error "Run TimeError 53; File Not Found".
Please help with code
comparing strings
Re: Sort a range of strings using VBA code?
Right-mouse open a 2nd file to a particular sheet that correspondswith a 1st file's sheet
Offset indeterminate amount
Re: Macro for Append to csv
Re: run vbs from vba Syntax
value input on 1 ws, find on another, put date in
Re: ThisWorkbook.Saved = True
Simple Copy Paste within Worksheet Change Event
data object / text box integration
sumif wildcard for text and numbers
Re: Highlight Selected Range Only
Re: ThisWorkbook.Saved = True
Lookup formula needed
Re: Need a little help with a custom function
html hyperlinks using sub address
Enlarge a linked window using VBA
Informal invite to "Excel Blackbelts"
Display selected cell at bottom of screen
Re: If statement with "OR"
display message box in excel(2003) using VBA word(2003)
Optional arguments