Excel Programming [Archive] - Page 4

Adding to Array
Default folder when saving a "Cute" PDF file
Iterating through a ComboBox's values
Tax Form with Merge and Center
VBA Code Writing to Excel Box Name
Is a signed certificate necessary to run macros in a marketed file?
does anyone have any idea how to import this spreadsheet?
MIN in VBA?
Merging 2 sheets.
Changing Cells depending on data entered in other cells
Adding a condition to VBA CountIF
Combobox date value matching
how to use VBA code to create 'Select Data Range' userform.
Autosum
Deleting Columns with VBA
Range Reference Problem
how to run a recorded macro in many files at a same time
Compatability Checker Question
Setting a .Range to equal another .Range
VBA's Q? Printing None-Zero Valye ONLY
halt macro execution, inspect progress and then resume execution
display list based on validation
ComboBox value matching
Formatting short times
VBIDE.Codemodule.addfromfile putting code in wrong place
Multi-Dimensional Array
LinEst using arrays
Insert columns and values programmatically with IF statement
Insert page break
How can I Lock a Link?
Microsoft Excel VBA Professional Projects
Error handling
Wait till pivot finishes refreshing
VBA Example of Using WHILE and LOOP?
macro to copy columns from one sheet to another sheet
Newbie help needed please...
Odd Export as PDF problem - Killing me.
C drive size
Copy Multiple Areas from One Workbook to Another
Delete characters from behind if too many
Ignoring a blank cell while running a macro.
Determining if a query is refreshing
UserForm doesn't show?
List all sheets in the work book and select by double click
Error '1004'
Pivot tables not refreshing after data source update
Check a Check Box with VB
How to print multiple sections from different worksheets
Mixed-font string both to cells and word document
Syntax in worksheet functions for individual values instead of ranges
Working out of Statistics on Exam Results URGENT solution needed!
VBA API for Outlook and Email managment
About data transfer using formulas
Replacing the formula text's substring
Lookup Formula Problem
Loop to hide sheet based on cell
URGENT help needed for a macro to place and size command button
Hiding Columns produces error <----HELP PLEASE
Macro to select, set, and print
HELP! Command buttons moving to edge of Worksheet when unhiding rowsand-or columns
Macro to upload file to http://
4 out of 35 data connections running high cpu/memory
Syntax question using :=
Paste to next free column
How to set range to autofiltered visible cells?
loop to copy paste
Pivot Table Refreshing
Looking for all the opinions about Self Certification for macro's
Chosen opton button
Vlookup error
Find and delete error value
Countdown 1 every workday
Cycling through collection
Out of resources error message - when not...
Deleting backslashs and everything after
VBA SaveAs function generates blank CSV file
Days between 2 dates excluding Sundays only
Put Name's Refer's to: field in cell
Open a GroupWise .NAB File
Sending mail from Excel with CDO by Ron de Bruin
Sending mail from Excel with CDO by Ron de Bruin
Declaring a local variable once for all subs
Not able select list value in HTML
Variable Data Type
Worksheet_Change - compare columns
Vlookup error
switching workbooks using variable and wilcard filename
Pivot Table Refreshing
FInding Data Connection Name
Programmatically setting pivot sourcedata
Delete rightmost zeroes
Finding right-most cell.
Copy cell value from one worksheet to matching worksheet in another workbook
Copy from Excel to Word
Extraction
Excel vs .csv?
Excel startup problem. Possible problem with stdole32.tlb
Open Word file with Excel VBA
count cells with diagonal borders
Find(SPELER, LookIn:=xlValues) problem with hidden colloms!!!
In Excel 2007, color for number format axis not working
Populate TextBox with other textbox value
REMOVING COLUMN FILTERS VIA VB CODE
add hyperlink without changing the cell formating
hope someone can help with excel save with 2003 and 2007 installed on my computer
How to write Left Function in VB
Combining Text based on Values
Reading Excel Table in VBA
Search for empty cells and move cells next to
shorten sheet name
Find and move cells with text
Text To Columns then insert rows
Code for RefersTo property
Deleting Toolbar
Deleting Toolbar
Macro to open file and copy information from worksheet
Excel 2003 - VBA Code Problem
formula for payment, time vs hourly price
Add data to a PDF file or form?
Excel 2010/2007 - How much can be done with Custom Validation?
month gaps counting through whole column
Wildcards in SumIF formula
Check font of a cell
Copying Cell Value AND Format into Email Body Macro
colors change in graphic
Global/Public/Universal variables
Use only cells with data in
Modifying a Defined Name's Contents
Alter internal margins of chart title using VBA, Excel 2010
execute .acsup script from VBA macro
Require entry in one cell if data in another
Filter based on cell contents.
Help bringing in hyperlink into Excel from Web
macro to a number + 1 to a cell
how do I link a constant or variable to form
Should I activate workbook before activating sheet when button is selected?
Automatically create ranges and then name them
Auto Detect Data, Auto Print Data, Auto Erase Data Loop
Draw line of defined length
calculating Sick pay entitlement
count cells with diagonal borders
List of items from other sheets
Keeping Conditional fromating When Emailing Using A Control Button
ListBox with 2 Columns
How to change a sheet name without opening the workbook
No program is registered to open this file
Efficient looping
Unique Random Numbers
Directional buttons
Storing Multiple Selected Pivot Table Report Filter Values
Include Layout name with filename when printing to PDF
how to determine duration of meal break in timesheet (working with times)
Controlling Page Break Preview
VBA to set the font size for the axes of a bar chart
Purging Excel's VM Usage
Important Union Intersect VBA Problems
Cannot recalculate
How to parse text in a cell
Looking For A Formula
Iterating through a ComboBox's values
Why does variant not need set?
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed
Comparing dates
Implement time-out
ChDir "F:\dump" - not working
Detecting when a process ends
Possible to refer to a sheet's object name ?
changing activesheet shapes label caption
Updating from Webpage
Can I use loops to enhance this code?
List of methods and/or properties
Wierd Formula Request
Obtaining list of all objects on worksheet
VBA: Read picture filename
Average of a column, excluding spaces?
XML and EXCEL 2003 standard edition.
Prevent Sending eMail from Excel
importing Access via code
Convert Objects to Pictures (or Shapes)
Need Java Developer w/ADABAS Location:FL
Need Java Developer w/ADABAS Location:FL
numeric value, vba to split out one digit per column
Forcing Excel to Import .CSV data
Spliting digits up to fit paper form
Alt-F8 and Excel 2010
VLookup a named range
Cannot display Add-in Macro list without going to VBA/Project
downloading from excel to google
Dynamic rowsource for ComboBox
VBA module for record data from datafeed
Importing several web pages with macro/VBA?
Excel/Financial Modelling freelancers needed
Excel 2011 for Mac tries to run a file when it starts up
Get CPU Priority of a ProcessID
How to create a variable selected range
Parsing Month WorkSheet (one row/Project) into Folder & SubFolders by Project
Sorting multi-dimensional array
Finding a Value Between Two Numbers and Returning Corresponding Value
Using VBA on Excel Pivot Tables
Enable macros
Macro to display Tabular View of Active Pivot Table
Save sheet bitmap to desktop?
No characters data in Hyperlink cell
VBA Go to Today's Date
Saying No to Message Box prompt through VBA
EXCEL 2010 VBA; trying to use INI File stored on local desktop machines
Macro to remove squares from cells
Large Dynamic Named Range Sort Problem
Excel 2003 - Save as dialog box
length of line depending on the value of the cell
Compare and highlight differences in 2 worksheets in same workbookand list differences in 3rd worksheet
only 1 time declaring variables
Error handling
scraping PDFs
Dynamic Creation of Arrays - Sorting into Bins problem
VB Marco Reverse Variant and paste into other sheet
VB Marco Reverse Variant and paste into other sheet
Function in a VBA prog. or something like that
Transfering Excel Tale into .csv Ones?
Change cell type
Run Macros
Creating an ARRAY UDF
Excel timesheet
Adding CustomUI Ribbon code using macro to new generated file
object library problem
Object libray invalid problem
ActiveX ComboBox Linked Cell
Userform Control validity check
General question on multidimensional variables
Excel 2010 Charting in Userform - Can't Access OWC11 Control from Toolbox??
EXCEL SQL.REQUEST of ACCESS DATA
Putting the series 1 and series 2 titles from a worksheet
Recode values
MINIF UDF
Improving Nested Formula Calculation Efficiency
Get ColorIndex from Character in String
How to maintain size of array: UniqRow
Macro Excel 2003
Combobox list based on choice in previous combobox
Combobox list based on choice in previous combobox
Combobox items based on choice in previous combobox
DSUM not unique records
How to best set this spreadsheet up
import data from a non existing datafile
Retrieve numbers that meet criteria
get column name by ADOX
Produce Random Numbers
Running macro operations in serial fashion
Test Message
Robust Excel addin installation through vba
Using code to edit spreadsheet formulas
Check a value every time excel is loaded
Runtime Error 1004 on Linest
Runtime Error 1004 on Linest in VBA
Runtime Error 1004
Runtime Error 1004
removing personal.xlsb file
Cannot save macro spreadsheet due to ReadOnly = True
Triggering auto_open
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook
Variable Name Changes in Loop Operation
Creating a UDF to search a cell's formula
Stubborn toolbar
When importing text field Excel chops off leading spaces
ByRef v ByVal
Delete named ranges in VBA - by scope?
Need : Application Developer - FoxPro Loc:William Street, NY
VBA Search worksheet, find text, change color of row
Excel consultant recs?
count shaded cells with a gradient fill
2007 Compatibility Checker states cells outside of range when saving2003 version
VBA code won't run, even with Macro Security set to Enable All Macors
SUMPRODUCT Error
Excel VBA assistance
Runtime Error 1004:Method 'Range' of object'_Worksheet' Failed
Task manager’s system CPU PercentProcessorTime
vsdvfs
Returning the name of a deleted cell style
Referencing a cell value in a macro
A way to count cells in a range containing text or formulas
Problem with ActiveWorkbook.Close command
Manpower Calendar Distribution, Skipping weekends.
How do you detect a Left click on a Worksheet
Help: Find Matching Cells, If - Then Move Cell With Self
Error 1004 on Range.Text with AutoFilter
Importing a JPEG image to excel as matrix
Keyboard shortcuts
å›žè¦†ï¼šRead back the source data from chart
Read back the source data from chart
Passing Parameter with OnAction
Workbook_BeforeSave
Formula re value in column C or D, calculations made on either in column E?
Conditional Combobox
Import Hours as Text
VBA code for Range
excel cell to text file and text file to cell dir to cells and renamefile from cell
Convert Time to Text
Summary sheet
Copying Value to Range
how to quit in BeforeClose
Find more than a word in a table
Clearing Office clipboard 2010
Filtering Worksheets by Same Criteria - Object variable or with blockvariable not set
Change Format of Active Cell
Sendkeys to external application not working
Excel Bar Charts Issue - How Dynamic can charts be?
How to find sheet names without opening files
Make a crosscast reprot from a tabular report
Count or Match Help Please
Calc Number of Months PER YEAR Between Dates
Moving data from column to row in groups of 250 per row for fourrows, then skip a row and continue the same throughout the data in column A
xls Compare Software
Searching
Coding
CreateObject Software Versions
Is Range Offset property needed
Close dialogs
Routine too fast for Form to Update?
automation error 440 when adding to collection
how to copy worksheet to new workbook with values only
Count no empty cells at the right of a selection
USB Communication
Match using VBA
Error Opening Workbook
UDF for Aging in excel - Help needed
UDF for Aging in excel - Help needed
Re: Error populating a list box
comboboxes, extracting specific item
Re: Error populating a list box
Error populating a list box
Create a password protected Zip file
overlapping sheets' frames
Have shapes react to events in Excel 2010
Inputbox from another OPEN workbook
Finding Intersection Points between different lines
Finding Intersection Points between different lines
Adjusting alogarithm
Import module
Trim leading numbers
Finding, grouping, then copy/paste to new sheet
Adding PivotTable fields with a macro
Best way to make all sheets in a workbook Values only
Why is Cell not an object
Corrupt files due to pivot remnants after saving via VBA
Re: Excel Formula to add network file link to each month
Worksheet appears briefly before UserForm opens
CountA and Countif and Arrays
Protect / unprotect a form
stopping a range from calculating
how to protect a program
Identify invalid folder in VBA
+ / - Percentage Variation
Returning 100%
Save ActiveWorkbook dilemma
=SUMPRODUCT Question
Delete some letters
Duplicating worksheet based on range and changing worksheet name
Using a sub within a function
Cell list value from another sheet
VBE object in 2010
Advance Filter
Re: 'Save as' dialog opens despite Application.DisplayAlerts = False
Re: 'Save as' dialog opens despite Application.DisplayAlerts = False
VBA dropdown vs Validation
Read contents of #Name cell
Unable to change ActiveSheet within Workbook_Open
Nested If / And Statement with Conditional Formatting.
How to Average a Sumproduct() formula
Outlook Code Run from Excel
If then statement based on time of day
Apply macro to all worksheets
Add Hours by Looping through Data Q
Custom filter
use ComboBox value to select range and then use selected range tocreate a chart
How to copy row data from Sheet2 to Sheet1 based on Conditional Date
CountIf / SumProduct in VB
Rounding up/down time
Copy worksheets to control file
Copy a range instead of just one row but with condition
Open excel Visual basic code window by clicking on hyperlink
criteriarange not equal to
Where to put / register a 3rd-party activeX component for use in Excel2010
excel shape xy poisiton in A4 paper
In need of more guidance please....
Need help on this strange event
Guidance required please...
Week numbers from an entered date
Need help with vlookup & MACRO
Macro Sorting according to a chosen name
Re: Excel 2007 "Custom Toolbars Button"
Excel 2007 "Custom Toolbars Button"
For, Next, Loop vs. Select / Case Is
alignment of SOME text in a textbox
Number Match Formula?
Knapsack Problem
Select two items from many
Macro to Create Name Ranges for variable lengths of Data
For Next loop
FINDPREVIOUS on UNION not cycling correctly
Q: UDF with Interior.colorindex Help needed
Match based on a lookup and then flag
Math Problem in Excel
Need help with worksheet_change script
Help with worksheet_change script
Search for values in a sheet and copy found records one after theother in another sheet
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and Pivot Charts
MINIF function
Original Picture Size in VBA?
Shapes in 2010
The Mt. Everest of requests
PING: ANYONE PLEASE I NEED YOUR HELP!!!
Paste failing after cut
Re: Macro to navigate through a Java Web-Page
Re: What's happened?
Macro to navigate through a Java Web-Page
Shapes in 2010
Delete lines with a blank cell
Disable optionbutton
Re: Windows XL, Mac XL, and the Ribbon?
Bold items within text string
VBA Lookup table / Array
Highlight Cells in Active Row
2010 MultiThreadedCalculation Incompatible with Range.Calculate
Print to PDF format
Re: Timed Scrolling
Help with VB macro for Excel
Excel 2010 is not acting the same with ReadOnly...
Copy Sheet and rename it.
create a pivot table and chart from a named range
Macro will copy formula instead of value
Command Button Text Cut Off
DOS batch files
Parsing names
Excell 2003 VBA Code needs
Macro need for Excell 2003
need help
LoadPicture command for excel 2011 for Mac
Application.Inputbox Type2
Count tokens in a string
Data Validation blanks for formulas
Win7 VirtualStore Weirdness with Excel 2002 and earlier
Apply different color to datalabels
What kernel function returns process stats
Diff btwn Dim x and Private x in class module?
Excel for Windows/Excel for mac compatible?
VBE tricky question
LoadPicture command
macro need
Sports Arbitrage Formulas
Send mail
Print entire workbook with each sheet starting at page 1
Help Required - 22nd May 2011
Just switched to Excel 2007 from 2003 - Unclear how to enable macros
generating zip code and county information from latitude andlongitude data
how to find union of two arrays
Method to automate page numbers on single worksheet
Have Cell To Left Show Fixed Time When Cell Changes
Inserting blank rows after ranges
Insert Border
Help file for VBA custom function
Macro for Fill Blank Cells Macro
Re: Extracting web data
How to copy several nonajacent cells and paste to ajacent cells in one row
cells.interior.color values
Re: Extracting web data
Sheet print doesn't center with pivotcharts
Extracting web data
Countif Code
VBA get range from cell offset
Copying same data range to a summary sheet
Error 2042 problem with vlookup
GETPIVOTDATA function on pivot filter
combo box
Save each sheet of multi-sheet workbook as a single-sheet workbook
Howto declare and fill a custom collection of worksheets ?
Re: " Select method of range class failed" if sheet not on top
" Select method of range class failed" if sheet not on top
Label controls change apparent font size when moved up/down
Accessing Exchange via Task Scheduler run on a Server
prevent pasting to more than one row
Re: Stuck with multi function Part 2
demerging add-in
demerging add-in
Creating a workbook(s) based upon a cells value <--HELP please
Querry in relates to the function SUMIF
Linking Attributes
Identify Hidden Columns
Stuck with multi function Part 2
Stuck with multi worksheet Function
A macro to parse a wordlist in Excel
Re: Autofilter based on user inputbox
Re: Autofilter based on user inputbox
Move all from Listbox1 to Listbox2
Move row based on value in cell
Working with 2 range but wont work with 3
Re: Autofilter based on user inputbox
Re: Autofilter based on user inputbox
rotating an Isoceles Triangle in the shape of a Gauge needle
Re: Button to copy, save a sheet in a new file
Re: Button to copy, save a sheet in a new file
Parsing XML with VBA
renaming tabs based on a on a worksheet
Re: Autofilter based on user inputbox
Problem when publishing to PDF
Button to copy, save a sheet in a new file
Macro for compare between 2 workbooks and copy adjacent cells
expanding SUMPRODUCT
Problem - Show values as % of Grand total
Macro for absolute reference
Re posting - Transpose employee data from Columns to Rows
Pivot Table Excel 2010
Image recolor with VBA
Counting (unknown at present) discrete values
Connection between Solver add-in and file path code
CommandBarPopup not recognised as a keyword Excel 2003
Convert a yyyymmdd date format in code
Macro assistance?
Loop through all open workbooks except Personal.xls
Macro help please!
Re: Copy Column Width
Deselect a worksheet?
Re: Copy Column Width
Re: Copy Column Width
Re: Copy Column Width
Re: Copy Column Width
Re: Click event for UserForm Multipage
Copy Column Width
Click event for UserForm Multipage
Number showing row location when you scroll
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule
how to write a macro to club data in multiple excel workbooks into asignle one???
Re: List sheet names in "pop-up" box for users to select
Re: List sheet names in "pop-up" box for users to select
Re: List sheet names in "pop-up" box for users to select
Disable save/saveas dialog box upon closing
converting a for next loop into a for each loop
Sorting Alphanumeric data
List sheet names in "pop-up" box for users to select
Adapt macro
count cells with diagonal cell borders
validated, stop all calculations on bad data
Move row to another location on sheet
Re: Vertically centering text in a label field
Vertically centering text in a label field
Button to copy row to first empty row on another sheet
helpp on being able to cut & paste automatically from a web client into a sheet.
Macro to save contents of a named range to a file
convert unformated text from word to excel
Dialog controls and display settings
code to open another workbook
code to open another workbook
code to open another workbook
Run time error
Auto Save
Copy rows to another sheet
Insert rows at change in cell value
insert worksheet shift 11 tab
file path or IP address protected
Calculating a worksheet
re-creating vbcomponent
Re: Automation Error
Automation Error
splitting text in cell - row and column operations
Open Webpage in Excel
Scrollbar on userform in design mode
find beginning of line to first space?
Why cant I get the path to the sharepoint library????????
security, enabling macros to enable a disabling saving function
Lookup cell, find Tab then copy/paste
Solver iteration in VBA macro
Scatter Chart
Find #Value Error
EXCEL DROP DOWN
automation error when closing excel
Filling an Array in VBA
Use index and match function to get data from pivot table
Impossible with regular expressions?
Date showing as numbers in Textbox on Userform
Multi listbox change event - selected or deselected
Help copying last sheet and renaming to next consecutive number
? Function to copy based on choice
error correction on vba macro
Restrict Input of InputBox to numeric values between 1 and 10
Excel 2007 Charts & Memory Leak??
Changing name of worksheet based on data in cell of another worksheet
Superscripting text in a cell
Mac Excel 2001 and PageSetup.PaperSize = xlPaperLetter
R: Re: function - find first number in row > 0, return cell column number
function - find first number in row > 0, return cell column number
xlPortrait in Macintosh
Automatic copy of cell formatting between sheets
Mac Excel 2008 question
Change cell backgrounds from VBA with undo enabled
VBA triggers on tabkey
R: Re: Basic regular expression question
R: Re: Basic regular expression question
Utility can't live without
Array - delete and replace elements
Calling Stack size in Userforms
Basic regular expression question
VBA Runs After Application.Quit
Reading image size?
Sum a column to a certain value
Turning off Word-Wrap
Selective selecting of multiple tabs
Advanced Find and Replace
Name vs FullName
Hiding 0 value data labels in chart
error trying to sort data
How to create a shared procedure
Upload Excel data to Access error
R: Alternate ways to extract a substring?
R: Alternate ways to extract a substring?
Alternate ways to extract a substring?
Read only file
type mismatch error
Bound Controls on UserForms lock Worksheet cells
Question about FileDialog
HOWTO Time VBA code
On-Worksheet ActiveX Controls - is there a bug in the Excel engine??
Enum bug?
Help With VLOOKUP VBA Script Line
Find pos of next whitespace char?
XL2003: VBE Won't let me break into running code
compare same data in two workbooks
Find the first numeric substring
Compare same data of column in two workbooks
compare same data of column in two workbooks
Worksheet level names
Convert time to military time?
Cells drop leading zeros from numbers
Multi-select listbox - mousedown event
For Each Type mismatch
Match 2 set data and combine to 1set
Change ActivePrinter?
Conditional Min/Max Question?
My formula stopped working when I moved it to Office 2011 for Mac
Insert string from Pup up box selection
VBA code based on column heading
"Duplicate declaration in current scope" during edit and continue
How To Import Excel Data With Excel 2007?
Type Mismatch error when trying to generically set ComboBox to aComboBox variable
How to copy a range of dates
how to reshow userform after following a link
Getting Last Non-Blank Row Number With VBA
selecting names in a list
Multiply a range by Input Box Value
Saving files based on lookup
Problem in Excel 2007 when Range beyond 65536 in SELECT statement
looking for fileio instructions
Re: VBA code if/then
VBA code if/then
renaming named ranges
Spin button to scroll up&down a database with a userform
Get visible pivot table items
Work week
How to stop a macro
reporting yes results in one column
Flip a spin button
Macro Syntax Again
Using a button to scroll Up & Down a Database on a Userform
File not found: VBA6.DLL
SpinUp & SpinDown in Excel 2010
Floating List Box
Copy/Paste_Value problem.
Save without Macros without prompting
Chart rotation
Macro to clear clipboard on exit
Problem adding a reference
Transfer data from user form to register spreadsheet
Conditional Sum
question on a feature of this site
comparing textbox value with values in named range
Attaching a trusted certificate to an Excel macro using Excel 2010 64 bit
Bar Chart With Custom Labels On X and Y?
Y/N and print job sequencer
Re: SUM of alphanumeric cells
SUM of alphanumeric cells
Deleting Duplicate Rows with Same Sum?
application.version ... is a application.servicepack? vba
Increment a row based on another column with duplicates possible
Can't get Control.State to work
Double-sided printing and printing entire workbook in one go. Macro to help ... ??
S-Functions and modeling user growth
finding "favorites"
Formula Help Please
Opening with Excel All Word documents of a Sharepoint site
Background images for userforms
Finding name of shape that was last clicked - Application.Caller
A/B split testing question
Making an estimate
application.filesearch error in office 2010
2 If/Then statements in 1 sub not working correctly
2 dimensional loop, averageif formula
Macro help please
passing a parameter from a button invoked VBA macro?
Update website with live Excel data
creating a database with outlook forms
Supplied provider is different from the one already in use
Date values not appearing correclty in the x-axis
Remove a missing reference that is in use?
Details in dialog_open box
Convert Chinese character to UTF8 for hyperlink
first sip of working with range in vba excel
random number generation help
Intersect for time
fso.FolderExists Gives True but Access is Denied
UserForm Functionality
Macro / Web Querry Help Hide options
How to find folders in a directory
Forms & Excel
Calculate Payment Days and Date
preventing referencing hidden cell
Re: Can't filter/clean cells that contain #NAME?
Can't filter/clean cells that contain #NAME?
Repeating tables
macros in Blackberry?
Problem with a class1 certificate to sign Excel macros
Open Workbook (VBA)
Open file and set numbers of decimal points
Using the INDIRECT function across multiple worksheets
Alternative to pivot table ?
Calling macro?
Align cells with same value - vba almost working
HELP NEEDED - Iterative process in a VBA function
Help needed - Strange hyperlink problem
Excel crash
Check whether URL exists
COUNT for 2 or MORE CONDITIONS
activating windows
Web background colors
Formatting from CopyFromRecordset
Summary View From Database
Re: ActiveSheet.CodeName?
ActiveSheet.CodeName?
Summary View From Database
Excel 2003/vbx macro errors.
need help creating a Batch-File
Check boxes
VB Printing problem
number seperator by coma
Macro to Convert Value to Number, Sort, then Delete
sumproduct error
open workbook in new window using VBA
Check for the existence of data labels
Determine which user has write access to a file?
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts
More Formula Help
Tables in Word 2007
Pivot table - show monthly data based on start/end date data
Hide Sheets to Left Q
Double click message on userform....
Using Excel to search Word documents?
Refreshing NON-embedded External Data Connections
Name Range Help
Removing Dashes in Excel
Re: different value for setting with breakpoint vs regular running code
different value for setting with breakpoint vs regular running code
Drawing a line for a set range
Get line no from right click menu ("Cell")
Re: Explicit declaration of variables
Explicit declaration of variables
updating a pivot table's original data sheet
Cutting row data and pasting into next available row on different tab
Save Array in memory
Rick Rothstein
= cell above last entered data
Conditional formating via VB
Sending an Outlook Template from buttons on Excel sheet
Where was I before pressing enter/return or tab key
Pivot Table in a sheet
OnAction bei vielen Shapes ... ich meine sehr viele Shapes?
Pivot Table - charts - default ?
Creating named ranges automatically
Refresh a local web page via Excel
Data validation, mandatory and restricted field length for excel vbs
Delete Rows with Conditions
Two column deletion
Pivot tables - refresh.
Excel 2003 VBE - Inside function, cursor over variable name does notdisplay contents
html output to file *.xls - how to stop date formatting <td>01-01</td>
Help With Input Box
Delete all drawings/shapes except DownArrows
Problema Copia ed Incolla
Run macro from email
Macro to Delete multiple/duplicated lines
Pixels counting !
Algorithm of GROWTH function
Remove Duplicates
Counting used cells on sheet
Save a userform that has been created programmatically at runtime?
ONLINE CODING COMPETITION
2D array of strings problem
Count days between two dates excluding weekends
Sumproduct not counting if the formula result is zero
GoTo Sheet reference
Export Sheet Values to new workbook
excel macro
Strange behavior
Auto filter "ALL"
Calendar object
Subtotal Sidebar query
User form: select all text on text field entry not working
replace 29 february with 28 february with vba
new xlsm & VBA problem
visual basic editor automatically opens up
Please let me know the error in this code
Problem with deleting blank rows or last row
MVP's Where Are Thou?
Code runs different on different machines
Excel 2010 code wont copy/paste to values
Excel Ribbon
Problem transferring VBA code w/ ProcOfLine & ProcBodyLine to VB.NET
Getting the caption from a HTMLSubmit button
Set Active Cell to A1 on Open Q
Display a StockChart In UserForm
Listbox problem
lookup values from tabdeliminated text file
Import a comma delimited file & match records
Use VB to unlock & lock cell protection
Pass "array of strings" into a function??
Setting range by cells fails
How can delete file by Marco
vba dynamic
Can you call a Color by # in Excel?
password protect individual sheets
Help please!
recognizing conditional formatting with VBA
Is there a limit to how far autocomplete will match user input?
Count cells with content in different color background
Rounding Time down
Copying date if 'date' matches with the reference
Sticky filepaths at Assign Macro step
Error message Macro cannot be found
transpose
Hyperlink - default font size and colour.
Help : Search Duplicate Records and Paste to New Worksheet
Converting weekly price data into daily (5 days of the week) format
How can I know whether an excel sheet is running in a PC or Mac environment?
The Road- Matching data within a range of values
How to imitate VLOOKUP with DAX?
Transpose
Refresh a local web page
HELP
Why no intellisense for ActiveSheet
better way to copy cells
Re: getting data from web
getting data from web
Last used cell in column
Automating producing PDF of my Excel reports
Changing default "Group dates in the Auto Filter menu"
Clear cells
Usenet group message fonts
ADODB
Note related background color of a cell
Locking and Unlocking Cells via VBA
cut/paste columns efficiency
Data Form
Toggling navigating between 3 cells?
How to extract data from an array
Select and sum all numbered cells in Column A
today's date static
Input box display
Matching cells
Cells with same contents
Cells with same contents
Cells with the same contents
conditional formating
search and replace loop problem
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another cell?
New Google Groups
Finding matching cells
file extension shows up twice on attachment
Cell change WB1 -> textbox WB2
Add-Ins: remote macro updates
little help
Clicking cells - run VBA
Copying all whilst Range Forbidden active
Macro to update other local macros
Copy cell change to other workbook
Re: Prorating an amount
Prorating an amount
Prorate amount
Can't Open Text File From Website in Excel 2010
XIRR
Prorating an amount
Property of a cell with a string
Changing the worksheet scrollbar increment
Consolidating sheets in Excel
File size grows 10-Fold after changing VB Code
Concatenating Cells
Usin OpenDiagBox to set ActiveWorkbook Name
excel isObject or collection exists
Who is linking to my file? And what files am I linking to?
ODBC QueryTable Location (Cell address)
Show/Hide Minimize/Maximize Button in Excel 2007/2010
Conditionally copy cell from one column to another VBA
Programmatically set UID & PWD in existing ODBC DSN connection string.
Context Menu 2007/2010
Combine multiple worksheets in one Workbook into one big worksheet
Borders around cells with data in them
SQL Syntax
xlDialogWorkbookMove crashing Excel
Update Pivot Table Filters based on a Cell Value in Excel 2007
ODBC Query
range name define on non active(focused) sheet
disappearing procedure
Sum formula in E5, add in same cell formula for gain/loss?
Active cell is to jump from one cell to another when conditions are met
CRC32 checksums with Excel VB
Printing Setup help
Best way to result more than 1 result?
passing values from form to module
Re: Adding another column
How to Remove Code
xl2010 and UserForm
problems with "CurDir"
problems with "CurDir"
Sum a range of cells based on relative position
regex validate rangename
Center across selection
Cell alignment
For Next with negative step ?
Macro to compare and copy ranges of cells
Data Validation when entering hours over 24
UPDATE Query
Getting in xcel in 1 cell txt valua based on number in other cell
Placing commadbutton
PageSetup doesn't work
Carriage return in a cell
Carriage return in a cell
Carriage return in cell
CurDir, ChDrive, ChDir error questions
Re: User Defined Function being called by changes to an independent workbook
User Defined Function being called by changes to an independent workbook
Hiding row ?
Shadows
Printing problem
UDF to merge duplicate rows
Return a string based on which Textbox is clicked
Magic Excel function or UDF?
Unwanted chart plot area resized when .Axes(xlValue).MinimumScale = "-0.1"
VBA error while using SQL "with rollup"
testing ADO recordset for PrimaryKeys
compare and color cells with similar values in a column using vba
Excel Userform
Superimpose an XY Scatter chart over a Background image.
Re-enter space in a cell if user accidently deletes it
Need help with Concatenate function
range values into list via c#
Accelerator or Access Key
Error Control - null rnage
Show file properties when file opened
Is there such an Excel Function?
Excel to Access
IE Automation
Checking if a font is installed (2007)
Calendar control in 2010
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spreadsheets tab names
wrap text in merge cells
function with more functionality then typical UDFs?
Help Needed, May have bitten off more than I can chew
Efficient Excel to Access uploads
print 2 sheets on one paper
Clipboard macro seriously locks up (or whatever it does) myclipboard! [XL2003]
How to access certain website log in with user name and password andclick certain button?
Shading pivot table based on value in 1st column
Personal Macro Book and VBE showing
Changing File "Summary" Properties Programmatically
Single key press date input
Application.StartupPath not set in Excel 2007
Code after the "Unload Me" call?
Updating Information on Userform VBA
Migration to Excel:Mac 2011, but what about the VBA projects?
selected Pivot Table filter items
Another textbox question
Moving extra characters to a new column
Sumproduct instead of SumifS in VBA (application.sumproduct)
Test for string of space chars?
Web based newsgroup needed
Extract text from a "textbox"
Re: my latest C++ excel OLE automation code
Re: my latest C++ excel OLE automation code
Re: my latest C++ excel OLE automation code
Re: my latest C++ excel OLE automation code
Calculate if 2 times differ by 24 hours?
Puzzling printarea code
Assign subroutine to a key press??
Re: Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value
How to implement mySum(Sheet1:Sheet3!B1)?
Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value
Need Clarification
before save event
Let a user choose a folder?
List of data?
Problem using a named range
Conditional formatting not working with AND
Need a macro to alert me when the value of a formula in another sheet changes
Renaming cell contents
TextBox Updating within for loop