Excel Programming [Archive] - Page 12

Take out dates that are not current month
Ribbon toggle button issues
How does Excel Know Where a Referenced Add-In Wbk is Located
Notification of replies
Disable/enable recalc
Named Range, hidden row, auto-filter & macro buttons
FTP File Size from wininet
FollowHyperlink
Code to copy cell values from one sheet to another
workbook file name
Automatically Updating Summary Grid
How to get rest of characters after last certain character?
FINDING DUPLICATES - CROSS REEFERENCE 2 COLOUMNS TO FIND UNIQUE EN
Excel VBA SQL Query Filename
Comments - with unprotected sheet
Worksheet_Change() and range question
Case statement comparing two ranges
vlookup: file moved or new one. keep cache
Make Userform Caption equal textbox contents
Location of SQL in an external data connection
Email excel - 1 sheet in body 1 attachment
Dreaded Runtime Error 1004.
Mid and Left Statements Issues
Shakersort & my modifications that don't work :(
Copying Data between Spreadsheets based on a rows value
Autofilter in a macro
vba for find last column with hidden columns in worksheet
Summary Grid
FindTextInsertCol Excel
Remove double quotes from text file
Converting/inserting values, without changing the other contents.
Create array
Get sheet name in any workbook
Goal Seek Problem
set on / on autocalculation
Why is Access VBA syntax different from Excel syntax?
Option Buttons
copy worksheet
Validating date entry in cells
CDO email - transport failed to connect the server
Calling a Macro from multiple places in Excel sheet
RE: HELP: Syntax error (missing operator) Query Expression
Sorting columns
How do you Determine if a Worksheet is protected?
Deselect a single sheet
Help with Immediate Window
Re: Clear check boxes?
RE: Clear check boxes?
Compare entries in 2 worksheets and list what does not match
Historical Stock Close Value
Default entry in dropdown on Ribbon
How to apply data formatting to a chart
Spreadsheet calculation problem
Clear check boxes?
HELP: Syntax error (missing operator) Query Expression
Out of range problem - I'm stumped...
More then 1 Private Sub Worksheet_Change
Re: Automatically Spell Check Before Printing
Re: Automatically Spell Check Before Printing
Concatenate text from columns
Position of a Shape
RE: Testing for formula or value (constant)
Testing for formula or value (constant)
Automatically Spell Check Before Printing
fixed column data
.LookIn problem 2007
RGB fill color not right
Array problem
**finding duplicates from multiple columns and highlighting**
If a workbook has only 1 worksheet then
Macro Help
Run-Time Error 1004/ unable to set the hidden property of the rang
including references; how portable?
Set a reference to Microsoft VBScript Regular Expressions(vbscript.dll)
Use spreadsheet cells for global variable space?
Pass variables to Worksheet_SelectionChange
concatenation
concatenation
Open password protected ppt files
Convert cells reference to string reference??
Add a comment when cells are changed
church visitation
church visitation
SOS! how do I write a customized function to do multiple-value lookupin Excel 2007?
RE: Paste value in new workbook
Paste value in new workbook
Simple code question
XLSM to XLS conversion
how to get the format of this cell right?
Finding the last column
SUMPRODUCT troubles
Search always ends in a find, but should not
Return All Sheets to Cell A1 before save
Add row dynamically
Userforms - automating the naming of frame and page tab captions
DateSerial vs Date??
Calling Crystal Ball Predictor from VBA
Run MS Access macro from Excel VBA
Received .xls with macro I can't find.
FileDateTime
What is a user form?
Worksheet Crashing Excel
Conditional Formatting not recalculating
Userforms - listbox gridlines?
Custom filters that filter formula results?
Have we set a Precedent??
Deleting sheets
Attempting to call a sub from another wb using a Userform option b
Rows in named range?
insert data after page break
Insert Row and Formula
drop down menu
empty arguments recalculation
Problem getting Excel formula to Calculate
Excel Number Formatting
Run Macro button after info is entered in a cell
Moving 2003 Custom Menu to Quick Access Toolbar
separate string into letters and numbers
XLStart File doesn't open when Excel Opens
Data Entry very slow ... Slow to start WOrksheet_Change
Excel Macro to Populate table from Data
User Form to Create a Pivot Table
UserForm loaded twice in VBA Project Explorer
In Excel, comments cover the data line. Can it be moved?
scaling a range
Getting the address of 'MyDocuments'
Identify and Paste Down (autofill) a Formula- Help Please...
Not to run macro if row 1 selected
Error 1004 opening workbook 1004
how to choose a part of the text in a cell???
Import Text file Data into Excel Sheet
VBA code to delete cell contents
Alternate way to refer to sheets???
VSTO Excel 2003 to VB 6.0 Type Mismatch
Export Data from Excel into existing Table in Access
IS there any short cut key to select all shapes
VBA to create series of workbooks need to add code to skip creating areport if no lines meet criteria
Scheduling
Vlookup with Reference cell from Sharpoint
Copy and Paste Formula from ActiveCell to cells in 13 columns priorto the active column
Checkbox value in a custom ribbon
Absolute to Relative Referencing
empty arguments
hyperlink button on a userform
Functions & Formulas
Pre-select visible sheets in listbox
Can't set column width
Reset Color Scheme
Importing 23 Excel Datafiles to one Excel Datafile at The Click OfA Button
File Save Properties
How to move down cells...
Excel 2007 Chart colorindex?
Retrieving values from existing worksheet
Save file in XL97 and 2003
Check box to change the format of a text box
sheets that mirror each other
Using functions and subroutines in other modules
pivot table connection access
Re: Difficulty analysing Journey Planner result
Show a named range within a label (not VBA)
VBA code to write current workbook to file
listbox - code to adjust column widths
listbox -shows table of information - option to select and edit ro
Combobox will not show list
office 2007 scroll thru the items in a cbobox in the ribbon
Active Cell problem
Nested if/and
.cells reference?
Forms
SpinControl on PopUp CommandBar ?
Problem with "Application.Goto Reference" code line
new excell will not read old excell file
DDE Links
Re: How can I rewrite IF IsError Function to Work in VBA
How to fix the code for macro?
Absolute value
RE: "Paste Special" does not work??
Error 400 in VB code execution?
2003 & 2007 Differences in Locking Cells Syntax
RE: Data in f a Merged area
Help with OptionButtons on a Userform
Editing multiple controlsource references
Data in f a Merged area
Preserving number format in userform textbox
Re: "Paste Special" does not work??
Re: Looping through TextBoxes
Add to an Existing formula in a Cell using VBA
putting a picture onto a userform without using the vba window.
How can I rewrite IF IsError Function to Work in VBA
Looping through TextBoxes
Overriding the menu "Save" option?
Set sheet viewpoint on workbook_open()
"Paste Special" does not work??
Activate a moacro subroutine from a userform command button
Pivot table warning dialog suppression
Pivot Tables - refresh from Userform command button
Email a Merged Worksheet or just required cells
Re: Breaking One workbook into many Tabs
building array
Re: Breaking One workbook into many Tabs
Breaking One workbook into many Tabs
"Flase" overwriting value in cell...want to preserve existing valu
Re: delete rows in a given range
Combine Ranges to Draw Borders Issue
RE: Increasing alphabectically
RE: delete rows in a given range
Re: delete rows in a given range
Re: VB excel help needed
Re: Increasing alphabectically
Removing duplicates
breakpoints
Error on Autofill
delete rows in a given range
Increasing alphabectically
Update
[VBA] Dynamic target stock
Re: VB excel help needed
VB excel help needed
Checking to see if a user form is hidden
Re: Best book to start Excel Visual Basic?
Best book to start Excel Visual Basic?
Create a public variable
empty data from a pivot table
Proper VBA code to open Excel template
Append name in the same cell with ' '
How to code the macro?
Autofill Based on a Changing Column
activate pivot tables from a userform
Cell Values Not There ???
Run Time Error 13: Type Mismatch
Pivot Table not pulling all fields or data
count cell with background color 36
UserForm show question
Compare two arrays
Newbie with a desgin question
Re: Use VBA to change row height or width??
Use VBA to change row height or width??
Extracting data from one sheet unless it is also on a second works
variable variables
create sheets from data
Sum column with count formula
Save As without VBA project
Indirect addressing
Accessing Named Ranges
How can I define my own Primary Key in Excel?
Extracting names and titles
Another Error Handling Question
Keyboard shortcut for add-in
Data Validation. Multiple.
Delete Rows from sheet 1 from values in sheet 2
Want a Macro for Date
save a copy
This is probably something really simple!
Create Named Range for each unique value
VBA equivalent for Excel "indirect()" function in UDF
Copy /Pastespecial Textboxes
VB to get to top of page
Duplicate procedure in other sheets
Need help developing a Excel VBA Macro to Vaildate data entered intoa textbox
find a word in sheet
Copy and Paste Loop
Wait for action
get complex data from other xls file
Adding shapes to worksheet
RE: Converting 2007 to 2007??
Date conversion doesn't make sense
Sheet selection on Autoclose
When useform is openning, I cannot open another workbook.
Updated Calendar Tool (No Macros)
RE: Macro to Un Hide filtered rows
RE: If(vlookup statement
Converting 2007 to 2007??
RE: Help with Excel 2007 Interface programming
Re: Formula throwing up an error
RE: Formula throwing up an error
Macro to Un Hide filtered rows
How do I create a TextBox on a DialogSheet in VBA?
Want to Change Range Selected in Formula
Formula throwing up an error
Using VBA to change Excel layouts
Re: smart tags
Start up file doesn't open
Quotes in a csv file
Re: How to Sort Merged cells for worksheet?
smart tags
How do you send data to the same row of a text file everytime?
Capture data from cell before Enter
If(vlookup statement
I need help with VBA and a CSV file output
Show userform at spreadsheet open
.PrintQuality = 600
How to Sort Merged cells for worksheet?
Help with Excel 2007 Interface programming
Grouping rows with the plus/minus icon in the first row
ADO connect mysql
RE: Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't
Loop without Do
RE: Macro to import external data from Access query to Excel
RE: Worksheet Ref.
Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't
Macro to import external data from Access query to Excel
Worksheet Ref.
add customui ribbon tab to a existing workbook
Count occurrences of filename in column
Calender sizing
Re: Using String as Code for new Module
AutoFitMergedCellRowHeight Limitation
Using String as Code for new Module
Pivot Table Formula
Marco help - emailing
Formula assistance
MACRO help
AUTO SUM ONLY SPECIFIC COLORED CELLS BY CONDITIONAL FORMATING
Macro Help
Excel 2003 - Macro Help
to make column letter dynamic in charts
Convert column # to the letter of the alphabet
Make changes to Options in Internet Explorer and log onto a networ
Adding a new menu on the Worksheet menu bar
Report creation in Excel Using VB.Net App.
Intercepting the Save
For control variable already in use
marco to move a sheet
Open file already open by other user
VBA in 2007 interface programming question.
Could my ADODB connection be causing a network problem?
cant draw connector lines between 2 shapes
PLEASE HELP with populating userform fields from access database
Design of web service for Excel consumption
animated text in a userform?
Why does Excel think this is a number?
Dividing lines in userform list boxes
AutoFitMergedCellRowHeight limitation
Don't refresh tables on Open
Re: MACRO Recorded and saved does not run the second time.
Import external data from Access query with Variable
opening a userform from a userform
Copying command buttons
RibbonX, Keytips, Menu Controls and Underscores?
Destroy VBA code within a macro
Importing / Linking Dynamic Data or ASP Tables into Excel ?
Adding an image to an Image control
Open and Save Files in Directory
validating username and password in Active Directory
Setting up Solver reference in a protected VBA project
Setting up Solver reference in a protected VBAproject
Getting info from other Excel Files
if then statement with a vlookup?
Check Auto Filter - if on, turn off before running macro
creating groups from an existing list
Macro Help
code breaks in macro
file names and path. How text to columns from right to left
Open multiple workbook then combine into single workbook butdifferent sheets
make changes to Internet Options and how to log onto a private net
UserForm Query
Updating Progress Bar for individual actions
Macro to copy and paste
Using Excel to WRITE to a closed Excel file
Alternative to Calendar Control 8.0
Calendar control code
Problem reading with Percentage values
Do you need MS Access to query on an Access table?
Application-defined or object-defined error
ListBox TextAlign-Property Question
Ribbon X macro not available
Simple Range Syntax Question
retrieve an AVERAGE of a range using VLOOKUP to locate start/end d
String comparison
disable sheet while processing
Help with Date functions
Printing userforms
Help. Sumproduct Data Type Mismatch Erro
read vs write file
MACRO Recorded and saved does not run the second time.
kb973593 bug
copying a range of data multiple times from multiple workbooks
Open file validation
multiple value choices for If range().value = "xxx"
Message box this is what your looking for
pasteall problem
MsgBox in another Instance of Excel
date comparison
ThisWorkbook.RefreshAll Issue/Question
Formatting a subtotal line with a macro
Sumproduct gives #Value! when answer=0
How to assign range to Double array?
Validating Hyperlink for file
Moving Files
How to work with reference unions (A1,A3,A5)?
VBA Password Workaround
Set up macro (or formula)
Macro shortcut glitch HELP!
starting Word from an Excel macro
VLookup and Indirect
Coding deletion
Date Format
Include Dropdowns and Checkboxes in Worksheet Change event
Macro Security Warnings
Coonect to access with password
Copy from one source to multiple spreadsheets
How to use comma separated inputs in macro
How to call a macro from a xlam in a xlsm
list workbook names except one
Hyperlink File Help
Averging data when criteria is met
Hyperlink File Help
Hyperlink File Help
Hyperlink file help
add combox with code
Emergency! Switching to Office 2007!
i want to this template for planning in Office
Not sure what the subject is
Change row colur
Getting info from closed Excel files
Having "Ð*Ð¾ÑÑÐ¸Ñ" in a Workbook name and recovering "??????"
VBA to remove records
Excel Database and Macros
merge data macro
Publish charts as PNG
Using VBA to read/write data from Excel files
Workbook with Macros won't share
Macro to copy from one source sheet to numerous destination sheets
strange result for SpecialCells
Ribbon's equivalent to CommandBars.ActionControl
making a countdown timer
Adjusting row heights and column widths to align with another sheet
if then and do - DA
SUMPRODUCT Formula Not Calculating with 2 criteria
Reference a workbook chosen by a user from a userform
Copy from one open workbook to another?
Finding rows that contain Keyword1and Keyword2 in any part of fieldin Column A, B or D
copying VBA from one Excel file to another
user-defined data type capabilities
sumproduct ?
Date Format
Can't get length of a variant array passed to a subroutine
Hiding a "Userform" instead of closing it???
String to Number Conversion Problem
How to express a set of cells as a range
Pasting Data into a webpage text box
Cut and paste objects into userforms
Drag and drop text in userform text / combo boxes
Check values in each column
looking for matches from 2 different sized ranges
Pasting into a Webpage Message box
Using "Select Case" inside Worksheet_Change() subroutine.....
Defining variables
Preventing "save changes" dialog box???
2nd question - Calendar Control 8.0
Cell entry triggers Worksheet_SelectionChange event
Button for a Macro
select a range by cell names; vba
Copy from one worksheet to another
Problem with copy from one worksheet to another
combo box value
Sumproduct formula works in spreadsheet, NOT VBA. Help please
Workbook_Activate() vs Workbook_Open()
I have excel 2007 but I need 2003 tool bar
simple question regarding pasting
The worksheet calculates too often
Set Print Area with Dynamic Start Point
Calendar Control 8.0 question
Index-Match and Like...maybe...
Help with creating dynamic table & filtering
Workbook_SheetCalculate Method
XML Data
Re: Create a new worksheet (excel 2003) if one or more cells in arange is not empty
Create a new worksheet (excel 2003) if one or more cells in a range is not empty
Why Range name not showing in list
display dots inside a cell in graph form but without Excel graph?
How do you work with high character numbers?
Creating a Pivot table
VBA - Copy/Paste to next empty cell
Axes(xlCategory) for a chart-sheet in 2007
Sum using ordinal/relative positioning
Is there another way to write this?
VBA code
Remove some intermediate lines
Excel 2007 Smart Forms
Moving files based on cell references
Selection Change Event
read hidden cells; vba
Show a range in a shape/picture object
conditional format -- if not a date, then highlight cell
Macro Recorder
Macro Quick Key
userform list setup
Please help!
Remove a shortcut from desktop using VBA code
DataObject: PutInClipboard Not implemented
Charttiltle as function
Excel getting info from Access
Insert formula to range of rows (Variable) from macro - debug help
Update value. Function
Array within a dictionary
Sumproject Run-time Error 13
help needed with graffiti.net email query
Open Search and replace dialog
Open Search and replace dialog
How to retrieve data from share folder using vba?
How open multiple file using vba then later combined into oneworkbook
Group
Feasibility of 365 day workbook???
Mysterious re date Format
ODBC - SQL parameters error
Filter based on named range cell - debug help required
Hidden sheet tabs (to store data)???
need to automate a sheet re-organization
Save the ppt file with password
VBA Code not shown
Detect top, left & height of activeworkbook? How do?
Copy from one open workbook to another?
creat sheets with assigned name and protected
Want Macro to save to .xlsx
Acos in WorksheetFunction
Chart Question for Excel 2003 **Desperate**
sub tot column to next blank cell when blank cell exists in both c
Using VBA with Pivot Table Report Filter
Only keep rows that contain
Ron de Bruin's merge cells to master sheet
Assign macro to check box?
Copying and Adding Values
Sumproduct in VBA Type Mismatch problem
complicated Vlookup?
Referenced Workbook Add-In Slow to Open in 2007
Getting all open files in Excel
VBA Format for a Range Name Used in the Sum Function
Joel - The DBF Solved
Error 13 Type Mismatch
How check if file to open is Excel or if Excel file is corrupt?
Open a sheet based on day of the week!
November 10, 2009 Security Update macro problems
search posts
Passing a range from worksheet to VBA function
Oracle <CLOB> question
Select range of cells in column AS based upon lastcell in col A.
Reverse sign of range
Time-Saving Metrics on Sorting By Color
Use memory variable in range selection
set pivottable source data to range name
Get Access Data into Excel
Show cell contents depending on other cells information
can msoFileDialogFolderPicker display file names in the folder
MS Excel 2003 to Mac Office (Excel) 2004
Workbook_BeforeSave Event
filesearch frustration
Make cells blank IF
Can I use a macro to create a macro in a new workbook?
Printing Macro
Still need help on Macro
Delete Rows that do not contain
Macro to pull every Nth row of data
How to match debit and credit line item
Problems saving XML file: Run-time error
userform help
Excel Function not Evaluating to a Result
Specifying which axes Excel uses to plot a graph
Need Marco Help please
Updating links to external files using macros
message box caption color
taksitli satÄ±ÅŸ tablosu
Giving back
dynamically increase x axis
Tricky question about rows of cells.
convert to Numer
Internet Time and Excel
Linking to Access Table
What's up with mswinsck.ocx ?
Book with 365 sheets??
Protect Workbook in 2003 changes to password to open in 2007
Array in Both Branches of an If Statement
Evaluate File for Last Updated Date
How do I connect to a sql server over an IP address?
Run-time error '9'
Significant figures
Delete all rows not current date
Extracting numbers from a string containg letters at the end
Changing color background in a range from a drop down
The mode function
Delete rows with names
on error msg box help
HELP Error: Trying to populate userform fields from access databas
Print group of records with same Customer name
IF a cell is active THEN...
Number Stored As Text
Personal macros file
Position Userform In Cells Portion of Excel Only
How do I Shorten Object References?
Populate date into excel from DataSet/DataTable
Why are the two codes below not getting the right formula for myworksheet event change formula?
help with sort on active cell
MultiLine Code Builder, Need Help to Clean Code:
referencing web site object
Joel - The DBF4
Autofit -
Calculating a sum, exceptions for specific values
Copy URL to clipboard
Lost VBA
Change file name from folder using VBA
combining rows
Excel Instance not cleaned in Task Manager (Interop)
SasAs Issue: Automation Error
C# Add-in and PivotTables
How to run macro to shut down my PC?
sort dynamic range on active cell
Looping through sheets
Password protect all files in a folder
Open file with a Pivottable Protected
RE: Macro to delete a specific sign
duplicate data in range clear contents
writing a vba code for a simple function
Problem with Code to Change Font Colour Q
Formula Cell Error
TRIM, CLEAN, or Something Else?
Re: Counting Highlighted Rows
Print Spreadsheet to PDF file
Re: Inserted rows, now need Counta function
Re: Inserted rows, now need Counta function
Re: Aligning edit boxes on the Ribbon
STOP close button on another workbook
VBA Borders in Excel 2007
Delete columns based on a cell reference date value
New to Excel/VB and could use any help
Function to Return the IP Address of a known Host
can anyone help me finish this
Re: #N/A
Visual Basic for DOS
Re: #N/A
Formatting cells entered by a macro
Re: Insert cells at end of selection
Ghost VBA Projects Created when using Hypelink
Re: Aligning edit boxes on the Ribbon
Re: Insert cells at end of selection
Macros help!
a way to append data from 2 different files
Pull info from access to excel userfom and edit an existing record
VBA question
Re: Start Macro when specific Cells are selected
Maco question
Re: Change page orientation to suit selection
Re: Change page orientation to suit selection
Re: Extracting Data from Access dB to Excel, using VBA
Rename Sheets based on List
Convert (-) to a (+) number Macro
Populate ComboBox with Worksheet Names
Re: Data analysis by 2-dimensional data table + database
VBA Copy Range of cells with a condition to another worksheet
RE: Extracting Data from Access dB to Excel, using VBA
RE: Counting Highlighted Rows
Save last row to use in another set of code
Re: Convert Radian to degree angle for COS function
RE: #N/A
RE: #N/A
Deleting duplicated rows based on data in two columns
Userform question
Defining a range
Excel crashing during macro (but very odd)
Combobox strange behaviour
userform question
user form start field
Why Doesn't This Work? (Page Setup)
Data in a Calender layout view
Ribbon - custom button calls macro with argument
user form parameters
Dynamic Image references in a cell
Count only cells with red font.
Timer recalculation
Transfering data from one spreadsheet to another.
HELP: Export data to word template and save it as a seperate file
HELP: Trying to a word template with name from userform at a diff
Combobox add large range of cells
Wrestling with fractions and dates. Knowledge of photography is helpful.
PivotTableWizard
Display ranges from one worksheet to another
help with HUGE file building list
data lookup/validation syntax
Autofil on variable rows, delete extract and show remaining rows
paste linked cells show "0"
Copy only visible cells after applying "Subtotals"
Problem with Vlookup
Copying Data from One sheet to another
VBA//Oracle Interfacing Question
Initialize an imagelist for use with a listview
Count filtered rows
Help with my Excel Database
reset combobox to blank
UNDO become impossible after modifying SheeChange handler
Pivot Table Page Fields Selection
Macro
Well, how hidden is it ??
Automating Making a DBF File
Prefill column
Should be an easy but I can not figure it out!!
what type is calendar control
Re: code to sum 8 textboxes
code to sum 8 textboxes
Turn pc speaker on/off with vba code
Timestamp a cell when row is updated.
Simon : Script Error
Append Below
Syntax Error Writing in MDB table
Remove a cell's CF by double clicking it
MS Query has data, but does not transfer it to Excel
How can i make a macro run all sheets ?
Macro analyzes all sheets and puts result in last sheet
find text and copy selected rows from text and loop
Conversion from text to excel
is there an add-in to use genetic programming in excel?
How To Validating Range of Cells
Run-time error 1004
Please Help (Unusual Lookup)
conditional formating
Little help - Quotes in VBA
Need macro to turn off AutoFilters in a table (repost)
Show the Paste Names dialog via code
Need Excel macro to turn off AutoFormat in a table
Data entry form macro shows wrong formats
CommandBars
Scrol window
Excel Game
Find & Replace Macro
remove all format(s) on a sheet
excel macros
Option Button Stays selected
too long a formula, can someone cut it down
Runtime error '16':
File dialog makes application visible
Tools for Analysis - Samples with VBA
Related Functions
Date and time picker use in a userform
Web Login, Table1
explicitly name workbook and close without saving
INVALID PROCEDURE CALL OR ARGUMENT
double click event search in other workbook
save only selection and subtotal
How can I open an ODS file?
Is Sheet Empty and unused
search button to populate cells from sheet
Calculate Range run-time error 1004
error on sorting a range
VBA compatability
Addin compatibility between Excel 2k3 and Excel 2k7
Rounding range of cells
German VBA
Excel/VBA Coding Help
Format linked workbook cells (updated)
Sending Excel Worksheet as PDF file with Excel 2007
#N/A Conversion
Address Range in Email Script
Save a pdf to the desktop with a filename as a cell reference
I need a Magnifier for electronic maps
Format linked workook cells
deleting first 10 characters in a cell
Auto filter, sub totals, text
Adding Column Headings to a ListBox
Better way to select Cell in Range
visual basic in excel dictionary/glossary of command terms
Help with Time Calc
Row find Macro
Making a list of 100s of items typing narrows search
Dividing variables
AutoFill down a certain number of rows
Excel Pivot Items Using C# - Unable to Access
Two macros with same name in different workbooks
How do I get the row number?
Cropping an image
No filter rows
advanced filternot working in macro
Select (highlight) Text in txtBox at Initialization
Updating public array within a form
random numbers from list box
copy date to text
Fill down Formula Automatically
Excel buttons
switch automatically between text boxes
Code to resize image
Image resizing
Look up question from changing range with criteria
Delete Entire row if value don’t match
Time Stamp help
Find similar items from a two fields.
Rnd() 1004 error
Dynamic Ranging
on error help
triming the first 10 characters in a cell..
Excel Shapes
automation to remove certain characters from a cell
Mystery of the re-appearing custom toolbars
Can I use VBA to copy from excel and paste
Validation List
stdev CF Formula
Need help
auto running macro
Vlookup return %
Call subroutine problem
How can I use vba to populate a website input box?
Ping
Converting workbook to run on German excel
Pivot table Macro
same button on multiple pages
Variable in formula problem
formula variable prob.
Split Workbook into Multiple Workbooks
Create Hyperlink to URL
submitting a cell into a search box on a website
automation of sub
Insert Picture using Macro & Validation list
Validate Text in Textbox to Ensure Text is a Valid Price Format
How to insert email signature from EXCEL VBA
Editing controls on a userform en masse
HELP with .HTMLBody: Display Hpyerlink in email body
Using VBA to evaluate ranges of data
Scheduled task "Error # 70 was generated by VBAProjectPermission
Run-time error 13: Type mismatch
So then how to a get arrow keys to control a spinbutton?
Excel (or Access) Challenge
Create new worksheet with Excel Macros/Formulas from another works
How put Array in VBA
Long Block & "Name Box"
If Code
after filtering, change every cell in column J
Office Discussion Forum
Odd character from scan
Finding the next blank cell
workbook
VB macro script to find column A in Excel when row not known
Scheduled Task Fails running Code to send Outlook Mail from Excel.
Macro to populate cell value from another sheet based upon the datavalidation list selection
Excel 2007 bug caused by latest security patch KB973593
Using SQL (with a Group by function) inside EXCEL VBA
Need advice re: date without slashes
Random Number
help with on error stuff
macro to set cell protection by row, based on pre-populated values
Trouble with conflicting IsBlank() and CountBlank() results
Insert Page Break Based on Text
Excell
Reference Errors with Distribution of excel sheets with macros
Range to Variable for Sort
VBA Help
Help with VBA
auto fill cells with text if value of one cell meets specificcondition
on error coding
delete all rows not beginning with
Output to a fixed row in a Text file
vba to lock columns b thru d based on value selected in col a
Macro to hide rows
Loop range change a cell color
Matching with respect to Column text
Formula in a table header
Out Of Memory Issues
wrong code
Populating values in cells based on lookup from other cell.
Highlight Text In A Textbox
Display variable in userform
Show cross-referenced value from 2 combo boxes
Redefine a Range
Run Code in Another Workbook
Trying to loop
<1000
Assign faceid to image on userform
Synchronization Best Practice
web page data (question for Joel)
Highlight cell if criteria met
Shapes: identifying different types (charts, textboxes, pictures e
Embedded function screentip
templates
How to refer to the previous target
copy and past numeric values only
Command Buttons not responding
Command Buttons not responding
Applying a specific Print setting to all worksheets
date confusion
customize Excel ribbon
Remove password on 'file save as'
Excel.Chart size changes after copy-paste into Word
Excel 2003 lookup help
Array question
Missing Reference
Assign range to variable for sort
make worksheet tab blink?
Array question
Creating a Macro to adjust the row heights
Merged Cells Autofit Macro Help
Expand and Collapse rows using a macro
CONDITIONAL FORMATTING IN VB
Merged Cells Autofit Macro Code
copy/pasting data into a worksheet and then sorting worksheet
hyperlinks
Vlookup against a different spreadsheet.
Change background on excel chart
Dynamic Event handler wanted.
Adv filter fails in macro, works fine manually
help please
combine sheets from several workbooks into one
Simplify save code
How to find a workbook name?
RE: reading hyperlinks
Test if Internet Explorer or Excel
Test for Internet Explorer or Excel
reading hyperlinks
ScreenUpdating and listboxes
auto convert to upper case
Error 2029. How do I fix this error
Seating Chart
Increment/decrement a number in text cell
Help with Sub's on a worksheet
Can I use HLookup with an internally defined array?
stuck with Auto column fit
Explanation of code
Pass parameters to Workbook from hyperlink
Please help
code is not working.
Auto column fit
Opening / Closing files using Excel Macro?
Refer to Hyperlink
Create a workbook from every worksheet in your workbook
Copy data from one excel to another
user defined type not defined issue
Select and Delete
Select and Delete
Clarification
Finding what if IE or Excel is opening a workbook
Need to find what is opening workbook ( IE or Excel )
Get info from second sheet
Another Find and Replace need
set up drop dpwn using VBA
Macros
Excel 2000
Charting in excel
Changing formulas in Excel that relate to Pivit tables
feedback program
copy from excel to word
Find then Sum
Rookie Question - Activating Worksheets
Creating Named range problem
Display file path as hyper link in outlook email body
Cell Change Alert
Copying specific cell ranges from a worksheet multiple times to a newsheet
Help needed with Missing Refedit.dll
Allow "Goto box" resized in Excel since long tab name problem
populate some userform fields from access database
merge worksheets
Button location problem
Deleting all rows in all sheets
Insert row gives run-time error 13 message
Variation on the count row question
loop through the workbook and paste every sheet it into newly createdworkbook with same sheet name
To have 2nd window view only
Formula in macro gives "Run-time error '1004':"
ADO copy from SQL Server into Excel 2003 List Box
Change Source Data in VBA
Listbox selection hangs
Problem with code used in other countries
Obtaining a certain date from columns
Changing the background color of a cell
Protect Workbook and Share it.
2002: Worksheet_Change and Validation error
2002: Worksheet_Change and Validation error
Code inconsistent
Row deletion event: identifying deleted row ID
Copy if code
Impossible? Dynamic copy/paste
Impossible - dynamic copy/paste
Impossible - dynamic copy/paste
copy and paste it in a new sheet with sheet name as a1 value
Compare two Sheets
Automating a web link
XL7 bug in inserting pictures
Need Macro to Sum Range and Paste the Value into one Cell
Excel 2007 stops calculating
Clear a range
Clear a range
userform - user selects image file from dir that will display in c
userform - user selects image file from dir that will display in c
Hide columns with certain coditions
Please Help, Excel to Website and web data back to Excel
Match, Index and CSV
sorting data in columns
Textbox form to Textbox in worksheet
What do I do wrong [Excuses pushing the wrong key combination earlier]
What do I do wrong
Increase the value of a cell by one... With a mouse click...
2003 works, 2007 doesn't: "Method 'Select' of object 'Shape' Fail
Export VBA Code to Text File
2003 vs 2007 Shape Selection Error
Function to find value in string
color lines in a spreadsheet
From Excel - Access run saved import then open query design view
Code to get the primary key of table using ADO and VBA
Do I need these lines?
Extracting data on multiple files from one folder
Repost - Set print properties in programming?
Populate userform fields from access database
Limit to hours in elapsed time format?
Record Selection by Current As of Date
Run Existing Access Query From Excel
Changing filenames in a folder
HELP: Update a password protected workbook and save it as unprotec