Microsoft Excel Programming [Archive] - Page 8

RE: excel
Input distanct from a map into excel
Combo Box - Form Control
Clearing cells but also not clearing other dependent cells
Chart Problem
Excel crashes on close
Search CSV for string.
record sheet row order, then restore to that point
Macro Running very slow
Clip art in Excel 2007
Macro continues to run
Macro with an IF/OR statement
Determine who last modified an Excel file????
refreshing combo box in form?
Looping through visible cells
Query using list of parameters
List unique items
How populate multi-column Listbox control?
dictionary->(item, item, item); Can dictionary point to an array inVBA?
Check for data in cell
Move macro to Personal.xls
-->edit -->clear -->all; Can removed from standard menu?
Excel Application Warinings and Errors
Can I have default data in new rows?
RE: Find out, if test doesn't fit in a cell
RE: Find out, if test doesn't fit in a cell
Custom Header Aligment
Placing Icons
UserForm updated
Listbox headers
Data Entry to a Cell Range
measuring waves in the currency market
Apply format to >0 cells
Select a specific row in named range
XML File
Bypass error message to debug
Change code to look at a range of columns not a single column
how do i link spreadsheets on common data points?
i want to input data into a range from a simple input location
Listbox questions
Inserting additional rows and only copying certain columns
Converting MS query from Excel 2003 to Excel 2007
Task Scheduler or VBA to simple copy periodically folders contents toexternal drive
find and replace multiple values in one statement
Sheet Numbering Routine
VBA solution to paste text into megred cells
Working with Both Excel 2003 and 2007
pagesetup.printarea Print non contiguous areas # rows varies
pagesetup.printarea Print non contiguous areas # rows varies
Convert Column Number to Column Letter
Help with modifying a formula.
Create a new worksheet and name it
Trapping value before and after change
Formula on two or more lines
Funds allocation by Calendar Year
Working with GroupName in a control
Sort 2 dimensional Array, copy a row
Moving rows in Macro/If statements
The best way to build your own VBA library
Using IsError with Match
Create multiple Pivots based on list of parameters
How to initialize a multi-dimensional array
combobox after change but user hits cancel to message box
Line break from vLookup
VBA to insert date string
i want to input data into a range from a simple input location
Using VBA to gradually change cell interior colors...?
Test Search For: function this community abcde
Month & Year Text to Date Format - Help Please
Strange Range copying
Fool Proof Price Validation Custom Function
What does the Userform.Tag do?
Hlp! Adv Filter - Non-Contiguous rows don't copy
Automatic conditional formatting from a list
Find Next Row With No Value In It - But Not Next Row With No FormulaIn It
How do I save external data in Excel?
Suppress "Opening File" Alert
Sort with subtotal
Repeat the macro using different ranges
Check column header value
Please help me solve my problem
what is the formula for what I want to do
vba Function code
Program stops (creating pivot table) when too many records
Find then paste
Match the value and highlight offset
object required
Using Date as a Variable
formulas
Centered Overlay Title in VBA
Application-defined or Object-defined-error when changing color in
inserting columsns variable range
Spell Checking on a protected sheet
Message still appears with DisplayAlerts = False & SaveChanges:=Fa
help with dates in the past
macro copy and paste criteria
Web query - one table multiple pages of data
Bluecoat
Checking latest Forefront updates
Display Print Dialog with Selection: Excel 2003
Open a file and execute code
How to execute a dynamically added or changed module
Data Validation -> Validation list is larger than the cell width
Excel runs slow
Info in F but AF and/or AY no info so delete the rows
Retrieve File Names in Directories
Select a file to open
create pivot chart in vbscript
Re: ScrollIntoView Non-Selected Cell ..?
Call
Re: ScrollIntoView Non-Selected Cell ..?
Need help to read Pie Chart Series Range
Exporting PivotCharts and PivotTables from a workbook without"breaking" them
Dates converted into text
Date format problem
Date formatting
MS Excel 2003 - Advanced Features Add-In
"implant" ActiveX ComboBox value into if eq'n
set scroll property of ActiveX combobox in spreadsheet
Re: Error trapping not working
Macro Compatibility between 03 and 07
VB list box print reports. Known # of columns. # rows unknown
New to Userforms - need return value in a cell
SumProduct basics
Loop Overwriting
Dates prior to 1900 are text
VBA code for VLOOKUP - linked to another workbook
Macro or Formula
VBA online classes
Code to Create Chart
Userform with commandbar popup
Count Conditional Formatting Colours - Excel 2003
Use VBA to update Access table or Query from Excel
RE: FileSystemObject: how to tell how my files were copied
Macro
VB and graphs
Excel not opening properly when exported from Sharepoint
Auto Enable Macro
Worksheet_Calculate
populate combobox from worksheet in different workbook
How do I find a column number for a cell containing a value
Re: Unhide Columns With A Password
conditional formatting
Copy Data From Varying Lines to One Sheet
Stop macro
IIF statement to hide a graphic
VB Excel Macro
help extracting data from 3 text files to csv
view list of named ranges
find and remove page breaks
2007 Excel vs. 2003
Entering data from a userform into multiple sheets
Insert Rows if Pasting more Than 1 Row
add years to a cell
Calculating age at different points in time
Date VBA
Visual Basic Editor Opening and Closing for User
? Index of Names
Updated Links
User Public Type, circular dependancy error
toggle read only
Can you automate the ALT+ function?
3 month rolling totals
Re: Excel 2003 VBA program kills itself in Japan
Sort code doesn't work on first pass, works on second
rounding to nearest .5 in vba
bizarre formatting issue
loop until vlookup true
Axspreadsheet datasource
Nested loop Programing Challenge
Split cells VBA
Loop thru used rows in column
VBA code for copying part of a sheet to another, with column widthsand formats
RE: File status = "read only"
If greater Then
Printing Via By Macro for Network Printer
Selecting items from list and attaching ratios to selection
Combobox linked to Custom Views
Check if webpage is open
Private Sub Workbook_Open()
Convert Case
Convert Cells to uppercase
Programatically open Access DB with user level security
How to show a message box ?
Dealing with windows 7 folder structure
input numbers for code
Problem with Word 12.0 Object Library
remove vb project
show column headings
Simple VBA Code Working in Excel 2007 but not Excel 2003 #N/A
drop-down for entire column
Run-time error â€˜13â€™ mismatch type
vba help issue
Identify last date of a specific month
Passing a string to a function instead of a cell reference
Update individual worksheets from Master Worksheet
auto open from any folder
SQL query in excel (VB) using multiple parameters
Paste data from AJ to K
User Form Text Date Format
Formula Help
Number Format with Macro
Copy/Paste Values code
print labels from userform
vb to Unselect a Filter Value
delete ghost spaces
Marco to copy and paste values based on cell value (cont)
Practical Jokes in Excel?
Subtotal multiple columns and ...
Editor Window
Can I use an IF ELSE statment
Update pivot table report filter using cell value
Multiple Forms for Data Entry; re-loading data
Match Ranges problem ,
shortcut for same directory
RE: File status = "read only"
selecting qty to print via textbox entry
Looping
Code so that worksheets cannot be added to workbook
change cell value by code
Printing App
alternate sort on different columns
locate add-in
To disable pressing of Enter key on a sheet
Problem with VBA code not running in Excel 2003
Help with creating drop down
What is Selected?
Autofilling Cells for Daily/Hourly Schedule
xltm saveas xlsm
xlookup & paste a picture
even the codes in microsoft's help section don't work
XL2003 - CreateObject("UserAccounts.CommonDialog")
Excel converter download
Does a workbook become fragmented after much editing?
Startup Notepad from Excel???
Re: Excel macro filter Like keyword
Data Array Not Calculating???
Change Shape text / Color
Extend Custom function
Save command before emailing workbook
Macro to copy paste values based on cell input ...
copy named range & paste values
Parse only text from column?
Copy a worksheet
HELP modifying macro to delete rows if more than 1 condition met &
find sheets with by part of name
Macro to change pivot field with latest value
How to disallow a zero value in an array
copy active row and repaste values
drop down list for IF equation
Excel 97 replace vs newer versions...
Remove lines from text file prior to importing in Excel
Extract only text from column
"Undo" creates bizarre behaviour
Excel worksheets auto-incremeting question
mark active cell and return to paste
VBLOOKUP BY DEPT
Insert Row without changing formulas
Does Excel Support the VB List Class?
Filter/Display only certain rows of information based on a user na
Moving an active cell
Delete all rows except...
Password Userform Help Please
VBA Select File
Pasting into an active cell
Pivot: grand totals
auto generate sheets in a workbook from list using a master sheet
Checkbox linked to calcs
use command button to total datas in cells through VBA codes in ex
Remove duplicates from list using code
Distribute macro to users
XML generating excel charts
Checkbox linked to calcs
Text in cell is not visible! 8(
Check to see if a formula is correct
Collating stock market data
choosing cell to top left of visible window
Test named range exists & exclude worksheet if it doesn't
SendMail
Automatically Sorting of Excel Records (Macros)
MSCOMM Control with Excel 2003
truncate date; nix the time component
VeriSign Digital Certificate Failure?
macro to continue running if error
Excel VSTO pivot table code revision help needed...
cpu usage when excel is in taskbar
Conditionally disabling activex toggle buttons
Automatic increment of onTime
VBA code to find first blank cell in a column and activate it
VBA code to "skip" empty rows
Entering Values in a Single Cell to Update Next Empty Cell in a Ra
Detect if Excel file is "read only"???
Another '03 vs '07 Add-in Menu Question
data validation, mouse action of select... then move right
Shorten multiple sumifs
better way to copy data from an embedded html box
Macro to Insert Worksheet with Worksheet Name the Current Date
Error: Microsoft ODBC Driver Manager Data Source name not found
Shift Roster on Excel, pls help
define range using col and row names; not cell name
Import selected worksheet from another workbook
VBA forms in excel
using a command button in excel
Filter Column
Object Heirarchy Chart
Using named ranges in macro
Right Click - Disable item
Copy Values From Wbk1, Outlook Them To Another PC, Paste Them IntoWbk2
Vlookup help needed
How to create a folder & error handler
Hide Rows based on Combobox Selection
Queries created by MS Query not in QueryTables collection
More Useful Row Autofit
Macros in PERSONAL.XLS
Returning a named range source reference
Userform Command Button
Create shape, name shape, add text to shape
Select, copy, insert, then paste.
Accessing Autofilter Lists
freeze panes from vba
Passing Userform Control to Subroutine
Printing App
Macro to Delete Rows if true HELP!
Sort function
#VALUE ERROR
VB: Convert rectangular clusters of # within field: FindNext, Find
Do not calculate or update formula's during macro
Compare row contents to baseline data
Macro/VBA to loop through list of values and output row- Help Need
Who do you read an ini file with Excel VBA?
mouse pointer to be focused on userform command button upon opening
Trigger Event Sub when A1 <> B1
Upload file to SharePoint from machine with CAC
Search for strings listed in column - Excel 2007
Re: cell.value comply with cell.value before and cell.value after
Finding Duplicate Entries - Saving Worksheet if none found
VBA - ThisWorkbook
Multiuse (Single Instance) or Single Use (Multiple Instances)
Payroll,formulas and Macros?
Side Filter
Filters - sort state
Lots of text in one cell
Multiple tabs in 1 worksheet
vbcrlf question
Change Data Connection Definitions from local to sharepoint
Macro needed Fortran to VBA
Need Macro Fortran to VBA
What is the right syntax for vlookup in vba?
Reading a textbox ole/control
Changing page height while in a multipage
Impossible Macro?
Enter data on one sheet and copy to others
Autofill Data
Resetting the chart count
Type checking from VBA to C++?
Links Based on Cell Values
Unfilter a sheet which is filtered
Name A Range
list box controls - text property
Validate to quarter units
Data Validation for Prices in Cells
prevent user from deleting a tab prevent running macro from menu
Find a text
Can't figure out this PasteSpecial error message
number stored as text
Sorting a protected worksheet
Command Button Macro to Expand/Collapse Grouped Columns
Need to make sure workbook is open before proceeding
Macro Needed
How to check if a certain function is used
module not accessable
excel vba language refernce manual
Concatenate cells from M9 to Last row in M
.Formula vs .FormulaR1C1 in 2007
Disable autocorrect in active worksheet?
Can some one modify the thirdfriday code to get me the following d
Import MS Word 2003 Table to Excel
what is wrong with this formula
Move data from Doc1 to Doc2, end with 2nd doc open
List ALL folders and files
Rolling Total
Rounding 2 decimal Places
Autofill
Minimum function in a list
Certain string in cell A1 causes a change in Cell B1
Can you write VBA to export objects
Subscript out of Range problem Copy Cell from one workbook to anot
I need to change from "=E7" to (equals the current value of E7)
Finding the minimum value in a list but excluding zeros - a variationon an old problem
VBA Loop If statement
excel user form
Nested Ifs VBA, How to
Search options
VB to search a value in an array from a sheet then write another c
Copy and paste range ontime
Unexplicable error
Convert Macro to custom function
Grouping Rows
Copy data from one sheet to another
Why use tables??
Data Validation, Via A Formula
Conditional Format With Wildcard
Round to 2 decimal places
Modify RDB's Copy filtered data code to loop through multiple shee
I'd like to modify mt Macro ...
Immediate Window Can't Be Viewed
Calling a module from another module
Combine multiple sheets within workbook
Loop to retrieve value in worsheet A and put into worksheet B
Deselect cells on multiple sheets after unhide
Retrieving current custom sort settings
Database to Excel REF#!
Find Highest Score In List Formula
Suggestions to start programming in Excel
hiding row if the cell is found in a differeent column
Re: Exporting Data to Excel
Re: cell.value comply with cell.value before and cell.value after
Resize Excel Window
disabling specific items under tools menu
Exporting Data to Excel
VBA Programming help
Optimization Modeling with Excel Solver
Projecto VBA
Input specific value into cell if Row has data
Formula for Counting Two Characteristics in Separate Columns
cell.value comply with cell.value before and cell.value after
copy paste fail
sumproduct problem (another one)
problem returning a range from a function
NetWork Printer Selection Problems
Compare sheets for matches
Subgroup from the Main Group of Data Consolidate
Excel deleting xml item problem
is it possible to convert pdf file into excel?
Automatically Sorting of Excel Records
Change location of XLSTART
user to input date as "yyyy" in cell
Link Drop Down list with PIVOT Table in Excel 2003
Full Script for Excel Spreadsheet Import Automation
Slow subtotal and insert row
What is FreeFile() function???
To get the same header,footer and sheet titles across multiple sheetsof a workbook.
Storing and Accessing Data
button text size gets bigger
Ms Project to Excel Linked
Modifying a locked/protected sheet
rt error 1004
Toggle Text button between two options code needed
Easiest way to match against array of holidays? XL07
Force PasteSpecialValues in Excel 2007
Inserting new rows into sheet
Hiding Columns based on cell value
How disable an Excel dialog box?
User Form Locks up Excel and must be restarted
Prohibit duplicate data in a cell
Cells object question
WaitForString Mutiple Conditions
macro to update last character
Value Metadata
Macro to update last character
Generated file--charts squish when saved in .xls format, ok in .xl
Test for comment in cell
Will my 32-bit Add-in work in 64-bit Windows?
menu 2003 to Excel 2007
How can a workbook grant access to another one
Directory Name - IF Named Range Exists
Table with two pick from list columns that need to vlookup each ot
RON DE BRUIN Merge data from all workbooks in a folder HELP
Re: Excel 2003 VBA program kills itself in Japan
Re: Excel 2003 VBA program kills itself in Japan
List all folders and files
For loop - update your expression to evaluate
Re: Excel 2003 VBA program kills itself in Japan
Print Function? - Combine 2 textboxes and 1 range in footer?
invisible Add-ins in Excel
Having trouble using LINEST in Excel 2007 VBA
Puzzling attribute - trying again
Large Amount of Info on Clipboard
Need help with VBA code
Streamlining repetitive report
ammend to exlude sheet(s)
Update Password Protected Links
email macro
parsing and importing a text file with records through a VBA macro
Loop copy/paste for x columns
Clear Check Box
Distribute an excel workbook shortcut
append query with dtae and username
Finding Specific Rows and pasting to new worksheet
How to pick date and month?
Format number as text on multiple files import to a Single Workbook
Formula needed to SUM and COUNT in specific way
Formula problem
Problems open workbook via macro
Display required succeeding cells value if a cell value A1 is capt
ComboBox Dropdown not under control
Deploying Excel com component on server did not work
Increment number in textbox with KeyDown
Problem removing page break
Date format Workbooks Open
Determine if workbook is open
Delete row problem
Storing VBA Code In a Cell to Use real Time
Find a value in a worksheet
Summing Boolean
How do I create Folders/Sub folders from User Form control button
Paste into spreadsheet in userform
This book has lost its VBA project, ActiveX controls and other fea
Error using offset
cutting and pasting data within a worksheet, from one sheet toanother, using selection criteria
Adding a leading zero "0" to a number in a cell
VBA 2 Codes
Undo Macro Action
emailing spreadsheet with macros
If cell D2 begins with 00 then E2 =
Unprotecting cells using VBA
fill down and across range
Shading a row red as soon as a cell entry in column L says "Error"
Worksheet().Range.Calculate Problem
VBA
Macro runs fine from VBEditor, but not button
Validating clipboard data
Data Connection: Access Query to Excel How to get rid of header ro
Grouping radio buttons?
â™*Modify my code: Need to qualify FolderDialog selection
How do I use Conditinal Format for another cell?
SetRange Help
Find all cell with a decimal value
Re: seperate
too many arguments error message in excel
Errors Closing Userform
Moveing Rows
Is RowHeight=0 the same as Hidden
Number format of ranges using cell value
Need a UDF to count blank cells
sumproduct problem
Workaround to define an array of constants?
Excel to Access - User needs Access installed?
Change Formula in sheet by adding a new part
Subtotal GroupBy text string
Page 1 is full with data...now what??
Timer that auto-closes workbook?
one workbook, multiple users....
Opening two workbooks
Need offset function help, I think
UserForm1UserForm1_InitializeProblem with Office 2007
Code for IF
KeyDown in TextBox to increment Number
Max number of columns in 2003 vs 2007
run macro in another workbook - error 1004
Moving a row
Date conversion question
Enter formula by code.
labels for subtotals
filtered rows getting shaded alternately (conditional formatting)
a repeating formula based on multiple options
Re: Can't call a sub in a UserForm using Application.Run
Add days to date
How to draw blue borders dynamically like pivot table?
macro to calculate or make/update formula
Turning off display while VBA running
Creating a variable and pickout data
Go Immediately To A Particular Cell After Inputting Data In AnotherCell And Hitting Enter
Err.Description as error proc name trail, error handling
Re: Adding an image signature to an Email generated from VBA
Code to send SMS text message?
How do I reference cells in CF formula within loop
Dynamic worksheet selection using messagebox
MSCOMM32 Control in Excel 2003 VBA
Re: Adding an image signature to an Email generated from VBA
Tooltip Balloon in worksheet cells - Solution
Display of the tabs
linked cell math help
Re: Adding an image signature to an Email generated from VBA
Question Responses
working out which colour text is used to populate a cell
Adding an image signature to an Email generated from VBA
Write to MS Word
RE: Checkbook register
TOUGH MACRO - DARE TO CODE IT
opening up Powerpoint slide from Excel
Excel file types?
Generating an RGB color spectrum based on cell values (XL03)
Macro - New Workbook
how to store user responses
formula to change font colour depending on which cell it has used
conditional formatting
Run-time 438 - OptionButton troubles
Chart on a worksheet, find chart location
Need help
HELP!
Still need help
Excel AddIn - how to get formula from Formula Dialog
For-next loop question
Sending An Email
ActiveSheet.ShowAllData
Re: Number and Text issues
macro naming
Avg Calculation
Number and Text issues
Re: Checkbook register
Alternating between duplex and single side printing.
If And formular Or somthing else
Macro to find highlighted cells
Excel Formula Guidance. Formula need to determine if cell is popul
Excel as front end and SQL Server as back end
Re: Checkbook register
converting excel 2003 adp projects to 2007 or 2010
Date Picker
Data Reporting to a cell
set print area on multiple sheets
Lookup VBA
subscript out of range....
xlPasteValues is Empty
Worksheet Change Event log for multiple cells
SQL General Help
Creating Excel Sheet using VB 2005
Beginner: Compare cells, if they have same value, then copy the ro
RE: P value in excel
Unlock VBA Project after getting wrong first time
Sorting data on button click
fear of a bug, hope for a workaround
Free Manual
Tracing Dependents on a Protected sheet
Email Disclaimer
Select multiple ranges using cells property
Macro to change pivot field with latest value
Getting the name & path of a hidden WB
Excel Files not opened
finding matching text in different sheet
Change Number to Text , Case error when cell is String and format isGeneral
Referencing A Workbook
Array formula does not calculate correctly when run from macro
Excel 2003 get text after wraptext problem
Read from Form to Worksheet
For Each Next Loop behaving in unexpected manner
Programming "yield" function in Microsoft Access
string to range
Beginner- Macro for Resizing Charts
Populate combobox with folder names
Re: Better protection for VBA project?
Data Tables
Looping thre named ranges
Collecting Range Name values to VBA
Macro that can sort out a variabel name among others in a row and
How to start excel in "safe mode" programmatically
Re: P value in excel
A1-B1-C1=D1 BU FORMÃœLÃœ Ä°STÄ°YORUM
Array Formula Confusion
RE: reference inside worksheet function
RE: reference inside worksheet function
Coding problem
Code arrangement
Calculate Duration with UDF
how to add a textbox if user chooses yes in response to msgbox.
Can a checkbox be created with a logic function?
macro in excel
creating macro to seperate lines
Hyperlinks
Change text in textbox in chart in Excel 2007
activate, window activate?
Freeze section of worksheet to show on all other worksheets
MS Excel Automation - Checking if a record in Access is locked
unable to set the locked property of the range class
Fire Code after Preceding Events Run
VLOOKUP
Chart Label Positions
GetKeyBoardState Function
Check for the existence of conditional formatting
Listing files with full path
Unspecified Error in connection to Access 07
Find Date in range and scroll down to next row
How can write this as workbook function ???
Macros in excel
Averaging specific rows - HELP!
Data Validation won't copy
ADO Automation Error
[Microsoft][ODBC SQL Server Driver]String data, right truncation
Macro doesn't execute fully using shortcut
I must make certain I have a specific range of numbers present.
split excel into multiple sheet
Fix multiple 'assign macro' references broken due to moving sheet
Conditional Formatting - indirect
Reference the previous Worksheet in a Formula
Excel 2000 QueryTable to MSAccess SQL with "TRANSFORM"
help with Applying nested Loops
Display all cells values of that row from where a cell value retri
Format a string before write to a cell
Cell content capture and release
How do I setup a cascading combo boxes?
Code to fax range?
Check to see if entire string is UpperCase?
Form Control Button Name
Calling Private Sub from User Form
SaveAs in VBA or through interface extremely laggy
HELP: Excel userform version control issue
HELP: version control issue
Colouring cell if it has a specific date
using a inputbox to enter search item, then find all highlight al.
New free mail add-in for Excel/Outlook 2007-2010
Macro help
for loop with If then question
reading HTML
application.run on new sheets created
Conditional Formatting
Conditional Formatting macro: simple, but doesn't work
How can I delete a space/character from a number of fields?
Help with combining cells
VBA message box to inform user that Excel is still calculating
Export to pdf - Office 2007 sp2 issue
Filter worksheet based on named range on alternate sheet
HELP!! Formula for calculating overtime
Check if data has already been formatted.
Prevent a workbook from displaying
Extract data from csv file
List output to a x by 10 range
Help in writing dynamic formula in vba
shape remains selected
Delay Calculation of A Cell
Shared 2007 Workbook, 3MB, 15 users, locks up after 2-3 hours of u
Cell ID property
text box in userforms and international number format
Excel - Macro to rearrange/add columns in all the sheets based oncolumn header
how to get the width or length byExifReader$B!!(B
Scheduled task method of opening Excel questions.
Variant vs Double for functions where data could be "null"
Excel Companion
Find errors in Excel.
Convert text into number code
find question on vba
protect check box and cells
Sum up values in each column in 12 different worksheets and displayvalue in a MsgBox
Whats & Hows of XLL?
My Macro is slower than the turtle
Why is Add-In (.xla) Workbook Read Only when I try to save?
PERSONAL.XLSB
Trouble with Clear Contents Macro
Search the column and return a cell value
Copy data from one sheet to another
Macro or scripting help
Create new spreadsheet based on template from macro in Word
Getting the values in a named range
counting values in a column
Having trouble with combo boxes.
Can't find "Visual Basic" Toolbar on Excel 2007 Ribbon
find range and fill down
counting values in a column
Colouring any cell in worksheet with negative value
counting values in a column
Office 2007 acting differently--macro not available in this workbo