Excel Programming [Archive] - Page 131

Information from one cell pulls information from another cell
Excel crash HELP!
Need help using a variable in Range command
Switch Workbbooks
using Criteria with two possible values
How separate text boxes from pictures in the same worksheet by code?
Sum Formula to Exclude Certain Cell Values/Backgrounds
Search for the word "continued", if found, delete that row + 10 rows above
MS Object library
Cut last word in cell and paste in next...
Time Problem
Starting add-in using vba
Use of forms in Excel causes crashing
Add-in to run macro when ANY workbook is opened?
running timer
Autofill
Move to Next Record with User Form
Print in Gray Scale
unlock and lock VBAProject
Apply vba code to multiple userform objects
Any known issues between VBA for Excel 2000 & 2003
Icon for Menubar
Backup with date-time
Continuing VBA development whilst workbook is in shared use.
transferring code from VBA to a VB dll
Apply vba code to multiple userform objects
unlock and lock VBAProject
Re writing program - 3/4 rogrammers input on this spreadsheet, !
using names
Building a String based on Selected Check boxes
using names
Is column hiden?
?web query?
EXCEL 2003 AND WORD doesn't speak anymore
Share a workbook and protect
GOTO Using the ()NOW Function Q
I've killed the copy process
How Do I Get SetFocus On A ComboBox In A Frame?
"Save As" triggers combo_change event
creating new file
vba to sort group copy paste to another sheet
Opening newest file
Help deleting rows with vba
Check matching value
isnumber()
Retrieving data from Excel and store it into string variable
Help! Excel multiple worksheet populate from recordset
I am Tring to lear how to create addins with excel 2000 were can .
Automation Add-in Distribution problem
Trouble with Macros Assignment- anyone willing to help?
Way to Protect cells
Calculation Stopped
How do I make a 'global' macro?
Fill Color - any way to know what it's set to?
chart sheet value (Y) axis scale data report - an example
Calling the "Move or Copy" Dialog Box from VBA
import text w/macro
Starting add-in using vba
supress activex message on open workbook
Tab Order On A UserForm
when Boggs is on duty the total sales are higher than when he is absent
What is the VB code for autofilling relative cells?
Using InputBox to get desired date for a Query pulling data from Access into Excel
Refresh BackgroundQuery problem when migrating to Excel XP
Runtime error 1004
Jumping Out of Nested Statements
HELP - I need to adjust code!!!!
Why ?
Using VLOOKUP in VBA
VBA to call a range
Creating a Pause in a Macro
Copy problem again.
Re: Select Case
Looking for cells with variable in cell text
VBA to call a range
COM-call-in to Excel
Problem with Macro
User Forms
Using InputBox to get desired date for a Query pulling data from Access into Excel
Protecting cells with data validation
ChDir Error
An instant sorting problem
Problem with textfileplatform
Active cells
Realy Stumped..Multi Selection of Rows?
Unable to reference data stored in XML spreadsheets
VBA and Excell
Text Box 'Left' position problems...
Textbox Bug? Missing/delayed update of textbox filled via VBA
Generating Non-Repeating Integers via Randbetween
Textbox Bug? Missing/delayed update of textbox filled via VBA
How do i download excel 2002/2003
Search for the word "continued", if found, delete that row + 10 rows above
Delete
Swapping Values
Delete
reading database and filling excel
Format cells with numbers and text
Unable to set the PaperSize property of the PageSetup class
Copy-Paste between sheets in dif WB's
Combined code not working
Help with shared workbooks and maintaining content protection
ADO and sheet name with spaces
Auto Run Macro
Paste values & formats
conditional disable functions
Common module by multiple workbooks
Software Life Cycle
Add-in and toolbar
Excel and Access
Dynamically select a Printer
loops and if statements
Macro attached to button runs twice
PivotTable Columns
PDF Files into excel
Selection Based Pivot table in a macro
personal commandbars
PasteSpeacial - transpose
Toolbar Recorder
Generalising Deleting Rows after AUTOFILTER
Macro-hide sub sheets?
Generating Non-Repeating Integers via Randbetween
PasteSpeacial - transpose
Showing Time
XLL Files
Vb Macro to attach sheet and send by email
Halting code for worksheet manipulation?
Locking project with workbook open?
Function Wizard - Help for arguments
Web queries: button v code
How to check for Exclusive access to a workbook
Print the same sheet from different file
Code to check existence
Alternative to Split function for Excel97?
Retrieving data from Excel and store it into string variable
REQ, component for MNG multipage export.
Cell Comment Summary with Hyperlinks
Comparing & Retrieving Data From other worksheet
Continuing VBA development whilst workbook is in shared use.
Delete rows with particular dates present
Can't re-open Access database from Excel VBA
Common module by multiple workbooks
SQL Connection
Passing Public Module Vairable to a Worksheet Event
Geeting error while setting datalabels through VBA
Going to cell with maximum value
Help With TextBox Formatting
Transfere a workbook's all cell's formulas and references to VBA "fingerprint library" ?
StrikeThrough
User Input Of A Number
Open database from Excel
ADO to pull data into another worksheet
How can I customize the buttons in a MSGBOX?
Cut & Paste with hidden columns
Modules
Modules
Help deleting rows with vba
Modules
Modules
Collections of Collections
MyHelp.chm ????
Combining absolute and relative reference for sum
More on merged cells
force keyboard (ALT) shortcuts in VBA Code?
Help needed with merged cells
HOW DO I PROGRAM THE TAB KEY TO MOVE IN SPECFIC ORDER?
Bitmap data of Image controls & Picture objects...
formulas in drop down lists
Looping through range newbie question
Using VLOOKUP in VBA
Excell work sheet
Calculate Month
Calculate Month
Disabling COM Addins in Excel
Macro To Shade Every Other Row
Paste as values in macro
How can I get my to do list on my daily calendar?
Using a Variable in the Workbooks.Open code
ADO and Combobox
printer options
VBA Macro Loop
formulas in drop down lists
formulas in drop down lists
VBA error with calendar
How do I access each cell in a range
Change date format in string?
Loading Excel Data into a Form
templated array as function parameters
Exporting columns in excel file to csv format
object.EnableEvents = false
personal.xls doesn't open when double-clicking on Excel file
Header code
Inserting rows via macro
WorksheetFunction.sumproduct limits?
Help please with copy problem
Using a Variable in the Workbooks.Open code
Macros don't work on another PC
VBA Auto display validation list on cell selection.
Find value
Array Formulas with multiple rows
Inserting rows via macro
VB6 COM Add-In for multiple Excel and Word versions
VB6 COM Add-In for multiple Excel and Word versions
Header code
VB6 COM Add-In for multiple Excel and Word versions
opening a large text or csv file
input not erasing old data without notice?
vba code for subtotals and percentages
Divide comma-separated string and look up corresponding category
Divide comma-separated string and look up corresponding category
excel lookup help... already have formula but doesnt always work
Include password in VBA code to open file problem
Find Method Not Working Right ?
ActiveWorkbook.Close
can I use some Qwery to populate the sheet with the data from pre.
Timeout Error
Can anyone help with _click() events?
On Open
Removing leading spaces
ActiveWorkbook.Close
Macro modification
where or how do i create a function that ive been given?
Looking for RANK macro
Got a doozy!
Help Converting Cell Formula To VBA Code
Insert cell/format/text/fontsize and auto insert into header?
clearing the office clipboard in vba
Calendar error and include on form
Twice run of macro
How To Query and Update Excel Data Using ADO From ASP
How do I calculate how many days in which months given two dates .
UserForm; Textbox; Multiline; NonPrintable Characters
whatsthishelp
Format Painter Info?
Column reference
Shortcut to personal.xls in XLStart forlder
Not A Valid Add-In
Pls help to check my macros
Selecting one every four other rows
Formating Time for calculation
vba code for subtotals and percentages
Toolbars
Writing to protected sheet from ASP.NET
Writing to protected sheet from ASP.NET
Unlocking protected Sheet from ASP.NET
Issue with selection boxes and if statements
Startup Path
Export sheets
option explicit error
vba code for subtotals and percentages
Problem with option boxes
Accessing hidden sheets
How to attach function to a custom Menubar?
merged cells and wrapping text
Refresh Modified Query From Same Sheet
What's wrong with the code,pls hv a look
VBA to copy and paste folder
Go to a Cell Below the Last Populated Cell Q
Cursor Position in VBE
Increase all Font Sizes by a Certain level Q
Get OLEObject.Object with Csharp
programming - copying and arranging selective data ...pls help....i know u can...
how to display data of input that is within a data range???
Calendar ToolBox in a UserForm
Passing data from PDF fields to Excel
Check font strikethrough
Delete a row
add-in macro strange errors--method sheets of object workbook fail
Lookup
Displaying charts from Macros
Fill down from active cell
Fill from active cell
Year and Month Question?
Is there code for finding last row of data?
Counting the number of consecutive cells/rows that have the same entry
Made a Word Document with inserting an excel file??? BUT???
excel97 vba to append lines to text file overwriting last 2 lines
IFPUSH & IFRUN functions??? Please help
Maximum value from multiple worksheets
Filling down from active cell
Testing in a macro for bad range name?
Need help with "Find Method"
How do I delete my custom button on closing
Printing Range at the beginning of every new page.
Reading Sheet Names/Index from closed file using Biff8.
Changing Properties of a Range object after initial Dimensions ??
pivottable
HELP w/ Macro and IF Statement
Excel and Word
Delete blank rows in Excel with macro
UserForm problem when Worksheet is cloned
Problem displaying a listbox over a combobox
Pivot Table refreshing
Help with altering a download macro
Distribution Lists
Macro Error
Control Toolbox appears out of thin air
Need code for Excel Simple Visual Basic Macro to select next avai.
Looking for RANK macro
Deleting empty rows and field names in report
FollowHyperlink -> how to close window
#if-then-#elseif-#endif
Help with code, Please
Macro assistance needed
Can we compute CDF value from a given std. normal?
option explicit error
Help with altering a SaveAs macro . . .
Importing data
I am seriously in trouble!!!
before print
password protection
Arguments of Excel functions
loops and if statements
Can't start macro via button click
Row or column number
Processing time to set values
Break a link to a data source
Referring to arrays and circularity produced by it
Can i use IsEmpty and IF this way? What's wrong here?
Inserting carriage returns or line feeds into data destined for MS Word.
Tab selecting a button with assigned macro
string manipulation
Search for a Specific Worksheet Macro or Function?
Checking Protect status
stop a program
Can i use IsEmpty and IF this way? What's wrong here?
Font Index Numbers
Saving with a filename already in a cell
VBA Code works by stepping through, not by running
Screen Resolution
add-in detection
Limiting text
I want to create a template like invoice template in excel.
Can i use IsEmpty and IF this way? What's wrong here?
open workbook - timeout function?
Search for a Specific Worksheet Macro or Function?
Rename .txt file with macro
Using Find method in Excel passing more than 1 parameter
Declaring a Range
Clean funtion
##Save to Unmapped Drive##
Get OLEObject with CSharp
Can i use IsEmpty and IF this way? What's wrong here?
Excel and Word
Macro to copy cell contents number of columns
Selection's first and last row
Can i use IsEmpty and IF this way? What's wrong here?
Text box selection
Place space in postal code
Verify names
Year and Month Question?
Problem with my Else statement
Create array function
Passing variable values from userforms
Vba excel - Combo box question - erasing value
Simplifying VBA code
Several sql queries with the same recordset
Year and Month Question?
How to design excel pivot
Dialog Box Query
Extract a given row from progressive worksheets
Title Page
add-in folder ambiguity
Excel VBA - TextBox Error
How can I add Excel worksheet functions? (Financial)
Calendar mod
How can I add Excel worksheet functions? (Financial)
Where can I see financial functions in VBA code?
Checking an array
Several sql queries with the same recordset
Cursor Position in VBE
Query from another sheet in same Workbook
Help needed guys!!!!, Excel macro
Run Macro when particular cell is changed?
Re: Run Macro when particular cell is changed?
UNICODE strings
Validation
Change cell colour according to conditions
Change cell colour according to conditions
Auto find a specific row and copy it to another worksheet
What's wrong with the code,pls hv a look
How to see code for general functions?
Editable listbox?
Is there any way to set the autofilter of a specified column to "non blank" when the workbook is started?
How can i open a folder or file
Paste range from one sheet to another
xlCellTypeSameFormatConditions
Re: Newbie question: How to iterate over combo boxes on a worksheet
text to date
Using named cells in relative references
Loop to change cell color based on found value?
Entry password to read/edit excel file
VBA: how do I return a row number?
Selecting a variable range
translate lotus 1-2-3 macro into excel macro using excel 2000
how do I convert a lotus macro into excel 2000
How do I set up an animation in Front Page?
Macro Paste Special Merged Cells
Copy on "GO"
Detecting when PowerPoint is done Excel 2002
insert rows
if statements vs date ranges
multiple toggle buttons
how to write visual basic macros
Multiple Monitor Work Stations on a Network
Ratio Calculation in a Pivot Table
USING AN .xla FILE TO STORE MACROS
Multipage Background Color
Use VBA to fill in formulas in Cells
How can i handle more than 65000 rows in excel
problems resetting backcolor in listbox
Last cell problem
Cont' Value and Text Property of Combobox
Two Different Diagonal Border Colors in the Same Cell
accessing worksheets
How to combine two SpecialCells CellTypes?
subtotal problem
Procedure to detect a running application and to register it.
Procedure to detect if an application is running
Drop down boxes in worksheet cells
VBA: how do I return a row number?
Simple Find Button added to Worksheet?
How to combine two SpecialCells CellTypes?
Formula that perfectly copies data from another cell (with color)?
Change Printers in VBA
How to combine two SpecialCells CellTypes?
colore cell based on condition
Counting in a userform
Trim
Active X Control Help
read sheetnames with ADO
Simple Find Button added to Worksheet?
msgbox if cell is locked
VBA: how do I return a row number?
Distribution Lists
VBA: Update worksheet when txtBox data changes.
Create stacked bar chart
document not saved
DLL will not run
Passing, Declaring, and Assigning Objects
Lookup Multiple Occurrence Of Item In Array
Total newbie question involving pasting someone else's Macro
Problem with macro to copy worksheet--odd behavior
msoFileDialogFilePicker Question
searching a spreadsheet
Using macro to save xls as txt without changing originial xls file
Using Macro to Save xls to txt without changing file format
vb with word - very urgent
Excel 5.0c VBA to Excel 7
VBA in Excel 5.0c to Excel 7
identify if a CalculatedField is positive or negative on VBA
Mail Routing
Outlook Automation
Copied Worksheet does not maintain it 's properties
disable warning messages?
Exporting columns in excel file to csv format
File Save Macro "End If" Problems . . .
VBA: Update worksheet when txtBox data changes.
Alternate startup file location
Grouping Print Jobs
UserForm value check
SENDKEY method
Creating a Combination or Permutation Array in Excel
Active cell is within a specific range
AUTOMATICALLY CHOOSE COLUMN H OR G DEPENDANT ON CONTENT IN COLUMN.
Passing null to a function
Scripting Excel different behavior than Interactive?
Visual Basic 5 or 6 Tutorial
How to call a VBA routine in an add-in from a VB app?
Processing XML files
Sending an Excel Spreadsheet to Eudora
How to retrieve the password for VBA code???
owner/author of a file
Sheet Exists in another file?
Finding a Range Name
CDate cannot coerce value of IsDate(true)?
FIND CURRENT DIRECTORY
microsoft acceslinks add-in
Excel opens without a visible worksheet
PrintOut macro from ?passed range.addrsess
Curssor Movement
"Hand" Symbol?
Populate a cell with TextBox info
VBA & XL2K: Working with objects/class modules
Re: printing sheets in different files
Visual Basic Toolbar Question
Problem with VBA Code?
xlDialogs - Sheet Name List
Delete Part of Cell?
Validation for dependant dropdowns
Delete Part of Cell?
Excel 2000 Visual Basic - Export Contents of ListBox into a worksh
Auto find a specific row and copy it to another worksheet
How to retrieve the password for VBA code???
Excel Worksheet Codenames 2
Weird range property behaviour
Type Statements and Memory Release
VBA: selecting sheets and copy them to a workbook
Delete Part of Cell?
Problem with listboxes
Problem
Delete Part of Cell?
Dialer wont start
How to attach function to a custom Menubar?
Excel macro -example
using names
Auto copy a raw from a worksheet to another.
How to attach function to a custom Menubar?
Userform update
How to attach function to a custom Menubar?
how to select cells dynamically in excel macro?
Include password in VBA code to open file problem
Function Wizard
pivotable excel2000 macro
How to attach function to a custom Menubar?
for next loop problems
Any help in manipulating text appreciated
Excel Programming
Excel Worksheet Codenames
Use VBA to fill in formulas in Cells
locking cells based on condition
How to Update filter criteria from list and storing the query to another worksheet
Is there a way to determinie the maximum row and column used?
cell inspection
Format the items in a combobox
UserForm text box Date formatting
Extract date from right to left in a cell
Add item to comboBox "form" from vba
how to keep formula un-changed when I chage to file folder?
Export into text file
Delete Rows
nested loops trouble
Help on Search
Re: ScrollBar is still activated when pressed > 2 times in a row
Change a buton "Caption" from VBA
OnUndo
Newbie: Multiple Cells Range
Option Commands (Option Explicit / Option Base etc) - Scope
highlight of a range
Can't get border on shape to deselect
subtotal problem
Re: WEEKNUM() Function
Code Assistance (Paste Special)
Include password in VBA code to open file problem
Trouble renaming Folders
Learning how to use 'Cells.Find()'
Ordinal Nummbers List
update access from excel - jamie collins are you ready for new adventure;-)
referencing a dynamic array
Naming Ranges
Linking lists in Excel 2000/2003
update access from excel
list box columns not transferring
list box columns not transferring
How do I Open A UserForm in a Worksheet
Pivot Table Programming
Label font formats inconsistant
list box columns not transferring
query from excel to access - xlodbc.xla
pivotable excel2000 macro
Re: website hosting
Question RE Count of records in AutoFilter
UserForm - ShowModal Error
How select all pictures in a worksheet and make visible?
protected code allowing save
A No Brain Question......This must be obviously Simple
Disable Close X Button On Excel Application
A No Brain Question......This must be obviously Simple
RE: This option(Trust access to visual basic project ) is not active .
How Protect chart source links but allow change font and colors etc?
#VALUE! when adding numbers
Passwords for Hidden Worksheets
How to transfer text from Excel to Word
Links cannot be updated
Re: Move file to a different folder
How to choose a sheet in a workbook with the old Excel XLM ?
combo box dropdown method
stuck with VLOOKUP
Copy module with code - amendment
how to reference worksheet as control source with space in name
deploying excel with a vb project
Deploying excel sheet with a VB project
clear intermediate window automatically
stuck with VLOOKUP
Catching VbMsgBoxResult
set date format of text box
Macro to Move Selected Cell to Top of Screen
Re: Concatenation
Erik -Deleting row cont.
Re: vlookup lookup different column
Does anyone have a template for using Excel as a simple Construct.
Re: Copy/Paste
Stop Warning Message?
Are there ways to clear the intermediate windows automatically?
Deleting a User Input Row
VBAProject references
Stop Warning Message?
Disabling Splashscreens and macros from external aps
Re: Application.OnTime driving me crazy
5 cells to 1
Re: USING AN .xla FILE TO STORE MACROS
Re: Application.OnTime driving me crazy
Macro to Move Selected Cell to Top of Screen
password on macros
How to turn a string into a formula?
WorksheetFunction.Sumproduct(syntax...
Re: Reading a VBA Array - Thanks
Re: ScrollBar is still activated when pressed > 2 times in a row
Re: Macro to Move Selected Cell to Top of Screen
pasting formulas into a selection
Please Tell Me What I Am Doing Wrong
copy charts & paste as picture, hide chart, size & place same picture as chart
Simple Macro IMO
Color Formatting
if statement with vlookup
open another workbook
change font colour if cell contains function - programmatically
Redim Preserve doesn't work
Search feature
Working with large group of numbers in a column
Calling Macro when using Select Case
If user says "No" to FileSaveAs Overwrite?
Assigning Range to Array
Advanced Filter Macro with InputBox use
Underline
Worksheet Activate Event
Find, Loop, Subtotal
Insert hyperlink
Find, Loop, Subtotal
Sumproduct operation in VBA array
Lookup Multiple Occurrence Of Item In Array
Enable a rectangular Shape
Formulas not calculating
update access from excel
converting to mixed case
Dynamically filling a static name (for querying an Excel range)
Lookup Multiple Occurrence Of Item In Array
Force 2 choices
Adding library references programmatically
converting to mixed case
offset and address?
Making "examp le" become "examp_le" in a string
Joining text
Lookup Multiple Occurrence Of Item In Array
Macro for Hiding Visible Worksheet
Macro to hide the current worksheet.
Query/formatting problem
VBS script to start Excel and load Add-ins
Dynamically filling a static name (for querying an Excel range)
Chg Absolute to Relative
Column Designation Conversion - alpha/numerical
Excel alternate startup file location
Specify Font Color
Custom Dates (VBA)
Excel application does not quit
User input in cell
6 cell copy macro
Need help revising print range selection
Excel 2003 vs Excel 97
Chart Title SuperScript
Adds Extra Condition
Exporting columns in excel file to csv format
Enable a rectangular Shape
Macro dies in the middle of execution
Problems with quotes
What is the intialized value for a cell with general format?
adding shortcut menu items
Test FTP Connection
If a Workbook is already open?
Default Response to a MsgBox
Ugly file import into Excel
Inexplicable difference in row hiding speed - identical code, identical machines!
Macro causes Excel to crash
adding shortcut menu items
referencing a dynamic array
Userform is "semi-locked"
Having a problem using a variable to add a 'name'
How to attach function to a custom Menubar?
Userform Label question
Having a problem using a variable to add a 'name'
VBA get lotus notes version number
Has my macro broken Excel?
Macro To insert missing data
counting by colour only if a cell contains a date???
Having a problem using a variable in
To declare or not to declare
floating toolbar
Run Time Error
Scroll Bars in TextBox on UserForm
Report
Drop Down List Selection... Then go to The Cell / Range
How to use a query rathen than advanced filter
Referencing dll in Excel
Dynamic Lists
ExcelTip/ExcelForum threading
Add apostrophe
Compile Errors and Missing references
External Variable Declaration
How to programmatically control "Vary colors by point"
Compile Errors and Missing references
External Variable Declaration
This seems weird to me
counting by colour only if a cell contains a date???
programming: 4 Millions Domains data with Category
Change event
External Variable Declaration
Can a workbook variable be set by clicking the workbook?
vlookup code and accumulate - sorry need help
Changing links via VBA
disable excell sheet cell from VB Script
how to paste 2 variables value in a cell
Always Change Input Text to Proper
Desperately seeking some help! (Please)
Macro to Go To a Certain Cell
Validate dates entered in excelsheet
Running a sub in a different workbook from a sub in this workbook?
Excel And Access Compatability
how to accumulate value and put in other sheet
loop through column to find value
How do I get an OLEObjects check box to call a function when click
Programming footer
Error comparing date win2003 Server
Excel in memory
Macro Assistance with Incrementing Formula
XLODBC #N/A Sum Queries do not connect
auto link update
Grab Last Name data within Title and Name
Sorting Algorithm required!
Working with hours and minutes. Help please!
Text and Formula in the Same Cell
clicking on an image
vlookup help
Automating the rest of this....
How to populate column with formula based on value in cell
displaying a dialog only over certain sheets
Macro Can Run, But I Cannot Edit
matching problem using VBA - 2
Advanced Filter Criteria Problem
macro to copy in Excel and paste in Word?
Value Property vs Text property
Re: Worksheet_Activate Not Called When Opening Workbook
Worksheet_Activate Not Called When Opening Workbook
Re: * How do we debug this? ...
Bolding text using a check box
Deleting rows if the total is 0
Worksheet_Calculate event problem
Total in a PivotTable PivotFields
msohelp.exe - Entry Point Not Found when using VBA help
Macro not working in Excel 2002
Ungrouping using vb
VBA Add Page breaks around tables
PDF Save As problem
Option Buttons
Reference mis-alignment
Problem with Excel 2003 and ole and vb
Increase / decrease decimal - retain cell formatting
Can a workbook variable be set by clicking the workbook?
vba - change column "type"
Saving file to a location determined by a cell
Saving file to a location determined by a cell
run the macros without opening or showing the excel sheet
Running a macro from the command line
Problems with vb in excel
I Need a Macro to Sort out a Large Database . . .
Moving Target...
Combo box property
macro creating a spreadsheet
Problems with vb in excel
with .net call to excel range.merge()
need to find a software version matrix utility
Conditional format formula
Range question
Closing a database from excel
Chalange: Creating recursive tree from Excel List
conditional statement to find more than one value ??
Looping and String Variable
How do i refer to the text typed in a combobox?
run the macros without opening or showing the excel sheet
Combine multiple books into one list
LOOKUP 2 values in array
VB way to remove the query from a Query Table?
Best structure to store a long list of strings?
A macro that can save a file?
Range question
Can a workbook variable be set by clicking the workbook?
Need Help on Spreadsheet Form!
Can a workbook variable be set by clicking the workbook?
feet and inches
Counting Variable Length of Rows in a Named Range
Counting Variable Length of Rows in a Named Range
User Form
locks up while pasting data from Access
Can a workbook variable be set by clicking the workbook?
"This file was created using a later version...."?
Increment in column field.
ADO Excel in ASP
Macro Date Testing
VBA tutorial
Retrieving value from function
Referncing objects in spreadsheet
Retaining value of a string from a textbox on a form ??
KeepITKool - Directory and File Size
Pasting within an Addin
Way to merge data in 3 cells?
Timed Operation
LOOKUP 2 values in array
Workbooks.Open incorrectly formating date column
Prob with Var Data-types..
Leave cell value untouched if Custom Function errors
Creating a summary from existing spreadsheet data ...
Minimise/Maximise Controls in Forms
userform Logos
Deleting rows preceding
variation of "delete all except"
Set cell background based on date.
Run-Time Error '1004'
Best way to get unique names
Set cell background based on date.
Excel VBA perfoming different in two computers same hardware configuration
macro to complete missing data
Autofill
Look and save
Stop to modify the SQL query manually entered into query !
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star
Selecting Sheets within a Macro
Calculate Interest owing from date
Counting Variable Length of Rows in a Named Range
excel spreadsheet function
Problem Saving Digital Certificate with workbook
cell in footer
VBA: Function Help... Search?/Match?/Vlookup?/
on double click change cell color
New Named Range Created Each Time Data Imported into Excel via Macro
automatic cell advancing
Exe file search and insertion?
Pivot table won't refresh after external data update on open
Special dates in EXCEL
Querying Excel with SQL
TRICKY: runtime generated comboboxes and change event
update underlying data
Exporting chart to GIF file
OnOpen event
How to run the macros automatically while opening the excle shhet
Changing a Parameter Of A Formula
Autofill
VBA: Function Help... Search?/Match?/Vlookup?/
Add In Installation
Update PivotTable Range with a button
Copy named range contents to activecell position
Creating a chart while writing to the file!!!
Saving file to a location determined by a cell
Creating a chart while data is being written to file!!!
Re: Saving file to a location determined by a cell
import data
TRICKY: runtime generated comboboxes and change event
Saving file to a location determined by a cell
Using substitute to replace text that varies
SelectionChange event
reading database value into a cell
TRICKY: runtime generated comboboxes and change event
To dear Tom Ogilvy, Ron de Bruin, Frank Kabel, Bob Phillips...and other experts
Opposite to "Application.SaveWorkspace"
Multiple Worksheets: Add:Print
Using C++ Dll library
Stopping a Looping Macro
converting a string to long
*
* How do we debug this? Bush to Cut DeficitCall() from $600b to $800b >> >> This way
Sorting Algorithm required!
a problem in generating a list of all of the possible combinations of those words
Compile Errors and Missing references
counting by colour only if a cell contains a date???
matching problem using VBA
VBA code that will be fired when another user updates links
Compile Errors and Missing references
Data Validation & ControlSource & Change event
Fecthing comment text
Automation : from Excel to VB ?
Validating excel entry...
programmatically fix no. of rows and columns
Programmatically validate text entries in Microsoft Excel
how to programmatically fix row and column
Trigger VBA routine if ceel content changes
Compile Errors and Missing references
Change Font using VBA
Time Table Problem
compile error - pls help
Need find cell b3 on another worksheet!
Paste problems!!!!!!
VBA Using 2 OS (Win98 & Winxp)
Add In Installation
Macro Assistance with Incrementing Formula
Using text boxes to find value, then do some action
Convert IP Address to Host Name
Opposite of Application.SaveWorkspace
VBA Using 2 OS (Win98 & Winxp)
Open and format new worksheet without selecting it?
protect command button
autofilter using string input
Using Excel to change/add/delete records in Access database
vlookup and search combine in vba.
Macro producing chart from variable length column
Swim team Lookup issues
deleting pictures
Displaying data from different upon request
AutoSum for variable number of cells
Switch between Languagges
Disable popup menu
Solver Macro quit working
Excel VBA perfoming different in two computers same hardware configuration
vlookup and search combine in vba.
variation of "delete all except"
Declare variable as what?
What's wrong with this code (r1c1 paste)
Newbie:
Print entire contents of multiple textboxes
Collection of case sensitive unique items
record macro - copy absolute, paste relative
Find changes and add them to the new sheet
Access Query Recordet conversion to an Array
HELP - Accidently Wiped Out CommandButtons
Auto Refresh Pivot Table
combo box will not save text typed
MyValue
Testing for chart in a worksheet
Finding byte info for files and folders
variable string and loops
Creating a production quality Excel add-in
Cell value in footer
combo box will not save text typed
Best structure to store a long list of strings?
Rearrange/Transpose Data
Determine which button was selected ??
Disable popup menu
blank cells
timestamp on each row...
User Form Question
FollowHyperlinks opening multiple browser windows
reference variables correctly?
combo box will not save text typed
How to open excel file from linux
vb Excel to PDF in Acrobat 6 - need help
searching a spreadsheet
Problem w/ open no extention file
user form properties not saving
How to Copy worksheet from one book to another in Classic ASP
Collection Object Keys
Extracting just middle text
Open Locked Columns to view code?
Deleting all rows that match a pattern
Excel.NET
Re: How do you say in VBE language to go to the last filled cell?
Retrieving a Collection Item
Deleting all rows that match a pattern
Copy Worksheet Formula Problem
reference variables correctly?
printing via vba
Copy data in column based on cell value
Wait opening file
Exporting Picture to Gif - VBA to VB.Net
Simple code crashes Excel
Deleting all rows that match a pattern
XLA will not load
Macro for making worksheets visible.
Fastest way to enter many formulas
Macro that will Pull Cells from Other Worksheets if not empty?
Save As FTP Settings
Writing a Macro that will Plus Cells
Creating a new function
Copy data in column based on cell value
If Statement to place .xls within .xls
No event fired on sort
email forms
How to get Cell value and use as file name in macro
printing via vba
Need help troubleshooting code which changes the color of a cell
"passing" variable trough routine
Excel 2002 Automate shared workbook at close to save changes to new document
Auto Refresh Pivot Table
Change Header Font Size
vba excel problem
Copy data in column based on cell value
Input Boxes
Diagonal Lines on UserForms?
Automate Hyperlinks
VBA Equivalent Match/Index functions
truncation problem
Excel VBA error
Selecting a Range
Fastest way to enter many formulas
Scheduling Hours
Losing selection and strange scrolling
Coupla questions
Fastest way to enter many formulas
Vba excel - converting Number to Date
Search and match condition
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October
VBA: Pull Record Into UserForm
Fastest way to enter many formulas