Excel Programming [Archive] - Page 20

Concatenate many cells without zero's
Create a Private Const Array in excel 2000
Log-In Credentials in a Macro
RE: Use of Variable in Sum
Microsoft.Office.Interop.Excel.Application
Maximize Sheet1
autofill to visible cells only
Macro to Define Name on a changing selection of cells
Inserting a Picture from Folder over cell in 2007
For... Next loop problem
How can I PERMANENTLY get rid of the Excel clipboard?
Lookup Function in Macro (VBA)
Selecting different Worksheets from a Loop
Cancelling But Macro Still Carries On
Date Conversion Help
Unsure of my error?
Grouping According to IndentLevel
How to add additional worksheets to a directory of workbooks
CommandBars
How can I make VBA scripts compatible with browsers other than Internet Explorer?
Where can I learn to convert VBA to VB scripts?
User defined Nth_Occurence function fails when new data is loadingvia macro
sing Data Validation
Using Data Validation
Worksheet selection
Variant and Array
Excel query not responding
Improvements to code
ShowDetail on PivotTable does not work in VBA
XL 2007 - Macros won't run when security configured to allow macr
XL 2007 - Macros won't run when security configured to allow macr
Loading pivotfields from an array
Counting the Occurances and find the Latest Date
Automate searching and then copying files to a folder using excel
Stop Refreshing/Blinking Chart screen when running Mouse over even
Automatic Hide/Unhide Programming
Sum values based on criteria in another column
stop refresh of cells during an optimisation/calculation
Look at, Find, then go to
Naming fixed range versus a List
Help accessing msgbox prompt via function
Clear Cell Contents based on Criteria of another cell
Macro to copy and paste cell into text box in PowerPoint
Delete file within a zip file
Error message when I open any other excel file
Print UserForm?
Filling a macro button with colour ( color)
vlookup workbooks in a folder from master book and save them
Emailing range in message body using VBA - problem
call new workbook
Excel 2007 - Links between worksheets
Do While Loop
Which Oracle home does VBA use?
display calculation next row
Excel 07 issue opening MHT format
Re: FIX: Annoying inconsistent errors in Excel via Access automation
Lookup for multie tabs
how can i change colour of a cell
VBA Excel - Run-time Error 50289 – Can't perform operation
automation excel to access
How to read the current grouping of a pivotfield in a pivottable
Copy Values to another Sheet Q
Unable to exit Design Mode
Need VBA Script to Open URLs from a list in Excel
Unhide rows macro
delete rows that dont match values in named range
Must VBA be manually converted to VB.NET (C++;C#) to create a DLL or Com Addin?
develop UDF in Xll, Automation Add-in or VSTO
Create a pivot table in excel 2003
.SubTotal: Controlling where the caption goes?
If Cell = X then name sheet Tab GHI for eg
Loading Data into an Array
refresh pivot table with New source data without changing tables
MS Access Query Question
Possible to Transfer/Open "Read" a text file into VBA Module?
Missing Headers
outlook task
Creating pivot table dynamically
Find internet explorer is installed using vba excel
Macro Button Dissapears
Removie .select
First Error works but Subsequent Error Handling Does Not
empty cell / copy and paste
Macro for moving arrow shapes
VBA Test on Array - Find a value
Problem with Parameters In External ODBC Data Queries and Userform
Re: Path name problem with pivot data source
loop and some more
Hide Next row based on Cell Value
Last row function....with a twist
How to change old data source reference from copied pivot table
How do I come back to my First Sub?
Making an IE Window the focus for Excel VBA
Wolfram Alpha
Playing wavfiles from excel
Emailing select data from Excel automatically
Not enough resources to display completely
Test for Shape is part of a group?
After checked condition, add the data to adjacent cell automatically
SaveAs Confict Resolution Help ?
Macro Error Handling
LISTROWS problem in userform
Using a matrix and class design
Emailing using code
Checkboxes disappear after macro is run
Process steps to compile current VBA macros into a DLL or COM Addin
Excel 2003 - Recovery of Lost Tool Bars
Userform Option button lost
Hiding Rows with Blank cells
Adding Options When User Cancels/Cannot Find
Is it possible?
Maintaining Macros on a sheet when it is saved as a new workbook
Maintaining Macros on a sheet when it is saved as a new workbook
Converting data into multiple rows
Running Word (and Excel) code from within Excel, to process both file types
formula or macro to change a formula in muliple spreadsheets
Copying from another worksheet
VBA code to email active work book
Customised printing
XL 2007 - Custom Toolbars
search all open workbooks for sheet name
Adding user defined range in macro
array
Copy Dependent On Cell Value
Issues with UserForm Box
Copy range from one open workbook's worksheet to another.
Deleting Rows in Case Statement
creating macro that works in any open workbook?
Cut and Paste Macro
Setting Colors Using Other Than ColorIndex?
Declaring Decimal
Clear Clipboard command in Excel 2007
Place a date in another cell only if adjacent cell = "X"
Event to add a date if "X" is entered in a cell
Userform checkboxes
AddTextBox Position Fix
Syntax issue
Substitute() & Char() in Macro
Workbooks Open Statement
Printing multiple workbooks
Run-time error '1004' general odbc error
Opening a workbook opens two
Column Cell character number checking
Put Value in Close Excel
Retrieve Outlook mails from Excel
Very slow Excel Macro
Strange French hour format
Filling an Array
Declaring Variables Twice?
RE: Interfacing PHP and Excel using OLE Automation: file access pr
msg box to apply filter
Strange macro behavior - result is correct every other time
copying multiple images from excel to word
Out of Memory Error in Excel 2007 but OK in 2003 - Please help.
ADO.NET truncates excel data
Problem referring to a particular sheet in VBA
Refresh ListObject Linked it SharePoint List
how do I change page layout in vba
Download file to computer from FTP
Re: Fastest find method for number interval
Re: TextBox Click Event
Open folder
Opening .xls that runs macro on open
AddressOf
comparing data between 2 worksheets with no unique identifyer
convert string to value and sum
Please help with "Username"
Using a Calculated Value from a Custom Function in the Calling Sub
Using Data Validation List
Truncate a cell value
Re: Duplicate phrases in one cell
Detect if current select is a row
Auto Fill Equations in VBA
Re: Call Macro from PERSONAL.XLS
Verify Column Letter Selected
Re: Fastest find method for number interval
Re: Duplicate phrases in one cell
RE: outline question
Re: a way to print
Move a worksheet position
Change it to a variable
input the date range for update Pivot table
RE: Rename & Colour Sheet Q
Setting and removing page breaks
Re: Trying to use serialdate in database array
How to check the value of a Column
Re: Matching 2 lists
Cell Border
Deleting rows
Column D x 2
Re: Take value from active cell to make formula
RE: Move last names to front
Help list box to update pivot table
print macro
Copy range and paste into MS Paint
Find last row in workbook sheet & move data to it from another sh
Using list or macros to input predetermined values
Pre-Setting the number of characters input in a whole column
Macro button for all files
Macro library in XLSTART: Why does Excel 2007 fall over?
Type mismatch error - 'run-time error 13'
Creating Macro to group data
ms query editor question
Copy Columns from multiple workbooks
Strange problem in Excel combo box
Missing Component (Converter)
Where can I VBA and VB scripts?
User defined data type (losing its data)
Macro to save 2007 file in 97-2003 format
Send an email message from my website using VBA code
Convert Table to a Range
ActiveX control dilemma
Referring to an ActiveX control
Update Record
81 rewrweeds 18
Use mouse to select sheet
Spreadsheet in Userform
Pass on cell address to an UDF?
Spreadsheet translation
Adjust Chart Size
Preventing file overwriting
Working example how to create a DLL using Visual C# 2008
looping colums and rows
Making a directory if one doesn't exist
use formular to create a cell address
Select current region less 2 rows at the top
Extracting specific items from large IE table
How to display a custom menu item
Microsoft error
auto filter list selection
method select of object range failed
Advice on With-End With
Repaint worksheet - or Cell select outline.
macro to date stamp to the right of the macro command button
EXCEL.EXE process does not end after adding an excel chart
How to change what version of Excel starts when double-click aworkbook
Save As.....
Delete 0 - Column D and Column F
Get data from closed file
Column All Upper Case
PasteSpecial column widths with different size ranges
Inconsistent Macro Security
RE: Macro ignores IF statement that refers to cell value
Macro ignores IF statement that refers to cell value
vsto08-ExcelAddIn-Performance Increase while Dragging Excel Window
Re: Pull down menus
RE: Pull down menus
Pull down menus
activate code on single click
Subscript out of range error
One Entry Cell area, to add items to lists
Delete Rows
Hidden rows loop
Between Function
Application.ScreenUpdating broken?
RE: Prompt User to Select Macro to Run?
Re: Prompt User to Select Macro to Run?
Re: Prompt User to Select Macro to Run?
Prompt User to Select Macro to Run?
special character in vba
Can Excel directly access .mdb?
RE: Run-time 1004 error
Run-time 1004 error
Cell contents check and prompt out message (By using Macro)
ScaleType error
Changing case and also changing entered data
Find Character Codes
Way to output list of macros to file
RE: dynamic range question
Large macro "drops out" part way through
dynamic range question
SPEED....2003..V..2007
Userform leaving a trail
RE: Moving a Userform
Moving a Userform
Converting a String into a date format
RE: Edit csv text file with VBA
VB code for autofill
VB code for column fill matching weekends
List box
Edit csv text file with VBA
VBA Advanced Filter - latest lines for multi criteria
USING FIELD DATA FROM USERFORM
Hidden Property 1004 Error, Union of Rows
Macro to Group andor Ungroup rows and/or columns
Save to My Docs
Delete sheet code
identify drive letter
Retain formats in userform
Search location and sub dir's for file, then open it.
pivot table by useing Oracle view
Copy Array Formula
Can't see macro list
How to get actual sheet in my workbook?
Calendar control
How can I check if the ActiveSheet has keyboard focus?
How to obtain Cell Address and/or Select all sheet-cells with xlExcelLinks
Problem with go to
strange behaviour
Comparing Dates
Excel file using unusual amunt of resources
trying to build in a check
for x 2 to 100
Hard Return
Protected Excel File manipulation
Inserting Columns based on missing headers
Drop down Ref another sheet within the Workbook
Macro question
If statement help
Advanced Excel Conference - Atlantic City - June 17 to 18
Is it possible to multiply a chart series formula?
2003 and 2007
Character symbol meaning
Activechart.parent.left
VBA Copying/Pasting problem when data is filtered
Save as marco
Inserting and Deleting Rows and Columns
Summing column cells based on values in other columns
Recorded macro selection widened
Going to a "set" range
VBA Formula Help
Protecting worksheet
How can you flag a cell with fill colour
Modification of Recorded Macro
Marking owners sites & names
Cannot find part for the specified URI ....
DateValue gets wrong date number
Multiple users saving a form
PivotTable Events?
Case sensitive VBA Match
Variable Control name
Paste chart images macro fails
combobox list of sheet2
DoubleClick mystery
FORMATING ITEMS IN A COMBOBOX !!
Desplay active and Hide sheets
How do I access different versions of Excel from one .NET executable?
Unable to Authorize Launch Permissions for missing "Microsoft ExcelApplication" in DCOM Config
loop selecting data
VBA code
File Size - VBA vs Excel Formulas
UserForm QueryClose
Copy formula
Find a row and move it to the end
Data Validation Lost After Clearing All Shapes
Printing to File (PDF)
e-mail a range of cells as the body
Prevent Extreme Zoom Out. Mouse Wheel Event?
why does the execution jump to another procedure?
Execute Codes after Sheet Deactivated
Cannot delete workheet
Adding An If Clause after Prompt
Delete Columns
How to unhide hidden Excel Instance
waiting for user response
ConditionalFormatting help
Excel
Schedule a macro on a specific time
Using com add-in vs digital certs for app
Compile error "Else without if"
vba, how to go to Col B in whatever row is active
treeview drag/drop problem
How do I make a button appear when the custom Add-in is selected?
Create folder macro or vb code?
Macro or formula to date stamp cell based on new data input
Help with Replace()
Report Header
Subscript out of range?
how do i check system time zone from excel?
Excel bug?
using Networkdays formula in French version of Excel options
Getting a constant/variable from another workbook?
VBA/Coding issue
problem wtih worksheets activate
counting every 3 rd row
Repeat Label on Pivot Table
Display image based on value/status
Display image based on value/status
use of Case-Select, with on error
Properties returning object reference or value?
More elaboration on help pages
Run macro in background
Create folder, text file and vbs script from data in excel
code to shade row then return it to as it was
Date problem
When is a parent object required for a property?
Can VBA function be used to return value
Sort Rows into Columns?
File Listing in a Directory
do if cell not empty
Chaging pictures on excel
Auto Paste Values
if not empty do something
Saving all open workbooks as html
RE: AutoFill the data
Re: AutoFill the data
SendKeys
AutoFill the data
Match Values and Highlite row
exact match in a string
Macro to Paste Picture in email body from Clipboard
Excel locks when opening file not in focus
Tough one - Timeout doesn't work
Vlookup
Accelerator
Scatter graph with step wise data
Here is the syntax for TreeView.KeyDown().
can't sort a list
Application.Calculation = -4105 behaving strangely
Problems with sort
Help with getting filenames & then checking for new
opposite of dropdown in combobox
Am I an email enclosure?
Loop through Variables
Control Box assigned to multiple spreadsheets
Saveas Not Working
Avoid Type Mismatch Error when using CDBL()
changing the excel "color scheme" using vba
Using duplicate data in Dictionary or Collection
Use code in a modul
What is wrong with this lin e of code
Compare part of text cell to another
If product already exists continued
Macro to define range names
sumif/vlookup
Copy contiguous from one sheet and paste to another every other ro
duty numbers and names
Email only one sheet from a workbook
Fill in Text with blanks.
choose range based on criteria
Regex Multiple Match not working
VBA: Delete name range
employee excell dilemma
placement of error traps
How do I make a task calendar from an excel spreadsheet for work?
copy paste merged cells
2 Variables determing a lookup sheet to use
Copy cell data from one worksheet to another-TJ
Delete Rows and Sheets
ask user to determine email program
Pivot table help
macro security trusted sources
Initial Value=""
CF or VBA
Range name applies to list, or simply range; collection-index/member-ofprecedence
Help with count problem
Help with count problem
Toggle between True and False confuses me
there must be a more simple way of doing this?
Determine version of Excel in VBA
VBA: Clear temp internt files every 20
Autofilter and cell check
Coding
loops
Possible Print If macro?
Help with VBA............Again.
Question for Office 2007 Users
First 3 characters
Hide Spreadsheets
caching in excel
dynamic size of label, and depending on size label position of tex
Copy from fixed range does not work
Web Browser Control and Javascript
Save As: change all control characters to an underscore
VB to Notepad
need an average over 24 hours
Workbook_BeforeClose event - Cancel won't work
new row with data from criteria
Re: VB Macro in Excel 2007
Making a cell count the amoun of entries that has been put into it
Excel 2007 vba error
'Cancel' on User Prompt Box
Delete Certain Rows Based on User Input
Combobox release
Already Zoomed Out as Far as Possible
ColumnMatch Include Column H:I
Best practice in qualifying Excel worksheet function invocation
protecting a file
Change UDF to work as array formula
query afterrefresh not working
Hide a Password
Selected item in combobox at DropButtonClick
textbox's exit event
Lock cells after data entry ?
macros in my custom xla Addin - how to make visible in Macro menu?
trying to hide command buttons in userform if cell empty
Dim and Disable Buttons
Timeout of sql server in excel vba
Launch Macro By Double Clicking
count where item =x
Notes email.
Date Formatting Lost when multiple cells are blank
changing the source range of a chart
Simple Command Button
Pasted this morning, but not now
interactive databases
Overflow error occurs when multiplying integer constants in excel
VBA selecting a range
Back color on a multipage
make autofill code conditional to avoid runtime error.
VBA keywords
Add Yes/No stops in VB script
A taxonomy of methods and properties
how to build a dynamic array and search it for a value
The Range property
using a macro to map a shared drive
Help in Getting the File Name from a path
ComboboxStart item
Match statement that displays result
Command button caption from cell value
auto date reminder in excel
send email when changes are made to a worksheet
Formatting a comment using code
using Excel 4's REGISTER command
Expanding selected ranges that are changing next time (with vba).
Help with VBA
Summary sheet
highlighting intersecting Cells if ColumnName=Value in an other Co
Create organizational chart with VB
Disable formula Bar in Option Menu
How many words can we save in Custom Dictionary of MSOffice ?
[Excel2007] How to obtain provider name for ADODB.Connection
Copy rows if
i would like a code for autosort left to rigth
Range with "Large"
Who Can Expand Chip Pearson's procedure ExportToTextFile?
Associated fields coming into a spreadsheet
End(xlDown) function
postion of dropdown list with sheet combobox
Today only
Form height and scroll
Label in a form
Re: Vlookup in VBA
Is there away?
CSV-file as semicolon se
autosort
How can this be???
Test if clipboard empty
LINE INSERTION IN TEXT !!!
Vlookup in VBA
Copy certain cells to a "backup" sheet using VB
combining multiple rows into one row
Using xlDialogFindFile to get filename and path.
Where was I called from?
Matching/Finding/Search Array Element
Select Case "Procedure to large" Error
macro to hide empty rows
maximum of currency array?
Conditional Number Formatting
File opens slow with digital signature
combobox on sheet
Server timeout expired
convertion form number to words
Flashing cells
"Caps Lock/Unlock"
If Product already exist then overwrite that row
Quicksort for multi-columns
Adding data to a cell next to another cell with specific value
Data Retrieving
HELP!! Download data to workbook
0.9176237 See What's In Here ... 0.2019745
Using Variable array in Excel VBA charting
Calendar 2
User Forms and Date Formats
bug: Worksheet_Change clashes with dropdown list validation.
Highlight active cell
How to insert variable into link path?
Create a simple menu button
Add new sheet automatically every data.
foundfiles bad result
Help my please: VBA code for "Find" function
mysteriously enters into break mode
Read Only Files - Part 2
compare pairs of columns
Weeks between two Dates
Pending Records
Variable Range & Sorting Macro
Macro to automatically hide rows based on 3 cells
Download data from secure website into new Worksheet
Use a Variable to Reference a Check Box Object
fill down range starting at last cell
OR options in IF statement
activate userform when a worksheet tab is selected
Read Only files
How to code ReDim Preserve when "ReDim strArr(1 To 100, 1 To 3)"
Re: padding cell with up to 3 zeros
Code stops while Userform Shown
padding cell with up to 3 zeros
How seperate text with comma in a cell into seperate rows
VBA code to get the Html code from the IE
Programmatic row insertion error; KB211769 no help
Can Checkboxes trigger the Worksheet_Change code?
change all specific row references to next row available in fill downformula
Copy hidden worksheet
Macro Assist
Why is this code not working
Find last row in column and past below
Combine Two Worksheets
Format row based on value
Today's date
Spin Buttons
problem formatting lines around cells
inserting range value in call
Delete Line
auto open workbook to make read-only
How does this work?
Re: Colour rows based on value
launch macro in other workbook
Colour rows based on value
XL2002 - PivotTable 2 to Match Pivot Table 1
File name to Cell
Prevent scientific formatting when creating excel sheet from vbscr
Re: Importing a string as columns.
Re: Importing a string as columns.
Importing a string as columns.
Change a Macro - Copy in Columns instead of copy in Rows
RE: Command Button to export a worksheet as a .csv file
Command Button to export a worksheet as a .csv file
EXTRACTING SUBSTRINGS !!
Selecting a Range
VBA Changes
protection
Macro for copy and paste function
Locate source data on auto refresh
display time when macro was last run
"String" manipulation for a Case clause
load user forms
group all sheets after
Run-time Error '-2147417848 (80010108)'
disappearing macros
Secure FTP (https) and VBA
Macro and Macro Button
popup immage
within my existing code, check for blank cells in certain rows. Ifblank, exit sub
Data Validation - I Think
Inserting a symbol
Passing a variable into a subroutine in a different open workbook
userform display
Use cell value to adjust date range
Conditional checks in Userform
Excel images
user form, set values
Project is unviawable
ComboBox Help
Color text inserted into other text
TextBox validation code
2003 - MS Calendar Control VBA weirdness
Working with ListBox with frmListStyleOption set
RE: Friday of a given week
RE: Friday of a given week
problem coping data from 1 sheet to new sheet
Re: Friday of a given week
Re: Display VB code result in cell instead of message box?
RE: Display VB code result in cell instead of message box?
Friday of a given week
For Rick Rothstein
Lock lines together to creat pivot table?
Display VB code result in cell instead of message box?
Alert
Macro to add column and insert date then in blank cells copy fromprevious cell
user form, code placement
SEARCH function
Temp variables in formulas?
causing the bakground in excel to flash on an event
Column Match
Connect & disconnect dial-up connection inside Excel Vba
Userform
popup immage
VBA Training
VBA code for Timestamp
THE "INSTR" FUNCTION !!!
Form label not updating immediately
Named Range not appearing in names drop down
VB Code for summing control check boxes
RE: Copy to an existing wb or create new wb if it does not based on ce
Copy to an existing wb or create new wb if it does not based on ce
Maintaining position and Value of certain cells when inserting inf
Dynamic charting; Diff between exec 2000 and 2007
Activesheet question
auto/conditional formatting
Data Entry Form which updates several worksheets
Please help with OLE object and text box content!
Lookup for a value in a table
RE: Msg Box to appear when page selection changes in a Pivot Table
Excel is running too fast
Pivot field data disappears
RE: range shift
range shift
Lookup Return Multiple Values in VBA
Data passed to spreadsheet from Form. How to reload the spreadsheetdata into the Form?
Rearrange data into Columns in same row
Change Cell Color Dependant On Date Range
Column Rearrange same row
Using a text editor into a userform
xlCellTypeBlanks
Passing Data from "Form" to Spreadsheet
button and Excel and VBA
Sub or Function not Defined
Looping Every Nth Row to Copy & Paste Special
Count unique instances of text in column
click on calendar control calendar but want to return the DAY of
My unsolved mystery!
Need XML export solution (Excel 2003)
manual and macro run differences
Office SP2 - Problem with macro assigned to a button changing, Workedwith SP1
Web Queries
Convert Range of Years to Individual list (integers)
insert 1/3 as fraction
Is there a way to force Excel 2007 to recalculate just one cell?
How to see worksheet changes while macro is running?
read from hidden sheet
The use of VBA function "Time" in an Excel Macro
Drop Down List - Other Cell Results
Text>Date ???
System Error &H8004111 + out of memory when using Excel macros
Loop through FTP locations in File Browswer
How to return Array() to range as variable?
paste range from one sheet to each sheet after
Problems Loading Large String Array into Array variable
Disable Alert
Looking for a Form Control that combines ComboBox and CheckBoxes
search criteria - auto filter
Save only changes in a specific sheet, leave other sheets alone
Password on Command Button
RE: F2 Function key
Flashing cells
Running total macro issue
F2 Function key
Destination:=.Cells(.Rows.Count, "A").End(xlUp).Row + 1
Deleting Blank Rows at end of sheet
Renaming styles
Error 5 on Shell Command
open workbook
Change Imagebox Property?
microsoft query
Event drivin copy and paste code
From active cell, select the next 10 rows down, 6 columns over.
Change Sheet Name
Defining XLApp as 2007 App on a machine with 2003 and 2007 loaded
Printing Invalid Data Circles
Open Access Form from Excel Macro
Finding month in mm/dd/yyyy format
"Trust Access to Visual Basic Project" checked but getting error 6
"Trust Access to Visual Basic Project" checked but getting error 6
AutoFilter-criteria with VBA in XL07
Re: auto/coditional format
copy format to new sheet
Selecting between two ranges
ListBox error "Invalid argument"
Write in word OLE object
Copying data from different column
Auto_open MAcro
Please tell me how to make this more efficient and repeatable
Font Style Properties
Adding dates within a comment
Data from sheet, through userform to text box on the sheet.
Code error
Cell Data Update
Colour numbers
Multipage and Global variables
Nobody can answer! Problem with commas and dots
Lock and Hide range of Cells
Clicking a picture
counting instances
send XL text to word
Trying the impossible
Device I/O error
text strings
Cells flashing
Assigning Functions to Toggle Buttons
How to Override a VBOKCancel button?
passing value to excel 2007 document solution on web server
Fourier, numbers-as-text, and macros.
Private Sub Workbook_newsheet
Creating sum formula using vba
Macros for copy and paste of a range
hyperlink prompt
Splitting Range into it's components
Submit Data form in one tab to another tab in same excel?
paste range to all sheets after specified sheet
Re: Please help me with VB Code
Delete Worksheets
Table using Excel range
RE: File size gets huge on photo insert
Need help with macro
Adding company to an Access table
Re: Please help me with VB Code
create sheets based on data in string and copy to
Please help me with VB Code
File size gets huge on photo insert
Can I paste number formats only?
Double Quotes in MsgBox!
How to save a worksheet in a project as a SEPARATE FILE
Font Color
Deleting Sheets via Macro
I have some code which loads a form in Excel on startup
Macro not copying (or pasting?) content of all cells
Is there a GPS coordinate converter in Excel?
trim not working
How do you run an add-in?
Linking cell through variable
If Then Code Question
Launching a Macro bt Double Clicking
One letter per cell
Hiding Rows and Columns in code
Calendar Popup
Update Date Cell
Compile Error
Shouldn't have to ask but..
How to set up macros that will work when aditional data is added
How to build / refresh pivot table without ODBC??
Label caption change on opening of form
Getting unexpected gaps in a spreadsheet
TextAlign in List Box
Use a shape as a gauge.
List Box
InputBox Choices
VB for Different Excel
RE: Password entru code
Code Stopped
Password entru code
Marco to change formula according to what is written in the cell
Buttons
XML schema import problem
Music in Excel
QueryTables/ListObjects and QueryType/SourceType
pagebreak
Extract Chart Titles from graphs
2003->2007 xlsm->2003 loses worksheet commandbutton functionality
LOOP HELP!
ActiveWorkbook.SendMail Recipients
drop down menu with option to add values to the list w/ new entry
Need Help Matching 2 Lists of data
Regex as replace function
fetch a value from a w/sheet to userform.
Moving Part of Column
Custom Toolbars in Excel 2007
"Enable background error checking" on/off in Excel 2007 SP2
Help Modifying Macro
Referencing command button on worksheet from VBA
Initiating a Custom Toolbar
if student number repeats move all data for that number on to same
Re: Repeat copy for indifinate number of worksheets
Execute code when grouping buttons used
Toolbar Error
Need a little excel coding help
Import Access data to text file rather than Excel
Making a process faster
Macro for Hiding one column at a time in a range
Share Excel Worksheet
disable option button on user form
Group function with hidden rows
using vbCrLf in email body does not work with HTMLBody
A macro that will inable/disable input message boxes by a cell'svalue
function LINEST
Stuck - VB Help needed
protective measure
VB Help sought with some code
How to Detect when third part application releases my WorkBook
Where to put PERSONAL.XLS
Address of a Cell
XL2007 .CodeName bug when copying sheet
very confusing
Module
Format Code - Joel
how to separate text and numeric data in the excel or text file.
Date Marco
Adding controls to a userform at runtime
Userform-font change
Macro to add data once a Pivot Table has been refreshed
Excel 2007 - macro for formatting worksheet?
Repeat Range for select Records
Re: Adding Leading Zeros; Formatting as Time
Help with Custom Tool Bar
Adding Leading Zeros; Formatting as Time
Vlookup and Sum
Protection in VBA.
Insert Photo - error on cancel
Resize Range for Column
Question about AdvancedFilter
Find Merged-cells
Updating & keeping
Auto Filter List
How to check for the existence of the Temporary folder namedTemporary Folder a , 2 and so on before deleting as the name is not fixed
How to check for the existence of the Temporary folder namedTemporary Folder 1,2 and so on As
MULTIPLE SELECTION !!
Type Mismatch
Simple example of a range argument to a UDF?
Upgrading to 2007 - Object library invalid
Linking added sheets
word to excel format change
Excel & Access Tables
Thankyou and Thankyou
Reference Textbox from cell
Cleaning up Macro to Copy Word Formfields into Excel
Help with Macro
How to Get External Data from a Service created in vb.net --> WCF
Changing Hyperlinks
moving active cell on another sheet
Templates in 2007
calling sub from other workbook
List files in a directory
why cant my workbook total data from worksheets?
insert name paste for ranges
edit ribbon image ?
problem writing an Excel file on server using Microsoft.ACE.OLEDB.
Check for Duplicate
Run Error while protected
Choose picture to display
RE: Macro Error
RE: Macro Error
Macro Error
If cell contains AlphaNumeric "True"
How do I call Fourier Analysis in Excel2007 in a macro?
Find Matching Zipcode Range for Address
Wildcard to activate another window
Macros Stop Working
Setting a public variable
XL2003 Userform; cmbbox uses named range source, changes unexpecte
Menu creater - Jacob Skaria
How do I make VBA code usable on all worksheets of a workbook?
Column width and Row height test?
Open a CSV how God meant it
Determine Max and Min date in Column
having problems getting a c# excel add in deployed to other machines.
Re: code back to worksheet
workbook code - new sheet created...
code back to worksheet
check entire column value
Has Text Enough Space in a cell
Get text & background color with single button click.
Convert table to range
VBA Help
GetSaveAsFilename not responding
Determine if a chart exists
Initiating a Custom Toolbar
Option Private Module
For a website, are Excel scripts better than other programming language scripts?
checking and setting a value to a range in VBA
Help Defining a range using variables for column
Help to find a code
Adding documents to Lotus Notes Database via VBA
RE: Is there a better code to do this?
Re: Is there a better code to do this?
RE: Is there a better code to do this?
Is there a better code to do this?
RE: Cell data change
VB code to insert page breaks for Duplex/double-sided Printing
Cell data change
Export from excel to Access
Auto Fill fomulas
Re: Conditional formatting of a Row
RE: Conditional formatting of a Row
Conditional formatting of a Row
RE: Macros will not work when sheet e-mailed
Read Only
Macros will not work when sheet e-mailed
adding/appending comment by code
Menu creater - Dave Peterson
formülü yaptıktan sonra nasıl gizlerim?
RE: Select method of Range class failed error message
RE: Select method of Range class failed error message
Select method of Range class failed error message
Loop and running total
VBA compatible code - PC to Mac
SpaceChart - can't see the chart
Macro to filter two columns
Code help
functioning XLL not loading properly on other machines
Creating an Excel Pivot Table using COM in C# producing 0x800A03EC
file names with full path
Problem using group function with hidden rows
Reading a text file from the web
Initializing a custom toolbar
Losing my array from one sub to another
Error on IF statement
delete all rows except
Print To pdf Wait For Save As Completed
Application.GetSaveAsFilename question
RE: Pivot Table Field List
Pivot Table Field List
Trying to create a formula in MSExcel 2007 (DATE based)
User form close
Workbook with macro
Checkbox displays 'check' instead of the assigned caption
import from excel to access with macro?
hello! Want to buy software Retail or OEM, Microsoft, Adobe, Macromedia, Corel Symantec
VBA: Code to Clear IE Cache
Application.GetSaveAsFilename problem
How can I change Format Axis Scale Units of a chart ?
paste data from web to next available row
I need to check for a number in a column before continuing on
Converting Excel 2007 sheet back down to Excel 2003
Re: please explain
RE: please explain
Sending Email using Lotus Notes
Cell Filling
Setting maximum and Minimum Scale for the Category axis
please explain
hello! WTB SELL ME YOUR software OEM or Retail LARGE and SMALL QTY