Excel Programming [Archive] - Page 67

Forms Buttons. Can you add a Comment to POPUP if the Mouse floats over it ?
Combobox List to Open when uderform is Activated ?
Help with an Excel Macro
Replace hardcoded cell reference
Show actual name of file path after you have renamed it
Re: delete row if text in cell
Re: Open workbook on close
Re: Increment number on command
Add values from a current cost column to a cost to date column at the push of a button
Copy and Paste cells using VB
Round to Nearest 25 Percent?
Get Month and Year ONLY from cell value
Referring to data series in a chart
Why Spreadsheet worksheet is not a worksheet?
Re: SpecialCells problem
Q: Creating a macro to sort and group columns in a sheet according to another sheet
Pivot Table Loop
Re: "Personal" Sheet
Textbox = Capital letters ?
Re: "Personal" Sheet
Re: "Personal" Sheet
Re: Trying to convert from Early to Late binding
Problem with reloading graphs! (References to Nameranges)
Select the same cell in sheets 2 & sheets 3
Daily "Tabs"
Using a Named Range to create routing slip in Excel
Re: Call one Macro after another
How to use spinbutton to recover data
Copy text with formatting from an Excel cell into an embedded Word object?
Format date macro
Re: Increment number on command
Multiple For Next Statement, Excel 2000 & 2003
move column data based on value of another column
Another head banging problem
Moving Rows (Basic VBA Stuff)
convert to values numbers as text
Input Box
Programmatically Access to Symbol Dropdown in Format Cells Dialog
Input Box question
Control size and location of Tables and Charts Linked to PPP from Excel
Help with paramarray
testing if there are named shapes on a sheet
Re: selecting a pivot table through VBA
Re: need help populating a totals sheet
stopping userform resize on minimize
File does not close
VBA Causing Excel To Crash
Change found text in special textfiles
Get Fun With This Click Counter
Visual basic linkup with Excel
if addin loaded on command line, it is not in addins collection
RE: Running a Userform from Excel
STOP MACRO IF CELL "A1" IS EMPTY OR SHEET DOESN´T EXIST
Re: Retrieving page number count from Word DOC
How do I have Excel VB write a open ended formula?
Programming a Forms scroll bar on Chart Sheet
Help with deleting all files inside of a folder from Excel?
User form closes after opening another one -- Problem with "Unload Me"?
need to build an Excel VBA database
Need help parsing column data - new to Excel
Need help with Criteria1
Bug ! Textbox on userform will not align text correctly ?
Comparing relative cells and making values dependent
worksheet change
Quick syntax question- bolding userform control text via VBA
Toolbar Help
Move/Scroll Specific Cell(Row) into the centre of the Screen ?
Creating a Profit and Loss Statement from Imported Data
Delete Row
Excel UserForm issues: Textboxes cannot be blank
Show actual font type as in the cell in a Combobox
Correct code to Exit Userform, with out Unloading data
Selecting control on userform with part of control name (set question)
Custom Mouse over Cell Event Help
Set new range based on rng.Offset(rng.Rows.Count, 0).Resize(1, 1)
Re: consolidating worksheets
Re: consolidating worksheets
Borders within a With/End With
How to insert a group of columns, each part of different ranges
Creating/Adding Combobox
Restrict from increaing numbers of rows and col in a spreadsheet
vlookup again
loop through tabs
Delete empty rows in list of data
Adding Combobox Values
Hide/unhide specific cells based on the dropdown list value
Add DropDown at Runtime Visual Studio Shared AddIn
Using vbYesNo in conjuction with Userform
Detect Hidden Columns by Formula
question on formula
Re: complex copy and paste
period solver to schedule lifts
Can you use a formula to fill cells with color?
Create a activecell from the listbox?
OutLook Task and Appointment
Run-Time Error '-536608719 (e0040031)': Whats the problem?
VBA reference to 3D range
can concatenated result extract an address ?
Re: Enable Auto Filters in protected sheet
Addin close command not working in new workbook
RE: Enable Auto Filters in protected sheet
Re: range on new sheet between dates
Allow a file to open on no more than 3 computers
RE: help from Gary''s Student
Re: AutoFit Columns in a new Worksheet
listbox
Run Time Error 1004
RE: Combo Box Dropdown Menu
Up Dating Cells From Userform
How does Excel evaluate embedded "IF" statements
Summarizing Large Reports
RE: Lock Cell if another cell contains data
TRACKING DATA
RE: Recording a macro for a Data Analysis add-in
Still stuck on finding the last occurence...thanks...
Re: help from Gary''s Student
Run-Time Error '-536608719 (e0040031)': What the hell?
search and expand feature: programming
Excel 2007 development problem
Heap Error when debbuging my Excel COM Addin
Command button to run a macro
Statistics Problem
How to code, AND where to place it !!
Excel column autofit
RE: Hyperlink help
How Might I "Mail Merge" Data For Multiple .txt File Output?
Re: Writing output to a textbox while VBA macro is running
Re: Cell formatting
Right Click
RE: help from Gary''s Student
Apply Names in Formula
RE: Run-time error '1004'
Macro to hide rows with a certain cell empty then set print area and print
before close runtime error 9
Re: On Error Goto 0
Macros between two seprate windows (excel)
Make only active sheet Volatile? Or other solutions?
mouse pointer in and out from commandbutton's area detection
Any way to compare VBA code in different workbooks?
Re: Copy a named range from an installed add-in while in anothter work
Re: Copy a named range from an installed add-in while in anothter work
Re: Cell formatting
can anyone tell me whats wrong with this line of code?
Re: uncheck checkboxes from a form
Re: Controlling tab order on a sheet to include AX combos
Re: Decimal problems
RE: Inserting Dates
Re: Decimal problems
Still having issues with adding a period to a ActiveCell.Value
VLookup Help
Navigate Sheets using In-Sheet Combo Boxes
Help with Checkboxes
Sort worksheet by the number of occurances
Re: Check for duplicates and move to another worksheet
Re: Conditional Formating on column matches
Re: Dynamically changing a file name
set the bottom propertie of a label
Inserting Dates
Can't edit cell
Re: Dynamically changing a file name
Find and Replace with Changing finds and replacements
Re: Filter only shortcuts and xl files
Re: Filter only shortcuts and xl files
What the heck is wrong here?
Re: Excel 2007 is saying macros are disabled, but they are not.
Removing double lines by macro in excel 97
Macro To Import Text File
Open - Output txt file creation
Re: Undo function after a VB macro in Excel 2003
What event to use?
Selection by color
Use named range to fill Userform combobox XL2003?
Selection by color
Query SQL Server from Excel
Re: copy a result
Re: delete based on date in input box
Need help 'cleaning up' a spreadsheet
Easy Sorting for Senior mgt
Display different charts
How to click and highlight cells and calculate the total amount in MS Excel?
Re: Creating character combinations out of a possible set...
How to Import the path of files (>100) in single folder to excel
Name a dynamic Range
Re: CreateObject - Namespace variable
Re: Check inputbox enter is in correct format
E-Mail from Excel at a Certain Specified Time
Copy Worksheets and create new Individual Excel Sheets
stop a macro
RE: How can I save a Range in Excel to a Word File?
Detecting row delete/insert
prompt user to save file as {desired_name} and save it to a variab
Re: Combo Box Dropdown Menu
Create Compeition Schedule
Need Help Formulating a spreadsheet
Re: How do I tell if user has closed Excel.
Re: Embedding Excel in a C# WinForm
Re: Code Locks Up Worksheet Briefly
Hmmm. Private Sub ComboBox6_DropButtonClick(). Should i have my code here ?
Modify Font from this code. Possible ?
Several worksheets in 1 file to different new files in one command
Re: Strikethrough Text to be identified with code
Re: Strikethrough Text to be identified with code
Re: trying to use print screen.
Re: trying to use print screen.
Re: Decimals problem
Re: CreateObject - Namespace variable
Pivot "row hide menu" keeps having items I don't have anymore!?!?
Range.Value fails
Detect Hidden Rows by Formula
Re: On Error Goto 0
Re: On Error Goto 0
Change Combobox list to list more than 1 cell.value
How to use variable in code
using automation in excel to create multiple charts
Automatically entering missing date into a list
Concatenate Macro
formula based on prefix
Emailed Excel file comes across as read-only
Add-in w/toolbar crashes on one of many company machines
setting current directory
Converting col number to alpha letter to use in a range...
Re: entering date dd/mmm/yyyy in VB gives mmm/dd/yyyy
Re: Run-time error '9'
Excel Recalculation problem with VBA function
How to check whether Cell has Validation?
Re: Running a Userform from Excel
Application.ScreenUpdating = False still causing screen to flash...
Re: Pivot Chart Changes Data Labels Formatting
Re: Can we make XY Scatter Chart using Pivot Tables
Re: Save As Code
Un-pivot
Re: Adding Cells in Different Sheets
Re: Fit Selection to Page
Code to include a one-up suffix to a field value
Re: Exporting only the workbook formatting
Re: Cannot sane all data and formats
Using Calculated Item to add dynamic columns in pivot table
find and add values in different worksheets
Re: Adding Cells in Different Sheets
Re: toolbar
Re: Determine which button was clicked on a sheet
Re: Adding Cells in Different Sheets
Re: Data Keeps Dissapearing
How do I display an Excel file?
Re: Excel 2002 SP3 and VBA
Re: is it possible to store formula under a UDF
set certain entire groupings of rows to print together
Re: Cannot sane all data and formats
Re: unhide multiple worksheets in one go
Re: unhide multiple worksheets in one go
Pivot Date criteria
Re: Beginner
Move down 1 cell after going to the end of my data.
Re: 2 Questions about the following code - Please help if you can.
Autofill using variables
Re: Beginner
Copy specific text from notepad into Excel
Excel 2007: How to solve *Cannot run the macro...*
Re: 2 Questions about the following code - Please help if you can.
Code needs your help
RE: Loop & Count
macro that automatically sends a fax from excel
Re: how to save the complete path of the file we open?
Re: how to save the complete path of the file we open?
Help with code please....
Combobox list to leave ONLY related values in list ??
Re: Using Instances of a Class
make signed over-punch conversion work in a macro
make signed over-punch conversion work in a macro
Re: Migration from Excel 2000 to 2003
How to select Acitive and Next Row
Put date stamp on file name using VBA
Need help with code debug please
Hooking up a Cryptographic Hash Function
communicating with another program via a network port
Re: how can I send automatically a fax from excel 2000 using faxtalk?
Re: Closing a Macro Early
Re: How do I use a macro to select a range?
intersect method error
RE: How to get NewLine in a cell?
how do I put my unprotected cells in order to answer they're mixed
Re: How to deactivate the external queries that are used to import dat
rng.Offset(-1, 6).value to work with CheckBox value
MS Excel 5.0 Dialog - What is this?
Re: Print to fit one page
Cell Refrences in Addin
Cell Refrences in Addin
xlUnlockedCells ClearContents Possible ?
Using If Then to check for a worksheet
Naming word tables or coding reference library with vba
Setting CONST referencing a cell Value
Re: Istalled Windows Version
VB and check boxes in Excel
Locked hidden cells
Extracting Data from the Web
Re: Use Range Name with 'Find'
Re: What's causing this?
Re: A hard one for manipulating arrays
Re: How do i write an offset code ?
Re: I need help making 'click' buttons for a survey.
Re: go to top of page
Automate an Excel Add-In Install
Consolidating spreadsheets
border non-contiguous rows
Re: Excel 2002 SP3 and VBA
Re: Print to fit one page
Code to Delete Range Names
Re: Create a collection of ranges
Re: Excel 2002 SP3 and VBA
Re: Excel 2002 SP3 and VBA
Re: Create a collection of ranges
If A cell Is null Do Nothing.
Hiding column if cell in previous column is empty-revised
Re: How do I change the shadow using a formula?
Question on determining "ROW" inside of a "For .. RANGE " loop
Detect for empty excel sheet
Insert chart into user form
adding code to command button in word from excel VBA
Paste, clear and ignore contents and... automatically!
Boxes in my addresses
require more than 7 nested IF statments
Re: A hard one for manipulating arrays
Re: Multiple Versions of the same file
Forms / Lookup
Re: Headers
Printer Driver / Video Settings?
Re: Paste
Re: Multiple Versions of the same file
Cut Duplicate Records based on criteria
Re: Worksheet_Calculation Issues
Hard Coding A Button Using "Buttons.Add(x1,x2,x3,x4)"
Re: Automatically Update Currency
Equivalent of Vlookup function programmatically
Re: Macro has stopped working!!!
trying to use xlToRight but having problems
UPPER case in a macro
Display column when previous column contains data
Combobox Help...
ctrl+break when modeless
VIP needed!
Change event
getting paste function to list all addin functions
Problem looping ChartObjects in a Com-dll
Adapting Excel 4 Macro Page Setup for multiple pages
Block keyboard input
How Can I write a function that calculate the time it take to coomplete all the loops
Convert text from clipboard and put in cells...
Cut and paste duplicate data
Auto Fill Color of a particular Cell if conditions are put
Deleting Personal xls
Re: Creating a .csv file that will import to multiple worksheets
How do I get Excel to jump to the next row using VB code?
A continuing search
Macro - Cut and paste a row if duplicate
Re: Downloading Worksheets
If statement question
How do i write an offset code ?
assign excel 2003 macro with parms to shape
RE: Downloading Worksheets
Changing Filename in VBA
InpurBox & Directory
Returning an array from a multi-dimensional array
Strange formatting behavior
Re: Inserting Dates in pre-existing data list
RE: Select All,Copy All and Paste Special Question
RE: Select All,Copy All and Paste Special Question
Slow Running Code to Hide Blank Rows
RE: Select All,Copy All and Paste Special Question
import only files with a certain extension
How do I get Excel to enter a cell and delete the last character typed?
Re: excel formula writing question
Re: Command Button Question
A bit of Syntax help please...
Re: Creating a help file
display multiple lines in pop up when workbook opens
Insert row after pagebreak
Display data in a combo box
Inserting Dates in pre-existing data list
Re: Combining Macros
Using a string to set an object reference?
Re: Combining Macros
Re: Open Workbook with Macros
Re: Need help with codes please
Combining a 3-Step Formula into One Formula
Re: Line Gradient in Excel 2007
Re: Creating a help file
Re: Need help with codes please
Regular Expression for cell address
Perform a task if result is a whole number
Re: userforms & workbooks
Re: userforms & workbooks
Importing External Data using a variable
Error when adding a reference to Analysis Toolpak
Build a userform on excel to copy contacts from outlook 2003
RE: Help with a sort please - Tom it worked like a charm thanks somuch
Problem with nesting an OR in a formula
Re: How to replace a tilde with the corresponding headword
Reset Spin Button
Hide Spin Button
Re: macro is creating a duplicate worksheet
Getting a value from a formatted row
Dynamic user form - VBA and Excel
using now() function not in a cell
Help with a sort please
Help - Using VBA with a validation dropdown list and a table to expand the entries
Re: Allow font colour changes in protected
Re: Cleaning Up
Re: Cleaning Up
Pause a macro for some time
RE: Allow font colour changes in protected
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ?
Check if a predefined number of workbooks exist in a specific directory
Check if a pre0defined number of workbooks exist in a specific directory
ShellExecute hangs Excel when opening XLS file
Run macro when adding a new line
digital signatures in Excel
Loop & Count
Class Modules
IF FUNCTION
IF FUNCTION
sequencial sort
text to columns trouble with "zeros"
Rename Several Defined Range Names with Macro
Delete the last Range Name
VBA Module Recovery?
front end form
fill cbox unique value
Excel hide caption bar...
PrintArea Query
Combobox value to be set as Target for referencing from. How ?
Possible to call a procedure inside a function?
Remove item from Tools menu
Excel 2007 is saying macros are disabled, but they are not.
Moving data from mutiple workbooks to one
File in Excel 2007 has encrypted macros. How to remove restrictio
Discontiguous Chart Source
RT Error 438
Looking to make simple formulas
Looking to make some simple formulas...
deleting shapes with VBA code
Trying to demo Code, but get error
easy udf by VB
Macro Problem
Easy question - Unselecting cells
Problem with "ThisWorkbook.Saved" property.
Extra Sheet, Workbook, and VBA code protection?
Use Outlook 2003 contacts in excel
Macro for copying data between sheets - Help needed.
Rename Protected Worksheets
two way vlookup
Printing
Insert row at start of each subtotal
Solver and VBA
Changing focus question
Autoopen of an Excel File at the set time
There must be a way!!!--set cells' values equal to calculated values in another range
Listbox question
Hide row if particular cells are empty
sorting custom
How do you solve this one ?
Code looping through files
Open external data (varying file names) and closing file once data is retrieved
Excel Connect to Accpac Dos
If A>0, I need a message pop-up box to show text in B1
Reference UDF within Worksheet Formula
Sheet Ranges Possible?
Move File to New Directory
Divide Value in Cell by worksheet count
Change colour of multiple shapes in a Chart???????? HELP!
Excel Spreadsheets to Access Database
Creating auto functioning worksheets
Cannot create forms?
Pattern Matching using LIKE ?
Adding a Value from one worksheet to another.
VBA basic question
Write 3d array to range
VBA question
worksheet change
Randomly selecting a cell weighted on percentage
Adding information to a Pivot Table
Create simple line graph in Excel!!!!!
Subs
How can I take away a xldatafield from my Pivot table in VBAexcel
Problem with short-cut key combination
C# Value2 intermittent exception
Request for help with EXCEL 2003
MicroSoft Office Development Tool Kit (SDK)
RE: Removing VBA Password
RE: Removing VBA Password
Re: Removing VBA Password
Re: Removing VBA Password
leave one blank row between data in *visible* rows
Change cell color
RE: Footer Font
VBA Problem Converting Numbers that are brought in as text
Cout CF in range that = blue
Transpose to Non-adjacent Cells
Skip code
If spelling of a word in a DV range changes, can values previously selected be updated?
SendKeys
HOW TO TRACK DATES OF A MONTH EXCEPT SUNDAY
Can't find project or library
Updating value in form text box based on combo box input
select cell with value
Org Chart: Can't add coworker object while recording macro?
Re: System Error &H80004005 (-2147467259). Unspecified error
Newcomers' Newsgroup Etiquette
checking for a numeric value in a textbox
Type of variables and their effect on result...
Re: Syntax to Find User's File in MultiUser App
Create & Name new Sheets without duplicates
DSUM - Modifying the function...
Bubble Charts in C++ Automation
Re: Activating Workbook
Custom Toolbar Below Other TBs
RE: Recognizing cell change in a Sub Worksheet_Change procedure
Re: Recognizing cell change in a Sub Worksheet_Change procedure
RE: Recognizing cell change in a Sub Worksheet_Change procedure
Re: Activating Workbook
Re: Pulling Part of a String
Re: how can I create a save file hyperlink or macro in a workbook?
Prevent Editing of Worksheets w/in SpreadsheetML
Re: Pulling Part of a String
Re: UserForms -- Subscript out of range error
Pivot Table Error
Hiding subtotal groups
Re: excel question?
Re: Pls advice if there is a bug in my vbe ?
Possible to automate conversion of text files to Excel?
Posting text from VBA to spreadsheet Web Browser
Re: wrap text
Re: wrap text
Re: Can we run Windows Script file from Excel/Office Application
VBA compiled - affects conditional compile?
Randomize tab colors when new sheets are added, and link color to formatting
Create an Array to fill a Range
excel question?
FAX with Excel VBA
RE: Multiple Userforms Upon Click
Excel size increase through charts
Problem solver call from vb6
Run a macro when changing the sheet
RE: CommandButton Caption Anomily
RE: Can we run Windows Script file from Excel/Office Application
Function Int
ActiveCell.FormulaR1C1 = "=IF(c4:c4<='Title Page'!$B$19,1,0)" ?? HELP!!!
Code stops for no apparent reason
Controlling Hidden Rows / Columns in Filtered List
Problem with ATPVBAEN.XLA
Copying Cells
Showing rows containing text
Hi ...read text file and copy it in a specific cell
Hi ...read test file and copy it in a cell
Modify code to reference from a Matching value in Combobox1
VBA coding to copy sheets into a new workbook
Combobox Properties (Text Wrap and Center from Top to Bottom) How?
macro help please
Macro Help
Re: can i from excel create mail merge with calendar invitations ?
Totaling (Subtotaling) a Changing Filtered Range
RE: cell.offset when starting cell is merged
Custom face for custom toolbar item
RE: cell.offset when starting cell is merged
Re: Worksheet Change Error
Number of links?
RE: SP UDF for EXCEL
Non Static Variables in a For...Next Loop
Re: Show Milliseconds
Conditional automatic entry from a list using VBA
Re: exit from excel?
macro for pivot table
Re: personal xls for UDF
Re: Need some code for header/ footer, another case of "last saved
Excel Chart displays incorrect X-Axis
Accessing Mapquest info from Excel
Re: Help Rearrange Data
Re: Show Milliseconds
Re: Need Automation Help fast
Re: Need Automation Help fast
Create an attractive "link" button
Re: any more criteria condition for mySP UDF, if possible
How to run an After Save event?
Re: more factors needed for an SP UDF
RE: How do I do this
Re: clearing a user-defined Type variable
protect sheet question
Filling both hidden and visible cells once a filter has been applied
FTP via VBA
Re: excel question?
Data table automation problem
repeat macro for added items
Automatically add/show/hide rows that have (or have no) data?
Help: sort data and move to a new sheet
It takes two clicks to shut down Excel
Hash (#) at start of line in VBA
Stand alone VBA script files
Run macro on refresh data (pivot table)
Merging Spreadsheet and matching data...
Move cells to another column based on value of cell
Importing all files in a folder to excel workbook
pls help ammend progress bar code
Export sheet > store sheet > import sheet.
How to reference to an other excell book to get the value
RE: Check Box Question
Copying rows to another sheet when certain value equals
Re: Check Box Question
Change row height
C# COM Add-In: Form doesn't appear after closing n reoping it 3 times
RE: Problem with too large a range
UDF for Excel in C# paramters not coming through
Re: Lists and Look ups
Formatting numerals and text numbers between Arabic and Hindi (indic) languages
Unexpected CommandButton Caption Display on Exit
Pass the variable into the sub function
How to check drive exist or not using FileSystemObject
e-Mail File out of Excel 2003 Macro
Look up Function
RE: what's the problem with this ?
RE: what's the problem with this ?
RE: what's the problem with this ?
Combobox List to list Numerical Values ONLY in Column A is specific Sheet....
Pivot Cache
"LegalWorkSheetName" Function?
Help with a Dynamic range
Cancel 'Password' prompt during VBA
Formatting Text to Italic AND Underlined to individually listed cells
print PDF file from Excel - NOT print Excel to PDF?
moving between windows
Help writing macro for a lookup table
Excel solver in vb6.3
Re: Highlight Cell
Using VB Code to update one workbook with data from 4 diffferent workbooks.
Re: Activate WorkBook
RE: Highlight Cell
A macro that will show a cell's contents but not allow it to print
Re: Highlight Cell
Combining Files
Find Replace List of Items
Simultaneous rst.AddNew and rst.Delete from 2 Workbooks
Re: Activate WorkBook
Re: Delete workbook..?
Macro Only works Once
Centering a worksheet for viewing
Re: help for myWORKDAY UDF
non disruptable run time condition
Re: Rank Code
Changing pivot chart format
Re: custom commandbarPopup control - how to return its identifer?
Re: Delete workbook..?
Macro to delete first and last row
Re: Problem with too large a range
Re: any UDF for sum or rounded product
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look
Passing excel cell values as sql variables
Need help with adding Controls and event handlers at runtime
Need help with adding Controls and event handlers at runtime
Re: Automatic Dates
Re: Automatic Dates
complex time formula
Help with a simple Excel macro
Counting recurring cells
Re: Option Button forces user to input into a Textbox
Re: Hide all windows while macro is running
Re: Save into different "user's" folder
Re: Hide all windows while macro is running
Re: How do i assign the ActiveWorkbook.Worksheets to a worksheets object?
RE: providing serial numbers with cells hidden
Re: providing serial numbers with cells hidden
Display value in same row of most recent date in a different column
Create a command button in Excel using C#
Formula in text formatted cell
Re: Save into different "user's" folder
Macro to save data in one cell and add new data in cell below etc
Re: To go to a particular Sheet
display alert when workbook open
SaveCopyAs generating the 0x800a03ec exception
Creating backup of a data file
Loadpicture - check if file exists
can i copy a hyperlink with absolute and relative references
how to trap cell cut and paste
how to trap cell cut and paste
RE: Open Read Only
Re: Use of Calendar in both a form and excel sheet
Protection to add a line to Remove "Select Locked Cells" ???
Userform Canellation.
General Ledger template from Microsoft website - adding GL categor
Macro to open the Subtotal function
bug in excel range naming?
How to Add 21 Textbox values to give the Sum ?
open (or save to) other workbooks
Cannot jump to 'VBProject because it is in the library 'VBIDE' which is not currently referenced
RE: Open Read Only
Redirecting
How to tab to next from a texbox
Advanced math
help with a special timer
RE: I think this is a hard one
RE: How do I add sound alerts to Excel spreadsheets?
play wave file from Excel 2003 macro
RE: how to use .xla -- addin file -- Office 2003?
userform Max value in Column A
are these 2 statements equivalent?
One problem
How to check if a cell is blank and, if so, apply a formula
Center Comment Over Selected Cell
Re: Can any controls name concatenated?
Opening workbook in its own program
How to detect when Find returns nothing?
Selecting a Record and copying it to another Workbook
Help!
Help!
duplicating a page while adding a progressive date
Listbox value help needed
SAVE AS... WITHOUT COPYING THISWORKBOOK MACRO´S
Problems With PRN File
Counting Cells By Color
RE: Mutipage
Removing columns and rows from an imported worksheet
Re: Mutipage
RE: Macro help with copy/insert into mutiple workbooks
Excel and Barcodefont distribution
Query text too long
URL forwarding in Excel?
Resetting an object counter
pivot cash
Copy rows to new sheet based on variable cell reference
Using Checkboxes
sayfa korumasÄ± ÅŸifre soruyor ben ÅŸifreyi bilmiyorum
How to refer to an other worksheet (or book)
is this possible, replacing password protected sheet text with mac
Hidden macro
UDF function on Matrix
Create a 5 second message box that shows text in a cell
Macro help with copy and insert
running a macro on another worksheet
Zoom Window Selection Possible?
User Forms availabilty to all workbooks
Creating the name of a worksheet in a cell
macro doesn't work on Excel for the mac but works on Windows XL??
Programming a worksheet to find last row and add formula's
Re: Setting Path for Word AND Excel
How do I call a dynamically created String in a VBA Sub
How to store variables of a single cell in a column?
Render the contents of a cell invisible
Passing a function as a parameter
Odd copy and paste question
Excel Window
RE: How to set the format of cells after importing into Excel
using range, and/or offset to complete table.
Create a date that will not change
Spacebar Exits Macro
Run Macro from cell change THEN select adjacent cell
XLCALL.H problem with C++
Distorted Fonts on Controls
Preventing Range Name changes
Placin Data In Next Avaialble Cell
Combobox and Textbox settings
Getting info from FIND/REPLACE
Force Path for File Saving
Object creation
Hashing function CryptAcquireContext Lib "advapi32" not working in new computer.
Ex Rate
Comment Positions
Test Initialization of an Array
Re: Convert String variable to code
read data in an excel file on a remote sever
Going nuts on this one...
Re: Writing macros to sequentially change the address of a cell in
Re: Writing macros to sequentially change the address of a cell in
Re: Writing macros to sequentially change the address of a cell in
Application.InputBox
Parsing Strings in Excel
Re: userform to appear in the center of the screen
Re: Writing macros to sequentially change the address of a cell in Exc
inserting a formula next to populated cells
Sub that cannot be executed from Excel
Running code before saving workbook
Excel concatenate duplicate rows
Updating a sum
data from password protected files
How can I execute a macro right after the user clicks the validation drop down?
Assign borders and colors with a condition
Re: Wait Seconds and Tenths
VBA code for outline border
Re: Delete Duplicate rows
Re: Hours Minutes and Seconds
Re: Complex--don't even know how to word the subject for this
Re: Complex--don't even know how to word the subject for this
Re: Wait Seconds and Tenths
VBA to -0- an amount during a Copy/Paste of a range of cells
Loop through Row Range, Excel 2000, 2003
Finding Cell Address from Listbox
RE: userform to appear in the center of the screen
Downloading Multiple Pages of Get External Data from Yahoo
this code makes excel crash
Easy (for you) question
Rounding a Rounded Number
How to use an array ?
Run Macro in another workbook already OPENED in another instance of Excel
Excel Object Model Diagram?
Yet More Question about Newsreader
RE: Formula to count distinct values not working in VBA
Re: Delete Duplicate rows
Selecting Drawing Object By Name
Re: Function Question
RE: Function Question
running macros from LIST choices
save workbook but doesn't really save
Clear all borders with VBA
Copy/Paste Range
cusotm formats
RE: I dont understand why this happens
Quick Question: Buttons
Control Toolbox Checkbox Macro - Help Please!
Find First Row where "value" = ""
Excel: Compare Two Worksheets
Excel: Compare Two Worksheets
Excel: Compare Two Worksheets
Re: What could be wrong?
Set Focus Not working on a form
Re: What could be wrong?
God's New Year present.
Select Cell on Same Row as Checkbox
variant/error Error 2023
Re: error handling - dodgy syntax
Re: Claiming Dependents
Re: Claiming Dependents
Loop through a range, allow user input during...
Re: Continuous Loop
Looping Error
Re: Make 2 Macros Work as 1
Unchecking all Forms checkboxes in entire sheet
please help me
next cell
Re: Active Conditions
Petty Cash book
Excel 2007 Problems; in writing macro and convert text to colums
Retrieve a the date created date of an Access Table in Excel using VBA
closing dummy file
Offset function
Trying to improve the performance of my code
modeless userform problem
Basic Syntax
Re: Multiple responses from a look up table
Re: Multiple responses from a look up table
Count the times a file is opened
Reference cell in previous worksheet to then add +1 for serial pag
Same footer for worksheets (grouped)
Re: Adding Images
Re: How do you create an Array of Arrays?
How to pass text to web page ?
Re: Adding Images
Re: UseFunction question
More Concise Way To Assign Borders?
Error Checking Code, Excel 2000 & 2003
Don't Copy If Null --> Help
Setting the text in a cell to the text of a cell on a different sheet in the same workbook
Re: How Do I Password Hide a Sheet
RE: Named Range Macro Formula
Pivot SubTotals - Request help
Re: Named Range Macro Formula
Re: How Do I Password Hide a Sheet
Sorting a range on another worksheet without selecting the worksheet
Check if a optionbutton is selected
Auto Log Into Site, etc......
Create list of worksheets and cell values
(VBA Function ?) Lookup value and copy it into antoher worksheet
Comparing two worksheets
Can't select image on a worksheet that was inserted by c#???
Wanted: Syntax for Filename changed without impacting Macro
Re: Can't add macros to buttons I've created....
Re: Why are some dates changing and not others?
Re: How do you create an Array of Arrays?
Re: copy and paste to multiple cell
Re: If / Else Code (hiding rows based on cell value)
Hide Columns based on network username
AURO SUMMING FROM TABLE AND COPYING TO NEW WORKSHEET
One subroutine to run another
Needs help converting some pseudo code into VB code
Counting Groups
Re: GetSaveAsFilename
Delete Rows
Extract Part of Sentence for Separate Cell's Value
Re: Fill FromDate to ToDate
Re: program tab button
Re: Use string as cell location, need help
#1 How to best learn VBA? #2 Division problem question
returning the first name on the list assigned to a particular rang
Save as space delimited file from VBA
Re: TextBox Values to Outlook
Chart series delete all then add new
English German CSV issue
Cell References and Ranges
Re: Data Validation
How to using VBA to send/get data in logined web page ?
worksheet_calculation problem
sum with multi criteria
How to block all macro when a particular file is open
Excel macro to calc payment/payoff of credit card
Open Outlook from a macro
display worksheet on form
Flexibility assign Cell value
multiple criteria statement
Re: slow code
Re: Linked cell location in VBA
Automatic sorting in excel
RE: Insert new row and retain borders
Text in TextBox to Program
How to Hide Toolbar
Re: Find next Date
Chart not working
How to delete a question mark throughout database
Delete part of cell contents
Re: How to extract a value from Excel and include it in a query
Re: Multi Column Listbox Help
Delete Row Macro
Test
help with chart
Paste Special
Help with automating data style change
How to keep macros attached when moving sheet to a new workbook
copy values in rows to columns
Dynamically generating a spreadsheet with custom pivot table including data
Newsgroup Reader Advice
Re: PLEASE help Bernie are you still available?
Figuring out if a day is a legal holiday
Sort 4 of columns by matching cells
"find" finesse needed
Worksheet change event with cell linked to combo box result
DSO Summary Properties Error
XL 2003: Problem running Solver from VBA
Re: Colour Cells onSheet
Re: Input Box
Re: Row Height
Emailing range in Outlook- so close! just need a little help
Re: Filter Macro
Desperate for help with these formats
Re: PLEASE help - Fast approaching deadline
Cell Formatting
Re: Variable Range for Sum Formula
Re: Save Workbook as another file without an fomulas inside
variable sheet names not working
Re-setting HPageBreak
Removing all data from two columns
Help with If,then statement Returning Value (or Select Case)
Speed this up for me, please
Data Split and sort problem
Force macro to wait with next step
Re: Find last row and column in a selected range
File Size Problem
Re: PLEASE help - Fast approaching deadline
Cocatenating two variables with a space in between
Basic VBA Question
Date Format Macro Problem
VBA & Conditional Formatting >3 conditions
Time formats
Delimiter for csv and text file using ADO
Re: For Next Loop Chart Titles
How to disable column autosizing in Excel 2007
RE: Worksheetfunction Substitute
Re: Worksheetfunction Substitute
fourty different spreadsheets with the same macros
Excel saving as textfile quotes issue
Remove All Macros
Registry Location for References in VBe
change code
Big Problem using VLOOKUP formula
Help with looping macro / goto
Listbox In VBA Growing
Listbox In VBA Growing
Problem with Range reference - Odd error
How to use drop down lists in Worksheets using VBA
Add a button to each row of a spreadsheet
Combobox Properties Textcolumn
Concatenate anyone?
Disable menu item when a particular excel file is opened
How to debug class ?
Macro to delete specific rows
Excel VBA, XMTHTTP & Cookies
Corrupted Excel File
Re: How to solve 70-point gas network problems using solver tool?
How to fatch Range's from an excel sheet when the file is on netwo
Maximum Controls on UserForms
Macro to add "
Re: how do i use UserForm1.Show vbModeless command?
Re: Can't find project or library
Re: User-Defined Type
rows for visible cells
Re: get actual date from variable text string
Last Row in Disjoint Range
Data Sort Macro for specific cells
How can I insert excel sheet in to powerpoint slides with autupdate option?
Re: show modal
Re: adding code from a template
Saving txt file from excel by specifying path - drop down directory explorer
Re: change permission on a folder like cacls command
Re: Formula Macro
RE: Two excel version conflict?
Re: Formula Macro
Find and Replace Macro