Excel Programming [Archive] - Page 68

CreateDocumentFromUrl
Re: Formula Macro
select case statement?
Creating Chart Dynamically (It is Driving Me Nuts)
Write data to Access table with INSERT when table has auto number
Automating copy-pasting of data values into a new spreadsheet layo
Setting Cell Values from VBA
how do I prompt the user to select a cell?
Re: Finding lowest number depending on value from corresponding cell
Paste validation, Copy, Paste Special Validation
Re: msoFileDialogSaveAs
Macro that sums cells in rows of varible number and....
Excel Re-Starts after shut-down
Help file problem
Re: If statements
Copy thru VBA
Macro that deletes the last character in a cell
List of values / unique problem
PIA interop Excel - VB.net accessing Cell
Re: Row Number with Text
Re: Name of button
Error message if duplicate data entered
Button do not appear on Sheet !
Sorting Help
Intermittent Error - Method 'Add' of object 'HPageBreaks' failed
Re: Pivot Table Question
SQL Query Function
Format of amount in label
Copy Total to the following row in Column A
Excel to e-mail, with a twist
Values in Columns to convert in rows
Excel with game is stuck in a loop
Re: Find the closest value
Running Two Macros as One
Re: Data Upload from Excel to SQL Server
Re: I'm dying over here...excel
Find First empty cell at end of Column A
Error Trap Via Message
Re: I'm dying over here...excel
Pivot Table Question: SubTotals for 2 of 4 Pivot Tables in same worksheet
Re: Dynamic Chart Building - "Unable to set the ... property of the Se
How to intersect two coloumns in a third coloumns
Tracking Changes to Cells?
How do I bring up the select cells dialog ?
Changing file name
Replace VBA Reference for Type Library
Re: Call a VBA module from Microsoft Access
Re: Question about RANGE (easy one, or at least it should be)
Re: Question about RANGE (easy one, or at least it should be)
Copy data from one file sheet into another
Re: get actual date from variable text string
Locale issue
Re: Never-ending For Next Loop
Switching from Jan-1 yields 1/1/2006, should be 2007
Help in syntax
For Each array - TextBoxes in a UserForm
Hide Sheets
delimiter
Query
Question about a formula
Series XValues, determine if labels or values
arrays from Excel VBA
Run-Time Chart Only Displays Even DataLabels
Using VBA to open an excel file
RE: Multiple print title rows
Re: Copy - Paste Special (Values)
Delete sheets - all except 3
Detecting the workbook name on startup
unique range
Selecting Values in Worksheet
average rate of change per given time period between 2 moments in time of a value
Conditional Format
Check File name for its existance in a folder
User Forms
RE: Can't find project or library
Re: Calculate number of records in a Group
Is this a joke or Microsoft screws up again?
how to disable chart tab in Excel?
how to disable chart tab in Excel?
Referencing a Column with a Variable name
RE: Add Delete Hpagebreak Macro
Editing in formula
Lookup Sheet
using data validation list for dropdowns
Can VBA save file after deleting all VB code?
RE: Macro to Pull Data from Seperate Workbooks
Re: drop down cell link to worksheet not working
Re: drop down cell link to worksheet not working
RE: Macro to Pull Data from Seperate Workbooks
RE: User-Defined Type
printing an external document
selecting multiple ActiveCell items (possibly loop problem)
Continuing problem populating userform from a previous record
Re: help with code
Office COM Add-in by Using Visual C#
Compare cells and concatenate on match
Autofilter / CF
Re: The undo button is greyed out due to this formula
Re: ActiveCell.FormulaR1C1 referencing a moving target.
Re: need macro to call a workbook w/o the actual name of the workbook
Lookup on a sheet so that every time when file open it copes data from another file sheet
Re: MS-DOS commands from within Visual Basic Version 6.3
Re: Sheet referencing in a macro
Re: Sheet referencing in a macro
Re: send range results to a certian cell
Macro help
Re: removing programs
Re: removing programs
Re: Excel 2007: Macros disabled when workbook is protected (why?)
Conditional formatting of a range of cells?
VBA Copy Info from Excel Sheet Displayed in IE
A Substitute for Vlookup
Autosaving an Excel Workbooks as versions
Move Total from Column B to A
Concatenate Variables
Help! Selecting a Worksheet with VBA
Automatic Exchange Rates
Excel graph (newbie)
Location of mscal.ocx
Pivot Table: Optional Page Field
Web Query a changing URL
Reference Table
VBA to Save Web Pages
COMBOBOXES
Store TextBox entry into Variable
Interpolation Problem
Re: Converting currency to text "One & 00/100 Dollars"
Re: Converting currency to text "One & 00/100 Dollars"
Using Vlookup worksheet function in VBA
Unique Data ID tags help (average)
Detecting Broken links
Re: calling subs
Coding if formuals
Help with Arrays - making a total formula
Basic VBA Question
Re: rounding to nearest 1000
Delete Sheets Problem
Delete Cell Contents IF
How to make Excel the active application
Copy specific data over to other worksheet
WORKDAY #NAME? Problem - tried the toolpack already
Charts and EMF
Save as problem
Operators/if etc
Combobox Dropdown method
Date format Problem Macro
validate
Password on VBA Code
Unique
Last digit automatically changes to zero (0)
VBA code in Excel
About function BAHTTEX
runout - plant production scheduling tank inventory
runout - plant production scheduling tank inventory
on error don't resume next?
Big sort problem
A1 reference style
Difficult find and move
How to check Excel worksheet contents before routing?
Can I create a userform in Excel to create an appointment in Outlo
set up a flashing background
PT dimension renamed after AS2005 migration
Password
Linking Excel-areas to word-documents
Nested Loop
paste excel text into a comment box
Selecting multiple ranges
If A1=H Then B1=1, Excel 2000 & 2003
Sheet selection
Can I use standard Functions with MS Query?
Rename Sheet Goofyness
While/Do Loop problem
Creating a worksheet for every weekday
Breaking up long line of code doesn't work
Getting and setting all printer driver features supported using VBA
converting from gedcom to excel
Class module and a lot of records
How to list objects defined - buttons, etc.?
Where can I find Microsoft.Office.Interop.Excel.dll?
Create Add-in
Chart macro okay but sometimes ends by moving to a new location?
Connect Pivot Table to WSDL web service source?
Code ignoring filtered (visible) tasks.
2007: weird position of labels on 3D bar charts
Fill Colour
collection and limit
XP control look ?
Problem with filtering
Code for auto league tables!
Trigger a Macro
Re: send range results to a certian cell
Re: Loop vertically, copying and pasting inputs for each cell in Col A
How to Use Relative Reference in Array Formula
Return filtered tasks
How not to show zero in textboxes?
Re: Code to instruct "Insert new disk"
Code question
Change Event not firing
SendKeys "(^ {HOME})"
Inserting 3 new rows after the word total
auto-open macro lost within workbook
auto-open macro lost within workbook
Problem accessing an Excel file from ADO
Extracting part of the data from a single Excel cell
Help with variables
RE: Monthly Report
How to select a single "column" of a VBA array?
Printing form with .printform leaves out headline (caption) on pri
Holding Shift to bypass Auto_Open doesn't work in Excel 2007...
webpage tabs
Is it possible to exit Excel completely from a macro?
Re: How do I print batch run to pdf files?
Opening another instance of Excel
Does Office 2007 have VBA?
Substitute for Vlookup
Sort Column, Excel 2000 & 2003
Re: equaision displaying phantom numbers
Dimmed Keyword as Variable
Re: Delete all Shapes from selected Range
select based on 2 columns?
Pivot Table: Totals for "Last 12 months" and "Preceding 12 months"
Re: Problems with Application.FileSearch
Concatenate Text in Visual Basic
Re: Chart Labeler Macro
Letter alternative to 1 - 26
Autofilters and Userforms
Moving rows with out removing from range
Using filename hyperlinks in Macros
Re: Macro Problem
Adding spaces into a variable
Concatenate Text in Visual Basic
Re: Create Function using Excel VBA
Macro to find odd due dates and move them
Macro to go to last cell in a column
Re: OleObject really embedded in cell - not as shape overlay
Check if Date within this week/last week
Find Blank Line
SQL database
Call user defined function in an add-in
Excel 03 Macro/Code
Re: Troble with Code
RE: Troble with Code
Creating and using add-ins
Trouble with Code, but only sometimes
Alternative to integer?
VBA Syntax to :select" or activate a module in Project Explorer
Formatted output to text file
Range Definition
How can I get the row number Based on cell value
copy no match
'Save as' problem
Chart Code
Re: Window Class of UserForm controls
Is there any way to speed this up?
Rename selected (highlighted) sheet with cell contents of sheets in cell A1
RE: Find & Replace macro limit?
Compare 2 list and extract continous range
Can i Bunch a Many Macros & put them into a Single File
Lookup Multiple Values in Same Range
Paste filenames into cells
converting matlab scripts to VB to run in excel
Drop-down list dependant on another cell value
assign shortcut to macro
Re: Create pivot table with VB
Clearing cell contents
reading tags from an mp4 file into excel sheet
Insert Data Last Row Loop through cells Excel 2000 & 2003
How to have data ordered via Data validation
Next without for??
Delete all Macros Error
RE: What Does FormulaR1C1 Do?
Re: What Does FormulaR1C1 Do?
if selection from drop down menu = X, then...
RE: Selecting Activecell in hidden sheet
Chart code
RE: Subscript out of Range Error
contar.se
RE: Subscript out of Range Error
Help speeding up my code
Re: What Does FormulaR1C1 Do?
How to detect selected cells in Excel, in VSTO
FAX from VBA
any function to replace loop
Delete cells where value is 0
Re: Adding working days
Re: vba macro to cut and shift text>65 char
Save only one sheet from workbook
Re: problem with spreadsheet number format loaded from array
Re: public property in one workbook, want to set value from another
Re: Selecting Activecell in hidden sheet
VBA UDF Calculation (not)
Re: Please Help.....................
Re: Please Help.....................
Re: Inserting formula
RE: Inserting formula
vba arrays, count blank cells
Merged cell auto row height revisited
VBA Code and Protection Sheet
Newbie Web Query and Date Formatting + Error Handling
Re: copy and paste values in a range
Re: copy and paste values in a range
Error Handling doesn't work!
Re: load 2 dimensional array into excel sheet
Re: load 2 dimensional array into excel sheet
Re: Window Class of UserForm controls
Excel VB: Problem Clicking Submit In Online Form
Re: Expected End With..
Re: New workbook / 3 sheets
Help with using arrays or just help in general!!!!
Re: Expected End With..
Re: Expected End With..
Re: Expected End With..
Convert Weekly Forecast to Montly
Not recognising value
Re: Auto Row Height in Merged Cells with pre exisiting text
Re: Converting all numbers to negative
Re: How can this code be made more efficient?
Difference between VB and VBA?
Re: How can this code be made more efficient?
Re: How can this code be made more efficient?
Formatting help
code error
Suppressing the Disable/Enable Macros Message Box Programmatically
xlBook.SaveAs (documentName) when file open by another process
Re: Paste filenames into cells
Range text alignment
Run a macro continuously
Using a variable in more than one sub procedure
Re: For Next help
HOW CAN I CONVERT NUMBER IN WORD USING VB6
Error on opening more than one workbook containing the same code
Help with for/next statements
Filtering problem
creating a new collection
Automatic type conversion prblm when populating Excel sheet from C
Delete row if formula brings back an error
Re: Find & Replace macro limit?
Re: Help , reading an Excel value from the C program
Re: Excel Worksheets Menu bar
Re: Userform: Showing Cell Data
Are Excel Shim Dll's have COM support
Extracting data from web page with an imbedded DB query
Worksheets("Sheet1") for foreign languages
RE: Copy Sheet Names to a Column
hide columns by column number
quick question
Best Excel VBA book?
Deleting Charts
Limit characters
ip addres
Cell Select Excel 2000 & 2003
Re: Code for Unicode
Excel Formula using relative position of cells in two different worksheets
Program too large
Trigger an Excel VBA event from another application
RE: Macro to copy selected data
Copying workbook with VBA
Code runs slooooww
RE: ScreenUpdating = False not working
Microsoft Query Help
Using Relative Reference Function to apply to Range
Forms
Re: Unhide Picture Using msoFalse
Re: ScreenUpdating = False not working
Re: Oval-print location
Re: Locating 1st blank cell in named range
Re: Locating 1st blank cell in named range
RE: Locating 1st blank cell in named range
Using Multiple Variables in an Array with Booleans
Userform to have Last Updated Values Time & Date Displayed ??
Locking certain cells..
Re: Is there a way to know when a user has selected the find funct
Re: Auto Response to Dialog Box
Re: Locating 1st blank cell in named range
Workbook reopens after close
Re: Auto Response to Dialog Box
Inputbox Location on Screen. Can you code it to popup lower on the screen ?
go to website, fill in blocks from Excel
Re: Long Strings
Re: Macro to run when sheet activated
allow entry in only one txtbox
Re: Macro to run when sheet activated
3D column chart
Number stored as text error message
Re: Colour the rings in a radar chart?
Re: Macro to match values in an array.
Re: Using result of function as row number
Macro that changes worksheet tab name
Re: How to know if a range has been selected
Re: Vlookup problem
Help with If / Loop / Adding cells
Re: How to know if a range has been selected
Editing a Read Only Excel File via VBE
Charting in a loop
Re: Pivot table change selection
Re: Pivot table change selection
Updated Question - Updating an SQL Database
Printing Charts Macro Help
Programmatically unprotect my protected project to delete modules?
Re: Character Comparison In a Cell
Install or protect an Excel spreadsheet?
Auto Save
Re: Serious problem when opening a file
Application level VBE
Open an excel Module
Re: Compile error: Argument not optional
Copying Conditional Formatting Fails
CSV Import - user to select file
Selecting a row from one worksheet if it is present in another
Object hyperlink produces "Reference is not valid" error after worksheet name change
Re: Macro to clear cells of no value
Programming
Excel 'database'
Identify if a page break occours while entering data
System.Runtime.InteropServices.COMException (0x800A03EC)
Application.Quit
Applying the same macro to multiple excel files
Tacking All Sunday & Saturday in a Year along with the dates
Re: How to rename worksheet like "Jan. 2006"
multi sheet scanning
File Open Dilog Box with Filter
File attributes
How to do this kind of sorting?
Re: GetSaveAsFileName to prompt for overwriting?
Re: Read VBA source code as input
Re: Choosing which macro to call
Printing on notepad from excel worksheet... Please Help!!
Re: Setting Up References in the VBE
Re: Type change in a declared Variable?
RE: Type change in a declared Variable?
Setting worksheet name equal to variable value
RE: Type change in a declared Variable?
RE: Type change in a declared Variable?
Re: Sorting after autofilter
RE: Can one select file types for Zipping?
Re: Formatting of fields
RE: How to create worksheet with the name "Jan. 2007".....
match function with text and numbers
Re: time switch
Re: How to create worksheet with the name "Jan. 2007".....
Re: Lock an option in a menu.
Re: How to rename worksheet like "Jan. 2006"
Re: How to create worksheet with the name "Jan. 2007".....
Colour specific cell based on 2 other cell values
Re: Percentage
Array of comboboxes
Show Data from Various Tabs in one Tab within the same worksheet
identifying files with macros
Macro
Re: vlookup function that returns blank if error
On Click Event in Excel
Access Named range value with multiple workbooks open
Macro delete line
Combo Box vba that works like Forms Menu combo box
extract range with same weeks and move to "calendar"
Email a workbook/worksheet on schedule?
Re: Rename Worksheet without Selecting the sheet
Launch Macro at startup
Re: Rename Worksheet without Selecting the sheet
Web Browser
Listbox none selected feature
List Problem--Please Help!
Re: VBA parameters and checkboxes in Excel
finding odd due dates
Converting a "Logged out" time and "logged in" time to find out the elapsed time
Adding meta tags to Excel web pages?
copy row when matching colums found
URGENT! How to read value in pivot table
Importing from Excel to Access
Enter information in one and lock the other, OR vise versa
Re: select a range with a dialog box
Send email when Condition met?
Macro to Filter on active cell within autofilter
Compile error in hidden module - in custom VBA add-in...
Re: Copying Columns
Re: Cell Formatting
Re: Cell Formatting
detect duplicity by 1 scanning
Filename parameters passed based on cell contents
Edit Module headings...
showing data from a cell in a text box
Filename created by passing parameter of cell values
Conditional Computing
Re: URGENT HELP PLZ! Search and Update VBA function.
Re: IF Statement Help
Re: IF Statement Help
Application.onKey non-functioning
RE: File transfer using Shell
problem with shapes.nodes collection in excel 2007
Error Querying Access Database From Excel
send excel by email
Subtract cell formula from existing cell formula
display more info for listbox entry
Re: Form VBA
Re: Don't COUNT 0%??
Re: Don't COUNT 0%??
"Cannot quit Excel" after tried to access protected WB
Data Split and graph problem
ClearArrows - Runtime Error 1004
Adding cell properties (validation/colouring) quickly
Pictures Disappeared
Extract values to copy in another table
DisplayOutline
EXcel Functions in VBA
update links question
Troubleshooting programming on a Mac from a Windows
Calculating a Due Date that is not a holiday or weekend
How to use Index and Match to lookup headers in row and column?
Re: 'Freeze panes' disables controls
Storing a selection from a combo box in a variable
Re: problem with "Refresh BackgroundQuery=False"
Warning Message before a Macro is Run
Re: prevent location change before saving
Re: how to tell when the user selects the find function - hippy
Excel to MiniTab
Re: Excel rows.insert question
Re: Ignoring Errors
Re: Could not set the Text property of a ComboBox on User Form.
Re: Screen Position
RE: Long Strings
Copy paste a range from one Workbook to another
RE: Long Strings
RE: Could not set the Text property of a ComboBox on User Form.
Re: Long Strings
Re: Open old workbook as new workbook?
Problem with leap-frogging myCell Range
Re: Formatting of fields
Re: Formatting of fields
RE: Find specific column titles and copy the column to new workboo
RE: Long Strings
RE: Find specific column titles and copy the column to new workboo
VBA function calling for computations within other sheets
recognizing overtime while preparing a schedule
Return System TimeZone in Abbreviation Format (i.e. CST)
Excel vba SUB doesn't complete until closing app
Re: VB number formats
Looking for range interestion recommendation
Re: Custom Toolbar Docked amidst all other toolbars
Re: Search multiple strings in each cell
Re: Convert String variable to code
Removing "dummy" cell entries - zero length
Re: Splitting files / Pivot Table
How can I make all the #VALUE! on the spreadsheet disappear?
Re: Auto row height for merged cells
Output from table?
Do while loop error....
Transfer Data From Multiple TAB to One TAB
Re: If X and Y then Replace Y
Re: Changing
Excel Add in for AS: Function's not recognized
Need Help ASAP!! Re: VBA cell addressing after Filter
Re: Data Upload from Excel to SQL Server
2 column List Box populated with data not from Excel sheet?
Macro Code Help
pick last item from a (variable) range
Re: Timer Code
Where the objects are stored on the hard drive
Re: Interactive user form design
Re: Timer Code
How to view and update the code behind a pivot table
RE: Interactive user form design
Sin Button run macro Excel 2000 - 2003
E-mail Files From Files
print sheets from a range with names
For Ron de Bruin
Vlookup Cannot Find a Particular Date in a Range?
Open file with VBA
Re: customise Insert Function/Function Arguments dialog box
What's This? help (Shift-F1)
object or array ?
Creating a User Defined Class / Object
calling external routines
Value Issue
Value Issue
positive value
Hw to write a macro to calculate values
getValue
Copy to current workbook loop
HOW DO I DISPLY DIFFERENT VALUES IN ARRAY'S TO ONE COLUMN?
Code Error Message Excel 2000 - 2003
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code.
Populate a Userform from an existing Record.
Save as Read-Only
Poor performance in summing up values on another worksheet
delete rows using VB
How do you SETFOCUS on TextBox
User Form pop up with a beep?
Relative & Absolute References in Formula
Pop Up Windows
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible?
Just a quick thank
Textbox appearances. Format as $ and %. How?
Accpac Dos to Excel
Using Solver with multiple ranges (Excel 2003 sp2)
Creating Pivot tables by VBA for varying amounts of data
Help with event code
Change cell value Excel 2000 & 2003
Question on Graph XLGraphType
Problem limiting characters
Calendar control with merged cells
RE: Determine if Row/Column was Added/Deleted
Conditional copying of rows
find first occurrence of data in a column
Update linked data from other worksheet.
finding the location of a group of cells
Tourism
Macro to Print all worksheets in workbook
Limit characters
non duplicate values
Save As
Refresh Excel Pivot Table When New Data is Added using VBA
Applying Colours
Offset problem
copy chart from one sheet to other.
Still Need Help Repositioning Comments
Pasting search results not advancing row between matches
help with passing date to access as parameter query(code included)
Problem with Shell command
shape runtime error 438 excel 2007
Extract Data using Web query
New List in 2003
What happened to Auto-Filter?
create drop down box
before_save problems
Disabling Shortcuts And Keys
dropdown cell link changes when inserting a row
I want to change the background color of cells, if value is a square root.
capture link update event
Using Macro to fill up data in coulmn
Calling another worksheet
Name Sheets in Series
combining macros - compile error: duplicate declaration in current scope
Help with drop down selection list box
Application Sendkey (when value selected)
SpecialCells Value=0??
name sheet
Calling curve-line feature at run time
Formula with indirect addressing
Row Source based on a filtered list
listbox help please
I need a SUMIF that works with two criteria
How to show User Form when form name is in string?
Re: Select Cell Contents from multippel cells
Re: Multiple windows?
update Records reference to new file
Changing color of a cell, can it work like this?
"Sending" range from Excel to Word
Group data in pivot using VBA
Concatenate a range of cells with delimiter
RE: List and Data Form
MarkerForegroundColor not working
Custom msgbox help needed!!!
Re: Code Problem to end of column
Return System Time Zone
Re: Using an IF statement, or VLOOKUP statement
Re: Adding time & dates together
Re: Code Problem to end of column
Re: coding help for headers
Re: Day v Date
Re: Macro assigned to Menu
Re: Conversion
Re: Zero Default
Re: Conversion
Re: Moving data from one sheet to another.
How can I get rid of all the #N/A that are in my spreadsheet?
Re: Data Upload from Excel to SQL Server
Macro - Excel to I-NOTES (Lotus Domino)?
Macro - Excel to I-NOTES (Lotus Domino)?
Macro - Excel to I-NOTES (Lotus Domino)?
Add data to calendar from worksheet, Excel 2000-2003
Each cell is showing as a page
Parse Cell Around "Dash" in Data
Re: Print and Copy option - MsgBox()
Re: Chart Axis Alignment
Re: How to display the first Item in a combobox as the default item
Re: How to display the first Item in a combobox as the default item
Re: Macro Security Settings and C#
GetSaveAsFilename
Macro with stop date
Re: Declaring Worksheets
Re: Basic question - all rows in column to last row
Re: Basic question - all rows in column to last row
Re: Ceilling or round function?
RE: COUNTIF with multiple criteria
Re: Ceilling or round function?
Re: COUNTIF with multiple criteria
Calling a value when double clicking a cell
No Multipage pages are active on startup
Re: remarking VBA code
Re: remarking VBA code
Re: SendMail without open Outlook
Re: Sheet name as date
Re: graph
Grouping Work Sheets
Re: Overtype mode
Re: More Concatenate operation - Any help?
protect opening of worksheet
Re: More Concatenate operation - Any help?
Re: Run a macro by pressing a hyperlink
Re: deleting a chart using a macro
Strange 'Print' behaviour'
Help with For - Next Loop
Re: Message Box - With Text Input
Find and set references at runtime
Search then copy and past data
Macro to deleting spreadsheets in a workbook
Error 1004 ""Method 'Range' of object '_Global' Failed
Point and comma problem
Re: Cell Formaating using vba
User defined function: Address where UDF is used
Re: Select Case organization help
RE: application.caller
Difference between fixed and variable date
Change Range using value in cell
IS POSIBLE TO ADD TEXT IN TO A CELL WHIT TIME FORMAT?
UsedRange.Rows.Count value
Cell formatting
Delete duplicates and more!
SQL with OO4O?
Visual Basic Code
Delete Tabs
Visual Basic Code
Visual Basic suddenly stopped working
Can I change the colours on a spreadsheet with an if formula?
Re: Names of named ranges in active sheet only
Combining similar data
Case sensitive unique list
How do I programatically pass in a filter to an excel 2007 pivot t
Re: Follow Hyperlink Without Showing Website
listbox add item
Re: task scheduler does not reconize excel
Private Sub Worksheet_Change(ByVal Target As Range)
Calendar DropDown & Scrollbar HELP, Excel 2000-2003
spellLang # for UK
Difficult VBA Query
Re: Select Case organization help
Do loop until, step down row - copy paste - not what it seems.
send sheet as attachment
Adding time
Re: Return the name of a range in a sheet formula
Convert Long File Name to Short File Name
Copying formulas with Macro
Getting started
VB macro to change shape colours
Re: Breaking up a Text String
RE: Multiple windows?
Re: How to Run VBA Code on cell or range change
Re: How to Run VBA Code on cell or range change
Re: How top copy cell comments
specifing an open workbook and reading its worksheets
Using Vlookup in VBA
Excel 4.0 Macro (XLM) Users - Your help is needed
Helping Parsing Excel Data
How to find this total?
Insert image into cell using C# and Excel interop??
Input Box that allows user to select range
Multipage's first page does not show contents on startup
Re: AutoFilter.Filters--What column is being referenced when On?
Re: What DDE topic returns the currently open file?
Loss calculations
Access to Server folders
Re: Selectdown Macro w/ varying rows
Need help with filtering dates
Two Cell Loop
Re: I have if statement and I want to add more if to this arguement
Need Help...Fix my Spreadsheet Please
Re: Need to create a list of sheets from a list of names in column a
modifying a macro with a macro
Re: Using VBA to bring up Help
Click event of combobox
Re: Display decimals in a msgbox
Re: For Next loop
Re: User Defined Type not Defined error
how to compare two arrays?
Re: Deleting Worksheets
#N/A and SUM
Re: Deleting Worksheets
Re: Deleting Worksheets
Learning about arrays?
Convert string to date & select rows with certain feature
Re: How to remove rows with the first cell blank
Re: Find Loop and then Loop again
Slicing and Dicing 1 Cell
finding the blink cause
Does the Macro Editor have an .exe associated to it?
RE: worksheet loop
Named Ranges
Re: list box selection?
Convert a number to text and add a comma separator for thousands
Autofill range
Re: worksheet loop
Re: VB calculations
Index and Match Functions
Search column for certain criteria and display results in a table
Re: Hide the running macro
array elements count
Re: how can i "=MROUND(J33,50)"
Re: how can i "=MROUND(J33,50)"
Validation
For Each loop recheck
Macro formatting
Data Extract and Sort Macro Help
protecting a worksheet
pdf printer on each laptop different name
CellFormat is lost when using CopyFromRecordset
Re: workbook before save
Re: Display decimals in a msgbox
Re: Delete All Macros
Re: UDF Help Websites?
Re: Names of named ranges in active sheet only
Re: Strange serious problem
exclude a column
Re: User Defined Function - Needed
required alert msg
evaluate error
How to I activate Excel
Selecting a chart in a worksheet with VBA trouble
Re: Query Refresh code
modeless dialog question
Save excel file before printing
save before printing
How to Fill the data
RE: ActiveCell.FormulaR1C1
How to change all cells with "zero" value into transparent, not bl
close application when interrupt by user
RE: Check My Code Please - Execute Access Macro
How to Programatically Invoke "Debug"
Re: File Object properties for Photos...
Change Worksheet Button Caption on Worksheet.Activate
Open Excel file from the web
RE: Key listener
Copying cells to another worksheet
Pivot Table and User File Selection
Extract all CN='Name' from a Active Directory data-dumped-cell
Automatic line change
generating non-repeating random numbers in a range
Re: How do you keep a Dialog Box in the center of the screen?
Re: Formatting Excel from Access/Subtotals
Re: Set Integer Variables back to Zero
Re: Timer Events in VBA
XML equivalent of VBA's XLdown
Re: Sorting Controls by Name
Re: How do I create a macro to Show detail in Excel
Which imports for stdole in vb.net
RE: Formula to VBA
RE: Formula to VBA
Print long sheet shared on pages
Re: Insert Rows
Re: FormatNumber
Re: Consolidate many sheets into one sheet with multiple rows
Autofilter Printing
How to automatically generate excel files at the web server?
Find, Copy offset to offset on other sheet, Run-time 1004.
reading rows
ranking each employee
Create multiple workbooks from a single Excel spreadsheet
weird things happen sometimes
Re: goto row
Re: ActiveCell.FormulaR1C1
Re: Efficient Code to Copy a 1-D Array to a Worksheet Column
Using variable as row reference in VBA
Re: Moving, Resizing a Cell Comment
Where does an "On error resume next" statement apply?
An objects properties?
Re: Dynamic Column in Pivot Table Macro
Calendar change month from multiple sheets to one sheet, Excel 2000 & 2003
Assiging value to range through input box
refer to cells by number
Re: Excel button
Re: email to multiple
Combobox will not fill
Hide unbolded rows in specific column
AutoFilter.Filters--What column is being referenced when On?
conditional concatenation
Textbox query
Auto Update Cell (Row) References
export xml source mapping
Select page tab when form opens
Function: days of week in column, Excel 2000 & 2003
Question on how to do a COUNTIF type of statement
Find & Replace Macro Issues---Please HELP.
Re: errors.....
Excel VBA UDF Userdefined function - search in partially empty fie
Re: Event Code for Controls created at runtime...
Re: Excel VBA UDF Userdefined function - in which line is the function
Need help with: runtime error '13'
Formula that will ignore strings
Re: Copy from multiple worksheets
searching
Macro Execution Time
Re: Worksheets looping.
Creating a values-only copy - page breaks a problem
Re: Event Code for Controls created at runtime...
Re: File Object properties for Photos...
Search cell contents
Re: File Object properties for Photos...
drag and drop without holding down control
{=AVERAGE(AND(B6:B15>=B3,B6:B15<B4),C6:C15)}
my Franken-code
Losing data in controls (and arrays) during unhandled exceptions.
Help with formatting Excel sheet.
Sugestion for the Excel Guys
Fill empty cells in a range using the used cell
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the l
Re: save userform as image
Format problem
Pivot table
RE: In over my head again
Re: Macro printview
Double sided printing with entire workbook with multiple pages
Re: basic file I/O
Re: Copy and Paste for columnwidth
Re: run time error
Re: formula for negative time
Excel Time Help
initialize value in userform when opened
Drag label position on userform at runtime - jerky movement
Would someone explain what this code does?
add an event procedure and hide the code
Tooltip or StatusBar msgs for menu items
Re: Workbook_beforesave question
How replace a character in a string of characters?
Re: How do i program a macro for print view
RE: Beginner to VBA
RE: Programming dates
Re: Macro printview
Re: Find Column to use based on Name of Header
Need to combine people at same street address
Data Mismatch Error when adding 2 new fields
Re: Excel in winform freezes Excel
Re: Excel in winform freezes Excel
RE: Go back to previous page
ODBC Password
Adding Extra Data Row to Chart via Macro
Re: Sending mail
Finding & filling blank cells
EXCEL VBA + Microsoft Flexgrid
Re: How do i program a macro for print view
Vlookup help
Totalling the same cell across multiple workbooks
Unreadable characters in file with Print #File in VBA
help needed
stop a macro to enter data to the cell I want
Simple yet...Copy formatting (including column/row dimensions) and values but not formulas
Re: Horizontal Page Breaks
Multiple Controls in a Dynamic UserForm
Macros in Excel?
Re: Help with Numbering Macro
Re: Vertical Page Break
modify a macro with a macro
Re: simplify my codes
Run Macro on All Worksheets in a workbook
Error in grouping rows in excel using VB
Macro Error "Unable to record"
Re: Correct way to implement floating combobox?
Re: code?
Re: Mail Merge/Data Entry question
Re: Hide Worksheets?
Re: Code for Returning to Last Active Worksheet Please
Excel 2007 Text Box
worksheet selection change
Re: Background Cell Colour-If Data Match
ComboBox
Re: Save As location
Re: Macro to copy the same cell from each sheet
debug repeat entries with a random function and erase the rest
Iterate through Names for text
Re: Table sprting
Module not found
Column Lookup Problems
OLEDB Help
Follow link from Window("1") in Window("2") possible?
RE: Help with code needed
apply all names
Hyperlinks and directing towards a current window
Re: basic VBA programming
Too many ignored errors
Too many ignored errors
Search and add numbers from many WBs depending on ID column
countdown clock
Help with code needed
merge rows
Determining Range of selected cell
question on gosub / return
userform and variable
Re: basic VBA programming
Module Precedence?
resource for automting Excel using vb.net 2002 via PIA
Calling msgbox in Excel
RE: basic VBA programming
Finding a word in a cell, but not when its a substring of another word in the cell
second key in cbox2
naming an undetermined range in a new worksheet via vba
Spinner Increment Values
limit on DLL function arguments
Stuck Smart Indenter
Data Validation
UserForm Size On Different Computers
XL2000/2003 Compatibility Issue
Variables with times between Midnight and 1:30am