Microsoft Excel Programming [Archive] - Page 91

Re: Is this possible ?
Re: Missing code
Re: Searching for 3 Add-Ins
Re: vlookup from different file
Re: Chart or Shape Object: A Place To Stash A Few Bytes?
copying modules and links
Re: How do I goto a specific Record in my Database?
Re: Can't read file
Re: seeking John Coleman
Converting Lotus DSUM to Excel SUMIF
Re: Greater than zero problem
Re: Functions with multiple inputs?
Re: Greater than zero problem
Re: Functions with multiple inputs?
Re: Chart/Shape Objects: De-Link From Column Widths?
RE: copy limit?
RE: copy limit?
Re: Greater than zero
RE: keyascii = 13
Passing Excel addresses instead of vaules
Re: How to find the maximum from a list of variables?
Formulas in Arrays in VBA
Re: Object variable or With block variable error
Hide actions while macro executes
Send email from a VBA macro?
Re: How to delete sheets with "Ch" in the sheet name?
Re: worksheet names
Re: worksheet names
Entering Multiple Items in a Single Cell - gmail has it right, can Excel do it too?
#NAME error for user defined functions at workbook startup
Automatically insert pictures
Variant array is empty problem
Adding values to a combo box
Problems Grabbing Data from Access to Excel
Re: Reset TextBox values on userform
Auto Calculate Macro
Re: Extracting data/numerical values from a give list
Automation question
Re: How to delete sheets with "Ch" in the sheet name?
copy cell values to another workbook
Discontinuous Range via VBA using R1C1?
What's my error? - S&R macro to work on any selection, from a master list
"ActiveCell" in another sheet...
multplying matrix with constant doesn't work in VBA
What is going wrong here...
Problems with OLECMDEXECOPT_DONTPROMPTUSER
breakpoint affecting the run speed of a macro
accessing web tools
Running macros it returns compile error in hidden module
Re: Tools...References Full Path
Pivot Table Refreshes Via Code
Hide clicked commandButton
Help needed with find & Delete
Re: how to hyperlink b/w two sheets?
Auto Calculate Formulae
How to get users' range selection in VBA macro?
Re: Runtime error 75 in workbook_open
another autofilter question
converting excel wortksheet to text
converting excel wortksheet to text
Re: Names
Working with a Range object
How to substract a date in excel to 2000
How do I create a commnd button with hyperlink in Excel VBA?
Matrix Countif Statement in Marco
Re: Minimize and Maximize Buttons VBA Forms
Excel Magazine
Import of 50+ Survey Data Results
Re: Omitting Hidden Columns from a .CSV File
Re: Why is this an erorr?
RE: Relatively new to macros
paste named range data
Original Excel File gets deleted and temp file gets created.
Used to be possible in Excel97
Excel takes forever to shut down
Re: start excel in background
Re: Text string with only punctuation
Need Error Message Box In VBA Code - Excel 2000 & 2003
Reference Check
Detecting changes in a single cell without worksheet_change?
Re: email from Excel when a cell hits a specific date
Compare Validation Operator give error
Re: How to use Macro using Visual Basic
How to extract file extensions?
Simplify code to lower file size. Possible ?
ListBox RowSource set to range of in-active sheet - possible?
Re: Is there a "most popular kbd shortcuts" list somewhere?
Re: How to Create Sound Alert and Email Alert when Macro is Finish
Gray out and deactivate a particular cell when another cell equals 1
Re: Use CreateObject to add a new module to Excel
ChartObjects/Shapes: Absolute Positioning via VBA?
Assigned Macro not working
Open file from a form
Re: I used a nested IF function in excel-calculates only 1st IF?
Re: How to Create Sound Alert and Email Alert when Macro is Finish
MPORT DATA FROM MDB VERY VERY SLOW...
autofilter question
Macro help needed for large amounts of data to be averaged
Re: How to Create Sound Alert and Email Alert when Macro is Finished
txt-file is UTF8 or DOS.
Need Help Making a Macro Repeat Until All Rows Are Processed
Want $1 to appear in a cell - Text
A function to find a phrase within a range of cells and return the address of the first instance.
RE: Conditional formating
Query does not seem to work...
Create Tabs from Existing Tab
Discounts within Ranges
Formatting cell for text
range(range("A1"), range("A1").SpecialCells(xlLastCell))
Simple Paste
userfom shows up white even though it's grey designed
Copy From Combobox to Cell
excel graph transformations
excel graph transformations
excel graph transformations
custom cell color
Excel Select Case with HorizontalAlignment
Adding Named ranged for each column...
Find/Copy/paste.. then Find/Paste - not working ... at all....
Selecting list box causes sheet to scroll
Items in a discontiguous range
How do I do this?
Why does this not work
delete duplicate data in the same cell
Refresh screen with open xls on client-computer
Copy Column data to other worksheet
Extract Certain Data from closed file
Extracting text to from one cell to create columns and rows
Copy Value from ComboBox to Cell
[VBA] Convert string to Range
If Cannot find skip???
Excel / Form in website
Run Macro on Cell Change
Public variable problem
Deselecting All selected Sheets
VBA and Pivot Table Refresh
Use 1 userform for many sheets, Rather than 1 userform per sheet: How?
userform: object required
Help with Worksheet_Change event time stamp
macro/sub to copy a specific ws from source wb to open wb and overwrite existing ws
Can't get Sheet_Change event to fire - please help
Worksheet_Change
application.vlookup syntax
To send an email to a remote SMTP server
simple looping question
Multiple cells
Drop Down List and macros
Row menu Insert control ID changes
xldialog question
Sum for given date range for given item - can't find this for the life of me
ReDim an array
Pivot Table Refreshes
Formatting Rows based on word being found in cell
PrintOut and PrintPreview show only first record when printed using ADO and VBA
Validating cell contentswhen leaving the cell...
Default File path
Hiding worksheets and rows in a worksheet permanently
converting formulas to "atomic" formulas
Setting horizontal print area
Is there a VBA Function for WorksheetFunction.Text?
Refer to the worksheet containing the current running code
Worksheet_Change stopped working after sheet is protected
Worksheet_Change stoped working after sheet is protected
Anybody remember Excel4Macro's
Image on a worksheet
Relative VBA function
Two Questions; Can I Track changes to my WB that is hosted publically in a network?
Calculating the difference between cell values in different rows - Loop
How to show 'Custom Auto Filter' dialog?
Dynamic Cell Format
Use same macro on 2 sheets?
Ordering of bars in VBA charts created with ChartWizard and union()
Translating A1 format to R1C1 format addresses?
Check if specifik folder exist.
Macro to collect rows with user-specified cell value
Macro to compare two sheets and then copy if match
PivotItems Bug?!
Office Assistant Question
Can this be done?
Isnumber function - question about data type
Quick help
Accessing the Ribbon values
Changing the cursor style in Excel
Re: Returning active control name on multipage
VBA Code to read selection from a Validation List
VBA Code to read selection from a Validation List
If statement combine, Excel 2000 & 2003
Please advise on the production of a frontend, to view selected record(s) of a completed worksheet
Adding comment text - linefeed visible - why?
Calling worksheet functions from within a module
data validation & mac excel
General referencing
I am trying to select a new cell whose row address is based on a variable
conditional formatting: if no formula, set fontface to bold
Selecting simple range relative to the active cell.
How do I associate calculations with items in a dropdown list?
Worksheet and Listbox
How can I add formatted text to a cell?
Filename coding with date
UserForm Setfocus Problem
macro to intsert a word using the "Find" command to search for a word
vlookup Variables
How to Delete rows in a column
Counting Blank cells using evaluate(=sumproduct)
using a countdown variable in a range
HEADER WITH VARIABLES
HEADER WITH VARIABLES
Macro to copy and paste a user selected number of rows
More then one MATCH
error 9 subscript out of range
Pivot Table Sorting
How do I select a cell based on the Column name
New CSV File
Calling a sub
Control Source / Row Source very unstable
User Form?
Using Office assistant
how to sum one column using a second column as a condition
Envoke code with button rather than as data is entered.
Would very much apreciate some help
Filldown Todays Date
Using Time
Copy & Paste Special into first un-populated Row
Calc Prorated Cost based Specific Days in a Gven Month & Year Range.
Selecting Cells
Object Creation
Saving combobx enteries
SUMPRODUCT with AutoFilter
find links without opening file?
Adding rows dynamically via macro
Adding rows dynamically via macro
Adding rows dynamically via macro
Command button enabled dependant upon cell value
Block save file prompt in imported txt file?
determining whether all cells in a row are blank
Excel to run Word macro & Word returns value to be written in spreadsheet
running multiple macros at once
pivot table
Microsoft Progress Bar ActiveX Control - Version 6.0 (SP4) - problems.
for each chart (sheet and embedded)
Lost clipboard contents on Workbook_Activate
Extracting rows based on value in first row
Macro to replace a row with SUM formulas.
macro - compare data in cols n transfer to next row
Add Loop to code
Adding up different combos of columns
Title heading in Listbox1
Formatting Data in excel VBA
Error Application.ScreenUpdating
Color of Cell
Unable to edit DialogSheets in XLA
Comparing cells
Finding values based on current month
COUNTIF "string" in cell
Automating Data Entry (Position the cursor, insert row)
Employee Skills
First Filtered cell in range
Running macros in newly created sheets
Excel 2000 vs 2003 programming problem?
Series Collection Name Problem
Copy range
Filesearch by last modified time...
Double lookup
Number of work days (ie excl weekends)
Opening a excel woorkbook from VBA
Run macro on multiple files
Volatile User Defined Function??
Use Sort method for 2002/2003 in 2000.
name location relative
Edit filtered list
Nome utente
Volatile User Defined Function??
Summing two text boxes on a form - HELP!
naming range moves me to macro
How to switch to next window and back
Collating Collumn
COM Addin Help
edit filtered list
Macro to create Org Chart
How to write directory structure to excel file
use VB to click the submit button, pse see if you can help
Help with Code
delete row and 3 rows below by range selected
Mscal.ocx on a UserForm to return selected date to WorkSheet
Creating a range name based on cell content not being a negative value.
Selecting Background Color?
are wombats good?
"Object Required"
User Form
CODE given - Highlighting corresponding cells
Resize Property Window in VBA
Conditional formatting with merged cells
where are wombats?
How to: Assign pop up when command button is pushed
possible to save macro with workbook as add-in?
interested in wombats
Sumproduct counting blank cells, dates, capturing last row
Assigning procedures Programatically
Variable value display with mouseover
Trouble removing toolbar - why won't my code work?
using a list box to fill text boxes
how to I sort and keep blank lines in between data
Excel: How to generate a list of pivot tables in a file
Centeralising Macros to control changes
Change the format of text in disabled controls
For Each statement setup
Code to Alter value by adding 1 to value in cell 4 rows above
Excluding Worksheet from Procedure
End command not working
CommandBarControl control question when using template
Combobox list items
changing passwords
Scaling Axis via VBA?
help with altering existing code
Run-Time error '1004': No cells were found
Challenging question for the VBA guys
Combo drop down list
Calendar Control
Get single ADO Recordset from multiple Access Databases
Protect ALL sheets in one coded macro
Copy Value from ComboBox to Cell
Using VBA to split individual characters across cells
Need importing macro to recognize #*# as delimiter
opening a file problem
Update Access with a range from Excel,
Reporting on information from multiple pivot tables
CODE rectification while sorting in descending order
print parameters based on if-then
textbox to file (.txt or .doc)
Need help with formula
converting excel formula into module
Conditinal Formatting
DocumentProperty of .csv file is Nothing
Calculating chnages in time
Trying to return a phrase in one cell based on value in another
Copy method of worksheet class failed
Workbooks.Add fails when executed within IE
Can I respond by program for prompt conflict name
Set up Reminders in Excel
XLBook.Save fails in Excel 2007
Replace Chart Values with Second Set of Values
listbox integral 'width'?
Property window - VBA Editor
Selecting GreyScale
Using ADO Recordsets to pull data from a closed Excel WB.
Selecting GreyScale
Compile error
.PageSetup: Any recent workarounds for the speed problem?
Search for string in a cell, then hilight the row
Globals set to nothing
negative number
Rounding up based on a decimal value
How do you run a macro on all files in a directory?
Count and Sum the cells with color formatting
table sorting .... please help.... newbie
Recursion in VBA macros?
Protected cells
card dealing
Demand Loading of COM Add-In
VLookups on Network
To send a e-mail via Outlook which triggered by excel
Copy/paste Column
Personal file opening automatically at Excel start up
Personal file opening automatically at Excel start up
how to set a formula name by using cell values
Excel 2007
Custom Toolbar
Make Inputbox field *****'s
Problems with listboxes in connection with screenupdating = false
Can't use Arrow or Tabs keys to navigate ??
Test Message
vlookup error 2042
Import from access with parametrs
populating a listbox
Macros
email certain rows.
Graphics
List Worksheet in a Workbook using ASP
Code Question
verify external data before importing
Webquery - Excel 2003
table sorting.
lock listbox items
DateTime Data from Access to Excel using ADO
Name value position in a string of data
Start Up Position for Workbooks...
little watch
How to List the names of the subfolders present in the folder (path of folder is given in the textbox by user )
How to stop code re-running
activex message protection
Fixed column, variable rows
Creating a macro for a beginner
Open files from a dynamic path..
recursive parsing of zipcodes from a string
pse see the following scripts and advise if you can assist.
Expiring the Old program in Excel.
Expiring the Old Program on Particular date. Is it Possible?
UserForm Combobox DropButtonClick Event Bug?
Open and Close another Workbook from VBA
xl2007 Pictures.Insert Does NOT Work anymore
Recurring revenue and cost
sending mail through excel
userform setfocus question
How to copy workbook?
Option Explicit set at Application Level by Excel Add-in?
Excel Solver with VB
How do I create a new workbook from an Excel file on the web?
Search non-empty rows, compare text
Import - Access Data through ADO
Excel screen opens off-center
return cell formatting
Problems running a dos program from vba script
How to run a macro in the background & how to end it?
Can't Find Project or Library
System output in Immediate Window?
Setting aws to name stored in an array
Reference the next visible cell
Workbook_BeforePrint macro
Best way to secure spreadsheet
Email a selected range using sendmail
Named Ranges
Excel - Formatting Worksheets.
Summarize sales data
How/where can I get a digital signature certificate for signing macros so they are trusted?
copy, paste into a 'found' row on another sheet problem......
Find method, special cells, home grown function
VBA and internet
Excel data to frontpage or vice versa
How to autorun a macro upon loaded by VB6?
2007: Parent bug in charts
2007: Charts.Add
2007: bug when changing labels
Validation question - allow -500%, 0%, "=50%*50%" but forbid "A", "", " ", "-" ?
Invert a range? - I wish SpecialCells(xlCellTypeHIDDEN) exist ...
Using Variables in the sum() function
How to run a complex SQL statement against Excel spreadsheet range?
UDF Worksheet/VBA discrimination?
Array of values in 1 textbox
IF then GoTo
Worksheet_Change code problem
check to see if the value is changed ...
Last row is empty
Calendar to insert dates in a form
Worksheet_Calculate event and input data
How do I enter a function in a cell and run it programmatically??
vLookup Problem
VBA script on document open or close
Macro Newbie
Excel hanging up?
For Each loop leaves file open after .close
Macro Loop
Remove items from a listbox
Strange behavior
Open xml file in Excel
saving a worksheet using a macro
Application.EnableEvents
Excel Form With Date Time Picker And Command Buttons
Find all cells NOT containing "100%" -no loop solution needed
Change cell's color from a image file
Looping with Userform
Copy & Paste Special Using Values
random number
run a macro wehn leaveing a cell ??
VBA RC1 variables - name error
(x+4)squared
How do I add MegaStat to my tools?
Selecting range for Data Validation list
How in to parse constants in formula to cells
Add info to last row of table?
List Box
How do I add Mega Stat, under tools and add-in in excel?
Prevent getting all rows if Autofilter criteria doesn't exist
Excel Dialog being "Non-Modal"?
Rows to column
Move A1 on every thrid row to a new column
Finding last row of every sheet
Text to Columns alternative
did I uncheck something?!?!
Differences between Excel 2003 and Excel 2000
getting quered data to merge cells
Strange, code works on one computer but not another
Auto date in VBA
Employee Skills Matrix!
Put contents of a range into one variable
help with sumif formula
the differecne between two files
Counting visible cells
VLookup type mismatch
VBA color picker - copy of Font dialog combo box
Ole Object Problems
Catalogue Documents in a Folder
Excel Formatting - Think I'll need a macro for this
Workbooks, subscript out of range
Automatic Paste to different workbooks
PivotTable/Chart - Can not Group?
Creating a database from data input in template
Display values in a drop down in range
Setting ActiveCell color
Executing code in a library as a result of a worksheet change
Current file path
Print multiple sheets
Tom Ogilvy - Timer help
Create Worksheets
List of items in an array - VBA?
macro - copy, paste, convert column data
Automation: Adding Text to Cell With Different Colours
Formula problem once inserted by VBA
Excel Automation Problem
Best way to execute an SQL Query on an Excel Worksheet
delete rows with multiple criteria
Selection.AutoFilter Field / Criteria => criteria sometimes non-existing on worksheet
listbox
using 2 Worksheet Change Event in a sheet, is it possible?
Automating update between two workbook
Refreshing a combo box...?
conditional formatting Copy colour of adjacent cell
Automatically copying a row containing formula
Multi format conditional formating
VBA to manage user input in a workbook
hello, very new to VBA, (?) silly question coming.....
My Blog
2007: terribly slow
VB problem for distiller 6 and excel 2003
VB problem for distiller 6 and excel 2003
2007: .DataLabels.Position
Custom Auto Filter
Greater than 3 condtional formating rules in Excel
find range size
send sub routine variable to global
Converting string "061123" into a date "23/11/06"
Special spinner
how can i read data from a closing excel file?
Working with Worksheet_SelectionChange
Validating Input Box
Variable Execution speed of VBA Code
Replace vs Application.Substitute
How to convert Text to Numeric
Excel vba help needed
VBA Formula
Macro to design a dynamic graph
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations....
Insert Blank Row Based on Value in Column A
Decimalising RA and Dec Values
Sum above
Editing and Saving webpage
really stuck...
how to make excel simply count red x's?
How to call a macro with a flexible name
Is there a way to show something similiar to treeviews in EXCEL (Not user-forms) ?
Problems with my Work rota set-up
QueryTable connection using ADO Recordset
pass combobox as argment to procedure
Controlling realpalyer within vba
Sort with hyperlink
Control property change using VBA
Recording Macro - Excel makes reference to a specific cell
copying formula from one cell to a range
Is it a duplicate row?
Print titles
2007: Connectors IDs on charts changed
SelectionChange works only when Cellpointer is within a given rang
Advice rather than an actual question.
Testing Hyperlinks
Finding Sample VB programs
MailMerge Label printing from Excel
How to create a long validation list?
Variable Range in Macro not working.
vb.net interop
2007: new behavior of grouped shapes
Is this possible? Click a cell to run a macro
I found these text strings printed out. What would they do if used in VBA?
Retrieve Documents Within Date Range using VB/VBA
Formularbar won't disappear with VBA code
Creating Macros at runtime
Consuming DDE and providing XML
Find Duplicates Variant
Ignore duplicates
SaveAs Cell.value=filename
listbox
Saving a txt file
How to create new textboxes during runtime?When user clicks on a button textbox shouls appear.
change current cell colour based on the value of adjacent cell on other worksheet
adding to a VBA COde
Download file with Excel VBA generated from jsp over https
Specify Path / open all files in folder...
Windows Media Player
Excel selective search for a combination of values - urgent
Urgent please - Macro stored in template cannot be found
Windows Media Player
Protecting excel sheet for data input
browse for path in vba
simplifying repetitive routines in VBA
Help with Cut copy and paste...........
Cell offset for filtered list
Menu and Form problems
Help...Automate send e-mail code....
use of category / subcategory pattern with excel combo boxes - please help!
vba excel update to a database problem
Add button to worksheet cell
VBE Editor opens automatically when I run a macro
Non contiguous ranges
Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template.
match cell to range
Command Button coding
name definition
Performance question
How to Stop VBA from executing
copy sheet complete with command buttons and code into other workbook !!!
sum of cells with dynamic range
Creating A Chart With Embedded Data?
Search multiple strings Difficult to figure out
Slow Calculation Index and Match Array Formula.
Data Clean-up
Updating multiple worksheets dependent on checkbox selection
Automating Page Header
ActiveX controls only work in Single window
appAccess.currentdb() -- Interface not registered
I require some help with a section of the following code.
Copy sheet without code?
Creating Subfolders
"Continue" and Exit with For Loops
trying to find a way to make duplicates and add identifiers to a
vbBack... not like a backspace
Right Click
Navigate through selected range to store values...
Storing column() to use later
"Sort key" problem now is "worksheet identification"
set Excel.Axis properties
Macro based on cell value
Create New Worksheets based on Pivot table data
Double search
Cell format as "Text"
Excel print loop
Various different page headers for one sheet
concatenting rows for excel combo box output
How do I make my macro update each month?
Find a number of strings within a worksheet and move them to another.
Output an Access Table or Query to Excel
How to change a cell colour depending on the result?
Cell A1= range from B1-B10
problem with excel vba copy/paste. can anyone help?
sharing
Split datadump and create new worksheets
Toolbar & custom buttons - gone!
is number between to other numbers.
Test for Empty, Null, "", 0
How to set off CommandBars
Manage Word paragraphs inside Excel
Generating a drawing based on a cell Value (Repost Attempt)
delete all sheets but one
Excel 03 Active X Message
Change font color in cells - Excell 2003
Fastest reading of large text files
Export very slow
Extracting conditional format conditions for cell
Executing Userform
change cell color when result is above a certain value
Split a datadump and create new worksheets.
Date type library
Identifying formulas using Validation rule
Calculating ages and volumes: Macro or formula?
#REF! error
Optionbuttons in frame on form
Disable clipboard confirmation
Footers after the fact
Chart Source data in a closed Workbook
Iteratively removing data from a VBA array
Customize Text for Pausing Over Chart Datapoint
Select a file
External table is not in the expected format. OWC11
Converting file from XLS to TXT
External table is not in the expected format. OWC11
How do I stop Macro from affect other Workbooks
Label with Scroll Bars
Problem with formulae in VBA
Export Pie Graph Chart as Image
Last Cell
Custom Menus
2007: Macro recording not working for some actions
Custom Menus
Hide/Unhide Rows or Columns
Formating cells
Cell Format
finding multiple instances
Add Chr(10) to cell
accessing the value of a slider without selecting it
code to input date after diff. cell selected
American date conversion Macro
How to prevent broken links?
formula help please
Help with Time Stamp
Time Stamp
C++ ATL control on Excel 2003 VBA form
Error 400??
Think I may have screwed myself...
How can I do this?
How to build an RTD server from scratch?
Error on Excel 2003 Workbook_Open XmlMaps
Time Stamp
Retrieving the last save date and last author from a list of files
Need help with calendars...PLEASE HELP!
Pulling entire colum from one cell
Sheets names
Excel 2007 Conditional Formatting
Why am I getting a #VALUE! error?
Excel 2003 VBA calling VB.NET ?
Storage location of macros
Error Message at Launch
excel 2007 UDF name problem
Sort key
Build custom charts in Excel and copy them to PowerPoint
Hyperlinks
Optional Argument anomaly?
Formatting portions of cells
data from external file without opening
calling calendar, get Automation Error
Running a Dialog frame on different worksheets
Carriage return in a Text box
How do I read this VBA code?
edit filtered list
Macro for importing a fixed width text file into the activeworkbook
How do I create a mandatory field in Excel
Delete everything after a certain character
Conditional Formatting
2007: .top property not working with datalabels
Program Logic Suggestion
Menu Item on the Excel
How do I create a mandatory field in Excel
Insert Row in Excel
Merge cells
Hyperlink into Address
Find/Replace in Module
How do I copy an autofilter using a macro?
2007: Chartwizard bugs
how to hide or minimize add-in
summing multi inputs
Copy & paste ranges dependant on results from another calculation
Setting a VBA Control as a variable
2007: Legend format in Surface plots / shadow effect
Worksheet Range Question - Excel 2003
different dates from one calendar
How do I get one instance of Excel to communicate with another instance?
Nested if statements / comparing two adjacent cells and inserting row
Excel VB or Macro. Referencing a cell by its contents.
Excel Conditional Formatting
Too wrapped up in macros!
VB code needed for novice
Macros
Application.run and ByRef arguments
Make a IMAGE Move