Microsoft Excel Programming [Archive] - Page 68

Help Please
Run-time Error 1004 - retry x times or end
testing efficieny/speed of a macro
Office 2007 Filter Copy Issue
Printing a certain amount of pages based on amount of data
Concatenate cells in one column of value in another column is same
Need some help with codes
Combining logic IF with string searches
Using ADO with INSERT query
Using ADO with INSERT query
Using ADO with INSERT query
Error handling
Macro save as from Template
Read and write an Excel file
access file based on last saved date/time
How to make tab name match cell on another sheet?
find question
runtime error 9, subscript out of bounds error #2
Can you use formulas to manipulate the fill color of a cell?
RE: Can you use formulas to manipulate the fill color of a cell?
waiting for another application to complete an OLE action.
Help Needed With Message Box
Date filldown
Two Worksheet Change macros in same worksheet? Is it possible?
Programmatically show and hide portions of worksheet?
Problem Sorting Excel Range in VBS
Macro Security to "Low"
cut rows to another sheet if a specific cell NOT BLANK
Code to add Range Value produces nothing
Writing a macro in Excel that Refreshes External Imported Text File
Code Procedure for multiple sheets
Find existing number in another workbook
Excel Creating Shortcuts when automated. HELP!!!!!!!
List box to a Cell
Issue with filenames using FileSystemObject
AutoFilter Header Row
How To Link To An External Dynamic Named Range
Using a variable for the 2nd paremeter in a vlookup
Can I end a sub on error?
Left as a condition in SUMPRODUCT
Finding multiple values
Number of Worksheets in a Workbook
Excel Printout runs off page
Help with SUMIF in VBA
Macro Control
get application, object error
Pivot Table with no "Blanks"
List Box Setup
Last cell with data in...
Using If Then Else within a Macro
Listbox Scroll Problem
Prefill a text box on a form
Match Formatting
Remove "-" from 01928455-01 - want 0192845501
Excel Charts on Windows Forms
Delete rows with duplicate information
Test to see if Sheet exists
Get data from Outlook Public Folders in Excel
Highest Value In A Range
Help With my program
Need code to close minimized workbooks in BeforeClose event
dropdown value
How to get the PageBreaks not to appear in the middle of the table
How can I get a macro to know when it false and run a different ma
Is there a formula that can display the Tab Name? If not can a Ma
Defining an R1C1 style dynamic named range using vba
Links and Add-Ins Error
Entire Column - Dave Peterson
Worksheet_Calculate
Add-Ins menu in Excel 2007 diseppeares?
Performing Data Transformations
Rename a worksheet that includes a cell refeerence
monitor a specified range ( OnChange)
Debug to Output
The "temporary" parameter of CommandBarPopup.Controls.Add
Loop through cells in columns..
Deleting #N/A
Save on sheet shift
Calculate cell once (on workbook open)
HOW DO I FORMAT A CELL IN EXCEL TO PICK CURRENT SYSTEM DATE
Last column...
Macro Running Twice
Copy data from one workbook to another existing workbook
Find & replace string in text
Function to display username/networkname
Returning Image Details
Trying to Locate position of a DASH "-" in Cell or String
How to run macro for 10 seconds and stop?
How to encrypt excel pki
Hyperlinks from one excel sheet to another in VBA
odbc connections in excel 2003
excel 2003
ScreenUpdate Usage
Unprotecting worksheets only if you have the password
run time error #9, subscript out of range
Copying data from cell to other on click or color change
VBA Functions
How do I set up two cells with a reciprocal formula?
Test Date of External Data Source
How do I create a macro to add a zero to end of a cell? or cells..
RE: How do I set up two cells with a reciprocal formula?
Calendar control
Dropdown Box Update
Print to PDF
Block Manual Entry
waiting message
Color Sort
Calendar control
Can you use FileCopy to convert a file as well?
Determine what row is currently selected
StrComp
Question about a Variable being Nothing
How to copy a drawing image between sheets
Picture Problems
if statement
Use value in cell as numeric reference to a row, within a sum func
Activating EXCEL window from PowerPoint
RE: Picture Problems
RE: if statement
Run-time error '1004'
RE: Use value in cell as numeric reference to a row, within a sum func
cell comparison
RE: if statement
Problems using Worksheet_Change
RE: Question about a Variable being Nothing
RE: Can you use FileCopy to convert a file as well?
Virtual AutoFill Macro
cell comparison
Make a particular tab visible on a forms tab control
RE: run time error #9, subscript out of range
RE: Color Sort
RE: Print to PDF
Excel 2007
Can Excel XML validation be done on Web?
RE: Determine what row is currently selected
RE: Determine what row is currently selected
RE: How do I create a macro to add a zero to end of a cell? or cells..
Get column count used range from S to IV
RE: Problems using Worksheet_Change
Macro Not Completely Working
Using formula in code
RE: ScreenUpdate Usage
Userform to size to display
How to org my questions
RE: waiting message
Test For Add-Ins
activate VBA
Want VB form to show in Excel Worksheet
Microsoft Visual Basic- compile error: can't find project or libra
print/save macros
Get outlook contacts from a Public folder instead of DefaultFolder
RE: Use value in cell as numeric reference to a row, within a sum func
RE: Use value in cell as numeric reference to a row, within a sum
Adding a hyperlink to a macro generated e-mail
Automating Refreshing Part (III)
Need autofilter and data extracting help
RE: activate VBA
RE: waiting message
Simple Custom Function???
RE: Test For Add-Ins
RE: Unprotecting worksheets only if you have the password
Define variable from cell to open a file
Copy/PasteSpecial Not Pasting all Formatting
RE: How do I create a macro to add a zero to end of a cell? or cel
RE: Test Date of External Data Source
RE: Macro Not Completely Working
rename message
RE: How do I create a macro to add a zero to end of a cell? or cells..
Filter duplicate data in excel spreadsheet
RE: Question about a Variable being Nothing
RE: cell comparison
RE: activate VBA
RE: How do I create a macro to add a zero to end of a cell? or cel
protect sheet problem
RE: activate VBA
Same Office 2003 but different VBA Tools>Reference (object ref.)
Excel 2003 hangs
Changing Value
Multiple Workbooks
RE: Picture Problems
radio buttons
Need help creating VBA procedure for Open event
RE: waiting message
FIND Beginning of field and add C to end of the field
Define variable from cell to open a file
RE: Test Date of External Data Source
screenupdating problem
RE: Using formula in code
RE: Simple Custom Function???
RE: Define variable from cell to open a file
RE: Same Office 2003 but different VBA Tools>Reference (object ref
RE: Test Date of External Data Source
RE: Picture Problems
Copy Selection doesn't work
Text output
Programmatically show/hide portions of worksheet?
a micro that knows a row variable that is the date
listbox concatenate
Hiding a From Button
Non-programmer needs help with search function
Immediately Entering Break Mode
Obtain Path on open workbook
Copying a value till the last populated column
Combobox which are dependent
Check Box
path problem
sharing between spreadsheets
=IF ..OR.. =IF
Simple Text Editing Macro Help
Deleting rows from mutliple sheets
Macro help needed
define variable range
advancedfilter action
Inputbox default Question
path problem
looping to through rows
Subtotals problem - wierd!
group/ungroup
Distributing A Custom Menu
Is there a way to give range names (especially with relative reference) for series names and series values in Excel 2007 graphs?
Inserting blanks
Copying
Identify Shapes
Merge (not consolidate) workbooks?
EntireRow
coding vba
Ensure items in a list aren't entered twice
Code correction pls help
Partial find and full replace
Opening new excel file & inputting data into cells
Changing File Name
Changing File Name
Flash Screen/Timeout msg box
Problem with Macro in MAC
Shortcut for Format Painter
Combo Box Click Event
Create loop to insert two rows after every row of data
Code that executes against any Excel file
Free Excel and PowerPoint Backgrounds
VBA Combo Box
ActiveCell present in Range
embedded WindowMediaPlayer keeps resizing
using checkbox to calculate another cell
Custom Menu and Menu Items
Button On Wowsheet
Copy Data from one workbook to another
password for end user
Gray Treeview item in VBA
PivotCache.Refresh
Excel.Workbooks.Open behaviors differently in VBA and VB
Dates and Combobox problems
Concatenate non-concurrent cells
Creating and accessing PDF
Recorded single column insert in macro. Macro inserts two not one
Qualifying macro run according to current selection
Retrieving value from range name
Outline level
I need the code for Audio Warning!
Hide a worksheet
Can't copy and paste the comments
Dynamic Range based on cell contents
Sort works in 2003 but not in 2000
Insert row and copy cells from the currently selected row
VBA doesn't like my file path
LegendEntries
copy cells to end of range in other column
sum for each month
move cell values over 2 cells
Autmating CSV Import???
Workbook_Open does not work
macro button to unprotect entire workbook (used after password ent
Chancing Excel worksheet
EXCEL: Feeding data into model and recording multiple output value
Comparing columns and intersection
Using Solver with Named Ranges
Looping through selected charts
Automating Refreshing (Part II)
Copy/Paste Worksheet to End of Workbook
some code sets a variable to a sumif formula, offset 2
Resizing Checkbox
Routine procedures/formatting same as previous cell
Macro pt.RefreshTable
Determine last row while autofilter is activated
Print condition and autofilter
what exactly does Exit sub do?
To set command for total amount
Copy command
Trying to import multiple text files using "fixed width"
Help with paste special
Macros and Security
"Object Required" not displaying
Old Toolbar won't go away
Problem with VBA Macro Consolidating data
Finding a Sheet
Button to activate a macro
Macro Continuation
Hiding/unhiding columns based on user selection
Excel to Outlook email
Delete rows where colums match
ISNumber
Macro Problem
timer ticker
Linking to cells on a spreadsheet with controlled access
Sequntial Number in Excel
Can't find Custom Toolbar attached to workbook
Sorting row data?!
last cell without a blank
Opening notepad file then sending to back
Double click cell to execute macro
formating RichEdit
Closing Userform
user interface only question
i dont want vlookup to solve this
mousedown in a graph
Deleting first empty row along with the next 700 rows
Search across rows
Help with ActiveWorkbook.SaveAs
I am looking for an Action Log format
Check File Open Macro
Adding rows and copy/paste through a user form
Select Case in ComboBox
Using VB to auto generate email - unable to get stationery
Copying data
Form focus
Focus in a form
Extracting text from a string
Office 2003 @ using 100% memory
Row height & Column width locked?
Excel equivalent to Eval function
Look at numbers between 2 numbers and copy the complete rows to a worksheet.
Access remote database with IP address
VBA format for a variable cell selection
Autofilter or SpecialCells-related bug?
Establishing which rows are currently visible due to filtering
programming
Macro Recording 2007
runnung word
Disable "Move or Copy sheet "action
Identify Blanks; All Listed in Column AX
How can i secure excel files if copied from office server?
Upgraded to Excel 2007 "Compile error"
Append Excel Data from a named Range to an Exceldatabase
Need to Loop some code based on a count of Cells
Way to change or update the macro
disabling custom menu upon closing workbook
Macro for Deleting Specific Rows?
combo box in several cells
Custom Toolbars does not retain Button
go to the right worksheet
MultiPage UserForm - Need to Prevent Duplicate TextBox Entries
VBA Code vs Public Function
Stop Macro
to copy the value of several cells to another part of the spreadsheet
Search Listbox Values
Combo Box Display Multiple Column Info After Selection Made
Drop-down box & code
Sending Excel ranges to Word as Metafile pictures
AutoTextMacros.xlt: Solution?
How to retrieve Excel column as a string (AAA instead of 703)
vba browse button set to current directory
Copy tables from MS Word
Changing Cell Color by clicking on a cell
Runtime Error
Excel VBA macro
Cell colours according to date
Renumber "Microsoft Excel Objects" SheetN (XXX) ...
Change Event
Disable Copy/Paste
Excel 2003 loosing Database Queries
Clearcontents takes long, long, time
Macro to name a worksheet with a date variable?
Override normal VBA when clicking on a add-in (BEx) toolbar button
BCC global distribution list
Is it possible to make an excel macro to work with all sheets?
Protocol in Immediate window?
Open Access 2003 or 2007 from Excel
Using LINEST with a sparse data row?
Refreshing automatically
Background in email
Making a text box active when returning to a screen
The Current .Net Security Policy does not Permit...
how ot keep value and drop formula while copying
control toolbar combo box and command button
Editor Issue
Creating function
Error Not Displaying, Instead macro just ends
auto insert worksheet name in dynamic named range
creating a function
Determine if template file is dirty
how do i send a named range as the body of an email
Save As name
Populating data in ComboBoxes on UserForms
Data Validation and Error Reports
Addin conflicting with Workbook Module
Find last row and delete from +1 to end
open data form when worksheet opens
Disable "Move or Copy sheet "action
Modifying a Macro - Help Please
Clipboard is empty or not valid
Merge cells if value is zero
stop auto macros running when opening a file by code
Updating VB for info entered in a sheet
Dir for folder name?
Type of variable
creating form/filter in Excel
geo rectify coordinates in vba
vba command
Macro to create a schedule
Please help me with running this macro in Excel 2007
Using VLookup in VBA code with variable range
Date ranges
tabbing
Multiple IF NOT OR
extract data from web
thanks
Enter Button
Print String from VBA
Sort/Search Arrays
Advanced Filter not working correctly in macro
Accessing another workbook's data
Sum the value of cells, when cells contain errors
Sorting problem
Macros
locked cells and code
Code needs tweaking :P
2003-->2007
Stopping a Macro
Place Cursor in A1 on all Sheets Q
Enhancements to sub which writes cell value to comments
2003->2007"unable to set the Left header property of the PageSetup
ActiveWorkbook.SaveAs in excel 2007
Getting data from different worksheets in another workbook
Referencing workbooks in macros
Insert picture from filename & path in sheet's cell
update
Method proceeds but not taking action-Gurus help here
VBA compile error with Split Text Function
Extract Data from Text Files
image1.bordercolor not showing
Background Calculation acts as though it's disabled
pass value to excel userform - is there a constructor? how to pass
VBA code to copy and paste by values from one Excel workbook to another
Worksheet Activate
highlight a row when total is in column A
run all worksheet macros
Updating links in a spreadsheet
Listbox Selection
sounds easy but I can't figure it out.....
I receive "isref" when i do an autofill in a column in Excel
Let the user select a range from a window
slower by 10 times by adding an easy function????
Multiple Language in Excel
Another Userform Date Problem
How to break the rowheight limit
Dynamic linking or referencing of cells
Run-time error '1004' - The file could not be accessed.
What can cause Excel to save slow?
VB Script to Remove Letters from a number
Can you ask a chart which worksheet it's data is located?
Trouble Adding Worksheet via VBScript
password recovery tool
Parse Data - Code form Don G.
Open XLS as though an XLT - unsaved copy in memory
Link loses formatting
Referencing Cell Location
Define Range Question
Test if Worksheet is not in an Array
Add result feilds to a pivot table
value doesn't get passed to a sub-routine, loop doesn't iterate
Vlookup Question
Date format problem on form
Loop until X or Y?
Copying non-contiguous cells
is it possible to have excel insert zeros into data??
Inserting a row in excel 2000 although the worksheet is protected
Find Blank Cells and List Each Cell Address in Another Sheet
sorting a worksheet with vb code
Row and Column Reference 2007
Selection.Copy throws an Object Required error
Delete all cells in range matching certain values
Validation Object error
If the sheet exists...., then
Excel running Access query
save Changes and close book
2 problems with my vbs script
Overwrite saved workbook in VB Script
Real Time Graph
How to use VBA to copy selected data from one worksheet to another
Import Data from txt file
Loop +2, +4, etc. help
Receiving error 1004 - Method 'Rang' of object '_Global' failed
Next Loop
Time Sub
Automatically Selecting "Yes" in an Externally Called Message Box
Set Row Height depending on cell content...
I want to put the text in the cell of column B in front of the the text in column D.
reformat to get more hierarchical view
Kill a file
Goto in a sheet
2003-->2007"programatic accses to visual basic project is not trus
Copy data and page break settings from 1 sheet to another
Fill the cell in column D if column D is empty
Pivot table Page field content display?
Shell Script
Use AddIn to Open an addtional Excel Workbook
2003-->2007 recognize if i'm in 2007 or 2003 via code.
How to auto update currency exchange rates in EXCEL from website
Insert line every x lines until end of data
Automation error with XLA addin, fails on commandbarbutton onaction
Help
Data Validation blanks
need to divide value across added rows
inserting page-breaks
Programming the VBE Find/Replace dialog?
Worksheet Arrays
Duplicate value are not being removed
label position affected by wide screen?
for next loop problem
Insert image from Cell value
MockReader.com
MenuItem Check Mark
Worksheet printing
How to Differentiate between a Student's Score of "0" and a Score of Null?
run macro on other computer but not this one (workbook open event)
Connecting to SQL -Looking for best methods
Debug.Print convert vba
Debuging Macros
Probelm with Application.Run Method
time question
Going from total to details
Supress Confirmation Prompt
Auto_open to check for folder
copy columns paste in rows
use of variable in array formula
reverse or flip rows
Sub to write formula results into comments
run macro in workbook open event once only
saving web pages
Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal)
Reverse Values in an Array
Save Control To Userform Toolbox
How to find the most common pair and triplet numbers?
deter worksheet deletion
Loop Until Last Worksheet in Workbook
How to tell if xls is open?
if any range on sheet2 change put "a" in sheet1 cell a111
Data validation
Stopping the confirm popup on file save with same name
Help including exception handling - try block
Importing JPEG data into spreadsheet
Problems Adding Columns--but data close to IV and no hidden objects
pass a variable to a public sub
WordArt
idea which I don't know how to work out
Dynamic Charts
why my excel data lost on cd ?
why my excel data lost on cd ?
Working with column and page widths
array formula in macro
Duplicate rows, based on date difference
Duplicate rows based on date difference
auto run macro on open of workbook if cell a1=A
Invalid page fault in module RPCRT4.DLL
Output 0 to 100
how do I compile data entered using a drop down list
Excel 2000 custom toolbar button macro assignment
Help on adding the second trendline in a "lines on 2 axes" Chart by using VBA
Function to return column where a date is entered
Updating Pivot Tables via VBA
help with calling a sub procedure, doesn't compile
Can I convert years to months in the amortization template?
problem with protecting sheet
problem with protecting sheet
Copying range from selected workbook to open workbook
Can Excel recognize code I didn't write?
Move data from sheet to sheet based on ColA
Text Box - Moving Formatted Text
Import Data from Access/Query Criteria Not Enforced in Output
Help with Saving to a Folder
Userform TextBox
shortcut key to macro variables
Text via ODBC truncated at 255 characters
Recording a macro to copy into a series of variable ranges
how do i create a nomogram in excel?
Read a Range into an Array
VALIDATION USING ALPHA-NUMERICS ONLY
VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
how to programmatically clear Document Recovery entries
FunCustomize - general how-to question?
Help me fix this function
Syntax for getting value of named workbook range
Dynamic Data from Excel to Word
Replacing "IF" or "LOOKUP" formula's with VBA Function?
Help! Can't find bug in program
ComboBox Toolbar
Copy button caption
filtering out duplicate data values
VBA and "If"?!
highlight row / spin button
Lotus Notes email from Excel - formatting body text.
retrieving named ranges from another sheet
generating random cash flow with same IRR
RTD only alive when Excel is active app?
VBA small code error?
hide row + buttons and password protect
Error trapping is not working for errors related to files
comparing a date range within another date range
spin up / spin down
Macro - cell content left then....
Can this be done with coding?
Help, Query Refresh windowm appearing....
Validation of the First Character entered in a cell.
decimal places????
Incorrect data when using xlset with autofilter
list box / scroll bar
Replacing "IF" or "Lookup" formulas with VBA function
UDF with IRR
How can I parse time and address from cell with non standard extra text?
VB Programming for Excel (and Office in general)
Macro Looks for Cell Contents & Performs Action
Custom Filter loses blank rows
excel search function
Saving Files into a Folder
controlling the Range.Replace method.
Special SUMIF Formula
Search and replace using a named array on another worksheet
If certain text is in a cell . . .
Cut & Paste data in new Worksheet
Change font size?
Disable AutoComplete with VB Code for a Single Workbook
Range addressing question
The operation cannot be performed because the object has been dele
Macro security via Windows login name (or other)
Specified dates within a date range
Toggle Button Caption
An executable file to run a VB script?
newbie c++/excel issue
VB to find text and delete that row and three beneath it
reset checkboxes
How to improve my code?
Forms and worksheet focus
Improving this code
Auto select when using Combo box in worksheet
Trying to find an "A" in the last position of a variable length Part Number in Cell
SPC XL2000
msoControlComboBox Value
Does this code Delete pictures or simply makes them Invisible
add in, ribbon, tab menu problem
Relatively easy data comparison Q?
Checkbox Name Change?
Help in calculating # of columns dynamically
Excel 2007 Error
Excel._Worksheet.SaveAs
Filter and Move Row Macro
Find end of column and paste formula in adjacent colmn
How do I set up a formula for greater than but less than in Excel
Capturing cell address and contents
A formula that evaluates the value of a cell relatively addressed.
help with inner loop to search for matching strings
Open text file as text not numbers
Recalc Alarm
User Data form and populating a worksheet
Copy sheet--Some cells more than 255 characters
Double Vlookup Problem
Permission to print from batch job printing Excel spreadsheet
need help on inner loop
commision on multiple invoices with sliding scale.
xlDialogOpen
Applying Bottom and right border
End of data
Incomplete query return, who can help?
look up multiple fields
VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
Highlight the row and the column that the mouse pointer is in.
Capture name of last worksheet opened
Saving Files into a Folder
Export from Access using vba
macro button
Testing for a value's inclusion in an array
Please help! Data Validation is Suddenly Acting Strangely
If Toolbar Exists
remove little green error triangle - how loop through to ignore er
finding minimum value
construction billing
Conditional Formatting
Detecting a single quote from a cells value
Macro to find end of column data
Macro to find end of column data
Multiple Target Addresses...
Copy / Paste Errors
Protect Drawing Objects bug in 2003?
Sub or Function not defined
printer exception, error handler, need to loop through network num
SaveAs matter: How can I save the worksheet on an external .xml keeping the .xls opened?
How to make code waiting until Outlook finishes its job
Data Validation, Dynamic Named Ranges, and Dependant Lists
LINEST & How Nonlinear is it?
Macro Import Excel Sheet into Excel Sheet
Access to Excel
Simple popup box question - font size change
error handler, goto errgetfile
Autofiltering macro does not work correctly
Conditional Formatting / Positive vs. Negative
Searching VBA Code
Macro Selects Directory to Save File Based on Sheet Criteria
How to output a sheet as PDF file
pop up box
Using IF statement
Conditional Testing Glitch
Copy and past as values
Converting CSV text
Set Document Focus to Top of Datasheet
how to reduce execution time of my code?
Text boxes and Spin buttons
Macro question.
Updating pivot items on 3 pivot tables contained on one sheet
Value or Value2
How to copy part of a sheet as a new sheet into another workbook?
Sort by two columns using VB Script
workbookbeforesave
Importing Soccer results from Internet Site
Need help saving an image from webbrowser!
Send an email from Excel VBA
Date Format
Still retuns to begining of range, Please Help
Duplicate a Formula in 1000 Spreadsheets
Determing closing method
Excel memory leak?
Summary of Different Workbooks
Combine data in two columns into one and sort the combined column alphabetically..how??
MS Windows Common Controls-2 6.0 (SP4)
List box in tool bar
Encapsulating Communication Between Objects
Re: VB to identify and delete any text box on a sheet
Programming Solid edge with VBA
VB to identify and delete any text box on a sheet
Answering an Excel generated msg box Yes
Returning to first offset point.
HELP!!! Macro doens't run on clients maschine
copy and paste problem
Macros detached from buttons on charts
Case Statement with multiple checks
How can I find the rowheight and use it in a formula?
just looking for some suggestions
Issue with command button visibility
Command button
Add a Pictures File Name and Path to a cell ?
Hiding entire rows
Merging Access e-mail field into Excel worksheet
Run a macro when I open any file