Excel Programming [Archive] - Page 75

How to make "("@")" work with =ROW()-1?
extracting data to csv from multiple worksheets
Simple change to list address
cancel the loop
Exproting Excel Worksheet to seperate Workbook
Problem with action on range change
Keyboard Shortcut changed after XP
Help with VBA Code
Printing hidden sheets with vba.
Sudoku Solver - Help needed..
Regional Options
Counting Minutes
Performance Difference - LCase vs UCase?
Help with autofilter
change firstrow variable to be the 2nd row value instead of the fi
Auto fill the next row in spreed sheet
returning value based on font color-repost
Runtime error 13-- Setting a variant Range?!
need relative cells instead of hard coded
Testing if a cell is within a range
Advanced - Search and Update
Help wanted with VBA code
Only show userform after startup of app.
VB Code Question Range(
Change Event on Dropbox
Autofilling Macro
Need simple prompt to save at end of macro
number from a cell value instead of a string
Extract Specific information out of xls sheet to a different xls
Referenced File
Filter then paste
Email Sheet
How do I add new rows with data simultaneously to linked workbooks
Formula to manipulate cell font
Create a dollar value
select last dirtied cell
Printing
Excel 97/2003 VBA merged cells
Events not triggering
how to switch pages in a multipage control by a commandbutton
Create message in linked sheet ---- newbe
help with sorting data in excel(Macro)
vba sort range problem
If Or not working
Passing parameter to a select query
SPOT THE MISTAKE!....
print result
resize Columnwidths Listbox
Pasting two named tabs one below the other
Run macro for all documents
security level
text orientation in labels
....SPOT THE USERFORM!!!!.....
Macro that searches 5 files .xls and in every worksheet in every file is looking for "text".
Use excel with java to store data
save / saveas specific filename.....with a difference!
Find Folder Size
unable to open excel file
user input for date and time
combo box + option all + use all functions when this is pressed
Wierd - when saving wb & protected...it opens with sheet 'down'
What is the selection syntax
Sending Workbook
How to set user defined format in VBA
OLE Excel AutoFilter
Error Message
Re: Graph Size not adjusting with Chart Area and Plot Area
Re: Any Good Book on Excel Pivot Tables
inserting a colored row with the department name
Wide Drop Down Box reduces to cell size after selection
For Tom Ogilvy
creating a button to activate another worksheet within a workbook
RE: Conditional Formatting Question
Disable VB Editor
send focus to a textbox
Generate Email Alert
Detecting Macro Secutiry Settings
What was ActiveSheet before changed to new sheet?
Excel on Windows Mobile
SaveAs Question
Custom properties for worksheets
Code to configure Spell Checker
VBA question
insert a row above the first one
Disabled richtextbox control in excel sheets
A few questions - newbie in VBA
Inserting symbols into Cells of a worlsheet
Cell that is below given coordinates
Transfer ListBox items to a range
Searching For Duplicates
Screening values in cells to create a sentence..
Select Multipage by name?
DDE Replacement?
VBA macro generating MD5
Saving only changes
pagebreaks after last department in a group, color header on first
VBA: Search for word in a file in Folder using VBA?
Copy range based on condition
Detecting Null
=HVIS
Running Custom Code if "Entire Workbook" is Selected for Printing
sizing a chart in Word that was created in Excel VBA
selecting and sorting a variable rowlength
Trying to remove hyperlinks
Trying to remove a list of hyper links
Access to this newsgroup
userform error?
I am stupid and don't know what the heck I am doing wrong on this pivot table!!!
Counting instances of an incident happening
Userform - with Commandbutton fill a Listbox with data..
saving a file
Sub Not Working
ActiveX Error 429, "Can't create object"
Search for text with specific parameter and copy
Sub totalling in VBA
New file format constants
Ned help with Resize function in Excell VBA
SumIf with 2 ctiteria
Range selection
EXCEL FORMULAS DO NOT WORK
FORMULA DOES NOT WORK
Animated clip art in Word & Excel
Numbering Worksheets
Kill Files in Excel 2000
X-axis values in xlLine chart problem
push a command button
MsgBox Problem
Disable Printing If Cell Empty
Search for a specific file's extension
sort doesn't sort numerically
Undo Command Button Actions
Help with VBA code for reliability report
How do I prevent unintentionally running a Macro?
macro securtiy
Forcing cursor to next cell
Re: code needed to update links
FORMULA WON'T WORK WITH LETTERS
Error 13...Mismatch
formatting all textboxes in a userform
if/then block within another if/then block needs a loop
test for secondary monitor...
get screen resolution for second monitor...
Disabling macros when opening a workbook?
What is the proper syntax
game in excel? is there a way?
resize column row headings
Strikethrough cells B2 to E2 (a "row", in essence) when A2 has a checkmark?
Conditional formatting for a row, dependent on one cell.
inputbox error when clicking cancel
Calculations across sheets w/ other questions
Delete Sheet w/o warning prompt...
formual in macro
Out of Memory Message - Code Problem?
Deleting VBA code
sort macro stopped sorting
.cells not applicable to range
Displaying values rather than formula in cells
find and select a cell
Calloway Golf Scoring System
Worksheet name list from range....
Codenames
Obvious, but couldn't find this either
Constructors for Classes
Some more help with code...Averaging a range
Re: Excel to Peachtree via VBA
Error in vba line
MS Excel Web Query
Automated Copying without links
Formula Scientific Notation Problem
EZ ??? - Conditional Formatting
format text through vba
VBA Formula Errors
save and email button
Subscript Out of Range when closing a workbook
check the name of a cell
Disappearing act!
how to maintain add-ins? (with toolbars)
Range Name issue
Count Dependents
Goto column A of the ActiveCell
Windows "Region & Languages" ComboBox Issue
Application.inputbox for another workbook
RE: Excel to Peachtree via VBA
Re: Solver Error
Max Sheet Threshold
button in a protected sheet
RE: Compare 2 range of data
Finding Maximum Within Range (Looped)
Reconicle with Arrays
Maximum number of DDE links?
Pasting two page one below the other
remembering the nth item in one sub routine in the next sub routin
Overriding ScreenUpdate function
Re: Help with an algorithm
BottomRightCell ignores hidden cells
UserForm initialize
Compatibility Excel VBA WinXP vs. MacOS
Record sets?
How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
Addressing a Help File
userform value
Advance handling with duplicates
multiple graphs in excel
Copy latest date from one workbook to another
Find same context in to dif. worksheet
OnTime code error "can't execute code in break mode"
How to put a calader object on a form???
Re: Can a TextBox on a user form activate a popup calander for dat
integrate output from various workbooks in one workbook
Triple state command button
Dave Peterson...
Spell check query
Workbook_Open doesn't run
Spell Check Query
Access current active workbook from DLL
Auto Save
UDF -> 256-Char -> UDF = "#VALUE!"
RE: statistic using excel data pls help!!!!!
Transfer range to array etc.
Re: Function failure
Clearing Non-numerical CellCvalues
Print Rows
How to code this
Using Excel VBA to create shape in Word
Re: Help with an algorithm
Re: looping through variable defined cell
Re: Hide Columns
Re: Code for ComboBox
Re: running macro after refresh of extenal data
RE: If Statement Limit
Warning message about potentially non safe ActiveX controls
Re: Filtering worksheet in VBA
RE: Code for ComboBox
Re: filter to new sheet
Re: How to Sum
Re: Put the split cell option back in Excel.
Change errorbar series data from vba
Specific Conditional Selection
Saving Selected Worksheets
Open workbook form from Add-in
Import Data into a Formula
Start up folder v Addin folder
assigning a macro to the tab key
Using cell value to reference another cell
Error in Excel 2003, OK in Excel 97
How do I create a User form to input Data into an Ecel spreadsheet
Copy Range
Generating a List
vb function in personal.xls
Excel Templates and databases
PivotTable problems downloaded into IE
Change Error Messaga from Sheet Code
Macro needs data from hidden worksheet
changing button prop with vba
Bringing up a message box if values already in cells - Help!!!!
Excel 97 clearcontents method fails
ComboBox update
VBA and File System Object
userform open when sheet activated
filename in "Subject" in email
Loading Data into Multiple sheets in 1 book
Macro stops @ row 300 with count... how?
InputBox method with range
Problem with managing excel embedded with IFRAME
trim "/" from date
Turn Check box on?
Formula not adding right
WHY OH WHY DOESN'T THIS WORK!!!!!
Changing the textbox value without changing the textbox format?
Building an address
Sums, Filters and Events oh my!
formatting data for import into ms access
Add a new column to a worksheet
Auto Program Pivots from a userform
current workbook name
How to prevent Excel from formatting Dates ?
Getting a macro to work in all workbooks
Save user Menus and Toolbars Status
Proctect when closing
Splash or message box that doesnt pause
Freeze Panes
Defining a type of the cell
application.run 'current' filename?
application.run \
CHANGING POSITION OF AUTOFILTER LIST
Userform, listbox and ActiveCell. I'm stumped
How to Unprotect Project Protection through Macro
excel should let me unfilter all columns with one click
Unique Value by Advance Filter
MinMax Button
problem (maybe simple) displaying certain text
referencing crystal report
Looping through Range...Slow
Finding worksheet
IF function with link to different lists
dfg
Filling cells
how to autorun a macro from personal.xls?
Formula assignment problem
sort data?
adding two highest numbers formulae
DIV/0
Sorting Collection
can I use text color to set up a formula in excel (Red text = -1)
interior color of macro
Check range before pasting and modular approach questions
short cuts
Read Keyboard Buffer ?
Recording highest and lowest ranking
Re Countif
application or object defined error
What have I done?
Creating A Breakout List from a Summary List?
Hide code
UserForm Loads Slowly
Hide Combo Box
Weekly Totals on sheet
Workbook_Open() Not working
Problem in Excel...String of Ranges?
sorting problem with range definition
Ensure Named Range is in ThisWorkbook
How does one show an intital value in the combobox
Format date in combobox
Formatting Numbers with Decimal Places
range selection for a sort on a excel db
merge text
Data Collection File
Random Numbers
Run-time error "5" after range().delete runs before querytable.add
IF Statement
Html controls in spreadsheet
Reading Comment Formats
Creating a UDF from a VBA routine...
Macro to hide column based on header name
ONe Macro won't call another
How to add user input to determine a variable in a macro
ComboBox Decimal Errors
how to use a knob or level slider in microsoft excel
Shortcut in c#
VBA(Excel) tests
Message Box Coding question
Getting Worksheet name in Reference Style
create cell reference in formula
Date (dd/mmm/yyyy)
VBA cell content check
How do I build "hide a row" into a macro if #N/A appears in a colu
footer
problems iwth VBA code- for each loop
Named range in an array
Promt When Closing
function
Find duplicate records and delete
Weird AddIn behaviour
CountIF Question
how to resize the comment in a cell
Multiple If Statements
Moving Data
How to set Paste:=xlPasteValues for all paste operations?
Excel Crash and/or Gray Area on Screen
Reorder numbers from one cell into another cell (123456 to 341256
Problem formatting decimals in ComboBox
Copy last 12 rows after filtering
adding test and cell address to combo box.
Excel.exe memory issue - Resolved in 2007?
Array question
I set up a macro to hide/unhide columns. It hides more columns
adding named ranges without a "-"
record formulas
Before Double Click
Add sheets with name as in cells in a specific sheet
How to add and delete pagebreaks using Excel and C#
Customize "Dynamic" List
macro
Trigger macro on value only
MS Query refreshing in order
Date issue with if Statement
How to transfer data from a system to Excel
BAD FILE error
creating/distributing patches to excel workbooks
Programatically specifying table for web query to import
Consolidating data from several sources to one target book
Automated formula coping
Selecting ACTIVECELL range in Macro -
International dates are not recognised by autoformatting
MS Query drops column aliases on certain queries
Selecting 10 cells downwards
I need an excel sheet to creating a new folder every month, and save a new spreadsheet every day, untill the next month, when it creates a new folder
ComboBox Update
Find and display
Add Members GAL
Members hinzufügen Globales Adressbuch
where can i find my personal.xsl?
How Can I count disagreement??
uses of add-in?
how do i set up my own drop down list with my information on it
open outlook from excel to email out
Return a stored procedure value to Excel
Userform Show
run-time error '1004': unable to set the ColorIndex property of the Interior class
Copying Userform with Controls OR complete application.
Outlook reminder
applying modules to mulitple worksheet
change all the autoshapes
Automatically email a worksheet based on criteria being met
shape objects, displaying text, extra info??
Custom Formatting
Summming a Data range through a cutoff date ?
Removing a module
Multiple Worksheet Selection
Adding Rows to Multiple Sheets
type mismatch, can't open a workbook?
How to check if one of the conditions returns "true"?
linking workbooks
More detail on dynamic combo box
Is there a way to interrupt "Ontime" macro once it is started?
Autofill for checkboxes
pasting
Saving File with macro
vba code to create pivot table + group fields
Format Text Bar In Userform
Add Newline(s) inside a Cell Without Splitting Content into Different Cells
Add Newline(s) in a Cell
Add a Newline in a Cell
Pop up box Help
inputbox to import file
Problem distributing User Defined Function
Automating the Fax Consle to send faxes
vlookup if not in Table
Nice Looking Color Palette?
Conditional formats and macros
password protection via code
Help needed on Macro
hollidays
If-Then-Else Statement
want to save a copy as text , not save the original as text
Excel Lookup in Access
Using Find in VBA based on font color
unable to get match property of WorksheetFunction class
Problem with saving Excel Template opened in macro
Format Cell- Border Line
Overflow
prevent error message
Changing the color of a cell and adjacent cells based on conditions
How do I find Templates for Horse Racing
Loop through single column of named range
using ado to query the contents of a spreadsheet
paste formula
sendkeys to a launched IE browser
Weighting Costs over time
AutoFiltering with Grouped Data
Multiple input variables
Setting calculation mode via a macro
Help With Referencing File Names with Spaces in Them
ComboBox Aktualisierung beim Starten
.additem
formula
Using VBA to copy Excel Charts to Illustrator
Format issues...
Excel crashes on closing after SendMail
Hiding rows and columns in a procedure
autofilter
Code returns TRUE instead of value
Code for MsgBox
[VB.NET] Inserting Relative formulas
convert R1C1 (international) address to A1
Allow users to edit rangers
Hardcode
Relative hyperlinks help
Run time error 1004 generated in Excel (Office 2003)
Formula/macro help
How to make last cell in current selection the activecell
Mobile-Softwares-Songs : http://www.mobile-softwares.info/
Additional Macro Button Picts sought..
Excel solution deployment issue
Obtaining a value from a cell and using it in a macro
How to use count of records in code?
Retrieve data from Oracle Database
Dont Show Zero Values
textbox formatting questions
Type mismatch when calling sub with array of worksheets argument
vlookup problem
SLL based Web Service Access
SSL Web Service Access
OnTime+TimeValue + Autoclose
Urgent: Enable All of the excel command bar
saving local inside the workbook???
run-time error 1004
Loop through columns
1st and last date of the month from MonthName
Search for file with *. extensions
check to see a file is existed
String or integer?
Get the date a file was modified
Inexpensive and easy to use installer for Excel
how can you add time using hh,mm,ss,tt
worksheet protection?
Distribute Excel Application
Pasting from the clipboard to the address box of inserthyperlink dialog window in vba
save and close automatically an excel spreadsheet
jump to link
KeyCode
Search through subfolders
Using Excel functions in VBA
strings in a range
Comment Font Name trouble
Chart slice colours....almost works
type mismatch
trim
Convert text to upper case format
Seperating Numbers
Conver Text to upper case format
Insert row numbers
Ron DB
Set print range for individual sheets (ranged) in workbook.
RGB Color for font
#13 type mismatch error on user form
Formatting Formula Results
Make rectangle border solid
command button and the "enter" and "tab" keys
Help: copy sheet format
copy-past and lock cel!
time interval other than forms
Timer in Excel
Input box to cancel sub when Cancel is clicked.
Make last cell in currentregion the activecell
UserForm Problem
Improving File Writing speed
Help required on a formula
Search and replace PivotTable sources
RE: Selecting the non blank from 4 cells...
Sorting with Groups
Selecting the non blank from 4 cells...
subtotal automatically update
Migrating from XLL to XLA
Refer to customproperty by name?
How to sum a data range thru and after a cut off date
Error 91
Omitting data from pivot tables
Help on e-mailing worksheets
Preserving leading zero
Duplicating a number in a column
Can I make hidden cells inactive so formulas ignore their value?
forward compatibility excel 2002?
Row & Column
Reading from a file
Help with For..Next Loop
special characters from vba
ActiveCell and TextBox
VBA code for Date ranges
Search and extract
How to change to time format?
print form with data from other sheet
working with a group of sheets
Procedure too large
Dates using Regional Options
fill array with only values
Formatting A Pivot Table
Need help with named ranges
Disable PrtScr
Counting a range of cells with TEXT
COPY A FILE OUTSIDE OF EXCEL!
column hide
Copy Columns A to I Problem
More Efficient If function
Error when Execute New Procedure Created Using VBE
TextBox_Change a little premature!
Module call
protecting sheets
How to use Open as Append for log file
Delete from control button
Extract value from formating
EXCEL: VBE code for a push-down stack (Date,Value1,.....)
file association
Increase your Karma Points -Help a newbie out
Why do my outlines change on my pivot table when I add new data?
cell value
Adding custom property pages to Tools | Options
Re: selecting filtred range
Macro to insert data from another sheet stops working
Workbook_SheetCalculate Events
Baffled by calling a private function
just weekdays
Range Filter Problem when creating new sheets
copy range of cells with blanks then paste without blanks
columns identification
Disabling a range of cells
Delete Records according to One Criteria in one Field
Copy/Paste doesn't trigger macro
Filtering
realplay.exe?
time delay
separating first and last names
Filter based on Date
conditional programming
Alerting user if file not open
Create a splash screen in excel
Division Formula
Using cell name to open workbook
Format changing to General
Workbook_Open
Worksheet Functions
help on looping structures
Return formula minus = sign
Nested IF statements - simplify?
if x=3 find 2x+4 using excel
Using Font Colour
Userform list for more than one column of data
Execute Upon Opening
VBA to create Pivot table from text file
I need to do a arithmetic if than formula
Link two worksheets....
Lost Automatic Row Height
Filename variable
How to pass data from UserForm to spreadsheet
Formatting Formula Results
MACRO Question
Ubound(x) gives rows in a range-array - but what about columns ?
Shared drive issue with Excel.
Deleting Names in a Workbook
Format Cell with Mouse Click
select open webpage, copy information to open worksheet
Macro or VB to copy data between two workbooks by column A match
Vlookup macro run time error
Please Help Adapting this Macro
setting combobox style using vba
adding a second axis crashes work of art - please help
Defining a range by the contents of cells?
NEED HELP - How to Publish Excel file with Macros in Web.
Please Help: Transferring from Dictionary to Array
Paradox with constants
Chart Activate event not triggered when workbook opened?
POInv macro w/ if then statement
Don't save file if condition is met
macro is not saved in project but in a project.txt version
If then for POInv macro
Linking to other spreadsheets - complex formula
input data and automatically move to next row
Using Macro to update Links
compare strings - highlight characters which are different
Help with Shell to Acrobat Reader
i'm looking for VB code that does the same as hitting F2 in excel
how do I make a spreadsheet compatible for a Q-Byte FM upload?
Deleting Repeating Values from an Array
runtime error 1004 saveas text file
variable not defined, ActiveWorkbook.name
Date Stamp in one cell when data in other range changes
filter and delete rows based on two criteria
How do I set up a COUNTIF with more than one condition?
I need one cell to populate another cell with a $ amount
Help stopping when row is blank
Gradebook Question
Runtime Error .Refresh
Filter by user-submitted date range
Using VBA to Find Text in a Powerpoint file
Collation inconsistencies
I need to search for then extract a specific portion of cell data...
VBA line numbers
Downloading Files from Web and Associated Filenames
3 option buttons, okay, cancel, NEED the form to stay up
Events on controls generated on the fly...
userform labels
check boxes
Date and error checking
code for closing out an excel file while in the browser?
Strange looping in User-Defined function (Excel XP)
How do I automate printing ...
Recording maximum and minimum
Can't create a spreadsheet from a word doc?
Group sheets using code
DDE Links
Why does Listview control shift to top on multi-page form?
dynamic form checkbox question
copying and pasting two rows of formulas every other line
Problem with excel workbook switching
Missing measure in a privotchart "data area"
Re: Return single value from multiple criteria/data table
access to info from windows and unix servers
Excel 2003 error message!
match multiple criteria using VBA
setting LinkedCell using VBA
Subtracting Night-time-hours
All pages to open in page break mode
DataObject in BeforeDragOver has no format
go to first empty row
Password Protect Macro
Using Macro to Select Worksheet
Add/View/Update/Delete buttons
Charts: not plotting zero series
Insert picture into protected sheet
VBA project duplicated in Project Explorer
Find macro
ActiveCell and TextBox
Export Automation error
#N/A
Copying latest date from weekly workbook
subtoal update automatically
Apply conditional formatting to non-blank cells
Scrolling to top left corner when window panes are frozen
Routine to restore drag from- and drop to- areas/cells?
Working with ranges in arrays... or an introduction to arrays
Pivot Tables Drop Down Data Appearing Twice
Shell Doesn't Work With UNC - Can't Get ShellExecute to Work Either
Password Protect - put password in a cell in the workbook
HEX2BIN
Macro to automate MSN Stock Quotes?
Auto Running a macro when a field has changed
What is True ??
Change settings for print
coloring a cell only if there is a value entered in it
Chart_Activate not running when workbook opened
Sort on 3 keys
Defining a formula
Help with pictures in excel
Auto Column width for new sheets in workbook?
Print Excel Directly to Printer
get the current filename as a variable
Empty VBA Help Topic Windows
Pivot Table Relative References
how do you get an excel hyperlink to open a new target window
AutoShape Re-Sizing IS KILLING ME!!!!
Need help on my Jobs applied too SS
c
passing multiple parameters to a Stored Procedure
Block comments in VBA
SaveAs error handling
Re: Cell format
Prevent mismatched columns following sort operation
Copy text cell & change text color conditionally
macro to save a file
RE: Cell format
Modify Macro
Help with this
Locating my posts
Automating online report creating process
Group and adjust columns for several sheets
Custom event handler? i.e. Before row delete
Running a macro from Access in excel and then refreshing external data in excel
solver for if statment and discret function?
Alter Mulitple Protected VB Modules
linking workbooks
Custom Error Message
Min()
Problem using an Excel 200 Add-in
Opeing Excel and Word documents in a WebBrowser Form
How do I look at other documents?
xl* object definitions ??
Hiding rows containing zero in certain column on multiple sheets
Enabling/Disabling/Hiding/Unhiding Newly Created Menus and Submenu
Excel cannot complete this task...
Problem with Solver
Set a range name
Importing text from a Word bookmark into a spreadsheet
Disable save, save as, but allow save via command button
Replacing data in a row of sheet1 with data in a row of sheet 2 based on a field in both sheets being the same?
Clearing rows after autofiltering
Formatting cells
Call the Save As dialog
Extracting data from SQL Server using excel
Creating and Appending to Access dB using VBA
DisplayAlerts not working?
VBA Code or Macro Help/Advice Please
File upload
VB beginner
VBA Code
Wild Card!!!???
Import data from other Excel file if file ends with "[directory][filename].xls"
Nesting worksheet_Calculate inside worksheet_CHANGE
Context Menu (Sub-Menu Disable/Enable)
Strange problem with formcontrols
select
Newbie: Find additional text strings
Excel "Available Resources" Error - Repost With More Info
Setting Application.EnableEvents=True after Thisworkbook.Close call
Adding extra formatted rows
Fitering/Matching Data based on various Criteria
how can i use vlookup to find data containing pictures
Duplicate values in column A and different in column B
Saving embedded OLE object as file to hard disk
open powerpoint using visual basic in excel
how to use codenames with an addin?
Need Help with PDF format & PPT image
Add new workbook with new name
Creating Formulas in Pivot Tables
Name range based on Cell content
label caption changes depending on activecell
vba to filter the rows in excel by their font color
import data from excel
Macro help/advice please!
Need to add values based on three other criteria
Transferring Columns to another sheet based on Cell values
decimal number convert to 16bit binary
copy / paste -- vlookup combo ???
Set chart to show positive numbers only
insert row with formulas automatically
Delete all rows below my data to the bottom of the sheet
Toolbar problems
Play and stop sound
Create Sticky (Always-on-top) Popup
Determining the full path and filename of an active workbook
Have Excel send information to another program?
Split Cell Data using Excell 2000
Find last used row in named range with data all around
use LIKE within sumproduct in macro, possible?
Help Opening Website using VBA
Userform crashing excel
Enabling/Disabling Macros w/o closing & re-opening
paste special
call a userform
calendar
Source Data for Chart
vba script code - for emails and creating directory as req'd:
Need help on my Jobs applied too SS
what is the maximum number of worksheets that one can add to book
Pivot table - filtering out rows that have blank columns
SaveAs uses current open workbook filename;
Adding additional rows BEFORE first blank row (????)
makeing the pictures visible or invisible
new to VBA programming
Hideing and unhiding worksheets
Reset Delimiter when opening text file
hyperlink can't open
delete non adjacent columns when blank
Copy data from above rows in cells are blank
Finding the last increase/decrease of an series of data (row)
Formula to search for worksheet name, then calculate
Removal of " "'s in my VBA routine
Change cell data using excel 2003
Changing database link using script editor
Summarize Multi Worksheet Data
Delete Rows With Specific Text or Values
crashing personal workbook module
corrupted form in Personal Workbook
How do I print various sheets from a spreadsheet to PDF via VBA
Can Step through but when run defines variable wrong
Automating Internet Explorer with Excel VBA and JavaScript
current date
Runtime Error 13 - UserForm
macro doesn't compile after module crashed continued from scary th
Count number of characters until encounter "&"
AddSpaceAfterComma
scary thing happened P.S.
scary thing happened
VB Function Needed - Differentiate between a number and a characte
Define Named Range
Hmmm, Where do I begin???
Multi select dependent on cell in range
macro button to be associated with specific speadsheet
macro button to be associated with specific speadsheet
How do i format cell to change colour as the number increases
Ping a Set of IPs
Creating a custom formatting Macro
Precision of Points
Checkbox Problem, Please Help!
Drawing Objects
How to trigger MsgBox for this event?
Macro Help
Data Formatting & Parsing
Using IS statements
Tabbing between textbox's
Macro for Merged Cells
date formatting error
With statement
ActiveCell changes contents of TextBox
How to delete programmatically a pivotcache?
Horizontal Scrollbar partially Hidden by Taskbar
Selection with one object
Reconciling Data Ranges
Retrieve Row Index Number
HIDING ROWS AND COLUMS
sub slow down after page prview
How do i find a cell that contains more than 255 characters
Concatenate>>Format>>Math
Trying to creat a Macro to count rows and more
October Excel / Access User Conference
excel
Last Row/Column Question
Cell value = adress. How to select in VBA?
Automate excel in a way similar to mail merge
Array question
arranging row based on a column
Opening and then saving closing workbooks on a conditional mannar.
New toolbar button
Code to run dialogue box at workbook startup
Class modules: parametrize class object fields
check whether shape is a group
Newbie: problem referencing cell range between subs in the same mo
Hide negative values!!!
CONDITIONAL FORMATTING- DATES
Can Smart tags recognize functions / formulas
Auto sheet scroll sub
printing forms
Combo and list boxes headers in excel 2003.
File System Object
Prevent automatic calculation for workbook being opened
Prevent automatic calculation for workbook being opened
stopping Windows Media Player using VBA
Problem with 'Workbooks.OpenText
Copy from Excel and paste as bitmap in Word
Ascertaining whether a search in VBA code returns a string or a reserved word
is there a way to Update MSN Quotes using a Macro?
date stamp with protected cells problem
bin2hex
Delete email after Excel form sent
UCase with Worksheet_Change and Target Address
Input box not working with IF statement
defining a range compile error
Create chart at a cell address?
Help! Basic Macro Question?
Newbie question regarding using Sub Worksheet_change()
Accessing Excel Sheet
Is it Possible to do
IF Function
Using the Print # statement, I can't get double-quotes to work
grouping sheets
X & Y Coordinate return value
Workbook_BeforeSave - Prevent use of "x" filename on save or save
Simple Paste Issue
How to prevent user selecting chart
Need help utilizing the lastrow type functions
error handling date
Disable Sub-Menu of a Context Menu
Pick a graphic from a combo box
How do I remove repeating data in an Excel database?
run time error
How to Copy and Paste a variable range
Macro wtih sumproduct 2 help
Downloaded numbers from the web are stored as text. No Good
merging multiple files/sheets into one
Convert seconds to h:mm
Copy Cells/Paste Cells Programatically
Hide Entire Row If Cell = 0
ending vba
Hiding rows w/ "" cell and printing
Macro?
ADO Field Size SELECT
Using DateAdd function with cell values.
How To Get Into a Password Protected Workbook
Macro Compile Error
ADO recordset XML format for globalization
Reference Column by #?
Highlight
Question about Excel (Office) auditing/changes
Use more than one module
Populate workbook dynamically??
15 MB of Heap Space Too Much For Excel?
VBA code not working- repost to further explain problem
tag different modules
Log changes in a range only
Last save date in excel 2000
Restricting Paste in Excel
How to find the number of used rows in a spreadsheet?
Change hardcoded filename
run addin function from macro
Macro help
Chart Data Table Object
Need to select 4 cells and merge them using Excell 2003
Mouse Coordinates
disallowing insertion of rows
past method error
Textbox Value not updating
Argument not optional
Importing data from multiple Access queries
.OnAction set value
Help with a Macro?
Please help me find the problem with this
Selecting an unusual range
Overlapping DataLabels
Excel 2003 F9 wierdness
Picture on spreadsheet will not print
Dragging a range of cells
Chart syntax
Help with XLM 4.0 Get Document command
Header Font and Range Value
unicode CSV files
Almost working using...
Possible?
calculating from other sheets
How do I combine different workbooks into one?
table changing
Code Execution Error
how to enter data on multiple workbook at the same time
Merge / Add / Combine Sheets from different Workbooks
Filling comboboxes in loop - problem
How to recognise "#N/A"
File Protection
Scripting Runtime
Preserve last selection of an OptionButton
Error opening Excel 2003 in ASP.NET
Office XP VBA can't find reference after saving by Office 2003
Kill file
Set Current Date
MultiPage exit/change event
turn off design mode
Passing focus to another application
Return to active cell after macro completes
How do I lookup large number of workbooks (by filename) for data?
macro with SUMPRODUCT help
Retrieve cell value
Finding the last item in a group of ranges
Separating / extracting words within a cell