Excel Programming [Archive] - Page 65

Autofilter & Long strings i.e > 255 chrs
Autofilter & Long strings i.e > 255 chrs
.PrintPreview
How to find existing ChartObject in a worksheet?
Explain use of function property
HIGHLIGHT THE COMLETE LINE THE CURSOR IS ON AS I SCROLL
De-Select an Option button
count row and insert
2007 EC Excel / Access User Conference
Insert row above Sum - update formula
only manual HpageBreaks into new worksheet
Assigning checkbox to the cell
Range in wrong book
Excel VB form to break apart a phone number?
RE: Regression results
Date calculation problem
Excel Count characters in a textbox to display character count?
How to get a DriveName without using the FileSystemObjects?
Detecting double click
Code question
Extract text from hyperlink
endless loop - using input box
Renaming scan files with a list of drawing names in excel spreadsh
Chart & Active Sheet
Varing range
Server process
Number Cells As Cell Value Changes, Excel 2000 & 2003
RE: Protecting specific cells
Code Question
copy data from one workbook to another
screen tips and macros or automation
help with updating a database from a form?
help with updating a database from a form?
use Select Case with 'external' list
Advanced Filter
random cells in a row
Type Mismatch Problem
Manually call Workbook_Activate procedure
Excel Array Formulas
removing links to external workbooks via vba
HOW TO GO ABOUT USING THE SHORT PROGRAMS FROM VB SOURCE CODE
Displaying big numbers WITHOUT scientific notations
Excel Objects
USING MACRO REMOVED -OPTIONS- FROM TOOLS. HOW TO GET IT BACK?
EXCEL97 WHY SOMETIMES THE COLUMN WIDTH DECREASES BY ITSELF??
Solver in VBA
Code for an entire column
HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OPEN FILES WHICH HAS LINKS
ADO Select qry to access mdb
directory listing
Macro example needed
Macro - Varying Range to Copy
Getting a total in a pivot table, excluding the duplicates.
Returning a series collection end Point value
Excel - Powerpoint
Identifying Printer Name
Change macro to hide row if null
Beep
Name of a chart series Point
Set a Workbook Name from VB
Combined histograms in single sheet
Cell text color change
Using file name as argument in function
Check values before running macro
Autofilter more than 1 worksheet
copying a recordset into a variable
Code Bombs in Excel 2007
sniffing out string inside cell
Determine name of combo box
range as test
check for cell with numeric value
XML and xpath
Find Last duplicate value in Column A
Linking to user specified file
Adding Delegate in Outlook
Count cells with Conditional Formatting
VB and Excel Scrip
Run a MSDos Command from Excel
another macro questions
Quote Building Question
minus sign
Design Mode
Excel Splash Screen
VBA functions dont work
"Cannot expand named range"
Add-ins customization.
Scrollbar with variable maximum and minimum
Exception from HRESULT: 0x800A03EC While opening Workbook
removing single quotes from a paste operation
Delete Entire Row if value is not Q
Help with Code to Copy to New Worksheet
Formula for detecting a certain pattern in a particular row or column?
Strange "paste" behaviour
Microsoft Excel is waiting for an OLE action to complete
storing and recalling account data
Help? SUM row to a cell with a specific value in a different row
Auto Update a Database from an Excel Form.
How to change words in excel cells?
Why does the list get bigger ?
Linking worksheet tab 2, 3, 4 ... names to cells in worksheet 1
Listbox value to be placed into a textbox
Screen Updating problem with nested subroutines
rename unknown named files
fx Libraries
Toggle Button help
naming several sheets from cell range
total number from start date to end date
chart vs. chartobject
Extract Name from Email ID!
How to Push Data from Excel into Access?
help with this code
Last cell, copy, paste special, loop
How to find numbers that total o a specific sum
Mixture of Control and forms checkboxes.
Running LinEst() from VBA
Worksheet_Calculate or Worksheet_Change?
VB from excel03 not working in 07
Macro - Save an Open Excel Version 4 as current version of Excel
Macro for sorting a worksheet
Using GetOpenFilename
Reformat Excel Spreadsheet to List format
Can I make tab colors dependant on cell entries?
Using macro to copy data from Access to Excel
Conditional format problem
Menu disabled
HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB
ADO SQL statment
ADO / SQL /
Macro doesn't work twice
Force use of the Default Directory
newbie, vba simple prg from a book doesn't write...see vlookup with vba?
Command Button Function
Graph Source Data
Con ditional Formating-Need 4 condidtions
Message Bar does not appear when browsing Excel in IE
code to disable "this cell contains a formula is not locked" warni
Compare two arrays in VBA to find dupes
copy only non-empty cells
Copying data from one worksheet to another.
Assign cell value to equal file path for loading
Trim Find Issue
Code No Longer Works in 2007
Database Connection
"COUNTIF" using ".ColorIndex" and "AND"
VBA to update Chart Source Data Rage on Multiple Charts
Method 'Copy' of object'_Worksheet failed
Cleaning up cells
Exchanging Values Between Two ListBoxes.
Compatibility 2003-2007
VBA code to search and display results in multicolumn listbox
VBA Cell Highlighting -- Tricky
Compare two columns
Calculated Column Using Loop
Job offer in Portsmouth NH, USA
Limiting input
Advice to speed up process
Width of drop down in data validation
F3Dynamic Library
problem programming outside the startevent
Updating Ranges or References in Code when Adding or Deleting Rows
Verifying Input
Excel 2007 Menus - Ron De Bruin please
How do I create an autonumber similar to Access in Excel?
Scrolling vertically filtered list
Filter date by month and year
Interop.excel dll with no office installed
How do I change the color Excel Autoshape using VBA?
Import CSV fieldname problem
Flickering
Runtime error
Unknow file names
Cannot reactivate workbook after sending email in VBA
Extracting mixed values in single column to multiple colums
Refering to 2nd Column in a Combobox
dup value deletion
Convert all cells in a range to a number
Another Copy/Paste Question
changing a file password from something to nothing
Add data to sheet, in next available column.
VB code required to compare name list
Wandering Split
how to remove my button
Range Issue
Difference between xl11x17 and xlTabloid (PageSetup)?
Trouble creating a chart
Compare three strings?
Start up window
Array trouble
Why does this not work
VBA Code - Retrieve SQL 2000 data -Pivot Table
sumproduct or sumif?
Dynamic array
Newbie with VBA for Excel
vba code to import access query data into excel spreadsheet
Don't ask to save changes
Adding values from one table to another
Excel Comments Referencing Excel Formula
Problem with simple routine to change font size
intro to vba
Delete Entire Row
Using ADODB.Recordset
Daily events
Copy/Paste based on Criteria
Selecting Undefined multplie rows
Modifying ODBC data source for multiple reports
Dynamic chart
Dynamic chart
worksheet change macro
Excel 2007 Class
need macro to clean up telephone numbers
Macro security settings - digital certificates
Need help to auto input a file
Help Needed
Strange
Strange
if end if sanity check...
Custom toolbars in Excel2007
Deleting all items from Combobox
Type Mismatch problem...
HELP: Error creating email from Excel (Office 2003)
Help with Sumif formula
problem with Locked always on after pasting
Set then print area based on a search
Find length of string - firstfolder
Row count a filtered sheet
using environment variable in macropath
formula strings containing quotation marks - VBA
change UNC path of multiple hyperlinks
Re: 2007 EC Excel - Access User Conference
Contorls are not displayed
Hi i want to export the excel data to xml
Application.Index & Application.Match
Excel 2007 menus - is this right?
Highlight Row and Column headers of active cell
Problem with excel add-in and low level user
Workbook addition
Excel File
IF cell=TRUE how can I delete that row in formula
Modelo de objetos de Excel
How can I get all worksheets' names of the spreadsheet?
Pivot table sorting
update data from website txt file
.interior.color hates me
Basic Stuff to some
Copy and Paste Between Files
Date question - really simple but I am stumped
How to find record in Oracle
How do I make the formula see the message box answer?
Testing if a file is open
CodeName Referencing Help
marco issues
Filling Combobox
VB code required to compare/delete data
Comments
Excel and Outlook integration
Find a series, then average
same macro on multiple sheets
Selecting an offset of a range of visible cells, but only those <>0?
Moving name from 1 listbox to another
Add columns horizontally? A1+B1; A2+B2
Saving Workbook via Macro
Check the Date
Strange
Scrolling a split screen with VBA
A simple way to crack VBA password in Excel file
VBA Password Removal - Does any one can help me find it?
Comments
Combobox to Show 2 values in same row
Combobox Date format change
Excel Gantt Chart. Schedule vs Actual
How can I deselect after paste special
How to use the content of a cell as a file name
Is there a way of asking "is a member of" in VBA?
How do I import Word bookmarks into Excel cells
Conditional Row Delete
selecting a collection of cells from .Find()
Dijkstra Algorithm In Excel
Frustrated VBA Newbie
Has anyone out there got a micrososft excel macro to run Dijkstra
Excel marco to screenshot a user form automatically?
how to sum a range depend if the corresponding adjacent cell has a specific string
HOW TO GOTO SAY 100TH THREAD IN THE LIST INSTEAD OF GOING PAGE BY PAGE
Question for Tom Ogilvy
Capturing the last row of a chart and changing it
WHY IN EXCEL97 SUDDENLY GET 'EXCEPTION ERROR'
Need Input Box to only Accept Numeric Values
Using Cells while UserForm shown
EnableSelection for all sheets
Protecting an Excel file published on web from unauthorized copying
Update References in Formulas when Columns are Inserted and Rows are Skipped
Working with name ranges in vba
Excel Programming/ Fucntion Guide
Cell Protection
One for JMB, DE-concatenating, but keeping relationship
Data Validation Multi Select
Exception from HRESULT: 0x800401A8
detecting application idle time in Excel 2000
i've tried every thing relative reference problem.
Macro with memory
How do I use For loop to pick different Range of cells to Select & Merge?
Custom Toolbar
Corrupted CSV file- '!' character and line break
Custom Right Click Menus - Inconsistent Functionality
legend naming issue
[GetMacroRegId] in Immediate window
Sort Worksheet Tabs
ActiveX Option Buttons
Saving "ThisWorkbook" code
PC runs slow whenever workbook with UserForm is open
Simple VBA Module functions do not work on the worksheet!
Web query - Pulling Tables
How to pass unique custom file name to Save Dialog
cell formulas
Email from Excel with Selection of Cell Value
automate clear clipboard
modeless dialog box
.csv problem?
Returning last columns with no values in (but possibly w. formulas
create a button that put a Hyperlink in a field
How do I convert to .pts or .ibl file?
copy selected rows to a new worksheet
Re: Offset
Checkbox resizes?
Re: Offset
Need help...vlookup "type mismatch"
Calendar help
Checking sheet for values and capturing column name
unexpected error (32809)
resize excel chart embedded in word
Searching for specific case
How do I create a Formula bar toggle button
Why Doesn't This Nested "with" work?
Can I trap "formula too long"??
Saving 2003 Excel file on Excel 97
Using an existing autofilter in protected sheet (with code)
To Generate statements(from source) for multiple rows to destinati
Marking Col. A if number matches
Sort groups of 5 columns by the first column in each group
Missing Ref
Lookup with Index / Match
Visual Basic
Sort groups of 5 columns by the first column in each group
Looping through worksheets
Emailing an Excel Spreadsheet
Advance cell reference
opening a pdf file from excel
Cleaning up variables, memory
ZIP Code insanity - , How to…vlookup, formats, number of digits.
Macro hot button in Spreadsheet
TXT -> XLS
A Strange Excel Question
[VSTO] Display "XML Source" with c#
Excel Web Services - SetRangeA1
Date format in Excel query
Determine the colour of text in each cell in a range of cells
renaming worksheet with cell contents
unhide sheets
placing PDF logo on a button
How do I delete last two digits without going in each cell-Excel
Set Header and footer automatically
Digital signature/certificate
disable Menu/toolbar items
Getting folder paths
Comparison between two similar strings
Automatically ZIP Excel File on saving...
Save VB Userform Frame1 as Image?
can i create a reminder to pop up in excel?
Make name assigned to newly added worksheet persist when file save
XML Excel File
XML Excel file
Error while creating excel sheet in office 2007 using mhtml
Insert New Row on Sheet Not in Focus
copy and insert cells with macro
Email in VBA - getting a warning before sending
Write data in a closed file?
RibbonX and a "macro may not be available" head-scratcher
Macro in Excel using an Array to Delete File in Directory if it Exists
Selec the column to add in a listbox
Find in Oracle
Validation
Validate issue
Print/Not print depending on dropdown list value
Macro to put picture in background
Excel Unhides hidden controls?
Is there a built-in function to combine 2 ranges?
referencing a cell in a macro
Add userform to excel workbook using script
Why is Workbook sheet change being activated?
Can't change NumberFormat via Command button
protection problems with 07
Using VBA in Excel to locate a sheet
Copy/Paste Values Only
Call Calendar
Call Calendar
visual representation
VBA and validation list
Get Tab Name to Input Dynamically
Finding external data link
How to get individual range objects from a set of range objects?
RE: Floating Execl Form, etc
Named range scope question (using application.match)
Copy and paste Named Ranges
countif for two ranges?
Help raising an error from an Excel Object (e.g. Worksheet)
manipulating text file from excel via vba
Copy data based on IF statement into new worksheet using button co
Offset
Excel: VB Macro programming problem with formula writing
lookup by column & row
More efficient macro help
format validation in UserForm textboxes
Specifying a Range in the SUMIFS function
How to sort AlphaNumeric Data sequentially with spaces
find fuction macro to look-up name
List of Shortcut Keys
Pivot Table & Dates
stop excel updating from word
stop excel updating from word
Edit replace within data table formula
Doing what if scenarios with multiple worksheets
macro to import a rtf from word into excel - from excel
Option Base 1; how to also make auto-arrays set to base 1?
Skip cell if X nonexistent, populate next cell
Worksheet_Change
The difference between two dates.
Outlook contacts list into Excel worksheet?
Is it possible to protect parts of a worksheet, certain cells?
Select i Rows
Counting rows based on multiple values
Code to unfilter if filtered
Running Macro in Excel to mailmerge and print in background
Copy table column from multiple word files into excel
Excel files update
reformating date
Turn ON design mode...
Kill Excel
Excel tabs
userform command button checkbox problem
Date stamping based on cell value
Text formatting - Change Font Size
Forgot open workbook password
Adding a new row
Return a random number from a list
Listbox jump to value as you type
Activation inheritance
Runtime Error 13 help
Getting sheet to find data
Find range of merged cells
Link porblems
email worksheet contents as text
Material Require. Planning (MRP) & Capacity Require. Planning (CRP
Re: Check/TIck the selected Item List in Pivot Table
Re: Check/TIck the selected Item List in Pivot Table
Icons for Visual Basic Buttons
Loading Data into ListBox
How to find the Expected Value of a PDF
Link question
Trouble finding cause for Excel crash
Write data in a closed file?
Slow Down the Macro to View
trying to use dynamic ranges and names for dumb bar chart
Open and Append based on input string
Populate ComboBox with Enum
PivotTable.Refresh woes
Sending multiple emails at same time in Excel
Two Ranges, Spot Different Values
Buttons on Worksheet
Macro automatic execution x times
Two Ranges, Spot Different Values
Keep Excel Formula constant
Copy based on condition in target cell
Delete columns based on cell value
Multiple Bars: How To Make Them All Side-By-Side?
Copy Record to Appropriate Worksheet Based on Contents of Column A - VBA.
How to publicly set a variable?
Help with error
Insert Row every 13th row, then Concatenate
pivot table
Changing view as well as selection from code.
Performance Measures and Conditional Formatting
C# Excel Replace text in a range
C# Excel Replace text in a range
Performance Measures and Conditional Formatting
DoubleClick Method?
Input Box Formatting
Reference columns using For each r in currentregion
color count...
Architecture Question
Changing the focus in an inactive sheet.
Can't open workbook
Formula in VB
ADO.Net 2.0 version of CopyFromRecordset
How can I tie a workbook or worksheet password to a user ID
error: Excel encountered an error and had to remove some formatting to avoid corrupting the workbook; please recheck your formatting carefully
UserForm - Setting focus to a CommandButton based on a Cell's contents
xla security warning
Macro to print selection
Transpose and remove blanks
macro timer
excel marco
Result posts before Function executes
Simple Copy/Paste Question
create a calculated field for pivot tables
Distributing spreadsheets with VBA code
Deleting rows from all sheets in an array?
increment a row reference with addition
Sort Ascending/Descending
Varaibles as both integer and String
strange 400 error from web query
ASP.NET 2.0 Excel 2007
Cell Fill Colors
Runtime Error 13 Type Mismatch
How to use .NET classes from Excel 2007 ?
Run time error 91...pointing to where...?
Getting data from AS400 to Excel with SQL
Appending contents of clipboard to a selected cell range
.NET Interop Copy all cells from Worksheet to Clipboard
2007 EC Excel / Access User Conference
Chart display area
unhide sheets
DAO Parameter Type Mismatch
link broke
Print a word doc from Excel
Print a word doc from Excel
importing back code modules
UPDATE : Phantom VBA Projects (again)
Setup ComboBox when open workbook
Run excel macro on one xls from another xls
What's wrong ?
Font Object
pop up list box and line graph
Coding email with 'read receipt' requested in VBA
Finding the Size of a Range in an Unopened Worksheet
How to create a custom numner format for IP addresses?
write macro to fetch particular column in workbook to another
Connections bug?
Creating a Excel Interface to connect multiple varied databases
"Match" function returns wrong value
Copy/Paste Excel Cell Range to Word Bookmark
Ensuring File Name is Blank
Creating a name with VBA
Continuous Macros
worksheet change not triggering
first user form
this.flattenPages()
Find & Replace macro help needed
Can I use COUNTIF and AND together?
Check if a named range exists with VBA?
Loop Thru Worksheets
how can i remove commas from the alphanumeric list?
Find / Search for two column values?
Chart: "Line-Column on 2 Axes"... but...
Compile error 'Method or data member not found' when closing Excel
Applying Protection Perameters With VBA Code
Chart Title Length
Simple Row Offset Question
Send Email on Update/Close
Determine format type from strings
list sheets in range
creating worksheet with code - limitation on number of worksheets?
Pivot Tables
Conditional Formatting Question
Conditional Formatting Question
Conditional Formatting Question
Another "Object doesn't support..."
Populate an array with sheet names?
Can you use "Target" in a Module besides the worksheet module
Conditional Formatting and Percentages of a set target
Password when Check Box is checked
Saving web pages with VB possible?
Skipping cells in a formula
Verify data validation status inside VBA
How do I skip cells in a given range?
Save filtered data as a separate file
View Modules
copying cells at a specific interval
How to keep comboboxes stationary
Adding Header to CSV
How to publicly declare a variable?
Dlook up Access
Choosing the Version of Excel when opening an instance
Need to know how to automaticaly customize worksheets in specific
Allowing users to run macros on protected worksheets
DateTime datatype in VBA
Inter-Connected Worksheet_Calculate events
RE: Do Until Loop not functioning properly
Select hidden cells
Select hidden cells
Excel Macro Q: Insert-Picture-Scanner....how to?
Skip LOC in D While Loop
Naming UserForm CommandButtons using VBA
figuring return type of a field
run macro when closing file
Javascript funchtion converting to Excel
Find closest date or matching
Last 4 digits of SSN
Index Popup
Days per month for calculating storage days
Cell help
CODE FOR DATA SUMMARY
Userforms: 508 Compliance question
Failure with Excel.Application Call
Creating Multiple Graphs in Excel 2003
summing on a unique list
Macro problem
Re: Opening a Word Template from within Excel
Column letter reference as number reference
ActiveWorkbook.RefreshAll deosn't work in shared mode, "calculate" doesn't either
Need to Sort Multilevel Data List
Restore clipboard from Task pane clipboard content?
sort list
Pass value to form to subform to subform
Hide a Sheet Q
VBA for Importing Text Files
Question on Forms and functionality of macros
Autofill a Pivot Table
Individual values from a Combobox List placed in textboxes
User dialogue to browse folers
Accessing Values of Cells On other Workbooks without Opening Thm
is it possible to toggle display of project window with control-R
Help for Excel UDF & its Parameters
Recreate Data Validation
Clicking submit button on web page
When I sort it is carrying my formatting of cells
Curly Question with a Combobox
Button Editor in Excel 2007
special folders: references for Shell Controls
The macro ... cannot be found
Using one Input Box Method For Two Separate Macros
Excel 2007 - WordArt Help Needed
Excel Text Color Conditional Formatting
Excel Text Conditional Formatting
Using VLOOKUP in VBA
Copy ListObject with non-visibles NULL
How many named cells
ADODB.RecordSet
UserForm CommandButton Caption
Calculation Setting
Variable excel formula
Link comment boxes based on different cell values
On error go to 0
Delete Rows except
Userform - Query Help Please
Recover Password
Increment Cell Value by 1
Using VBA to create and format Chart
Scan data on worksheet 2 and display a summary on Worksheet 1
Command/Menu bar & assigned macros
A list of software in Excel to show as header
transfer data from word userform to excel
Emailing Help
Updating Calculations
Emailing a worksheet
Pulling conversion rates
page break location in VBA
Looping with incremental variable/object names
ENTER DATA - LOG ENTRIES ON SEPERATE SHEET (IN SAME BOOK)
ive been stuck for 2 days
row movemwnt
Window Split and activecell
Excel AddIn .dll problem: 'Can't find object or library'
Print visible rows only
Simple CountA syntax (VBA)
Data Point values from chart
Line Feed in Formula Bar
Read File From URL
Base class members are not exposed in Excel using Web Service
Accessing cells in Excel spreadsheet from Visio
comparing 2 fields/cells and displaying a message programitcally
Find & Replace Very Slow in VB But Not Manually
Wrap text doesn't work when sheet is protected
Filename leads MacroName
Pausing code execution until calculation is complete
Decimal Dilemma
Capturing last column's letter
Worksheet change event problem...again
Read values from an Excel Table?
drop-down / combobox in a custom toolbar
Running macro automatic after opening Userform
converting time as text in formula to get sum of cells
chart text position
Slow running SQL via ADO connection in excel
links
Excel crashing problem when saving from VB
vba filesystemobject EndOfStream EOF
Excel VBA to VB6 Conversion
Consolidate data
Excel extracting Headers and Body text from MS Word
hyperlink formula to its result in same cell
ActiveSheet.Pictures.Insert
Str to Currency round problem
Excel dislikes searching *.zip in WinXPPro
help me!
PMT()
macro column lookup enter data in another column same row
dynamic validation list
Generate Random Groupings from List
Weird behavior for excel file when open it in web browser.
Delete Duplicate data row wise from each cell
Userform: Display Scrolling View of Columns A:C
How did he do this?
Copy UserForm
creating variations of existing excel formula
return what page a named range is on
Omitting #n/a from calculations
How can i find and View required values ?
print values in an array
using a macro to apply data validation to several cells
Using "protection" as a macro condition
dont know...
Re: Combining Cell Contents
calling a user defined add-in
Changing a cell color inside a function called by that cell
Combining Cell Contents
is it possible to toggle display of project window with control-R
unprotecting project
please help
Find and Delete Row from Range
Disable Macros through VBA
storing code in Add-in
Can't change macro assigned to drawing object
Find & Replace and Find & Insert macro help needed
Serious Slowness in this Situation--EnableEvents apparently not the issue
UNABLE TO PUT THE SUM FORMULA IN VISUAL BASIC
Static variable
Report Taking Me Too Long
Set range error
protect all sheets macro crashes when sheet is hidden
Re: How do I insert barcodes from a scanner into Excel cells?
Macro Paste
The best sub for last row / last column / last cell?
count question
find first empty cell in range and copy information from another workbook
Opening excel
Out of Control File Size
Help with table lists or whatever you call it.
Keyboard key assignments change...
Macro on Protected sheet
Make Border Lines Stay during Cut & Paste of Cell Contents
Change to Current Cell
simple question
Re: Remove characters from string
How to Change Source Data after copy sheets from another workbook?
Barcode Data - Look up data
combo box
Re: Dropw down user form in Excel
Random generation.
Auto refreshing data via VBA
Re: How do I insert barcodes from a scanner into Excel cells?
Re: Remove characters from string
VBA Filtered Subtotal - require sheet activation?
OnKey
Re: Remove characters from string
Re: Remove characters from string
Syntax-Change?
API call to replace taskbar icon
Gantt Code Needed
Help to amend code which prints only certain sheets
Input box default = last input
if function
C#/Excel automation add-in not working on MediaCenter?
Re: discipline, resources, and above all, common sense and ingenuity.
Activating an excel custom menu bar when external application is a
How do I save excel text without formatting?
Use Portugues Excel with functions in inglish
converting text to number
Can someone please check this formula
Automating An Excel 2007 Application using VB
making a text string recognizable as a name range in excel
Putting a formula in the first empty cell in a row
This code crashes on one but not all machines? Any ideas?
Before Save Event is not working when called from another Procedure
How do I round to the nearest 25 cents in Excel?
adding button to commandbars crahes Excel when started
Basic newbie question
Worksheet change to control worksheet visibility
Reference Cell # with variable
Copying a formula from one line to another
Code Termintes
Need to use Replace menu when the sheet is protected
VBA code to open and copy a file
Excel Macro or VBA
Cells.Find
error using userinterfaceonly
String Comparison Help needed (Simple I hope)
how do I delete all text before or after a symbol?
Runtime Error '1004' Method 'ActiveChart' of Object '_Global' failed
this line of code works on some machines but not others
Problem programming .SeriesCollection().XValues and .Values
Excel Macro / IE Form / Alternate to .Value
What If and Drop Down List
RE: Updating link to database w/o breaking the link
Adding scroll bars to cells in a table
Link to Multiple Cells Within One Cell Including Text
compile problem
!!Macro to attach pdf and reference excel!!
Need simple code to skip blank rows
my compile code option is grayed out in excell 2003
Control buttons missing
Create toolbar
Menu gone, what am I doing wrong?
Selecting multiple dates with Calendar Control 8.0
Check for instance of Internet Explorer
Macro Help
2 macros to insert new line
Adding & Processing Columns
Get Mouse Coordinates
Excel - XML Page Breaks
Can't set CommandText if pivot table copied
Removing VBA from a workbook
Eextracting sections of Text from MS Word using VBA code?
Extracting sections of Text from MS Word using VBA code?
Excel macro to attach files in Outlook 2000
digital signature useless from com
How can I bring up the brose pop-up screen with VBA?
Copying chart templates to other workbook - Links
add-in help
UBound
text position in charts
Highlight Row and only certain Column cells
Disable Range Selection Change
Downloaded Excel opens blank in IE only on certain machines
Only print rows that contain data
force print of another sheet
Print textbox-content possible?
Maximum worksheets in an Excel
Maximum worksheets in an Excel..
Move and rename a file
Move and rename a file
Cannot get vba function to execute
Range Selection & XValues in Chart
Using my macros in 2007
Assigning big 2D arrays
Display output as blanks with average and large value set
Sort more than 3 columns + choose ascending or descending
calling external program from VBA
Macro paste values help
Web Site Loading Slowly
vcf. Transfer
2 conditions Countif with offset
csv with embedded commas???
Code with formula interfering in worksheet change event
Data validation using TextBox in UserForm
One more try...no solution now for a month
Access to an EXCEL VBa application thru the web?
Help with Spreadsheet Toolbox Control
Modify windows language using VBA
Signing a macro
Forcing a certain date format in an Excel column
Coloring a range of cells based on a time frame.
Invalid Page Fault when I copy a page
How to add entries in the Menue bar with VBA code?
How can I store both key and value in VBA?
automating the name of my files
exporting text with quotes , i.e. "value"
Get multiple cells from all worksheets Code Not Work
unprotecting modules
Move the cursor to end of data in textbox
How to get ActiveWindow
who creat this spread sheet?
Temporarily modify international options
FreezePanes on a Row without using an ActiveWindow object
Is there a Better way Q
Msg Box VBA Issue
Trouble with passing a range into worksheet function in VBA
Macro to combine multiple workbooks in a directory into one workbo
Check Box Value
FileDialog deactivating the close button
vbscript for partial match in two columns
Line Start and End Coordinates
Adding to excel user form combobox
Mode of Text....
how do I create a dialog box in Excel 2003
If A1 is empty, then delete the cell I'm in - with data validatio
DisplayAlerts and QueryTable issues
Permission on adding an Add-in
PDF files
VBA macro to delete rows that contain text
Select specific cells in same row as active cell
Select specific cells in same row as active cell
How to jump from a Form procedure to a Workbook or Module procedure?
need worksheet tab magic
Textbox format
Concatenate values based on array
Acrobat Annotation
Passing variable among controls
Passing variable among controls
Addition string from input box in to a formula (eg;R1C1 Formula)
RE: Dynamic range - start
Mirror Cells
Print/Open fdf/pdf files
Print/Open fdf/pdf files
VBA Function gets slower every time I use it...
Running a Macro at every Solver Iteration
Status Bar Question
Delete Row
Excel Macro to Auto-Populate a Word Template
grouping rows
Formula using INDIRECT function?
Cell Formatting Issue
Pivot Data
Pivot Table - Selecting the GrandTotal Column in VBA xl2003
Runtime error when trying to save Excel 2000 worksheet from VB app
Show only matches between a named cell range and the values in a page field - vba
RE: Can I make a cell into a macro button?
OLE Commands to Duplicate a Sheet
Procedure too large error
Conditional Format, copy down
Expanding Viewable List in Drop Down Menu's
last cell in range
Generation of filenames
ODBC error
"Strange" array formula issue
How do I modify charts thorugh VB
chart labels
Relate 2 tables in excel
Can anyone point me in the right direction please?
Open an excel from a .NET stream
dividing an replacing spaces in string
Help required
Subtotal in samll file take a lot of time (VBA)
Const Array
How to find a cell's location/index within a range?
Alternative to custom views?
Updating a chart
Re: Excel Takes Memory in Terminal Server session
how can i remove repeated names in a column?
For Each cell - Variable not defined (VBA)
Input box to select column
Adding large amount of data to range get excetion:HRESULT:0x800A03
Appending Two or More Excel Sheets
this macro is slowing down my spreadsheet
Declaring a tab name as a variable
Calculating Fiscal Period based on Date
Declaring a tab name as a variable
Excel Capabilites when interacting with Outlook
Problem when opening 2nd spreadsheet with vba while in another!
RE: Available resource limits, memory leaks and linked files
Batch File drag-n-drop processing.
Formula or Macro
Re: Positioning of Chart Objects on an Excel Sheet
Scientific Notation - I wish MS Gave us a switch to turn it off
Turn filters off and back on
RE: loop and sum
Ablity to just recalc one worksheet
user form check box vba
Building a new userform
re-naming styles
Excel Button and Drop down image missing
Form elements change size with Screen Resolution change
Re: How do I parse cell contents to break out Last Name.
Re: MailMerge in Excel
End of Month Function in Visual Basic
VBA to hide rows?
how to use vector name with a formula
File Exists
File Exists
Re: Page break macro
Re: Page break macro
MkDir Simply Not Creating Folders
Re: Excel VBA to execute Visio VBA
late binding
Re: Pasting Named Range List to a Worksheet
Macro to format dates
Pivot tables and merged Cells
Re: When hiding a row, how to avoid useless and long calculations ?
how to get rid of "^M" in the output file
How Do I Get This Macro To Loop
Breaking up part numbers
Re: Userform results as Autofilter Criteria
Re: Excel VBA to execute Visio VBA
Excel 2000 - Macro Short Cut Key
Re: Selecting a Printer on a network
Re: Printing a User
Re: Error When Assigning a Macro to a Command Button
RE: Gathering data - individual points for a single topic
Re: return to original sheet
Re: Hide Rows
Re: return to original sheet
Re: Printing a User
Re: Find and Replace from Hidden Worksheet
Formula
VBA and PDF
Sequential Number Generator Macro
how can i output the file
Re: loop and sum
Re: Running macro from closed workbook
Re: Running macro from closed workbook
Dynamic List in a Report
Msgbox and variants - a deadly combination
Gathering data - individual points for a single topic
Insert or add one number at right side to ISBN
Upgraded XP >> 2003: should I hold my breath?
Spreadsheet takes 20 seconds to open before Workbook_Open
Re: change event
One more question on worksheet protection
Sales Budget 2007 per Weekday
User Input into Hyperlinks
determine row where activex control is placed
Qutting VBA code in case of error