Excel Programming [Archive] - Page 17

Reposition Chart Macro
Pausing a macro during execution
[VBA] Sum Range os values
Set cell color with VBA results in "#VALUE!"
Log to a file everytime I open a spreadsheet
Locate a value in a cell and delete rows above
Script to conditionally copy data to another sheet?
Counting Errors
Linking Worksheets
New Sheet Macro
Using a sheet's 'Codename'
Cannot find/see AddIns
Problem with retaining numbers formatted as text after code runs
userform textbox: hit enter to start writing in a new line
How public is public?
How public is public?
Using VBA for Inputting a "-"
How to select a single word from a cell?
Workbook jumps to Sheet1, cell A1, regardless of where it was whenlast saved
Right click - Normal view/ Page break preview
VBA Code
Display custom function
Getting the date from my left footer
Relative references in formulas
question regarding pasting controls
Recording Data
File handling in excel
Passing single-cell vs multi-cell ranges to a variant array?
Referencing cell content and formatting
using range name VB help
Ron: email a closed workbook? possible?
Protect template worksheet
transpose copy and paste
merge rows based on criteria
display $ sign in excel sheet
Correcting "Circular Action" in Worksheet_Change
Mysterious Happenings
Stop all macros in worksheet when left
Macro Creation
Copy a sheet and all formats to a new sheet
DMS to DD
Need a pause in my macro before printing
Adding Rows after dropdown menu
concatenate not working
SUMIF with sections of data
Temp folder location for ACE/JET ODBC driver for Excel/Access
Changed decimal on fixed numbers
Trying to get DOM of web page
Converting range to variant is easy; how do I handle rows vs colum
Run procedure in stored in module on worksheet change event
Conditional Problem Or What?
Macro to insert row
CustomTaskPane Objects in Excel?
Run a Word macro from Excel?
Email: email a user back once his request is accepted
Change number text to Date format?
MsgBox cell address
Need formula dates
Using sheet reference instead of name
AND & COUNTIF in same formula
Excel 2007: Data connection returned empty table
Restore menu & toolbars
Getting objects other than 'Excel.Application using GetObject()
generation of: qty to serial numbers, plus date
How to count number of errors?
Embeded excel's parent
Finding and working with rows that have data in only
Excel Warning Message on New Sheet Created
Closing, Saving question
ExportAsFixedFormat method and print margins
Macros: Why 'wbook.xls'!MyMacro
Inserting a number of rows based on the number of columns filled bytext values
Easy Peasy Explanation required
VBA Code to Change Currency Format
Limit on Column Selection
Cascading dropdowns
CODE 2 SELECT SHEETS LISTED IN A RANGE
Learning VBA - Resources & Stories
Run time error when accessing Internet using VBA
Combining Data from Multiple Closed Files in Folder
Assigned Macro with argument?
Excel Version
Custom images on a button or other control
How to find .Name of leftmost worksheet tab
Clearing data from Excel 2003 Form
Issue With Save As
Why does the Formula in VBA not calculate
Copying Worksheets in Different Books to One Workbook
Efficiency of Code Help
Protectin/Unprotecting Sheets
Pressing Esc to make a form disappear
how to: c.value = "a cell value"
Object programming in Excel
cells that contain data-->unclickable
Sorry for the cross post but this may belong in this section inste
Determine if variable contains a valid range reference?
macro works at home but not at work
copying a template sheet and inputting a formula into another sheetthat references the new sheet
Applying formatting to non-continuous named ranges
Spin Box
OnTime unreliability
Consolidating Macro for Multiple Workbooks and Sheets
Finding specific data and changing cells next to the data
vlookup not working
Conditional Tab Colors
restrict users to input atleast five characters
Mid and Find in macro
Conditional Formatting More Than 3 Items
Unreadable Content Errors
selection of cell at the intersection of column B and the row ofwhatever cell is active
Interactive Macro in Excel
IF statement inserting new rows
Pivot Table Page Break Issue
Vbscript and VBA
Open Text Method Fails
restrict user to enter 5 digits only
Open Workbooks and Password Protect all Worksheets
Comparing two cells
macro code selecting moving range
type mismatch error
VBA code relative to current date
export excel chart to file error
export excel chart to file trouble
Copy and paste error
Enter formula in a message box
VB6 Expected Array error
Export data from Listbox into text file
FOR-TO_NEXT is *very* slow
Disable the toolbar options button
VBA Help
Create a button that automatically fills out data
Anyone know why this doesn't work ?
Select Worksheet Code
Find
Macro help needed
Copy a spreedsheet
ADDING/DELETING SHEETS WITHOUT LOSING FOCUS.
SELECTED SHEETS' NAMES
Subject: Macro for Address verification/validation
error in code
"Out of Memory" error in editor
Formula
Macro question
auto fit & horizontal alignment not working
Assign a range-name from B2 to {end of data}
Indirect/match formula - array
expand or collapse
Spinner
Use button to add 1 to total
I want to insert "n" records and then copy the formulas to them
Sorting hidden cell
Locking/unlocking cells based on column headers
Using Macros on the Web?
Renaming wrong worksheet. Why?
Help in creating formula in a macro
Find text string and move contents to another cell
Activecell select properties
Worksheet arrays in VBA
Date to Text conversion
Macro not working with XLAM add-in
Remove Hyperlinks
Return Portion of Variable
Update Excel Column Data from SQL Fields
Insert Row based on count and copy range to inserted rows
Multiple Workbooks Using the Same Custom Toolbar
placing calculation based on two sum fields in loop
Shapes.AddShape msoShapeBlockArc...ShapeRange.Adjustments.Item(1)
separar texto de numero
Automatic Crossing Axis Values
UserForm Issues
Opening Internet Explorer Only from VBA
Auto-Populate
excel programming
Open CSV File
Re: Auto Fill Columns A and B with varying ranges
Clear "Blank" cells
pick out arguments from formula
Hide cell select border when clicked
Prevent saving of files to P:/ Drive
find last updated row
email issue: need last user input only
Match and Extract Data
Viewing a .doc in excel
Excel freezePanes not on non-active Workshhet
Re: Quick Macro Needed
Issue with nested data subtotals
Close w/o saving changes
UserForm Variable
How Do I Change Two Pivot Table Page Selections with VBA Code
save as - to any desktop
macro for deleting a particular string and inserting commas in it
Reference to external program
Looking for an example
Transferring data between worksheets
Re: Msgbox when a cell with a specific text entry is selected.
stuck on the timing refresh....
Apply Conditional formatting if cell contains formula
Last row in a particular sheet / workbook
Hi All - How do i get my vba macro to refresh every minute?
distribution of Excel Addin - errors
[Ask] Triangle Distribution and Latin Hypercube Sampling
Vertical Scroll bar w/ picture background
Run a macro when sheet name changes
Hide Ribbon In XLS Workbook When Using Excel 2007
"Highlite" a "row" that has a "particular date"
create new sheet with zip code as name
Code Not Recognizing Decimal
Changing Path of .JPG file?
email only current entry, not the past data
Hide rows based on cell data
Excel 2007 VBA - macro stops after autofilter command
Show Method/UserForm Object
Postgres
Sum At Top And Move Cells Down in VBA
Advance in a cell range using VBA
Toolbox showin up during running time
combining data from 2 sheet into new sheet based on like values
If Then Conditionality Help
VBA Chart
Macro support for Mac
Multiple names Print_Titles
MDX query in Excel
remove autofilter on close of workbook
Conditional Formatting adding different cell dates
Copying and Pasting Macro from one worksheet to another
chart series macro
Re: Clear cells in a column that contain 0
Remove File import using VBA
Passing Arrays Between Worksheet Functions
[C#] Excel Print Dialog
Problem in Using Control Tab to scrol trough several Workbooks
Save Archive Copy as Read Only
Skip / Execute Macro Q
Inconsistent Formula Result
Data Transformations
drop down deletion errors
Code to delete shapes in copied sheets
Lock certain cells from edit- test if select cell name starting wi
FormattingLost
Multi Column Combo Box
How to find table position on page
Sumproduct in Macro
Userform and Macro code
Require Password to overide data validation
Run MS Excel Macro From MS Access
Excel/SQL Automation help
Import File Line by Line
Iterate through the autofiltered rows
Worksheet function - array result, C++
Re: Create Workbooks and then create Worksheets within them
Re: Shift a cut row up
Convert Full name in Intials
Close help
creating last name first, first name last from a column of first name last name data
Hyperlink Back w/ locked worksheet
hyperlink to top left 'between' worksheets
using UCase
Adding Variables to a range with quotes
just curious Xlpart xlWhole
charting run time error, Excel 2007 SP2 problem with SeriesCollectionand .Formula property
Recovered file has "File format is not valid" error
recognizing the day of the week
trouble assigning array to variable (variant) runtime error 9 please help (ignore correction, this didn't appear for some reason)
Building a dynamic right-click context menu in excel
Mail sheet template for Excel 2007 and 2010
Correction to previous post re runtime error 9
Runtime error 9 subscript out of range - assigning array to variable
How to find invalid formula references with VBA
how do i get the Genetic Algorithm in Excel Solver?
Stuck at Trying to Extract Data from a Website using JSP
'Save As' Macro Debug Error
Find macro on columns A,B and C.
Protecting a range or cell in a worksheet Excel 2007
Changing select ranges in VBA
Select all, but one, sheet?
run sub when one cell is changed
run a sub only when one cell changes
return a value from a vba function in another xla
Re: Query run automatic update
Macro to cause a password to display ooooo's or other symbols
Re: piece of code keeps failing....
prvent viewing a workbook
Re: Multiple entries from a drop down list
Re: Create new workbook and new worksheet and close. Worksheet not saved
Re: Parsing Variable string
Re: Check Date, Include dates from rest of month and all of next month
form follows user's activity on sheet and updates itself
can't find project or library
help with copying of excel spread sheet from template trought VB
Argument list of Dialog box objects show method
Diary Page Printing
How to refer to an ActiveX Control itself in event handler?
Formula/programming in excel for cinema movie scheduling
Insert Row Event
Counting TextBox values
Re: referencing multiple controls using a variable
selectin the whole column beside the target cell
Question about input boxes
Colo's Junk Room
Re: How do I save a password protected .xlsm file containing old macro
I need to get tthe sum of cells with certain colors in a range.
Private Sub
Compile Error "Invalid Outside Procedure"
UserForm Hangs
Command Button
Current Document Name From Ribbon Control
RE: Customized Tool bar
RE: Customized Tool bar
creating variables
Drop down errors
Unload a Form using SelectionChange
Which workbook caused calculation
Still not flying
Run portion of loop when value in column changes.
Saving the revised date for any workbook.
RE: Obtaining AutoFilter Filter Settings Automatically
Save Excel 2003 in Excel 2007
Constants
Re: Validation
worksheet change event running slow
Re: Validation
Re: Msgbox Based on Cell Content ???
Re: workbook open in looping
Function in Excel
Form Control vs. Active X Controls
REPLACE HELP
Re: Assigning a button to a subroutine
Save specific sheets to new workbooks adding tomorrow's date to na
help on comparing datasheet with a master sheet
Customizing row color
Sort error?
synchronising data in 2 excel files
How to add my own icon into modify button symbol list?
Can I pass arguments to my formatted empty spreadsheet file?
Paste formula in numerous worksheets
Creating Pivot through VBA
Split data into multiple worksheets by row count
hey guys, thanks for all the help with the loop problem...part deu
combobox rowsource = named range ??
ActiveWorkbook.Save - adds quotation marks to the file content
IXMLDocument
Create a Macro that help paste the lot#
Object Library invalid or contains references to object defintions
Excel 2003 - SOAP
Excel 2007 : Excel is crasing if hyperlink is click on the workboo
Dialogue box ghosting
Impossible? - Close code
RE: Customized Tool bar
UserForm ComboBox Date Format
temporarily disabling subroutines
Re: Quick Macro Needed
Help with Access query from Excel
Stop a find after the last occrance of the search value.
Possible Macro Solution To My Problem
General Thanks
Is it possible to use a macro to type numbers to another applicati
cycle through hyperlinks in column b
Array speed
find row address of target cell
Simulating tab stops in Excel cells
Worksheet Number Max
Issue building pivot tables with certain names
counting values as they turn up in a column
I can't figure out why these lines don't work
printout as jpg format
printout as jpg format
Look up values in a range, then summing from another column
Copy changing group of cells from Sheet1 to Sheet2
Formula Help
Long Macro
Interactive web browser object embedded in an Excel print
How to set chart series border property with variables read from cellvalues?
How can I detect change to Autofilter selection
Turn off Security Alert dailog box for office 2007
fresh start/better explanation....totally stuck on loop code.pls h
delete a shape
VB, Vlookup worksheet function and copying data
SaveCopyAs and FileType
Count down display
Convert Date to End of Month
End a procedure form a UserForm
End a procedure from a UserForm
Toggling display
Extracting account details
Image Control
Conditional Formatting with reference to another worksheet VBA
IE Document Object
How to return special values from function? (Excel 2007 + VS 2008)
Collapsing groups in Macro
Autofilter on a combo box
Changin Number in cell on click of button
Totally stuck trying to format,loop etc...re-post.please help
Totally stuck trying to format,loop etc...please help a novice!tha
Workbook doesn't fully close - sorta
Count number of appearance in a cell
helllp!
Is it possible to Protect all Cells that are, say, Colored Gray?
when I create a chart for the first time,
To be able to show only certain sections of worksheet
Paste special VB code.
Autofilter method of range class failed
Move line as Worksheet change not working correctly
Is column below title row blank
Digitally Signed Macros in Personal.XLS
Retrieving Key value from dropdown
Open Referenced Add-In Worked as Read Only
Merge Cells Complexity
Using a macro to delete cells from any row
Error - Replace command within access acting on excel file
Date as filename
Deleting Shapes
Hide/Unhide Multiple Sheets
Code OK in XL2003 but Run-time error '1004' in xl2007
Referencing Inactive Workbook Cells
Picture Load in Image Control
Reset AutoFilter in code
Adding quotation marks to each line of cell contents with carriagereturns
Similar Function in VBA - does it exist ?
Clearing IE cache and cookies through VBA?
formatting ms access to ms excel report
Re: Extract only part of a string
paste special code
HELP... Pivot table sorting
Setting page layout and print set up in code for a new worksheet
using vb to change row height for a whole worksheet
Export to CSV values
Proper syntax for selecting a range using cells instead of range
Looping(Rookies)
Calculation based on 2 seperate ranges
Looking to Pay Someone for Help with Excel VBA Script
display special characters in some textbox fields to ensure data f
Another Vlookup for VBA question
If ElseIf statement can not adapt to new data?
Button points to wrong macro
unprotected cells
Change the Mouse Pointer on a Excel Worksheet
copy past two existing sheets into 30 workbooks
Error 1004 SaveAs Object workbook failed
Set value of checkbox on userform without triggering Click event
How record each refresh?
How record each refresh?
Conditional formatting Cell Value Attribution
Copy a worksheet that can be attached to a web-based internet system
excel working with desktop application
run multiple macros from drop down list
Syncronize Autofilters on Multiple Tabs
MSAccess output to Excel losing formatting of number
Loopng through specific worksheets
Insert macro using current workbook
How do I attach a document along a column?
Textbox mask for textboxes in my Userform (Excel 2007)
Which Excel references used for Workday Formula in MS Excel 2003?
Programming a column so the it displays the lesser of two values
Searching multiple fields and then print the entire row from resul
Reference Library Upgrading
Activate / deactivate a link based on the value of a cell
Setup
Workbook_open not running and Phantom Projects
Create new workbook and new worksheet and close. Worksheet not sav
Hyperlink cell change color upon activation?
Fast intro to dictionary object in VBA/Excel
Automate data from Web to Excel.
Exporting data to excel file with code
Hooking into Refresh/RefreshAll events from listobject
Select a Sheet Issue in VBA on a very hidden sheet - fails
If statement(rookies)
Excel automation from a Windows service
Forms and WorkSheets
Change InputBox Range Selection to Column Letter Selection
Unable to specify position of InputBox Method Dialog Box on the sc
Identify offending cell
Dynamic filtering into a new range
Macro to add sheets works sporadically
Working down a column
Loop works for x = 1 but not for x = 2 : gets Type Mismatch error
Export a module to .bas file -> No Password
Adding a -L at the end of each number within a column
my VBA procedures stopped calling other procedures in excel 2007.
Using Worksheet Objects from PERSONAL.xls
Incorrect Function error
Identify row based on criteria and copy paste special values only
Help with Office Assistant VBA
Open Excel file
formulas not auto calculating and will not calculate
How to Load Combo Box with Named Range
combobox problem
.DisplayFormulaBar = True doesn't display formula bar...
Text & Colour Hi-lite of "blank" cell
Transfer data between two worksheets
Need to Speed Up A Macro
How can I stop my workbook being attached to an email?
Extract only part of a string
ReSizing InputBox Parameters
exclude hidden worksheets while merging.
Sheet Deactivate Loop
for next coding wants me to define variable...
Question
http link
Custom color in Excel 2007?
Find variable with the highest value
Excel doc saved as an HTML file - can't unhide worksheet
Compare 2 ranges
Match Values and Copy Rows
Workload spreadsheet - pivot tables
Help with sorting lists of data.
Minimising VBA Code
modify macro to execute based on current path
How to save/move a personal workbook
userform question
Display of gridlines
Draw on image object on useform
Creating Email using Windows XP, Office 2007, Outlook 2007 "worksh
Get External Data returns error message
Copy an Access recordset starting with Column 2
Can You Reset a shape's Left & Top position
extraneous data in macro recorder
Network Computer Offline
Help organizing large program
Network Computer Offline
.find not finding value
FUNCTION TO COPY STRING ARRAY !!
Run Macro when a cell within a range changes
Multiple line controltiptext
Write select columns to array & back to another spreadsheet
Launch msn messenger box by clicking on a name in excel? Help! Urg
Automatically Deleting Comments In VBA
Calcuate 2 days prior to TODAY
Locking An IE Window As Active
Info Message without a response needed
Problem changing numbers in a string
Open Excel file stored on Web
colour coding alternate weeks
Re training expiry date formula required
2nd highest value.
Macro creation via VBA
Listbox Validation
Mouse double-click to select listbox item and run userform
BOOLEAN VBA FUNCTION !!!
Excel 2007 MS Common Controls
Macro to copy existing sheet to end
Macro To Automatically Save As
Pasting a date to a cell from UserForm
Randomly choose x numbers from y data block
VBA MsgBox close button has changed...
Using relative references in macro
Copy & paste range
Programmatically press CommandButton
Trap ctrl+Break
Return to starting point
Using Filter List to set Chart Symbol, data labels etc
SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003
#NAME error on all VBA module code
You may not use references to other worksheets or workbooks forConditional Formatting criteria.
training Out of date formula required
How to Learn Macros
input box for a date -- how to make an enter key the current date by default
Label Control
Second Find after a first find fails
Missing:ATPVBAEN.XLA
Parse Duplicates by Latest Date?
Sever side excel automation issue
Last line selected in ComboBox
SearchDate
Re: remove autofilter results with a macro
remove autofilter results with a macro
Macro/calculations/for loops/ dropdown lists/ and fun.
Determine if all items or elements are equal
Sumif
Excel to Open, Fill, and "package" .doc word forms
Switching to Manual Calculation stalls workbook
Check Validation List for Matching Entries at Start-up
How do I get an Excel macro to run completely using the keyboard?
Adding rows
Reading data from CSV file
Merge Cells Logic
Disable 'Select Multiple Items' and '(All)' in PivotTable ReportFilter
Populate Excel 2003 Spreadsheet with XML Data
Macro Shortcut Key
Working with AutoShapes - Adding Text Vs Adding Formulas
Checking a listbox
Excel Range name case sensitivity in VBA code
merge worksheets macro
Turn Off automatic parsing of data in Excel
Fill cell based on cell value
bug in sort routines
display $ in a userform textbox
Generalize sub to work on all open books and views
Date Formula
Inserting results below and not above
Another FileSearch Question Please Read
Excel 2003 Autofilter Alphasort, Hyperlinks and Validation Drop dn
Simple Loop
Create Object MS MapPoint
how can i select the data from 6th row 7th column using VBA
Add Sum to the columns at the last row
Can I have a macro that will delete an email in an Outlook public folder?
TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"?
How to set the text in a textbox in a chart object with VBA?
sorting list to a new place`
How add a value help parameter to User Defined Funtion
List active onkey assignments?
Removing words from a string?
excel 2007 convert one sheet into multiples sheets (for excel 2003Compatibility)
Autofilter with optional criteria
last name first, first name last -- is there a code to combine 2 cells with last and first names?
Filesearch error in Excel
Columns other than one selected by macro being erroneously selecte
shell function + wait parameter
Copy Range from Open Workbook to Active Workbook
Point to "Contacts" in email 2007
ComboBox Problem with ListIndex
Find value in hiden row
Bring data from header fields to the columns
Concatenating Formulas
Help with Macro in Excel 2003
Convert from ColumnNumber to Range(" ")
Circular ref
Counting Occurrences
Why is Excel 2007 macro creating extra blank rows?
Trying to make a form for SEO.
Accelerator Property
Need help with formulas
Formula Syntax Problem
Check if Workbook fully loaded...
Not a programmer...am I in over my head??
Start copying an access recordset starting with the next column
populating a workbook but not opening it
using variable in
SUMPRODUCT IN VBA
File Lister- (Code help) Pull File Name without Extension into Col
Using Vlookup, hyperlinks do not work
Excel to Word help needed
two workbooks
Excel 2007 vs Excel 2003 = Runtime Error 438
not able to enable macro in password protected .xlsm workbook.
Programmaticlly sign and password protect a VBA Project in Excel 2
Populate Excel from Word
text wrapping in coding lines
Code to automatically fill cells
Make a formula work with a checkbox
Budgets
deleting source code without IDE
The long way round seems faster...
Early variable type issue
Prompt the start of an email...user fills in email address
Application On Time
Macro that uses three hidden sheets
Tell what format each cell is in
how to view filter in html file generated from excel?
Bring fields from header to columns
collapse an expand rows using VB
VSTO-Detecting Read Only status of workbook opened from Sharepoint
Have macro force user to selecat a value
Delete duplicates and add worksheet name
Preventing workbook_open code executing.
Excel Combo box & Autonumbering
XL 2003: How do I get every possible combination?
How to take a current Excel file and make it into a program
Automation to calculate the SLA date?
Placing values into summary sheet
Refrencing Excel cells on a Excel file on a NAS with VBA
VBA Offset (trying to resize an element within nested array)
Close External Apps Issue
Text case question
returning data of type range; error 91
Textbox reference
Textbox reference
Textbox reference
Type Mismatch Error 13
Stumped
Preventing a graphic image from being deleted or added
Ambiguous name detected - help how fix?
Referencing columns in formula
Reference to ATPVBAEN.XLS
Counting and Comparing
using .copy to copy a worksheet several times
one or two monitors
protect a sheet such that it cannot be deleted
VBA Regex syntax problems (XL2003)
Trouble opening a spreadsheet
Extract/process Excel files in outlook.pst file?
Essbase Add-in VBA programming question
HELP WITH THIS FORMULA
Separate report on tabs based on Sales Rep Info
Date criteria for adv. filter in code
finding line number selected in combo box
save user inputs from userform in a seperate workbook
Store input from userform in a password protected sheet
Get data from closed workbook for use in a variable (no copying)
find where a number belongs in a series of numbers
Can't change connection property on querytable
Code for avoiding slashes, ampersands, etc. when naming sheets
SAVE AS HELP
Print Preview
how do I copy streaming data values into excel
Rotate Fill Effect With Shape in VBA
Reversing from a Hyper link
Range named Add_Info_** issue
Help with lockiing/unlocking cells in subroutine
Delete & Merge Columns,Delete Rows with filter, etc
Sorting Problem
Conditional formatting using relative refrencing
Disable the PauseBreak key
Macro for Print Area
Counting When Last Occurance
Invalid qualifier with dates
clear ranges
...more repetitive copying
Find and Replace text with formatting
Exporting weekly data from different sheets to a word document
Help with condensing a lot of copying/pasting...
subalterne sub in parallel
Drop down menus
Excel 2007
Pivot table in VB
Delete records from result-cell after a find-function call
Google AJAX API from Excel?
[VBA] Get the content of each value of a line
Align text in a text box
Access to Excel-pivot, changing location of Access
Is there a way to draw a vertical line from a point on the chart line to the bottom of the chart
Looking for better way than .formula = "countif....."
Allow changes to Shared workbook
why does Average only on certain cells?
Re: Emailing excel sheet: Help Ron De Bruin
Too long to save an Excel file
Display Current date
Minimize the ribbon in Excel 2007 using code
dynamic radar chart
Macro to set column widths in a worksheet
"T" function broken?
Subscripts and superscripts
copying down a formula only where there is data
How do I modify an existing template in excel 2007
Excel Run-time Environment
Macro to Copy hidden worksheet to new worksheet
Referencing specific cells in an array of ranges
How can I enable a macro to run in a hidden worksheet?
How to make an excel macro go to a cell a choose value from list?
TextBoxes and Data Filtering
Auto-size the UserForm with Monitor Configuration
vlookup macro in excel
Macro's, Buttons, and 2 Instances
sum of cells that may contain #n/a
Done with Code1 Find Code2
Date Picker Control
Entering a long formumla in Validation criteria
Custom Validation formula for business rules
Find duplicates or missing numbers
VBA Code Locked for Viewing
Using VBA to send out mail via gmail
Programming the treeview control
Date Picker on Multipage
Re: Is there an Excel Function that can be used in lieu of this fo
VBA currency or percent format object
Code to copy and paste based on today's date
Pivot Table Page Fields ~ Filtering for multiple values
attendance sheet
if, then, replace text
Error 438 on With statement
Error on Discard of Checkout
Trying to write a macro that will copy a formula - TIA
Data Seperation w/ multiple sheets
Not saving as xls file
Is there a way to copy a bunch of cells to another workbook, But also bring over the named ranges?
How to rotating a Label control in VB 6.0 to, say 90 or -90 degrees
number not recognised
Open a workbook using a stored name
QAT buttons on template
onmouseover
Exract individual page ranges from sheet
Problem with filename =Heute()
VSTO: Detecting Read Only status of workbook opened from Sharepoin
AutoFilter Criteria in VBA
Trading File
Extra E-Mail in a Column Q
Re: Range("Defined Name").Sort
Check number and return code value
Macro to convert abbreviations to its expansions?
Excel VBA Matrix Operations
increase Range by 1 row, until all rows with data have been execut
vba create text format cells in excel 2003
Re: Excel VBA to acess currently open web page (existing IE6 instance)
Drop down menus in excel
Prevent event macro from executing on ALT-Enter
Re: show selective data - help in code
Re: show selective data - help in code
Re: HELP- Need TSV extension for Excel
Speeding up this code- when a custom function is used many times
Determining Max value in a dynamic range
Excel 2007 recalculating custom function when scrollbar is moved?
Re: Excel VBA to acess currently open web page (existing IE6 insta
Pivot Table Code - Is there a better way?
Filtering info to corresponding sheet
Re-format Date
transpose variable array
One connection multiple unique SQL's
Screen scrolling to show active cell
VBA to lock column values
FreezePanes not working when chart present
Validate same month and same year
VLOOKUP
Problem with reference to Refedit control
Setting Curline to 0 on a text box fails (Excel 2007)
File name
creating folders one level down
Strange behavior with Macro - Import from Access
sub or function argument
Send data to another workbook
Cell Fill
VBA - Monthview working with textboxes
Change workbook name to a generic name
Return to todays date macro
Size of 'find and replace' window
Compare two Ecxel Sheet
Code to copy the last row formulas and paste it in the bottom row
What is excel equivalent for LPRINT please? Thanks
Prevent UserForm from displaying
Emailing out of Excel
End(xlDown)
User Name
accept and decline buttons in excel sheet emailed to me as attachm
accept and decline buttons in excel sheet emailed to me as attachm
Open IP address device with multi ports, read only
convert hyperlinks to commandbuttons via VBA
How to count number of rows with data?
Include cell text in web hyperlink?
Copy and paste only filtered cells
Problem displaying a UserForm
Want to calculate the appointment date and deappointment date?
Always open a workbook on Sheet1 regardless of sheet viewed when lastsaved
Executing Part Of Macro Only On Cells Meeting A Condition
detect the filter mode ?
array udf
Since we moved from Windows XP to vista Excel opens minimized !
Copy ranges in sets of 30 rows into separate worksheet tabs inworkbook
Timer Procedures
Paste TextBox value to worksheet with specific format
projects left open in vba after closing workbook
How to get list of subfolders, including shortcuts to folders?
Solution needed
Transfer AutoFiler list to a ComboBox
How to use the code?
Count With Criteria
Delete single conditional format
Automation to add 99 before any 10 digits?
Change PDF Properties via Excel Code
ComboBox Rowsource question
Setting Up a "Reply-To" Email Address In MAPI
Save Sheets In Different Files
Transferring data between worksheets?
Simple macro, even simpler programmer!
Edit Locked Cells with UserForm only
Delete row by color of font
Help with mess of code
Select next blank cell in column, before running macro
Activate Find Results
Clearing trext box values
Instead of a long Case?
Add check mark to cell upon selection
Summary Tab for Workbook
modifying merge all workbooks..
BeforeSave
Creating popup messages for User Defines Functions
Formula to calculate what percentage
Delete temp files
List Applications That Are Running
Download CSV from webpage
Test If Add-In Workbook is being Referenced
VBA to delete column values and formats NOT formulas
Should VBA Developers be worried?
Data Validation Formula
Quarterly date format issues
Range question
set font color depending on value Range
Sharing Excel Work Sheet
Xl2007 not unprotecting worksheet!!!!
Matching Debits and Credits in same column
Error 1004 very puzzling indeeed
Clearing an Active X text box with a macro
Combine contents of a column
Disable Preview Button in Print Dialog Box
Excel to Word report problem
File Save As macro for users with different paths
1004 Run-Time Error
RE: Macro to enter a value, tab to next cell in the row, enter ...
Macro to enter a value, tab to next cell in the row, enter ...
PivotTable ShowDetail not into ActiveWorkbook
Date & Time Picker Control 6.0 - another challenge (for me)
Flexible autofill in macro
Script entry to add a new worksheet
Transposing hundreds of addresses in a column using VBA
RE: BeforeSave Event
BeforeSave Event
Looping Sort
Building Menus with Macros upon opening Excel
Test for Error in cells
RE: Worksheet Change in Excel 97 does not run first time
Comparing Conditional Formatting in VBA
Worksheet Change in Excel 97 does not run first time
WorksheetFunction.Match
User Form - Finding the value in an Array
C.Value #N/A
How can i read a specific coloumn values and get its contents?
About the Macros in Excel 2007
Overlapping Sequence Number Range
Populate combo box with a range
E-mail a worksheet via internet e-mail such as hotmail or yahoo?
Pivot Table - Source Data Information
trouble setting colors
date fields in excel user form
Provide ability to resize form when open
Save Form Position on Close
For Next only updating one row
Generate web address string from date range in column?
strange
Tooltip and ActiveX control
Resourcing Multiple Pivot Tables
Combo Box and Multiple row / column display
Alert messages
Adjust userforms to fit in screen
Expose formulas
Comparing 4 columns on Two different worksheets.
Deleting a PivotTable.
Set Boolean Variable for Changing Any Control on Userform
Pasting Pivot data
Changing Value using vba
VBA to delete columns
Page break code
insert picture
Sharepoint
File save as produces corrupt file
Sub ShowAll_Records()
auto changes in chart
Filter, Cell Reference formula and copy formula on filter data
Excel 03 to Excel 07
trim, chr(10)
Format cell depending upon type of data pulled
strange behaviour for the multi-threaded calculation in Excel 2007
Custom Macro for pulling information into one sheet
Modify Insert Object Macro
function to make plot data section of charts auto-resize?
Excel Hyperlinks not retained when importing from workbook.
Comparing Conditional Formatting in VBA
How to remove dashes in Social Security number
Context sensitive menu options
culture mismatch with Button name and get_Caller
Data type not defined
After e-mail, unhide sheet
check if a string contains a particular character
Syntax to Run Macro in ActiveWorkbook
ms excel template memory increase
Command Button Gets bigger in size.
File count excluding those which are hidden
Unprotect workbook and merge
Fonts
Triger macro on and of a file on diff. machine
ExecuteExcel4Macro in GetValue not working
Find in Recorded Macro
Sub to copy n paste special discontiguous ranges from 1 sht to ano
error : can't find object or library
Changing Option Buttons status
E-mail a worksheet, then auto open another and do the same by valueof a cell
Resize range of non-contiguous cells
Macro to select columns and replace data
Macro to select columns and replace data
Find Cell When Interior.ColorIndex =3
formulaArray limit of 255 chars - what workarounds exist?
Expand a range by rows and columns
Edit Macro script
syntax in VBA to create a pivot table
VBA Save
User input from excel form not populating Access Database
Refreshing Web Query & Saving
Autofit/wraptext on vbLf problem
Pasted text will not spell check
VBA for Month and Quarters Output
Updating or Changing VBA Reference
First save to save as
Using Excel to call Oracle Stored procedure.
How do I set the source data to make this graph?
XYScatterPlot - Setting colors of lines and datapoints (C#)
cell formula in string variable doesnt work
Checking if a cell has a range name
Change links without updating them
Data Not populating in Access database from excel form
Hide Cols ??
Application.Match - Is it possible to use named ranges?
chart name not saved when save as another file
Displaying a linked Image in a spreadsheet
Sorting columns on weekdays
Sheets won't move
finding a minimum
Difficult Macro
Resizing the Go To Navigation Pane Larger
Active X text box using Excel 2003
Automation error for proecssing few xla files
WriteResPassword
Option Button in User Form
RE: Getting count of entries in a column