Excel Programming [Archive] - Page 77

couple for each performance questions
Stopping repetitive loop execution through user form (or other ide
Change object formula without selecting first ?
Index Function in VBA
Excel Macro
Increment for or do while loop by 0.001 (not 1)
Get image (picture) from Oracle database
Setting binary values in Registry?
Vsto
Kill file
newbie "?" macros
Copy to Clipboard and so that I may paste to any other program
How to reference a vba chkbox from a vba command button on excel?
Locking/Unlocking sheets using a range.
Making a List (and checking it later)
Sort and Merge
vba countif linked to another sheet
Pulling data from one worksheet to another
Fix Button
Solution To Auto Height For Merged Cells
Refreshing a worksheet
424 error on a Worksheet Change Macro
Checkbox procedures
Run-time error 1004
Need Help
Worksheet question
Slow code
How can I force the file to over write the existing file
Can a Macro use Different File Names?
To Set or not to Set that is the question
Concatenate rows
Help! Need Excel to send Automatically an Email
Starting a Visual Basic Code
Userform and mouse pointer
Store FilePath Inside Code
disallowing copying of rows
Kicking off macro if data in cell changes
Excel4Macro(arg)
Accessing Excel Macros from VB.Net
Accessing Irfanview from Excel
copying cells from one wkbk to another
Speed of REPLACE-just curious
Saving a file
Splashscreen with Progress Bar
Disable Menu Items Insert/Delete Entire Column(s)
paste in hidden sheet
Selecting Last Empty Row / Certain Columns
How can I create this formula?
RemoveItem resetting Value in ComboBox
Producing Records on a given date
Copying sheet or saving workbook kicks off ComboBox change Sub
Print and save as restriction
Exit Sub if file/path not found
copier sur la prochaine ligne vide
Save
Creating Custom Function - A Little Help Please!
Range Change
RefEdit control
Range.NumberFormat Full Reference
Auto fill a cell with data from the cell above
Automatically entering data in cells
Is this a recursive problem?
Application.Filesearch
Quick Toggle Question
InStr Question
Unlink to other Data sources with code?
how to open an existing excel file using macros?
Macro newbie - simple copy/paste function
How can I make a list populate more than one cell in a row?
For each....that is not blank
Print Macros
Selecting a variable range
Copying Name Ranges along with Worksheets
Date in cell to update upon Pivot Table refresh
ActiveWorkbook.Close function
Transfer macro to new user
LA User Conference October 25-27, 2006
Autofill question
Running a macro
popup box asking to select an open book/sheet?
Allowing the user to specify save location
2-column sort macro
How to speed up VBA program in Excel?
which weekday?
Setting up Conditional Formatting in VBA
John Greenan/Bloomberg login
Unable to set the Values propert of series class
sauvegarde d'une feuille
pls help
Selecting a file for read access
Chart GetChartElement problem
Saving file with date variable
Not weekday
macro to autofilter other file and copy in opened file
limiting characters in a cell
Dynamic Toolbars
Hide/show drawing object by mouse over
worksheet_beforerigthclick event
Round(cell,0) after the Fact
checking Sequential numbering
Gregorian Date from Hijri
Is weekday?
Getting Info From Drop Down Menu
Enter data from excel sheet to another excel workbook.
Importing data from the active sheet w/ c#
Look Up Box In a User Form
Creating New Lines from original
Method 'SaveAs' fails
Jump straight to specific row number 1,234,567 (within a Text File
Reszing a loop - Possible?
How do I suppress warnings when following Hyperlinks
Length of series
Passing a Label object to another procedure
Format a Cells value within a MsgBox
Disable custom drop-down menu
pls help for fill data
automated process within Excel
Path/File Access Error
is there a limt to the number of points ?
making event
Upon mouse click a checkmark appears in a square.
Newbie repeat question
Saving MSForm.Control (s) created at Runtime?
Reading/Changing Workbook Propeties with VBA?
Sending print output to PDF file?
How to skip save prompt ask me if I want to replace File.
How to skip save prompt ask me if I want to replace File.
Userform data entry into hidden sheets
Mark "track changes" in MS excel
How to print different columns
A problem in VSTO Excel application deployment
Timed Message Box Issue
Check Box
Copy a range from one copy to the other
using class module
Picture #s Assigned to Objects
Trouble with Advanced Filter
help with offset
Formatting Text Boxes & Label Captions in MultiPages
Using VB.Net in Excel 2003
VBA code to fill rest of cell with dashes (-)
Closing an open workbook
Amateur VBA developer seeks further assistance...
matching like numbers/data points residing in different columns
Select multiple rows and apply changes all at once
Help needed with a RefEdit control
How can I unhide columns on multiple worksheets in same workbook?
AutoComplete error in (my?) Excel
Excel for presenting Access Data
Maybe very simple, andif?
Disable Tools > Protection
Copy & Paste code more efficient
Worksheet_Selectionchange for range
Run Macro After Paste
Reference Ranges
conditional depending on font color help?
Scroll through items in a drop down from a button.
Macros and vba
Delete unique records
Pasting to MSPaint
Can I use VBA to play a WAV file?
Help Get This Macro Running in OS X Please
Error Checking - Convert to Number
Cell Range
Faxing to a number which is a cell value
Array size limit
checkbox value change
checking for drive
Scroll to last row with Data
delimiter output has c arriage returns and commas but not consiste
Index on a selection
VLOOKUP in VBA code
My menu calls an old macro
Ron de Bruin - Using PasteSpecial (xlPasteValues) instead of Copy
Programmatically put an image on a button
Can It Be Done?
VBA Equivalent of FIND or SEARCH Function
hide repeating values except on new page
Adobe blocks AutoRunMacros
Excel date lookup using several worksheets
Making % add up to the original whole number?
Paste Special - copy everything except formulas
Formula too Long
Formula too Long
Link cell text to header
cell change
Hide sheets from ObjectBrowser?
Margins
Actions between user actions
Select Cells by Style
unlock last set of rows
Excel Command Button Color
linking a listbox to sql table
Send a fax from within excel via outlook!
Disable Save on Tool Bar?
Converting a Variable Filename to a Constant Filename
All of my Macros Stopped working! Is there a reference I might have unchecked?
OLAP Pivot Filter from array
select row
Remove File Path - just keep name
Is there a way to calculate 4x10 in a single cell?
A value based on OptionButton selection
FileSaveAs Project to Access
FileSaveAs MS Project to MS Access
Select a file, copy it and change some data
Deleting Sheets
Excel Custom Made Toolbar
Find and Replace that contains some word
Excel "Calculating Cells"...
Macro automatic Hyperlinks - References to Sheet and Cells
formula or vba code
From which cell is my VBA function called ?
Need A Start to Excel Programming Code
Need A Start to Excel Programming Code
Using Macro, how can I check if an opened workbook was changed ?
Copy a worksheet throws "Exception from HRESULT: 0x800A03EC."
Adding items to right-click menu
How to stop CommandButtons being deleted as pictures in code??
Extracting data please help
Information about activecell before clicking on hyperlink
Confirmation box
Excel Email Macro - "From" Address.
Excel as Input Form for Another Database
Simplify
SORTING BY COLOR
Check Box names
Find closest value
Deleting columns if condition is satisfied
Date Conversion
Fuel Consumption Figures
content on textbox within userform
Cleaning up some code?
VBA Update Sheet Where...
Why doesn't status bar update consistently?
Can I enter a "Y" and return "Yes" in the same cell? PART 2
Finding server name or FQP?
custom dialog boxes
fill data to next column pls help
Adding a header to a CSV file
count of column b when criteria = conditions of both columns a and
macro for update links
checking cell format
Emailing workbook from Excel
Ned Help with Print Macro
about udf..
Loop Down Columns and Compare Values
bottom borders in a For Loop
Go back to starting point
Finding temp folder. Environment variable?
Sumif in 3d
auto prompt file insert object when opening a template
Range conditional formatting in Excel from Access VBA
Select cell = today()
VBA - query an Access table -> results in Excel
Combining Text to Produce a Variable Name
Weekly email update
ADODB.Recordset from workbooks : numbers only?
limit scroll area of split window panes?
Open Another File to Search and Replace Text
macros to operate when sheet is copied into another file
FileSaveAs MS Project to MS Access
straight line connecting first and last point on a chart
Distributing Estimated Hours over calendar working days.
Looking for a Great VBA Book
Write/Print Statements, and date formats
video time code calculating
Macro fill down question, I think its easy
Using values of cells in a comment
Disable "Do you want to save changes" MsgBox
Concatenate values
RE: Using values of cells in a comment
Exporting contents of range to Access...HELP!
loop to check for duplicates Newbie pls help
Paste HTML Code
Combo box keyboard shortcut
Change Code from a Worksheet
John Walkenbach's MenuMaker Error
Macro to search across multiple columns and delete rows not containing specific value
Printer Ports
Merging/synchronising Contact list, Re-inventing the wheel?
Changing decimal place of y-axis in chart with vba
problem with recordset find
Programmatically determining CODE NAME for sheet based upon Sheet
How do I solve for missing value of changing cells?
need help with Worksheet_Change code
Looping on Criteria
Forcing Integer in InputBox
How to stop Enable/Disable prompts on my screen
DropDown Menu Macro
Re: MultiPage Control problem
How do I protect an Excel worksheet for use as a form by others
Code an image viewer inside XL
Changing formulae links
Filling in data into adjacent column utilizing VBA
Combo Box filter with autocomplete
[HELP WITH ARRAY] Simple for you, very hard for me....please
Macro for checkbox generation
SumProduct with more than 1 selection
protect columns (prevent addition or deletion)
Protect - Certain Rows / Columns
Is the password available to edit the macro's associated with invoice.xlt (Excel 2000)?
Checking whether a workbook has been unlocked
Macro too long
Excel Access query with username/pw
one row per item > one row per order
Variable variable name?!!?
worksheet plus one
Active X log in
Re: Remove zeros from cell data
allow user to stop macro with yes no question
Active X log in
Row Manipulation / duplicate dependant on cell value... and perform calculation on another cell...
Copy/Paste into new workbooks
excel (vba) and sql server express
Re: Importing pieces of data from multiple files
Initializing UserForm which uses MultiPage controls
msgbox for invalid data
Macro to prevent adding sheet in a workbook.
Referencing Cells of Different Workbook
Problem using VBA for the Networkdays function
Remove zeros from cell data
Golf Scoring with a Challenge - UDF
Uniquely identifying a row
Flex Grid Control (supporting files)
Network Drive accessible
Add row number in Excel
Determine file type
Help fixing date to be the past Thursday
Re: Coding
Help for fill function to next column
Rounding Errors from Percent to Numbers
one column to multiple
Replace module with code
Automatically renaming worksheets to weekdays
Looping through chart worksheets
Hiding and restoring controls
Re: Coding
Bob Phillips
Not what I want....
change and ODBC Connection
SendKeys to open application
The program have the same problem
Outlook express problem..................!
XP macros not working in NT
Capturing current folder path
Javascripting over an Intranet
Dynamic Named Range
Excel file Copy Prevention/Restriction
Function in cell than fill to next 5 column cells.
Re: Moving shapes with the mouse
Uninvited function!!
really remova all VBA code from Workbook
possible to open a closed workbook from a server
Re: Force Integer in Inputbox
I have password protected and now cannot access it...Help
Pagebreak when range does not fit
Custom Toolbars
adding an integer to a string in code
Need to Change ActiveCell
find
Event Handler for Controls made "on the run"
Set Worksheet Name
Find Heading & Apply Formula
Re: how to copy and paste in a protected worksheet
Re: .UsableWidth .UsableHeight
Re: Color formatting with VBA
Auto Print Area
Re: Need Help with Printing multiple sheets
Re: how to copy and paste in a protected worksheet
Re: Xls to Csv -- remove formatting
Re: finding all missing check numbers
Re: Bypassing protection for macros applied to an image
Re: dredded Negative or zero values dialog box
Formatting variables
Help with a ListBox
Different usage of range formats, conflict?
Best way to do this:
Importing File greater than 65536
Playing .mp3 files based on user input
VBE replace with pattern matching?
Open CSV file
Microsoft Office Spreadsheet 10 or 11 Component
copy data across worksheets and add multiple lines
"IF" Statements with buttons
Recursive Code
subtraction formula
Reducing the size of the Search Dialogue Box
How to verify addresses and zip codes are correct? In bulk...
Webform
Excel VBA Formatting - HELP!!!
Search code?
Cross sheet reference function
Search not found
Assign macro and hyperlink
How to NOT show other screens flashing by when macro runs
How do I embed Affiliate html links in a spreadsheet
Excel lists
how to prevent code running when in a worksheet code
Application.DisplayAlerts = False
Deleting unwanted data by macro or...
nestedif function
Message box help
Change code HELP. Sentence Case
Processing input data
Image to appear on all worksheets if placed on 1 worksheet. POSSIBLE ?
Macro Problems
creating an array from range help
Invalid procedure call or argument error
Pivot Table Worksheets
Reset a commandbutton
Worksheets() Object
Macro Troubles
Quirky, infrequent problem with code
Fantasy Football & Excel VBA
How to execute a macro in a protected worksheet?
Simple Question..if there is such a thing in Excel
Excel is adding "" to my concanteted fields
How to count and group items in a list depending on size of list?
E-mailing a Mail Merge via Excel
.onaction property for controls checkbox
Recognize ALT key Pressed
Creating a form- mail merge
Open a ms project file from excel using vba?
specify default path in dialog open box
Stopping VBA Debug pop up boxes?
printing all charts in the workbook
How to run macro from Add-In when Excel opened workbook?
switching between workbooks...
Macro conflict causing problems
Tom Ogilvy please help : File size getting large
playing mp3 files on user input
Cursor automation
Replacing a value in the string variable
Button Speed
Problem finding merged cells
deleted files
VBA Automation error
Move method trouble with hidden sheet
defining TextToColumns with variable
Help:Find and Display
How can I move the cell pointer down one row in a macro command?
File size getting large
Macro Strategy - "Peeling" Off Sheets
Run time Error '1004: Method 'Cells' of object'_Global' failed
Unexplained/Unknow"Object variable or With block variable not set"
still stuck on days value to year value code
External database
Loading data into Excel file from Data table.
Looping filter criteria
Help with Dates
disable alt and control shortcut keys
Returning formatted output from a User defined function
The 1904 Time System
Multiple Instances of Same Listbox
allow user to paste in a protected worksheet without unprotect it
Temporarily Disable/Cancel pivottable refresh
Input to Form during Code Execution
how to set a userform's button caption equal to a variable in the main procedure?
Can you automatically scale text in a graph? I'm hoping there's a way!
how to average a varying amount ou numbers
Is This Embedded in The COUNTIF() function???
Schedule task without Login
How to Know Selected Sheets
How to increase size of image in msocontrolbutton of custom toolba
Application-Defined error for some users...
Help with Col. split
poor macro performance
Formatting an array
Multipage form: Referencing controls on one page
Finding file
How do I sort values only, and leave formats?
Macro and charts
Repost--"Ignore spaces and tabs in word search"
Global 'Lookup' Ideas
Loop + Data validation list + e-mail problem
Data/amounts in spreadsheets are sometimes dim and fade out !
Determine Email App
updating multipage report before each page prints
Carriage return character
E-mailing Forms
Macro no longer working - Don Guillett
Auto enter data from cell above on enter
Highlight the contain of textbox and radio button
Validation Y N N/A
List Box into a cell
Is ther a better way?
Face ID - where can I get a listing
Save file in a new folder, but create folder only if folder doesn't already exist?
Help: Creating dynamic sql queries in excel
reading txt file and copying the lines in new excel file
data validation
Testers for CDO mail code example
Need tweak in program: finding next data
Need tweak in program: finding next data
Deleting Cell Content
Message Box before Save
print pdf's with changing filenames in a macro
Interactive Workbook on Shared Drive
validation list boxes
Rename or move file function
Copy cells from a excel file that filename changes daily.
which sheet a loop is valid for-how do you know?
printer port assignment in macro
Sounds and Title Bar (Userforms)
My ActiveX control does not respond when i draw it on a excell sheet, using ActiveSheet.OLEObject.Add
Find a sum of a combination of cells to equal a value
Search Different Excel Sheets
Re: Condition Formatting in code. How?
Search for first empty cell.
Re: Condition Formatting in code. How?
RE: Condition Formatting in code. How?
getting the column address of an argument to a user defined functi
Convert Excel 2003 XML file to Excel 97
Table from Excel into Outlook
Insert pictures
Workbook_BeforeSave question
Working with circular references
Excel macros
Ron de Bruin
Cell formula help?
Capture a worksheet in VBA
searching filenames
set code to ALL sheets in workbook ?
Automatically Begin a new email
(Hopefully) Simple Array Pasting question.
Almost there
Send e-mail
Log in with macro
International Excel 4 Macro
Can i avoid mutiple copy pasting of this code ?
Translation to International Excel 4 Macro
Book
Setting values for "TRUE","FALSE" and "#REF!"
Declear which picture I want to show and not?!
Statusbar
Delete every nth column from the worksheet
Run-time error '1004,
Count rows in multiples of 'X' & highlight?
Thank You Simon :)
Sum selected Range and copy to clip board
VB Code Corrected Solutions
Macro to extract data and paste to a new sheet
Bar Cutting Optimization????
disable autorecover
error in code when placed in workbook_open
Excel Sheet cell format
AutoDetect the path of the file?
psate values in right click
Looping
Declare Worksheet name over multiple modules
Sri NEED HELP - AUTO MAILING THE FILE WHILE CLOSING
want to save, print and close wb
change formula to code function
Pause to Calc
error in code help
New Spreadsheet Name
user input of a range of cells
Syntax error?
Multi-sheet FIND capability
setting all sheets in workbook to same zoom level?
Error when Target Range is block, not cell in Worksheet_Change Eve
VBA Code To find Hardcoded Values in Formula
Remove Dashes
Origin of Immediate Window messages
Problem with funtion ShowAllData
autorun a macro
calling sounds in VBA for Excel2003
I'm in over my head.
shortening text in cells
If Statement Before Save
Need tweak in program: finding next data
Updating Dates to Next Specific Weekday Automatically
Sending Keys from Excel to Internet Explorer
writing a small array to a single cell as a string
Quick and Easy: Copying and Inserting Lines Using VBA
Multiple Date Stamp & Worksheet Change macros
need to minimize userform via command button on itself
Unload a COMaddin
I need a macro to copy each of 2000 rows 12 times in same sheet
Tricky copy/paste question
trace all precedents or dependents
Display a list of all logical drives and include full paths for mapped drives
rewrite sheet with some saved values
Move cell contain from Column A to B anythign with the word Total
Email from Excel but NOT from Outlook?
paste comment text to right of cell
Use Function to Get Filtered Data From Another Sheet
Has anyone ever encountered an error AFTER the macro has completed
Userform
Updating of cell linked to drop-down list
More problems
protected worksheet
Can you default a value in a CombBox?
Cell value for Query
Need Project Help
Can you create a "flyover"?
Range.Value doesn't work in hidden columns
http's are turning into tp's
Syntax Help: Range variables (plucking data and pasting to 2nd sheet)
Inserting a picture
hidden macros?
Move columns...
Crash due to worksheet order?
find an array, only finds first entry
An urgent modification
Dim CTL as MSForms.Control always sets as Control/Combobox
Clear Cell Contents
Fill combo box ignoring blanks
Exclusive OR question
Copy data
File in Use
formatting pivot table report (borders automatically showing)...
Return file name only from FileDialog
VB Code Corerection Part 2!!
Buttons Adding lines
How to delete allowEditRanges programatically
Downloads or Links to VBA training
Alt command for custom menu
importing from access
VBA Code Correction
How to pass active workbook to external DLL?
VBA Code Correction
Execute warning on close if cell unchanged?
Macro to rename .doc
Moving files
Problems with linking pictures!
How can I create an error log?
Column stop
Field delimiter formatting
Creating List From Folders
access menu
Excel 2000 webquery fails for pages greater than 2k
Can I change a controlbox to a listbox on a Form
Managing errors in VBA
lock all cells of a certain color
Counting blank cells in one column
Public variables
msoControlActiveX
Newbie help pls
how can I trap the change event (Tab Press key) of these controls
Links to external documents
how can I trap the change event (Tab Press key) of these controls
What is this called in Excel?
help
Determine the text in a range that covers several cells
use a macro to "Save As" to a generic desktop
UserForm Issue
How do I get 6 conditional formats?
new books
Printing contents of a listbox
Charts
Trouble Selecting a Range in VBA
MsgBox
Ranking
Email a CSV file
Automatically extracting MS Project data for use in Excel
Page field and array selection
Populate list box with multi-dimensional array
Ontime method, quick question.
Probleme saving xls file with C#
verify user input
VBA Code Comments
Difference between .value and .value2
how do I leave cell content unchanged if a condition is not met
Listobject Blue Border
What was selected in autofilter
Simplify the Macro of Looping
Problem while copying range as picture and pasting in Power Piont Slide
Macro Code to find duplicate and add alphabet to it...........!
How to Replace multiple words to replace using excell
Testing (unsuccessfully) for non-blanks
respond to message box
Custom Function not working
VBA codename and codeprotection
What csv standard used by excel?
VB Control Focus
Copying non-contiguous columns to contiguous columns
How do I set up an Installment Note in Excel?
visual basic macro help
"Marketing Reasearch Tactical Plan" Template
Making a Constant Row
hide pivot field
Find the name of the label within its _Click() ?
changing axis number
Is this possible???
Locking a worksheet during the reading of it
VBA code to confirm Workbook is [Signed, unverified]...
Split days of the month if new month begins
When does the Workbook_Open event occur?
Version Number Property
Macro for auto date/time stamp
Char(13) displaying as square in Excel
If...then formula, otherwise "entry field"
problem with charts
ComboBox RowSource Question
Autofilter rows and columns at the same time
Selective Worksheet Deletion
Use Excel as UI to OLAP for reports
Error handler will not work correctly after [Ctrl] + [Break]
I want "locked for editing" message
Tough Problem
Macro to edit cells
ascii validation question
Need help!
Need a formula to count the fridays between two dates
How to send a mail from excel macro using Lotus notes...
Possible Bug in Excel UserForm?
spinner control in chart sheet... please help!
Finding number of occurances of values
finding the address of a specific cell?
securety problem
Security in Excel 2003
ActiveCell.Offset Code
select all worksheets in a workbook
cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc10d
copy the valued of named ranges
Using worksheet code name in this code
Detecting Sheet Type with VBA
Problem with Data Validation Dropdown List / Worksheet_Change Event
Changing Query path
Macro that changes line styles based on the series' name
Macro uses "Save As" to a specific location
how to make a mirror database ?
help with this VBA code to open cetain books
How to refresh a sheet?
Excel Updating
Newbie and Excel 2007 basic question
how to fill formula in any cell and drag it?
getting the dimensions/location of a workbook
Code to replace 'sumproduct'
public array
After autofilter my results are not visible..
Extracting unique values from live list
Upon Opening Doc1/Open Doc2 without showing.
Excel gone out of memory
Reset Form/Hide Rows based on cell value change
User Form value passing problem
Changing a String to a Range
Selecting a Page (not a sheet) using VBA.
Multiple range selection
Please help me get around this:
Having a cell equal a specific day of the week?
Find all cells with "A" and add the values of the adjacent cell to give a total.
Hide Subtotals in Pivot Table for Certain Columns
Macro Formatting? Please Help
Macro Formatting? Please Help
worksheet subroutine causes Compile error: Not found when on User
Save as filename cell DETAILS!B2 value
place content of variable in destined cell in previous worksheet
Import Data Macro
Select method of Range class failed
tranfer array to range
I want to download MS Access template for Customer complain track
How do I set up a form with data tracking in excel?
Select the 2nd cell from the top in the column with filter
Type of Selection
Chart Events
Conditional replace
User identity
VBA and use vlookup from one sheet to copy data from another sheet
Can I use Word built-in dialog in Excel macro?
VBA Pivot Table
DIM Variant / String
Make cells uneditable, with general Cut/Copy functions intact
Data Validation in Workbook
unlink object
creating an array on the fly
search and select from list box...
Activecell Reference in Macro
ActiveCell
Dynamic Range in VBA
Formula =Now()
Formula Now()
Managing Printing
Areas Collection Question
Areas Collection Question
XL VB noobie needs help - macro opening file already in use prompt
Tool / Code to copy and paste only the conditional formatting rules
Opening an Excel Spreadsheet from Access with VBA
Use Cell as Source file
Icons for attachments added via VBA
pagebreak only when range doesn't fit
macro to remember sheet
Removing a reference from the LIST
Adding a date timestamp to the last column of a spreadsheet
Sorting on more then 3 columns
Marco to copy from active cell to top of column
VBA code for averaging a range of cells
Trouble with Find
Deleting a worksheet - impossible!
XL 2003 - Create Dialog Box to Complete Cells...
how take data from refedit control
Counting the length of a string and adding spaces...
Export excel2000 charts into EMF/WMF
Replacing data using the cell value not the formula
stop loop if prev sheet does not exist
Copying Pivot help !!
Running a external Program
Simplify Code
Excel
Can I enter a "Y" in a cell and have it return a "YES"? How?
Camera tool is slowing macro
Colored Cells Question
Customize Filter List in Pivot Tables
Difficulty restricting characters
Using code to write code
variable view in VBE
Tag in CommandBar
Help Retrieving attached file
Help Retrieving attached file
Setting A Range
Macro to create pivot table from large data file
Multiple Workbooks Selection.text
excel form activation in macro?
Column heading(A,B,C etc) and Sheet teabs at the bottom are missing!
Add Header Row
Creating a formula to compare 32 sets of data against each other?
Variable for Worksheet Name & Syntax for use in formula
digital signatures
Dropdown List from values in a Cell Range
getformula UDF
Opsummerring
I'm Lost... Bin? Delineate different processes with time samples
Open two worksheets, then match and compare cells
import excel to recordset in ASP
Bypass sheets.delete confimation
worksheet.copy truncates at 255 characters
Replace an Existing File
Managing Printing
Managing Printing
Code stopped working
Managing Printing
Set a row colour when a criteria is met
Calculating the end of the month
"Highlight" Entire Row while entering data
Macro does not function inside a list control
Change case
Lookup Results by selected MONTHS/YRs...
Importing a file
Please help correct this macro! :)
Web Query TexttoColumns
copy a group to a new worksheet
If then statement
Reference Worksheet Name variable in VBA formula
Macro to find string and remove, but leave the rest of cell conten
I have an msoControlEdit which I need to fix the text typed into i
Iterative Correlation Test
Insert cell value into a link path
close doc and call next macro
add dynamic control (checkbox)
insert date timestamp to end of spreadsheet
Difficult (for me) question about conditional SUM
If IsNumber or IsNumeric
somewhat minute technical question about selecting each cell in a range
Running Excel 2000 VBA Application on Excel 2003
Every other
Excel addin - puzzle?
Excel Autofill Method of Range Class Failed
Error when user clicks "no"
Every 75 rows
Charts
Validation: Changing Lists
If IsNumber
VBA reference path goes to lower case
clarification of code
Checkbox usage in Excel
how to read dta from a web page automatically?
Determine Cell screen coordinates
Best Method to Remove Data Rows
Recursive Code: How does it work?
Search for multiple cells with a row for matching criteria, then sum up certain column
Can you do IsEmpty(Range)?
Repeating Menu item
Saving over a range
VBA Timer
Help!! Using IF statements for the 1st Time
R1C1 to A1 inaccurate formula conversion
Houston, We've Had a Problem
Help - Calling Analysis Toolpak Functions from Outlook Macro
Delete empty spaces at the end of text of a column?
Get RGB settings
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
Re: Using Code names in formulas
search cells
Microsoft Word Object
Retrieving stats from LINEST
Adding values to cells
USER FORM COPY
How to download a .txt file...?
import multiple txt files in worksheet and formating
Assign different
formulas
FileDialog(msoFileDialogFolderPicker) not using the current direct
Determining last active cell in a protected worksheet
Run time error '424' object required
Copying rows
Command bar
Help with FindNext Method
How can I copy the values of all selected cells to the same cells inanother Sheet
Is There A Solution.......?
Importing each cell in a range to a different worksheet
Web Queries in Modules
Web Queries in Modules
Using Conditions - cell colour and cell containign text
Share workbook
Blanks in pivot tables
How to Capture insert row event in Excel using VBA
Editing a for each next loop
RE: Editing a for each next loop
How to protect a row
need help
Using a custom function in a macro
Find Next Methond???
How to Return #N/A from a formula
Extracting first two digits of a time entry!!
Move a file
How to increase size of image in button (msocontrolbutton) of custom toolbar of Excel 2000
How do I check the number of rows selected
Check to see if a cell contains a certain word
Column transfer
save and delete a file when in it with code
Quick question about moving around a worksheet using vba in a macr
userform label creation
Userform Copy related...
Find text within a string
Move data to new sheet depending on criteria
Is It possible to get Lisbox1 windowlong ?
Workbook.Path
Using a macro to edit part of a cell
Excel 2000 VBA Application on Excel 2003
Autorun macros on opening
SaveAs function and Send mail in VBA
Custom Views
How do I code VBA to hit button on a different worksheet?
Question about using FIND in macros
Modular Arithmetic
Problem with cell references in my macro
Change Defined Name Constant String
Help with a Type Error
Calendar Control, Weekly
Conditional formatting of adjacent cells based on text in cell
Thanks to all for the help
Passing indexed array value to VBA function
Help: Dynamic Total Updates?
Reference worksheet by partial name ?? wildcard
macros?
Selection to Array and Array to Sheet
Re: Using Code names in formulas
Public variable not recognized in event
What key is being pressed when running a macro?
Import Module
RC format formulas
Combobox - can't get click event to run for first item in the list
different ways to copy a range?
put cells based on condition in sheet2
write out formatted text files
Open an Excel Document using VB
copying a range using syntax 2
Remove Macros before send? & Runtime error if choosing not to overwrite file?
SendKeys Help
save as csv cell format
usernames and passwords
Excel Image Background
Save As causes Crash!
"if" question
Named Range
RE: "if" question
Running Total in Pivot Chart Not Displaying Individual Value
Problem setting combobox
a challenge for a VBA guru
Excel 2003 cell limit
Military time caculation help needed
Programatically access Excel 2003 spreadsheet
Run time Error 6
Help with Error Handlers!!!
How do I VBA....to go through a recordset and eliminate duplicate
How to track formatting changes
Update Web Query Parameter with a Macro
sum a column based on multiple other columns being true
Combining data from two columns
Calculating Friday Date
Testing an object varible for Nothing
selecting row from active cell selected
Remove Reference from VBA Projects
Excel & Candlestick Graphs?
User switching between sheets while data is being logged
Distributed Excel Application
Running GIF in userform
stupid round question
Memory leak in names collection?
Counting in a variable range
Excel 2000 to 2003, Resources for Compatability?
Excel Formula for "Litres per 100 Km"
loop to find cells with specified value
Cell Referencing Error.
Opening Templates
more efficient VBA?
Digital Signature in Workbook
How do I stop Excel from resizng columns in VB6
how to increase size of button's image of custom toolbar of Excel