Excel Programming [Archive] - Page 8

Autofill Formula
Conditional Format Syntax Error
Passing info to the Workbook.Open event
Sending Emails
Extract multiple data to other cells with same numbering
Problem Applying Formula to cell
Separate first and last name in two columns
how to check if a number has no more than 2 decimal digits
Which version Excel created file?
Selection based on partial input
Conditional Format
Named Range
This one is For all the accomplished MVPs.
Getting the entry of a Named Range
Code to find all / next in a row of data
Array range error question
SUMIFS BY MONTH
Drawing in VBA - compatibility between Excel 2003 and 2007
microsoft 2008
senin - sabtu
Alternate Shading for non-bold rows
Re: Extracting a number from a multiline-entry
What VBA function returns cell 2 from which cell 1 gets its value?
Lookup value, but between dates
Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1to be repeated at top
random selection of rows
Help with printing rows and/or columns
Help with drop-down box creation
trim a range object
Pivot Items Visible
Making A Particular Wooksheet Active
Turn off all error messages in Excel
Type mismatch error using Sumproduct
Columns Grouped
Making a sports league schedule
Prevent user from Inserting new worksheet
Copy Rows Based On Criteria
Setup dropdown list that selection references another dropdown
Using VB to pull formats and data from another workbook
Pivot table and it's macro
Excel Function
How do I programmatically select various ranges in vba?
Populating and Comparing Arrays
In XL VBA, Word Document SaveAs throws error
Where to ask- running Excel from .NET?
Add Page Numbers to PDF
Macro Please
how do i bring a visual basic form to the spread sheet?
Creating a Required Field
Programming question
Do loop or For Next with data from cells
Events copy and paste
Can I do without using VSTO
migrate xls app 2003 to 2007 -- get custom macro button out of des
Macro for blocker from using cell range
Sharing macros
Email Help: Email with voting buttons from excel, Body gets delete
Why Excel process is still there on Task Manager list
E-mail from Excel
Save file to Specific Directory - then EMAIL
Saving a Macro Button on the Quick Access Toolbar in Excel
How to do it in macro?
Saving files to Sharepoint site: error 1004 (can't save file)
cells() property?
create a macro that opens, edits then closes cell
how can i search for sheet with any part of sheet name
Type mismatch: array or user-defined type expected
what is the code cann make this pls. help me
how do I find all the rows containing a specific value in excel
Macro slow when copy and pasting
Advanced filter VS formula in cell
find item in coloumn
date format
date format...3.1.2010
date format...
Excel VBA: Reading data from HTML-file
Copy cell values to another sheet
Merge 1000+ cells into one
Organising sales data by month
Macro to copy a VLOOKUP formula - Data with a filter on
Distinct items from recordset
Change color on faceid 3077
How not to display any pop up message for macro?
Protect Worksheet Macro
make it text in vlookup
case is string contains string?
Local cube files
sumif
HELP: how to locate objects on userform from VBA code
show and hide a drop down list
slecting averages from a changing table
application.statusbar updates freeze
Open Referenced Add In Workbook as Read Only
Question on pivot tables
Advantages and Disadvantages of Referencing An Add-In Workbook
How to Update Selections for (Numerous) Validation Lists
between
I need help with this Subroutine!!!!
Lists not working w/ userform
Search for userform or procedure name?
dynamic references to content in closed Excel workbooks
Can anyone help with a macro?
VBA IF THEN with an OR
Complex Excel formula help
How to determine which sheets appear on opening a workbook.
Formula appearing instead of result
Importing number with dash changes to date
How do I create synchronised lists in Excel?
Copy and paste rows from one wksht to another based on cell value
Application.SendKeys & Printing
Extracting a number from a multiline-entry
Organising large amounts of VBA code
Chip Pearson's VB Object references
How to set cell validation in excel using name range?
Why macro cannot refreshall?
dumb question about subtraction
lookup
Date Format returned from Userform to Excel worksheet
Reading from a dat file
Dropdown list items and item IDs
move one cell down
User Form Date Field disappeared!
Delete Blank Rows when Pivot Table included on sheet
Problem with exported text
automating data copy from dynamic invoice to single spreadsheet
CopyPicture from Excel Range to Power Point
Extracting data from an excel spreadsheet
date tracking
Pick numbers
String of numbers
Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
Help with DDE - stock feed
Excel VBA Populatig UserFrom Contols as Design Time.
How to retrieve value from specific cell value?
How to set TIME condition for if-statement?
Manipulating Table data
How to code it in macro?
Sort a Column
How to code macro to disconnect internet connection?
Prevent cursor/focus from moving
Ribbon Customisation
Extract last name from Last, First
Build a String Sort Key, sort a 2 dimen array Mar20
odbc connection lost
Combined Cell Value
Time duration calculation
copy a hyperlink to another cell
Letters in the code
How to code it on macro ?
What is the bar and function name for refresh all?
Hiding rows
Calculating Distance in MIles
Choosing a drop-down menu selection returns value to another cell
Acos trig function
Making my App only work so many times
Reconstructing a table with Arrays
onGetEnabled
Hide Rows if all values are zero
covert invoice.GIF to excel database
Macro Error that I connot figure out
Excel 2007 export/import datetime
Object variable not set error
How to make weekly totals change as the days in the week change ye
Macro
Macro to extract data from multiple Excel files
HELP: Email body deleted when I receive voting response
VBA: Insert rows
Deconstructing a table
SaveAs FileFormat
e-mail issue
EXACT function - but where does it not match?
Data Entry Form
Deconstructing a table - How to take a table back to the begining
Macro to Delete Duplicate Cells
Dependant ComboBox on a UserForm
saving And rename source file
Copy question
Advantages and Disadvantages of Referencing An Add-In Workbook
vba format question
Triming trailing spaces before using Match on columns of numbers withleading zeroes formatted as text
prioritized assembly data
XML Suppress Keytip Auto-Assignment in Custom Ribbon Tab
Ribbon Customisation
Select all rows till last row with value in Column A and CopyPaste
Accessing Worksheet stored within Power Point
Unable to change "Enabled" state of an Excel 2007 ribbon gallery b
How to Reregister a given Excel version
Cdate does not help
problem with conditional formatting and VBA (excel 2007)
How can I make this formula work?
Can I freeze columns in a listbox
Making a cell mandatory if another cell has a particular value
create email when the cell value changes
Prevent edit on combo box?
Urgent Help needed!!!!
how pass array to a function?
How to do it in macro?
Help!!
Digital Signature?
lists not populating userform
Is there a way to test if a control exists on a userform?
cell to have comma-delimited values based on text
Excel 2007
presenting a list to the users
Number with dash is importing as date
Closing workbook open as CSV
Object doesn't support this property or metheod ERROR
Macro Please
update links - source file open
Opened applications
show download progress to user
Re Post Please help: Listboxes question
Calcutate SUM of column in first blank row
Bug with the function Round !
need help writing a script Hiding a range when a cell with in is greater than 53..
How to get notified when user inserts cells, rows, or columns in W
Evaluate v. WorksheetFunction: best practice?
Loop through a range Open a file
Close Referenced Workbook if it's No Longer Referenced
Simple IF give me nothing?
Programable Controls on a Chart
Unable to get TextBoxes property of Worksheet Class Error
appXL = CreateObject("Excel.Application")
ActiveWorkbook.PivotCaches.Create in Excel 2007
GetObjects chokes on apostrophe.
Run time error adding controls to form programatically
Listbox scretch
Data Validation circle cell position
Pull data (sumif?) from an external workbook
Copying and pasting values to the last available column
Copy and paste
How to set time within macro?
How to do it in macro?
question using SUMPRODUCT
How to set time for processing the code?
Create Range of Visible Rows only
Create a list of pre-named tabs
Create Hyperlink in VBA
Referencing another field if result is N/A
Auto copy and insert a defined number of rows as defined in a cell
Automatic filling of data
International Range style settings
delete rows that have a duplicate id keeping the upper row
selecting cells to produce a pivot table
Problem copying named range
VBA access to a series, after it was assigned to an empty range
Declaring variables for use in a Module
Automatically start a macro after data refresh
DIR
List of Displayed Pivot Items
Excel Open window customization
How do I code the cloning of an object in vba?
Cloning an object which contains a collection
How to simulate a click into a textbox (shapes)
Filling right header/footer with barcode
List Listbox data in column
How to open a workbook into a new Excel application
format on change event
delete rows which have a one in them
Macro to delete rows
.Text .Formula .Value to replace copy_paste values?
Re: save as - location or default
Set certain cells to print and others not to print
Excel automation fails from PowerShell when PIa are installed.
referencing a workbook using string var = error9
Combo Box
.pdf file not working in UserForm
Need Help with a cell?
How can I use a collection inside a class?
Date dependent macro - run once only
Clearing used range?
Determine the Empty row and/or column
List of tables in SQL server database
Looping code
change date in a sql statement from a cell
Getting output from the TREND function using VBA
Matching Data between 2 Tabs on Same Workbook - then calculating
Copy subset of Range
Determine number of rows with data
Self Signed Digital Certificates.
using excel formulas in VB coding
Unload UserForms
format a formula to general (not text)
2 Dim Array Sort, on any columns, ascend or descend. Guidance des
Convert Pivot Table to Values in Macro
Allow only one value in range.
Password To Open Spreadsheet Used as Variable in VB Code or Macro
What's wrong with this?
Autofill Formulas
Open hyperlink - how can I check the page has finished loading
VBA Conditional Formating Using Logical Expression
move row to next sheet
Chart Print Footer :: Excel 2007
Remove Focus from Form
Code not working
Change in Cell Value
Return 1 of 3 different values based on multiple cells
Simplifying an If(OR(…)) statement
Stumped - Problem with Macro Security settings?
Auto Populate a Template
Addin instalalltion throught a vbscript
macro pointing to wrong folder
Multiple row insertion on various worksheets
UDF Not working
pdf file in a UserForm
How to write Property Let for the single elements of an array
Recall a file
Code To Insert Blank Rows
Open Workbooks
List Listbox items in column by macro
Re posting Please help (Macro for Special Sorting)
Get Range object from Cell Row and Column No.
User Account
Calculating calendar days and completion dates.
Checking specific text string in excel files stored in a folder
How to activate a User Form
Problem using Match on columns of numbers with leading zeroesformatted as text ???
active worksheet
Populate User Form Text Box from Worksheet?
Merging row data in Column A has duplicate.
Select range from ActiveCell do to Lastcell in ColumnA
Select range from ActiveCell do to Lastcell in ColumnA
Using Variables in Two Workbooks
How to use structured reference (ListColumns) in VBA
Printing multi-page and multi-orientation excel tab to PDF
Fill column question
How do you set up backround with multiple pictures?
Checkbox activate Combobox selection
macros disappear in Excel 2003
Copy part of text file
Dynamically Adding Textbox Control To Frame Object in VBA (Workshe
Can someone explian to me what this line of code does?
dynamic reference to data in multiple closed workbooks
Minimum row height
Excel Date format changes
Place a cell value on Charts
Configure macro to run on all sheets Excel 2k7
For Each loop doesn't work on First Pass, only on Second Pass
Picture AlternativeText property Equivalent in Excel 97
Color fill based on multiple conditions
Fill with Gray if Column b is bold
Macro to Check Dates
months to full calender year
Minimum row height
Auto row fit height
Wildcards and Looping
paste values without copy-paste values
test for exernal links
Send email from excel to notes - save email in sent folder
Strange error message when loading a collection with an item of userdefined type
Copy row when value NOT found?
TODAY() and NOW() being reflected as zero
Show Activecell Date in MsgBox
How well does MS Office 2003 run on Windows Server 2008, IN PRACTICE?
Macro for Special Sorting
Sorting with VBA (Tough)
LookUp If Greater Than and LessThan
How to handle dynamic Array properties in a class module?
column copy
Best Method
Populate combobox
Bubble Sort failure, Strcomp with binary compare
Need help with chart formatting
Remove characters
Used Range and Source data of a Pivot Table
Selecting from a randomized list
collect data automatically from a folder
Changing tab color locks the worksheet
Word wrap and height
User Select File on Import External Data
userform in the VB environment
PDF document that has Text Entry fields
activesheet error
Marking found records in Workbook A from Target List in Workbook B
Trying to write a query
Project Window does not refresh?
Make Worksheet Deactivate Event only run once
Problem creatting charts with VBA
Novice question: I cannot get the immediate window to work
Autocomplete
how do i include an excel formula in a vb string?
Convert Date-as-Text
vba excel 2007 data mining
Code to copy worksheet
statistical database attack verses defense for online game
How do I sort worksheet without affecting formula values?
Lost a radio button on a sheet
allow sort and filter on protected ss
VBA Excel Macro worked for 2-years now dosen't??
problem with ActiveSheet.QueryTables.Add for text file
Auto complete a row
AutoSave
Carriage return character shows in combobox
Is there a work-a-round i can use for making a datagrid....
link in macro
GetOpenFileName
Excel button problem
Save
Choose folder with largest filename number
LinkedCell
ADO - Access to Excel
Conditional Formatting of Percentages
FYI: Microsoft admits Office patch gaffes
Can't create recordset to populate userform combobox
Data Validation Lists - Generating a list based on another list'sresult
Open a file in another Workbook
How to get notified when inserting cells, rows, or columns in Exce
Repost - checking date of latest Forefront updates
VBA: Paste in a range
mstsc from hyperlink
Excel VBA ?
Start a macro from a change in a cell value made by a formula?
Dynamic Price Change Calculation
VBA-recovering a broken link
Notify user macros are disabled.
Excel events appearing unexpectedly
Merge multiple worksheets into one
controlling chart location
Trouble with modifying cell right-mouse-click context menu
find mac address of my own computer by excell macro
Novice q: allow user to select worksheet in middle of macro
Change Selected cells references
Activate Windows explorer
Stumped on Object Variable not set
#Value! cell
UserForm as Reader
Setting column width on different computers
worksheet_change becoming active just by entering the cell
Change a default Excel warning
Click on a Pie Chart
Editing a Chart on a protected worksheet
Using data from cells in a Query to a MS Access Database
Opening Text Files and Re-Saving Them
wkbModel.wb_Activate
Find last user of computer from ActiveDirectory using Excel/VB
Excel 2007: Formula bar text flicker, can't access other openworkbooks or close Excel.
How to hide macro so as to protect them from editing
Excel Crashes after updating workbook from User Form
Merging all the sheets in the folder
Forgotten password
Re: VBA Passwords - security
Determine when Enter Key is pressed in a sheet??
test
Buttons re-assigned themselves to the right macro name but in Book
Folder location for Addins
VBA Passwords - security
Paste to next row if cells are not empty
excel 2010 question regarding determining the last row
Formula causing run-time error
Would like a more efficient way to Copy/PasteSpecial
Select contiguous cells by ActiveCell.Interior.ColorIndex and applyborders
Passing Parameters to a Pivot Table
colorscales, icon sets, and databars referring to remote cells
Maintaining variables after program ends
Macro to copy and populate an egsisting ssheet and save it.
Syntax Error Help needed
.StandardHeight property
Convert date (m/dd/yyyy) in text format into an excel recognised date
Referencing Chart Data?
VBE Toolbars and Windows
Clear contents of last two rows of data on sheet
code for Allow Insert Hyperlink
Is there something wrong with the random generator in Excel?
Excel
Connecting to Access database to populate a combobox.
In VBE, how can I set a date format different than the system date
Macro code mod - add tabs/apply to entire workbook
Calculating relationships in table
Compare worksheets
VB to specify criteria then paste to a new worksheet
Freezpanes address - apologies for incorrect post
Referencing other Office programs in a Excel VBA App
Simple shared code library, also how to find spreadsheets with macrosin them
Genrate random numbers using the binomial distribution
Problems in copying a Collection to another and removing elementsfrom two Collections
Programming involving applications other than Excel
MsgBox instead of compile error
Is it necessary to Set a Object to nothing before referencing itagain to some other object?
Delete duplicate rows of data
Saving files automatically
Message box warning of missing data
Replace Worksheetfunction.ln code
Select range from ActiveCell do to Lastcell
Highlight
How to know the correct height of the row
Msgbox if cell is not a value
change date format to excel format
Select specific worksheets & copy - code problem
Copy cell range to another sheet
Error Handle problem
Adding date and time to cell programatically?
touch screen apps
linking cells in a column (result) to cells in a row (source)
Pasting to Cells to the Right.
How do I use Filesearch now that it is hidden in Objects
Suspend Scrolling in a split pane
Odd behavior using CONCATENATE
Control to pick time?
Printing of option buttons
Check if value does not exist in range.
Find if value does not exist in range.
Macros Help Needed, Thanks in Advance
Searching question
Repost - checking Forefront updates
name manager?
Copying Data from a workbook to another workbook
PivotTable: formula for added & removed
Pivot
Lost locals and watch windows
BeforeDoubleClick Event not working
How do I make a Binary Search Algorithm on Excel?
Index match formula required
Personal.xlsb problems
Create OptionButton at run time
Delete ' from date
not like syntax in querry not working
GetSaveAsFilename
How to print with a gap in the middle of a sheet
Conditional Formatting VBA Multiple Numeric Ranges
Modeless User Form Is Blank
VBA-Protect Row
How do I add numbers in two column based on the date in another?
Select range from unopened workbook
update in the workbook by different users
Find Value in Workbook
Out of context error in user defined function
WorkBook Custom Properties
Dependents problem
How to reset the range name to refer to another cell?
Special problem deleting a folder
Call Stack Available ?
Spliting Names
ShowDetail
Convert decimal digit to integer
Excel Crashes when trying to open a User Form
Need help with VBA help
Unprotect Workbook with Function
Why does column revert to date format after setting to numeric for
ComboBox and rowsource from an external sheet
Structured Table Refs in VBA
if / then structure with macros
Manadatory break after 10 days of work formulae
Manadatory break after 10 days of work formulae
Reliable send keys
WorksheetFunction Calculation Error
Error 1004-application or object error
Chart datalabels linked to cells
Command Button in Excel 2007 Chart
Modify code from paste values to change font color / multiple rang
Excel TextBox Control
Launching from IE
API License
Need a accumulator driven from second cell
Error 2007
Help with Microsoft.Office.Interop and c#..........
vLookup with comma break
Comparing and updating sheets.
If statement in macro to find blank cell/value in another cell
Problem with Worksheet_SelectionChange
Excel 2003 VB referencing #N/A not working but works in Excel 2007
Custom XLAM tab not showing up when excel is opened from word
How to add a worksheet from template without duplicate cell styles
Retrieve part of a calculation
update sheet with data at bottom of present data
Freezing Header Row
Userforms with CommandBar Popups
Link Drop Down list with Pivot Table
Inconsistent behaviour of attributes accessed through structured r
UserAccounts.CommonDialog - How it works
reading data from .xls file
Excel instance isolation problem
Manipulate filtered data
SFTP
Password for running Macro
Timer to detect idle time?
Adding daily updates to other master sheets
Enter event in textbox control?
Situation when file is "read only"
How to code macro to import web link and avoid frame within HTML?
Last used row within filter
VBA code to paste data based on condition
compare value of cell in one sheet to range of another sheet
Calculations not keeping up with macro
Responding to Keypress event on a sheet
using formula =sum('*'!A1) in a macro does not work.
val() is not work in my code
VBA, refrencing a range
Distorted display in spreadsheet apps
conditional formatting of cells based on result in hidden cell
Excel 2003 vs Excel 2007 #N/A in VB
How do I insert a row ...
Copy/Paste charts , ranges in PowerPoint
How do I find text among multiple worksheets and return the cell .
2007 Excel Issues
2007 Excel Issues
Problem with pasting special merged cells to merged cells
Copy cells from another workbook
Select One
Macro for Thick Borders using conditional formatting
Find records that belong to a combo box value
Save As Webpage - include my own HTML??
userform - list of clients without repetitions
HELP: error handling in VBA
Part protection of Excel 2007 tables
what is the mime type for office 2003 xml formats?
Sub or Function not defined
How can I size merged cells to fit the needed rows of text?
Disable functions on command bar
Honoring page setup of each worksheet
return checkbox value
Do Until Macro
Add text per user input
Compare Two Workbooks
Excel 2003 VBA Editor Context Menu won't open on right-click - Hel
Save to SFTP not working.
Search a range of cells for a specific word
formula help
Autofilter for fixed columns
Selecting two different columns in excel using VSTO
Personal.xlsb counts as a workbook, can I "super" hide it?
Spin Button Programming
Pivot Table Show Detail
How to incorporate 2 sets of changing named ranges
Date find Macro
True/False Checkbox
ADO query eating CPU power
signing VBA Macros for Excel
Hiding a userform properly!
How to Loop?
VB Editor Window
Dealing with unknown array sizes
How to reference a cell into a Dialog Box ?
Copy rows with values in sheet 1 to next empty row in sheet2
Drop and Drag Cell Data
Excel 2007 returns data as 2007 table instead of range - how to turn off.
Copy & Paste cells dependent on value
Excel 2007 Object Model Map
Using a macro for a user-entry password - hiding the entry
no change pivot item.
Input distanct from a map into excel
Combo Box - Form Control
Clearing cells but also not clearing other dependent cells
Chart Problem
Excel crashes on close
Search CSV for string.
record sheet row order, then restore to that point
Macro Running very slow
Clip art in Excel 2007
Macro continues to run
Macro with an IF/OR statement
Determine who last modified an Excel file????
refreshing combo box in form?
Looping through visible cells
Query using list of parameters
List unique items
How populate multi-column Listbox control?
dictionary->(item, item, item); Can dictionary point to an array inVBA?
Check for data in cell
Move macro to Personal.xls
-->edit -->clear -->all; Can removed from standard menu?
Excel Application Warinings and Errors
Can I have default data in new rows?
Custom Header Aligment
Find out, if test doesn't fit in a cell
Placing Icons
UserForm updated
Listbox headers
Data Entry to a Cell Range
measuring waves in the currency market
Apply format to >0 cells
Select a specific row in named range
XML File
Bypass error message to debug
Change code to look at a range of columns not a single column
how do i link spreadsheets on common data points?
i want to input data into a range from a simple input location
Listbox questions
Inserting additional rows and only copying certain columns
Converting MS query from Excel 2003 to Excel 2007
Task Scheduler or VBA to simple copy periodically folders contents toexternal drive
find and replace multiple values in one statement
Sheet Numbering Routine
VBA solution to paste text into megred cells
Working with Both Excel 2003 and 2007
Unable to set the top property of the picture class
pagesetup.printarea Print non contiguous areas # rows varies
pagesetup.printarea Print non contiguous areas # rows varies
Convert Column Number to Column Letter
Help with modifying a formula.
Create a new worksheet and name it
Trapping value before and after change
Formula on two or more lines
Funds allocation by Calendar Year
Working with GroupName in a control
Sort 2 dimensional Array, copy a row
Moving rows in Macro/If statements
The best way to build your own VBA library
Using IsError with Match
Create multiple Pivots based on list of parameters
How to initialize a multi-dimensional array
combobox after change but user hits cancel to message box
Line break from vLookup
VBA to insert date string
i want to input data into a range from a simple input location
Using VBA to gradually change cell interior colors...?
Test Search For: function this community abcde
Month & Year Text to Date Format - Help Please
Strange Range copying
Fool Proof Price Validation Custom Function
What does the Userform.Tag do?
Hlp! Adv Filter - Non-Contiguous rows don't copy
Automatic conditional formatting from a list
Find Next Row With No Value In It - But Not Next Row With No FormulaIn It
How do I save external data in Excel?
Suppress "Opening File" Alert
Sort with subtotal
Repeat the macro using different ranges
Check column header value
Please help me solve my problem
what is the formula for what I want to do
vba Function code
Program stops (creating pivot table) when too many records
Find then paste
Match the value and highlight offset
object required
Using Date as a Variable
formulas
Centered Overlay Title in VBA
Application-defined or Object-defined-error when changing color in
inserting columsns variable range
Spell Checking on a protected sheet
Message still appears with DisplayAlerts = False & SaveChanges:=Fa
help with dates in the past
macro copy and paste criteria
Web query - one table multiple pages of data
Bluecoat
Checking latest Forefront updates
Display Print Dialog with Selection: Excel 2003
Open a file and execute code
How to execute a dynamically added or changed module
Data Validation -> Validation list is larger than the cell width
Excel runs slow
Info in F but AF and/or AY no info so delete the rows
Retrieve File Names in Directories
Select a file to open
create pivot chart in vbscript
Call
Need help to read Pie Chart Series Range
Exporting PivotCharts and PivotTables from a workbook without"breaking" them
ScrollIntoView Non-Selected Cell ..?
Dates converted into text
Date format problem
Date formatting
MS Excel 2003 - Advanced Features Add-In
"implant" ActiveX ComboBox value into if eq'n
set scroll property of ActiveX combobox in spreadsheet
Macro Compatibility between 03 and 07
VB list box print reports. Known # of columns. # rows unknown
New to Userforms - need return value in a cell
SumProduct basics
Loop Overwriting
Dates prior to 1900 are text
Error trapping not working
VBA code for VLOOKUP - linked to another workbook
Macro or Formula
VBA online classes
Code to Create Chart
Userform with commandbar popup
Count Conditional Formatting Colours - Excel 2003
Use VBA to update Access table or Query from Excel
Macro
VB and graphs
Excel not opening properly when exported from Sharepoint
Worksheet_Calculate
populate combobox from worksheet in different workbook
How do I find a column number for a cell containing a value
conditional formatting
Copy Data From Varying Lines to One Sheet
Stop macro
IIF statement to hide a graphic
VB Excel Macro
help extracting data from 3 text files to csv
view list of named ranges
find and remove page breaks
2007 Excel vs. 2003
Entering data from a userform into multiple sheets
Insert Rows if Pasting more Than 1 Row
add years to a cell
Calculating age at different points in time
Date VBA
Visual Basic Editor Opening and Closing for User
? Index of Names
Updated Links
User Public Type, circular dependancy error
toggle read only
Can you automate the ALT+ function?
3 month rolling totals
Unhide Columns With A Password
Updating CSV files with ADO
Sort code doesn't work on first pass, works on second
rounding to nearest .5 in vba
bizarre formatting issue
loop until vlookup true
Axspreadsheet datasource
Nested loop Programing Challenge
Split cells VBA
Loop thru used rows in column
VBA code for copying part of a sheet to another, with column widthsand formats
RE: File status = "read only"
If greater Then
Printing Via By Macro for Network Printer
Selecting items from list and attaching ratios to selection
Combobox linked to Custom Views
Check if webpage is open
Private Sub Workbook_Open()
Convert Case
Convert Cells to uppercase
Programatically open Access DB with user level security
How to show a message box ?
Dealing with windows 7 folder structure
input numbers for code
Problem with Word 12.0 Object Library
remove vb project
show column headings
Simple VBA Code Working in Excel 2007 but not Excel 2003 #N/A
drop-down for entire column
Run-time error â€˜13â€™ mismatch type
vba help issue
Identify last date of a specific month
Passing a string to a function instead of a cell reference
Update individual worksheets from Master Worksheet
auto open from any folder
SQL query in excel (VB) using multiple parameters
Paste data from AJ to K
User Form Text Date Format
Formula Help
Number Format with Macro
Copy/Paste Values code
Copying and pasting a range x times based on user-defined value of x
print labels from userform
vb to Unselect a Filter Value
delete ghost spaces
Marco to copy and paste values based on cell value (cont)
Practical Jokes in Excel?
Subtotal multiple columns and ...
Editor Window
Can I use an IF ELSE statment
Update pivot table report filter using cell value
Multiple Forms for Data Entry; re-loading data
Match Ranges problem ,
shortcut for same directory
RE: File status = "read only"
selecting qty to print via textbox entry
Looping
Code so that worksheets cannot be added to workbook
change cell value by code
Printing App
alternate sort on different columns
locate add-in
To disable pressing of Enter key on a sheet
Problem with VBA code not running in Excel 2003
Help with creating drop down
What is Selected?
Autofilling Cells for Daily/Hourly Schedule
xltm saveas xlsm
xlookup & paste a picture
even the codes in microsoft's help section don't work
XL2003 - CreateObject("UserAccounts.CommonDialog")
Excel converter download
Does a workbook become fragmented after much editing?
Startup Notepad from Excel???
Data Array Not Calculating???
Excel macro filter Like keyword
Change Shape text / Color
Extend Custom function
Save command before emailing workbook
Macro to copy paste values based on cell input ...
copy named range & paste values
Parse only text from column?
Copy a worksheet
HELP modifying macro to delete rows if more than 1 condition met &
find sheets with by part of name
Macro to change pivot field with latest value
How to disallow a zero value in an array
copy active row and repaste values
drop down list for IF equation
Excel 97 replace vs newer versions...
Remove lines from text file prior to importing in Excel
Extract only text from column
"Undo" creates bizarre behaviour
Excel worksheets auto-incremeting question
mark active cell and return to paste
VBLOOKUP BY DEPT
Insert Row without changing formulas
Does Excel Support the VB List Class?
Filter/Display only certain rows of information based on a user na
Moving an active cell
Delete all rows except...
Password Userform Help Please
VBA Select File
Pasting into an active cell
auto generate sheets in a workbook from list using a master sheet
Checkbox linked to calcs
use command button to total datas in cells through VBA codes in ex
Remove duplicates from list using code
Distribute macro to users
XML generating excel charts
Checkbox linked to calcs
Text in cell is not visible! 8(
Check to see if a formula is correct
Collating stock market data
choosing cell to top left of visible window
Test named range exists & exclude worksheet if it doesn't
SendMail
Automatically Sorting of Excel Records (Macros)
MSCOMM Control with Excel 2003
truncate date; nix the time component
VeriSign Digital Certificate Failure?
macro to continue running if error
Excel VSTO pivot table code revision help needed...
cpu usage when excel is in taskbar
Conditionally disabling activex toggle buttons
Automatic increment of onTime
VBA code to find first blank cell in a column and activate it
VBA code to "skip" empty rows
Entering Values in a Single Cell to Update Next Empty Cell in a Ra
Detect if Excel file is "read only"???
Another '03 vs '07 Add-in Menu Question
data validation, mouse action of select... then move right
Shorten multiple sumifs
better way to copy data from an embedded html box
Macro to Insert Worksheet with Worksheet Name the Current Date
Error: Microsoft ODBC Driver Manager Data Source name not found
Shift Roster on Excel, pls help
define range using col and row names; not cell name
Import selected worksheet from another workbook
VBA forms in excel
using a command button in excel
Filter Column
Object Heirarchy Chart
Using named ranges in macro
Right Click - Disable item
Copy Values From Wbk1, Outlook Them To Another PC, Paste Them IntoWbk2
Vlookup help needed
How to create a folder & error handler
Hide Rows based on Combobox Selection
Queries created by MS Query not in QueryTables collection
More Useful Row Autofit
Macros in PERSONAL.XLS
Returning a named range source reference
Userform Command Button
Create shape, name shape, add text to shape
Select, copy, insert, then paste.
Accessing Autofilter Lists
freeze panes from vba
Passing Userform Control to Subroutine
Printing App
Macro to Delete Rows if true HELP!
Sort function
#VALUE ERROR
VB: Convert rectangular clusters of # within field: FindNext, Find
Do not calculate or update formula's during macro
Compare row contents to baseline data
Macro/VBA to loop through list of values and output row- Help Need
Who do you read an ini file with Excel VBA?
mouse pointer to be focused on userform command button upon opening
Trigger Event Sub when A1 <> B1
Upload file to SharePoint from machine with CAC
Search for strings listed in column - Excel 2007
Re: cell.value comply with cell.value before and cell.value after
Finding Duplicate Entries - Saving Worksheet if none found
VBA - ThisWorkbook
Multiuse (Single Instance) or Single Use (Multiple Instances)
Payroll,formulas and Macros?
Side Filter
Filters - sort state
Lots of text in one cell
Multiple tabs in 1 worksheet
vbcrlf question
Change Data Connection Definitions from local to sharepoint
Macro needed Fortran to VBA
Need Macro Fortran to VBA
What is the right syntax for vlookup in vba?
Reading a textbox ole/control
Changing page height while in a multipage
Impossible Macro?
Enter data on one sheet and copy to others
Autofill Data
Resetting the chart count
Type checking from VBA to C++?
Links Based on Cell Values
Unfilter a sheet which is filtered
Name A Range
list box controls - text property
Validate to quarter units
Data Validation for Prices in Cells
prevent user from deleting a tab prevent running macro from menu
Find a text
Can't figure out this PasteSpecial error message
number stored as text