Excel Programming [Archive] - Page 5

Copying a range
How to do double quotes in "cell language"?
Class Module Question
Launching Windows Search application from Excel macro
Return Value of GetOpenFilename, Excel 2007
Excel on Mac crashes
Record Click on Error Indicator
web automation - repost
Point and Figure Excel Sheet Program
++ Web automation
Calculating Costs for Each period
Calculating Costs for Each period
Copying and Deleting Range using buttons on worksheet
Code in Excel 2000 template doesn't work in Excel 2010
Can't Reference from Webserver
changing the controls for a userform
Drop Down Menu link to Pivot
Help with Index formula
Simple Macro
Evaluate does not work
Why do I have to restart Excel when ActiveSheet.QueryTables.Addfails? Options
Fractions in a userform.
Find all in vba
Can I automate Range.mergeCells = True?
Save a bakup file when opening the file
Capitlize a column?
Formatting date as first letter of day only
Problem with the VBA / Excel interface
Worksheets
Comparing Similarity of Strings and Returning Best Match
How to: copy value from active sheet to all other sheets with VBA (in desired cell)
Copying Range but Font not Copied..
Can Excel do 'lookups' and show different data depending upon the cell with the focus?
Data Table Issues
Declaring variables programmatically
C#NET2008 Excel Merge Cell Problem
Conditional copy and row insert based on criteria
Excel, Python, Linux
Compating all rows in two sheets
Get results from Access Database.
Select Previously Selected worksheet (and/or select previouslyselected workbook)
What If a Table has a Million Rows?!
How to group my students using Excel
Range reference in array formula
Silverlight
running macro from keystrokes versus from ribbon
Excel hangs
Excel VBA Training Courses
Times before noon show different
Looping through Non contiguous cells in a row
Re: Change Cell Background
Change Cell Background
Re: Change Cell Background
Run a recorde macro in multiple excel workbook at a time
Problem with file path to sharepoint
Insert Excel Data in Oracle
Excel Database Readability in Linux?
Conditional borders
Microsoft Internet Controls
trend data, with twist
Updateing file links
What does " " turn the cell?
Help with text file
Does M.S. Project have to be installed in order to use the ProjectObject Reference within Excel to grab read-only data from .mpp file?
VBA to write Excel data to Oracle table
Average/Sum formula with offset
Capitalise on Input Q
Anyone speak Japanese excel?
From 2 predefined test data ranges, how do I detect which one has a anon linear trend through Excel VBA ?
Do Until - If-then problem
Problem using Range objects
Can't create a new instance of the Range class
Sum Dynamic Range
Recognize currency in a cell
Find item in column Copy to new location
macro listing subfolders from selection of mainfolders
Trying to print specific worksheet from outlook attachment
variants and freeing bstr memory (C++)
Excel 2010 crashes on Workbooks.Open for csv file -- sometimes
DLL not available in system32 folder - vista/excel 2007
Web Automation, Form Filling, Web Scraping with Excel
VBA Save As problem with file that already exist
Problem with printing multiple sheets-only 1 sheet prints in color, other sheets print in B&W
Pasting to a new page on existing sheet if not enough rows on the page
Manipulating embedded excel charts in Word
Frames Scroll event causing cursor to move to first textbox
Populate list or combo box from closed workbook
Simple userform tutorial
Creating UserControl with VB6 for excel
Existing sheet formatting removed when changing active cell border color
custom function - finding cell address
ListBox Remove Certain Text
how to store a macro to be available to all workbooks
block of quoted lines
How to change active cell border color in Excel 2007
Remove Blank values
SHRINK/REDUCE EXCEL FILE SIZE
Multiply Corresponding Values in Range
Convert Excel IF ISERROR formula to VBA
Re: Hi PatWith the headers in row 1 of "Sheet1" try this oneSubFind_Date_test()
Re: Hi PatWith the headers in row 1 of "Sheet1" try this oneSubFind_Date_test()
Save dialog box
Differences among VBA in Excel 2007 and 2010
Finding the maximum in an array of strings (Excel VBA)
combo box - last value
Using Collection to also capture range adjacent
Formula problem
Why do I have to restart Excel when ActiveSheet.QueryTables.Add fails?
Excel 2010 Component Id
Excel 2010 Component Id
Excel 2010 Component Id
Delete Entire Column
Summing Criteria with Index - Match
PasteExcelTable does not work in OS X
Drop down list - link to another worksheet
Filter with an IF, AND, NOT formula
Emulating Ref Edit in VB6
referring to texbox
VBA date conversion
Solution for Application.FileSearch Excel 2007-2010
VBA form imported into VB6 project
INDIRECT Syntax
Merging Multiple Named Ranges
Macro errors when upgrading to windows 7
Macro question: Using named ranges
SofTeC 2010: Calling all Testing Professionals, Managers, Leaders[Nov 20th, Pune]
Beforeprint not executing
Save dialog box
How to Schedule a VBA Macro?
Save box / file name
Prevent Coping/Transffering item twice from Listbox1 to Listbox2
CheckIBAN
HELP - Radio buttons and other controls suddenly moving in Excel 2010 only
SofTeC 2010: Calling all Testing Professionals, Managers, Leaders[Nov 20th, Pune]
Listbox
special characters, other multi-language gotchas?
Save data to closed workbook
workbook open password protected
Password protected sheet
Calling subroutine defined in another workbook (autostart workbook)
controls and dynamic events
controls and dynamic events
CSV decoding line-by-line
How can I transfer information from Excel to Outlook?
Subscript out of range
SUMIF with the criteria range
Data Table
Inserting 2 columns when cells don't match
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
make a named range with an array not using a workseet cell range
.find does not find if .NumberFormat = "#,##0.00"
Move Column Values to Rows - THANKS in Advance
Cleanup this macro please
Lookup?
Make this into a toggle command? [XL2003]
Howto populate a column with values coming from another sheet
Combining Procedures into Loop
closing a vba project - dumb question
Export to txt file using VBA
Using VBA to move system files
Set macro security level to 'low level' on opening a certain workbook.
Automatically select entire rows on pressing down and up-arrow key
Macro VBA to get Global adress List from an exchanage server
Code Snippet - Activate VBE window
Problems automating Word from Excel
Chartspace & Excel2003
Protect each worksheet individually
membercode check
Save All Worksheets as CSV
Association between cells
Delete duplicate rows
loop using double
Pivot Table problem
Why you should change your vehicle to flex fuel
How to embed INDIRECT.EXT into workbook Excel 2007
On Error Resume Next not working (2010)
Updating the 'comment' file attribute
Delete duplicates based on time
How to separate on very long line of code in VBA
Excel 2003 file header/trailer bytes?
User input into cell formula?
Which zones are touch given this range
Help with pseudocode translated into VBA Code
Option buttons not responding
ProgressBar control in 64-bit Excel
How to use MS Flex Grid in Excel vba form
ResetAllPageBreaks
issues with getting .pdfs to be created
Ensuring Macros Are Enabled
Is there a better way?
How do I view/edit code on Excel 2003 Worksheet Command Button
Why would End(XLup) stop working??
OPEN EXCEL - Needs your support and enthusiasm...
Timing Macros
paste value column based on first cell command button
How to Reference a VSTO AddIn
Intersect and Union
Multiple Conditions - VBA
Read smarttag value
Comment Box Placement
How to copy one worksheet vith command button???
macro using forms button
Non Uniform Random Number Generator
updating a safearray in C++
VB coding for complete cell copy rather than what ^C does?
non-repeating Comboboxes values
class module and encapsulation
Can you change the font and font size for a forms control ?
Can you change the font and font size for a forms control ?
Application.dialogs and PDF - again
selecting a range
copy and paste 3 rows run macro and continue to end of columns
Test if a user defined chart name is valid
Import CSV Data from Outlook Public Folder
End(xlDown) giving me blanks
End(xlDown) giving me blanks
Formatting currency with the cents but without the decimal point
What is the difference between 'Select' a sheet and 'Activate' a sheet
Wanted: Business end of Excel
Populating 2-D array w/ Application.[Function] results
VBA vs C#: filling a spreadsheet with random numbers - C# 4x slower...
Placing picture with code
Delete Rows as per Text, Font Color, Font Type, Time Format
RDBMerge ADD-IN
Setting a cell's color based upon RGB values
Text box value to userform
loop
Seconds missing from time/date properties
Userform Save data To Worksheet & File
Events
What happened here...?
Filter, Delete and Error handling - need help
Pick from drop-down list gives empty or erroneous result
Sort current range by column j
Change DeleteValue1 to named range
Help with DoEvents to show progress form, please?
How can I sum two arrays together?
VBScript help
Remove cell from range
Go to next row depending every nth iteration
Run-time-error 1004 "ListIndex method of listbox class failed"
What is the new object name after copying & inserting line?
Conditional Formatting
Macro to modify property of an object
Match and Range Reference Syntax
In Excel 2007 where is the Personal workbook saved?
Hierarchy of Codename and error catching if no worksheet.
.Lookin through Outlook
Mistery Link
Pickup Data from a Worksheet
GetObject when more than 1 Excel is running
GetObject when more than 1 Excel is running
VBA editor doesn't prompt to save changes, doesn't save
Why is my .Findnext not working?
Best way to run Find or Vlookup down specific column in range
Kind of a "reverse" Vlookup; or please help me use Find instead
Kind of a "reverse" Vlookup; or please help me use Find instead
Index and Match - Errors
help with sumif formula
application .dialogs and PDF
interior colored cells counting
VBA handle on a C# ribbon
Format Telephone Numbers
Re: Automation and XLL add-ins
Re: Automation and XLL add-ins
Re: Automation and XLL add-ins
Re: Automation and XLL add-ins
Add a sub folder
increase / decrease font size based on value in cell having a formula
Even procedure in xla
save worksheet data to alternate closed workbook - next row
Referring to ranges as Cell, Range, and variables
Using a function to return a populated array
Define a Range based on a Range object
copy/paste records into different sheets by status
Search Target <= in Col. "B" to return Date in Col. "A"
Search Target <= in Col. "B" to return Date in Col. "A"
Referring to Range addresses when in variables
Worksheet_SelectionChange Not Firing
Populating one sheet with specific data from another sheet (I'm dumb)
Excel prompts for VBApassword after saving workbook under new name and exiting excel
CommandButtons moves to another place in office 2010
Loop don't work
Change definite value to string reference for criteria
compare named ranges and list duplicates
Date format.
Insert rows in grouped sheets
activesheet.name ending in "-" &Style1
Strange pasting array to cells behavior
Quarterly Analysis in Excel
Highlight row and insert text on click
How to build a bulletproof application Using excel
Open File in Skydrive through VBA
VBA to Extract time that user logged onto Windows
PAMELA ANDERSON Showing her BOOBS and PUSSY
Semi Autofilter code
Convert Conditional Formatting to Conventional Formatting
Set range, perform operation, set new range, repeat
How to get the available languages (MUI) of Excel using VBA?
Using VBA to close a running application
Excel 2003 autofiltering options from a userform
How to structure specific macro task, oop or procedural approach?(Excel 2003)
Limit range of values for integer
How to deploy my new addin
Personal Macro Book
Working with moving dynamic ranges
parse csv file contents into powerpoint textbox Autoshapes
scrolling 2 frames simultaneously
cell comments, hiding columns, "Cannot shift objects off sheet"
Code deletes first row/headers.
Create new worksheet and use a number as its name..
Dynamic Names
Payment Coupons
Personal Macro Book
Total by Invoice Number
Vlookup using array ?
Dynamic Names
Totals rows shouldn't become invisible when filtering
2007 Table
Use VBA to Populate Listbox from Open Spreadsheet
On-screen buttons turn to white
loop through class module
Import Excel to Access (used range only)
Apply Alternate Shading to selected rows
Excel model - Very fast first time - Very slow second time
Find a date in list less or equal than target date
Duplicate Entries
Find Running Total Value or % at a given Target Date or vice versa
Range object causing Sort to fail
How to change a device name into a resource name and v.v.
using two cell references to make up the save as file name
Stopping a macro to edit the template then re-saving the macro for use
Stopping a macro to edit the template then re-saving the macro for use
Title bar not up-dating after running the macro below
password protection
Picture on comment
Generate Subtotal Summary from Sheet1 into Sheet2
Saving templete / workbook to a specific drive / file...trying again
Change file name when saved to C drive
save as cell A1 to to a specific drive
Conditional formating question
Can I do automation on Access if the database is open?
UTF-8 File Opened in Excel from Firefox Browser
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ?
Copying used range from other sheets ignoring row 1
Automatically copy files into folders
Help with Excel VBA code
Help with VBA code
count dates
PERSONAL.XLSB will not load
Mail Multiple Sheets via PDF Q
Running a Macro periodically between Time A and Time B
Referring to control value on form using variable name for control
Saving templete / workbook to a specific drive / file
Sorting problem : "The sort reference is not valid..........."
#VALUE
Auto select worksheets - and goto a specific cell afterwards
ADO question
Charts.add or ActiveSheet.ChartObjects.Add doesn't work
Group rows based on indention of string in a column
Convert dates
Comparing dates
SOS! Help! Loading another workbook in the current workbook - cellsnot updating!
Add-in question: can I store default values for a form in the Add-in?
Remove a criteria from countif based on user selection
ADO connection to a protected workbook?
How to "freeze" all cells in Excel sheets?
counting a specific "text" occurance in a selection of sheets withina workbook
Restore a range of cells to "empty"?
Let user break out of a big computation?
Macros I want dont appear in the customise box to drag to a toolbar
group of worksheets in a workbook
group of worksheets in a workbook
countif - in an entire workbook
find
ADO connection to Excel 2007 *.xlsx files?
Using an ADODB.Recordset in Excel 2007
converting excel VBA macros to VB
Excel 2007 Ribbon Will Not Re-Validate Unless Excel Window Has Focus
Can I import 2003 .xlb definitions into 2010?
How to import events VBA code in Excel?
EXCEL 2003 file doesn't update certain cells
Transpose & reorg data from 2 WS to new WB
IBAN Number
Searching a group of Excel workbooks.....
How to program with this problem
How to compare two spreadsheets
How to get a MsgBox to pop up if I have VBA write a wrong link
ThisWorkbook.Close crashing Excel (2010)
writing macro to match the group and age
Good way to open a .txt file, copy/paste all text into Excel?
Excel reporting
Expose Function Fieldnames to VBA
chart objects top
countif and vlookup
Help with code restricting TextBox entry
Filter between Dates
Any way to know when my worksheets get opened at remote location?
Resetting autofilters
Programatic access to VB-editor not trusted
Substituting zero values in blank cells
ActiveX Properties missing from menu
Excel 2003 VBA In directory Open Spreadsheets Extract data
Spreadsheet object in VBE appears with the ThisWorkbook icon
sheet cycle macro
Conditional Formatting Weirdness
Require user to enter numeric value in TextBox
Strange CopyRange behaviour
MsgBox problem
Retrieve Excel Colors
Re: Text to columns and comma delimited text
DropDown List (Validation) from other worksheet
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately?
Allow text in locked cells on a worksheet from a userform
Re: Worksheet or Me. Why the difference?
Option button enabled when tabbed to - how?
SUMIF and SUMIFS Error
Excel 97 Mouse scroll-wheel stops working after run macro- edited
Re: From WebPageA to WebPageB: Error . . . windows opener document isnull or is not an object
Adding a row with the previous one if....
Macro to line up rows
Mouse scroll-wheel stops working after run macro
Re: Filter on Day
Better Understanding of XIRR
keyboard up/down arrows to select items in this list box
Application.OperatingSystem returns what?
AutoFilter Criteria using named range
Re: How to choose Random rows??
Is cell outside printable area?
A Volkswagen New Beetle Car only for UK
sending an array to Excel
dropdown menu ? other ideas?
Excel process still shows in TaskManager
Adding string to PrintOut?
Add value to the content of a cell with Vlookup
User Defined Function - reformulated repost of an earlier question
Exporting Worksheets from a workbook and saving them as a .prn file
Exporting Worksheets from a workbook and saving them as a .prn file
Macro speed decreesing after each run
Template opens instead of copy
.INI versus Registry
Useform won't Show with dynamically added controls
Creating PDF files via 995
/ key not displaying in cell
Better error message when a user enters a value in a form comboboxthat is not valid
Problem with this code by protect sheet
Using functions
Energy Saving Tips
Need vba code to Update Data in Powerpoint 2007 charts
custom error message
Project Code Communication
If named sheet exists then delete it
macro question
adding verbiage to the end of a cell
Back up files? in excel 2007
Check if UserForm is loaded?
Clear contents of a 3-d (three-dimensional) range
vlookup in VBA
Code to display a true or false value in the cell containing a check box
HOW TO APPLY GRAY HIGHLIGHTING TO RANGE, BASED ON ENTRY IN ONE CELL
Validating multiple textboxes on a form.
Copying diagonally opposite value from the known cell/range.
Converting European number formats
To Determine the 2D array
how to compare formula's values?
Different uses of AND function
Formula,Function, or VBA
Print variable number of rows of spreadsheet
test
Dropdown list from all worksheets name in a workbook
Formatting macro runs real slow due to network printer - best workaround?
Rank Data using VBA - having trouble with R1C1 notation
Macro to retrieve values corresponding to the value selected in Dropdown box
Form, Dual Monitors
Easy way to merge 5-6 columns
count duplicats, display incremental count, restart count at changein value
Modify Ron de Bruin Code; Save Specific Files to Specific Folders
Synthetic Speech in Excel?
Employee Schedule with multiple options.
Square brackets to specify a range
Excel File; CanCheckOut <> True in SharePoint
CDO.Send failed to connect to the server
Neat code for pasting filtered data to a separate worksheet
macro is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activity log" .
macro to fill cells
Find a Pattern and Parse Text
Opening PPT deck in background
read the Windows version
ead the Windows version
Delete all user numberformat?
How do I get something like IE > View > Source . . . Navigate therewith VBA
Macros Disabled by 2010 Shared Workbook
"Set" statement with variables?
UCASE... with Office 2010
Date Variable in Macros
Help with Cell Formula
Generating XML files vs. code page.
Column is overwritten
My excel Generated .tmp file
Use "Tab" within a cell comment
Post disappeared from this forum?
Application vs WorksheetFunction
Running Batch File from within Excel
RoundDown function not working in code
VBA to read HTML; Search for TDelement
Get filtered range into array
Windows Query working on some computer, and not working on others?!?
trying to email workbook from VB6, getting error 1004
Custom Form
Reducing "Set" statements
Macro to send Workbook as Email to Users thru MS Outlook 2003
How to write a VBA function which returns an integer
Dynamic chart problem
How to use a subset of a range?
All Workbook Saved except This Workbook - Part2
Macro Help - Looping & Deleting
Function Help
help with highlight code
UDF Not Recognized
Convert a range of numbers to strings
Can I use variables in the text portion of a message box?
UDF function with Optional Paramters Problem
Help with macro to populate blank values
saving to WK4 registry error
Workbook_BeforePrint Stopped Working
Doube click cell to run macro
Dominate Mafia Wars
Macro delete columns satring row 23
Excel is Running Too Slow. Can I run a Diagnostic?
Easiest way...use shortcuts and internet explorer
All Workbook Saved except This Workbook
Import from a HTML file
Always on top and Deactivate event
how to cread invoice tracker
I am getting the following error message "Microsoft Office Excel hasstopped working", when I try to run a macro to load my Userform.
Dynamic add formula
Limited Edition ghd IV Dark Black Styler
Highlighting (formatting) 4 lowest cells in a named range to differntcolor
trigger formula execution based on user entry
Macro specifying file name when printing to PDF?
Retrieving data from online excel spreadsheet.
InputBox to resize all charts of active worksheet
Manipulating the Userform Window
error 9 - related to an array - adding delimiters back to a cellvalue
Check if an Excel or Word file is "read only"????
Not able to initiate printer from checkbox
Worksheet_change or Worksheet_calculate
VBA Validation between two Times
IE
Compare two worksheets in the same workbook and highlight difference
Macro works but also runs original spreadsheet
Create several charts in one go using VBA
How to format cells to General via vba
Excel open from VBScript does not display Windows pop-up when file inuse
Workbook Page Numbers
Cells(row, j).Interior.colorindex
Force Recalc
VBA equivalent for XLL?
delete last-line help.
Copy/Paste from Sheet to Browser; Then Copy/Paste from Browser toSheet
continue processing a link has opened another IE
consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet
Automatically changing default formatting upon opening new workbook
Import Word Table Macro running very slow
slover for a 5x5 logic puzzle.
Sum Columns with Specific Headings
To color string of variable size
AutoFit not working properly
How to read the contents of an OLEObject (dropdown list) in excel
Building a formula from another cell
Macro warning with no macros
Grey Fill for all cells that contain a certain string in hyperlinkaddress
from pivot table to vb array copy to new table
Excel Macro delete certail column's
WebBrowser
I want to loop this macro
How to properly read Value2 Range ?
Adapt this Directory Listing working code to insert a file namepattern prompt.
Re: Transpose
VBA Excal start powerpoint on mix system of 2003 or 2007
Excel Macro error
Combine/Merge Rows, Multiple Worksheets
message
How to reference a file in a different instance of Excel?
Printing page 1 from each sheet in workbook
Getting Run-time error '445'
Open CSV File
Open a New Instance of Excel
Getting to the bottom of it
just trying to copy 6 rows to the right
summing through end of row
Lookup a value within a range
To disable Right Click Q
Delete all Excel workbooks from a list on worksheet on condition.
Font selection dialog box?
Advance Filter data to store array
Autofilter with criteria from userform
Cell to macro
Adding multiple combo boxes to excel cells
parse a string and do a simple comparison
Convert A Formula to Value Until A Value is Met
Insert rows by group and copy value
how to avoid user to save in .xlsx
if I create a BSTR in C++, do I need to release it ?
Need macro code to pick data according to year selected
Use concatenated String as input to Data Validation List
Remove digits after colon
Set a reference to a Workbook w/out opening the Workbook?
I have created a vba script for a document registers
IE automation
Save a file to SharePoint
List of objects with properties & metods
For Dave Peterson
Re: Change Excel Link Source using VBA for Excel 2007
Saving a CSV file
Check an a file; SharePoint
Copy with a macro
PERL script for xlsx
IE Automation
compare column color row
Macro to copy
Open a file from share
Problems copy data when using filter in place
Check a file into SharePoint
How can I force a workbook to close?
Trouble using VLookup in VBA
Continue macro from current workbook
Re: How to save a WorkBook to SharePoint?
Re: How to save a WorkBook to SharePoint?
How to save a WorkBook to SharePoint?
Delete all Links via VBA
Advance Filter with Multi Criteria
Trying to recover deleted macros
Next Without For
Populate Listbox on Userform with file names
Macro Help : copy + selct
Input Data to Webpage
Shortening code
Problem with date formatting
Array by getrows to listbox - date format problem
Autofiltering & copying results to new worksheet - custom message box
Autofilter & copy results to new worksheet
How to replace numbers in sequence without sorting?
Count Number of CF Q
Count Duplicates
Re: Deleting blank columns
How to run macro from an exe?
Free microsoft excel templates and macros
Control program flow
Automatically create names from values in cell
Stop Auto Calculation Q
Number of months
Code for auto fill (\-) stopped working
Help- Simple function fails working with pasted values
Copying 1 worksheet to new workbook with data and formats only
Making Functions in a DLL visible to the outside world
Progress Bar won't work in Excel 2007
Split a text file with more than 65536 lines over many worksheets
Loop within worksheet array
Weird screen refresh problem in Excel 2003 - bits of differentworksheets display.
keep duplicated numbers, eliminate single occurances
download info from a web site to Excel
All Combinations of cell values in a single Column
counting CF cells
Adding New Sheets
Macro for Multiple Worksheets
Macro for dialog box from pivot table
Using a Table in my VBA User Defined Function
Delete all Conditional Formatting Q
Removing duplicates but leaving data on following rows
Turning into normal proportions
Lookup formula for retuning multiple values
Group By Calculations and Labeling
Can a Sub/Function print the names of its callers?
Function created in VBA not listed in worksheet existing functions.Pleae Help
Userforms & Excel 2002 Crashes
Using XLM Macro Sheet in Excel 2010
.FindNext problem
Disable the cancel option while saving the excel sheet-Excel 2007
Speed of Macro on 2 PC
Best Excel Development Architecture? VSTO vs. VBA vs. VB.Net/C#.Netvs. ???
Populating a form from a spreadsheet
Combing Student list and Classes they took to one sheet
ControlTipText
VBA Macro in Excel 2010 - Curve lookup
Calculating the current time in Excel 2007
Select value on a cell by matching value of two cells
need a macro to set the print range only for visible rows
Re using same macro accross other spreadsheets
Converting an Excel file to PDF Q
Code to Remove Form Control buttons Q
Transfer data from Excel Spreadsheet to Outlook
Help with UDFs in Excel 2010
Can you use ADO from Excel to run an Append Query in Access
Combining formulas
Macro to Call A Subroutine on a Sheet Sometimes stops?
How to use Excel VBA Help
Addin - Invalidate Error
Mark if checkin date is within 30 days of checkout date where name isthe same.
Return to Excel after Automatic Email
Function to Sum colored cells values not working
formatting problem
Lousy routine to get the first available day of the month
SOLVED Excel 2010 not using Options:Open Registry key to install
Excel 2010 open in full screen
Save all content of folders Alpha, Charlie on drive C to externaldrive Il
"On error" within While loop failing
Need help creating a listbox in Excel that can delete unwantedcolumns
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box
wrong Hyperlink-Values
Referencing Userform in VB6
Generate RGB combinations from Rng.Interior.ColorIndex vlaue
Microsoft Excel VBA: Concatenate without formatting
Converting Time
convert selection variant idispatch to something useful
How do i stop a clock in excel
Search array for string
BSTR to char* Help!
Corrupt xlsm
Userform problem with "Run Time Error 75"
Do I need DLL or COM Addin, Excel Addin
Excel 2010 not using Options:Open Registry key to install
remove text between [ ]
.NET "Isolated Storage" from VBA?
Problem with progamatically defined named ranges
At each change in data concatenate text values in contiguous ranges
How secure is SaveSetting?
OleObjects very urgent issue
Macro to combine worksheets
writing formula w/ variables
Macro to add up values in COMMENTs
bug - named ranges point to wrong column after being moved inside anMS Query Table
Command to toggle Control Toolbox on?
How to make ImportXML run faster
Test
Print Preview Freezes
Macro to count numbers in COMMENTS
connection form Excel to mySQL
Check that date exists
SheetCalculate fires all the time
Copy row to new sheet if cell data is repeated more than 3 times
Why is file suddenly "Read Only"?
help updating userforms
Formatting macro required
Copy files in sub folders to a specific directory
Calculation of Monthly No. of shifts available per operator forunloading work
create a spreadsheet from another app
Excel 2010 not using Options:Open Registry key to installAddins/Add-Ins??
Calling Procedure from Cell value
Where is the personal.xls file located in Windows 7?
Add "paste values" to right-click shortcut menu-how do? Excel 2010
Fill in the blanks
Locking down a combobox
Macro: insert rows anywhere in the sheet
Sort and align 2 ranges
Going to website & Entering username & password
Error Trapping Problem
trying to format if AHT is found in a range of values
Finding external cell dependents works in a Sub() but not a UDF.
Hide button in a combobox dropdown
I need to give index number to charts
Sum values in a range to a result
How to wait for addon to load
followhyperlink happening twice
Creating new sheet and renaming problem
Copy rows from Sheet1 to Sheet2 when Column B values equal "X" andColumn C values > 100
Scroll Bar- Move one cell to right
CheckBox values based on Worksheet condition
Setting a column of a 2D array = named range
help with macro for checkboxes
need help with macro (checkboxes)
Help with this macro
Renaming worksheet on the basis of workbook name
Copy yellow shaded rows to another worksheet
Combination and Repetition Not Allowed
Renaming worksheets
Button to print XLS file as PDF
Formula Help within Code
Calculation of Overlap Outage Hours
two charting problems with excel 2007
Excel weblinks live or not
Macro Doesn't Work When Worksheet Protected
Blank user form issues
vba running slower if i'm not looking at it?
Can I run a macro in an xla from a button on a sheet
Print as pdf and save as xls with filename from a datafield
copy recordset to CSV file
nested function
Mobile Locksmith Los Angeles 1-323-678-2704
Santa Monica Locksmith 1-310-925-1720
Auto Locksmith Los Angeles 1-323-678-2704
Office Locksmith Services Los Angeles 1-323-678-2704
Car Locksmith Los Angeles 1-323-678-2704
Automotive Locksmith Los Angeles 1-323-678-2704
Mortise Locksmith Los Angeles 1-323-678-2704
Mortise Locks & Cylindrical Locksets Locksmith Los Angeles1-323-678-2704
Mul-T-lock Locksmith Los Angeles 1-323-678-2704
Baldwin Locksmith Los Angeles 1-323-678-2704
Kwikset Locksmith Los Angeles 1-323-678-2704
Master Lock Locksmith Los Angeles 1-310-925-1720
Schlage Locksmith 1-323-678-2704
Locksmith Los Angeles 323-678-2704
Santa Monica locksmith, Culver City locksmith, Venice locksmith,Malibu locksmith, Beverly Hills locksmith 1-310-925-1720
Medeco Locksmith Locks Los Angeles 1-323-678-2704
Los Angeles Locksmith 1-310-925-1720
Locksmith in Los Angeles 323-678-2704
Border looping macro
Change language on Ribbon in Office 2007
how to keep the oiginal format of charts intact in excel vba afterdeleting a series ??
Simple hack to get $1000 to your home
Extract item numbers with suffix -09 and copy them below the actuallist
Excel 2003 > Disabling "Refresh All" functionnality
Select Range
resize of combobox does not work
Addressing ranges
Trying to delete sheet code with VBA
Y axys not properly displayed
Test
Vertical lookup with a lookup value that returns multiple matches
error trying to use GetFromClipboard
Fueling your car with natural gas from home
Re: Excel/Cellphone
Disable Ribbon command while WB is excel 2003 format
PivotCache.refresh not working
Can't disable RIGHT CLICK
ribbon events
ribbon events
All MVP's & regular contributors
VB copy files from one folder to other
AutoFill without sequential order
Macro to find the value of adjacent cell from a range of values
Is it possible to override totalling function/values?
Re: Need help in highlighting the cell color in VBA
How to execute macro when selecting user-defined menu in ribbon
How to get sequence number in the next column?
Grouping a range of sheets
opening other workbooks at the same time
Is it possible to intercept pivot table SSAS query or extend SSASprovider?
Regarding questions
Pulling specific Data from one WS to another WS based upon 1 criteria
Icon Chalange
Self Signed Projects
Self Signed Projects
Re: How to do this with macro?
Excel/Cellphone
Floating text
Deleting Duplicate Rows
Macro if criteria
External Data from SQL Server
Code not working in a PROTECTED Worksheet
VBA Code to select and format range
Save data before printing
Can use VSTO to reduce the size of a file?
Change event does not fire
Trouble with dynamic named range
Sort Routine Macro for Excel Worksheet
Drop Down with hidden values
When this NG migrates to forums, please consider ...
Worksheet Cell Reference
Solver
Need largest number
How to do this with macro?
Multipage, controls-collection and events (XL2003, VBA)
Compare two columns using loop.
Selecting certain Rows and Copying cells in those rows to new work
Macro to run based on criteria
Fill Down to Last Value
Sharing Macros
another filtering question
macro to insert row and type data
Copy and paste sheets to new workbook
Shading cells that contain formulas and conditional formatting at thesame time.
Recalculate a worksheet following an autofilter selection.
Passing dates to Sql Server 2005 stored procedure
MsgBox refer to seperate worksheet
RE: MsgBox refer to seperate worksheet
Environ("username") in 2007
Can I 'toggle' a toolbar button
automatically unprotect vba-project
Why does saving take SOOO long?
Sync parts of two worksheets including formats
Using counter "i" in for loop gives error
Float Menu Excel 2003 vs 2007
How to add a "running count" to cells with matching data
Conditional max
copying and pasting certain info
Functions newsgroup
Graph not plotting correctly if source not selected
How do I set up timer for sheet?
timer for sheet
Most Recent Custom View
Automatically Saving created FILE
Actively select cells/ranges/sheets and Paste Link
Actively select cells/ranges/sheets and Paste Link
Selection.Cut Destination:=Columns("B:B")
3d column chart dynamic range
open several workbooks at the same time
paste special macro stops working when run a 2nd time
Hyperlink Function
EOMONTH compatibility issue (workaround?)
Merging of rows.
How to open a password protected powerpoint file by Excel macro
Convert 24/03/2010 date into 03/24/2010 date format
Add a date to a Userform
Quiz test
Find and Replace with contents of cell
Arrays of Controls
eliminate leading quote in SAP download
Referencing conditional format is another workbookHI
date & time formulas HELP !!
SelfCert
Class versus Another Way, Wbk and Sheet Custom Data Needs
Delegate constructor compiles in VB.NET, but not in Excel VBA
User form Default value in text box
form not opening when started from command line
Variable refers to a workbook
Sorting and Date Format Help
Date lies between
Excel template similar to MS Money less investments?
Declaring Variables
Can't Edit my Excel Comments
Search Macro or VB script
Vba Date$
Data Validation based on Cell Value
RE: Select / Copy / Paste
Re: Select / Copy / Paste
How to get early filter?
Trouble with UserName
Vlookup in vba - how to use absolute rows not relative
Automatic Prompt for Users to Save
using ADO from Excel 2007
Sorting Problem
Compare and Copy/Paste b/w Two Workbooks
Where am I going wrong ?
Separate code from workbook?!
Different kind of cell reference.
Accessing the call stack in an Excel VBA macro?
Macro to filter on most current date.
"Optional" output of a Public Type record
windows resize event trap
OverFlow
"Unable to set the LineStyle property of the border class"
convert letters to numbers
I need to use the last row of data in a formula
Copy and paste to other worksheets
nXn matrix creation
How to deliver an Excel tool training
Run-time error 1004
What equation that i need to use to group in vba
A Sub in another Sub...
add eventhandler to sheet in code
Please Help AutoFilter
How to assign unit for TimeValue?
select and paste data based on creteria on previous cells
Find Min and Max in variable length arrays
select and move columns by their name in header row
Popup Menu Item
Excel 2007 User form Enter Data Last Row @Table
UDF: how to tell if optional *range* parameter is empty?
Making .jpg's
Save not triggering Before_Save event
Creating a Pivot Table via Macro - Errors on Recorded Code
Customizing Shortcut Menus
Active X Controls Shrinking on Excel worksheet
Help with this error "PasteSpecial method of Range class failed !!
Use 'like' or regex to match number-letter pattern substrings
Re: Select from a list of workbooks that are open
Summing Range
Finding File Extension from Full Filename (VBA) (2007)
Copy data using macro (with worksheet protect)
Updateing Access DB
Filter event
Scaling Charts
how to open a password protected powerpoint file by Excel
open excel 2007 refresh query from batch file
Find and Replace
List Open Workbooks In All Excel Instances?
Macro for Deleting rows with balnk cell
Copy/Paste cells containing only numbers with .50 in it
Formula Not Working Properly
Pivottable
How do I make a macro seek the botom of a list?
Pivot Table
Update link on vlookup from closed excel file
SaveAs
Update datasource links programmatically
Disable print from standard toolbar button
Disable print from standard toolbar button
Adding to a list of codes
pool league table setup