Excel Programming [Archive] - Page 103

Add controls to Frames at Runtime
SaveAs not saving...
box with the content of D26
Finding Blank Cells in a Range in Excel
Excel2000: Formatting a range as Text in VBA
Dragging an array?
Wanting to write results to array instead of sheet, results overwriting....
convert currency to words or english
blinking text
Help needed to speed code up
network auto open
I don't want to display any controls in excel.
MultipleText entry
Excel 2003 decimal point
Referencing the First Cell in Any Selected Range
Error 429 can't create activex object - winsock
Subscript out of Range - CodeName
Userform is blank when displayed
format row based on non-blank or blank cell
Rename Worksheets Based on Values in cells
Copy contents from all sheets into 1
How To Make A Customer List With Extra Entries Per Customer
Implementing Excel as a webpage interactive
How to conditional color a named range in VBA code
pivot table calculation
Initialize macro
Problem with Hyperlinks
Change path links in Excel from VBA
rename sheet
Finding The Right Row To Do A VLOOKUP
Copy sheet from multiple files
Public, Private, Event modules, Forms modules,,,
Text Box macro
Use macro to password protect macros
Deleting rows not containing one of 3 values
Best way to handle this problem
Stop a Macro
Barcode Language
Get excel cell properties
Showing the standard XL Colour chart
Q: most efficient way to feed textboxes from worksheet and vice versa
Check box in user form
Hide Row Numbers Only
application.visible problem
problem with..end with selection
userform checkbox problem with controlsource
Calling cacls.exe from Excel vb
Using a Visio Drawing in a userform
Use VBA to collect information from Excel cells to av word documen
Access
Creating Functions
codename help
Hiding the CommandBars
Run option fo Macro greyed out when I declare Static variable in a
i'd like some more userofrm help please
Refference Unbound Text Box
Capture "after delete" Worksheet
Vlookup function
Excel Geek Help Needed
Date format
Data Transformation
controlling ms word from vba excel
ActiveCell.FormulaR1C1 Sum Function
Pass a variable back to the host script?
How do i close i an application by VBA? (Repost)
Scripting Autofilters..
Downloading big datasets daily?
modified date
msgbox
Count match of two criteria
VBA to change mass formulas
custom toolbar button questions
excel 2003 macro help
AddIn Name Resolution
Looping through Columns then Rows
Help with thread - "Script problem - Help please "
BOLD font slows VBA performance in Excel 2003
Script problem - Help please
Dump Utility for User form Application
converting a file to EXCEL from FoxPro.
Revisiting an old topic... Autofiltering- unwanted rows!
Multi-dimensional Array Referencing
SQL query in Excel - help !
summing all hours end of the month
Enable Word Template Macro from Excel
Effecient use of Arrays for encryption?
Filtermultiple data and copy them in another worksheet
user form question
How to use autofilter to delete duplicate rows (2nd criteria) ?
loop question
How to fill value in cell based on date criteria?
Range error when referencing non active worksheet
Filters
Will only print one???
Delete all of collumn after cell...
How do I stop this macro?
RE: do if loop
do if loop
disable macros?
Why doesn't this work?
Combo box problem
Auto fill references
Put same web query in same cell in each sheet
Delete Rows based on criteria in Column A (not working)
subscript out of range
Filter unique in range, only keep visible
With, End with - workbook
prevent Excel from popping-up an "OK" (information) message
Interop.Excel version 11 does not work with Office 2003 sp2
deleting all shapes and lines
Sharing and Solver
Lookup & Match
Linking a cell to a toggle switch
Unbreakable Password
Help on a consolidation macro
suppress Excel save message
VB and Batch files
RE: Parsing excel spreadsheet
USING LOG and LN
Parsing excel spreadsheet
scrolling text
Highlight all Text in a Textbox when the textbox is selected
Yes, I'm an idiot...But I cannot seem to divide two values in VBA see below
Vlookup Calculation from another Excel file
Divide by a value in a varying cell address
Need Help With Creating A Loop
I lost my macros!
question about filtering
how to redim more than one dimension in a multidimensional dynamic array?
Input Box Timer
begins with, not equals, using activecell.value
How can i find and replace words mean from one file to another??
what's the difference between Activate and Select for Worksheet?
Halt A Macro If a Cell Contains a Certain Value
excel
Preventing only one cell from recalculating
Do Until ??
Command Button to be used as Browse... for selecting a file to be used...
VBA - opening files with Shell command
Worksheet_selectionchange Event
selecting groups to add border
Paint a cell ?
A better CTRL A select
Macro Code Problem
How can a macro accept keyboard inputwhile running?
Spell Checker
Is there a 'GetKeys' or equivalent?
Help! Condiational Macro
Tom Ogilvy, your code about locating a specified shape in VBA
Visual Basic 6.3
Look up & past value
COPY-PASTE Macro
Print with paper from a specific printer-tray
Re: Unlocking Macro in protected sheet
Excel - keep a command button from moving after code runs?
How do I Automatically generate numbers in Word or excel
closing user form
Saving a sheet in a workbook as .csv but not changing workbook name
Run Acess Macro
Unprotect Auto Filters
pause a macro to display a form for x seconds then end
Unlocking Macro in protected sheet
Move to a cell
find cells in a range which equal a specific value
Trouble with Find Method
Get back from chart to spreadsheet
Copy A Worksheet, with a Twist
Summing with identical Vlookup values
Accumulatar Cell
How to Close an application?
Creating Second Chart via Sub Procedure Error
Creating Second Chart via Sub Procedure Error
syntax needed to validate cells on spreadsheet
fax from excel with ms fax sbs2003
Check i a value is in a Range
Automating the f9 (Calc Now) function key
Print Acrobat Reader PDF file from VBA
If value already exsists in range....
Populate a column with a month end data
how does one use the NETWORKDAYS function in a excel VB macro?
Referencing differenct ranges with one input box
Copying values and formatting but not formulae to new worksheet with VBA
If...Then function
Using a variable in a formula
Need to send Outlook E-mail from Excel VBA without warnings.
Check boxes not working
Am I being Ignored, or is my problem too hard?
Call procedure using variable
updating two sets of data
Excel, COM+ and Web Services
Help with simple form
Any idea?
What VBA function to use for?
Export (VBA) an Excel 2003 List (Filtered) to a txt/csv/xls
Pop-up Calendars in an Excel Spreadsheet
form with print preview
Help with InputBox in a Macro
listbox rowsource from wrong workbook
If statement 'formula' not working
Selective Data
Update Automated Links: No
using check box option, how do I add or substract
combinations of checkboxes and executing commands
Set Color of Cell Background Based on value in another cell
Paste Special?
Hide Row/s (single/grouped) based on cell value of column in the r
Detecting if a range contains a shape
Help with UserForms
Cancel an application exit from VBA?
on error in whole workbook ?
Help, I can't figure this out
Find Duplicate Data in Two Lists
.EntireRow.Select question
Entering from a userform?
Toolbar lockout
For statement help
A quick one I can't get my head round
Date Criteria in Excel Macro
Web Excel
userform help
run time error (1004)
I want to replace the first character in a column of text
object reference not released when using ADO.NET
Function or VBA Solution Needed
Function or VBA Solution Needed
Totals for months
execution subs not in logical order ?
Extract 10 digit number from string
I want to string several formulas together.
Why does the click event get control?
how tell if file already open?
Macro to transpose data to fill blank cells in table
HELP! Programmicly Save an Excel File ?
Dim Userform Control
Selecting an active cell
getting unneeded notice that workbooks are available as read/write
Updated Cells
If A2 =X from list V then B2= Y from list W
Visual Basic for invoice to set up tabs
Truncate Cell text all the time
ActiveCell Format Same as Target.Address Format
counting iterations
Outlines and Locked Worksheet: XL97
Check Existing Button
Urgent Macro help
Read folder access rights
Convert Column letter to number
After Save - 1 more question
Excel file format.
reference to current file path/folder name?
Open book as hidden and getting value
Creating sveral reports from one excel file
How dio I attach a variable to an Operator:= ?
concatinate and vlookup
Find and copy problem
Fed up with VBA...want to use the .NET framework
Fill x number of rows with formula
How do I use ActiveX controls to hide/show rows on a sheet?
Programming graphs to be placed in determined cell area
adding data to new column
Combinations with contrstraints
"Conditional" Maximum
Excel SQL query
After Save Event - Confirm
Changing the name of a workbook without saving it
Dismiss a dialog box (Via a Macro)
Forcing the Custom Menu to be displayed in the worksheet on Startu
Get number of pages to be printed - before print
Transfering Data To another Workbook or Sheet
Duplex not printing second page on back.
publishing worskeets with accents in hyperlinks
Set an Input Mask with Data Validation??
Running Code from Add-Ins
Project Name
How to Maximize Print Size
Macro help: VLOOKUP with conditions
Help with a Do Until statement
is it possible to get an object without opening the book
Programming a macro to run on opening a workbook
Macro bombing out
Returning the row no of the lowest non-zero cell in a range
How to see macro code of a password protected macro without a password?
Hyperlinks.Add does nothing
Referring to cells in a filtered range
Finding constants in formulas
Open URL problem in excel xp
changing date format by macro in excel2000
Alt + F11 - Enter Password 'abc'
How to know the right most column?
Compare Colours
Create Qtr Ending Dates
Max date in auto-filtered range
Regression in VBA
Test Results in Excel
Mult. wrkbk copy, from cell reference
Macro formula using MYDATE not working
what if system time is changed?
method 'range' of object '_global' failed
Copy multiple wrkbooks, multiple lines of each
Releative Cell vs Absolute cell
Create an array inside a For...Next loop
Re: reset option buttons
Validating Time e.g. 23:17
Applying data label in VB
date lookup on two column date range
reset option buttons
date function
not allow empty cells
Adding a comment to a cell in VBA?!
Find xls with embedded queries
How do I use existing data from a worksheet to auto fill a second
Save As Macro only if Check Boxes...
International issue (Excel XP)
Remove data that doesn't match ??##?##
Getting the workbook number via VBA code
How to identify a the user
Re: Great Documentation for Investment and Trading Systems
Lists
autofiltering using a dropdown list
Run-time error 9 (Subscript out of range)
Pivot Help
Dynamic Cell Range
Sort array with 2 dimensions?
Help with External Data Queries
passing multiple strings to a function
How do I sum a column of unknown length using a macro
Instance still there in task manager after xlapp.Application.Quit
Example After Save Event
Link Rows To Multiple Sheets Based on Value
Copy method of Worksheet class failed
Null To Zero - ODBC Error - Undefined function 'Nz' in Expression
Treeview Control Populating Problem
Link Cells
Converting Excel >xls to .csv
Disabling Events: Dangerous?
Need add-in that saves worksheet as PDF file
Installing Addin via Automation
if statements
Enter date via pop-up calendar
Change a Value in a Worksheet
How do I fix this formula?
Referencing a cell color in different workbook
substring operation
A begginer trying to use arrays
Text box in form
How to create drill down scope form?
ActiveCell.Copy Cells(1, intRow) limited to 255 Rows?
SUMIF
Activating a Procedure in an Excel Worksheet
Changing CheckBox Control Names
a number is replaced by text when inserted anywhere in the sheet
a number is replaced by text when inserted anywhere in the sheet
how to know the active cell
Does Excel have a counting glitch? or is it more likely me?
Writing a macro
Series of errors on only one machine, security related?
Excel Custom Number Formats
Macro VB step required
printing a range that changes all the time
excel combo box
Please help
endless loop help
Add Series to a chart failure and Disappearing Series
Start macro when excel opens
Hardcode Links - edit my code please?
Pull data with entered date
Check if Word is already active?
filling a form with an array
Excel Code Samples
simple quick question
conditional input box for sheet name
Adding a 0 in front of a column of numbers
Using System Date
Why QUIT method doesn't work after COPY method?
Getting Started - Referencing Cells
Basic (I think) string manipulation question..
Count within a range
wrong code?
Getting system date
Simplify macro to show grid lines
macro to ensure conditional formatting
Tracking OnTime Events?
How to use UDF from Add-in in VBA
Help with status bar code
Convert from Excel 2003 (xml) to Excel 2000
Textbox Hyperlink opens VB Editor at Specific Module
vb6 addin
Form
Re: I don't want to run visual basic editer code after saving...
I don't want to run visual basic editer code after saving...
ThisWorkbook.PublishObjects.Add runtime error 1004
replace text in many textfiles with vba
I've got some problems in converting Hexadecimal values to ASCII
Type mismatch error on form show
Multiple Find/Search Criterias
Loop through all sheets in workbook
How do I quickly export 90 diff versions of 1 .xls chart in ppt?
double blank lines in cells
retreiving the range of a graph
Export as picture
Totalling x no of cols
Book for Software Engineering for Excel
Problem with Updating Add-in path programically
How to Import Selected Data
force addins.add to change folder for an addin
Macro
What is wrong with this formula?
Looping Macro with input boxes all related to one number
Relative references and macro programming
Coloring Chart Area Dynamically?
Creating a loop
Linking combo boxes
Worksheet relocation within workbook
Sort by specific word, then reg sort. (VB knowlege NEEDED)
Open file behavior with add-in
Dates and VBA Magic!
Excel Query fails to include data?
Menu bar question
Hi
Call a Module
pulling data into a month of worksheets, two tabs per day
Save a workbook in 2 places
Issues with saving text file
Microsoft Query in Excel
How to call a specific function in the form level
msgbox Question
Can I password-protect a spreadsheet for different users?
xlTextFormat in TextToColumns
Restrict user entry to numeric values only
auto fill calendar
Delete MenuItem
multipage tabindex
macro/function to transpose
Name x as y Deletes file
AddItem with multi-column listBox
Excel VBA - Copying access column
error 1004 Method SaveAs of Workbook failed
using user defined constants
Protect formulas but still allow formatting, etc.?
Closing UserForm
Tabbing through Active X controls
Windows - Mac and VBA-comptability
Help PLEASE!!!!
Always Print Gridlines
Cells Contents Anywhere Else in Column
how to redim the type of variant element
Arrays with one item
Cannot read selected row
Header formatting problem
Saving File
can you make this faster?
MSXML.DLL HTTP getAllResponseHeaders setRequestHeader "Cookie"
Macro Problems
autocalculate to include my function
Disabled add-ins
File Versioning in Excel???
Set optionbutton with range data doing Loop//For Each
Unique records of matching pairs
macro question - selecting the right column
Email with no prompts
Upload Excel DIF file to AS400
What does a number with suffix # mean?
Display link source from other workbook
Update Macro
which page is active
Testing code for oldest version...
Message Display
More e-mail problems
multipage userform question
keep recursion result (a dynamic array) without using global variable
Empty cell Identified
Looking for Macro Help: Zeroing Out Cells & Color Coding
adding a worksheet causes main userform to corrupt
Need to convert point on screen to various screen resolutions
more comboboxes with 1 event
please draw excel sheet for the following
Saving Excel in Design Mode
Deleting rows dependent upon cell contents
Match data in separate columns!
Help with Progress indicator script
oops, wrong group... sorry
HELP: Remote Connection and color quality
How to hide a column when value=1
Transmitting data from a server spreadsheet to a client spreadsheet
store SHAPE-Object on disk
Sorting a Concatenated Range
Help in FTP
Disgarding lnk files
Calling a specific printer?
Dynamic Controls (CheckBox) using VBA in Excel
create workbook, copy sheets
Deactivate shortcut keys in excel..
Alan Beban's vlookups...not for zero based arrays
Automatically Update Sheet Names
Filter by color
Don't Update Links
sumproduct combine with average formula
Color coding column charts
Macro for a Rotating Shift Schedule
Display last value in the row
Move qualified data from one worksheet to another
object pointers
AddComment...
progress box while macro is running
Code error with input box
Multiple images of dragged userforms
macro to password protect exel file
Cell Formula
How do you turn off "Row and Col headers" in Excel from VB macro?
Which User Form Listbox selection just checked?
How to tell which fiscal qtr a user defined date falls in, excel
Worksheet Code Too Large
How do I launch my macro by button?
Programmatically Sorte Rows that are Arranged in Subgroups.
Help with filtered save
Using VBA to select applications...
How do I recalculate & move 3 cells data to the right in Excel?
Code / Add In to remove unnecessary white space
duplexing
Copying Values to matching labels
Run VBA on Checkbox Value
Assign Macro & Paths
Re: convert column number to letter
Re: Printing worksheets
Need help to understand script
Tidy up of data within Excel Report
Code Not Recognizing Value in Drop-Down Menu
Re: Input Box
Re: convert column number to letter
locate shapes with specified text inside
Re: convert column number to letter
Re: Delete rows that have data less than 20 items or less than value of £300
Re: Input Box
Re: convert column number to letter
"Cannot Change Part of a Merged Cell" When updating link using mac
How can Rowsource be used for a combobox on a form?
Copy range name to an other workbook with all the page breaks
pivot table refresh code failed
spellchecking only the unlocked cells of a protected spreadsheet?
Workdays
Help...Need to modify data within a column in a .csv file
Textboxes interfere with each other ... :(
Conditional Format to Delete Row
Date to Number format
Checkboxes from the Forms Toolbar
Deleting row after 14 days if...
Hide Macro Worning?
Form Help needed
Anyone help with this error in changing data source of pivots
data from listbox to cells
Calling the Windows Deafult Printer
Multiple VLOOKUP??
Copying data to worksheets in another workbook that will change
Restoring Line Numbers
Login Name - VBA
List Value
Find all then paste not working.
Pivot Table Question
How to insert RUNNING page numbering THROUGHOUT all the worksheets
Function call syncronized.
User Access to System
Vlookup ? Match? Something else
Supressing SpellChecker dialogbox
Time sheets
toolbox appears in tab order
SendMail Add-in
Comparing Fill Color
How to get VBA to automatically generate Column Index numbers
tab order
Insert if not exist
Stopping a macro from executing after a length of time has past.
Export/Import: How do I delete Userform copies?
Sum Dynamic Range - VBA
Consolidate
Delete row if value = zero
Object instead of value using HLookup
VBA Validation - textbox must not be blank
Check if sheet exists in a closed workbook
Problem With Date Picker
Creating a new workbook/worksheet problems
Code Increasing Size of Worksheet
runtime error 13 - unlucky for some!
Given a range of cells, some of which contain errors (e.g. #DIV/0), replace each cell having an error with the value of a non-error precedent cell
Excel Formating questions
Change colour of bars/lines in charts when data in rows/colums
Macro Writing Reference?
Userform to ignore current calculation
Mapping Worksheet - XML Schema
left fill Excel numbers
No Beep
SearchFormat and ReplaceFormat
File Names
Redefining a Named Range In A Loop
send sheet to email as html attachment
Transfer data to form from Excel range upon loading of form.
Countif Statements
xlAutoOpen - doesn't work?
search a string withing a string : find / search hangs
using countif into a formula
forms in excel
how to pick the lowest 10 golf scores
VBA or Vlookup?
Insert IF-statements by Script, very slow.
Error Trapping the Find method
Time durations in excel and VB
Delete Numbers and Produce a List
standard functions not renognized
macros don't work
How to untick options in toolbars.
ADO runtime files ?
e. mail from excel through AMOS MAIL
help with excel and vb6
search within string
Delete Chart shortcut menu
File Manipulation
VSTO: calling excel funcions?
Conditional Formatting
Changing links in many excel files.
GetOpenFilename xl2000 vs xl2002
Toolbar control for a form
Named Range question
Yield function
Jim Cone
list box question
excel- paste values, keep original cell formats- URgiving me RSI.
How to Email single worksheet?
Copy Macro from 1 workbook to another
Code to do a Web-download
population list box without repeating information
Compiling VBA code
What's the best way to start learning and using VB for Excel 2003
faulty PasteSpecial line??
Look up worksheet
Write log file
How do I know if a hyper link opened
List of open workbooks
File Copy Error
Making an Excel spreadsheet harddrive copy inoperable from a macro
Printing on message box condition?
This is For Jim Cone
worksheetfunction.transpose - nx1 to n element?
vlookup in vba code
Finding the default printer
Macro to take selected cells times a selected cell
Excel macros
copy dates
Pasting to an address specified in a cell
open worksheet without menus
How to break up a cell with 3 embedded (new line characters) value
Modify Recorded SQL Query to "Insert, Delete, Update"
more forms questions...
SolverAdd
Formatting separate lines of header
copy cells
Assigning a macro to a forms button (help)
test
accessing excel combo box control data from vb .net
create a print menue
AutoFill Funtion Error
the same question, revisisted
Ungrouping Sheets
How to block file Save (^S)?
Delete an entire Row if 2 Columns = Zero Q
Comments
Copying From One Sheet to another Q
Getting Data from Embed combo box in excel sheet to vb .net
Conditional Formatting using Event Macros
Is it possible to paste data into a UserForm?
excel should "paste special" a "conditional formatting"
Sort subs
Read XML based file that is recognized by Excel
how to use tab within a cell
excel userform save problem
put query result into variable
formula help please
code execution speed question
Sheet number
copy selected cells to new workbook?
Bottom Border along Pagebreak not working properly
Populate a list box with named ranges.....
Help Required for Graph
code window question
Cannot find inefficient coding loop
Helpe me NEwbie
Test for empty row
Changing a message box colour?
Get Balance of an entry
Defining Dynamic Range
Need help please
Beyond "Changing Hover Labels"
Deleting non empty rows
Deleting a worksheet
Problem with range in function
Threaded programming in VBA
Where to put DisplayAlerts = False
E-Mail Message at Completion - OUTLOOK
Auto Save
Help with Looping to solve 'procedure too large' problem
Listbox counter help
Documnet Number
Auto Open help
Order of controls in For Each Loop
Auto Filter
Animating a Menu Bar
problem userform disappears
Generic Userform class
Two cells if no match
Help with Loop please
Show an ODBC progress
Finding Row or Button Name
Button Name or Cell Reference
Read Excel data, along with format information
Auto Refresh a Pivot Table
Upgrading to Basic.net. Is VBA dead (or dying)?
Macro, Help me!
I still need help!
I still need help!
Protecting a VBA Project from viewing
Copy multiple collumns with multiple conditions.
I still need help!
pass paramter to SQL server stored procedure
excel comma quote
UDF Returning #N/A
How can I perform "Cosinor" (Halberg) using Excel ?
Adding OptionButtons to array error 91
Need help mith multiple IF Then's
Sum of Len(string) for an entire row
Unselect OptionButton. How to?
Adding Buttons to Worksheet
Formula Help needed
Macro: How to search and then paste elsewhere
Screen Updating
Macro edits won't work
User defined functions: Where to keep in VBA?
Getting corresponding test value to a MIN function
Password prtecting worksheets in code
How to prevent saving over Excel and Word Files
activeX interfere with chart
FileDialog
PasteFace from IPicture
how to set a workbook from a file name and path
R1C1 Notation in VBA
Create an Index Sheet
Time Formatting
Updating a named range with SQL like command
OLAP Data Cube Question
Automatically naming sheets
How do I print graphics with a Macro?
saving worksheet without code page
how to make sure which worksheet call the function
compare cell and insert vaalue in column Q
Looking to see if Workbook is open
Text Form Fields
Sheet Protection and XLA code
Copy from Excel to a table in Powerpoint
Loop Macro
name worksheet after value in a given cell
Automate infil of data into a cell on subsequent worksheets. (Again)
VBA question concerning variables
SetCursorPos
Internal links
Making Microsoft Graph objects invisible
More question on Column Number
Grab Parents?
suppressing auto-dailog boxes
VBA Code to Calculate Monthly Interest
Pause macro user selection, then resume
Slow code execution
empty a entire row
Excel: How to suppress the Names conflict Dialog on automatic VBA copy
ProgressBar control in Userform
Export/Import + Copy issues
drop down menu
sheet without the excel menus
Checking to see if a button is selected
can you make an IF command run a macro???
application userform database problem
Bypass the "Macros may contain viruses . . ." message
Macro HELP! Cont
userform 'helpfile'
Loop and fill Question
Zipping a file
Conditional Cell Protection
Reverse Worksheets Order
Insert value from vlookup and not formula with VBA
delete OLE object
how can I get the maximal used column in the specified row?
VBA, cell-range-popup box?
Create CommandBar
How to project the due date according to a number of working hours
VBA code to create new Contacts field in Outlook
scheduling dates nested loops ...
Comparing Dates - Flawed Code?
Macro for Dropdown
Using SpecialCells to return rows for deletion
Err 1004 when move Workbooks.OpenText to called Sub
Disabling Macros
Hiding named rows
Disable Open option in Excel Report from VB
name variable with 3 first characters of active cell
multiple row data to single row
how to copy selction
Rounding up?
Grey bar when menus removed
change text case of some selected words from formula bar.
Key shorcut for changing worksheet tab
Opening an xlt-file as an xls-file
Help!
count unique records with latest date
VBA Font Object Query
data sort and protect sheet
Converting from Excel into a fixed length record
Disable Customize toolber tabs
NamedRange in Tools for Office 2003?
Is it possible to have to many formulas in excel, some not working
Protecting Worksheet Names
? about a userform
Custom Macro Scheduler Bot Programming - Arbitrage/gambling apps speciality
How can I get rid of the ' single quote in Excel Worksheet
Offset (start after last row of previous procedure)-Merging macros
Set the text align property of each individual column on UserForm1.ListBox1.ColumnCount = 5
Configuring Double Click
find picture objects
relative sheet referencing - what's the secret?
test:pls disregard
relative sheet referencing
Comparing formatting of two cells
get all the labels of all forms in array
User Defined Functions - Edit line prompts and/or help
Pivot Table Programming
Convert a number formatted as text to a number in a macro
Edit-->Find special characters
Search and Replace Blank Cells
How to display Color Palette with vba code
1004 General ODBC Error
Copy Active Worksheet
Delete rows with bold or italic text
Can I "sell" an excel spreadsheet (to a person with excel)
How do I access a sheet in another workbook using VBA?
positioning the control on a popup commandbar
Excel 2003 should have "multiply multiple cells" macro / shortcut
How to modify macro for monthly sheets
Copy cells and paste to an address given in another cell (VBA Newbie)
Macro to copy a specified range to a variable range
Automate infil of data into a cell on subsequent worksheets.
Is there a Size limitation when writing from VB -> Excel?
Menu linked to macro showing up in all documents
help with IF statement.
Batch printing of excel files
Printing
how can I change the font size on a validation list
preservation of displayed value in vb macro
Column number
Repost: Removing Cells from a Range
Worksheet_Change()
efficent find all and value
file save as (path and custom name)
Problem with CopyFromRecrodset
Combining data from multiple sheets
Enter WEDNESDAY, not Wednesday
How do you have range address
RE: Problem with CopyFromRecrodset
column loop problem??
formulas not calculating
Using Template Wizard with VBA
Delete row if it does not contain
Trying to get a form to set a style
Excel autofit and word wrap
VBA Clear Cell Contents
Formula to VBA
problems with my class
Macro to make excel close
ISNULL( ) or something else...
I need your help in "for" function.
HELP! Almost got it..Summing numbers between
Right-Click (Context Menu)
Randomized Paired Comparison Array
compare celles and put value into Q
GetSetting & HKEY LOCAL_MACHINE
Return to previous worksheet
Unhelpful error message!
Chart Object Properties Problem
Run-time error 1004: Method 'Axes' of object '_chart' failed
macro in excel
hyperlink to another workbook and a specific sheet
how do i make my macros load on all machines on my network
Refreshing a Pivot Table from a dynamic range
Disable prompt for external query
unique numbers
Help with optimising code
Change cell format based on its color
how to add character zero in text string
display msgbox in order or one after the other
Removal of author from Comments
NumberFormat e date
"Reset Comments"
input from sound card
Macro to copy hidden sheet to front of tabs?
MsoEnvelopeand Worksheets
compare and copy...
insert or delete rows without losing formulas
Inserting multiple rows in excel with data in consecutive rows
Combo Box Copy Issue
ATT: Chip Please help with progress reporter
Excel 2003 and ODMA
Run a macro within a macro
find text in a cell and make cell 2 cells below that active
Stop Macro button in Excel VB
"Could not load an object because it is not available on this mach
Macro to change of a cell
Time sheets
Excel returns hresult 0x800A03EC at inserting Hyperlinks (C#)
MsgBox with multiple lines
SEND KEYS?????? Please.... help...
Global or Workbook level variables.
disable customize option when right click on menu bar
Disable Customize option in toolbar
Converting concatenation formula to text
Change a formula in VBA
I need help with arrays (I think)
I need help with arrays (Still)
Visual Studio 2005 Tools for Office
Cleaning text boxes
.find help
Ctrl+End with VBA
Conditional Hyperlink (If statement?)
how to use "distinct" to prevent duplicate records
Insert Whole Row in Excel when one column is updated from Access.
Launch pivot table using Macro
Combo box
Create Outlook Task from Data in Excel Row
Display alerts error
Use Macro to Select All Files Within A Folder
Buttons they are moving on Me
Alternative to Conditional Formatting
Using Access data in Excel
Plotting Rows that have values
scheduling dates
On Error STOP!!!
Change vba code in multiple spreadsheets
Create new directory
Checking and merging content from several worksheets
ShowDataForm of Worksheet class failed
Using a range from different worksheet in VLOOKUP in VBA
change cell contents
please help me with this error...user defined not defined.
Shortcut
How to use SendKeys to interact with Internet Explorer???
Digital Signing/Workbook On Open Event
Replacing values on multiple sheets using a macro
excel formula for "next month same day"
Enter date in text box - copy to worksheet cell
VBA Simple question
How to insert date at opening
referencing/sorting arrays
vba code to access checkboxes within groups?
option button help please
Open file with unknown extra characters at end of filename
Excel 2000 List Maintenance
Query based on logged on user (Newbie)
Excel: only THREE conditions for conditional formating of cells???
Passing Userform Listbox to sub causes type-mismatch error
Defined Name Range (Application.Match)
Automating a checklist
Macro prompts user to run macro?
Preserve Current Screen Appearance
Wrapping Text in a cell limitations - Excel 2003
Conditional concatenation and commas
Automatically e-mailing a sheet
Auto Fill Form
Is there any way to attach a jpg thumbnail to a row
Unprotect Sheet Password in Macros
Filename and path
rondebruin script
Adding text after save
Query regarding macros and formulas
Research
Macro's
can excel be used to track billable hours
user form text box date problems
Combo Box - Match Required help
If Range Variable isn't Empty
Problems using Union All
Date and Time Picker resizing itself
find % replace
User Type vs Class - General question:
Finding and Formatting the 5 highest values in a range?
Date Macro filter
Combo Box Help
After Save
Problems with template in excel
Problem w/ worksheet change event
Print to file
If data added to Excel cell it automatically make's another cell equal zero
dynamic form updates
VB Macro for Excel
Concat values in two or more rows based on id and eliminate duplicates
advance data to next cell when over written?
Copying RANGE of variable length
I need to make MS word visible..please help