Microsoft Excel Programming [Archive] - Page 5

Search and display based on cell value
Error 1004
formula to VBA
Re: OPEN WORKBOOK
Search letters within Words from the List
Loop?
multiple 3D equations in one excel surface chart
Excel 2007 "Protect Sheet" option not available
Controls in protected sheet don't response!!!
Controls in protected sheet don't response!!!
Event Triggered in Wrong Sheet
userform validiation
ThisWorkbook.Name returns a wrong workbook name
ThisWorkbook.Name returns a wrong workbook name
Can I refer to a sheet in another book by its codename?
Upload data on sharepoint automatically.
Re: streaming data into excel
Excel
how to print autocad dwg's from excel vba
Help with this code please !!!!!!!
How to select a workbook?
selection.copy = "picture too large"
Return cursor to proper place
missing Application.FileSearch excel 2007
Negative to zero code
Would like to locate a text box based on a search string and copy
Help to find and replace between sheets
Going through Named Ranges in only specific Sheets in my WorkBook
Get a list of open workbooks and choose one
Converting a “Delete Column” Macro to a “Delete Row” Macro
How do stop a 30 MB Excel file from freezing, while I am working i
Sorting help !!!!!!!!!!!!!!!!!
delete rows
See if cell is in Range
EXCEL
challenging sumifs?
Print all tabs to a pdf file
help with a sub
Combine 2 spreadsheets by parsing from one to the other
LOOKUP function help
Before Cell Exit
Can I call a macro from a specific book
Userform Help Please
MAX Function in VBE
2 spreadsheets - populating one by multiplys of another
Error of "application-defined or object-defined error" in Goalseek
Run Time Error 1004 in Loop
Altering Paste Data
Merge data by macro
MS Query problem
Copy data into multiple workbooks
can i sort certain entries from a big excel sheet
Can I open a combobox from my code
How to Lock VBProject Programmatically without SendKeys (Note:- Idon't want to Unlock or crack the VBProject. Just want to Lock itProgrammatically)
Find and delete rows
Scrolling Caption
.Seriescolection(n).formula - size limitation?
Copy/Paste problem from another app to Excel
growing excel database
Find Length and Format and Compare
Getting rid of the green triangles in XL 2010
Identify when Excel is displaying ### in a cell? (contents>width)
runtime error code 1004
runtime error code 1004
Using c# object in Excel VBA
Update Directory Path in Code
Run Time Error '1004'
Force increased width of GetOpenFilename dialogue box?
Pull out lastname
Run a macro upon saving
Change Picture
Call List Macro
Issue with expired digital certificate ..
Re: Finding a range and performing a function
Open workbook without running Workbook_Open Event
SumProduct in VBA
treeview control problems
What kind of workbook function should I used?
Custom Function for Pivot Table
Add-in doesn't load properly
macro based on text or number
Renaming tabs
Personal Macro Workbook
How to define the default value?
Macro for adding rows if two different columns have a value
Move columns of data from one worksheet to another in open WB
macro open tabs
closing file
macro to automatically send an excel spreadsheet by email
Count Timer Pause and Stop button
Count Timer Pause and Stop button
Function arguments prompt causing problems
sendkeys
row striping with VBA
Alphabetize Macros in a module
Skip condition if cell is blank
Skip condition if cell is blank
Macro to delete entire row
SendKeys with enter
copying the objects from a sheet
Insert a function through a command button
Startup files open while login.
How to ???
Open files while login, Pls help
Figuring out MAX LEN in a given column
How to map a shortcut key to a routine in COM AddIn for Excel 2007
Sort by one column then another.
How to redistribute microsoft.office.interop.excel?
Data Validation AutoComplete Help
Please help with Custom Views
Concatenate Macro
Hide subsequent rows based on pull down list choice - macro
Print Autocad Files From Excel Vba
Excel 2007: UDF can't reference row below 65536
List Box + Sharepoint Navigation
Case format for getting cell value from a worksheet.
Running code from userform
MsgBox; if 10-seconds, assumed 'No' Clicked
Trying again for an answer.
User selection of charts
Unhide/hide based on drop down list
MACRO TO COUNT ALL OPEN WORKBOOKS and print
Re: Copying a variable nuimber of rows
require cell input before macro can run
Re: Macro puts text if keyword is found in cell above
Re: Macro puts text if keyword is found in cell above
Open Save & Close Macro
AdvancedFilter property?
Looping Macro - Run Time Error
FOR EACH NEXT Multithreaded !
Can not show scrollbars using listview on a userform
Excel, How do I make column A renumber itself if I remove a row?
Subscript Out of Range Error
Display a filtered list in a "rolodex" format
Passing Array to function
Vlookup
if else if...
How to close excel worksheet after 15 mins? once it opened
Comment in every 10 the row
Conditional formating of cells
RE: Copying a variable nuimber of rows
How do I check error result occurring by filecopy function in VBA
Worksheet "slideshow" in Excel
How to turn off standard control functions
Copy range if column N is empty
fraction udf
Copy range based on input
Excel Data Validations
Pivot Table from 2 worksheets
Macro help
Itemize a colum and fill down
data file size increase
Data aggregation with multiple workbooks
Find matches in different spreasheets then copy and paste to new s
Copy Sheet to Desktop
WebBrowser Navigate Path
Custom Menu Bar in Excel 2007
Text to Column and Transpose?
formatting of txt file
xlFillDefault, based on values in ColA to ColZ
Adding/changing registry keys
How to count drawing object (text box) in vba
2003 toolbars problem
Comparing
Exporting to text file in multiple lines
UserForm Delete Sheet Columns
Control-Home key behaviour
How to copy a workbook
Sending data to a RTD
Can I stop the footer from indenting?
Remove Excel addin completely
Prevent user input, if adjacent cell text is identical
WordMerge
copy row heights
Unable to assign macros to a new button in the current worksheet
Choose which cell to paste data
Getting compile error on WorksheetFuntion.Sum line
find largest column width and ...
extracting data from one workbook to another
Declaring Range
Geometric progression in VBA
Workbook Macro
Private Sub Workbook
How to run a macro if I don't know the name in advance
Adding a decimal place
Display currency as calculated
Re: Array to copy columns
Speciefie table and not cells to sum
Dynamically Create and ID OptionButtons, then insert Row; Loop
VBA troubles
Sendkeys
Can I tellthe difference between 'Save' and 'Save As'?
Set objListObject
How to programme this??
File Attributes Function
Worksheet protection
please help about handling "#NUM!" error !
Search a sheet for a word
Macros on Windows 7
Select first cell in active row?
Organizing a Name in a cell
List words starting with a specific letter
Excel formula needed to round up a value to a whole number
Loop in Excel
Loop in Excel
how to perform function (e.g. Sum, Average) on VB 3-d Array
Delete Columns Macro
Apply formatting through code
Any help with inserting, copying and transferring data.
How to copy ActiveX Controls which are locked on a sheet
Combine two cells without losing data cell formats
Referencing Merged Cells in VBA
Selecting multiple sheets to print to PDF
Checking Cell Value for a Date
Excel 2003: Printing a worksheet and setting properties
VBA for All cells in workbook
Running Excel 12.0 Application on Office 2003
Help with function VBA existing code.
Any way to use "standard" Excel functions inside VBA functions
copy and paste from workbook to workbook
Linking Large Text Database to Excel
Find percentage of sums
Fire event code with Hyperlink and copy/paste RadioButtons
Re: Macro that delets rows if keyword is found
Lost X-axis after resizing charts using VB - not sure why...
Any way to show / hide sheets
To determine the font of a cell and change it if required
XL2003 to XL2000 code converson
Display Math Symbols in UserForm
Worksheet protection prevents Data Validation code from running...
copy and paste data from different sheets
use formula on external data range
how to close Read Only file without prompt to save copy
Windows key and keycode
Code to save Word-document do not work properly
Copy worksheet, trying to paste to new workbook error assistance.
Cell referencing in Macros
how to get DateLastModified name with wildcard
Limit due to selected cells
Run a sub every time a function is used in a sheet
Sub to freeze cols up to extent of data in col Q
shortcut keys
Possible disregard formatting in exception match code?
Linking Large Text Database to Excel
Excel 2003 and Gantt Chart
VBA used to resize objects?
Call Macro
Sum - to end
Non-matching cells
Create employee attendance db using personal.xls?
active window on top
AfterUpdate/BeforeUpdate and SetFocus
Trying to Modify Excel code; Pointing to SQL Server Instead of Acc
remove duplicates
Removing Command Button
Lookup Table
insert a dash
range calculate in vbe
Problems executing commands on one file from another
Create Tab delimited file with no quotes in Currency fields.
MACRO BASED ON A NUMBER OF CHARACTERS
Last Column With Data
With Sheets("wildcard")
transfer data range from criteria in 2 combo boxes
I want to format lines in my footers
Need Help! Need to Change Linked Source on Several Workbooks.
Parsing thru columns to find the last number
Referencing Defined Name in another workbook
using VLOOKUP in a text box
Screen repainting issue
Copy varaible no. of rows to another woorkbook
vbe command for making excel in the active window on top
Locked problem when using .Clear
remove crlf
How to delete numeric characters in a cell with alpha numeric char
Re: Autocomplete doesn't function properly
Re: Autocomplete doesn't function properly
Why is Excel 2003 changing the names of my macros??
Re: Concatenate then Fill Down
Re: Concatenate then Fill Down
Find value in a column and insert rows above
A generic "find" function
Get Column Header Value
When extracting from column A no data
"fixed objects will move" warning
Process all cells in a (user) selection - vba
splitting names from one cell to two cells
pagesetup.printarea cannot getting infos from .xlsx file
Web Query Multiple Variables on a Mac
create a macro with the match lookup_array is changing everyday
Automatically control the font of a cell when a function is used
Problem formatting date as "dd/mm/yyyy"
sumproduct in UDF
Displaying the arguments of UDF in the spertip
Macro to "find" the next empty cell in a range
How to bypass MkDir when that Dir exists already
Run-time error 91 Object variable [2003]
Help with activating window from Application.GetOpenFilename
Worksheet Change Event macro fails intermittently
Arbitrary data to Textboxes in UserForm
Can this be done?
Insert copied cells above hidden Named Range
Re: changing a cell to different colors
Re: changing a cell to different colors
Color change for Column Chart
limit range to unique values
Date question
Problem converting script from Excel 2003 to Ecel 2007
Excel Heiarchy and Highlight rows where certain data lies
custom color for font color and or background shading color
trouble using checkbox26_DblClick
SUMIF criteria
potential bug in copy method
Update Multiple Charts then Print to One PDF File
Using the FIND function in a loop
Z order problems
dsget
Working With Multiple Source and Destination Ranges
identifying text boxes
Select statement or me?
Range References in vba
To attach file to a workbook in a addin.
Cell context menu in XL2007
Drop down-list translation
copy several rows
how can i apply a footer in every .exl file
Save excel sheet as html then save to web useing ftp
Macros
running Excel 2007 macro in Win7
List details in another sheet
Challlenging COUNT IFS?
Amnesty Bill
VB to delete columns except these...
Cannot search forum
Formula that checks balances
Deleting rows
RE: Cannot search forum
finding unique values and removing all duplicates
Unknown object in the Project Explorer in VBE
WEIRD - Excel is Changing the name of my macro
Referencing cell range in another workbook with a formula
Array again limit
Get column of named cell
conditionally formatted list
Re: Chart events
Chart events
copy range
populating neighbouring columns based on drop-down choice
VBA and VB.NET give different results for same RegEx code
Re: How do I access a sub in a New Class
move item in multiselect listbox
Change fill color of cell
Get column name and data type from closed workbook
copy the data to all the columns
Macro executing twice??
Help in VBA code
import Excel worksheet to SQL Server table
When recording
need to sort 2 column "" as a dictionary ""
Help with Regexp, please
Ratio ??.
Freeze the Title in Excel
Two codes in one set.
Column Width
not enough resources
RE: The VBA IDE will discard changes without warning
How to look up each Excel workbook raw in another.
How to close file and hibernate?
Re: Minor puzzle: some UDF calls respect mixed case, others insist onlower case
Splitting a string into columns
Array Limit
refresh linked query
UDF
what besides displayalerts statement
Picture Orientation
Prevent copy and paste in one column
Re: The VBA IDE will discard changes without warning
Which textbox am I in?
Problem Copying Charts to PowerPoint
RE: The VBA IDE will discard changes without warning
Re: The VBA IDE will discard changes without warning
Web Query
Re: Minor puzzle: some UDF calls respect mixed case, others insist on lower case
Re: Error message on opening Excel after deleting add-in file
message "fixed objects will move" HELP!
Shape.OnAction stops working after workbook closed and re-opened
DO Until Loop
Porting a macro to 500 users
RE: Critique a function to convert time, please
Updating a Read Only file
Accessing the Data Connection Strings and Command Text (SQL) in VB
Lookup based on reference
Macro Help
Addin UDF Registration/Declaration
Use UDF In Conditional Formatting
Create CSV
range loop? help
Help with error on PasteSpecial
Textbox Validation
XL2007 (or 2003): Triggering SelectionChange event
How to copy specific number of rows from cells to cells?
Re: Does IsMissing only work with Variants?
Excel VB application
Printer PaperSize returned as a String - How
Re: Macro that searches for keyword and replaces it with ...
Simple code to find the empty cells in a range and cells with number
Limits in SQL query
Drop Down Box
Drop Down box
Search within a single cell for a character
Excel 2007 Macro Security
Copy the contents of a range of cells to a single comment(indicator)?
arrays
array values
Enable Spelling Check
Need VBA for Conditional Format of Row
Apparent Excel 2007 chart HasTitle race condition
Re: Macro that searches for keyword and replaces it with ...
Getting Data Validation to execute when using Paste Special... Val
Checking if some cells are empty when file is being saved
Re: Macro that searches for keyword and replaces it with ...
referring cell in macro function
Is there a way to speed up Calculation !!!!!!!!!!!!!!!
Setting up a macro that can be ran from any excel file.
Count Images in an Excel Sheet
scan text in cell and color part of the text
vba project password
Moving Macros to the Application Level
Can I display an open file dialog from a macro
Can you speed up this code?
Passing a variable from sheet code to a module
Re: Column Array
Help with code please
Stop text to date conversion
Hiding graphics elements?
format a specific letter by code
Help with Connection to external text data file
Re: Copy to Named Range
Converting strings to numbers
Copy filtered data (Values only)
Insert Shape Based on Cell Changes
Sort bug on Excel 2007
Click Excel custom menu item via MFC automation
find a non-empty cell
Re: Who is in a network shared Excel file
Matrix inverse with MInvers, help please.
Check to see if subtotal is expanded
Problem with file links changing
copy multiple rows
Array problem? List comparison?
Compare two lists and get differences
Case Method & Range Object Problem
Tweak to display autoshape
Insert character using Regex
How do I create a hyperlink with a macro?
Pop up message asks if I really want to edit the live office data
Sort Worksheets Numerically
names in file name
Using iserror with greater than
Re: Excel Export to Access via VBA
Check for other open wokbooks
complex formula
Sorting question sort of
Copy a Sheet to an AddIn
Help with sorting data
Textbox (Object) Right Click Menu - Disable Cut
Pointing specific textbox
MsgBox Loop
Count the Colorindex of a cell with a conditional format
Re: SUMPRODUCT is not working
RE: SUMPRODUCT is not working
RE: SUMPRODUCT is not working
Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
Using vba find
Re: How to find all UDF calls in all workbooks
VBA to open a PDF, print, then close - Stumped
A macro for converting formulas to formula results only
Macro to save a workbook
Insert character in a cell using a keyboard shortcut
Checkbox values
Hide Columns Based On Date Value
Color Definition
auto copy and paste to another workbook by using specific titles
force recalculation of function
quicker cell concatenation
Re: Calling one UDF from another in a different module
Find date in row and move to cell
Detect macro in excel file without opening it
Save as vba excel
Evaluate VLOOKUP in cells in column
Re: VBA source or reference
Selecting a cell according to the cell value
NetDDE
HOW: Click Formula Hyperlink To Trigger Macro
Re: Is the MSFT online help offline?
RE: How to find all UDF calls in all workbooks
moved macros to new book now they don't work
modify formula
Autofit
Establish if Offset RANGE contains text
declaration help please
Insert an autofiltered range into another tab
hours / minutes
hours / minutes
programming 33 tabs with 1 chart on each, 9 series lines per chart
RE: Is the MSFT online help offline?
automatic replacing of a VBE sub in all open workbooks
Insert Formula based in cell user clicks
Copy problem between worksheets
Turn a range of cells into 'read only'
Ignore Blank Cells
VBA code to protect cells Outside a given range
Loop Through Range
Print Wide html reports using Excel
Print only the used sheets in all open files
2 codes in one sheet
Change cell font color when cell is clicked
Wrapping entries in a ListBox
Lose info upon activate
VBA Code for Pasting Contents
VBA Code for Pasting Sheets
Call a Sub from another Worksheet
Counting rows and inserting blank lines
Macro not saving as
Insert Pagebreak in Word document
MSGBOX Run-time Error '13': Type mismatch
Excel VBA 2003: subroutine to reorder conditional formatting rules
Excel VBA 2003: how do I call an Analysis ToolPak function within
Protecting range limits
ADO connection Problems between excel worbooks
Avoiding #N/A result
Filter by error
Inverse Matrix
Column Coding
Copy image in excel to publisher document using vba
Comparing two worksheets
auto_close give me additional information?
is it possible to run code written inside a cell
Formula- to create drop down down list based on diff criteria
Combination to Two formulas with the Help of AND / OR / IF Functions
Re: Is the MSFT online help offline?
Auto closing UserForm
LoadPicture() error XL2007
Fill Down based on count in another sheet
Search multiple columns
Save all codes in a plain text file
Combo Box question
Autoadjust range declaration coding when inserting rows
moved macros to new book, now not working
Worksheets and Events
Slope from a range of cells
Adding Chart problem
Print all open files
Re: Can I get Excel to recalculate just one cell?
Re: Can I get Excel to recalculate just one cell?
Autofilter question
Open Multiple Files At Once
Find and Replace using a Loop won't stop
RE: Can I get Excel to recalculate just one cell?
Re: Can I get Excel to recalculate just one cell?
Re: Can I get Excel to recalculate just one cell?
lock first row and first column WITHOUT selecting Cell "B2" first?
Show Application via Automation
Re: Automating a copy from Excel to Word
Collecting data for MPG (miles per gallon) calculation
Before right click:
Lessons Learned
VBA to export large tables from Excel to SQL Server
Edit Query
Open Workbook to Specific Cell
How to limit number of Message Boxes on Validation Error?
Add Information Box to Macro
assigning variables
Compare Names in a column and create single list with adjacent vla
Color Variation
Unlock cells based on colour
Unlock based on cell colour
Delete space and restrict text length
Multiple reference locking/unlockng in formulas
Help, help! desparate for formula help!!
Cannot write the contents of an Object to file
Menu Add-in
Initialise the registry values in a array and retrive the values asrequired
Range Vlookup
loop thru cells to find matching record
moved code to new book - some doesn't work now
Loop in Excel
Adding to the cell value with a macro
macro trouble
Excel and Windows Live Mail
Re: Using autofilter in VBA
C application connected to Excel
Delete contents of cells in a range based on value of a cell
Tagging formatting (cells with mixed formatting)
Determine if the Excel Version is 2007 or previous
Formula ?
loop VBA request
loop VBA request
calculate number of days formula
slection change to make the selection go down 1 cell
selection change macro to go down 1 cell
Suggestion for Macro to Delete Dups based on all fields
Graphing a bounded region with a twist?
protect macro from a different users access
Code in a macro to branch to another macro?
how to brake a excel sheet passward
Make code aware of the workbook file name
Floating Text Box in Excel 2K3/2K7
Select the UNIQUE vendors name
Protection Macro Causes All Workbooks to Be Locked
Dynamic print range using macro and constant print area.
Extracting First Name from cell with first name and last name
Ideas for an alternate (faster) approach to sumproduct?
Open VBA Editor?
2007 Sharepoint XMLMap
combo box
hidden character in Excel
Need a code
If cell contatin string like .... copy in Offset mode
RowSource
Remove unnecessary rows
Auto Fill Cells
Auto Fill
Excel Macro Problem
Formula to format selective part in a text
Classification
find format syntax
Deactivate macros but reactivate again once another macro is run
Start of macro via desktop icon no longer work
PivotTable count unique
How pass credentials to Access from Excel (for onward use)
find range question
Formulas In Cell Comments
Hiding a dropdown menu
NetDDE
Unhide rows in an Excel Macro
Conditional formatting?
EXcel Chart Size Probelm with Printer - Please Help
Move all except latest to another folder
Stop duplicate record
How to hibernate Windows XP at the end of macro?
Macro buttons
Using a List Box to filter another List Box
Excel macro to Automate ppt
Hold shift to stop Auto_Open() not working in 2007
Sorting one worksheet from another worksheet
disable pageup and pagedown
Form and tabbing
setting more than one filter
date data type is not a date??
Listbox ?
Merge Curves in Excel Graph from VB.NET
Retrieve Formula Result when Saving
Unexplained change in variable
how do i change tick marks of excel graph from vb.net
UDF XLA and SQL queries
Excel development tools?
Verify Input
Create a small table from a large table by skipping empty columns
Finding new records in subsequent reports (XL07)
deleting unwanted columns in multiple worksheets
.addline error duplicate name
Help with loop-I'm stuck
Excel Save problem from C# application
Excel object model reference no longer available?
Insert comment into cell
Inserting the values of a formula using vb
Programmatically Adding a Worksheet_Change Event Procedure to a Pr
Change to different active printers on different PC's
How do I retain formatting?
multiple crieria searches
email sending to a group name error
Variable Range Sort
Using VBA coding to count color Occurrences
macro to apply only to even number rows and NonBlank cells
userform problems with copy/paste and drop-downs
restrict textbox on userform to mm/yyyy
VBA Pivot Table Change Criteria - Help?!
Excel 07 - doc insp says there's a hidden worksheet and there isn'
From ListBox selection >labels on userform to show sheet cell valu
Keep text box visible
Exclude one folder in a filesearch
Opening .CSV file
Macro to copy and paste all rows of data in between two words
Macro correction needed
Excel 2010
Re: Insert Page Breaks code is not working in Excel 2010
Workbook properties code in the xla addin
how to disable print button in preview
Simple... Using FIND, I need to get the row and cell
Re: Best way to package workbook and UDFs
EnableEvents = False not working ???
Self Closing MsgBox
ActiveWorkbook.Save saves to wrong directory
Complex Copy/Paste...Then Arrange Results in Columns
FormulaR1C1 using variables
Word table to excel
Re: Best way to package workbook and UDFs
Highest Value from Excel Formula
Pairwise comparison using excel
initialize userform code not working first time
Need Help With the SUMPRODUCT Formula !!!!!!!!!!!!!!!!!!
Needed Macro and Function Help
Excel Convert text to Number
Deleting columns if value of cell is not matching
RE: VLOOKUP related question
Add an asteric and let user input a number
DSOFile.dll error - The document is not an OLE file
Recommendations
Link error/Warning using macro in files converted to Excel 2007 (.
Sub menu
Put a single quotation mark in front of numbers in selected cells
Borders to every 8-th row
Sheet Cleanup Help Please
Macro to change column width and active window zoom as columns areselected
How to write to file the contents of a generic array/collection
VBA Editor Menu
How to find default property for particular object.
Faxing from Excel?!
Opeing PDF's withing a MAcro I have written
Match formula to match values in multiple columns
Error
Warning off by deleting a sheet
find by concatenation of cells
Average various variable ranges
How to detect merged cells with C#
Re: VBA: How to match two sets?
save a particular column in notepad
Macros missing
Re: VBA: How to match two sets?
Run Time Error '1004' Application or Onject-defined
Help with code
Count previous 30 cells two sheets
Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
Search and Replace, or Add New Row
excel extract data from one sheet to another
autoscale stock chart
Help with my macro
How do I make a golf handicapping form in Excel?
AdvancedFilter syntax
Object Browser
Adding code
Macro Order Rank
How do I apply State O Maine 5% Sales Tax schedule to $ amounts.
Find and loop help-multiple columns
Using VBA to create PDF - setting paper size
RE: Get user inputs
Substitute c. for something else
input box prompt
inputbox prompt