Excel Programming [Archive] - Page 18

Getting count of entries in a column
Automating complex workbook
Spell checking a TextBox
Sending range via excel macro
Excel 2007 and macros/functions
Slow Macro "CheckSum()"
How to avoid selecting an object?
Check Postcode and suburb
ARRAY SEARCH PROBLEM !!!
Anyone know Excel equivalent for Tools-Options-Compatibilty-Font Substitution ? Thanks
Loop through sheets and create a small PivotTable on each
excel form populating in access 2002-03 but not 2007
msAccess Report Header export to Excel
Form question
Command Button Ctrl+Alt+Shift_F9
How do you get Excel to refresh data on Worksheet from within VBA?
Updating Multiple Worksheets With Live Market prices
Macro Trouble with Numbering Sequence
Count to Table Format
Add/Update data stored in another worksheet
create new worksheet"ERROR"
Change color of points of scatter plot
HyperLink _ to show detail?
Excel macro programming question
DatePicker control lost in Excel 2007
SPREAD SHEET FORMULA
Syntax for AutoCad File Type *.dwg
Move active cell through current selection
querytables.add..Invalid argument for URL connection type
Add Macro Hot Key
Automatic row heigth
ERROR 424" OBJECT REQUIRED
Import Data, using a command line switch
connect excel user form to access database
Print problems w/ charts excel 2003/2007
Secure Data sheet from users
Code to get ActiveCell to start a Subroutine
confirmation window once user clicks submit on user from
Export data from excel into an existing word document
Is this possible in Excel (User Form)
Trying to get info and control a "child" web page
Untick a Checkbox on a userform
Monitoring progress of Excel/VBA routines with a long runtime
Object Library feature not supported
Add Total to End of columns
Run-Time Error "9". Subscript out of range
Need VBA Code to check if MSOutlook is open
Simple Answer ?
A macro (or other) that limits the number of computers a file can beviewed on?
macro to delete all labels
Add data at top of text file
Conditional formatting using text
saving a file using a cell for file name
automation of formatting
hide rows on different sheets
Hyperlink
how to cast in a select
Autoupdate data in a report
Split worksheet into multiple worksheets
page select in multipage web site
Save clipboard images to file
Repetitive block of statements
Problem with Font
Moving Focus On Web Forms
Complicated search and complete analysis on results
Environmental Variables
How remove invalid references in Tools>References drop down box?
Help with macro - deja vu
Another Try - Calculate from ActiveCell
Named Ranges in various sheets
data validation in excel user form
Copy Data Between two Workbook
simple macro?
Take From Text Input and paste to Cell on Worksheet
Customized Sum
Disable auto open
Set Tab Order in User form
Text box in excel user form
mvoing picture
Save a file as
Automatic Data Management
CSV Help needed
String Handling Discrepancy 2003 vs. 2007
help with merging worksheets
data populated multiple times through excel form
Basic Formula Question
ID and access currently active web page (in IE6)?
VB CODE EDITOR
Hotkeys
Format Pivot total rows
Hyperlink -Syntax
radio button help
coverting all *txt files in a folder to formatted .xls files
check to see if a file is open
'For Loop' For Selected Sheets/As Named In A Range
for next loop not working
FV function as an algebraic expression
Transpose cells - do I use Paste Special?
Read MHTML document from Macro
Relative, Offset, ActiveCell
Splitting data into seperate worksheets with data change
Put a formula in a Cell through VBA
Cell reference using INDIRECT?
Find/Replace Macro; Need Loop
clicking cancle button still populates radio buttons, check box in
V Lookup between worksheets in same file
If the chain of characters found, then...
Any ideas
Any ideas
timeline
make button invisible
VBA/Macro help
ws.Range("C51:S67").NumberFormat ?
3D Array Payroll
Function Help in Add in
Sheets(s).Range("A4:A19").Select error
Getting input from combobox to update sheet
Wait number of seconds in A1
Save as
Hireing an excell programmer
Tweaking Macros
open a workbook without running Workbook_Open macro in E2007
return top and bottom row in window
replacement for msgbox
Constants
Where can I learn to program VB?
Set an array to zero
Prevent insert/delete rows - sheet code
Textbox KeyUp event
Split cell contents and sum numbers
Re: Cell name to change name in codes of command buttons
system assigns work
Copying rows based on four digits and finding a match
Iterate upon opening - DA
combobox close on mouse move
Do Until or For Loop
Issue regarding Regional settings
Making a msgbox return a value in one cell, when data is searched and found in another. TIA
Still more on loading a .CSV into a .XSLS
RANGES AND DYNAMIC ARRAYS!!
Re: Can you stop a Msgbox from making a beep sound? Thanks.
Help to repeat find on button click
Barcode Scanner
vba code for finding the ranges between 2 cols
Can't stop a clock
user input recorded twice on excel sheet
how to zoom into excel line chart with about 2000 point tia sal22
Displaying Name Box Contents
checkbox in Excel form
Using Forms combo box selection
RE: Excel Number in a Column
Excel Number in a Column
Dynamic Scroll Area
Does size matter.
calendar pop-up
sub for calculating distance via post code / variable range.
AutoFill a large list
Error on sh.Paste sh.Range = ("A1")
Private Sub Workbook_NewSheet not firing when new sheet created fromcode
auto save shared workbook
Button Focus
Lock and protect ranges
Put password for excel file in VB code
Error handling best practices
Conditional formatting based on numbers in columns
Delete Row If--> Data aggregation issue
Unexpected Behaviour of _ExcelObject_WindowDeactivate
Change Event and undo stack
create dynamic comboboxes
create HTML from a range
Ecxel 2007
Ecxel 2007
Parallel port control with Excel 2007 VB and Vista
group/sum in ms query
Calendar Not Appear On First Call
User input into Macros in Excel 2000
Moving worksheets using VBA
Pattern match and grouped items
Macros
search function
Error Handling
Re: Can you stop a Msgbox from making a beep sound? Thanks.
Open txt file using vba code
Cannot Dismiss the MsgBox
Excel AfterUpdate...like Access?
Error Message ...move or copy contains the name xx, which alreadyexists....
radio button problem
Find First Cell With a Font ColorIndex =3
Copy to worksheets
Adding Controls With VBA Code
Cumulative value in a single cell
Re: How do I reduce 10 Sub() into 1 Sub()?
chart to email
How do I reduce 10 Sub() into 1 Sub()?
Print All Sheets-Select Printer First
Finding next unhidden row
Auto save question
Mileage Rates
Running a module from within a UserForm
Turn off the multiple sheet selection
Extracting individual bits from a byte
Avoid paste error if nothing was copied.
displaying an empty cell
Hyperlinks not sticking when auto importing data from another work
Re: Time in a TextBox
Time in a TextBox
Data Validation text size
Footnotes in Excel (not Footer)
Modify Ron Debruin Macro - Prompting for range
Unhide a Label and TextBox
Automation of worksheet protection from Access VBA - can't insertrows afterwards
Hide Macro
Macro Problems when coverting from Excel 2003 to Excel 2007
Macro to run external application and login into it.
Treating WorkSheet As MS Access Table?
elliptic integrals in excel?
excel internet explorer interaction appearance
Validation list
Adding Time
Excel- Go to Previous Sheet
Print files in separate folders-please help
Chronicle value
What has the User selected?
Range Syntax
Keep lot of sheets Displayed and Hide Other
Updating a userform
Special Copy, Paste Special macro
open / close files and display names
Smart four digit sorting procedure
Using a date to move a Worksheet
Radio Button output
VB CODE ERROR
Sum
Array in User Function
How can I make an error message pop up for a user?
Remove all column and row fields from a pivot table
Runtime Error 9
wacky sort order question
Q: macro - enumerating in Excel
Q: macro - enumerating in excel
RE: Return name of current worksheet
Return name of current worksheet
Up date a value in a text box
Modify a Macro - Copy Tab Name and Add To Column A
>3 Conditions for Data Validation for a List
count work days
Error trapping
PasteSpecial Error
vlookup macro...
REARRANGEMENT OF CELL VALUES !!
How to autoincrement with Leading Zeroes?
FileSystem Object - Return Internet Address
AUTOMATIC DATA ENTRY
Loop through date range, but skip down to next year
RE: Join multiple rows data into one row
Re: More on loading a CVS into an empty formatted XLS
RE: WEB HYPERLINK IN VALIDATION LIST
Iterate over undefined number of variables
Corrupt Visual Basic Project?
Filtering using critera
help with prompt to pull wed address
Checkbox font now very small
determine if activecell in specific worksheet and column
Vlookup/Index multiple criteria query
page select in multipage web site
Matching cell data between 2 sheets!
ActiveX error using Datastream in Excel 10.4302.4219 SP-2
Enable page area of pivot table on protected worksheet
Recording Macro - Insert Formula
Specify Row
Appearance of wizards and formula bar
Print is paused by msgbox!
Sheet change event not fired when showing a userform modal
Current Control Object ?
microsoft office spreadsheet control for powerpoint
Writing VBA Routine in XL2007 to run on XL2002
Active Folder Name
Extracting Mailboxes using Macros as in Pivot table?
EXCEL 2007 - 15 minutes to open workbook
Addobe PDF printer
prevent date change
hiding unued rows and column
query refresh question
worksheet lines
Automatic Data Update
Userform Error 91 and 438
Inserting Images from certain File Folder Take2
Cell Links disappear when objects are hidden/unhidden
help with macro
Change "Text Like" to "Greater than"
Intercepting F1 from custom ribbon group
connect excel form to access
Auto Change Notification
Excel crashing...
Copy and paste over existing file?
Excel 2003 Refedit Invalid Argument
troubleshooting excel files with links 2003 to excel 2007
custom toolbar
Link from Excel to Sharepoint list
Macro to Close Workbook Without Save Any Changes Made
primes
copy data to another sheet
MSCOMM
COMBINATORIAL SUM !!
find and compare data with few workbooks
Is there a user form control for selecting a time?
pohyb mezi sloupci a øádky pomocí kurzorových ¹ipek
Protected Sheet and allowing External Data Refresh
select columns to create new workbook
RE: Code doesn't work from in Office 2003
Code doesn't work from in Office 2003
locked VBAProject problems
Having trouble pasting to first empty cell
Sort by Rows for a selected range
To reconise text or number
Validate Cell Value
Is this expected behavior?
Variable Problem
numbering worksheets in workbook...
How to write a cell with microsoft interop
For/Next Is Not Looping - Only Deletes First Instance
Sum or Count?
My attempt to do a Replace
Take Action on Cells within Selection
Re-Post Find value of cell in another sheet
Locating Specific Row
Keydown issue
Excel 2007 FileSearch
Queryclose
Formula for adding when cell is based on drop down choice
Windows error
help: sorting rows by lesser value of two columns
Unique count and date associated
Importing multiple files
select multiple named ranges with macro
getting Run-time error '1004' Select Method of Worksheet Classfailed
A quickie for you
auto populate access database from an excel form
excel licensed to name
hyperlink cell to word in textbox
conflict of one loop to another?
More functions
Find value of cell in other sheets
Error 1004 - Autofill
Sheet Sorting Event
Autofull formual
Re: Converting Excel to html file
Converting Excel to html file
Importing XML with partial file name
Re-Post: Help w/ WeekNum UDF
Number of Specific Day within Dates
Create a warning message
User form - How to store data on press of enter key.
How to Check cell column A and add 1 to cell of column D by using Macro
sheet tab with a module name
Siva and surya
increase decimal
If nom one answers a problem here, where's another place to try ? Thanks...
VLOOKUP PROTECTION ISSUE
Can you search for lengths with find command?
Populate Adjacent Cells with value after selecting from dropdown
A macro that will break a link to another workbood
Using for loop counter as a cell reference
Re: Update a date into the same cell?
build automated scriptor to import data from website to excel
User hits Cancel
Using for loop counter as a cell reference
Transferring monthly figures to summary tab
Excel help with VB Script
Pick time from cell
Extracting Data Without Opening Workbooks
Using numeric pad - key in vba
Error 1004
prevent date change
Excel Version
copy to new worksheet
ActiveWorkbook.BreakLink runs but doesn't work?!
Macro to create a list of unique value in a given order
Write a macro to find smt.
Database macro
Reset userform?
Unicode Character
Checking for duplicates
Selecting multiple named ranges
Updating Names or Cells in a File
Add msgbox to confirm reset all
Auto fill adress field in Excel
Excel (2003) VBA: MSFlexGrid control load failure due to security
I've Created DV Boxes - Need Additional Help Linking Data to them
Copy Column Formats
Summing time, by time...YUCK
Warning in .xlsm file
UDF weeks of inventory calculation - lost on how to create this lo
Load a CSV into an empty, formatted XLS?
Copy columns if
Help with formula
File save as
Using ADODB in MS Excel.
conditional formatting
Help needed re: nested conditional formula
Macro to insert rows and concatenate text
find time value in string
Re: prevent date change
insert blank row
Working with the now function.
Automatically displaying text in a form
How to create a command button
Add Hyperlink to Cell
Blank cell
Dropdown List Add New Feature Needed
How to write a for loop to get the range between a ,b columns
Application.EnableEvents = False not working
linked gif instead of imbeding images
Creating Compiled Word Lists
Re: prevent date change
equalise text length in combo box
Prevent a command button from being clicked twice
command button
count if for 2 conditions
Replacement Code for Excel 97 Users - Join function
Run Macro when Excel opens
Control Text Box Data Transfer
how can I print a worksheet without printing the first page?
Auto Date
highlight based on criteria in string
Conditional Formatting
Compile Errors in Excel VBasic
Microsoft Excel 2007- XML maps in my workbook are not exportable
Open Access query from Excel using parameter
Excel2007 Conditional Formatting Slow Performance Issue
What is meaning of programming in excel
Issue with numbers and Time
assigning values to cells in worksheet
Wild Cards
Make a check box run a macro
delete modules
RE: DisplayAlerts = False not working for cell overwrite
DisplayAlerts = False not working for cell overwrite
userform and events
opening file by a macro (in Excel2007)
Formatting Column Headings
Request for Postal Codes
sub to get post code to post code mileage from web site
Convert Date into words
UDF FOR DEPENDENTS
Modifying regex to accept comma's?
Export from Office 2003 Excel to Access
Custom List
Need help with If statement
If statement
Macro in 2007
Re: Automating a process that uses an add-in
Conditional format disaster in 2007
insert format after specific time in string.
Separate
Overflow Error
need code to copy/move data between sheets
Skip Override Prompt in Macro
Help with formula in vb coding
Find Space from Right [in cell formula]
name sheet as yesterday
Import matching up the Headers name instead of the Column letter
Can't see the Accelerator line??
How to program this?
how to program this?
Overflow Error
filtering in multiple sheets
Macro to insert a period for single characters in a string
Do Until Loop
listbox
Feuding SORT - hasformula code
auto name each new sheet based on cell value
how to program this?
Row Height-expand if text wraps in a cell
update excel form macro
How do i create and run an outside procedure?
Code Works Fine in Excel 2007, Excel 2000 generates Runtime Error 438
date filter for yesterday and today
Import from another file
Automatic Date if data entered in sheet
how do i release ram after running a procedure in excel?
open message box before the update or dont update message box open
Deleting custom menu item createt in VBA
Error 1004 - unable to set the FormulaArray property of the Range
Copy & Paste
event before open
Weeknum UDF help
Computing Average
Gets Data Validation Services on 60% cutting rate
Help in Excel
Complex macro - Any ideas would be great
i can write a formula in cell but it can diaplay in formualbar.
Print Page Dependent On Code
Rows
imageMso name Required
Call macro in other sheet
Pension contribution
collection question
Testing for text using VBA
auto populate a field based on other fields
Look up Pivot Table Data
Macro not working in Addin
Fill blanks with find results
Microsoft Script Editor
Move selection after Enter
Macro or VBA to Clear Contents of Rows By Date (Starting At A5)
convert "1.30" to "1" and "3"
VBA convert Time to Military in the same Column please
autofilter
retract dropdown for combobox
Hide row automatically based on date
VBA - loop that arranges rows
Object Required
Active directory
Protect - Unprotect code location
modifiying a custom lookup function
xla management
File name extension
Number Format - Combine Currency Symbol & Scale
RE: Excel 2007 versus Excel 2003 : Speed problem
IS THERE ANYONE WHO CAN SOLVE MY PROBLEM ..(JOEL , MIKE H , RON ,PETER , BOB) ANYONE....
Date-time updates every cell?
Replacement solution including searching in subdirectories
Chart question please help
Excel SSAS Data Connection Wizard
Repost.. I think I'm too impatient :-)
C-DLL-VBA to excel (strings)
Excel Hyperlinks not retained when copied to new Workbook
Code to link Pivot page fields to DV Lists
Can A Workbook Delete Itself
Re: Selecting worksheets
BuiltIn dialogs value
Selecting worksheets
Re: Change the color of a range of cells.
Change the color of a range of cells.
Save File in different way
Excel Option Button Does Not Work
Userform listbox font color
In textbox required only number without decimal
Combo Box Unique Entries
excel - outlines
Range Name problem
Based new sheet names on cell value
Complie error: Expected: end of statement
Macro for Calculated Column using Subtotals
Format a cell
For Each Column
Moving entire workbooks scroll bars
Macro to fill in 1 of 10
Want current date to autopopulate a textbox
Refer to a different worksheet
Data Import from External Database
Save Workbook with existing Name in the Folder
Within Tolerance ?
Excel Macro to delete between 2 defined points
Hide sheets and allow form
MS Excel/Power Point 2007 using OCX - Windows 7 (32-64 bit) ?
How to refer to a cell from another workbook in VBA
Filter using Criteria
Adding 'dynamic range names' to the 'Edit > Goto...' pane
expiry date counting down
Referring to value in range
Search SharePoint for Workbook
UDF to return text
File Open (via browse) and then run my recorded macro
Help with Range.Value2, Range.Text and UDFs
Index and Match
Change Tab Order of UserForm TextBoxes Conditionally
Append to an array
Change Comment.Author
convert first 6 digits into date
Sub Sum
Code problems for pivot table
Reference issues in Excel 2003
How to return a Range object
Hide rows of one sheet based on values in another sheet?
Making a sub run in a particular folder
Retrieving Excel File extension based on XL File Format Enumeratio
Autofilter using range from another sheet as the criteria
Put worksheet names from inactive file into cells of active worksh
save workbook on time
Why am I getting "Code execution has been interrupted" message
ChartObjects
Target Workbook Dialog
go to a page in a pdf file
Programming a pivot
Set to Break on Unhandled Errors via VBA
Get data from web
RE: copying down the formula just for data
copying down the formula just for data
Subscript out of range error
Controlling Insert Copied Cells
Listview checked item
Pull login time and windows username
Grouping rows in Excel with the plus/minus icon in the first row
Target workbook dialog
Getting wrong last cell when using usedrange in macro in Excel
Hiding worksheet
Why Would Add-In Macro Not Be Accessible?
Respond to a Display Alert
Activate Workbook via UserForm/Listbox ???
userform and error excel has stopped working
Rename a control - checkbox
Hide screen refresh
Writing Array formulas in code
How do Excel display Cell values and stores internally?
GetObject to Open Word containing Macros
Excel 2007 corrupting shared formulae in worksheet
import search result from a website
Load Macros from xla on open
Display of totals in Pivot Table Columns
Pension computation
printer spooler
YYY-MM-DD format is changing when convert data to Flat File
Age computation
Percentage calculation from cell to row
Excel To Access
Office 2003 and 2007
macro to calculate average on varying sized rows with missing valu
Business Object in excel
skip & hit chart for lotto
Sumproduct() - Need for speed or change
Changeng yes/no msgbox button names
Why do I get Code Excution has been interupted
Formula to VBA please
Code not working in Excel 2007
Count Num and Sum functions as a variable
Why is this not working for me? (read message pls)
Excel Data Outlining
Drop Down List Format
Finding and deleting text in strikethrough
protecting worksheet tab names
PLEASE HELP! Autofill Row Number (Second time posting question)
RE: Export Custom Form, .frx .frm files
error 1004
Close excel in vbe
Need help in merging cells together
How do I, in VBA, test to see if a cell has a specific word in it
Corresponding numbers in a list box
sum formula and if
I have to run macro twice to work? Why
need code to copy/move data between sheets
Page setup too slow
UserForms - disabling the little x
Text Import Wizard Breaklines
Excel Data Truncated to 255 Characters
Looping through Worksheets to create Summary Page
type mismatch on find function
error when running macro from another workbook
RE: Cleaning up code
Cleaning up code
UserForm Filter Combo Box List
new approach
new approach
new approach
Sending each spreadsheet via email to a different person
Combine Records; Difficult
Put No. in Offset cell when value is entered
strange
Copy & Paste Question
Copying data into a number of other workbooks
Easy one...
Parsing a cell's value
the '$' in right$()
Rearrange columns
Slow macro
Entering information
help on combine program
Macro to copy a one worksheet in one book to the current workbook
Get data from web site - hyperlinks in divs in html table
dropdown issue
Compare & highlight data
Search for worksheet in workbook
Sheets - xlVeryHidden
Track Sales Weekly, Monthly and Annually with this Powerful Tool 06592
Adjusting Y axis scale of a chart using a scrollbar?
Run Time Error '9':subscript out of range
Serial comma delimited text - Import to XL evry 8th comma nuRow
Prevent user from changing font color (Excel 2003)
RE: URL function
URL function
Creating groups of people with different background
Creating groups of people with different background
Re: Internet communication
error in open excel program
converting table back to range
Get Range Address from a String
How to set a specific value into a data validated cell using macro
Re: Export Custom Form, .frx .frm files
Pivot table using VBA
Re: SPLITTING TEXT AND FORMATTING !!!
Re: sort only rows with data
RE: sort only rows with data
Re: Export Custom Form, .frx .frm files
Re: Macro to automatically select the last row of data after refresh
Macro completed message
Inserting all pictures from a certain file folder
Open file when ribbon button is clicked.
how do i add dropdown menus to a menu bar?
HowTo: detect a cell contains an ArrayFormula in vba?
Total Computation
Wrong Row Selected
Partial Match Lookup Question
Private Sub Workbook_BeforeSave
Unspecified Automation Error
Error Trapping
Index in google finance
PLEASE HELP! MACRO NEEDED
Max number of runs in a time period?
Excel "search engine"
Store formula for a while
RE: Populate form from row data
Populate form from row data
Formula Names not working
Linking to Password-required-to-open workbooks
Query brings in wrong date
query external database
Using Equations to Fill in TextBox
How do I enter unique row ID's in multiple tabs in Excell?
Loop find between worksheets
Subtotal duplicate
search values in named formulas
Month Deduct Formula needed
RE: using variable from input box
Hilight Row by Macro
Hyperlink Question
actual value of cell, not reference
using variable from input box
Padding in cells added to imported spreadsheet
Re: ThisWorkbook.Path in formula
ThisWorkbook.Path in formula
Access VBA to format Excel
Get file name to open from cell
Re: Sum based on second column date
Excel 2007: Delete Duplicates
Sum based on second column date
Fill down used ranges in several sheets
Pesky Custom Toolbar
Mid function compile error
Arrays problem in new filtering code
RE: Turn all #N/A values white in a range
Re: Recursive Sub Routine?
Re: Turn all #N/A values white in a range
Recursive Sub Routine?
RE: Turn all #N/A values white in a range
RE: Turn all #N/A values white in a range
FollowHyperlink with Username and Password.
Turn all #N/A values white in a range
Update Pivotfilter against Cell value
Embedding help file into Excel file
Updatelink Error
Challenge with Automatic Calculation
Excel 2007- Saving macros in workbooks
Higlight row when value is entered in cell
Worksheet Change Event Refuses to Action
Paste Special Macro
IE button click
Change sheet names based on cell contents
Re: Search column...change row to BOLD
how do I 'nest' multiple quantities from standard stock lengths
Re: Search column...change row to BOLD
Re: Search column...change row to BOLD
Re: Search column...change row to BOLD
Form with progressbar
Search column...change row to BOLD
hide range of rows based on another cell condition
Sort Range question
Re: Copy to end of sheets, another file
make range available to another macro
Copy to end of sheets, another file
Disable copy paste
Hide all items in Pivot Field except specific items
Re: Probably simple
Probably simple
Count Down Loop
unable to Find the size of the file throwing exception
unable to create a file if already exiists
Spliting rather mixed up address
Validate user inputted name.
Visual Studio 2010 - Anything new for Excel developers?
xlExcelLinks
Import Excel 2003 data into Word 2003
Sorting - should have been easy
RE: Problem w/ Print Macro
RE: Test-To-Columns > 256
Re: Test-To-Columns > 256
Test-To-Columns > 256
RE: Problem w/ Print Macro
Problem w/ Print Macro
RE: how to make auto date update work on a range of cells.
how to make auto date update work on a range of cells.
Display the built-in form
how do i automate colour to fill a cell if a range of data is inp
RE: Any response
Re: Any response
RE: save file as different name until cell is blank
Re: save file as different name until cell is blank
RE: Any response
Any response
save file as different name until cell is blank
Re: Replace blank cells with 0
RE: Replace blank cells with 0
Replace blank cells with 0
Form Control Button Offset
conditional message box
How to get an IWin32Window for Excel embedded in Word/PowerPoint
Any quicker way to write data from DataTable to Excel?
Read in cell value and comment from 2 selected cells
Copying a sheet from another Excel instance?
dont open a Workbook is Password protected
Drop Down Box to Display range
Removing Quotes from Range Names
Copy data from list box to sheets
Understanding the difference
how can i print hundreds of records one by one from excelsheet
Rich TextBox Control in excel 2007
Screen flickers while macro is running
Selecting non-blanks cells only
Listboxes on userform
Dependant combo box in Excel form
Unable to delete rows for only filtered results
Stop Module, Forms opening
Error trapping ComboBox input
Control in Excel 2007
Find Left$
How does PowerPoint manges the shapes inside one slide?
Re: inserting graphics in a conditional formatting
inserting graphics in a conditional formatting
Form Textbox Mulitline question
RE: Named Range Hic-Up
Named Range Hic-Up
Excel 2007 table named range does not include headers
Have the Find, desperately need the FindNext !!
arguments not working with function
Excel VBA Save file to Network in Vista and Office 2007
Parse HMTL source to fill in cells?
RE: Charts with Time as X-Axis
Charts with Time as X-Axis
Re: help with hard return please
Form based on rows
help with hard return please
Can't kill 'e can't live with 'em.
Re: Time/Date Stamp
Data Validation - copy/paste
E-mail spreadsheet
Time/Date Stamp
Exceute macro when cell is clicked
selecting more than one cell
Code stops for no reason (that I can think of)
RE: Object Required - My Brain is Obviously Not Working
Help How to sort a column with number and copy it in anonther colu
Object Required - My Brain is Obviously Not Working
Loops
Dialog Box pauses my process
Message Box if Data appears in Column
RE: 2 formulas to use depending on value of another cell
shared file !
Excel 2003 - Copy Variant to Clipboard?
VBA code to copy named range in closed workbook
Is there a specific Excel Function that doesn't this?
.txt import + saveas + mkdir
Copy Worksheet
Excel doc keeps making a backup after macro is ran
"auto fill" Look Up table
RE: Is it possible not to specify a cell reference when data is filter
VBA referencing the result of a formula
Vb?.tmp path/file access error
Refernce to cell in SQL statemen
Linking with powerpoing using VBA
in excel, how do i list all folders and last modified dates??
Check to see if a Workbook has a Macro
PivotTable and OLAP: how to reach attribute properties?
ToolBar Question
Refreshing external data on individual sheets in a specific sequen
Exclusive Access
Share Workbook
Excel Challenge: Compare multiple worksheets macro
Macro to copy a one worksheet in one book to the current workbook
Excel 2007 won't execute 2003 VBA code
Re: Separating data in the same cell
Separating data in the same cell
Open/Close CurrentDatabase
Re: Excel VBA - Close Event for Password Userform
How do I assign a partial cell address using data?
Excel VBA - Close Event for Password Userform
Re: 2002 versus 2007 question
Re: 2002 versus 2007 question
Re: 2002 versus 2007 question
Re: 2002 versus 2007 question
2002 versus 2007 question
Macro to Print Text to file in UTF-8
RE: Concate a range ignoreing blank cells
Concate a range ignoreing blank cells
Fairly Simple Macro HELP!
Record macro button grayed out (excel 2007)
Re: The autofilter is disable using the userform
The autofilter is disable using the userform
Code to Hide/Unhide Worksheet
location of an installed xla
Deleting rows that dont fit criteria
macro runs only if cell not blank
Help Selecting Sheets Array form a list box
Calculate time differential - Mon - Fri workday basis
Listbox and multiple workbooks
Open Locked/Protected workbook using vba
Worksheet Scroll Increment
How do you view your posts on this dicussion group?
copy formulas, not values
where am I?
Help With VLookup Please
Copying data from several spreadsheets into a new spreadsheet
Copying and pasting from Excel to Powerpoint using VBA
My addin mysteriously stops working at multiple clients
indirect addressing
VLookup Problem
How to create a macro to generate report using advanced filter
Prevent Printing
If duplicate in range
Insert leading zero's
Can I have 2 user forms that relate to the same worksheet
VB macro ascending & decending Alpha sorting on protected sheet
comparing bond cashflows
Show file size dynamically (Excel 2007)
permutation
reverse a "hide" function
2007 Quick Access Toolbar
RE: Hidden VB Code module/macro/function
Hidden VB Code module/macro/function
RE: Macro undoes my work. Help.
Macro undoes my work. Help.
Transferring Data from Multiple Excel files to single excel files.
Test cell for list data and modify cell contents
How can I count Rows and Columns
How to use IfError in Excel 2007 VBA ?
Re: Save VBA changes only
Save VBA changes only
Does a standard DLL stay in memory?
Comparative operation failing
Re: InputBox VBA all worksheet, specific cell(s)
InputBox VBA all worksheet, specific cell(s)
Change Excel 2007 menus to Excel 2003
Excel 2003 VB macro for Alpha-Sorting on a protected sheet
Extracting data...
RE: Can I improve processing speed of macro
How to set Range reaching the last row?
Can I improve processing speed of macro
Checking array to see if value exists before adding to array
Copying Text from a file into Excel w/ Macro
Dynamic user form
Export data to from Excel to Word
Input Box Cancel function
Updating linked spreadsheets
Filtered data error. Need to go to VBA?
user form - drop down set values
automatically insert rows
RE: Specific format
Specific format
How can I get comment from excel?
VBA Compile Error in Hidden Module
Userform text box formatting
Formatting a comment by code
WORKDAY and holidays
Format
Flexi Grids not working - Compile Error in Hidden Module
Date time format
TextBox Text
header not in first row
Re: Copy formulas in defined range
headers contains brackets
Copy formulas in defined range
Re: sql hangs
Creating identical print layout from copied worksheet
Using Find
Can DIR detect if a Folder exists?
sql hangs
Re: Problem: Closing one book causes the 2nd book freeze
Deleting characters in a column of cells -converting to text strin
Re: To open workbooks: how to put behind wbk in front?
Problem: Closing one book causes the 2nd book freeze
Re: To open workbooks: how to put behind wbk in front?
Best Practice - Cell and Range references in VBA?
To open workbooks: how to put behind wbk in front?
Specifying a range for sorting.
Excel Conditional Find and Go to cell
Macro stops after opening a file
Loop for update
Can you have a command line arg with a workbook?
Send a single worksheet via Outlook
runtime error 2147221005(800401f3)
runtime error 2147221005(800401f3)
Re: Macro Not working in Shared workbook
Macro Not working in Shared workbook
Transpose
calendar date problem
USE EXCEL MARCO LIKE OLD VERSION LOTUS-123 ---> {?}
Macro stops when one a file
Easiest way to flag data errors
Must range be selected before a paste can be done?
Need to reference two cells to construct formula
extract data from sqlplus into excel sheet