Excel Programming [Archive] - Page 155

Class module
Convert a 100,000 character linear text file
PivotTable and PivotCharts Problem - Manipulating in VBA
Printing radio buttons with the circular outlines
Undo macros
test if a sheet exist (with the name) ?
VBA Conditional Formatting
Solving equations programmatically
Running a excel macro from VB6
Track Excel File usage?
Can subroutines be called based on a commandbutton number?
Duplication warning
Defining range
Calculate vertical midpoint of a print area in a sheet
"Insert Line Break-Macro"
Finding week from date
Thank you, TOM OGLIVY: linking across the worksheets
#N/A error
Excel References
Suppress dialog while opening a write protected Excel document from VBS
updating a workbook
How do I reference the cell address next to Active cell
Import some data
List boxes/combo boxes
R1C1 to Range
Deleting files
Email templates & Excel Macros
How to empty the clipboard using vba code
Automatic update of code in other workbook
How can I get all table names from MS Access databse
Problems with SearchInRange() macro
function in a cell
How to make a nex sheet?
Repeat cell content
Printing numbers in Excel. Macro needed.
strange "subscript out of range" error!
Problem with Importing Data to Spreadsheet
How can I get the last used column in a sheet???
Freeze formula results
Sockets from VBA
Trying to create a conditional sum
multiple scroll areas on sheet?? and combo box values
running a macro ina workbook that doesnt have that macro
remove the row value in the pivot table creation code.
creating logarithmic trendline equation function
Sorting a Filtered List
graph showing date and time of arrival on each date
One Single Message Box for chained macros
Error: The procedure number is out of range
Pasting into Filtered Lists (Visible cells only)
More on Concatenating Rows
Insert a row after each account no change
Assigning a query to a control button
Populate combobox with visable rows only
SavingExcelChanges
what's the best way to do this?
Excel Graph
Error: Too many cell formats
Deleting broken range names
Menu Options
Transferring Workbooks with Macros to and from Mac Excel
Identifying Date Cells
macro to filter/print pages using certain criteria
Query on Control Source in Userform Textbox
object model diagram
Generation of graphs from a template sheet crashes with VBA
Help "saving as" please
Multiple destination cells for data entry
Branching in a macro
IE6 and Excel Web Query
Copying an array to a worksheet: Excel 97 vs 2000
Further ActiveX questions
negative number
Automate Excel from VS.NET
Re Name a Worksheet as a Date Format
Looking up dependent values in a list
deleting toolbars
Vertical mid-point on sheet
Microsoft Office Macros
Change format of a cell
Moving Between Worksheets
More Formula Help....
Form limitation
Macro Random Behavior
Macro That Moves Cursor Down
SQL.REQUEST query omitting rows in MSSQL DB
sheet names
returning max UsedRange row number
Find Keyboard shortcut in a macro
Excel File size, when imported JPG images
Date autocomplete (XP)
Formula problem
zeroing cell values in a collapsed group
Reading Access - Multiple Indices
Filtering Names By Date
Date format
filtering out whole pages only
How to update a pivot table, without refreshinh the whole thing?
Create Pivot from array?
XLL Functions with no parameters
Copy_to_sheet macro
textboxes and datatypes
Autofilter
Code Cleaner in 2003
Array or Vlookup
Improving the speed of FOR/NEXT statements
Need Macro to rename excel files
Commandbutton in UserForm to run Macro
Looping down list and each time copying to another worksheet
Looping down list and each time copying to another worksheet
Imbed SQL in Excel ?
Delete results of Autofilter???
truncating pasted text after 250 characters
Select instersection of two ranges
Common Dialog & other
More formula help.....
Deleted macros still showing enabled
Printing Excel BLOBS
SaveCopyAs method
Function that returns name og curred sheet
Form
Hourglass
Loops for deleting rows
Flickering edit bar during loop
Showing worksheets in an Add-in
ActiveX Controls
Change Word Total and Grand Total
Hiding Worksheets
User form - Picture in the caption?
Using TextBox to AutoFilter
How can a formula get the location of the cell it is placed in?
Returning an array in excel
Internal Hyperlinks in toolbar
Userform
Columnwidth changes-Event
Create macros to print specific cells
'splain the code please :)
tracking a macro like the evaluate formula tool
graph troubles in VBA macros
Event Sequences
HELP,how to show search result according to specifed criteria and selected fields
Conditional ranking
Is this possible?
Excel VBA - Userform Checkbox/Textbox Problem
Shifting Data Right Within A Range
How can I merge multiple files using SQL?
Old Value
UK to US date format
How to pass an Excel range as an argument to a SQL Server stored Procedure
Adding range to array, keep formatting
Copy paste range
Problems with SearchInRange() macro
VLOOKUP
Sort data failure
Delete hidden worksheets
Hidden Worsheets
List to Range
Icon in toolbar
Updating Links
Excel Menu 'pop ups'
Repeat job
Decimal declareren
Sub routine failure
Put formula in cell
Coloring cells thru VBA
DropDown list
Delate Names
Macro freezes Excel
Assignment by reference or value
Excel crash error code
HELP sort 2 worksheets
compare two cell values on different sheets
Excel 2000 macro security level
VBA back compatibility
Excel 2000 - range.calculate error - 2147417848
Run macro in background
Column.
Programming Array Formulas in VBA - Can they be intermediate results in RAM?
Help with SUM code
highlight cell as answer
Request Vba code Export gif file
Sorting question
checking for missing values
Combo box question
Using cell contents ae address
Combine two macros using InStr?
Embedding Executables in Excel File?
Userform Problem
create help files!
check if protected
TOM you made my day...
highlight cell as answer
printing module code from vba editor
#if..#else..#end if.
Scroll Into View
excel save AND concatenation problem
Determining if Macro Can Run
delete commandbuttons on copied sheet
what is this object called? - right hand corner of statusbar
xlUnlocked Cells Not Working
Last Row
Positioning custom menu
Stripping Path from File String
Creating a SubMenu
Why did XL stopped showing me the Macro Commands List
Why did XL stopped showing me the Macro Commands list?
Question on ktmsgbox Utility
Activecell.FormulaR1C1 Versus ActiveSheet.cells(column, row)
Re: how to put formula in a cell
Question on ktmsgbox Utility
How to delete an embedded chart
findnext issues
Data Validation erratic bevavior
program for filtering data.
Error with "Find"
How to activate the cell in same row, column 1?
VBA to set which columns in Autofilter
Deactive Activate Workbook Events - Add Menu
Get next Integer value
How to hide/show row/column headers and sheet tabs.
How to check programmatically whether Excel is installed on computer?
Worksheet Data Filters
Displaying the URL's of imported webpages
Automatically moving data
UDF, Category, Data Type, Format, Using
saveas for backup
Combobox problem
Variables - simple question
Writing a macro to change external links to manual updating in Excel 2000
Technique to move (reorder) items in Listbox
Hide or disable print
Excel Macro for multiple sheet ??
reading password-protected, open webpage
Computing Date n time
Can Page Setup values be controlled with VBA?
WorkBook_BeforeClose (Delete Menu)
help!!! i can not send target to my sub in event
Accessing File Properties
Open Winword from Excel
Replacing a value from a formula
Disable Macros through VBA
Temporary storage, Addin events
Code Help
Format Chart's Y-axis . Urgent
Checking for VBA5, not VBA6
Excel Problem - Delete Row Macro
excel function within a function
Re: Edit information in a cell and not change content
IF Statement
Function help
Excel VB Macro HELP!
Next line in header
Re: Personal.xls
Re: excel function within a function
Looping input from a text box
Column format as Text
SubTotals Problem
Re: Formula Help
Db function
function within a function #2
Re: excel function within a function
VSTO .net - Adding a Usercontrol unto Worksheet
Hide a data field on a pivot table
Excel VBA-Error, range function not working?!?!?
How to neutralize Active Cell?
it's not working anymore, please help!
ID location of duplicates in different workbooks.
Adding error-bars in a pivot-chart
Fixed objects will move
Editing Addins
Email again
Convert XL2K wkbk w/ macros to XL97?
Error Handling
Excel VBA crashing
Excel x CSS
Re: Formula Help
Workbooks referenced by a deleted workbook
Inputbox for Worksheet name - problem
Excel VBA-How to close all open workbooks except one specific?
Copying unique values
Workbook referenced by a deleted workbook
VBA Calendar control
delete empy rows
More help with SaveAs
Menumaker.xls Create Macro on User Toolbar
Scanning Through Filtered Data
Help with "IF" Formula
Do Until Help
problems calling this function
Lookup of sorts...Matrix Array etc.
Email from Excel
A few RTD Questions
Find all running Excel Application objects
Pause?
Calculating pagenumbers before printing
Parsing Data
Parsing Variable Range of Data
IRTDUpdateEvent failure
Run-time error '6' overflow
Help with SaveAs
vlookup?
For Loop and If Statement question
For Loop and If Statement question
Textbox value
Macro error stack full
Type Mismatch
Deleting Sheets
Writing Text Files
Leftaligning text in right header
Data Migration from Lotus . 123 to xls
data tables
FindNext problem
macro adjustment help
range.calculate error - -2147417848
display values in cell
'Programmatic access to Visual Basic project is not trusted.' message
worksheet_change event with a combo box
Conditional Formating Format Painter
How to write back a SQL Server table from Excel
Finding the query range
Re: how can i know the hidden by programming
Re: When open an old xls, an new macro is in a new module.
Re: Help with SUM code
Re: Find entries greater than 'Dec 2002'
Selecting Multiple Chart Series
Advanced Filter
Re: Find row (and column)
Selecting Multiple Chart Series
Deleting All Sheets Other than specified from a workbook
Re: Get objects property names in run-time?
Re: Easter egg in Excel 2002?
Re: file property
Re: Moving Data Within a Range
Re: file property
Problem with list
Paste Special
Truncated text in a combo box!
Dialog Boxes
When is "?" really a "?" (.SaveAs with Chinese chars)
Excel VBA data export
How to use multiple sheets with range in userdefined function.
Take value from sheet
possibility of automatically placing an autoshape using a function
highlight cell text
using a button
Listbox issues
Duplicate ToolBar Buttons
macro or vb to alternating row color
Data Types and inaccuracies with Trig functions in VBA
Excel Access Query
Negative number
Code to format data in cells in VB
need help- SUB: DATATYPE FOR A CELL..
Got a little challenge any ?
Looping through Sheets and passing values to an Array
How to record a New Web Query that requires login + password.
Macro, Persoanl Work book and CSV workbooks
Save the layout of PivotTable
Need simple VBA math help
efine the data type of a variable
Red bullets in left border column
Deleting rows which match filter
maybe i'll get lucky again
From form to sheet and back using proc
getting rif of apostrophe in front of ss#
Removing VBA Code (programatically)
Worksheet_Change event won't fire to execute Macro???
combo box codes
Arrays
vba programming copy/ paste cell values help.
From forms into a new row neatly?
Code to check if workbook is the last one opened
splash
Excel & dates... how to determine order.
Formatting a MsgBox number
Creating new VBA code on the fly
"Reset" a workbook
Error retrieving value of the specified Excel cell (Not active)
Pivot Table in Excel 2002 XP - Calculated Fields
VBA & Conditional Formating issues
No need to reply!!
DB Connection error
help with arrays
Re: no password carryover with "protect sheet" in macro
Userform ComboBox and TextBox help!!!
Help with saveas
Increment through For Next loop
Spelling out a numeric value
xls property
compare
Programming in Excel 2003!
Excel VBA-open & save all delimited files
Split Workbook - improved code required
help in writing a macro
VBA Help Screen question
text match
Button to close without saving
Re: pressing the "reset" button and freeing memory
TOM it did not work...
Add-In / Tool / VBA Code for Renaming Range Names
getting coordinates of a range
UDF - detect cell border
Frank - Thanks
range.activate
Re: Help with macro!!
Tim
Can I change the font of a toolbar button
Re: TOM I have put a wrong question
Re: TEXT(Cell1,"MMMM YYYY") to work in all locale.
Excel VBA-How to save sheet w/in all workbooks as sheet1?
more workbooks in one
Using VB to code a Macro within Excel 2000
Re: Excel sheet data to oracle.
Remove single quote, help needed!
refresh data vba question
text match?
Re: Macro for changing tabs
UserForm 2
Email a worksheet
Is there any way to enumerate the cell which contain a formula?
Calculating Sum question.
Trap a DateValue Error
Fill a Listbox with Values from a Pivot Table Field - an Example
Re: Macro for changing tabs
how to delete a row
Excel & VBA Macro Help AGAIN
Dialogs Command
Running a macro when a Wb is opened
Sorting two separate worksheets
Using INI files
Copy and rename files from hyperlink
Emailing Lotus Notes From Excel
VB combination code
Dynamic data exchange between two computer on a network with VBA
Getting a range from Excel into a Word document
Comparing Formulas - for budget purposes
Unwanted Square Character in .txt file
Copying tabs in a workbook
Determining last copied range
excel 2002 build problem :(
UserForm position
control toolbox contrls disabled in design mode
Need a macro to do what this VLOOKUP does
Comparing records from 2 tables
How to input 2 dates and mark them as range...
TEXT(Cell1,"MMMM YYYY") to work in all locale.
Distribute Personl.xls and excel.xlb for net use
How can I call Range::Find from C++ without crashing Excel?
How to become a better programmer, post college. More projects or less projects.
VBA equivalent of findstr
Preventing compile errors when referencing objects ehanced after 1997
Moving home
display settings
Numberformat
replacing column alphabet
Printing second page if data overruns, otherwise print first page
Read Only Enforcement
Re: Macro
Re: Using qry from excel to update tables in a db2 database
Excel and MDB Datbase Files
There has got to be a better way
VBA Replace Dates
Generating a Hyperlink Macro
Morning
Validation lists
Selecting a Page in Page Break Preview
Using Word Bookmarks to read Text
Re: Using qry from excel to update tables in a db2 database
Re: Using qry from excel to update tables in a db2 database
Cell validation
Date and sequential serial numbers
covering cells
GetSaveFileName across mixed language network
How to get image's path?
Excel VBA- format string length to get a cell height
Restrict a column to allow only unique entries?
Which is the best language for rewriting code into DLL's ?
Transfering Required data from *.txt file to
Adding menu to the mouse right click pop-up menu
using VLookUp in a VBA program
KeyDown / KeyPress Events
Font color buttons?
Running Macro with B/ground Timer
Excel vs VBA Dates
size of the plot area
Delete a row
specify a range of numbers in excel formula
Inserting a Face ID onto a Command button
Checking input for alphabet (i.e. words)
Web Query
How to add a macro with password protection
Filenames into Excel
Delimiter for Data Validation
Please help
Variable
Controlling Tab Oders
Creating new VBA code on the fly
using a macro to unproctect a password protected sheet
columns seletion error
Help, Need Copy of Excelrecovery
Password protection
script detecting the change of active cell
VLOOKUP help
How to get the number of a row
Combining 2 HTML files into a Single Workbook
Textboxes and loops
Mass find replace - inserting a linebreak
Transfer values from column to row using macro!
populate a cell with an external workbook referance
How to determine a range size
Copying too much.
Not Hiding Columns
Beyond a wholesome discipline, be gentle with yourself.
Determining the group a picture or textbox is a member of
Re: Using qry from excel to update tables in a db2 database
Re: Adding 4 business days to a specified date
Renaming tabs
ShowDataForm Initialization
How Can I Check Multiple Ranges?
Please help, file name issue
Conditional Formatting limitations...
Default Filepath question... How to???
Find Unique Entries
Automating import of a certain type of 'txt' file
Complicated Table
Range problem
Wacky form
Re: Function name not recognized
Userfrom code in written in Excel 2000 running in Excel 97
Re: Getting rid of "extraneous" data (rows)
testing whether a character is a letter or number
Macro to save excel XP spreadsheet to excel 97 spreadsheet format
ListBox question
Cannot Record a Macro or Edit VBA
split cell content
Use Checkbox Value or Public Variable?
HELP!
Deactivate Formula
Clearing Cell Contents
Code to print w/out cell shading
ComboBox RowSource --- can I use a userform OWC10 spreadsheet range?
pastespecial on a worksheet question
Determine last row then sort
pivot table single column
Compact Excel Spreadsheet
srf
Resizing comment boxes
How do I set values from a userform
Autonumbering
Filling a Combo Box with VBA
Conditional Formatting
Moving and parsing data - Copy & Paste problems
run time error 91 all of a sudden
How do I set focus
How to reference unsaved workbook in functions????
Linking to an external referance with a variable file name?
Excel Object Library Reference
Diverting output to another workbook?
Recognizating worksheet name
"Subscript of range" error
listbox with checkbox or radiobutton groups
Customised charting and data lookup
Linking ComboBoxes through VBA
SQL query to ODBC
SaveCopyAs cannot access opened file?
Using Round function on French and US Win2k
Converting Lotus 123 macro to Excel - copy/move data to worksheet
Converting Lotus 123 macros to Excel - Sort by Due Date
Summarizing several item values in one cell
Expot to Access
Pivot Table value in category renamed but the old value is still there
IF AND in VBA
Mortgage amortization Template
eomonth funciton in VBA
Getting rid of Prompts in a macro
VBA Functions
Macros
How can I make a simple database.
Copy/Paste to all Worksheets
"ghost" link
Sace and close
Recordset in Excel
Excel VBA-Change chart range to variable
Cell check
Customizing Toolbar
Re: ActiveX registering problem with VBA
Set a PivotCache as the results of a query
create a "check" macro
Excel VBA-
How to read active Excel celll value by external vb application?
Add value to existing cell value
Filecopy and UNC-pathname
Re: ActiveX registering problem with VBA
VBA/ActiveX ComboBox autosize bug - Selection of value multiple times shrinks text.
Macro to load on open
Help with Arrays & Ranges in VBA
Macro to unprotect workbook
Locked cells
Can´t get Forms Toolbar after executing macro
Calendar Macro
Keep the Enable Refresh option (VBA, SQL)
Getting File property info with code?
calculate
Concatenate Function
Macro
Using chartspace in a user form
Comparing Excel Workbooks
Mail Merge
Checking and Updating
ForEach procedure adding values
Maximize Excel
Excel automation
making macro run faster?
Comparing negative number
Sharing
Is file opened?
XL97: where are my favourite MVP's ?
Create (or find) a complete object tree for excel
"Dumb copy"
TEXT(Cell1,"MMMM YYYY") to work in all locale.
adjusting Y-axis
csv example
change value in a cell if other cell is changed
Listbox control
Pull data in a new colour
Set focus on command button
MANAGING MACROS
Empty listbox
Chart Identification Problems
format painter
copy files from one dir to another
Listbox with Bound Columns
keeping code in .dll library
Excel2000 VBA - Workbook size increases abnormally.
Matrix inverse
Getting a function to return a formated Range string
Problems with Excel 97 and XP
Another problem with changeing a graph
SelectionChange Event
Changeing a graph
runtime error 1004
Drag and drop onto cells?
Zoom on selection
Repost:I accidentally posted this in the general excel forum. Date Logic
Calculating Dates in VBA
Chart Series Question
Values in words
Assist in converting Lotus Macro to Excel?
how to select every third row
Need Help with macro code modification
Listing Temporary Internet Files
Making a connection: shape clicked and cell it lies over.
EXCEL PIVOT TABLES DETECTING EVENTS
emailing from excel
Maximum character input in a cell
Get sheet name given a cell
how to put tab character into textbox?
Unable to get VLOOKUP property
Macro Ran in Excel 97 but in XP. What Needs Changing
Vlookup with tableLookup is external workbook
UserForm_Layout event - Excel97
Hiding Toolbars Question
Re: Macro assigning help PLEASE
Hidden name
Undefined unction when using VLOOKUP
Auto Clear Cells
Generate a Modulus Sequence
Macro to mark double numbers in another colour.
Join string with variable name to get variable value
External dll
Path
ComboBox with an editable function
VBA-Select several ranges using variables
Defining Custom Colors
SetFocus to first textbox on userform upon Userform1.Show
Can't Update Cells from a Function?
Making Excel Ignore invalid references
Combining Msg Box and Data
Save Location - Date Format
Running Totals
List Box and Quick selecton of item in drop down
Macro to move selected cell contents to a specific column on same row
emailing workbooks
Setting scroll area for multiple pages
"Licensing" utility for protecting my Excel code
RE: Checkbox value
Refusal of Excel to recognization Worksheet name
comparing a value to a list
Collection Class problems
average and stdev
Dialogue Box
changing the name of a file
Blocking cells
Re: How To: Make cell reference the sheet name
Uaing VBA to query macro security level
Var
Finding the largest value
Multi-worksheet finds
Re: How To: Make cell reference the sheet name
Dele rows
Prime Numbers?
Activate Workbook
Question to a VBA Wizard!?
Need help with adjusting width of VBA-created toolbars
Blank import
Copy - Paste
automating email (CC:)
Re: TEXT(Cell1,"MMMM YYYY") to work in all locale.
Creating a summary
Chart via Combo Box
Address Subroutine Name from within Sub
Remove rows where value = 0
Date of Last Update Automatically?
Adding an artificial watermark to Excel sheet
Validation List Definition Fails for Some Regional Settings
something_like_transpose
macro to subtract columns and put result in new column
file transfer
passing parameters from command line
Run macro in different workbooks
Problem changing open file from R/0 to R/W
Copy Files from a folder to new location
Trying to move a BLOCK of data using 'OFFSET'
Importing data
Select an array of cells and paste to separate worksheet - 2nd post - 1st didn't work!!
Custom Fucntion
User forms & worksheet help!
Output from a userform finding the right column. column
Programming Excel to export to Access
excel-access
Help with IsEmpty
Open event
Showing a .PDF From Excel Button Using VBA
Find images in a Excel document.. How !!
Printing Excel in Landscape mode...
Unsupported object or method...
VBA protection and 'save as'
VBA problem - text boxes
macro/combo interchange
arrow key problem
Excel VB / Formula Problem
look ups
Single Selection ListBoxes
how to control word from excel
Working with multiple sheets
Yahoo quotes error in Excel
Add In - How to start and use it
Date formatting a text box
Creating Global excel macros
Copy worksheet from Active workbook into all other open workbooks
Assigning worksheet to worksheet variable
Date formatting
too many different cell formats problem
Hiding Named Ranges
What is the maximum number of files that a directory can contain on Windows XP?
XL97: colouring Pivot tables
Application.Caller
biff 2 clipboard
Code to automatically overwrite?
ADO - how to run proc returning a record
title in graphic
automate graph-data
double names in a list
Create seperate xls files with names based on cell text
Personal.xls
Colour Macro
Re: TEXT(Cell1,"MMMM YYYY") to work in all locale.
is it possible to run a macro automatically?
Hiding Parts of Excel
Command Button Picture
Creating multiple pivot tables from same cache
Replace worksheet name with a variable
how to disable form buttons using macro?
Indirect versus Offset
"Automation Error"
Excel column as datasource
re:clear pattern not gridlines
hide sheet? uncheck sheet tabs? or ???
Sheet protection assistance.
help with msgbox
Combo Box Events - Self-Referencing
Saving worksheet to .doc file
clear pattern but not gridlines
ThisWorkbook.Path
urgent, how to lock entire column upon load?
Help with code that checks if a sheet exists
macro help with print lables
Number of occurances of the larges value in an array?
How to color characters REG, GREEN, YELLOW in the same cell?
Please Help!
Update Closed Workbook w/ ADO
displaying the outlook address book in excel
Back Door to VBA?
hWnd of UserForm
Running a macro before saving file
help...
Re: Dynamically pasting function from Visual Basic to Excel cell
combo box
Notifying notify users on how to lower security
Re: Time Errors
ATPVBAEN.XLA!Random Call in Macro
Get File Properties
DDE to Query AS400 DB
Save As UI
Progress Bar
Moving through a data entry form
Opening help file with context number
Accessing password-protected Excel wkbk from VB
Lock a cell when a given cell contains data
Excel95 Floppy Save problem
Convert numbers to text
Checkbox value X instead of check
lookup cell location
question about worksheet protection using userinterfaceonly:=true
data from userform into worksheet cells
countif color count
help!!!
Finding duplicate value in another workbook
List boxes in MSExcel2000
Re: How to Refresh with VBA(SQL) created Pivot
force macro
Streamline PivotTable creation code
Activex dll files
GUI like the file chooser
Can't start outlook from Excel
macro to move contents of directory
Window Options
Assigning a formula to a Cell
Set focus on graphic inserted in worksheet
Compile-time Error Handler
Renaming the Worksheet through VBA
Control ToolBox Showing Maps?
MS Query
need help with filtering a list
No Charts will refresh in a Workbook
VBA Button to switch worksheet(s)
looking to simplify a recorded macro with code
disallow edit in used rows on save
Submit new data
Turn off pasting in range of cells
Range from highlighted area
error: reopening will cause any changes you made to be discarded
Subscipt out of Range
controls on worksheet
How to add new type of "External Data" in excel
Summing data
VBA-How to insert vba code file in a project using coding rather than manual import
Change names of files in a folder to match names in Excel Column
Conditional formatting across worksheets?
Adding a new column/field
Save Workbook using List Box Data
query criteria for timestamp
How to store organization wide macros?
Re: eliminating quotation marks when writing to a text file
eliminating quotation marks when writing to a text file
WRQ Reflexion
removing symbols from numbers
removing symbols from numbers
Re: How to skip in a macro
Re: Toolbars and menu items have gone
Disable Cancel button
Select column at run-time
GetOpenFileName
Fill a Memo field
Bizzare issue with matrix calculations
Naming a Range
GetOpenFilename
Parsing paramters
VBA Problem - Print Preview
Editing Queries in Excel 2000
Excel clearing clipboard
BeforeSave workbook event
Calling variable from user form
Import Wizard
Emailing multiple receipiants
creating formulas in XL
Picking Teams
Using the Find function with the What referencing a Range/Cell Value
Assigning a sub to a specific keybordkey
Office2003: Handle events for web charting component
Re: Graph Chart Custom Types (Tubes)
Left Function in code
what does .Find return
Userform Combobox to choose date
list of network computers
select printer
working on 2 different worksheets....arrays?
Excel generation and PageSetup.CenterHeader
Auto-Size and Position Pictures with a Macro ?
VBA Help - Running a macro when closing print preview
Re: excel--->access
column format as text
Save on change
Macros and User Defined Data Strucures
Re: HELP!! Macro suddenly not working
Login Information
need help getting combobox to open a file
Static Time Entry
Excel VBA - Opening a workbook to a specific sheet every time
hyperlink
Appending Imported Text Files
Mouse-move flicker, modeless form & shape selected
Alignment problems
"Modeless" Message Boxes?
Display Excel Sheet in VB6
Redim 2D Array Subscript Out Of Range Error
send text
Automatically Closing a worksheet after 10 mins
how to set password to protect worksheet under excel?
What is the formula to convert a whole column of date to text?
Re: How do I change a macro to call a sheet from another workbook
How do I change a macro to call a sheet from another workbook
Running a VBA by ASP
Suspend/resume running of a macro
urgent, on excel programming
Chart.Export max pixel size?
Before Double Click Event
selecting values
Working with quotes
Macro to clear content and put back a formula
FOLLOWHYPERLINK - Posting Over 1000 Characters.. can I?
Begin Search at specific cell
Passing parameters between functions
Different Kind of Progress Bar...
Lost my macros...
Auto-delete the workbook on expiry
Autofill
Importing Text File
pop up boxes
Deleting Hyphens or Dashes from multiple cells without deleting the remaining content
Creating a sheet at set times
InitializeComponent() errors, Setting values in another form
Selecting a range without referring to specific cells
highest value in a Row, that begins with "21" or "28"
CountBlank in calculation
Switching between Worksheets
Saving an IE Favorite from an Excel macro
Is there a way to apply a sliding percentage?
A macro for the today's date...not the current date
Data Validation
import text wizard...
Pop Up Window
Named Ranges
The 'clear' instruction in VBA
returning ranges offset from argument range function call
Output to CSV
Searching the formula result
Do I Need Licence to Develop Excel Tools for Sale?
Pivot table from a pivot table
Help with Analysis
DOS Messaging
funcres.xla
Sound Code
Email 1 Cell w/VBA
add new named sheet
Newbie needs direction
save as an UTF-8 file
Filter Rows
Prempt Disable Macros option
Worksheet_Change sub does not trigger a called macro
Selection.count isnt working
CSV formatted text file to Excel
Login Help!!!
adding a description for an UDF and its parameters(!)
Re: Charting Weirdness and VBA
Excel cursor
forming Ticker-Tape in Status Bar after running web Query
Re: Inserting iserror into a range of cells
questions regarding chart format.
Send Email from Excel - but only to people in range
VB in Excell
text boxes
RE: WorkBook_Open Event
Worksheet labels
Making cells readonly
Re: FAST, RELIABLE, LEGAL MONEY MAKING OPPORTUNITY
Command buttons
Remove vertical scrollbar from spreadsheet in VBA code?
auto sorting
How do i create a new worksheet
extracting numerics from literal strings
SaveCopyAs
Macro to paste data into next blank row
Code to go to last row (next blank row)
Corrupt Excel File, I'm Toast! I'm beggin here...
Help becomes disabled
An Excel question
Making a auto website login script
Need macro to work in 2000 and 2002 versions
compare mulitple fiels... then, order the files by header... then, save
TimeSerial
find letter vrs number
Array Functions
Using ActiveWindow.PointsToScreenPixelsY
Naming Cells
Need continuously running macro when conditions are met
formula for stock quote
Formula within formula
Amend open Workbook code
to join more workbooks in one