Excel Programming [Archive] - Page 3

correct syntax for LEFT in vba
Subtract all individual elements of two matrix
Excel 2003 file gets 25% bigger after changing TP source with VBA
Batch Pivot Table update
The Best IT Certification Material
Userform to Select what worksheets to print
VBA formula update?
Set Folder path for entire module
Re: Compare textwidth with cellwidth in Excel?
Please help! Cannot open pivotTable source file....
Playing back a Pivot Table macros
group filtering
Copying specific rows to another sheet
Macro to print specified range of several work sheets
Problem in adding macro to ribbon through Add-in
How to create multi chart beside the data?
Compare 2 excel sheets -Error Checking of entered names
Re: Code Improvements
Need help with a complicated macro (code change)
[HELP] Download images from a list of urls (in excel sheet) to my local disk
Macro for subtotal movement
forcing specific sheet opening upon launch of .xlsx file
Getting Excel Find to Default to Searching Workbook not Sheet
Check a range to see if a value exists in it
Importing multiple text files and getting certain figures.
Find last weekday of the month with vba for all months
Retrieving a range of values from a closed file
How do I find what is in a spreadsheet
How to assign a worksheet in VBA
Go back to last step in programming
How to force macros refer to ActiveWorkbook
Find Text using VBA
DIM in VBA
Open workbook(s) using VBA
Excel VBA Macro Training in Chennai
Advanced Excel Training in Chennai
Excel VBA Macro Training
How to call Excel add-in macro from a button…
When something in module is shown as a macro
Loop through cells to find a string and copy/paste the matching column to a new wkbk
Unhide sheet
CommRead data with unknown length
Re: Unexepected error (40230)
Customize Quick Access Toolbar
How to split an excel workbook in code and data
Help on Code Snippet Error {Val function}
Type Mismatch Error on IF conditional
Coding Equivalent of CRL-A?
Help me5
Help me4
Help me3
ListBox Item Row Number
Another question 2
Function Pointer in VBA.
Sending mail with CDO through a remote SMTP server
Quickly count used rows?
Mid-Month function help
Help me2
Run-time error when copying entire row!
Double Fields Lookup Issue
Re: anyone interested in part-time job on excel vba programming(fo rMalaysian in Klang Valley only!!!)
Re: anyone interested in part-time job on excel vba programming(fo rMalaysian in Klang Valley only!!!)
Macro to hide cols
VBA quick print function?
Re: Macro for converting Excel list to QIF?
is there a macro that I can use to prepare bank rec?
Excel as a sign in sheet
Excel as a one step time clock
Linked pictures to cell dropdown
Automatically save as pdf but include location
Cell format crosstalk
Find file in folder and sub-folder and sub-folder and sub-folderand etc...
Disable the sort commands in autofilter (Excel 2010)
Help me 1
Undesirable sorting behavior
Convert config file, copy to new sheet while making some changes, may include variabl
Pivot Table Question
Another Time Related Question
Time Function
Another question
Help me
Something like vLookup for duplicate values on other tab
Extract data from XML file and populate them into cells
Re: separate questions and answers of a test
countif - unique values only
Run time error specifying range for sort code vba excel 2010
right answer has value 1,wrong answer has value 0
populate cells using select case
Macro to update pivot table data range
FFT in a macro
Chart Question
Trying to work smarter, not harder
switch to another worksheet, then return to original sheet
VBA - Hyperlink Function Combined with Find
calculate(f9) event at workbook level?
Copy files from website?
Language version of Excel?
How to dynamically change the list in drop down list based on thevalue of another cell?
IF function and Drop down list UPDATE
Remove duplicates in one column within a range of dates in another column
If Functions For Dyanmic Drop List
Iteration Macro
from to 3 rows to 12 rows (please macro or formula)
Userform dropdown doesn't go away
Column heads on second row
Command button to create folder
Time Calculations Help
Code snippet works but is a bit 'clumbsy'
Trying to create a list of prices from a web page
i want to add footer in all sheets wen i save and close any workbook
adding footer to all existing sheets in workbook and also to newsheets which is added
placement of shape (image) in bottom right corner of viewport
Change ribbon labels by VBA?
PDF the Excel Report
Marco is not working
Listbox search question
Hyperlink in Excel 2000
Autofill Dynamic Range of Cells
Help with Nested IF Then statement?
Disable Cut/Copy/Paste in Excel 2010
Chart title: Text and Formula together? VBA
macro to run in event of cell value <>""
Send Workbook as an Attachment Via Gmail - Code Review
passing a non numeric cell for numeric comparison
Auto Row Height Protected Template
Using START, CALL etc commands in Shell gives me error "Run TimeError 53; File Not Found".
Please help with code
Baler Software
comparing strings
Sort a range of strings using VBA code?
Right-mouse open a 2nd file to a particular sheet that correspondswith a 1st file's sheet
Offset indeterminate amount
Macro for Append to csv
run vbs from vba Syntax
value input on 1 ws, find on another, put date in
Checking limit values from separate xls file
Simple Copy Paste within Worksheet Change Event
data object / text box integration
sumif wildcard for text and numbers
ThisWorkbook.Saved = True
Lookup formula needed
Create survey
html hyperlinks using sub address
Need a little help with a custom function
Help with a text box option
Enlarge a linked window using VBA
Highlight Selected Range Only
Display selected cell at bottom of screen
how to use Solver in Excel VBA
How to create macro to change value in CSV.
If statement with "OR"
Optional arguments
Parsing
Random Generator in Excel?
Detect outgoing (POP3) server
brain fart, need help
Server side permissions for SaveAs
Open Google Map and enter a street address retrieved from a cell
Sum Function When Formula Produces #N/A
A Huge Conditional Format Challenge....
Protecting worksheet.
Run time error Method 'Range' of Object '_Worksheet' Failed
Count IF/And
Excel Macro help to merge multiple files
Function not working on one machine
Conditional formatting
Macro to C&P from all Sheets
Using While Wend with Cells.Find
Error 400 in VB editor
Using filters for a scheduling worksheet
VBA "Find" with multiple criterion
Reference workbook with a certain word in the name
Consuming json web services with Excel VBA
Good code, need one more step
Macro Creating Auto Separation of Numbers thru Defining Delimiter
Custom ribbons dissapear when saving?!?
How to make macros work in both XL2003 and XL2010?!?
Printing preselected pages in Excel 2003
Combining Multilple Worksheets Into One
Sumproduct & VBA
Code not working
Make [ENTER] always go to Column B of the Next Line
Odd behaviour with a userform
Print contents of sub folders
Can you help me use VBA to stack data in Excel 2007?
I want to take select cells from other rows (2 and 3) and combinethem with row 1
Budget remaining
stock maintance
build a name selector on a rota with the location showing against that persons name
Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys.
Protect documents properties?
VBA filter and sorting
VBA Filter?
Insert picture in defined range from reference in database
SUMPRODUCT anomoly
2012 Excel Modeling World Championships (New York)
Variable Defined as Double is entered in cell with only 2 decimal places
Simple Copy to and From Cells With IF statement.
convert spreadsheet formula into VBA formula
peculiar condition: form optionbuttons lose position and linkedcellon row hide
form optionbuttons lose position and linkedcell on row hide
Print title
User Input to Generate ListBox Range
Excel Macro - Find Activecell.value
Multiple Dynamic Named Ranges across Columns
Impoting excel sheet to new workbook
Autofilter problem
Unexpected file change
How to paste chart format in vba excel2010
need VBA macro for printing multiple print ranges
JESUS IS LORD!
Err50289 Dynamic Ribbon in Protected Project
embedding pw's to master sheet & auto update w/out pw's
Various ways and inconsistencies of deleting cells in sheets
I'm getting unwanted rounding to integer for an average of range of cells.
Macro to delete rows with offsetting values - Accounting
Mail a different file(s) to each person in a range
Easy Problem b/c I am not an Excel Expert
writing a value to a particular cell from function
Adding Multiple images in in an email body
Excel 2007 Access the Content Created File property in vba
creating multiple charts at each change in variable
Excel 2010 record macro default save to thisworkbook
Cell Count Between Value
Would like to create customized named range
Open File Dialog and store opened file as variable
Excel 2007, Unable to save new VB code
Page Breaks in VBA Q
Need help with please..
Macro to send email 5 days before a date mentioned in Cell
Send email to a email address 7 days before the due date
External Data from Web
Excel for comparing two columns exceeding 1,048,576 count
From Excel to user form
check box
text box 1000's Separators
List 6-of-36 combinations matching 4 (errata)
Open all image file in a folder and insert into cell in excel
Using IE from VBA - Permission Denied
Capturing BottomRightCell in a Variable
VB to insert duplicate rows based on value in other row
Please help! with find/copy/replace
Accurate Detection of Graphic Area of Shape Object
Macro to copy rows into worksheets
Filtering/Excluding Values
VBA macro Trignometry function
Null Parameter
Hotkey in proper workbook
Iterating through each label on a worksheet
Copy range from multiple files in multiple folders to single sheet in master WB
import text
Excel v2010 compress picture
Using =Offset in Charts
Copy columns by Header and select all data (non-contiguous) from those columns
Macro to search for a value and insert new row
using xltm as template
Lock Row (A~F) based on criteria in g
alternate rowshading using conditional format excel 2007/2010
Copy filtered data to sheet 2
use content of a cell as an input for a google query and return the URL of the 1st re
How to retrieve number of visible digits after decimal point in VBA
Need to auto-enter last updated date, only if another cell has changed
List all combinations of 6/36 with unique 4 numbers
Save record Into master sheet!
Defining public/global variables in more than one place
Search macro for greater than 100000 on multiple CSV files
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria
VBA to find largest total of ANY two values
lock cell
Complex problem probably easy answer
Easy code, confounded by error
Extract filtered data
Data extract after applying a filter
drop down list
Basic Excel Marcos Help
VBA Coding Trick
capture date at another sheets using Marlett
Click on userform transfers to lisbox below
Excel 2010 Pivot Table
RTD server : Updatenotify does not return and Excel not calling refreshData method
Basic Row Delete Marco
VBA task: Copy selection in Word and paste in Excel
closing another file by code causes failure to run workbook activate event
Excel -> Word (Textbox Find/Replace)
Delete duplicate rows without deleting entire row
Word document reporting
Command line used for opening .xls files and clicking abutton/running a function.
user form error
Data Validation Link to Color Coating
Too negative XIRR?
Controlling auto-filter with VBA
Create new sheet based on cell value
Automatic Email using details from Excel
macro migration from XP to windows7
auto added checkbox
UDF not working for VLookup
Cant see worksheet tabs in a workbook
Another rascally VBA SUMPRODUCT issue
Select and copy only cells with values, open an app, paste into
NOW I'm puzzled???
Excel Macro Copy cells and pastes them in another sheet
hide progress bar when using ExportAsFixedFormat for printing to PDF
How to adjust or resize a range?
To be got Alphabetic
Formula help, please.
Troublesome tester- Is clicking top left select all...how to codetrap this?
Setting reminders in Excel
Moving Amounts to Another Workbook Based on 2 Conditions - Date/Employee
Getting a Grand Total in Grand Total field only
Preventative Maintenance
Macro Loop
Macro to delete entire rows where certain range of cells are blank
How to replace cell value based on other cell's value using macro
Selecting Date Range in a Pivot using VBA
Best Dashboard Software
New topic from discussion "Align cells with same value - vba almostworking" in this group
Macro to download house prices from web
Changing a csv file opened as hidden workbook
Problem creating a set of .csv files from coinciding worksheets
save and exit macro
Copy colored cell to a second page
Column of email addresses: how to just use the part before the "@"
Column full of email addresses: how to truncate to just part of eachemail address (before the "@")
Changing Column Width Temporarily
Non VB Help -
How to set focus on an ActiveX ListBox
Add background watermark to cells?
Comparing a cell value with a range in a table and displaying a response
Enumerate all subfolders?
Limits of Substitute and Replace functions
Macro only goes to row 43
How to enumerate buttons on user form
How to count colour and content of fields?
Test for installed application?
Update MySQL database using Excel VBA
Macro to open all files in SharePoint Library
RAND function without duplicates?
Getting Debug Error
VB Macro for Pivot Filter Function
Nearest one or two or three numbers in a row of data
Correct process for creating a linear trend line in Excel
Pop-up comments?
Excel 2010 to auto-generate an email to recipients in outlook 2010
Protection not allowing Validation
Protection not allowing Validation
Creating Survey Using MS Excel
Creating sheets with pasted colour-marked rows through a nifty macro command, please
Using VBA to change Crystal Reports settings from Oracle to SQL
"Run-time error '1004'
Excel 2003 Runtime error 40036
cannot insert row in vba
Z score on existing data
Can't find project or liabrary
Auto download of Excel files in emails
Macro deleting rows based in main sheet on values in another sheet
help with csv file
Help to show formula instead of value in a VBA code
How to change Pivot Table external data source (MS Access Database)by VBA
Path windows in VBA Excel
Workbook reminder
insert space in cells
Paste Value
Macro to find/replace cells containing a number and letter
help with code
Excel Macro VBA to Count Google Search Results
Advice on creating custom excel program
Extracting a Part of a Formula as Text
create a formula to know last months column character or number
Macro for checking data in a cell against another cell andcopying/pasting data
Reply to thread 'Syntax error on looping through each cell
Using ActiveCell.Value Yields Circular Reference
How to copy selected column to another page under a specifik field?
VBA code To Merge All .csv files into a single excel sheet (data start from row 11th)
Stubborn array wont change destination worksheet - HELP! (reposteddue to incorrect formatting)
Array to specific worksheet - nothing seems to work
Array to specific worksheet - nothing seems to work
Summarize information on different sheets of the workbook
Excel VBA macro to auto import new CSV file from fixed directory
Inserting variable into code
Copying a Range from Multiple Worksheets
Read into array and sort?
Error with Date Picker
how to write two criteria in if statement?
Creating a list in Excel for a matching criteria
Display formulae as values of each cell reference
Time averaging raw data
Update cell links between 2 excel file without opening source file
Can Excel talk to a back end?
Making a field compulsary before user leaves sheet
Put Formula in VBA
Remove Spaces
Conditional Formatting in VB
Flat Trend Line
Flat Trend Line
The size of the ActiveX ListBox control shrinks
Splash screen not working in hidden workbook
vba in excel 2007
MACRO Effeciency
Populating worksheet based on multiple worksheets
Delete rows autofilter range problem
Take active cell value in for loop and offset based on another cellvalue for columns to offset
Macro or filter to extract/delete data on value match
Opening an Excel File
fill in blank cell
Open an Excel file each time the computer is booted
dynamic adding
dynamic row
using the SUMIF function
How do i auto fill cell color based on other cells' color?
Linking charts as picture
Forecast Daily Usage
Sort in hidden page crach
Exporting selected textboxes to another powerpoint presentation
Excel 2010 large file size
Compile Error:Variable not defined
merge Spanish and English dictionaries into custom dictionary, possible?
Scheduled print of a excel doc that is always open
Problems with setting .Values with vba
Parsing an excel doc to find max values
Print Value from Inputbox
Conditional Pop-Up message in excel
Conditional Pop-Up message in excel
Find Date cell using Calendar Control
Help writing formula for investing spreadsheet
Find and Replace
Number Of Cells Between Colored Cells?
is there a way to control the sheet name you add
Application.Match Ignore Character
Date Format - simple question
Beginner - Click a checkbox then calculation to be done automatically
How to write a VBA program to load the webpages automatically
Vertical line on Excel chart
Re: LoadPicture workaround for Excel 2011 VBA for Mac
Calculating occupational sick pay entitlement
Create COM add-in using VBA
Calculating Fill Rate Percentage
naming ranges in Excel2007 using VBA
Excel SQL VBA Command Reference.
Custom function for vlookup
macro
Increment Cell Value +1 with a macro
Re: Formulas that update other formula columns?
Seperating Information In an Excel Sheet
Problem with relative reference.
Automatically Combine Cell Contents and Delete Rows
VBA-copy all worksheets except three specific ones
A simple printing pages depending on cell value
including macro in protected worksheet
Ensuring Combobox has Value entered if another ComboBox has aspecific value
Easy answers for anyone
Range With Variables
Saving in VBA to a particular location
QueryTables, some basic questions
If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet
hide rows in workbook
VBA find
Number displayed as text difficulties
Help with macro lsit
Determine name of macro contained in each excel file in a folder
VBA loop to create named .csv files for all worksheets and workbooks in a folder
manipulating drawing objects in MS Office 2007
64-bit ADODB in Excel
Add incremental character to cell value at change in value 449becomes 449-A 510 becomes 510-B
Printing to pdf
Use of constant instead of variable in VBA Solver
Excel Form
Macro required
Programming the VBE options?
Copy data from one workbook to another workbook at the next available row
Combining THREE columns to a new TAB
Find name of 'My computer'?
Why do charts disappear?
Code to delete names works in one WB, but not another WB?
Delete range names within a selection
Row and column count last occupied cells in range
list box item select
How to return the machine name?
UserForm Image
Help to get data from excel 2003 worksheet into Visual Basic 6
macro to show / hide grouping, linked to label button
How to arrange columns
Workbooks.Open always have
Enter data in cell referenced in a cell
UpperCase changes date format
paste if columns and rows are the same
Save PERSONAL.xls into Excel 2007 PERSONAL.xlsm
Finding and Replacing Sheet Names
Transport macro
Problem with If formula and concatenate "&"
Convert text to values
Conditional Formatting in Excel 2010 is being removed when I emailExcel Workbook
Macro to send an email automatically
Macro code to reference a cell for a date parameter when pulling data
Gather Data from Multiple Sheets
Find, Copy files and Paste in new destination
Can a excel macro be run from a .vbs file
TrimTextRange
conditionally format based on intersheet cell comparisons
searchbox in excel sheet
Save as (filename,fileformat) from Word VBA will not work
Stock expiry projection - Help-
Stock expiry projection
Have Excel 2007. I would like to have a spreadsheet perform thefollowing simple? tasks
conditional formating in adjacent cells
Link certain cells to 2 photos each
Count occurances in a range.
Ms Excel 2010 problem with coping
VBA help please
Functions - visibility
Invalid name?!?
Cell colour change for a set time period
how to use a variable in this line
VBA.Interaction.Shell ("msg.exe") = Run-time error '53': File Not found
"Errored" Cells in Data
Extract each line of text from a textbox into an array
Run time error
set/get value of checkbox (controltoolbox)
Using Excel 2007 with Excel 2003 template
Todays date minus 1
Writing code to objects within MultiPage object
Extracting text from Alphanumeric Cell
Delete Rows in A column not Containing multiple text criteria
inventory problem
Identify adjacency cells with same value
easiest way to find next non blank row
Linking cells, with values and formats: VBA
Calculating a countif with sumproduct + Date
XLL ('C' extension) question
How to send a private mesage to site administrator
Generating Buy/Sell signals accordingly...
Connecting Excel with another GUI Interface
Please translate the following formula in VBA
Ghost excel process
can I use IF statement to call a VBA function ?
excel if condition or vba
ThisWorkbook.Unprotect ("password") depends on Service Pack??
Dynamically Adding Labels to a Userform
Insert Value into cell automatically when new rows are created/inserted
Cell Required before Closing
Delete 1st character if string is longer than 6 characters
Copy item from Outlook to folder via Excel
formula or macro in excel, to open another excel sheet?
add a chart in a Add-In
Changing pivot table ADO recordset
Reference Separate Sheet for Formula
Help with Evaluate/Eval
Status bar in Excel 2010
count duplicates
Email validation?
Select Picture from Data validation dropdown menu
ReturnBoolean???
Do not undesratnd the error when calling EXcel macro from .vbs script
working on another excel sheet with an excel macro running
Help with VBA Macro needed
Returning two similar values from two different columns
Data Validation
append multiple worksheets data into a single multi-dimensional array
how to study for a microsoft certification exam, a microsoftcertification testing locations
Launching form blocks cell selection
Status Bar text
corrupt file plus 8 digit temp
temp 8 digit file, original corrupt
Re: Web page on the fly
Creating a Macro
Excel formula for counting nr records with data and related empty fields
FSO copy file returns permission denied
Move rows to another worksheet with vba
copy paste problem
[Excel 2010] how to get a horizontal scroll bar form control
[Excel 2010] fails to record macro for Custom Error Bars
Re: Add checkboxes programaticly
Track Changes Question
how to program a cell
Macro - Delete Rows with specific text
VBA code for Locking Cell disabling Drop Down Validation Lists
VBA Help
Tab character in a Text Box
How to add a calendar object to Excel 2010?
Creating a formula in VBA with quoted strings
Sorting Columns with a Formula
How to Select A Cell in VBA with a Variable Row Number?
How to Select A Cell in VBA with a Variable Row Number?
Re: freezepane set macro
How to Activate Filter in Protected Sheet
Macro shortcuts are running macros in different open workbook
LOGEST,LINEST,?POWEST
Radical color chages on importing a worksheet (Excel 2010)?
Combobox selection
How do you chart data from multiple sheets within a workbook?
How to chart data from multiple sheets in Workbook
How to match and compare multi-columns datas
How do I copy several rows from one sheet to another?
Lookup a value between 2 dates
Create formulas using multiple pop-up input boxes?
Lookup beween 2 dates
How write into text file at first and last line with excel vba?
How to activate Sheet2?
Lookup a price that was valid at a certain date
Excel and the Math Coprocessor for DLLs
Excel chart, set a vertical baseline on a certain date
producing a list from a programme
show formulas
Combobox Population
how to design spreadsheets to collect data and display the totalmaterial used in a plating department
philosophical question about programming best practices
ActiveSheet in formula
comment on "NEW" google group layout
Application.Selection.Name gives "=Sheet3!$A$1"; I want the name
Big dataset - batch process
concatenate a range of data
Ribbon issue 2010
Rows right click menu?
Array of Controls??
Excel is messing with the math coprocessor
excel 2010 classic look no ribbon
Sumif similar to Countif??
selecting a range
Excel 2010 Windows.Activate name issue
Need to find a static value in a cell and then subtract from adjacent cell
Use external file variable in formula
Creating a defined name's Refersto range
Application.Rows
RAND() function error? ##
help with generating a percentage value
Select random records by two conditions
Loop from left to the right
checking data in the A column
Re: Copying a Name's Contents
help with VBA
Macro edit to add before contents to the new row
Macro For Saving Worksheet to Word Document with A1 as filename
Formula in VBA
VBA-User says active cell jumps to a different sheet upon Save. Please review my code
VBA - function doesn't calculate unless clicked on
Auto add if condition is met
For Each Next
Survey Form as a Project
Dim problems
How to append data to existing workbook's sheet and don't create a new workbook
stacked bar chart - problem adjusting bar width - Excel 2007
Broken hyperlinks in excel 2007
Conditional formatting
Conditional formatting
Gather multiple keyword and separate them to categories
Conditional Formatting and VBA
Application.ScreenUpdating
Pivot Tables - Filtering on summed values
Assembling large "array"
Populating a range of empty cells with usernames
Change SourceName on Pivot Table
vba to copy data from sale receipt to next available column in an inventory worksheet
Web Query not coming up right
iserror function
Strange behaviour
VBA - Insert row, copy contents of original row except for contents of columns A-N
HTML string not formatting when copied into sheet
how to find a last value in a column in excel
Row Count...
VBA - Insert row, copy contents of original row except for contents of column A
Lose macros before saving
searching for text within shapes
Need subtotals
Need subtotals
Email individual sheets from an excel file
disable shortcut key sheet tab
macro for sheet hide
lock keyborad & mouse
Don't want to hard-code file name in macro
macro hide
**BARCELONA** R4 DS CARTUCHOS ** www.cartuchos3ds.info
Formula or code?
Formula or VB?
Excel formula to count the number of records which contains a certaintext (wildcard)
Get name of user who has a file open or checked out from a Sharepoint
restriction for delete or change in cell
select picture with list
macro eable or disable
Macro for solver on certain worksheets
How do I choose the rows that are filtered ?
1st macro run then 2 macro is run
macro to select worksheet
Macro needs updated Range name addresses
Cell Selection Control
Excel 2003 VBA help problem
Application.top=0 fails
Macro to add comments from cell values
A little help needed please...
How to Copy excel formulas from one excel to other
Problem with FTP commands in Win7+Excel2010 (VBA)
Conditional formatting with vba
Pivot table drill down sort
Handling hhmmss time format
Problem with UserForm1.Show
VBA password prompt workaround
Need warning message before a user changes worksheet
Excel Graphs : Images in X-Axis
create chart with column axis
Retrieve NTFS security groups from network folder
Send mail VBA
Send mail VBA
Exporting data with vba from Excel to an Access 2007 db with password
macro for right click
when sheet is active macro is run
Calculating subtotals
Calculating subtotals
Problems with If function
This could sure help my kids
Hiding a column if a cell has an X
Date reference to another cell
Macro to search a text in a cell and copy the row to another set of cell
VBA Conditional formating for specific text in several columns
Remove data from column
assigning a variable from an image alt text
Rename 'VBAProject"
password for macro
Pivot Table Macro with dynamic source data
Excel Template Question...
Chart Title color can't be duplicated (also series color)
Excel macro for general insurance tracking
Check each sheet for Auto-filtering and switch it off
Need help with a simple macro, really lost.
Identifying Machine or Location When a Procedure is Run
How to convert text file into excel using macro vba
Enable Slicer Data Refresh in Locked S/S
Re: Separating fields
hide menu bar
active range to run macro
Converting macros from Excel 2003 to Excel 2010 - Client Access dialog
FileSystemObject
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names
Only cells with values
active cell to run macro
Capture Web Page Source Code
Where are all you MVPs hanging out now??? Pls?
range names
How To Make Pictures Scrol in Text Frame
Excel module: Mark records if it contains names out of another list
data labels in excel using vba
How to export excel sheet to CSV
How to append data from different sheet and different workbook?
Re: Problems with Activeworkbook.Close
Can't delete sheets
Re: Determine the percentage of a range of cells with a certain value
Re: Separating fields
Re: Copy data from a cell to the next available cell in a range.
Re: Determine the percentage of a range of cells with a certain value
Print data from Excel in a Word Template via FTP
Hidden sheet bleeds through
adding vlookup into Macro and table_array is different every week.
Conversion from Number to Word!! Aki
Move multiple values in single Cell To Cells of there own?
Scrolling few Pictures at a time in a Frame
forwards/backward compatibility Excel 2003-2007
select worksheet and run macro
UDF: More than one input type?
excel 2003 vs 2007 menu and sheet issues
Passing SQLPlus script location using Windows Script Host Object Model
Application.Wait
FIND ALL
Create Table with the range of selected cells
Arrays and Checkboxes
Shared folder changed path - sometimes S://SharedFolder sometimes T://SharedFolder
Open folder based on cell value
run macro on close
Blank item in listbox, how to remove
Faster way to find and replace?
copy and paste data only to a new file
Formula in other Other Language
Add to Dynamic Named Range
VB.Net ToString Number Format
Conditional formatting excluding weekends and holidays
Macros for Consolidating data in worksheet 1 on worksheet 2
Addin not allowing thisworkbook.save in before save event
Highlight or Mark any values in a column that are duplicates insidethe column
Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...
Filter ZIP codes into ranges
Pivot table code question
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook
Would love to write macro to delete any row that DOESN'T containspecific text..
Re: Properly Saving a .CSV File With an 11 Digit Numeric Field
Sorting columns of data
[Q] For, Next - How to Speed Up
Inserting subtotals very slow
Buttons not always moving deleting rows. Odd behavior
Macro format selection
excel spreadsheet functions written in vba
Error: Method 'open' of object 'IXMLHTTPRequest' failed
3 results possible on every day. add up the number of each on each day.
Advance Filter Format
User Defined Function
Copy Matching Numbers To New Cell's
Populating a listbox from an excel column
Aligning related data
how to work with all items in a listbox
How to create a table of multiple combination
=Sumproduct Question
Sorting Question
Combine Two Different Worksheet_Change codes
New line vs line break
Hiding an Excel file using VBA
how to export pat_ids to another programme?
Hide/shows raw based on drop down menue
excel 2010 statistical functions
Excel question
initiate a macro
vlookup issue
Managing Cut/Copy & Paste During Program Run
Newline character in XML cell reference when creating xlsx from XMLzipped files
Function for combinations
Using median if in VBA. Excel. 3 conditions stop running?
Help adding a condition to a print code
Find matches in 2 cols using Collection vs Dictionary
Variable Range, selecting/copying
User defined function
=Trend question
Which Excel event to call when opening a .txt file
Sumproduct Problem
How to bypass password when pasting FROM a protected workbook
'.Copy Destination:=' temporarily freezes multiple instances in Excel 2010
Issue with TextFrame2: Library not found
Delete matching cells
Two digit dates and two digit days
Macro to copy to application
Is it possible to add variables to a pivot datafield name?
Need help with merging Excel worksheets and deleting unwanted columns
Loop & Print
Replacing a hardcoded date
How to pause without being "modal"
Changing mutiple data fields at the same time
[Q] How to create new worksheets based on an array (via named range)
Duplicate declaration in scope
Is it possible to just act on the filtered data
Fade text in a cell, disappeared when we input new text.
Find then highlight in yellow
Data validation trouble
Technique for switching to the VBE
Search function in Excel
Copy sum of two columns from one workbook to one column in another
Filling in some blanks to a data table
Looping through checkboxes
Removing Sequential Numbers
My code need to go on a diet
Get Data set range from closed workbook
Error bar format
Trying to create a mailing list using a combination of data and anaddress list.
Sumproduct with double quoted strings
Reuse old selfcerts (self certificates)?
Transfer selfcerts to new machine?
Extract Records via Userform
List of Direct and Indirect Reports
[Q] How to sort tabs in order of CodeName
setting folders in odc file
Loop has goofy message all of a sudden
Functions not firing!
Re: Ask before auto increment.
Wrong import values from webquerry
Seaching an excel sheet
Duplicate Digits
NFL spreadsheet
Counting rows
Counting rows
Can I send an email too?
move cells up
Copy data - Multiple Word Pages to Excel
manipulate other program using excel macro
Enhancing Explorer Excel Open Icon limitation
Distributed excel apps with add-ins
Break points will be ignored in Excel
MAX and Min value
MOVE CELLS DOWN
=TEXT fuction
Retrieve data from encrypted Access
Excel automation fail
Calendar Control for All Office versions - including Office 2010 64 bit
CheckOut/CheckIn from/to SharePoint 2010
Multiple (as in many) regressions
Copy specific cells to another tab
End of Quarter Based on Fiscal Year
Replace "A2" with Active cell
row height
ADOBE Connection to open Excel workbook
Closing programs on remote PC - help please
Compare Sheets
Early binding problem
Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse clicked
Worksheet not updating when execute mytxt.value line in VBA
Re: Screen Updating/Flickering
Find the row for a Hyperlink
toggle between method and source of inputs
Compiling and Late Binding
find newest file in all sub folders
Macro help please
Removing Duplicates from NameBox Table Using VBA
Two-tone color column chart
Screen Updating
copy my digital certificates?
Random selection of records based on specifc value
how to automatic adding up 12 rows for one year, and 48 rows for therest of year
Sheet Order _ Numbering
2000 -> 2007: gotchas?
How to Insert Variables into Formula's
how to use stacked line with markers plot to draw point estimationand confidence interval
email from Excel Question for Ron de Bruin (or other really smart people)
use stock plot to draw point estimation with confidence interval
Attendance Tracker
Compiling Error in Earlier Version of Excel
Avoiding cells being included in a chart
Newby, ..Membercode
Opening workbooks and stopping the messages
Adjust Pivot Table Filter based on a Range
Re:Tidy VBA Code
how to add error bars into bar chart
Form Control versus Active Control? When to use which?
Failure to load icon causes UserForm to minimize to bogus object inworksheet area.
Help with specific textbox entry...
Help: Chart & data
VBA Linest function for polynomial regression on horizontal range
Making .dll files for Excel 2010
Value of True etc
Excel 2007 VBA: Convert laaaaarge number to Hex
Read .TXT file line by line?
use vba to open pdf then save as xml
How to Disable the Insert Worksheet tab at bottom of screen
Button to Save File as PDF
Add-in WITH worksheets??
UserForm - pointing control source to new sheet - long delay
Move cells down
Move cells down
Incrementing IPv6 address
Separating Workbooks
Check a 'Logsheet' for a match, before continuing a sub
cross referencing two worksheets
Don't re-run macro for five seconds...?
creating frame and option buttons programmatically
Is there a way to automtically apply macros in a script
How to apply a macro to all workbooks
Check for file open/closed status
Listbox displaying incorrectly on opening worksheet
formula to filter out blanks
Adding values across files
Variable SUM range
Using IRibbonUI in VBA Excel 2010
Reduce Numbers Down To A Specific Value
Refresh Bloomberg data in an excel file from a script
Can I use a variable contain the name of a sub or function to call it?
Calling a Sub created on the fly
Re: search cell
Move cells down
Thanks
search cell
Data in columns
userform exception error 4 textboxes
Tech help
Identify each cell that has dependents
How do I get VBA to make AND print a chart with a square grid
Average If Problem
VBA Code organizer
Impleted the following code
Duplicate name range error when copying sheet (Excel 2010)
Joning Community
Changing a cell from another cell's formula
Can an Excel 2010 file be shared on the cloud?
How to remove duplication in text string?
Loading pivot table problem
VBA Script useable by like workbooks
How to make rows autofit when cells merge and multi line text inside
Excel 2003 VBA string literal help location
XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet
Find last row and column for 1st page only
Lookup
loop to copy paste
microsoft office web components wizard in office 2010
How to Pause an Excel VBA script without freezing excel
hot to calculate peaks of an "irregular" sine wave
Variable Range Copy...
Compare font colors
Copy value
Finding range
Center application window
"Following Features Cannot be saved" error on LOADING ??
De-activating Excel 12, Leaving 11 Active?
Script to remove file clutter
Is ActiveSheet in ThisWorrkbook?
Upload files to a Share Point Site.
Can you create a global variable ?
Can you create a global variable ?
Dynamic links to other sheets
problem with finding horizontal page breaks
Change ActivePrinter in a Add-In
Excel 2010. How to copy chart format to all charts in sheet
Send mail automatically
VB Script not working in Excel 2010
setting one worksheet cell range reference to another worksheet
Checking if a workbook exists
Adding New Sheet, But Carrying Over Previous Sheet's Cell Calls
2 more questions on excel and vba
Cell value on top, inside drawing
How make long string in a cell become text line by line in same cell?
Sorting a string array containing combinations
copy a 2 dimensional array to a range