Excel Programming [Archive] - Page 78

Label Colour Fading
Split up word in cell
Sorting
Paste clipboard to a comment
Splitting Text Out of a Cell
Replace() to "Find whole words only" ...
ComboBox List Formatting Issues in European Regions
unprotecting sheets in another workbook (syntax problem?)
Find Date form list
Personal.xls vs Add-in
How do I remove macro at excel startup?
MACRO, help for making
What is this code doing?
copy cell based on condition where row numbers are not the same.
Error 1004 Method 'Range' of object '_Global' failed
find mid value of string data in data with integers
Loop, If or another thing to use???
combobox auto fill in unicode...
A macro to update links
Range within Formula
Find text in specific cell??
importing entire workbooks
Validation and active cell
Help about creating excel using template.
Help about creating excel using template.
Help about creating excel using template.
can i rearrange names in alphabetic order
Two diff passwords(or protection) for sepate columns.
Identifying last row number
Copy Data to a new sheet
print screen
determining resolution of current screen display
Macro doesn't work on UserInterfaceOnly-protected sheet
Using filter heading name instead of number
URGENT HELP ON VARIABLE COPYING PLEASE!!!!
Splitting text in a cell
can i rearrange the following names in alphabetic order..
Code to convert text input to a number
transferring matrix to range
transferring matrix to range
hide/unhide rows depending on the top input value
Find cell with duplicates
cell resizing
Find cell (with duplicates)
If A3=alpha numeric,"X", if A3=text,"Y", Blank
How to refer variable while assigning string value?
tabstrip,scrolllbar related
call macro to format form
How to avoid error?
how do i save as from a macro
Compare cells including formatting
Pst password HELP............Please.!
Error in formula
date format in user form
Compiling Computer Vision Research Data
fill blank cell with cell above: special case
Run code without opening worksheet
How to scale from Excel screen to printer?
Minor/Major dilemma...
Decimal Formatting in Windows English vs European Formatting
problem of converting days months and years
Validating data at data entry and XSD
transferring array to range
binomial distribution
Remove Timestamp from date
blank cell shows as a "0" in a formula
form activation?
Date in TextBox
Assigning Short-Cut Keys
problem with days months and years
Difficult planning
Need Help
find and replace text
Is it possible to create a editable textbox?
Decimal Number Format in ComboBox
Path and Name
Audio Files Metadata
replace in multiple sheets
Name a Range based on Dates
MutiPage control question
VBA Loop Case..If syntax
Deleting "most" of row
Global variables
Produce Statistical Information
MouseOver Substitute in XL
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP?
how to code the clock text ?
Array size limit when using WorksheetFunction.Transpose?
PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ???
VB Function in function list
Hide/Unhide Form Control
get last line number
Variable values
Need Help to copy data from one worksheet to another
question about creating array
How can I copy a Combobox with all items ?
Buttons/1-add rows /2-auto save & name, close, send in email
arrays
Find first visible row
Citrix Excel VBA Search "There were no files found"
Store calculated date as a literal value
Using Advanced Filter w/o having to set focus on the sheet
VSTO Excel -floating action pane
calc
2 Listbox's not working
Export spreadsheet data to PDF or Word document
Normalising the values using VBA (algorithm given)
Combo Source from another file
Microsoft Money data into Excel
Load picture from file to custom toolbar of Excel 2000
Transfer Module1 from PC to Mac
MACRO - Unmerge cells and delete blank columns, leaving data colum
software thuriam
problems with VLOOKUPS?
MultiPage control
Graph not updating
how to popup msgbox once exit ?
print xls file
Find "Not Equal"
Syntax error - FSO related?
Picture inserted onto my spreadsheet will not print
How to: OLEObjects WITHOUT a border/frame ?
Openning a UserForm
print out a document directly from a cell in the same raw
Copy Worksheet from another file
Splash screen and printing titles
a very urgent help in VBA
Autofilter - Toggles OFF ?
Hide a formula
Select cells copy/paste and repeat x times
Keyword
Protecting Sheet
Pivotcache
I need some Help with FollowHyperlink please (Error 432)
Help Requested
excel copy cells to word template
Various workbook questions
Getting 0 instead or blank cells
formula question
Function Based on Chart Data Won't Recalculate
Macro in Excel to check if another workbook is opened.
Return a formula
How to write visual basis code
Anyway to improve on this code snipit
Object Required
counting occurrence of specific words in another group of words
resize userform image to fit on any monitor
Force event code to NOT respond
selecting a range according to the longest column
Range of variables
Tabstrip related
Text to Row by Delimiter
RowSource
Comparing Times in Text Boxes to Times in Cells
userform initialize
Help: Macro Adds Rows, Need to Update Totals with New rows
Shifting information from multiple columns to one column
check box and Wacom
Custom function, sheet vs array
Mass amounts of buttons
Diagramming stresses in a section with excel
Excel - word
finding the date
UDFs in Excel
Macro to combine variable multiple rows
Not a valid add-in error message?
Where is Excel Customization?
Convert Multiple Rows into One Row
Assign MAcro to command button
Database Question
VBA Click Command Button
Identifying value in a cell knowing R1C1 naming
Get rid of formulas
Special characters in a string variable
I have two columns (A) and (G) that have like product codes however
Create DLL in Visual Studio 2005 accessible by Excel 2002
Event to trigger when a cell is moved
Help with simple looping program
I need help matching columns
copying a formula across, but the row will vary
syntax - range name as a variable
Array to Access
Maintaining Maximum Platform Compatibility
"Method 'Selection' of object '_Global' failed" error
Custom Userform
Remove Hyperlinks
Help - Code not always working
Excel VBA
Macros (Sub routine type) not found, Functions are In XLA
Simple and Bulletproof Save/SaveAs Procedure
Retrieve data from company intranet page
save an autoshape as .gif
Scratching Head!
Add data to a column based on other column data
Lookup values in textbox and edit row
Can anyone help me convert to more efficient code?
Find right cell (with duplicate values)
Hexadecimal to Binary Conversion
Remove blue hyperlink line
Another For Ron
Macro to input total copies from a cell value
Printing to envelops
URGENT help or features needed for sox compliance
=IF((OR(B11="",B10="")),0,IF((B11<B10),((B11-B10)*24)+24,(B11-B10
How to COUNT in this case
Delete Row when value inside cell is less than 0
Select rows with certain values, cut, paste into new worksheet
Replacing Sheet name in formula
VLOOKUP and VBA
Multiple For/Next Loop help
How can I do this message box?
standard deviation
Get file extension formula
Showing Spreadsheet values on a userform
Watermark in excel from vb.net
Not looping through rows
Save spreadsheet into folder based on today's Date?
Calculate specific sheets from several Excel files
Excel 4 International Macro
Changing PivotTable cells in VBA
connecting database curopting excel
bad data when i change string to double
Need to determine the ROW of the TARGET in a Worksheet Change Even
How to prevent "Changed ... Save?" Message after disabling Shape?
I have two workbooks
Range
Pulling values out of cells using automation
flag if UserForm is resized
Colouring error bars in a chart
[VBA] pb with "group" method
type missmatch on Selection.Offset
What is the different btween Userform_Resize and Userform_Layout
Export Japanese from MS-Access to Excel
Adding more series to a XY scatter chart
Secure, license and sell spreadsheets
How find out the Query when the Excel connects to the OLAP
Update formula in Multi sheets
A Ruby/Excel issue - Cross posted from Miscellaneous
Templates
Updating Issue
identifying caller procedure
help needed extracting data accross the row into the first cell of the row
is it possible to get the user name........?
Retrospective worksheet change event?
Column Width
Locating the directory a workbook is stored in
Sql server login prompt
compare two text columns and find the closest matched pair of cells
finding matching rows
Sheets Name
Creating Excel 4 International Macro Sheet
Error Handling - Infinite loop
Cell formats
How to extract excel sheet cell comment?
???How to set chart position
How can I use this VB script to reset my values on other sheets?
Still trying to return the progress
Using IF statement to make conditional formulas?
creating macro to edit cell contents
Out of Memory error
Custom Format: Number * 1000000
Showing MsgBox after Control Toolbar macro runs
Kill a File
Taking focus off control on sheet
Having macro add PasteSpecial Values button to toolbar
Finding elusive control on User Form
How do I return the progress
Automating a Pivot Table
Editing Shortcut files
Macros & Digital Signatures
Find Select Macro
Modifing a recorded macro.
Help with code for Macro!
Selecting sheets based on cell in each sheet
Take a look at my code and tell me what is wrong with this
Cannot Activate Chart Area in Chart. Chart Object Failed
Importing to Excl 03 from Outlook 2003 Custom Form in a Pblc Fldr
how do i open a picture file by clicking on a certain cell?
Excel rows into columns
macro refinement
Change cell color based on another cell value
VBA Editor: my default font is gone,Courier New(Western)
Excel Macro 4.0
Defining series range for named range
code does not work when opening again
Checking for [Ctrl] + [Pause/Break]
Indirect.ext - Eek! Doesn't Work
excel to word! charts+tabs
ThisWorkbook.Saved = True does not work when Shapes().ControlFormat.Enabled = False
activecell column to a given range
How can I pass values in cells to hyperlink to get result
Removing spaces from value using VBA
Combobox Question
Printing on an envelop
how can i get a macro in personal.xls to know my current workbook?
Find/Replace functions VERY slow when visibility = false
Deleting Cells where content equals "0" or null
update formula cell
macro to hide/unhide columns
Replacing alt-enter (think chr(10)) with other text
Protecting Worksheet Tabs
How to get the address of the cell found our by vlookup
Application.OnTime interrupting Modal UserForm
Sum of values
Select cell by value
So odd, not sure what to call it!
time tracker - please help
Return to Original Workbook
Tab order in a user form
Creating Named Ranges with VBA
Creating Named Ranges with VBA
No more new fonts may be applied in this workbook!!!
Option buttons
how to lock comment only?
Unlocking a vba project within excel
Finding and Activating the first blank cell
Split out info in a Cell
macro to open a document
Change text color of specific date range by macro in Excel
Macro to combine variable rows
Tom Ogilvy's VBA code
Embedded Chart locations
Inserting a worksheet tab name into a cell
going to a cell that contain specific data
copying values
Unprotecting Saved Workbook Copies
Stopping the "This removes the subtotal and sorts again." notifica
Auto Display a Message Box
Assigning a min to a variable
Returning the Last modified date of a sheet that is currently open
OLAP pivot filters
VBA Function to talk to MS Access
How do I automatically generate numbers in Excel-Ex:1,2,3
vlookup
Adding "New Comment" command to all existing and new files.
Offset issue?
seperating data
Data Validation Behavior
Automating from javascript - can't get Excel window to front
Creating Worksheet With Cell name Once a Cell Activated.
Sum Formulae with more than 1 Criteria
Check if a value is an integer using VBA code
Obtaining min and max
TEXT-formula in VB Macro fails
Show Form whilst Macro is Running
FormulaR1C1 not working
Creating a Macro to take me to first cell of the first sheet
how to copy every nth column of a row to the first cell of the row?
Error Handling - Infinite loop
running macro at save/close/exit
Toolbar Help - keeping it specific
summing dynamic ranges
Auto_Open
Activesheet.pagesetup
How do I unprotect the saturdays on the atendance calendar
updating formula cells
Creating Excel 4 International Macro Sheet
displaying a "no match" on another worksheeet after a comparison
What reference libray?
Navigate through webpages
first 0
Underscored line automatically down in colums depending on rows
Find and insert?
insert pagebreak after a specific column?
VB Help (Excel Warnings)
Skip to next input cell on protected worksheet
Language Indepedent XLM Macro
MACRO range find last row
Copying Mastersheet layout to the rest of the sheets
on which column is the filter active?
Showing a calculation in a userform Textbox
Check for existing data
Find a string match in a column
macro help - extra contents of specific columns accross a row
Problem With Decimal Point
Drag and Drop
Type Mismatch Error
How To: Check pivot table data source.
Language Indepedent Macro
Deletes certain columns
search
Configure Right Click Menu
Copy and Paste using a loop
help!kill process excel.exe
edit data in multiple workbooks
randomize set of numbers
how to achieve this
Passing data to excel on open
Copy Excel Data to .CSV file
List Box
Need Advise !.. Is it the best way I found in WorkSheets_Change event
Selecting last row
delete workbook from one location and save workbook to new locatio
list boxes
RE: What is Excel. :) HELP, save me
Easy Macro
What is Excel. :) HELP, save me
save workbook as different name
Subtotals without left outlines
Cell A changes other Cells
how to find if an excel sheet has any hidden values in a cell in VB.NET
checking in vba if item is found within a range
How to change entire row colour when row is selected?
Create custom forms caused system error &H8007007E
If autofilter is on, then..
UserForm1 Not Displaying Textbox Content
Odd UserForm Behavior
Determine if range has NO Blank Cells without looping through each cell in range
Code to replace Formula
EXCEL functionality
Load form when workbook opens
Macro to retrieve user information
logging out
Excel & C# NullReference Error when trying to set Range.Value2
Copy and Paste in the first empty available line.
auto sort cells
OnAction macro in another wb
Application.Vlookup Type Mismatch Error
freezing data in a cell which was obtained using a formula
OWC11/Excel Column formatting
Attach all Open Workbooks to email as separate files?
How to elegantly end a main procedure from a userform command button?
Creating Subdirectory in "Default User" App Data
applying column formatting programatically
Setting a format in a formula
Using IF in VBA - only works in first several instances
Color color! Cell color!
select cells that correspond to a value in other cells
New to macros - find/move question
Inactive or incorrectly terminated Excel process images
Find Values and Return Data
Saying (And showing) Thanks
How to select Excel files ONLY
Runtime error 429
How to use an array function in a macro
Simple Macro?
Code works but is slow except when....
Help I need a macro or IF Statement
Insert a formula into the last row of a cell
Challenge for the day
Userform Defaults Text Box with Time
Application.Calculation during Change Event
Problem with ComboBox
Open URL For Input
Page Protection interfering with Hiding Rows
Runtime Error '9' Subscript out of range HELP
Deleting selective columns
confused as to why macro is not working correctly
Prevent someone from renaming a workbook
excel 2003 vba date function not working on all pc's
Takes too long ‘calculating cells’
Excel queries
Dynamic Link to MS Project
Re: Pivot Tables
Rather Complicated Process...
Source of call to UDF
If activesheet is called X, then do y
many subs or many modules
Excel Spreadsheet Protection
Nested Loop to copy sheets
MAX function with IF Statement
Check if the same data on another sheet allready exists
Excel sheet problem
Stipulation in command
Changing color of node in freeform shape
Excel Macro: Changing Color of Cell
Checking a String's last character
prob. running macro from diff. sheet
copy a range with known start column to variable end column
Eliminate Screen Flashing
comparing serial #s against another sheet then only displaying only the matching items and all associated data
Highlight duplicate entries
Integer only textbox?
Formula fill down
Hide Pages
Establishing a date range help with macro
Efficiency of Dynamic ranges
How to get sheet from sheet name
Mark if cells match on 2 sheets
Merge Cells run-time error '1004'
Exporting Data from Excel Form to HTML Page
Help Programming Limit Constraint
Help Programming Limit Constraint
Checking a userForm that has not been initialized
Setting a cell to Text and yesterday's Date?
How to make a ComboBox dependent on another?
FORMULA ERROR
Doing a save with a variable filename?
Looping thru Files In FolderSub
update active window
Auto Deleting of a Sheet?
Creating print areas automatically using VBA
Copying Charts: CODE NOT ROBUST
Setting Bottom Border On Each Page
Objects with .type property
witing for ms word to complete tasks the close
If Activecell Question!!
LinkCell Property
Unprinted cells
lookup function
administration tool
Application-defined or object-defined error (worksheet, range, sel
populating a listbox from an array
Stop the workbook from closing in Auto_Close
Countif with conditions...
Populating a list box with specific ranges
Sumis funchtion and offset function
Name of Right Click Menu
Create custom forums caused system error &H8007007E
Frame and scroll bar related
HTML outputs to distribute
Don`t show when running
Application.ScreenUpdating broken
naming a file based on cell value?
want to add excel sheet without menu on vb form
How do i subtract a half hour from a time when >8 hrs.
How do I step a Macro through a spreadsheet
Re: Macros and large clipboard error
SUM if cell is Bold
Detecting Row number
ChangeLinks fails if formulae exceed 1024 character limit
VBA code needed to apply formula to each value in a dynamic range!
Copying Duplicate rows
Before macro runs - check workbook name
code to enter in returns
ActiveX Control Item Numbers
How to generate a Map from an Excel Cross tab report using MapPoin
Find Excel files that have hidden workbook
Problem saving excel as CVS when last field is blank for all values
How to create a custom function
Extracting data from Access - error encountered
emailing a workbook from within excel
~~~ Distinguishing Normal; X1.5 and X2 Hours throughout the week by what day and time they are worked ~~~
Add Header/Footer to excel report from ASP..
Array to read data from one sheet and write to another if it meets criteria
Excel AddIns - changing locations
Copying Sheet - subscript out of range error
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C
Using Worksheet Fuctions with Macros
selecting the cell that a vlookup or match function references
Missing Column Using QueryTables.Add
Excel Routing Slip
Second Click on Control Button
Sort MultiDimensional Array
Clear Text in Text Box control
insert the value of a cell in a colum that is bigger of an preestablished value
Programming around Vlookup Errors in VBA
lots of makros into one makro??
Can you disable the macro security alert?
excel colum in alphbetical order
Help! Trying to avoid cut & pasting!
column aliases dropped with database query
Userform in BeforeSave
Programming around vlookup errors in vba
Match data to find intersection
PLEASE HELP! ASP to Excel Convert hard to soft return
Filter ListBox Access data from Excel
Request Directory From User - VBA Code
doent recalculate on save
Preventing incorrect data from being copied
Excel 12 Add-In compatibility - registerXLL fails in Office2007
Getting input within macro without the input box
Create a Summary of fields "NOT UPDATED"?
Disappearing grid lines
Mail Merge in excel?
Article Relabelling
Disable Worksheet Name Change
Calculating Daily Averages for Different Products
Article Relabelling
Add future date to cell
MS Forms 2.0 Object Library
Email excel as body rather than attachment
Time stamp - data input to row
How do I tab through TEXT BOX objects in Excel?
Pivot Table: calculated item problem
Macro to Add Row and Copy/Paste Merged Cells
VB to dsiplay value from drop down list
Excel Network Problems
MS Excel application developer needed -- in Seattle
Else Without If
how to lock/unlock comment ?
how do you show the drop down arrow all of the time?
Vlookup help
Clearing Cells
Auto Change sheet value
Auto Change sheet value
Lost VBA password
Refer to rows in a range
append data from text box
Import to Multipule Sheets
type mismatch
"If formula" within a loop
Localisation of Range Names
Comments formating performance
How to reset the Application.StatusBar
How can I make this code more efficient?
Online Home based Internet jobs for Indians. Earn 750-1000 daily. No Investment.
Challenge - Help - Move Data to New Worksheets w/totals and timestamps
Challenge - Help - Move Data to New Worksheets w/totals and timestamps
Folder Size/File Count
Auto-Hide Columns
Delete Blank Lines
Selecting point from chart while executing macro- is it posible?
Skip over a particular error
combinaÃ§Ã£o de numeros
Storing a vba lookup in an array
Not Nothing
Run time error Macro
VB Window automatically displays
Formula Help
cuting sheet and naming it based on value in specific cell?
websites
Comments formating performance
Unable to copy sheet
Hide/Unhide Sheets Form
Dynamic Range
Worksheet change event for data validation??
Copy a spreadsheet depeding on a variable
Finding a Date
Selection.Borders and replace with new colour procedure
Confused with lots of loops - Please help
Scroll bar to a label..possible?
PasteSpecial
Cells.Find wont work with "-"
Maybe this is not possible?
how to download task data
West Coast Excel User Conference - Announcement
Message box if cell is left empty when run?
Looper blooper
Endless loop
Help with Left() function in VB
Re: Events, Class Modules and Addins ... oh my!
Error: Cannot Set Range Class Property
Create reminders in Outlook calendar
Counting rows
Dumping Data
Autofill userform
Something embarrassing with ADODB
Autofill userform.
When using the find function.......
Checking files for write-access
cell 's width and height
Changing the default “macros in all workbooks”
Vllokup
Q4 Ron de Bruin
Initialising Referencing Paths
Route for new workbook
insert picture in email message
Serialization of pivot table
TextBox Values
Herez a Challenge for those who r up for the battel
All sheets unaccessible
Printing Multiple Selections on one page
how to delete ActiveSheet.HPageBreaks.
Select column same row by range name
Populating a column in a worksheet from another worksheet based on a common field
appending to .txt file format problems
Merge different excel spreadsheets w/common range but differnt val
help calculate time
Urgent Plea to all VBA Experts!!
runtime error in macro
Activate web link via image object
Extreme newb, easy question: Simple button/scrollbar coding
Formatting
Expiration date on Macro
Paste worksheet into multiple workbooks
Combo Box Question
FTP folder with excel
Problem Unhidding columns/rows in excel using VBA
ComboBox Question
Macro to clear Clipboard
cannot delete button
Graphic in a macro generated header
worksheet calculate
Want to run a DOS batch file (.bat) From Excel VBA code
Renaming Files
Events, Class Modules and Addins ... oh my!
Copy method of worksheet class failed - loop copying worksheets
Determining Save As Type
Name a chart and copy it to another sheet
Using arrow keys to move form objects
Opening a workbook
Macro to Unprotect save worksheet and protect it again.
Excel VBA
Subscript out of range error
bud hughes
Copy entire columns starting from a certain cell down
worksheets and ranges
Sumif within loop
macro to copy specific fields to another worksheet
SaveProtect&Close and Lockcells
Count Visible Range?
placeholders
VB automatically displays
Macro Examples
Password Protect
Vlookup vs Sumif
Date calulation
Skipping Columns
How to get list of all Excel macro names on my machine?
Dat Validation Different Sheet
Help undertanding Subtotals
Help undertanding Subtotals
Help undertanding Subtotals
Print from Option Buttons
keep first word only
userform
Auto Create workbooks and worksheets per columnar data
Central Macro Workbook
VBScript to prompt Save on Cancel click
formula
Copy and Paste
XLA Right Click addin
using a result from a web lookup in an equation
Unprotecting Sheets with VBA and IRM
Optimizing Index / Match function
Add icon to toolbar
Problem of With Target/End With block
Add Worksheet
Add Worksheet
VBA code urgently needed!
Drop Down Menu Help
Addin sheet
Compare 2 text colomns and match rows depends by cell content
Opening the lastest file
Embed Word doc. into Excel
Copy data to next available row
Probably a basic Addin question.
how to update this value ?
Right Click Menu
Input Mask
program a toggle between worksheets in the same file
Excel Addin using SaveAs Function
Problem updating via macro
Command Button Disappears when sheet opened
Border the selection cell
Problem using GetObject()
Checkbox to select image
Code just won't work...
Splash Screen off
userform.show question?
Late Binding Excel in Access
checking blank cells
columncount and range?
userform.show question?
Mixing For i = x to y and j = z to y for lines and columns
Heres the challenge!!!
Working with custom lists
Trouble with SaveAs .csv
INDEX functions problem
ms query refresh
Type Mismatch - Match function
Another ARRAY Question...
new instances of nested controls
new instances of nested controls
sum a specific cell in more than one sheet
Is there a clean way of running a macro?
Add in doesn't work on other pc
Copying cell comments to another worksheet
Run-Time error, type Mismatch
older site
Why won't this work
Accessing Web Service in the Excel 2007
cut in macro
If Error condition with Match Function
Converting Text to Number & Summing Issue
Run-time error 5
PDF Information
Run-time error 13, Type Mismatch
Deleting data
Please help summing problems based on day
Extracting a single file from a zip archive which has multiple files
calling a cell value from another worksheet
copy sheet format to new worksheet
Replace per VBA
No. of columns in XL2007 Beta
Play a Wav
Does anyone have a simple macro for this?
Moving Between worksheets
Run-Time error'1004' PasteSpecial Method of Worksheet class failed
Class quirk?
Menu problem
For i = 5 to 1000 for columns?
error using a reference in a range
dd/mm converted to mm/dd
How to set file Filter in Save dialog box
Repost:Excel not active / loses focus.Pls help!
Word to Excel
Insert dates from a userform
Insert dates from a userform
Combobox/Rowsource - loses date/time format
VBA code to list names of controls on user form?
Custom Msgbox?
Word to Excel
VBAProjects remain in memory after workbook is closed
Excel Paste w/ No User Input
Macro to Cut/PasteSpecial/FileSave
Starting Out
how to use (double) quotation mark as string in codes?
Access Pivot Data
How refer to current date in Excel SQL query?
Urgent help needed
Copy Across worksheets
Find and replace
Zero value
how to addshapes in a position decided by offsetting a cell ,
Index & Match Function
Hi Mr. Ogilvy how to Ctl+s to save workbook from Active UserForm
Counter
excel to autocad routine opens a new instance of excel that has no worksheet.
Vbscript Excel question
VBA error Not calculating If then statement
Replace SQL Table with Excel data
Haw can i test if CTRL is activated (hold down) in VBA
How to write an If Then VBA
A way to eliminate repeated info within a cell
Excel Add-in for SQL Server Analysis Services
Find/Replace macro from excel to word
maximum number of members in a collection
Code Correction Need
Scheduler Excel error report
Status Bar with ETA calculation
how to ignore memory copied ?
if statement evaluating to zero
Filling a listbox whith recordset data
Multi-Spreadsheet text and data extraction
List sheet names
Urgent help needed - Change in userform...
Defining Range using Cells
how to resolve a printer name
Insert a new column using a variable as address in a macro
Make upper left of sheets visible
code to check file size everytime an Excel file is opened
Test printer parameter before continuing with macro
test
turn off/on automatic calc upon open/close workbook?
C# with Excel and conditional format
delete row based on value of cell in row
Variable as result of Divide (Sum) Function
Can't Dim Range when Controlling Word from Excel
units = ActiveCell.Value overflow
Domain Name Sorting in Excel
Help with using vba to determine file associations
MMULT in VBA
file In Use
How to associated program
Sorting Data
get folder name
Alter text
Add double underline to row
Information about excel vs db tools
how to require pwd as pressing Alt+F11 ?
Help to run faster
Multiple sheet import
Copy rows with unique values to another sheet
Copy user entered Range from one sheet to another
Multiple Criteria - Shortening Code
strings
Export image from Excel using interop
Need some help with this macro plzzz!!
complex function
Insert Sheets & Copy
Combining the cells data for cells with same name
VBA - format a range of cells as hyperlink?
NEED HELP - I want last line of the sheet to go down automatically
Macro to link workbooks
implements statement
VBA Help
programa para combinar 25 numeros em grupos de 15 numeros
Hiding Columns running slow
Using a string to reference an address
NEED HELP with simple function
Getting Word data into Excel
Search text in multiple files in multiple directories
Sheet Protection
Excel Macro to email to addresses in "Contacts" Tab
Copy worksheets in excel automation app using VC7
In Cell Calendar
Copy and Pasting in Excel
Open Word and fetch specific data
Excel add-in works against RS report
Setting up Code for a userform
Summing or avg moving ranges based on week and day???
Setting a default path name under Save As Dialog Box
Cube analysis add in for excel and local cubes.
Program VLookup
Copy Function Question
Shared workbook shows wrong data
Selecting and then sorting a range
Run Macro Before Save
Footer Program
Footer Program
Footer Program
Simple Macro
Ping from Excel - Almost there
posting a question in the forum
Doesn't Recognize/Find Rectangle
Creating pivot table with VBA
Application.Calculate vs. F9
Change event due to Cut & Paste, Drag & Drop or Edit
AutoFit not working in vb.net when creating a xls
Sheet Reference Syntax
user's position of cursor influences macro
Macro to Uncheck Save Query Definition
Help - Send mail from Excel
check boxes in Excel - VBA Question
Dynamic Find
Opening Files
Userform text box return date value?
Problem with Activeworkbook.Close SaveChanges:=False
Excel event to determine if link has been added to the document
Is it possible?
NEED HELP - How to disable a cell to restrict data entry
Preventing sheet name changes (or a workaround)
Excel precision issues with float/single
Sorry - Pivots and Me Again!!
Help with method
check for non-empty cells outside of a certain range
Find End of String
Find/Replace macro from excel into Word
Loop thru two sets of numbers
I'm at a real loss here. Excel loses focus!!!!!!
Data transfer
Connecting Excel, Access and SQL Server
Compare 2 cell content and match them if 2 or 3 words are identicaly
Opening new worksheets based on entries
can I use a cell content as a Criteria1 reference in the below Selection.AutoFilter statement?
Links to multiple Checkboxes
VBA problem with CommandBars
Find cells containing "Total"
Reuel Other Help
create range of cells with random numbers
specialcells and error question
Help understanding Variables in an IF/VLOOKUP statement
Problem with an offset
Quick question
Runtime Error - Subscript out of range despite On Error statement
Self editing code..?
Finding a cell with 2 conditions
Multiple Userform Macro Headache
Help with multple For/Nexts please
help with 'Find' error handling please
disable selection of pictures
Please help--Interfacing excel with external html sites.
Formatting a part cell
Sort Columns
Lookup Multiple text in String
Set string variable to word displayed in a combobox
First result doesn't show up - drives me crazy
Overwrite option when saving a workbook
How To: Pivot Tables, Keep data together when printing.
Counting characters consisting of numbers in VB
Lookup arrayvalue in list
How do I create a company wide Excel function library?
edit links
German language issues with macros - Office 2003 version
using macros to save files in different locations
Userform Search
Macro - Prevent screen refresh
Changing the colour of a bar on a chart
FORMULA ERROR
How can I copy sheet, fill in cell from list and rename worksheet?
searching for and deleting duplicates
Multiply Every 2 Cells
Drop-down-list with Named ranges
Run Macro after cell content changes...
VB help req................!
accept input and move active cell?
Data Validation List
Copy A1:A13 from different workbook
Need to reconcile numbers accounting Harlan Grove code doesn't work for negative numbers
slow for loops ... better way using arrays or something?
How to showing a Col,Row in a variable
Selection Error
Timing Excel computations
find a replace
find function
How to turn off the row # and col letters to create an excel form
ADO-SQL-Excel
remove comand button
Automatically Removing Rows where Cells A:R are Blank
how to use 2 conditions in if
Balloon messages
difference of worksheet name and (name) property in VBA properties
creating list of column headers
I can't believe how complicated this is...
Data Validation & Worksheet_change
getting value of variable name
TRIGGER MACRO ON FILE OPEN
how to use 2 conditions in if
Opening of specific files
How do I select a sheet
VLOOKUP and formulas help
Foolproof way to add ADO reference
A save/load txt UserForm
Make Excel use Firefox
Code to add comment box
Duplicate worksheet question
Problems with Importing a File
Sum related data and move to another sheet