Excel Programming [Archive] - Page 9

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
Sum Range
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
Reference to values disappear after closing file
Retrieving current custom sort settings
Database to Excel REF#!
Find Highest Score In List Formula
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
color matching
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
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
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
List all folders and files
For loop - update your expression to evaluate
Print Function? - Combine 2 textboxes and 1 range in footer?
invisible Add-ins in Excel
Having trouble using LINEST in Excel 2007 VBA
Excel 2003 VBA program kills itself in Japan
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
RE: Alternating between duplex and single side printing.
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
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
too many arguments error message in excel
Errors Closing Userform
seperate
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
Add days to date
How to draw blue borders dynamically like pivot table?
Can't call a sub in a UserForm using Application.Run
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
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
Tooltip Balloon in worksheet cells - Solution
Display of the tabs
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
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
RE: Excel Formula Guidance. Formula need to determine if cell is popul
Re: Excel Formula Guidance. Formula need to determine if cell is p
Avg Calculation
RE: Macro to find highlighted cells
Number and Text issues
RE: If And formular Or somthing else
Re: If And formular Or somthing else
set print area on multiple sheets
Lookup VBA
subscript out of range....
xlPasteValues is Empty
Worksheet Change Event log for multiple cells
Checkbook register
SQL General Help
Creating Excel Sheet using VB 2005
Beginner: Compare cells, if they have same value, then copy the ro
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
string to range
Beginner- Macro for Resizing Charts
Populate combobox with folder names
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
A1-B1-C1=D1 BU FORMÃœLÃœ Ä°STÄ°YORUM
Array Formula Confusion
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
reference inside worksheet function
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
P value in excel
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.
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
counting values in a column
Office 2007 acting differently--macro not available in this workbo
range of unique cells
Use IsEmpty on a range without a loop? XL03
Retain Workbook Name throughout Module
for every cell search identical in range, not whole column; how?
MACRO
Copy Data Validation
finding the index # of a workbooks
Any way to determine Service Pack level on an Excel install
Seaching Ex cel for text styles
Table function
Spreadsheet issue
Enabling Spelling Option
Unwanted spaces
ActiveX ProgressBar - Scrolling Error disables color update
BACKUP file created when saving Excel Workbook with VBA
How can I get only visible cells using range.get_Value?
run on each sheet after
Autofilter stops Change Event
Excel 2007 Routing workbook to Outlook
Selecting from Worksheet to fill combo boxes on User Form
Newbie question on variables
adding columns to an arrray
how to re-sign macros afted editing them?
RE: selection.text erro 1004
test
Open file and keep it hidden
Is there a VBE constant for NBSP (Chr 160)?
Counter stops working
One button, Multi Cells
Macro execution changes filename reference for all macros
Worksheet_SelectionChange
Return to original workbook
VB Popup Alert Help?
Pivot Table xl2007 Q
Run macro on column insert or delete
Find file and remove .csv extension
Conflict of two macros?
Error on Code
Hide a formula. Change Source data
Selection autofill
search for lowercase letter in two-letter 'word'
How do you delete a custom menu?
I have nearly run out of Shortcut Keys
Run-time error '380'
How do you resize a Multi Page User Form?
Clearing contents beyond the "Z" column
Warning pop up window
Excel Won't close in .NET 3.5 using C#
xlDialogPrint arguments
Formatting 1 cell depending on a value of another.
File SaveAs
Find cells that contain text
value lookup?
Selection.AutoFilter Issue
test that there is something to undo before executing application.
Displaying userform before worksheet displays
Open file and keep it hidden
change color if more than a year old
Excel VBA Programming
Help file
Rename filename.csv
sendkeys sends every other letter Excel 2007 to Outlook 2007
advanced filter date criteria
How to forcely remove or overwrite an open excel file
Unable to open links from Excel in new tab - keeps opening new win
Last Column
Response to txtbox content if not found in the worksheets: Excel V
How to add days in date by macro
Removing picture from a worksheet
Removing Border lines and colour for All sheets
Problem running sub on a User Form
Print titles must be contiguous and complete rows or columns
User-defined function not recognized in formula
Find value in another column, change Interior.colorIndex
Selecting a directory or folder in Hyperlink dialog box
Delete Corresponding Cell Using ByVal
combine two row in one
Linking Check Box in User Form to Workbook
Workbook protection question
Transfering Data From One Workbook to Another.
creating database help please!
Removing Scroll Bars from a Listbox on a Form
Colour-coding a cell from a drop down list
Create Checkbox and link to relative Cell
Enabling Macros in a Password Protected Spreadsheet
Code help needed for Option Buttons to control Subs
Wanted: ? UnknownFunction("vbOK") returns 1 in VBE Immediate window
Copy Destination
MultiPage
Creating a plugin for supporting my own file base format.
i have problem in User-form
VBA Help problem
Application.Dialogs(xlDialogPrint).Show
Modern day considerations, Integer versus Long
Autofill Error
Autofilter of Protected Sheet - Excel 2000 (not 2003 or 2007)
Environ("Username") with Windows7 64bit
Downloading stock data
Selection.ClearContents makes macro halt???
Export multiple Excel sheets to a single text file
using cells property
sql update problem
Macro search text boxes
Create and populate a SmartArt graphic
Need help
Modify data on a hidden sheet?
delete all spaces in range
Find a subfolder?
Help with Clipboard
Can I calculate eigenvectors and eigenvalues?
Limitation for worksheet_properties?
Running UserForm1 routines from UserForm 2
macro alternate conditional format change
Stop Outlook for asking for permission?
Copying a row and pasting the same below it with just formulas
Excel SaveAs to force overwrite of extant file
Upon closing a file each new row of entries in a spread sheet becomeread-only
downloaded/uploaded sheet not reading data.
cells with formula fire worksheet_change when navigating thru them
Asking a user for information and then inserting a row with thatinformation
FindNext and more than 1 Area
delete column if blank
Keeping the date fixed
Best ways to search an array/collection for an element
Media Player Help
Filesearch Errors
Run-time error 438 - using With
XL03 suppress 'missing XLA' msg on Workbooks.open
Copy Method Failure - cont'd
Copy/Close error
BreakLink method for 2007
add/sub time/hour tracking in 24 clock format
Copy and Paste based on criteria
Assigning a cell address to a variable
Why is the vba project getting duplicated in excel 2007.
Updating dates
How to automatically activate VBA coding within worksheet?
Error in loading DLL
Simple Macro to Auto fill Cells
find header then replace header with number of entries below heade
GetSaveAsFilename X & ActiveWorkbook.SaveAs X
WHERE ARE MY BUTTONS
OssieMac help with code.
capturing TabStrip events inside an MsForm
I'm Paste values stupid
Reference a cell value in a formula
Split text into 2 columns
what references to use for vb.net 2008 project and excel
Copy Worksheets To New Workbook
Macro to import multiple sheets
Importing multiple sheets
Checking the Value of a Check Box in a Macro
How do I change a variable name based on a sheet name
Get text from Win Clipboard into VBA variable
Copy Method Failure
Modify Protection Macro to allow formatting?
Protection Macros--modify to allow format changes
prevent print
Macro please!
change categories to values vice versa
counting blocks of data
UserForm will not appear
During VBA waiting for Message box answer problem
Trying to create conditional format cell
Updating Series Data for chart based on variable.
Printing from Preview Screen
For.. Next with exception
Excel 2007 VBA shape fill colour problem
Autorun a macro at preset times
conditions are met but actions not (always) taken
Conditional formatting
How to automatically trigger the vba coding by opening worksheet?
Macro looking up to:Return distinct values
Value of wdAlertsNone
selecting rows using a variable
Multiple Digital Signatures (SelfCert) in an Excel Project
Can I mass-change macro paths of tool buttons?
Sending MORE than one workbook AND using .CC and .BCC as well?
add rows to a sheet
how to add new row to table in Excel 2003?
Extract numeric from text string
VBA code not working on other PC
Printing several worksheets
Help! Canâ€™t debug macro used to delete duplicate rows
How to evaluate VB constant name in string variable?
Macro to delete cell contents EXCEPT for last 5 characters
Macro needs to rename worksheet tab name
using lookup function in vba
How to check row is hidden when apply filter
Macro, Auto Return
Scan for combo then insert row
Hyperlink Cell to Shape on seperate worksheets
Dynamic multi-dimensional array
Automate Copy and Paste?
Make a sheet for one year?
Possible to nest
Text to Columns
Excel opening blank or Gray worksheet
Running code when hyperlink clicked
moving data dynamically based on empty cell
Excel Autofilter Copy and Paste with Changing Values
batch file to ftp code not running - please help!
IF COUNTIF - Need Help with multiple criteria
Merging several workbooks from folder to 1 workbook in different s
Need help utilizing the "Like" function
VBA - Opening afile, copying the contents
Multiple VByesno Message boxes no working
Range updates
Updating Pivot Tables Dynamically
Storing BLOBs in excel files
find text in a string
Time calculation
Prevent deleting of cells
excel 2007 errors on chart changes
Developing a code that uses a combobox for an autofilter criteria
Event Sub when one specific cell changes
len replace part 2
Active X problem with Win 7 and Excel
Auto refresh
Copy and close code
Rank non Contiguous
Getting row indexes on Range
How to insert 3 images into excel with aligning each positions?
Retrun row value for $A$12 , return 12
How to Search two column value are match
File disconnect with QueryTable
Totalling then Averaging subject to Product Code change
Column
Is there a macro equivalent to cell function SumProduct?
How to resovle Screen Flickering
How to stretch image cover specific cell?
SelectionChange Event question
Convert Numbers to Text
Disable Print Function
.SpecialCells, xlCellTypeConstants, and a null value
Macro for uploading data from other Excel files
Multiple Offsets
Hyperlink events
How to edit the code to fit image within specific cell?
"De"-select a forms control programmatically
XL03: Avoid "workbook contains links" msg when opening
Selecting a specific sheet by codename in an opened workbook (XL03
time to seconds
Multi-line text on a CommandButton
Excel macro or command button to search using a user form
TransferSpreadsheet and NamedRange; not working!
Referencing a ComboBox in VBA
Insert cells
How to find multiple same char in a string in Excel?
C++ Excel 2007 SDK
Jet Engine MaxScanRows without an ini file or registry
Renamed invalid sheet name
How to edit the code to insert more than 1 image?
input box loop
How Check some cells have been updated
Cleaner coding to repeat process
Extracting Digits From Text
if cell is text move left one column
RECORDSET file name length limit?
populate cells within merge area
400 Error
Working of formula in Macro.
Preventing "Protect Workbook"
search data
calendar object in excel. could be displayed clicking a cmdbutton
Autoload UserForm TextBoxes
Excel - BREAK in macro/VB
Error in formulas
range copy and paste special within macro
XL2003 Select each shape sequentially, show handles, and make visi
Excel 2007 Not Drawing Correctly
using excel from dotnet
how to detect if an addin is running
DOS..BAT VB Progamming problem
Last row + rank help
Help with Selection.Replace
Excel 2007
Use of array formula
loop till no more data
Reference a cell in criteria range
ActiveX Media Player Question
Convert Base 36 to base 10
List box value returns the row number of the list box range row
mouse selection of shapes
Trouble with Cutting and Inserting a Range
Macros only 'half running'
Paste Excel workbook into Powerpoint
Pivot page field
Ribbon callback from built-in buttons to trigger additional code
reference excel interop assemblies
when certain rows are hidden, can I also hide a combobox?
Find last column & copy/paste values
Mouse position within worksheet
How to use InputBox for passphrase entry?
2 sheets and a select
Problem with ".Visible" sheet property
Check Box linked cell offset
Application.OnTime stopped working
Hyperlink function presents variable results does not work in macro
Call macro after "macros are enabled"
WORD
How do I make excel say a phrase when hitting a certain goal in a
Sum of sub groups
Method to group lines
Multiple users saving data to a single file
RE: how to create a hyperlink in excel for a private mortgage insuranc
How to change this Ron deBruin Macro
Fails RTD Wrapper functions Excel 2007
Email help
Case select and sheet codename
SaveAs dialog argument for file type
paste data from a workbook on a userform spreadsheet
rotate picture based on cell value
paste named range on each sheet created
Delete Rows
Problem with selection behavior Text Form Field inside WORD table
Delete a code
fit to one page
Delete all rows except
formula through inputbox
How check if Application.Run fails??
help with listing data
freeze panel in a userform spreadsheet
use find to find fill?
Class module memory leak?
Problem with ATPVBAEN.XLAM in Excel 2007
How to populate a combo box with filtered data from a named range
Macro to delete last entry of a column
Get data from Access file
Insert code
Ignore the 'file in use message' when opening Excel
Speed and the "number dates".
Totalizing a value and Autofilling contents
Sort on last two digits of data
Import 1, 3, 6, and 12 month returns for a list of mutual funds
Macro Question
Setting Start Point in Hyperlinked Video
Sub to check and report any formula returned error (eg: #REF!)
Lookup Data in external workbook
Protect/unprotect a list of sheets via their codenames
References - Definition and Use
delete all rows except those meeting criterias
pivot table to MS Access query
Dynamic Array not response
Sort, Select and Avg Macro
Input Box
Color Codes: Different color with same color Index
How to return an error code from a function
Excel 2007 + PIA + Win7 + VS2010 = yikes!?!?
VBA: Activate sheets within a loop
Clear all rows except first two
How do I Hide VBA excel sheets after saving
Re: Removing unwanted symbols eg
Excel Download using Microsoft.Interop.Excel
count names
Userform
Help - macro messes up the character formating
Change currency on all sheets based on one cell value
how to disable/enable command button (ActiveX) using a macro
Clear contents on specified ranges
Hide defined names?
Networkdays
VBA code to run macro in certain file based on name of file in cel
Inserting multiple rows in multiple worksheets
Question about User Form Window Size on Chip Petersons Site
Insert a code
Problem inserting cut range
Excel 2007 'Copy as Picture' doesn't paste at 100%
Sort data to show in a series 1,2,3
Excel 2003 VBA Phantom Breakpoints
String search
Append Worksheet name to each begining of each row with values
Run-Time error '13': Type mismatch
using countif function in code
Shift key doesn't stop Auto_Open() from firing
if statement with or
Macro to Exit Worksheet when vbNo selected
Allow VBA code to change a locked cell??
Delete Named rnage and Add Named Range
Loop IF
macros disabled
Sheet Codenames
Macro that concatenates content from cells if given keyword is found
Chr$
from mdf to excel data export
A coding style question
Macro to check if current cell value is 1 and previous cell was 0
Vertical Center Alignment for Labels
Capturing "text" instead of the formula
Adding code right after the "Save As" dialog box
Copy/paste speed
Shorting a long title to a worksheet tab
Memory Issues with UserForms?
Message Box - Formatting Question
Take Up A Collection
Mixing data from 2 different tables
select range in column, calculate on range plus 3 columns, output inrange plus 7 columns
Delete a sheet and delete a module in Another Worksheet then save
Any more effective method to get selected item in Listbox?
Error handling in VBA
len replace function
Application.enableevents = false not working in workbook open even
UserForm show mode
Merge data from sharepoint workbooks
Dynamic Named Range
Visual Basic library?
Need macro that deletes B columns in all sheets
mapping columns
Can Excel startup Word?
Return Primary Key
Copy from one Sheet and Paste to Another
Input box replace text in textbox
Open files with same name?
Find number in Row 1, Copy Paste Values in Rows below
Cannot use recordset twice with copy From recordset
Hide Screens While Macro is Running
Check to see if cell is blank
Pivot Table Errors
Exporting issue to excel 2007
Where is VBA's BeforeSheetChange event?
Checkbox in Treeview control
HELP copy and paste
HELP: Auto Populate Excel Userform fields from access query result
Change cell color after processes - type mismatch
Data mining question
Check if clipboard is empty before pasting
Import Modules
Suppressing questions in Excel Macros
error while running macro, but not if stepping through lines.
Problem with If,Then, Else
Comparing values in a cell and looping
Addin - Look for a File when it is opened
C# Excel 2007 workbook application with VSTO Problem
How to check programmatically if Excel is installed?
Compile Error: Procedure too large
EOF behaviour
Excel 2007 VBA shape fill colour problem
Calculating(Processor(2)): %
Slow Macro
Moving an ActiveX control
Vba code cannot select text pasted from .txt file
Custom Function Updating Links Errors
Monthly Report
Disable close unless key held
Search any part of an Access recordset from Excel
mporting multiple text files into Excel with corresponding filenames
Everchanging number of rows
Vlookup
Getting the next higer value with Vlookup - True
find idmso custom tab in ribbon
Macro that unhides a sheet and takes the user to that sheet
importing multiple text files into Excel with corresponding filenames
Dynamic Array for data consolidation
Share Portfolio - Averaging the Cost per Shareholding
Paste Value Toolbar Icon
open text file, get file from directory, update file
variable for percentage
Passing a Parameter to the workbook open macro
Charting multiple graphs from a list on another worksheet
RefEdit in UDF ?
Need a way to verify a string is present in 1-column array?
Advanced Filtering
On/Off control?
VB Script XL - Range Selection
Is it possible to assign fonts using formular?
Calculating(Processors(2)): %
Read only issue with Windows XP Service Pack 2
Implement a progress bar when the macro run inside another workboo
Vartype, range uninitialized ? Feb2010
Compressed seq data, again. I want to pay to make it work.
#Value in FormulaArray
Display value of a VBA variable inside a cell
Macro code to clipboard
Breaking User Form Code into modules question
How do you add data entry grid to a form(UserForm) in Excel 2003?
Call oNet.MapNetworkDrive(sDrive, myFolder, True) no longer workin
Compress seq data from txt-file into 15 min chunks in another file?
HELP: Populate Excel FORM from Access - Pull from multiple rows
Combine columns from seperate sheets into new sheet- macro improve
formula to place real time in a cell when data entered in an adjacent cell
Generating random numbers from a given range
An alternative to Target.EntireRow
Copying recordset multiple times using copyfromrecordset
Detecting an orphaned Excel.Application
Uer Form Window resizing according to Monitor
Cursor color
How do I highlight certain results in an excel formula?
setting defaults for multiselect listboxes
Calendar Form Update
Right icw getfromclipboard
cell content change so...
macro triggered by changes to cell only works if i run it twice
Format time to hh:mm? and 24h?
Excel - Auto update of daily web data into excel
stop numbers auto rounding
Grouping dates in Microsoft Query
Create a macro to re-create a format?
Typemismatch when duplicating graph
can we copy the code from the addin to excel workbook
how can we embed the code to the excel workbook from addin
Hiding and unhiding rows
Adjust data range without opening multiple excel files
Help with this macro script on single results.
Option Box on user from to update workbook
Dynamic range w/in formula in macro
Page Format lost while saving to html
file chooser
Macro to delete rows
How do I find the currently selected Scenario?
How to load page with specific date?
Conditional formatting code that looks up a list of criteria
Can Sharing Workbook Corrupt Sheet Password?
Can Sharing Workbook Corrupt Sheet Password?
Locked cells
Bypassing password protection in Visual Basic
BILLING ON EXCEL
Counting blank cell issue
vba project explorer
Getting FileSystem Date
HELP PLEASE: populate form fields from multiple access tables
HELP PLEASE: populate form fields from multiple access tables
Hide Message Bar
No print settings in Excel HTML files
Adding hyperlink to access database from excel
Run Sub automatically on periodic basis
Simple Array
sql to database
Strip records from large textfile with VBA
how to get address of source of copy (range with marquee a.k.a. "marching ants")
Constants
Excel prompts for VBA password when opening
Computationbs on Duplicate Entries
Going back to the start of a string
Error 58, file already exists - why?
User Form Display Question
Excel Object Not releasing from Task Manager (Vb.net)
Outlook private calendar
how do I display last two digits of a SSN in a separate column
deleting rows automatically using a maco or vba
color pivot area
Run Time error 1004 - Pastespecial method of range class failed.
Hide worksheet when moving back to another sheet
Conclude new account number
white screen
Repost with correction on turn report data into list
Updating Check Boxes in User Form does not change worksheet
How to turn report data into a list
User authentication/protection
Code to change part of a formula across worksheets
hide colum based on cell value on each worksheets
Automatically hide unused columns
Sharing workbook removes cell protection
looping through text files in a folder
Worksheet change when creating new sheet
eliminating unwanted data
Saving values from Multi-select List Box
how do I create a macro to select all colored cells in a worksheet
Re: collection obj
Password Protection set for all worksheets
Macro that adds all numbers that have formulas
Code and Creation 09256
Advanced transpose/grouping question
collection obj
Macro to "separate" entries in a field?
Data Validation
short circuit for next; continue?
Sheet that never closes
How to load specific range of data from html into excel?
Check Box Question
Making Plug-In Macros Visible for Custom QAT Access
Copying Sheets to a woekbook
Hide Row If Any Cell In It = 0
Data range in Array worksheets
multiple cells text to text in one cell
SumProduct in VBA - Allow the user to select the file
Array Question
Prevent Coloumn & Row Deletion / Insertion
How to modify specific lines in a .ini file?
Excel save takes 18 times longer than Windows Explorer copy - why?Options
CHM documentation downloads
Pretty indent reformatter
Need some help with Excel 2003..?
Dialog Box Buttons
How to insert row after data from user form
FormatConditions
Unable to set the Text Property of the Characters class
copy/paste in the next column
Macro That doesn't work - Please help
Two completely unrelated workbood. Why is it asking me about updatinglinks? SOLVED!
Validation error
Please HLEP: whats wrong with my code!? Adding textbox as runtime
HELP: Add textbox to a frame at run time
Using a range object inside a formula
VLOOKUP - help
Macro to match 2 column values in different sheets
SET UP FORMULAS AND CODE TO WORK WHEREVER WKB IS USED
Move and delete files
Cell Interior Color
Help with code
Macro to append number to file name
Dialog for selecting range within subroutine
Adding textboxes based on what user inputs in Total Students textb
Programming a button to add a row
VB.net select column and format
EXTRACT FULL NAME
How to sort number follow cell accordingly
Tracking updates
Formatting within this macro
Cannot run the macro 'XXX'
Excel 2010 Object Model
inability to apply formulas
Import image as binary data to a cell
Sort.Orientation Query correctness of me or Library document
Deleting Auto_Shapes
Suppress warning message
Counting selected cells
Removing filters from data
Disable cut/copy of shape and images in excel 2007
Adjustable print range
Macro to open and close addins
Alternative to Workbook_Open()????
excel 2010 symbol files PDB
minimize workbooks in macro
Considering cells colored via conditional formatting
single user form with multiple worksheets
Redirect Selection in Cell to Print Job
Programming a macro in Excel Office 2007 to create Pivot Table
routing slip in Excel 2007
Loading PivotCache directly from a text file
Copy Range of Cells to Outlook
USING IsNull Function in PivotTable
File Name and Full Path Name