Excel Programming [Archive] - Page 21

Re: Visual Basic Editor Window Opens Automatically
Conditional copy from multiple sheets to one sheet
Right aligning labels
Visual Basic Editor Window Opens Automatically
Unhiding rows
Out of Stack space error
Userform Textbox to Worksheet Textbox
vba code to replace first row in CSV file
Form Control Text box
import shape from other sheet based on destination sheet data
Worksheet_BeforeDoubleClick()
Do not save macro with workbook
How to change linked source Worksheet
looping on excel files in directory
Un-Delimiting
change color
how to merge two ranges
Code no longer runs
Colour format code
Testing for a string of zero bytes
Format text using VBA
VB Format command fails
SET THEORY & VBA ?
Ontime problem; variable not passed from Workbook_Open to StartTim
Documentation on programming Excel from Vis. Studio StandardEdition.
Call macro from other workbook
Is it possible to validate excel cell against sql table query
RE: Data Source Name
Save as Macro Enabled or not
IQY File: Invalid Web Query
GoTo cell..
Determining programmatically if a project is digitally signed
Code Error
Detect file.
Macro to Print Pages 1 to 5 with "5" being a reference to a =count
Export unlocked cells to file
upgrade to 2007 excel
Help with SAVEAS
Variable in SQL
Timer
Here is a stumper for you (programming).....
Macro / VBA Help
Lock Range of Cells
disable combo change event temporaraly
replace text with a loop
Advanced Filter - Named Ranges
Calculate the number of Columns apart
handling an error in IF ELSEIF statement
handling an error in IF ELSEIF statement
handling error in IF ELSEIF statement
Editing items in a ListBox
handle error in IF ELSEIF statement
handle error in IF ELSEIF statement
Determine cell Indent level?
File Inflating in size Q
Overwriting a table with another query
Command Bars
RE: Copying a range of data across multiple worksheets
RANGE QUERY
Memo format field data problem - Data import from Access database
Export/import sheet ends up in Class Module
handling error in IF ELSEIF statement
Copying a range of data across multiple worksheets
Managed Code UDF without Excel Services?
Web query. Rejected by server after 7 updates... Way around?
Insert a calender in Excel 2007
Toolbar Not Creation Problem
Cell Background Color
VB Help
PrintArea Macro Help
RE: Why Isn't This Working?
Copying formulas
Why Isn't This Working?
VBA Sumproduct Help
Limit for ListBox columns?
Lotus save as draft (instead of sending email)
Dynamic drive selection to update link
Header and footer Protection
#NAME? error in function
Setting Print Area
Comment Box to include a range of cells
Setting Print Area (Macro Question)
Set Print Area Macro
Get the cell to the right of a merged cell in VBA
Set Print Area
Extract Application Information
RE: Run-Time error '91'
Run-Time error '91'
Set print area
password in VBA
Changing font colour for cell variables
datediff
Shape adjustments - how to calculate adjustment for trapezoid
Conditional formatating
VBA and home server
SendMail as pdf
Application-defined or object-defined error
How to focus on add-in Tab in Office 2007
Loop and and accumulate values
Pop up Read Only and Existing User !
Add
Save file from the value of cell in different opened file
(possibly) simple question about web controls
can you add months to a date?
Excel File Clean Up Excess Space?
Run Time macro based on the value in cell
For loop
Add .net ActiveX to Excel worksheet
Array, Match, ignore, List
Array, Match, Ignore and List
controlbox property?
Question on VBA Insertion of Additional Sheet
How to export unlocked cells to a row in a text file.
RE: Find File Name and Delete
Hidden rows
Re: Find File Name and Delete
Find File Name and Delete
How can I create a hyperlink to use an active IE window?
Worksheet_Change help
Subscript out of range error message
Re: Using wildcards in workbook calls
RE: stop worksheet code
Use range to move data between worksheets
RE: Issues with InStr
Shapes OCX - I would like to find one.
stop worksheet code
AutoFilter Confusion (no records found)
Lock down a workbook
Issues with InStr
Which is the best method to use
Easy Way to Check File Privileges?
No error message but code doesn't work
VLOOKUP to find a value that falls between a range?
find a value across an array of worksheets
Using wildcards in workbook calls
Naming Tabs with a reference using a Macro
Insert data in access by excel.
disable cursor when double click
SendKeys not working for some program
Print out embedded Word object
copy data cell from another file in excel
Subscript out of range error message
Lookup Current Date and Find Next 5 enteries
find minimum non-blank value
intentional circular reference question
make userform textbox value permanent
Offset and ActiveCell
Using named ranges for columns and row numbers... How would I?
New worksheet button code
RE: Printing to Acrobat - Possible to use VBA to program PDF file name
Grouping and protecting worksheet
WriteResPassword...
Calculating the total time of an excel logfile
Sorting multicolumn listbox
Cannot find . which has been assigned to run eah time . is closed
compare contents of two folders
Macro Help Needed...copy into new sheet based on account number
Closing a workbook
color multiple rows
Find next cell with more than 1024 characters
loop
Using macro to switch 'page' in a pivot table?
Opening textfile in textbox + moving to top
Substitute
Run repetitive task and frequency depends
Jump to a sheet based on the reference in a cell.
Field value defines worksheet name
Time Delay Between Execution of Two Functions
Gary's Student
Sorting hidden cells
Sende/receive email from Excel with Outlook
How to check the whole column at the same time?
Do Until Loop
Macro for copying values from the dropdown list in Excel
Pi in VBA?
Do Until Loop
looping programing help
Re: Asterisk after String Delcaration????
RE: Asterisk after String Delcaration????
Asterisk after String Delcaration????
how to send a variable size VBA array to a C struct
ODBC Microsoft Access Login Failed
Runtime Error 381 - Invalid Property Array
hide all comboboxes
Blinking cells
Dialogs(xlDialogSendMail).Show - how to delete attachment?
passing variable
General Comment about VBA
Try to built an UDF to Count until .....
reading excel 2007 returns 255 columns!
Calculating Cells Error
using VBA remove "0" but leave "X" first digit only please.
Protection worksheet
An intangible compile error
Disable Drag-Drop to Destination Cell; Don't Rename Named Range
code signing certificate doesn't have transitive trust
Pivot Table Macro, exclude possible blanks
AccrIntM: "Object doesn't support...."
Copy a sheet from one workbook to another
loop to change source data in Excel Charts
Copying named range returns #N/A
Macro works if saved in 2003 format
If Selection <> 0 then msgbox
Excel VBA - "this action..."
Click to Reset Radio Button
delete trailing space in column
Random Range of Dates
Typing vs VBA
personal.xls and add-in
Help needed for VBA object not found problem
Shape - Remove Blank Rows from Data Source
message box\Forms button
Message box\Forms button
Need some help constructing a Do While statement
Naming Tabs with Pivotable Page Filter data
Conditional formatting and Dropdowns
How to change the row1 content of the existing excel file automically
Finding and Counting Values in a List
export all worksheets as html
macro for combining worksheets
cell date value
Help! Combine Macros
Pivot Table with Percentages
Export to PDF moves the graphs location
Conditinal formatating
Essbase Error handling through VBA
Worksheet Name RefersTo
Dynamic formula for changing row numbers
Open XL - A Powerful Excel Addin
Call to INDIRECT within user defined function
Converting Formulas to Hard Values and Vice Versa?
Line breaks appear as squares in comments
Skip Spellcheck on comments
Re: Find first value in column with formulas
Find first value in column with formulas
Application.Match problem
Send Mail in Excel Spreadsheet with fields in spreadsheet
Export listbox items to worksheet
Sort problem - perplexing and annoying in the extreme
Sql Statement for Excel
Print listbox
Copy formula amongst files but create cross-link problem
Counting exception number and pop up in MSG BOX
Worksheet_change question
QUESTION ON TEXT BOXES !!
Changing a cell colour if target not met.
Compile error, Syntax error
Click to Reset Radio Button
RE: STRING MANIPULATION ! !
Macro to move a worksheet once a job has closed
Assigning a Variable to an Expression that Includes a Variable andVBA Property
Create a new worksheet based on and input box
Is UDF the way to go? Is there a better way?
Selectif function
Saving in Shared mode
STRING MANIPULATION ! !
STRING MANIPULATION !!
Looking For Interpolation code
combobox
Row coloring
Method VBProject of object Workbook Failed
Office Button
row insert problem
TEXTBOX COPY AND FORMAT !!
Formatting to 2 decimal places, placing a page break and autofitting a collumn/row height
creating a directory if one doesn't already exist
paste issue
like a vlookup
coloring range in one worksheet based on data in another one
Setting Default Values in Range When User Enters Blank Value
Detecting user input of "" and replacing with VBA computed default
Open File Marco
wait for combo entry?
excel range
ToggleButton Capton
Create named ranges WITHOUT using the Names Cells or Range
Hide ribbon+command bars in 2003/2007 for specific file
Last Occurance
Excel 2007 Macro w/ AppActivate = Run-time error '5': Invalid procedure call or argument
Filling an Array Quickly
Filling an Array Quickly
Do I have a compatability issue here,,,
RE: Find a file position and continue to list following files
Reducing data size
Find a file position and continue to list following files
Sort and create a Table of one column of dates
RE: Create two sheets, filter data to each
RE: Create two sheets, filter data to each
Create two sheets, filter data to each
Excel Files to be sent out via Lotus Notes
Shape color index does not match cell color index
Auto-pop up msg windows
Stripping Spaces from Right Hand Side
Worksheets emulating database 1:many
RE: between commas
between commas
Class Modules - referring to workbook properties
Excel 2003 vs Excel 2007 VBA
percentage formula for a discount
identify whic row contains todays date
macro to insert comment
Text Box Macro
Get the print range from a sheet you just copied for use inthe new
VBA: Select Cell using find function and offset
change format
ITERATING THROUGH WORKSHEETS ! !
Developing a formula that will return a value based on a date rang
Coding Help
combobox
Reprogram/reassign some function keys in Excel 2007
Leading zeros in Excel
mimicking a control array
Help with email workbook
Coding Help
linking cell to an access database form
Toolbars & command disabled
setting ActiveChart.Axes(xlCategory).MinimumScale not working
database connection vba ADODB & ADOX
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value ) ,"OK","No Match)
create sheet based on value in string
Reset radio buttons w/ protected worksheet
Custom Toolbar - "Begin a group"
Index, Match Help
Outline grouping within macro?
Set Print Area
Disable ALT+F11
Using an VBA & arrays to do calculatiuons
Problem in Picture alignment
Print To pdf Not Working
Loop with Variable name?
Filling a cell with formula only if cell in the column to the left isfilled
Close Code possible?
Insert row and fill down formulae
Button Color based on cell
object browser, and adding and deleting charts
What is the best way to query a range for a substring?
Run macro in protected worsheets
Debug problem
Object variable error
Can I use a UDF in an array formula?
Decoding a csv string into a readable xls
Re: New to VBA, code works but need it to offset diffrently
Need Macro to Dictate Duplex Printing
visible label when yes is selected
Application.Close
compare values
Beginner problem trying to iterate through a selection
Insert text in column A and calculate the average from column B
POPULATE combobox
SEARCHING A WORKBOOK ! !
Auto Filter
3d array formula
VBA Timing, to the Internet and Back 23apr09
Find the last row and column of the dirty area
winzip
Filterable alternating row colour formula skewed when rows deleted.
RE: Search File Windows in same Excel
Auto Close Pop-up MsgBox
Pop up Windows Question
Search File Windows in same Excel
Re: For next
RE: For next
For next
Code to set print range
How to handle objects drag-drop? (Excel 2007 + VS 2008)
Help with coding a command button.
Errors with : Sheets(shArr).Select
combobox positiion
how to create a userform without VBA
get Bios time and date
Removing Diagonal Lines on worksheet
Radio buttons in group box --> linked cell
Create New Workbook and copy sheets from my Speadsheet
Emailing worksheets from Excel and Word
paste named range for each new sheet created
C# dll use in Excel
Repeat code for multiple worksheets
Help needed
Find coding
conditional if statement and macro
Paste to array of sheets
create link to another 'place in this document'
Open workbook with unreadable content
Inserting Text in a calendar
UserForm Visibility question
Error 424, Object required
Bubble sort Error (Compile Error: Type Mismtach)
Macro to run through each value in drop down box and copy paste re
VB Question
RE: Extract Last 4 Strings from text
list all sheet names between sheet x and sheet y
Extract Last 4 Strings from text
Bold a certain word throughout worksheet
How to pick up data which meets certain requirement
Run-Time 9 Subscript ouf of Range Error
Print Selected Range
copy formula
linkable cell like result of a formula
Xll plus vs Rapid Xll
Protecting worksheet cause vba code to fail
"True" text format
.Chart.SeriesCollection.NewSeries.Values
email multiple worksheets
RE: Date in a cell equals most recent date in three other cells
Re. Module Comments
Date in a cell equals most recent date in three other cells
Autofilter turn off with macro
Problem deleting series in a chart
Sort code not working in 07
Public Variable dilemma
Stop Automatic Calcualation
Insert a text in Column A and calculate the average from column B
ppt2swf
nameing a worksheet
macro for editing a field
Re: Public variable (or Public Const?)
Public variable (or Public Const?)
Display ToolTip for User Defined Function
data>form
setting position of a pivotitem
Retrieve values from array and use as cell reference
Tally my bananas! :-)
CurrentRegion in 2007 Sort
Corrupt PDF using MS Microsoft Save as PDF Add-in
Display Text in Drawing Object - (in Rectangle box) <SHAHZAD>
Can you open 2 windows of excel with duel screens?
The most basic question ever - what does "i" mean
US / EN VBA menus
Conditionally copy from multiple sheets to one sheet
Macro for hiding/unhiding a set of rows
activecell giving me a hard time
select copy paste into new book incrementing rows
Click to Clear Radio Button
Compile error: User-defined type not defined
show cell value as cell comment, by mycomment() ro any
Change Sheet references in code?
Disable Textbox Still use ScrollBar
unprotect hidden sheet
Data Validtion
copy & Paste
User form
Invalid range name in German version of Excel
Copy and paste range instead of entire row
VB Question
RE: insert rows
Re: Changing header text from one page to another
RE: insert rows
Changing header text from one page to another
attach userform to button
insert rows
RE: MSGBOX, InputBox or some other method question
MSGBOX, InputBox or some other method question
Module Comments
simple question
RE: vba check cell value
Excel Ranges with C#.net
Change target sheet destination from A2 to M2.
vba check cell value
Update date every two weeks when a sheet is opened
Print Another Excel File's Worksheet
Foundcell
Is this possible with a listbox?
Re: inputbox ?
Hide the close X in excel
Paste format without borders
Visual Basic in Excel, Resize the Cell automatically
MAcro help
Deleting rows that contain a certain value in column A
Macro Recorder
CountIf Function
Copy formula down
close match
copy row if date matches
Re: save userform changes
save userform changes
Time Macro Issue
Need macro to play sound in Excel 2007
Using a macro to paste cells one cell below the last cell.
RE: Copy format macro needed
Using created variant value to reference to a variant within my code
Copy format macro needed
hyperlink to changing field depending on input
reference file
How to cycle through displayed PivotItems instead of the VisibleItemscollection
DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003)
Monowidth font
MATCH/ LOOK UP
parameter the axis of a graph
Mattter typed on Legal paper want to get it on A4 size paper
Find data between dates
Marco Password
Running a Macro when a value in a range of cell changes
format type in vbe
GetLocaleInfo Automation Error
Automation Error Exception Occurred
send mail with closing/saving of excel/xlam
Problem with customized RichText Control
RE: CopyFromRecordset Fails
Error 1004 with VBA and validation
Force Scroll Bar Down on TextBox Control
createObject - OLE and Driver error
CopyFromRecordset Fails
Change the second to last from "0" to "-"
"Type" Property for a Reference Object in a VB Project
Re: counting the first letters or first 2 letters in strings
Why Different File Sizes ?
counting the first letters or first 2 letters in strings
Updating For RowCount to accommodate inserted rows
How to make the last rows visible?
Virtual Row Selection
Conditional Formatting for %
Adding range search results to multi-column listbox
Sorting Worksheet Tabs
Creating named range in VBA problem
Re: select uneven range
Extracting XValues Formula string From Series collection ?
select uneven range
How to Kill a Reference - Arrrgh!
Checking for a minimum of 5 rows
Combine 3 Macros
Recieving email notification from Excel
copy a template and fill in data from a single worksheet
VBA Reference Missing
VBA code to change matrix to list for Pivot table Analysis
Indirect - error
Adding new worksheet BEFORE 1st worksheet
RE: Most efficient way to search a range
Most efficient way to search a range
VLookUp Function
Scheduling a Macro
Capture data in another non-Excel window
How to create a regression line from Excel data points
Stuck on SaveAs FileFormat in Excel 2007 VBA
Macro to select certain rows
Import text file to access database via Excel VBA
RE: macro to delete rows
RE: macro to delete rows
macro to delete rows
Auto Increment formula
Possible to import Word forms en masse into Excel spreadsheet?
Macro problem - not working properly
macro problem - not working properly
Copy forumla down
object array in excel
Run-time error '91'
Counting conditionally
Simple Message Box
Looping and pdf-making
hard code a password in a vba code
Trying to get info from a web page app into excel
Works too well - Hide toolbar Macro
data labels on charts
change of data location
macro free workbook saves macro
Time Marcos on Weekday only
FORMATING PHONE NUMBER!!
Anyone know why this won't work
Help Shorten Execution Time of VBA program
Lock range if date < today
Problem with running sub from Excel
PictureSizeMode
ron de bruins code won't concatenate
How to add text box with macro attached
using arrays to complete calcs
Append Text in Textbox
create a button
Single Row to Multiple Row Determination
Code not saving in Class Module
Chart Control
How Can I return the XValues of the Series collection object ?
68 vs 76
what formula would be used for the following
Code a long array formula
how to compare a date range another range
Need VBA for for column addition and on condition resets to 0
sheet read only in shared file
Re: Target Address Property for Insert/Delete Row/Column
Re: Target Address Property for Insert/Delete Row/Column
RE: Target Address Property for Insert/Delete Row/Column
If Then or Case help
Excel and its Visual Basic IDE
Target Address Property for Insert/Delete Row/Column
Chart VBA problem.
How does MS Query assign data types?
from "all sheets except" to "all sheets after"
unprotect when file is shared
Print Ranges
Export pictures from the worksheet
RE: Excel Macros in 2007
Excel Macros in 2007
Naming Ranges by Sheet Name
copy/paste: strange feature (I think)
Copy To New Sheet
VBA
running text import wizard through c#
How to create textbox's at a userform Initialize
Module In Visual Basic
Macro halt - Why?
Excel, Marking a field when text is not like required
Sub/superscript numerals in UNICODE
activex controls excel 2007 - Weird!
Coloring a datafield when nr of characters is more then 40
Step -1 method
adding formula to the boxes of organization chart
Network path in cell
find and delete empty rows
Conversion to XP causing problems
Selected ListBox item to TextBox
SAMPLING FOR AN AUDIT
Loop through Word documents from Excel
Can’t find library
Excel.Workbooks.OpenText and System.AccessViolationException
Counting items in strings
I think the problem is in .SetSourceData ??
Only remove first digit if it is a "0"
RibbonX and .zip File Issue?
Re: SELECTING AN ITEM FROM AUTO FILTER !
I want to bridge commands from excel between 2 different software
Help with Loop
Re: code modification
SELECTING AN ITEM FROM AUTO FILTER !
code modification
RE: LOOPING THROUGH WORKSHEETS!
19 R4i Dsi Cartuchos para nintendo 82898
Excel 2007 Chart Update While Macro Is Running
Contents in Column
LOOPING THROUGH WORKSHEETS!
days and months with heading zero from formula
Code Help
Replacing 1/3 and 2/3
vlookup with variable
Forecasting Error
RE: Unicode Problem
Unicode Problem
disable a macro using a macro
If cell value changes in 2 cells
Getting the Sum Total of a variable Range
If Then Combobox
UNprotect columns in protected workbook
Number of pages printed?
can't delete a series from SeriesCollection ???
Can a WorkSheet be proteced from deletion
INPUTBOX QUERY-DATE
show a whole row in a color if a condition is met in a single cell
Sorting a listbox when items are added
IF calculation using dates - brain hurts
Reading a txt-file with license-code
Grouping Question; Redux
w/book visible to a specific person
open w/book with password
prompting for a password
w/book saving problem
Populating a combobox by the getrows method
function with matrix
Rotate a Picture
Re: Unicode Code
Unicode Code
Can someone explain why?
VB Editor and Moving Line Pointer
Test if a variable is given as array?
Reading location of active cell
How do I move multiple Worksheets between Workbooks using VBA ?
Problem error when creating a chart in VBA
Detect text styles...
VBEditor toolbars
vbscroll - trusting the publisher
Kill a file that is viewed through a listbox
Macro Library
Shapes slow down Macro in Excel 2007
VBA-Beginner Question
Can I nest an 'If' statement in a 'With' statement?
Need help to modify RDB code
Re: Modules not being deleted
Re: Need help with Procedure to return selected column numbers
RE: Need help with Procedure to return selected column numbers
Eliminate "Cancel" Button on Save/Close Event
RE: Need help with Procedure to return selected column numbers
IsBlank or 6 digits required
Need help with Procedure to return selected column numbers
please simplify, if possible
RE: Changing the name of a message box
Re: Changing the name of a message box
Changing the name of a message box
Re: Dependant Data Validation
RE: csv file truncating zero values
csv file truncating zero values
Dependant Data Validation
hyperlink in email generated with .RoutingSlip
Combobox Exact Match control
Error 1004: application or object defined error
Not sure this should be Excel or ACCESS
How to Bind VBA Variable to Range().Value2 Property
Add Together
rearrange values in cell to date
Invalid Outside Procedure
saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value
Can changes to form fields be tracked?
Re: Non blank cells
Please help combine two simple codes!
Non blank cells
Open xldialogprint dialog box
Using treeview control in Excel user form
RE: closing file without saving
Separate value in 1 column to 2 columns based on value in other co
Find Date in different format
Re: closing file without saving
RE: closing file without saving
closing file without saving
populate userform only
macro for searching, copy and paste between sheets
Show/Hide one of many outline/group levels
Save Workbook As macro problem
excel sheet
run macro on a condition
Routine Interfering with Clipboard
RE: Comparing date values
Can't get data centred across pairs of cells...?
Validating Textbox-Value
Is there a way to get the range from a frozen panes using C#?
circular referencing of formulae when setting calculation back toautomatic from manual
conditional delete
Web query - unable to extract data
Find a merged cell
if not empty cells skip
RE: Using variable in formula
User form editing -reg
Using variable in formula
Macro to Put network path in cell
RE: Default multi page
How to hide and lock all cells but A1?
merge cells
Default multi page
Multiple Excel addin versions having LaodBehaviour issue at Addin
Data input and result on userform using function assignment
Need help with listbox
How to clear rows before copying data
delete rows within a specific range macro
Re: unhide all rows without loop
Re: unhide all rows without loop
unhide all rows without loop
How to add itemfrom a worksheet to a Listbox
*expression* - how to find surrounded string
Worksheet group
Solver add-in Excel 2000 An unexpected internal error occurred
Grouping Question
Inputbox Verbiage
UserForm or MsgBox to select from a list?
Check date
Re: moving certain data to another sheet.
Excel in Office and Works
for each sheet in workbook
moving certain data to another sheet.
SAVE AS/ GET SAVE AS/
Without duplicating sheet, print 1 sheet double-sided (repeated, inother words)?
access a column via a select statement
Formula to move certain data to different sheet
Re: macro command button click
Re: macro command button click
macro command button click
Re: Disable a userform after first use?
displaying missing data with a formula
create spreadsheet as stand-alone application
how to sort (by one field), copy (based on one field) to another tab,then clear data on original sheet.
Writing a variables value every second to a table
Change color of all option buttons in several worksheets
Stop Active Cell from Firing Event after Hitting Return
Cancel (Dismiss) Input Box
Error 1004 when using VBA to set Validation from list on another s
3 step consolidation.
RE: sheet numbering system
UserForm ListBox w/ Multiple Checkboxes
code takes to long
Overflow error
Re: ontime code
Help with Suming of Column
Re: Disable a userform after first use?
RE: Looping only through selected sheets
Re: sequel into excel problem
RE: Looping only through selected sheets
RE: ontime code
sequel into excel problem
Re: Excel 2007 Run-Time error
RE: Delay copy & paste of data until web query refreshes?
RE: Delay copy & paste of data until web query refreshes?
RE: buidling randomize function that not repeating the same number
What is SearchFormat parameter in cell.Find / Range.Find do?
RE: Pause a macro by resetting current time
RE: Pause a macro by resetting current time
Pause a macro by resetting current time
copying cells with more then 255 characters to new workbook
Using Redim on 2 dimensional array
Excel export into sharepoint
List Box
V or H Lookup
Help with VBA Script
Protection Error
RE: Long with value zero
RE: Long with value zero - IGNORE
Long with value zero
subscript out of range
XIRR function breaking down (#NUM)
Use Loop to set Picture Property of image on User Form
UpdateLink Problem
Hide QuickAccessToolbarCustomization
Progress Bar
Hide a sheet based on a cell condition
Keep leading zero in number (Column also contains text)
Need your hep: Creating new workbooks and name it based on a list
LoadPicture fails
running macros
HOW DO I EXCLUDE SUNDAYS FROM AN EXCELL SHEET FOR PROJECTING SALE
Need to always go to Sheet1
More VBA Editor weirdness
RE: Using InStr with variables
Using InStr with variables
Listing BuiltInDocumentProperties without opening workbook
relative reference for LastRow
losing modules, and user forms in VBeditor
using lotus notes
Has anybody found a solution for enabling macros from Excel 2003 t
Re: Delete row if cell in column "E" has 1 or more alpha characters
Add the values of TextBoxes
RE: Delete row if cell in column "E" has 1 or more alpha characters
Re: Delete row if cell in column "E" has 1 or more alpha characters
Delete row if cell in column "E" has 1 or more alpha characters
How do I set a default format of the drill down table?
Monthly Report
Eliminate wild characters
Hide a TextBox
The Amazing Growing Check Box
Re: Workbook_BeforeClose Event and Cancel Option
ignoring certain tab names
Workbook_BeforeClose Event and Cancel Option
Activate Sheet but minimize Userform
Serial Port Usage
Improvement to code
Bug in programming - using toggle between read-only and write acce
What is the correct object?
Help with Formula
run macro on all sheets in workbook after specific sheet
RE: Inserting Mulitple Criteria
RE: Inserting Mulitple Criteria
consolidate data from worksheets
Using alphanumeric and numeric criteria in same code
Inserting Mulitple Criteria
Attaching code to ThisWorkbook
Need help with SeriesCollection Object Please !
Copy data from 1 sheet to multiple worksheets
Help with some VBA code to copy and paste on new worksheets
Programming Excel to open a program
Can someone help me get started or point me in the right direction
Extracting sub-strings from a large string
Adding rows in the array
Excel 2007 erases VBA code from Excel 2003
Help with Macro that contains text and not looks at case
Looping help needed
Getting file name from Worksheet or Workbook?
ComboBox doing a double take?
passing cell reference and formatting cell in VBA function
TYPE_E_LIBNOTREGISTERED Exception in MS Excel.
break page based on specific conditions
Result in 3rd function from existing two functions
Macro stops working when save as xlsm - any ideas?
Open a excel workbook that has a different extension
Class module to access range events
named ranges in building excel formulas from a string
Re: converting ways of referencing cells
excel-vb help
converting ways of referencing cells
Help with .Find
6 arrays in 6 worksheets compare
Registry Location for ActiveX for Excel 2007
ActiveX controls still show data when empty
automatically rename workbook with cell input
Too many cell formats error
When Screenupdating = False is a lie
Device I/O error on workbook close
Ribbon Custom Tab Focus
textbox value
autoshapes - identification and property change
Code for summary report
loop through worksheets for each sheet after
displaying multiple inputs
Re: indirect formula that will fill down
Can I use customed Addin in french version office excel?
Userform Not working PLEASE HELP
indirect formula that will fill down
Copy Word range to Excel
run macro each sheet after and then copy range
Sort and move macro
Changing Pivot Table Source Data
conditional format macro
looking for an Excel VBA programmer - 2 - 3 hours of work
Before Worksheet Insert Event
Help with Late Binding in Excel
Using cells to specify range
Date format and Range.Find
Scantron -- Fill in bubbles
Monthly sales summary.
Re: Subject: Type 13 Error when defining a Columns variable
Timer w/ Start, Stop, Pause
Subject: Type 13 Error when defining a Columns variable
Excel 2007 Personal.XLSB file
Convert email hyperlink
Force a file to open in a new instance
Delete rows where 1st 3 characters in a cell DO NOT meet criteria
Overwrite Open Excel files on Macro
Delete rows where 1st 3 characters in string don't match criteria
Re: Expand/collapse toolbar ribbon
Expand/collapse toolbar ribbon
copy cell values only
automatic data entry
Making a Custom Dialog Box Work (some code included)
RE: If cell is not null, add value to adjecent cell
Create a callout box/Context menu for a cell
If cell is not null, add value to adjecent cell
Getting around a Mixed Variable Type
Dynamic Range broken
Working with colors (default and custom)
Re: Macro for detect palindromes and repeats in letters/numbersstring
Excel 2007 - Moving around in VBE
Macro for detect and list palindromes and repeats in letters/numbersstring
Dynamic userform help - Data Validation
Macro for detect palindromes and repeats in letters/numbers string
Unlock project for viewing within a macro
Is there a better way to get Range of cells for entier worksheet ?
Add Text to Shape
auto-run a script?
excel odbc ms query using cell as criteria value
Curser / Edit problem in VBA editor
Moving shapes around - XL2007 bug?
Password log in from input box
Mod 43 Check Digit calculator
Need help with wayward ActiveCell.EntireRow.Delete
Remove VB code when copying sheet to new workbook
Range method error
Password from cell
RE: Autofilter currently filtering, or just "on"?
Autofilter currently filtering, or just "on"?
Insert formulas by means of a Macro
Encoding query - Ansi
Listview and Imagelist
dates are formatted as custom date but still display as numbers
copying sheet1 from different workbooks contained in a folder to myone and only destination workbook.
Case Specific
Calendar in a cell
Monthly Update
how to input data into textboxes and make it appear on excel cells
Know which cell was just left
Spinbutton
waittime versus Sleep
Determine when Word document opens successfully from Excel VBA
Iteratively delete rows from a spreadsheet
Hexadecimal Numbers
Running Excel
Isert - ("Dash Mark")
MACROS IN MULTIPLE SHEETS
Active Cell in Non-Active Worksheet
Need to fix macro to send workbook via email
Centralize worksheet code in Module code
checkbox code needed
Reading range w/ 255+ characters throws error
How to send a variable from a VB Module to an excel spreadsheet ce
Macro to compare datas
Keep the textboxes the same size?1
RE: Macro to compare datas
Help with renaming in Visual Basic
Can't name new workbook
Copy to next row down....revised.
Deleting rows messes up Named Ranges--How can this be fixed?
Target.Address Question
How to limit "Unhide Rows" Macro?
How do I set the Maximum Property for this Chart in code
VBA: Edit Web Query with Range(B24).Value
Alphabetizing tab names
Copy to next row down
MinimumScale method of Axis Object failed
Re: From a series to a matrix
Macro to Unhide Rows
DDE links
From a series to a matrix
VBA code to ascertain difference between Range1 and Range2
Run Other non microsoft applications
Read only access for hidden sheet
Test if Word is running
Error 424 Object required
SetFocus issue
Overflow error in Progress Bar
Ran last Friday, doesn't this morning!
How to make straight line after edit points
Make a button or menu selection
VBA code seeing documents in Vista?
Customise Ribbon Excel 2007
macro
Error code 91
Inserting image file through ADO
Use RibbonX in Off2003
Copy row to sheet as per dropdown
Displaying Data in a List
Login into secure web site and download data into worksheet?