Excel Programming [Archive] - Page 145

Re: Remove the Password protection at the launch of excel.
Re: What is the quickest way to copy codes in Sheets?
Re: What is the quickest way to copy codes in Sheets?
Deleting Cell entries then save and overwrite template
Sorting Items in a ComboBox?
Method 'Intersect' of object '_Global' failed
COUNT cells with Y and N
Can this be done
newbie spreadsheet problem
Help Creating Text File
AskToUpdateLinks not working
If date Then Paste.....
Check Boxes
Excel VBA-Importing txt files with VBA
InStr and ADO
Problem with custom date formats
Make my macro security
if ... then action
Closing workbooks
importing Data from access
need to have users share add-ins
Excel RTD
name
Conditional Format
Date programming - Absolutely confused.
Worksheet Combo Box
Case# 4812 - Display gif picture based on cell content
Create Excel chart using C#
writing a Function with a variable number of arguments
know when the job of print is completed?
Non-Editable ComboBox?
Running a shortcut
Outlook 11 > Outlook 10 Object Library Compatibility Issues
Pass array of worksheets to ActiveX DLL (VB6)
how to get the cmd window to close in VBA??
Excel VBA from Word Template
userform Radio button updates text box
Word Template - Editing Excel with VBA
Modify code to disable "paste"
Excel Macro
Hide a Sheet
Conditional Formatting
Excel macro slows down on second run
funny problem with range names
help needed with timer / loop
find & replace (hidden) '
Custom function problems
MS Calendar help requested: default to 1st of prior month
New to VBA question
Marketing and protecting an Excel "creation"
excel's memory limits
Sub or Function not defined
simple scrollbar question
DisplayAlerts Intermittently stops working
Column Limit
start macro based on result
Excel Macro Problem!?
Waste Reduction Program
Filtered Rows using Mode Function?
Runtime Error 381 Couldn't set list property, invalid array index
Runtime Error 381 Couldn't set list property, invalid array index
Renaming Worksheets
Save web page as desktop file from Excel/VBA
Need Help on Web Query - Thanks in Advance
moving .xla files and top level tech information
Pulling Date Ranges
RE: How to pass a date in Excel to ms query
deleting rows macro
Compare two col to same two on next row
Position hyperlink in Excel
Copying a particular range of values from one sheet to another in excel
Workbook Close Event
Full Screen With Status Cut Worksheet Tabs in Half
Replace
2 quick questions
Visual Basic Marco
Multi-select Combo Box
formulas to values
formula- find min value in range, then average that value with one value on each side
I have date I want time
Problem with code causing Excel '97 to crash
lack of chart uniformity
Summarize formula links between worksheets
Detecting if AutoFill was used?
CREATEOBJECT Using VB
Excel renaming file to a temp and deletes original (long)
combobox/textbox/userform/other question
Lookup an array question
Problems in Visual Basic Editior, In search of a command
Filtering out dates using autofilter
User Form Help
Setting a boolean depending on who called the macro
How to abort executing macro?
Open Excel
loop
Need help writing a conditional formula
Code to delete Macros
Excel macro - Range & Sheet name error
IF STATEMENT
Filtering Data in Excel by Team
problem with military time and making calculations
Multiselect listbox selection question
MultiPage scripted changing
Inserting rows
Adding AutoCalculate option
Print multiple selections to file by macro
Formats for date
Transfer numbers
Need some help with conditional functions
Re: How to pass a date in Excel to ms query
Re: Auto Fill Weekdays Only
Auto Fill Weekdays Only
Populating a label box
Cycling through the cells in a range
For Each...Next statement
Custom functions address space
batch insert pictures one time in excel macro
Deleting shapes
How- Message box on opening excel file?
cell address
running a macro only if criteria are met
Add Comments to Word
Listen i datavalidering forsvinder
Excel from Access/File Sharing
Indirect and Match functions
Autofilter and choosing filtered columns
formulas not executing until workbook is saved
Where is microsoft.public.vb.general.discussion located?
Copy down command button
Disabling error checking.
Security warning for non existant macro
DSN-Less Connections
Vertical Alignment of text in Userform labels
Get values from Controls in Excel-sheet
Help with Loop
VBA IDE Weirdness....
Autofilter vba dont show filtered data
Date Control using Spinner
Autofilter with vba wont dispay filtered data
opening directory from excel
opening directory from excel
opening directory from excel
How to program a series sum function
Using SaveAs Statement to overwrite existing File
count time
locking textbox?!
Is this crashing for you ?
Autosaving files with different names
Publish Excel sheets automaticly!
Sheets Protection for group!!!!?
Multiple coloumns data
Updating range properties is so sloooow!!!
Display range of cells in popup window
changing design in excel from VB.NET
Next Empty Column in Row
Spell checking a protected sheet
ListBox and Hyperlinks
Combo Boxes
memory issue using ADO to query Excel
Register MSCAL.OCX
Select charts to copy
Starting over
calculate shares for heirs at law
Copy Excel sheet into IE environment
Problem selecting cell
Return to MS Excel
code to update a macro
Create a new sheet in a workbook from a template
Re: Background Web Queries flaws!
VB strings, MSXML, Latin 9, and the Euro
Pivot tables, Validation Lists exist in an excel file
Certified Macro's?
Office 2000 Programming with Office 2003
Office 2000 Programming with Office 2003
Spacing
Application.Speech
Excel Error Reports and Unexpected Termination of Program
Code Needed
Is this possible?
Background Query Timeout
really hard cell fomating question, sorry if wrong forum.
calendar control xls 2003
calendar userform
File in use
GetObject
Copying a column from several similar sheets into one sheet
Summing
"Casing" the strings for smooth code running
pivotchart colouring
Worksheet Controls Forms vs Active-X
help with some code
Spreadsheet Solutions
Conditional Formating
Detecting merged cells
Only one user @ a time?
Chart Size
Insert a command Button
Copying and pasting entire workbook
problem with cell sizes
Counting groups of similar items
To Tom -
Reverse of Chr Function
Accessing the USB Port
Examples of Using VBA, ODBC, and mysql
Case when statement gives type mismatch
Anyone Well-versed in loop?
Saving a worksheet out of a workbook
Need help with merge cells in a macro
Quick If Question
Help Me!!
Number length headache
How to make a Macro Iterate
Swap columns A&B with C&D
Help with date search
If....Or Logic question
Variable in range
Taking over OLEObjects... Possible ?!
xl macro
Visual Basic Help
Closing Excel in VBA leaves it in task list
Excel Vba Clarification
if statement
How to delete a file using VBA
merging two files
Progression Tables?
Spell Check protected cells
UDF help
Display hyperlink as web address
Book 1 auto opening
Pivot Table
Problem selecting a range to print...
Problem
Print Range Macro
Pivot table cruft and incredible shrinking workbooks
Full Screen With Application Title Bar
Setting up a database
Simple UDF help
Combining tables from several spreadsheets
Defaulting a cell to 0
macro that counts lines with certain color
Simple (?) Macro Assistance- Select, Insert, Paste, Rinse, Repeat
lookup value and change background colour
Re: Detecting Macro Security Level
Listbox Scroll
Re: Spell Checking Custom Properties
RE: The macro 'xxx' can not be found
Re: Spell Checking Custom Properties
Spell Checking Custom Properties
Detecting Macro Security Level
"Compilation" d'une feuille Excel / Compiling an excel sheet
embedding / structured storage?
macro to executable
Excel in English run on PC with Excel in French
When to Stop
Setting a Range
Userform in excel97 not working right!
Paste where cell meets certain criteria
adding reference to the Word-Library
Check for files
Save as using cell content in file name
Excel Macro
Macro
textbox focus
AutoFilter on a Protected sheet
Locating Cell Number of first occurance of data in Column
Re: how automaticly print excel sheet
dictionary function
Macro override password protection
pop-up adds
Is this possible?
help with formula calculation
Resizing Comment boxes back to default size!
Macro resets my calculation to manual
vba program clarification
vba program problem
Excel not seeing 2nd COM Interface
Is there a way to shorten this?
Passing range as an argument in a function
Rephrasing argument for typename and a different result
vba code problem
very very urgent vba pogram doubt
how would i select a group of rows based on a column value
Linking Worksheet File
Range.Formula in Excel 2003 gives Error reading formulas just below 1024 bytes
Not able to "Step in" - Debug
Date format
Find Method; First letter
"How can I reference all the comment boxes in my workbook and resize them
Why can't a calculation and macro execute at the same time?
Perminant Template
Perminant Template
Change color of text depending on "IF" Statement?
Excel Query - Code problem
Data Range for Graphs
A repost: Automatic file opening procedure seeming to hold cache
How apply one action to all worksheets?
Office 2003 PIA do not work for Office 2000
Event macro?
macro
Automatic Value conversion
Can someone fix this hyperlink formula?
Check If COM Reference Available on Machine
Number changed to Text
Web Query - Unable to Record
RE: do until...loop question
reading contents of a file
Text to Columns doesn't work for this problem.
Import text file into excel with preset file layout, delimeters VBA
Extracting from another file
RE: Programmatically remove sharing?
Custom Date in Autofilter
Trying to Learn VB
Conditional Fill Macro
Function Arguments
Disabling Saveas and saving file with a specific name only
Sum a row of data based on FONT COLOR (
IF and HLOOKUP Formula
Logic for a FOR loop
Referencing all sheets in a workbook in VBA
formulae in Pivot Table
Textbox question 2
Progress Bar
Re: Buttons
Shared Drive/Macro or Hyperlink
Syntax for Countnig Rows
IF and HLOOKUPFormula
Template Wzard for Excel 2003
Using Access
Format by VB opened Workbooks/sheets
Compile Error in Hidden Module TBRun9
Re: Prevent end users from manually running or recording macros
aling to right
Count number of selected item in Listbox
excel vs. access
Try Before You Buy Spreadsheet
Comma delimited text to columns
Sort Using Date Functions
Moving Data
Add reference programmatically before a module compiles
Conditional summation
Data duplication
Automatic Hyperlinking?
Hiding rows
macro question
Delete an autostart Sub with code
Mysterious standard toolbar
Re: Macro to run when sheet opens
Re: Macro to run when sheet opens
2 workbooks open at same time break macros
Delete duplicate records in the table
SUBSTITUTE using arrays?
Option Buttons
Range Select Error
Link Excel Fields to Outlook Contacts
incrementing cells withina formula in VB
Need help with custom open/save functions
Learning about macro's
Locking ranges
Show all Data
Conditional unprotect and unlocking of cell range
Setting up Worksheet_Change event
Text Box Question
function of a range of cells
OptionButton problem
Working through files in a directory
Excel 2003 and FoxPro tables
Saving on C:\
Sheet Code
Pivot tables changes the case
VB timing question
Saving frm XP pro to 97 problems!
VB Timing Question
hyperlink in Excel
troubles with the Workbooks.Open method in Excel 97
test vba in listbox (UF)
Conditional Formatting Macro
Help required for automated mailing list
Disable right-click
MsgBox position
Automate Macros
heads of column (listbox in UF)
How to do validation ???
Test the color of a cell
Add Remove DLL reference in VB
snake relocate to programmers :)
Complete Delete
Matrix formula ? Second try (no image)
workbook_sheetchange
excel vba programme
CheckBox value to worksheet
How Excel calaculates
Macro Help on Toolbar
Import Currency Problem
convert for email
Excel Color Code On Click & Redirect
Closing non EXCEL files
Excel Process is not terminated when using C# and com Interrop
True / false statements in Macros
Hidden worksheet
advanced filter in Excel
Need some help with conditional functions
Reading the ShiftKey state
Active cell
Re: Help anyone
Set the path
Re: Run - Time error
Using a hyperlink to find information on a different worksheet
Saving monthly information from order form
Excel VBA User Form - button problem
Can't record Global Macro
size of excel files
multi formulae data entry
stripping string & placing into cells
Excel VBA - Countif problem
Dynamic Range Names & Clear Cell Contents Q
changing 'names'
Password protect
Macro coding needed.
Rows(arguments)???
loop question
Re: Assign a variable from a Listbox selection.
Finding next blank cell
Re: Assign a variable from a Listbox selection.
Re: select down to the LAST non empty row
Rich Text Control will not load in Office VBA apps.
select down to the LAST non empty row
Assign a variable from a Listbox selection.
Worksheets - Visibility
passing named range to a UDF user defined function
Copying and moving matching data problem
VB Macro statemenent in Excel
Still filename problem
Arrays
Checking for bookmarks in Word document
Find the end of a column
return error msg, not run time error
Progress bar in VBE
copy files
Converting Times
Color Coding
Using the built-in dialog to format a shape
"Unable to Read File" on workbook containing Pivot Table
Returning MAX value and MATCH position in specific cells
Change Cell Color from cell vairable
Is the array empty?
How have text on clipboard reformatted as a cell would be put there?
Deleting a named range in VBA
How to create a mechanism to get the YTD?
DATA FORM problem
dates
alpha counter?
Excel 2000 Returning text value Not formula from Cell
Progress Bar
j-walk progressbar mod question
Pivot Table two column sum
Multiple Subtotals
Referencing "current" row (not using ActiveCell.Row)
Help required on macro for excel
Re: Sort list into alphabetical order
Sort list into alphabetical order
Multiplication based on CSV string
Delete a Row if a Certain Value is in Column C
Comma-delimited files and Reional Settings
Multiple attachments in Excel e-mail?
Trim, Len, Left causing problem
On Error, Capturing current module and actual line of code
Code Help
Dynamic Web Query
blinking cell?
Option Explicit
how to accomplish a menu_less window?
UDF return
Disappearing formulae
Re: Deleting a textbox control at runtime
Filename problem
Autofill help
Broken reference for chr function
Inactivate cursor
Excel Version Trap
FileSearch
Assignment to constant not permitted
_Application.GetThisWorkbook() in a C++ add-in
Inserting Date into TextBox
Copy WorkSHeet To New Book With Print Page Settings ?
Carrying Variables into Called Macros
Converting two column compare macro to vba in Excel
Timing Problem can someone help please
Passing parameters to a called add-in...
macro in 2003 template asks for non-existent XLS
Conditional Printing
Excel Function to add a space within a cell
Delete Asc(10) character from cell
Missing paste option between workbooks in Excel 2002
Visual Basic within Excel
VBA Excel2000 error 438 help
Lookup function to find email addresses
Passing Row variable to row Auto fill logic
Question about ComboBox/Userform/TextBox etc.
Static copy of spreadsheet
Saving text file in excel format through macro...
If statement to send email
Interplay between UserForms question
Passing cell addressess to variables to be use in range
Modify ? Tom Ogilvy "count visible filter records"
Pausing while retrieving data
Deleting "old items" bug with pivot cache
Text box
Automatic sorting of a league table once a result has been entered
command button on top
External Data Updates
A useful function: number2text
auto filter missing record count & a fix idea
Application on error sub possible ?
Cell as range
Make Macro available to all new workbooks
Re: copying a chart
Re: copying a chart
VBA : Number of Blank Cells in a Range
Workbook_Beforesave getting breached
calling a subroutine outside a spreadsheet
Need help with nested IF comparison....
Variable criteria to delete rows
linking radio button
Summary display horizontally
Extract Hyperlink
Substring to replace string
Substring to replace string
Automatic userform data input into spreadsheet
Automatic userform to input data to spreadsheet
Automated userform inputs to the spreadsheet
Automated userform inputs to the spreadsheet
xlNone incorrectly valued?
Copy & Paste Macro optimize
If/Then statements
Slow Add-in Load Time
Use Array to Goto Certain Rows
Set Print Area Macro
excel vba program
Set variable to a function
Macro to move information to different cell
Excel Vba Userform Tabular Column
Setting Print Size for varying Printer use
Problem in opening template through intranet.
problem while opening VBA template through intranet
Toggle Macro
Referencing A Formula As Text
Enclosing values in Quotation marks
DT Picker Control
how do you break the link with MS Query - Database via code
Spurious ComboBox change event
Formula Syntax
How to export a range to a picture ?
Checkbox Macro
Working with a combobox
=Right Function
=Right Function
How to find the range of a web query on a Excel worksheet
Is there any API to know that ocx files are registerd in the machine or not
function recognizing that there is no inout in a cell
Export Excel data to XML
"document not saved"
Problem assigning macro to button?
InputBox
Create an undoable 'paste formula' macro
Variable Not in the cell
Weekend dates
Find Function
Creating menu items without using VBA way?
Registry key for "Trust access to Visual Basic project"
How to solve: y=1/x, x>0
Excel Automation speed (version + OS)
File Recovery
Controls Moving
Setting autofilter criteria
On_change , Upper case, file SaveAs
Macro won't run properly
Exel VBA - Clearing clipboard, area names
String Function 'Like' and Special Characters
Run-time error -2147319784
How to calculate Total for different Group from user entries
Analysis ToolPak Not Working in Browser mode
VBA - AfterSave event
Automatic file opening procedure seeming to hold cache
Picking up values from other tables
Macro doesn't work in Excel 2003 (Con't)
Validation using VBA
problems with dates before 1900
Macro
Error 1004
Summarizeing sheets
Dictionary Functions
subscript out of range
Excel Vba problem
X-Platform Problem
Timer control for Excel VBA
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown
Excel Vba -userform Tabular Column
Timer control for Excel VBA forms???
Excel Vba -userform Table Column
Error Handling Open Function or query for missing Files
Excel open Outlook Postform
excel open outlook postform
Getting info from the clipboard
outlook post form thru excel
Form Positioning with Freeze Panes
Converting Excel 97 VBA to Excel 2002 VBA?
Need to create report in Powerpoing from Excel data
Need to create report in Poerpoing from Excel data
run macro auto
Questions of Great Import
Importing Text File Based on Query
Conflicting VB Code
Losing data when converting
Add value to array based on if...then output in VBA
Custom cell formatting
Looking for a VBA book
Macro - set calc off
Re: Editing Excel without starting excel
COMPARING LISTS
PrintToFile OutputFilename problems
Excel AddComment editing font
Arguments as properties
Setting Workbook Name by VBA
Key event
Omitting displayalerts set to true Vs. Automatic reset
Lookup as Part of Macro
Fastest way to clear contents
"If Not" with a date
Select checkbox with tab key?
VBA questions
Multiple arrays in Median function -- VBA
Trimming text contained in cells
checking the format of a string in a cell
Error on activating a window a open workbook
multi select listbox
VBA search and compare strings
Formula
Pivot table number format
Prompt for name when copying sheet
Re: sql and excel
excel dropdown list??
automatically special paste each week?
Disappearing Tool Bar area--Tough one!
Coding for Pivot Table
Finding multiple values in excel, then sending as "mail merge"
Repeating pattern on my second sheet
Adding the same content to multiple combo boxes
Excel Create Array Variable
macro to use a cell's contents as it's name
Problem with adding an item
RE: Workbook Open & Calendar Control
Behaviour of Save as and Displayalerts
last row
Working with a selected range
New to Error Handleing
averaging values according to (very) complex conditions
Unloading userform in MSComm event
Application Worksheet Function Vlookup error
Macro, Module, function, sub and This workbook and sheets ?
Hide calculatedField
GetObject-question
Personal.xls Macros?
send value to a cell instead on MsgBox
Assigning a row to a variable
Excel lost function pointer in BIG project ?
Print Preview
Excel VBA: Pass value when clicking button
Printing sheets with large amts of text in some cells
Printing with much text in a cell
Delete row if columnA and ColumnB are same
Delete row if columnA and ColumnB are same
Relative References for macros
Close Workbook without displaying message to Save
Excel Program Glitch?
Text box Scroll bar position
Excel Macro "relationship" grapher ??
Re: tree view control
Hiding a pivotfield using code
Code not working
Next Sheet
Search code won't find partial matches for P.N.s
tree view control
test
Macro
Pivot Field Function Code
shared workbook
Countif in VBA -- evaluate multiple criteria
Unwanted Rounding Errors
Pivot Table Source Field Name
Reverse cell value and convert to date
VBA Slow Peformance on Formatting
Can Excel Macro DoubleClick Icon?
deleting rows with zero value
Alex
Hard Code DLL Reference in VBA
Stupid question - Put a value in a cell?
Macro invocation after data enrtry
Hard Code DLL Reference in VBA
size/space problem with module1 in VB even though it is empty
How to do the folliowing copying fast?
Check before closing Excel
Force re-open file
Corrupted workbook or code?
ComboBox
Excel workbook with formulas keep crashing application
Excel VBA - Keeping a chart stationary in a worksheet while scrolling
Macro Running at Spreadsheet Start
Hide prompt to automatically update links on workbook opening
Real problems automating a mail merge
Toolbars not working
Hiding workbooks on opening
How select unlocked cells only
Run-time error : method failed
Excel File Name Got Changed Automatically
Text box help
(Name) Property Under VBA Control
Worksheet_Change event doesn't work in Excel 97
Worksheet_Change event doesn't work in Excel 97
How to read a SQL Table into Excel change the data and write back into SQL
How to read from a SQL Server table into Excel and use the Excel cell format as in the database
Print a List of Keyboard Shortcuts in Excel 2003
How to activate the button
Visual Basic for Applications
Opening files from a variable (todays' date) folder name
Copy file without open it???
How to set a new Excel instance as the 'default'
Application quit without displayalerts
Macro coding help needed
Saving an unactivated worksheet
Sorting each row individually
display all records to filter
Insert Row & copy all formulas - shared workbook
different color if an x esists in range
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed
Extremely slow run-time
row numbers missing etc
PivotTable - PivotTable Field name is not valid - error!
Switching Sheets
enable macros as default
weird
easy one!
Show Form, Hide all Sheets
How to skip empty cells while running a macro?
What is wrong with my array?
Recalculation on cell changes fails when using VBA function
Tracking Workbook Usage
Macro help
Opening a single workbook
re table & chart
Function in VBA
Select Case
NewComment
Closing excel and saving workbooks
Get external data - how to stop table list from being displayed on connect?
How to compare only a PART of strings?
Using macro to find file
Copy & Paste Macro optimize
Verifying all data in each row is filled in
Pivot Table Macro
Saving Individual Worksheets
tracking changes to cells
Creating a Macro that loads the most current dBase file.
Beginner seeking Excel VB String answer
adodb.recordset with excel
Can I create a FORM (that I can modify etc) from an existing spreadsheet?
On Open/On Close
Put one of the Regional Settings in a variable
ControlTipText style
User Prompt to Confirm Values
input date as date in formula
input date as date in formula
Literally - every other time
Excel Save pops up when unloading Addin file
Find specific text in a string
Counting cells thru VBA
Range description
Two validation cells populated third validation
password prompt to unhide sheet
Iterating through cells problem
Macro & Command Key to change data from Colums to rows
Delete rows that don't contain '+' or '++'
Macro Library
Dlookup?
hide sheet
Unassigning / Removing Macro from Shape
newbie needs help again, function returns 0 ONLY
RE: MACROS & COMMAND BUTTONS
Creating a Macro
Batch in excel
Comparison between 2 columns ?
Comparison between 2 columns ?
Looping through a range of cells
Worksheet_SelectionChange clears clipboard - can I stop this?
sheet name VBA
Excel Formula in XP and NT
Displayalerts and Screenupdating
compile error: block if without end if
Iterating through cells problem
try to use a worksheet object
Comment
Thisworkbook.SaveCopyAs - Does it work on Excel on IE?
Can we make a cell behave like a list box and populate it with values for selection.
Data Filter Operation
Create a subtotal
Sheet Names Array
reference non blank cell
table & chart
Images in Userform?
Bat file
Two simple macro commands
get data from a text file and insert them in datasheet to show a chart in VBA
linked formula
Cells.Range
Help bug?
grapic chararcters in a userform
TextBox.Activate - QUICKY OFF THE TOP OF SOMEONES HEAD
Indirect reference
Selecting printer from macro
calendar/date control
Load xla addin on demand for particular Excel instances
code to force xls file to open after several hours passed
com addins. Which book(s) to buy?
Problem with UDF
Excel 2k VBA problem - For loops interating a sort
Excel VBA - is there a multiple slider sliderbar control
How to compare 2 lists in Excel VBA?
Indirect validation possibility?
VBA Code to remove VBA
Populate a combobox
Adding comments in a range (!) of cells
VBA trouble when using Excel 2003 vs Excel 2002
Excel VBA - Find User Inputted Variable
Print group of sheets by VBA
Selecting cell using range.offset
conditional printing
Remove Macro
Assigning Macro to "Buttons"
add a toolbar button for an add-in
OFfice XP SP3, Strange Things....
clear form combo boxes problem
Path name
MS DOS Commands
On open/closed events-and stuff
Creating a table from one varying source
Application.quit
How to get the indiaction in Listview columnn header
Images cannot be assigned to Listview control
Formula help!
read range in excel without MFC using ole2.h
Range Paste in VBA
to find cell
Create New Folder
Save and exit automatically
Filling down problem in VB
macro virus protection
Colour Formular (Not a function!)
cells not changing selection after sheets array
Private type - please give example
Random Sort
Pictures or colors on tabs of multipage?
join sheet 2 below sheet 1
Horizontal Report
Keep certain rows only?
Pivot Table Calculations
Hide and unhide worksheets
Clearing a column
Dll error resulting from "CreateWorkspace"
Re: Shared Workbook - Hiding rows as per Username
Slow Macros ...3
useless file
Copying cells within a loop
Delete a line of text file
Delete a line in a text file
Delete a line in text file
Excel 97 Macros in Later Version of Windows
True / false output problem
how to change the defult location of Pivot Chart
Changing to a selected folder
Excel validation problem
Macro doesn't work in Excel 2003
macro was working, now it's not working
error handling - check chart existance
Automate CD Burning in VBA
Validation
List of VBA Functions and Constants
Programming lag
Reminder for backup
personal.xls file
Opening excel files automatically
Reconnecting a Link
Run Time Error '13' Type mismatch
Deleting old connections
RE: Pivot table field swapping in code
SourceData in pivot table
Sorting Worksheets in Alphabetical Order (Left to Right)
date picker
"View" in Macro
filters
InputBox function - prompt string limit
Macro Run-time Error 1004 Application Defined or Object Defined Error
Ron de Bruins Delete Row Code Q
Creating a folder automatically
Creating a Worksheet in VBA
systen variables
Look up VBA documentation using Excel Help
Copying Dates from One sheet to another
Delete Key Error Message
Find method using User input
Excel - Saving as a Web Page
XLS to CSV conversion
Re: worksheet to workbook macro
RE: solver macro
msgbox if you input text instead of numbers
Time Function
Wondering if there is a way?
Position Cursor to A1
autofill macro has error when there is nothing to fill.
MsgBox question...
Userform: Textbox changing with selection in combobox (list)
Re: eMail a sheet
Re: eMail a sheet
Hash a range, output a Long Integer?
Re: eMail a sheet
Searching a column (Repost)
Spinbutton help required
Alternatives to VBA in Excel
Message Box if Attempting to Save over Master
Excel macro
Automatically special pasting a range each week
Recordset or Object is closed HELP PLEASE!
Convert Date Time in Spreadsheet Column to Date only
pivot table
Automatically selecting the next option in a drop down menu.
Invoicing
Counting Variables
VBA Problem - How to collect and display text information from applicable cells.
Adding new rows
Formula doesn't compute. Can you figure it out?
ZipXP
Need help with Macro
Macro Help Please
Protection problems
Disabling an AutoRefresh of Scrolling in VBA
Generally speaking, which is faster?
Locked workstation breaks code?
Differences between Excel '97 and 2000
Importing CSV format issues
SAveAs executes combobox code
Searching a Column
User defined file name in an OpenText File command
Defining the subject of an Email by value in range
Listboxes 2
Simple Shell Commands
List boxes
Linking Sheets
Extending Selection
Name of color for a particular colorindex number
Conditional Formatting
Telephony
Macro Formula Updating Problem
copyright symbol in text of a label in VBA
Differentiate b/w False and 0 with InputBox fn
Search for text in a cell
Re: Marking my sub into a function i can use in excel
Excel With Outlook
Re: Pasting column after end of spreadsheet.
Pasting column after end of spreadsheet.
MsgBox Properties
Computer Identification using VBA in Excel
Count Bold Numbers in Range - multiple rows
Tabbing
Showing an angle in cells
Custom Lists file name
How to find if something has been changed on a worksheet..
List of VBA Functions
Set Active Worksheet onOpen
Creating a vehicle running sheet??
For Next statement
Cut and paste
VB to Find Rows
Question to overwriting a sheet
Coloring problem
Re: Files properties
Excel VBA - Easy way to paste chart to word document ?
VB's equivalent to VLOOKUP?
Cells coloring PivotTable
changing colours on stacked bar chart
Excel VBA - Activate Open Workbooks to format
Arrays
Subscript Error
Find&Replace on a lot of *.doc' s via an excel macro?
Sort by color
Additional thread in VB in Excel
SQL-Query from a textfile?
Editing a Row
Q: find range, listbox - format and fit columns
Word Mail merge
Excel Macro - Calc to last row problem
How to create UTF-8 file from VBA?
If Then Else Help Please