Excel Programming [Archive] - Page 149

How to set variable to nothing
Dynamic Outlook Form with Access as datasource
Interactive Excel Web Page save updated data
changing font colour of row when cell contains date
Print Several Pages as One Job?
Difference between .text and .value of a textbox
Cells.Find > error Object variable or With block variable not set
Copy entire file using VBA
Function/VB Code for finding pattern blocks in number sets?
VBA - inserting text as link (email to)
2nd attempt at excel VB commands
Check to see if variable is duplicate.
Excel Constants for maximum number of rows, columns?
Text Box Link to Cell & Reviewing Toolbar
trouble returning a workbook level Name object
Save As
Re: Can a macro write a macor
Using function from vba add-ins: looking for a solution
So close yet so far - combining workbooks
How to disable an other subroutine temporary?
Excel 97 Pro: VBA5: Illegal Error
Inserting dates in a worksheet
Conditional popup
functions across sheets
Repeat Entries
Correlation of Variables
Re: Move Folder Contents
Add bold font to Totals row?
Users on a Shared workbook
Date Filter?!?
Return US State Name or Territory from USPS Abbrevation - an example
Can a macro write a macor
New Main menu item
Auto opening macro when loading a workbook
Re: Visibility of a command Button
Re: Bummer2
Re: Visibility of a command Button
Workbooks.Open doesn't open file in ThisWorkbook
Displayed value in a combo box
Visibility of a command Button
Multiple column listbox syntex question
Inporting data from a group of .prn files
Disable sort function
Re: Conditional Formatting a range of cells
Re: Conditional Formatting a range of cells
Copy file and closing original
Open workbooks with different names
Code to Print to certain Printer
Can You Query Specific Access Records from Excel?
Better code needed
Check if a directory exists and if it doesn t...
Ftp an html file generated by an excel macro
newbie question
Bummer
I know VB, but how to use in excel?
Excel Macro & Virus
Data management error?
Can ActiveX controls be "disabled" and "enabled"?
HELP!!!
Detecting If An .xls File Exist
Automatically Insert Sheet
Delete Shapes
Cells as customer footers
Limit printing to certain 'pages' based on value
More 1004 Errors...
CountIf: Syntax and Examples?
Opening zipped *.xls from Excel
Does Outlook interfere with Excel memory assignments?
ActiveX control name change?
merging
a funny problem
Formatting returned value in TextBox
Conditional Sum Help Please
VBA Worksheets() term
Apply VBA function to multiple excel files
mailing new workbook in VBA 255 character problem
Modify date of a file via hyperlink?
Re: Custom Menu
Populate combo box for Userform in Excel 2002
Find duplicates
EASY - Excel VBA Problem
merged cells problem
drop down list sorted and selected by first lette
Hyperlink problem
listboxes
Web Brower control question
Cut the umbilical cord? Access connection to Excel
BeforeUpdate event for Combo box
CutCopyMode = False
OnAction to show a userform
conditional formatting under a condition...
returning a spreadsheet from code - ASP, OO4O Oracle Database connection
Setting OnAction of custom menu item?
Compile error using Call
How can I improve the find method?
Changing a chart source data in code.
referencing another workbook
Help: How to Get Fields Mapped (using .Net ?
display quarter and fiscal year
Passing Execution Control Between Workbooks
API to draw borders
New Menu/ toolbar distribution
Replacing instances in word with data from exel
Hey Bob I mean Don
Weird VBA problem
Can you turn Conditional formatting off in macro?
counting spaces in a string
Conditional formatting not working!
Listing macro categories
Changing the text in the top excel window bar to display your own. (Tip & Question).
CumulativeFunction
SaveAs and Replace File
how to add a combo box in to a excel cell using VBA dynamically?
Delete Entire Row in Excel if specific column does not contain a 7-digit number
Averaging in VB
AcitveX with admin rights only
Screen Tips
Frustrated - List Box
the vba book
Add-in help files - where to put them
dynamic ranges getting invalidated
Listbox's and retaining data when closing
Excel VB - Macro for mixed fonts
autosave workbook
generate chart with excel
Invalid Name in Macro
Creating a CrossTab Report using data in variant
Deleting a negative sign from an amount in a list (not trailing negative)
expanding IF
count days between dates
Excel & MS Sql
VBA macro easy problem!
Open a File "Quietly"
Making A Nacro To Change The Contents Of Many Cells
Can xl 2002 not have multiple icons on the taskbar?
Retrieving a deleted module from VBE in Excel
referencing a named range using a variable
xlFill
Validation through VBA using string has 255 char limit??????
Excel: Paper Page Width
Close without save
.AddComment
VBA Password / Program freeze
How to hide pre-defined columns at the touch of a button
spin button
search for date fields
Adding a border to a jpg image
Sheet tabs with Date and Time
chart menu bar vs worksheet menu bar
SelfCert.exe error
Create an EXE from a spreadsheet?
Create an EXE from a spreadsheet?
Combobox Selection
work with strings/numbers and dates
Sending an email to more than one person.
Is it possible or is it impossible?
Re: VBA Question - Canceling a 'Save As' command from a user form
Sorting embedded fields - control box
Combo box help
Prevent adding rows
Automatic Percentage Calculation
Error 1004, "select method of range class failed"
Search Page for Inventory Workbook
Embed Excel Spreadsheet inside an HTML page(IE)
speedy way to set values in a range
variable range definition
Specifying cell reference relative to active cell
Userform Close button
Please Help.. copy,formatting issues
HLookup function question
Creating a new workbook.
Printing multiple sheets.
Drop Down Lists with "variable" ranges?
Re: how to disable a macro by calling it from another macro
Filtering Text File Import
Pivot Table Question
VLOOKUP in textbox
Re: VB error message
Summation
Re: custom menus
Automatic updating
turninf off macros
Custom Functions
Pivot counting error
Re: Sub-Totals within timescale
Form/Listboxes -- problems
Help with "Autofill" Destination Range
Capture mouses X &Y position on a worksheet
Re: Sub-Totals within timescale
Re: Saving Information on Userforms
SQL and Excel
Select in Listbox using keystrokes
Data Series
Re: unassign a macro from a graph
Calculating times under the second
Multi Column Lookup
Re: Printing Sheets that only include data
DAO text database
delete blanks
Search Box & Button for Workbook
Hyperlink problem
Macro to search from one file & place on another file.
Create toolbar with VB (notVBA)?
Count of all non empty "records"
Using VBA, how to write unique solutions only?
Re: Sub-Totals within dynamic times
Make a column two columns
Re: Check if a range is a sebset of another range
Deleting worksheets containing ActiveX controls
Problem with ADO with Parameter Object
Copy Recordset into array?
ADODB
Re: Check if a range is a sebset of another range
Re: Make a column two columns
Excel VB
User form manipulation
Challenge
Date and Time
Re-create source data from pivotcache
Closing Excel down with a macro?
unassign a macro
Scheduled task hanging
Static Variable
Excel97 CopyWorksheet Problem
stop calculation
Copy range without changing sheet in view?
Coloring Cell if Data is present
Calculating Time
Prompt For User Mouse Input In Macro?
Wrong Macro opening
center picture over cell-Help
sort of mail merge in Excel
Copy Cell Data from one Worksheet to Another
Opening Word Ducuments From Excel Macro
A hundred of series in a xlScatter Graph.
Save values only before save
Select pull down menu
Disable Access to VBA Code in XLS File?
Pivot table - Ghost data
Rearrangement of reported data
Input box to formatting????
Printing Worksheet only if data exists
File in use by ? WHO ?????
Novice in exel macros needs help
% and $ formats in excel
Option Button Quickie
Finding difference between two cells
Save .csv file. Decimals separated by commas
Code-signing certificate problems in Excel 2000 with Windows 2000
Incrementing a receipt number in Excel 2003 VB form
Application.Undo Problem
Problem with Microsoft Query
How to interpret a path to another workbook and use in formula bar
Help needed, Input box doing 2 tasks?
how to consolidate list of qty under within date columns
Counter
Re: Formula
Send link to Excel spreadsheet
Using Excel as a Server for Web Application
Avoid Deleting a Shared Workbook using VBA
Date problem
Unhide sheets based on NT login
Chart window - excel
Round problem with sorting
return from subroutine
date...
very urgent
Checkboxes on a Shared Worksheet!
XLA help files
Copying VBA modules from one workbook to another with a macro?
Macro to format selected cells
Question about saving a *.dbf file
Open/Close files from Hyperlinks
User forms
merging two excel spreadsheets into a new one
A Challenge! Can you handle it???
Error 1004 help
User Form maneuvering
Why can't create Excel.Application using CreateObject?
VB6 + Excel Objects 8 = 100% CPU on Win'NT
Hidden hyperlinks giving me a problem...
Change Icon of a Shortcut with VBA?
WinXP: Solver: An unexpected internal error occurred ...
How to copy data from excel to Word? Thanks for your help!!
Export Picture
Re: open with full screen view
First and Last cells with data in a range
updating paths to linked files
Protection
File Open Macro
Re: InsertRowsAndFillFormulas
Re: InsertRowsAndFillFormulas
Userform - VBA Programming Question
Area Charts, area colors and series
Using a function from a vba add-in: is that considered an external link
Code compiles but Excel ERROR
deleting worksheet
very big problem..Who can help me?
How to position form in same place with different screen resolutions
How to hide a workbook and to detect a hidden workbook in visual basic
Macro Close 2
Referencing Macros
Application error with VBA code
Send email with Lotus Notes
Count Print Jobs
Pivot Table Page Field
Cell reference question
Unique Excel Web Page / Macro situation - HELP!
Excel Pivot Table Problem
Here's an interesting one...
Illegel Error on a Function Call
Printer Dialog Box
Array Help?
Importing CSV file into Excel
Which graph?
Re: Color rows
Thanks!!!!!!!!!
Irfanview
How to specify a Range which includes an integer variable
Close Macro
external file counter
modules that run modules
DDE Troubleshooting
Copy rows and paste to new worksheet
Reference Library
Run time error '-214741848 (80010108)
Do you give memory back?
slow sorting worksheets
Specifiy Printer (Location/name)
Print to PDF with given filename
how to enter 'CTRL-SHIFT-ENTER' in vb
Dynamic Range Selection
Excel 2000 Web service programming help
Sending an email from a macro
Replace first part of SS# with x's (XXXX-XX-9999)
Issuing DOS command in VBA macro?
Populated Cells In A Named Range
Re: Creating Loops
Save file as text pipe delimited
Re: Find and replace thousand of cell values
I'm looking for a macro that opens directly to the Pivot Table layout
Program Files Folder
Adding a border to a jpg image
Print Setup
Custom validation criteria!
ActiveX Combo
why this code doesn't work?
declaring active cell inside a for loop and offsetting from it
Printing in a list box
Viewing PCX Files
set up page numbers
Calling Procedures from another excel sheet by passing objects
 
Loop through cells
Selection.Sort not working?
Last Cell Code
Re: How retrieve GUID and Document Properties
Directory Search
FormulaArray..... HELP !!!
userform variable as global
Running a CommandButton in Excel I get this error
Run Macro on cell exit
Re: How retrieve GUID and Document Properties
Using User forms to enter data into lists
Imports
Re: Focus on Control before UserForm(s) pop up
returning a chart series formula
Declaring arrays
autonum field
Latest 24 hours avarege
Insert Picture in Worksheet Question
data validation problem
Create CheckBox from a row
Why Loop only happens once? Baffles Me...
Excel Macro sharing
Help needed selecting left cell same line
Guru Challenge
conditional formatting formula
list ODBC source
Colours
If Debug then end with msgbox
Minimizing Excel from a Macro
Where to get a visual tree-like object like the one used in the watch-window?
How can this be done?
Automatically transposing
How to create Dynamic interrelated ranges in excel
Another last cell detection problem
Excel2000 VBA problems
Identifying Excel version
Searching for worksheet
Send Excel File With Outlook
How to escape the Workbook Save?
Automatic importing of a macro
Open Access document whilst in excel
Preventing Excel opened through webbrowser "taking over" other instances of Excel
Finding all Similarly Named Ranges?
Print macro for Excel 2003.
DATE Functions???
Copy Values, not formulas
Validation
Use of Offset Formula - problem with blank data
short cut
Cell validation!
Undo button
Use file-status in IF ... THEN
Characters Object limitation?
Is There A "Choose Cell " Event?
Calling Alert message!
Automatic Dates
Read in Array
Drawing a semi-circle in Excel
how to know the column/row of a selected cell in vba?
Disable shift from ignoring autoexec
macro and button to open a word document from within excel
Olap Pivot Table
External images
Excel AutoFill
Another Time Calculation Question
Data comparison
Protection
How can I skip a (Sub)Folder in a Scan?
For and If Then loops, and remembering a value
Set value for range of cells!
ocde in a different workbook
Saveas
deleting data in vba array
Sharing Workbook Nighmare
Changing code with code
Font color
Dates test
Relative Reference
lock tabs
To number/print pages
Don't prompt to Update Links
How to prevent links to ouside sources?
Sheet Tab options
scroll bar incremental change size
Control Cell Link for Option Button based on value in a cell
Creating a Macro
Put Autofilter in VBA long to run
Selecting worksheets without hardcoding
Question on using Form's Button in Excel
The "i" prompt when opening a worksheet containing links
Re: Selecting worksheets without hardcoding
Help with Excel
declaring varibles looping probelm
Max Row height
Quick Pivot Table formula question
L14=total, if P14="text", L14=0
Re: linking sheets
Re: Question Re: "Save As" dialog box... (-:
Re: avoiding duplicates
Re: Question Re: "Save As" dialog box... (-:
Fun newbie stuff
help needed offsetting until text
Protecting cells if they are not blank?
Recording macros
Graphical plan
Copying Sheets with Option Buttons
Excel VBA
option buttons
capture text typed in Combo Box
data disappears when I press F2 to edit
Protection + Macro = NOTHING!
Convert Chart Series Formula to Array Via VBA?
Dynamic macro parameters
Count Visible
URGENT! Find and delete row macro
macro protection
empty clipboard using macro (vb script)
Sheet Naming, and code trimming.
Responding to prompts automatically
Need code that requires password every 120 days
Printing macro error
Removing invalid characters from proposed sheet name
Deleting macro
VBA - Option Button
Re: Does RangeFromPoint Method return ranges?
Re: Workbook Open macro/& Pivot Table Calculated field query
search formula for 1st space
Printing multiple ranges on one page
Search function for a workbook
Set cell value!
Re: HOW TO: Get cell address from a range
Filtering
Re: Workbook Open macro/& Pivot Table Calculated field query
Workbook Open macro/& Pivot Table Calculated field query
Overwriting a file automatically using saveas in a macro
coppying nested if statements
Macro speed - SLOW in 2002, FAST in '97??
Re: HOW TO: Get cell address from a range
Re: Is it possible to insert an Access Table object into Excel?
Re: AutoRowHeight refresh after ScreenUpdating suppressed
Textboxes on a worksheet
RE: Quotes
Treeview Control populating
Can't get Excel SaveAs dialog to show
linked cells
Quotes
Is it possible to insert an Access Table object into Excel?
thanks Dave Peterson
text comparison
reset a pivottable
Set Focus on Control at Creation in Dialogs, I mean UserForms
Comparing lists nad printing new/ old in a list box
VBA - No Duplicate Sheet
Excel Ranges
creating a master sheet that totals values from other sheets
Silence cell movment during processing...
ctrl-end in VBA
Why does hasarray return null rather than false?
Reling Pivot sourcedata to network drive
Re: Pivot Table Totals
modeless userform
How to find the cell given x and y worksheet coordinates
Option button controlling text box
How to check for availability activeX control
CHANGING PRINTER DEFAULTS
#REF error
Userform animation
No events when changing the color of a cell
replacing Offset with []
Exceeding the maximum of 30 arguments of functions like STDEV
Xla comparison source
Workbook Last Write Date Time
find the possibilities
redim of a double dynamic field
Invalid picture Error?!?
Module name
splitting a cell into 2
UDF, dependency sequence, IsEmpty() & Multi-areas ranges
Adding Pivot Tables Dynamically
VBA to change excel caption picture
Re: Cycle Number Lock
Accessing result of sort
Setting a reference to an object library - do our customers have to do it too ?
Text Box Currency format with two decimal places
Start A UserForm By Entering A Cell
Control Cell Link for Option Button based on value in a cell
Adding a Custom Toolbar to an .xla, not to Excel globally
What to Charge for Custom Programming
urgent
Merging a number of rows
Worksheet shakes like Rock n' Roll - A command like Cells_Change would have been nice
Help Vlookup from Validation List
Need help with data from coding....try to create an update button
Reference spreadsheet rather than table name
Is Array Empty | Boolean Answer
Using multiple user forms to perform Calculations
using array with Windows().activate
array use problem
pivot table error:Cannot open PivotTable Source file!!!!!!!!
extract values
Column width fixing
named ranges, I think
Macro to Change Sheet
Assign values to a cell in sheet A, from worksheet_change event of sheet B
R1C1 seems to effect listbox fill in VBA
Divide Expression stops in Macro when Can't divide
Excel
test
ampersand operator unexpectedly trims?
Making a function somewhat volatile.
autofilter macro causes #VALUE! error
"No more new fonts may be applied to this workbook". Say what?
create a dynamic Range()
thanks
How to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset
formatting a column in excel sheet with VB
make string variable reference VBA sheet name
Help! Extremely Difficult Sorting Problem
Running DOS .bat file from Shell in a small vs. full window
Concerning Userform
Merging Workbooks
Application.AlertBeforeOverwriting = False
How can I still go to the error-code after a On Error Goto?
VB IDE always activated when I unlock my computer.
open a word file from xl
Cell not null value?
macro to make different tabs in a same sheet
How auto EnableEvents again on code-break and errors?
Is it possible to programmatically add a multi-column list box or drop down box to a sheet?
What Are Effects of Choosing a Large Chart End Limit
Inserting an Access database into a spreadsheet?
macro to delete entire rows when column A is blank ...a quick macro
What range is a cell in?
Customized cell validation!
What range is a cell in?
Limit Printing of Worksheets.
Hyperlink base and internal links don't work together??
Select from first worksheet without knowing it's name
VBA ATP arguments
Code deleting values -- not as intended
Changing Print area
Re: Efficiently transform variables into range address
Copying images from Excel to Access
Macro icons on menu bar disappearing
How to close embedded excel object?
Caption of a button
Restrict User Input
Using an Activex DLL to apply formulas in Excel
macro which changes the name of tab in an excel sheet
save a csv file with SEMICOLON delimiters
Change from all CAPS to only the 1st letter
Function not performing copy
Code instead of copy n' paste the conditional format by hand
Checking for an open file in Excel
Efficiently transform variables into range address
Excel VBA - Selecting hidden worksheets
Macro related question
Help with Macro Please
How to eliminate % totals
API
using macro IE turns error...
Selecting & Copying a Changing Range
application displayalert not working?
Changing reference to Word in Excel project
Question about hyperlink behavior...
Create a Dialog Box
Where is hyperlink pointing...File or Folder
Get cell of broken Hyperlink
Working with PDF files in VBA
running a word macro from xl
check for "#VALUE!"
Help creating pull down list with unique names and no blanks
Capturing text in active cell to clipborad (Excel 95)
Time Difference between two dates
Remove Hard Return
What of these commands ruin my copy - paste operation between workbooks?
xlend syntax in VBA-guru help needed
Matching 2 Variables
Excel To Access - Problem with last column
Hiding critical cells
Getting "Save as PDF File" Dialog at end of printing to PDF using PDFwriter
Autofill & Lookup Function
add new category
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work
Search for existing values in woorksheet!?
Excel VBA-Protect and unprotect sheet with BVA
macro to calculate percentage
xla and automatic links
to open acrobat file in excel
Excel Cell Formating in Visual Basic 6.0
Load On Demand Addins
Check or a file exist give wrong result
Formulas returning errors when reference columns are deleted
Opening Excel 2000 Workbook in asp
Macro to play wave file in current directory
Programmatically inserting a row with Excel 2003
If ActiveSheet = .. then - I get an error
Exporting text to a Word document
Still Split Data and Concatenate
Name sheet tab by today's two digit date
VB won't recognize function in Analysis Tool Pak
textbox counter probelm
Code Interpretation
Sending SMS from Excel
change txtbx font
Split Data and Concatenate
XP Inactivity Logout
How write to hidden columns with VBA?
MsgBox -change vpOk to VpOkStop
Clear formulae
Macro Security Dialog - Document has no macros
opening a workbook
Help figuring out how someone did something on a worksheet...
getting focus on an optionbutton
Programatic Data Validation
Macro code
Weekly, Monthly Sums
Filling the first empty cell
Using a function from my own c++ add-in in vba.
Persistent data in an Add-in
Code Contribution
Loop
string sorting problem
excel - can all the macros be protected?
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet
Cell Value
excel - modifying toolbar, keeping it unchnagebale, then re-setting it to original
Macro to navigate between sheets
Excel VBA - macro to recalculate random numbers until target reached
adding components in VBA
Protecting Embedded Spreadsheets in a Word Doc
Program cell background color
Macro closes all coluns and not just the programmed ones, why?
Searching for a substring in a range
Are You Ready? New Adventure In My Project!
Inserting rows and saving formulas
how to automatically highlight a row?
Save As
Help Page in Excel_VBE
Fitting long text
Unhandled Exception Error
Populating TextBox Value--using ListBox
Excel 2002 Data Forms runtime error 1004
hide/unhide
Lottery Analysis
Open two new workbooks with macro
Error 1004 in Excel 97...
Adding Items to a ListBox-Unique Items Only
Controls on worksheet
macro - hides everything and not just certain columns as recorded
check to see if cell contains a string = to member of list
Write to closed workbook code
Display in Macro when editing the value of a Worksheet range
Don't understand External Data message
Concatenation...
Deleting charts on a sheet
IF statement problem
constant array
Excel 2003-RND() vs Rand()
Problems with callback from DLL invoked from VBA
Defining Cell Row Value Remotely in Formula not Code
VBA - not working
Removing focus from a Modeless Form?
Selecting cells for code
VB .NET Excel Builtin Property Access fails
Properties not visible in design mode
Adding Items to a ListBox-Eliminating Blanks-Part II
Assign names to R1C1 referencing
Selecting Range
Automatically Increasing Chart Ranges
VBA - using Goto - Please Help!
Adding Items to ListBox-eliminating Blanks
Adding Items to a LISTBOX--eliminating Blank Lines
Links work inconsistently
Sorting cells with formula links
userforms
VBA question - Percentages in text box
Color Indicator
Show date in cell if data changes
FTP Accessing remote files where filenames are unknown
lookup,copy, paste macro??
ç (c-cedile)
excel - macro - automatic initiation of a macro at a pre-specified "system time"
Excel 2000 Load Userform when clicking cell
Entering Worksheet range Value into Macro Scrpt
Is there a smart way to select multiple rows based on #2 :)
Is it possible to export each row of data to a seperate work book
Execute a menu command with VBA?
Hyperlink won't work...help please
Help clean up this code...
Is there a smart way to select multiple rows based on column...
Check Box Format!
Codes
Print BMP in Header/Footer with VBA?
From HTML open a specific worksheet within a excel file
Duplicate posting.....
Thanks!
Macro - Playing Macro if cells are locked
Macro Recording
Adress formula nested in an IF...
Dynamic Print Range
How to set footer and header for all sheets?
Transform columns with VBA
VB6 with Excel Objects: Please review my code
Vlookup With Indirect
Prevent non "validation" user entry
How to return the row number or column letter as a variable?
Searching in excel
All Projects Code
HELP PLEASE
learning vb / macros
html not showing corectly
Address in IF formula.. doens work..
Help with named constants in Define Name dialog box!!!!
running a word macro from xl
Range("temp").Calculate - ERROR
SpecialCells Method selects valid records
All open projects
sort data in a single cell?
Dont show msgbox again
Using the And formula in a VBA macro
Difference between range.formula and range.formulalocal
VBA help - worksheets and range questions
To join some sheets of several files in one file
ChangeLink error
How to change the color of a row using VBA
rookie needs help with replace formatting and case change
having things happen when spreadsheet opens
Re: Setting a timed event in Excel - Please Help
Re: Setting a timed event in Excel - Please Help
Macro slowing down gradualy... (duplicate post - use this)
Change Font size in Excel VBA
Re: Check if workbook has been changed
Test for Worksheet
Application.CheckSpelling Error in Macro
Formula based on one cell, pased in another range
Find and display information
listbox not dsplaying all records in a named range
Error message When running Macros on MS excel 2002
How to open an Excel worksheet in the webBrowser control
DataChecking
repeat code until row 24
Find and delete
Tri
Comparing rows in three sheets
Extract data from web page to specific cells in excel 2003
Code for manipulating Lists
Runtime Error
Read previous line of textfile
Writing to a closed workbook
How to bold a range of cells using macro
vbCancel
AcitveX only runs with admin rights
Excel - Access
excel problem
subtraction
vlookup question
Speed xl-2k compared to 2003
Using VBA to enter info on external dialog box
Using VBA to enter info on external dialog box
remove rows with the same reference
Word features in XL?
ActiveX component not correctly registered error 336
Find & Replace in XP
Calculating values to column D with formula based on values column A
Re: Determine the Row in a Range
Word features in XL?
Passing information from VBA variable to Excel range
Using timers within excel
Deleting Rows
Excel macro !!
User Form
finding unique items quickly
Web Services desde excel!!!
VB Code needed for Sorting with constraints problem-Tough One
How to display a chart where number of periods vary
Refreshing an Excel spreadsheet
sumdivide array formula
Excel Macro for building up OLAP CUBES - Analysis Services
=ISODD Behaving Oddly
Refer to a sheet by (Name) rather than Name from an addin
Finding duplicated entries in a llist
macro to find date format in a cell and delete that entire row
VBE code in a loop
automated email for functioned cells
macro to re-order sheets based on cell value?
Three graph into one
macro to find something in column A and delete 5 rows below it
VBA question - sending e-mail
msoControlButtonDropDown
EnableCancelKey with On Error Resume Next
Finding tabs in a string from a text file
Copying Sheet with Formulas
RasGetConnectionStatistics
SOURCE CODE
Array Formula Index Match formulas in VBA problem
Activecell value
Open a window / box showing a selected range of cells only
Excel macro
Tab to Certain Fields
Capitalise Letters
Automatic Advance
"cannot insert object" in Excel (even a button from Control Toolbox)
Automatically highlighting rows which contains certain data
Global module
insert rows
Late Binding
Open excel file at a certain date and time
PivotTables Refresh not work
Hyperlink to images
Extract the value from a cell, and add it to a chart title
Getting the value from a cell, and then using it as a name or R1C1 reference
Overwriting an existing workbook without having to click yes in the prompt box
How will I do Excel user-defined function to extract letters from string
Slight adjustment needed
Clean up code using WITHs
insert to hold data
PasteSpecial not happening
Help with reading comments.
Help using variables with Hyperlink
Re: Compare two lists
By-passing clipboard message
Find then select to the right
Grouping Control Changes on a UserForm
Sensing actual format background color
Creating a .bat file that opens, pauses & closes MS Excel
Import and Export
Customer menu Item
Peculiar Runtime Error 1004
Copy data from one worksheet to another
Programming Colors
Advanced Filter Copy Paste Blank Line Hell :(
disable the windows 'minimize' & 'file exit' buttons
Activate user form upon condition
Imput box - Multiple Lines (\n)
XP Screen Saver
NEED HELP! Macro didn't survive XP!
Re: Compare two lists
JE McGimpsey web site
ListBox size change on different PC's
I'm stumped, Function that leaves a comment
AcitveX only runs with admin rights
AcitveX only runs with admin rights
Night shift hours dilema
My current code
Question With Macro
Need to adjust formula accordingly
application.displayalerts is not working
Trim "\" Value
Run Macro Every 30 min
a macro which finds last cell in a column
inserting an object in Excel
Inserting an Object in Excel
Importing all components in a folder
Password in Visual Basic - Help!
Export just one sheet from a workbook
User-defined chart type deployment
macro to find out the last cell in a range
Adding the values of 2 textboxes
programmatically Set Reference to Library
hide / unhide details
unique values
Deleting file while in use
Export a file with today's date
File not Found !
InputBox
Comparing, Sorting,countig Mac address and vendor names
Open Workbk/Close Workbk Done Asynchronously?
Write over existing file with no Prompt
Help With Macro
Copy from sheet and paste to last row used
Using VBA Change Cell Text
Which Macro Is Assigned to a Button
Office 2003 General Problem
Save a worksheet as an Htm file
Randbetween puzzle??!?
End of file marker from Text File - Delete?
Excel Hyperlinks on a web page
Change text in a Cell
New to Excel VBA
importing a lot of text files to excel sheet at one go
Using Select Case Statements
Get the name of a newly copied worksheet
Please help, I've been working on this for days
Change Cell Entry To Uppeercase
Tab Stops
Text won't Trim
How to work =row(Cell_Address) into a macro
Using different print code
Working with other files
Range.Sort in VBA
macro to combine data from 2 different excel workbooks
Automaticully copy of data
Summing from multiple worksheets
Prompt for a range to apply code to
Refreshing / sharing an Excel spreadsheet
copying hyperlinks
Re: Routing Recipient
help please! need a macro which can combine data from 2 excel sheets
Is there somewhere I can access Excel-VB code at once?
External data sources in Excell...
Using macro to change printrange / fit-to-page
any clue?
RE: Error in VBA code to save workbook
worksheet function calls between worksheets
Password in VBA
Emergency! Can I use Maco to export excel data into word forms
Re: Error in VBA code to save workbook
Create Folder and Text File in folder
problems with Add-In event procedures when moving WB files between computers
Help in macro in excel.
sharing an array between worksheets
different cellcolor depending on cellvalue
Downloading a file via FTP in code
seting a workbook to a varible name
USERFORM
What is wrong with this function?
Popup login dialog
Reference a cell on a worksheet
Best way to create a workbook template that allows data entry and purchase order req to be created from it
Add Workbook with specified name
Macro for linked drop down boxes
Changing formulae for series in line charts
Function not working correctly
RS-232
Re: RUNTIME ERROR '1004' --- Select method of worksheet class failed
Filter Code
Problem with UsedRange.Rows.Count
EXEL Math - need help
Why?
Recalc versus enter
activecell.formular1c1
Date format
How to prevent anyone from viewing the code
Re: Forcing Data Entry in Certain Fields at Certain Times
Reading, Comparing and Writting
Calendar Gridcells
Problems converted comma seperated CVS file!
Function help needed
TreeView
VB excel Null values !! Please help me !!
Search/Filter to find values in another range based on two cell values
Copying non-blank rows to another sheet...
Working on a macro
Percent Format without Percent Sign
Excel VBA - Skipping #VALUE! error
Making All Checkboxes Run the Same Code