Excel Programming [Archive] - Page 10

Counting Selected/Highlighted Rows
Hyperlink opens word template for editting, not as new document
Positioning a Text Box
Personal.xls Workbook
routing slip in 2007
4 different axis in chart ?
4 different axis in chart ?
4 different axis in chart ?
Tab color change on specific value
ListBox Size and Screen Resolution
Using data filter
Refresh Macro to run each day?
adding a data series to a chart with variable inputs.
Create Detail Sheets from Pivot Table
Is it possible to add a Search Box within a spreadsheet?
Create a list using two criteria
ActiveWorkbook.FollowHyperlink strURL
Reg:Macro needed to pick up only distinct values but it picks up allthe values
Pictures/Clipart
Visual Basic On-line Training
Find And Replace
how to perform custom sort in pivot table
Works in 2000, not in 2007
Accessing the AutoFilter method via VB.net
Date format error with CSV file
Data Consolidate Limitation
Delay when userform resizes??
Print macro
Macro runs within VBE, but does not run to completion via a hotkey
Conditional Formatting VBA with formula to find string
Application communicating with Excel
copy range to a variable.
File unable to open
OleObject-Preventing deletion
how to set up an automatically dating calendar
Code and Creation 04205
custom function to convert numbers stored as text
Class Programming
BeforeDoubleClick code
Macro
Auto populate Email when Name is chosen
Find and replace with bold in cells
How do I draw shapes on a user form? (VBA Excel 2007)
Two completely unrelated workbood. Why is it asking me about updatinglinks?
Email from excel: Format dollar amount in outlook body
Trouble entering formula into cell
QAT Reference to Macros in Another Workbook Don't Stick
Can a macro read a list and insert the names into a web address?
Loop Macro to add Formula only on rows with data
Formula help
Macro to look up values in 2 different columns
undo a macro
Do not delete row with cell in Column B = 0
looping thru rows
Pivot Table Fields
Search string to search for wild terms in Access database
Help with a macro to display documents
Import XML spreadsheet from database with VBA
A little help please on a macro to display results.
Range for Body of E-Mail
Pivot table "Sum of" or "Count of"
RunWhen error
RunWhen error
Paste and cut code
Attaching files to Outlook
Comparing two dates
How to make X, Y axes of Excel charts to have same scale on thescreen?
Write to Module While Macro is Running
Macro-calling shape
how do I write a loop macro?
Count unique
Graphs & charts
Locking specific cells
VBA Functionality Lost
Which shape is selected
References to Other Workbooks Don't Stick
Position of drawing object on Excel-worksheet
CAN WE LOCK CELLS AT F COLUMN BASED ON VALUE AT C COLUMN
Show shape on cell select, Hide shape when cell is deselected
Search Post by user
VBA to find filename and replace
Regarding excel and VBA
Factorial function...whaaaaaa?
Open Excel 2007 .xlsm doc, but not allow user to copy it?
Go to named range nominated by user
Address of Selection Prior to Clicking on a Cell
Find and Replace in VBA
Need help to modify code to track changes in a column
How do I match 2 items in excel to return a unique value?
Help needed to modify macro to convert User IDs to Names
Writing VBA function with loop and condition
Solar cells for less than 1 USD per Watt
Only run if check box is checked
Table format - connection string problem
List of names that can be divide by catagory in a single step
Changing time zones
Logic question. Comparing 2 lists.
Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents
RefEdit Exit not firing
Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents
Lat and Lon coordinates from address
Find duplicate, save in a list, delete duplicate using macro
Loading combo box list
Counting Manual Page Breaks Only
VBA Password - Excel keeps prompting for it
extracting specific info from text cell.
How to clear contents of a cell without removing the formula
problems when removing validation
form combobox auto expand
Disable Print button & pulldown menu
Macro to convert ASCII File to Excell
Adding picture
COPY METHOD FAILED
SetFocus Not working
date format
Determining the row limit in a macro
Copy from one workbook to another failing
Build an Array of Different Values From Column
Compare data, and if different, copy to another worksheet
Insert Worksheets based on column data.
Workbook locks up after Worksheet_Change operation
Handling different Error 1004 errors
Testing for ODBC names
how can i append data to a sheet or book from another one
Close various modules/codes windows
How to find a number from a given data range?
Compile Error in Hidden Module: Module 1
Populate userform spreadsheet
prompt for path to loop through files
MATCH command does not work with dates
OpenDatabase Error
Adding formulas to rows using a Loop Macro
How to run macros from combobox selection
Help with looping in Excel
Creating Graphs + VBA
Trying to get just part of an XML file?
Name Formula
Autofit columns, password protected
Conditoinal Row Delete
Use combobox value as sheetname to set sheet object
Inserting picture stored in an Access DB table
2 fonts in Chart title in E2007
Run-Time Error on Cell Range Select
Copy and Paste Function
Re: Marco to protect / unprotect worksheet
Extract data from web
Did the newsgroup search programming change?
Open delimited file
Data Matching
Differentiate between False and Zero for Input Box return?
Excel 2007 query - Access MDB question
Novice - using macro to protect with password
lookup help
HasFormula
Slow Code
Copy Userform ListBox AND TextBox values
Setfocus question
Unexpected internal error or not enough memory
convert to capital letters
ActiveWorkbook.SaveAs Function - Can I specify the user account tosave the file with
CreateObject("Outlook.Application")
RibbonX Controls and Determining Enabled?
Look up
subtotals on every user - newbie help required
Package & Deployment Wizard
xldialogprint arguments
Excel Database - Magic Printing Macro
RE: Marco to protect / unprotect worksheet
Target Range Activation
command button
Invalid Circles - Can I force their display?
how to count columns i pivot table?
Help with error 2015 in macro
Efficient way of finding string and changing cell value
Not ranking 0's
Reference a specific cell in the active row
Refresh screen method?
ThisWorkbook.Close question
Multipage control help
Speeding up the importing of data from file
select non contiguos columns by variable name
Speeding up the importing of data from file
Problem with DTPicker 6.0 control
Package & Deployment Wizard
Excel won't close properly
Excel: Cell Value as Excel Document Metadata Property
Getting right date value
Get Outlook Settings for E-Mail from Excel
Passing an array of strings from VBA to C
How to list dates in a month of particular weekday
Monitor Changes in a folder
Find Highest Date in a range
Creating an older version pivottable
Problems with MS-DateTime-Picker 6.0
OneHD
Question about modal userform.....
Passing a range between two subroutines.
Run subroutines in other workbooks?
How to run auto-open macro in Excel 2007?
How to calculate % in summary sheet from cell A9 in multiple sheet
Control Tip or MouseOver label on Excel shapes
Send round office a macro enabled ss
Linked Spreadsheets
Calendar Control Shadowing Issue
Split data around a carriage return
Grey out Cell content
What is NNTP Server Name?
Delete chart series
commandbar control works on some computers, not others
Permission Denied
Left Click
Help-how to install a macro for everyone to use
UDF Drawing Shape Not Re-Positioning
Selecting specific rows in data range.
Weird behaviour of VBA when generating multiple PivotCharts
Excel To Access: Transfer multiple rows from excel at the same tim
Format Returned Values in VBA Q
pausing macro while cells update
Using VBA to change default color palette
Copy range to different columns depending on cell value
How to calculate % in summary sheet from cell A9 in multiple sheet
clip art shifts
How tcalculate percentage of values in cells in different workshee
delete blank rows from other tab
Editing multiple cells at the same time
Scripting.FileSystemObject stopped working
Editing dynamic worksheet exported from CRM to Excel 2003 *Correct
Editing dynamic worksheet imported from CRM
"Scripting.FileSystemObject" suddenly stopped working
Kill the annoying "Auto Fill Options" button
how to store values in a 2 dimensional array
Finding Closest Text Match
Retrieve tables from web with variable URL
Excel 2007: Return rownumber when text data on 3 columns match exa
Personal.xls ?Save? on exit but no changes
How to de-activate Menu bar in only one Excel Workbook ????????/
Cells(my_crt_row,my_crt_col+1) crashes for my_crt_row>65536
VBA DataEntryMode bug?
Combining 2 Text Strings in Body of E-Mail Q
How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed
Insert a specific number of rows
Pivot Table (Excel 2007) Display Full Year Budget Field only in Gr
test to confirm non-numeric characters
Excel Model
deselect chart
Stack columns from a matrix
Find a row based on a word in the cell
How to Calculate if a Range of Times Falls Between two Date/Time S
Question about how to use range in VBA
Reading through an XML file
Adding a dropdownlist programmatically to a ASP.NET webpage
Highlight Row Based On Condition-So close
There must be a better way to code this
Compile error :: Trim, ...
Solver slow
How to copy only to cells where there is data
Excel Query locks Access
using vba so search multiple Sheets
Help with Excel sheets
Calendar Control 12.0 - Missing
Message/Input Box - filename in question text?
Device I/O Error
Web query - extract data from web to excel
Visually represent project dates and activities as shapes in Excel
Filename in Input/Message Box
Macro to split the contents in a single cell separated by "," intonext cell in that column
Cut from one sheet, paste in another
How to autostart a macro?
Copy / Paste Not working with Target.value
Index Generator - Help with Permutations
Cut from one sheet, paste in another
test
Disable user interaction in VBA
Performance issue with accessing Microsoft.Office.Core.DocumentPro
Need Macros
Locking User Interaction
count resize range
Suspend old code while new code is running
Text is Truncated With String Variable
Compile Error: Expected:(
Oh look...the forum is not working again. NOT SURPRISES!!!!!
Excel to XML: Need some help fine tuning a macro
Modify sub to exit if password is incorrect
Refreshing query data via vba button
How to determine if a chart is embedded or not
Excel with internet exp freezing up
Checkbox problems
computations at odd but specified locations
How to autofit variable columns?
Sending E-Mails from Excel
Want code for emailing Excel files that aren't the activewrkbk-Out
Please help: Interrupt routine to get input from key
Howw can I make a function return a date in date format
400 rows, takes ages to delete
Excel To Access: Transfer multiple rows from excel to access
isblank function in Excel VBA 2003 ???
Conditional Formatting Code
Refresh a Combobox
Email from Excel Function
How can I access the "style" definitions in my Add-in?
Compatability issue
Workbook BeforeSave
Code for emailing Excel workbooks will only attach activeworkbook
Runtime Error 1004 when runing Sub() from btnClick
Sending a macro-enabled spreadsheet
.odc connection managing with vba in excel 2003?
Retrieving consecutive pages in web query What's wrong here?
Listbox and sheet updating issue
Transfer data from one spredsheet to many others within one work b
Export to XML exports single row only
Using Autocorrect to remove spaces
Move data to right with variable rows
When does conditional formating fire?
2003 v. 2007
One range inside another, Intersect
VBA Custom Toolbar
Duplicate Rows - Combining and Flipping
select a certain range of data
runtime error 438 when opening an excel file
Shortcut key and UserForm
Querying Data from Access
How can macro open daily generated files?
how to Delete Format Menu Toolbar From Excel
Which control should be used for my new table
Re: Conversion from 123 to Excel
Macro to seperate data
Stop users deleting& inserting rows
Compile error - Expected: list seperator or )
VBA Password Recovery
Userform with currency format
Restricting activation of a form button
RIBBON COLOR
prompt password for a worksheet
Help to modify a macro for deleting rows based on two or more colu
sumifs help
2007 wont run 2003 coded sheet_change event.
Copy to a Word Table
Extracting records from a list
Change color of specific text piece
Program won't stop
copying cell comment from one sheet to another
Help needed: How to adjust the SUM range??‏
Weird behavior on Worksheet_beforedoubleclick event (XL2003)
Excel VBA
Re: Creating sub menu in Command bar
cannot set range class?
Strip file extension from fiel name with multiple periods."file.9.69.txt"
Command Bar Creation
Converting User IDs to User Name
userform problems
Routine does not run when workbook is opened
Excel WB opened from Sharepoint as ReadOnly, ReadONLY for WB = FAL
VBA: optimize If conditional expression?
Write a button to run macro on *ANY* chart area clicked.
Need help with VBA - complicated copy and paste
CountIF Statement combining 2 different pieces of data
Selecting a Drawing Object
Multiform coding problem
Creating a userform?
Is there a macro for returning multiple values through a Vlookup?
koşullu biçimlendirme
Macro to subtract cells if...
Perform compare of multiple selected columns
Web Query Formatting not ready for Production
Select all tabs after a certain tab
Formula in Vba code help
OpenOffice
Sort data with a varying range
Issue with INDIRECT function.
Form Controls on Worksheet
Multi-Step Worksheet Export - HELP!
Delete Tabs
How do i refer to cell contents in a macro?
Where do I paste in the following Access SQL code into my routine?
Worksheet chnage event
Can I run code from a PC on a Mac?
Copy and Insert Row
Stop links updating when source is open
MsgBox when the cell is empty
Comparing the data in between two worksheets and pasting the data in next worksh
Problem with the code, probably with Private Sub Worksheet_Calculate()
VBA Code to calculate SUM and COPY&PASTE cell value in inserted li
Target.Address Being One Of The Cells Of A Named Range
Excel + Query Tutorial Recommended?
visibletemslist for excel 2007
Syntax problem
Spreadsheet in userform
object variable or with variable not set problem
save OLE Object to a file
Adding a New Tab-and Naming it from a Cell Name
Auto_Open update VBA
UDF that returns a Hyperlink
Printing a selected worksheet
Please help with On Error GoTo
How to reorder/rename modules?
Why show Enable/Disable macro prompt after I deleted all macros?
Comparing a date to todays date
Exclude header row when copying autofilter results? (XL2003)
Excel open files on task bar
Determine if a sheet is protected?
Using Excel GoalSeek on Access form
Personal.xlsb always locked
Autofilter Array
Updating Excel QueryTable using VB
Creating New Workbook from Sheet
Conversion of 10 digit number into xx-xxx-xx-xxx
Sheet protection complications
Programatically sort and highlight
Error generating a list of unique values in range (XL2003)
checkcompatibility not working in Windows 7
Large footnote
Getting data from a webpage
Passing arrays through procedures
Using a macro when opening an excel spreadsheet
SumIf across multiple worksheets
Find in UDF VBA
retrieving data from a table on a website
Identifying a button on a toolbar
Print a user form image
Help with api to excel?
Insert Record
Will 32 bit compiled Add-In run in 64 bit excel 2010?
Syntax Error '1004'
Get a specifc button Handle inside ribbon
Copy and rename a sheet
Colour a row, based on a cell value
Chart sheet causing error
Loop Enumeration Constants
Simple Vlookup Looping
Read the next line in a text file
Reg:Trying to write a macro in excel
Count how many instances of an item appear in a range
How to autofit text containing CHR(10)?
Deleting decreasing data and naming rows.
Deleting selected images from Excel worksheet
How to reference variable rectangular range?
Need something simple
Better protection for VBA project?
how can i disable/enable "copy and past" in excel sheet?
A code to import other xls data into one xls file
Select Case Syntax
can anybody send me complete list of MS Office Object model ?
Fire Worksheet_change event from module
Textboxes on userforms
Copy HIDDEN columns to a new workbook
Matching Values to Enter New Value
vba to send multiple workbooks to different address
search text files for a certain word
RE: Slow Running Subroutine
Desktop icon
How to constract an array UDF?
Macro/SUB to merge two columns of text
Transfer data from Excel col. A to columns B-E in the same sheet
VBA code
Insert a square in a cell with VBA
Mail Merge Option
ActiveWorkbook.Names.Add Name ???
Remove Duplicate Numbers in One Cell
Copy/paste/sort
Test for NULL string?
Setting workbooks
Access Version being used
MRP Excel Spread sheet
Disabling all pushbuttons
Frastrating-doesn't give all the data
Blank cells corrupt?
Visual Basic Editor opens automatically after lock, unlock
Multiple OR and AND conditions
Way to Override Policy & Use 2003 Vice 2007 Excel Interface (VB.NET)?
Store a picture in a cell
Divide into groups.
how can I disable a control in the ribbon at run time
help with/for pivottable code
PrintScreen and save 2 Internet pages
Graphic template Excel 1997
calling a macro within an excel formula
autofit column, password sheets
running applications
Converting from 123 to Excel
Code and Creation 53161
Code and Creation 08137
#NAME? error in nested if & VB
Symbol # after numbers
displaying formula result
Excel &VB - If/ElseIf - how to allow editing if no variables apply
Determining Change in a cell Value....
Upload a file to a web using VBA
Automatically pull data from one file to populate a template
Screen refresh problem
File handling
LABKHAND: Problem using INDIRECT function.
Excel Formulas
VBA - concatenate with a loop
HOW TO CONSTRUCT AN ARRAY FORMULA
VBA when copying and pasting
Save workbook i specified folder
Find header name
Count of text in cells
Form Controls on Excel worksheet
Change folder to save in
Macros disabled, not by security settings?
pivot problem
Code to copy selective cells from matching rows
Multiple IF conditions-AND/OR
Excel 2007: unusual flicker with Application.ScreenUpdating = True
Error Number 57121
ClearContents if #VALUE! found in cell
Wildcard in VBA?
Excel 2002, VBA, macros and Windows 7
Wildcard in change event ??
Userform combobox matchrequired = True; error with no selection
Excel To Access: Help with getting a range data from excel to acce
Excel 2010 developer support questions
Loop
User defined function
locking and unlocking a textbox using command buttons
Highlight cells greater than zero
Format last row printed
shell command and code execution
Office 2003 macro won't run in Office 2007
Copy ws to new wb, loop for each ws
If Worksheet exists, delete it, then re-add it
Protect a worksheet but allow cell editing
centering text on textbox
Including tab name in absolute reference
Object Required error
Resetting picture index number?
Macro's
How to create multiple subfolders using VBA
Prevent Copying of Excel Workbooks in 2000 and 2003.
Print Spreadsheet to PDF file with Excel 1997
Save as Read only
Insert Rows
How do you count the number of * in a string?
Copy and paste
Specified rowheigt in a table
Return value from cell info
MsgBox Positioning
Run time 9 error for some users but not everyone
Matching user entry to database value and pasting to correct cells
Search for a text in a cell and give the outcome later
Change in cell content alert
MsgBox popping up on entering of certain text in any row of Column X
pulling cell "value"
Autofilter and subtotal
programming issue
Codename not set
Worksheet copying in Excel 2007
6 conditional formats in Excel 2002
docable window in Excel.
Unable to assign values to Class Properties
Setting page breaks
Trapping the AutoFilter Event
converting lotus macro
Print to PDF (apeend to the end of an existing PDF)
Get Picture from Access OLE Object Field
val a string
Extract worksheet name from a chart formula
RE: which is right, protect password:="xyz" or protect password = "xyz
VBA copy 'corrupts' font selection (XL2003)
Rename sheet with (2) after existing name of existing sheet
Recording Macro Error Message
Copying From WB To WB
Importing .xlsm, .xlsx with OLEDB
Workbook_Open CommandBar corrupt excel files
CopyPicture method of range class failed using RangeName
Activebook.Unprotect in macro giving errors (Pwd)#2
Rename sheet by removing any invalid character
What is wrong with this forum?
Filter and excluding line item from filter
SUMIF?
Summary in the last row
Using Activebook.Unprotect in macro giving errors (Password)
Run time error "5"
calculation
Index Problem
VBA with OpenOffice
Moving from Excel to Visual Studio
Swap part of 2 columns
Keeping Validation References When Breakingout Spreadsheets
Need Formula
Visual Basic Personal Notebook?
Userform as childwindow in statusbar not redrawn when Excel window isresized
Transfer Union(rng1,rng2) to variant array
Count File Names
Problem with pivot index
Command Button Text gets smaller
How do i check if the a named range is empty
Start basic?
the freeze panes icon is not working
How to refer to the cell containing the formula?
Selecting a named range, the name of the named range is in a cell
Application.Evaluate (works with SIN but not RGB)
VBA in Excel Open properties
Formula Help
userform to update multiple sheets
Endless looping with Worksheet_change event (XL2003)
Cycle through a list
Vlookup Loop
If Statement Variations
ScreenUpdating not working.. Call Objects saved in XLA???
Text to Rows
Thesarus
How do you invoke the Let and Get class Functions
Can't get soap client to connect in Excel 2010 64 bit
(Error 1004) Object Defined Error ...simple code
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3
filtering rows w/ VBA
cell fill color spectrum
File Not Found Msg Because Sheet is Missing ?
Creating multiple pivot table report at run time
stop calling sub Intentionally without error.
Question on Form Textboxes
#Value when entering a circular reference
faster way to do this?
CAN YOU SOLVE THIS!!!!!!!
Can you do it ???????
Run Time Error "13": Type mismatch
Excel data connection to Access not retrieving data from single fi
entering data into multiple sheets
E-mail excel attachment via Lotus Notes
Best Practices - Workbook security & macros
why won't this work
Sorting Order for Worksheets
Create a workbook with macros from inside another macro
macro to sum with offset in 2 cell as other cell changed
Morefunc dying
Problems with date formats
Selecting & copying a named range through a listbox
Protecting data on a sheet
Copying a formula with multiple worksheets down rows and across co
Copying a formula from multiple workbooks down rows and across col
Use a Variable in a formula
Shared book (sorry!) bloating and not disconnecting
Icons for office 2007
Case select returning error when cell contains #N/A : how must i avoid this error
When a sheet is copied, i want also that the Sub's whithin this sheet is copied to the new sheet
Add Named Range
link
Updating values in 2 forms
ActiveCell.Offset for event macro
Button Problem with the Sort command
Stock Quotes
Excel 2007: Pivot tables "Invalid procedure call or argument"
macro to auto-veryhide
Open file(2) from file(1) and then close file(1)
UpdateLinks Popup on Workbooks.Open
Drop down boxes in VBA
exporting specific cell(s)/ range
Sort Problem using a button
vba command to autosum range with multiple columns
IF>0
Keeping Validation References When Breaking out Spreadsheets Using
Macro to highlight a specified row
How do you ignor File Not Found Dialog Popup ?
listbox click event question
Reading data into a 2 dimensional array
different results when using F5 and F8 in VBE
Multiple Drop down lists and their combnation
complex problem
How long does it take?
Reading data into a 2 dimensional array
Selecting range with loop in VBasic
Editing While Using Column Headers As A Reference
pdf writer check
select items in a list box with a macro?
where is my post???
Sum If and Count If
removing rows.
Reading data into a 2 dimensional array
get_PageFields
Turn screen update off; then back on during macro
HTML Interface FUBAR
Select an embedded Chart within a Protected Sheet
Calculating cells on workbook_open failing without message
Index Question
Outlook Email Help: selecting a specific property from excel
Outlook Email Help: selecting a specific property from excel
Outlook Email Help: selecting a specific property from excel
macro enabled/disabled (registry key)
Site Down?
New project - Exam question bank with export to Word
2003 vs 2007
Setting series values on Excel Chart
Macro for Autofiltering certain dates
Setting series values on Excel Chart
Estimating memory usage per worksheet
How to make loop code more efficient
Excel Macro
How to call a function from a third part com add-in?
Maximum Named Ranges in excel
is it possible to create Workbook Navigation
VBA - looping help
Can one export to visual basic express
Convert image to Base64 string in VBA
Maximum Named Ranges in Excel?
Selecting Two Sheets to Display Side by Side
how do I create a random list whilst keeping some entries fromrandomizing?
Using SumProduct function in VBA
PRESENTING MSGBOX ONCE ONLY
More than 3 Conditional Formals - EXCEL 2000
VB coding
VBA - splitting name and re building in specific order
Sorting with macro
Weekday function
Include guid (uuid) from Access in Excel
Open file with foxit when adobe reader is default application
Solver reference
countif not working
Need event macro to tab past a (calculated) cell
Hide columns according to background fill color
Workbook Deactivate event seems to occur too late
Simple Vlookup Loop
launching e-mails from Excel using Safari
Removing empty rows issue Please Help!
Calculate the distance between two 2d co-ordinates
Old style programming using Arrays
Update RTDs formulas inside macro.
trying to resolve range names to variable that vba can act on
re named worksheets which were linked to other sheets
Autocomplete Data Validation Combo Box
User selects existing sheet to paste to
select case to replace text with different text
Excel2007 VBA - dates in Pivot Tables not read in correct format
view & update (VBA-command button) two sheets concurrently
compare and arrange two sets of datta.
Is the Fourm Site Down
Transparency/blur issue with dynamic toolbar
Find Copy Paste Special
Copy Dynamic Range problem
MSNStockquotes V MoneyCentral
How do I name a range and then have that range be dynamic?
Problem Passing Arguments
clearing values of cells in named range(s) so the cells are empty
Control Word Files From Excel
what type of variable is this?
Call routines of other workbooks?
Excel worksheet without min/max/close
Formulas on many sheets
formula to delete first n chars
consolidate historical stock returns from multiple workbooks into oneworkbook
End of Word Document and Append from Excel VB
Help with Workbook name change on update
Help in changing code to see new file name (Dave Peterson)
How to write networking code in VBA?
Number/Text Formatting Issue
Number/Text Issues
Autocomplete Data Validation Combo Box
Change Ribbon in Excel 2007
Combobox list validation
Call Statement
Comments and Print Preview
deleting named ranges on a worksheet (not workbook)
Comments and Print Preview
The object invoked has disconnected from its clients
The object invoked has disconnected from its client
Excel libraries in VB.NET
FYI: MSDG not displaying posts; expects duplicates :-(
Concatenate 2 columns date & time
need macro to filter data from multiple sheets in a worksheet
Add-in closes first when Excel is closed, causing problems
Need to check if the value in one cell is correct or not
Pivot table in Excel. Exported data from access as excel sheet.
Using the Call Statement
Working with forms
RE: open files serially
Delete Table row with first cell not empty
Shared file keeps losing connection
setting font and other properties for datalabels
Protecting cell contents
VBA formula question
How do I create a list of sequential times?
Help! Problem Referencing Excel 2003 in VB.NET
Incomplete process
Macro to open file bypasses Auto_Open
Microsoft has encountered an Error and needs to close.
Best way to format a flat file that Excel will load properly?
Opening Multiple Hyperlinks
Save as bitmap
Selection on a non-active sheet?
Record time peroid to run code
Comments Boxes
Bypass information
Locking the VBA Project
Excel in use
Excel Solver
Is it possible to combine countif and countcolor?
UpdateLinks Popup on Workbooks.Open
Need help working with XML data from another data source.
Prevent ShowAllData Method from failing
Copy and paste same cell from a number of sheets into a new sheet
Copying Formulas
Cell Change triggers Worksheet Event
Date Formats
Formats for Printing Macros
Macro to create Name Ranges!
Lock a control object
Displaying a dataset or datatable in Excel
MsgBox that will open only once.
Workbook open code to do 2 things
Formula to count occurences of sickness
CreateBackup = True?
Identify and delete the specified objects names
Algorithm to combine identical items in a list
VBA CODE FOR CONDITIONAL FORMULA
name a range from the current activecell down 12 rows
Regular Expression Help on syntax
Data Validation drop-down
Count numbers that start with 1
Pivot Tables - How to display multiple items?
macro recording
Scroll when importing data
Excel export to Access - Run-time error 1004
Copy/Paste Excel Macro
Open Files in Folder
Run Time error on file name
Excel 2003 : conditional format for 5 format settings
Save Dialog pops up now - Excel 2007
Speed up calcs within macro....
compare 2 mem variables against a string value
Creating .NDF file
Declare Function issue with Vista
How to import csv file data to already open worksheet (in C#)
Referencing a Worksheet Name in Formula
Extract specific string
Use Macro to Format UserForm Object
open excel file and copy data to another file
HELP: Not able to generate query from excel for access 2007
Disable Clear DContents command in excel - vba code??
inserting more than one column
Access to Excel: Identify attachment field in access database
Automated report & external data source
listbox macro scrolling problem
Embedded Combobox (Form Control)
Reading the VBA code in a spreadsheet
Why won't negative sign come over with negative numbers?
Coding Etiquette
Array+Array
2007 compatibility issues
Retrieve value from Combo Box and Radio Button
counting "="
vlookup and drop downs
Open file with variable date name based on current date
Today's Date
Updating the VBA code in multiple spreadsheets
editing conditional formating formulas
Help with Formula
Help with Formula
VBA ADODB Automation - Truncated Memo Fields
Sort halted
Last cell in new formula
How to code macro to close Excel Application?
Protecting multiple sheets
Run-time error for objects deletion
use xml-values to rotate objects
VBComponent documentation
Function/Macro that keeps first X characters in a cell and delets rest
Printing Userforms [Landscape]
Change Excel 2003 default toolbar path
Macro to Run through each tab
Propercase, strings and arrays
delete all lines after finding criteria
copying an array formula
tab textbox by a macro
VBA Basics - Where does the code live?
Not getting Notifications
Autofit column Help?
Open file from website, where filename changes
2 User Forms Comunicating?
refresh multiple pivot tables in workbook
format label text
Retrieving addin data
insert blank row every 10 rows
Script only pulls numbers not minus sign for negatives?
Illegal Character Imported
Data Validation drop down list query
Replace leading zeros with leading spaces ?
Mail Sending Error
Code Needed To Loop Through Certain Rows
Save Excel file to a CSV without opening it first
Set RowSource
Need to get ActiveWorkbook after AddIn installed
C'mon. Isn't there a SIMPLE way to...
Outlook Email Help: selecting Voting button option from excel VBA
After SaveAs Event
Change Cell Alert
Problem exporting Chart as a jpg
Worksheet If Statement in VBA
Automatic Folder Numbering
Deleting multiple charts on a single sheet
Plot Range ?
Array activation question
Cell Selection issue
Excel Programming
Text in column causing SUMPRODUCT error
Excel Application to MS Access Application
transfering data from a one workbook to another workbook
How to Handle Chart Sheets
audimatic numbering
Format text entries with code - Excel 2007
Selective clearence
Enable autofilter in protected worksheets in Excel 2000
MS Query
How to see innards of Excel 2007
ROUNDING
Re: Userform problem with "Run Time Error 75"
Newbie question (:=)
Complete Newsgroup Access - 6 Months Free
Protected Cell Problems
Insert Consecutive Numbers in the Middle Of Each Cell in a Selecti
insert row when cell full, auto wrap
named cells. need a 101
CommandButton works in v.2007 but is unclickable in v.2003
PasteSpecial value
Stopping a Loop
Syntax question: using worksheet functions on a subset of a 3-D ar
Display rolling months
Delta symbol
Run time error '91'
Giving a name to a row or column
Getting Data from a worksheet to a form - and back again
IF Formula
IF formula
Detla symbol in code
Using a string variable to change a file name
Password Cell Protection
Menu Question
lookup drop down
Hunt for date 2 months back
Min not zero revisited
Email HELP: Add Voting buttons to new message from excel
how can i make it better (cod to delete rows)
Get data from sheet to form and back to a different sheet
How to clear contents of multiple cells in Excel simultaneously
Saving tabs into separte books
using a *.xslm add-in with several users
reposting of previous question
Repost of previous question
CommandCombo BOX want to populate all named ranges in it
Macro to Find the Max ?
right mouse click - cut copy paste in userform textboxes?
Change multple table names
How to check the Sheet name exist before running Macro code
Combo Boxes getting data from Work Sheet.
searching for a type of string
Filling a Form
looping excel macros
making a drop down to sort data
Text search only finds 1st result
Access an open workbook without making it active
summing cells in different sheets
Add custom button to existing group Excel 2007
Copy user selected range from all open workbooks
Using Forms to Update Worksheet Data
write vba to a worksheet via a macro
Loading Web Page Issue
VB macros in new Excel
On Error
Date does not update until worksheet change
Writing Excel macro in 2003 will not work in 2007
Need another eye on this Sub()
Dir function error
Sort several workbooks using code
Last row printed formatting
Borders Disappear When Hiding Columns
Drop Down Menus
Workbooks.OpenText Method / FieldInfo
Is there a way to protect hidden rows and also change fill color?
Referencing User Form from WorkBook
Referring to a range that has been copied (Excel-VBA)
ADO syntax problem
using find in excel from C# code
Retrieving current worksheet backgroud picture
how to remove selected sheet from CommandBarComboBox
doubleclick event only works once
Selection change code with merged cells
Help with batch production and Solver
Confused about sheets and "Select" vs "Activate"
Text in formula
[2007] Any way to transparently import data from txt ?
Get website information
Cell Format Function "NumberFormatLocal" in VBA
IE Automation - checkbox
Re: MS Access Query
Table Filters
Excel 2007: "Reference is not valid" when refreshing pivot table
Help with error
Range maneuvers question
Pivot Table
Creating a new worksheet
Getting Info From Registry VBA
[E2007] My VBA turned into an AddIn doesn't see objects
Any way to pretty this up?
Excel VBA & Web
how to sort a string?
Unique record
how do i use analytical hierarchy process in excel?
Does a toolbar already exist?
Deal with text characters that are greater than chr(127)
Help with significant figure counter