Excel Programming [Archive] - Page 2

Convert list to UPPER, lower & Proper cases.
Utility to flatten/import X12 834 file into Excel
Problems starting Word from Excel VBA
Changes in How Code Acts After Upgrade of Excel
Direct & Indirect Reports
Search other sheets for numbers & color them
Issue with blanks and spaces
Auto open/refresh/close workbook?
Should I be content with the time code takes?
copy from cells to textbox
Run on specific time/date?
Modify working code to expand the output.
Combo boxes in excel
problem with array formula
Combobox filtering
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7
Display entire number in cell
Highlight the Row
Comparing images?
Optional argument as Variant not acting like number
Six columns randon no.'s no dupes
Macro from older version into Office 2013 on Windows 8
Formula works in google sheets but not in Excel, how to make it works?
Macros to convert Data into date format and then plot in graph
Use BeforeDoubleClick to place 1 or 4 character in a cell
vba and sql
Print a range to a XPS document?
Why is xmove not working? Any ideas?
Saving a Word document as PDF from en Excel macro
If Condition
Combine 2 columns in a dynamic range into one
sort table listobject without table name
... another request for a book recommendation.
event that cannot be disabled?
sheet event wait for another event?
Using TAB as CSV delimiter
active combobox - possible to configure as display value andcoordinate value?
Reduce duplicates to 1 with a count of how many before
access table results after filtering
hyperlink - place in this document - can discover caller in target sheet?
HeaderRowRange
RMD Question
How to call module function or sub from the Add In?
Loop is slow trying array code
Get Pivot data not reading some cells
WorksheetFunction.Match Usage?
Forcing save on shared doccument
Named cells in an array to a column and to a row
table column name with newline, cannot select with string
Code execution is correct but generates Error :The file you aretrying to open is in a different format than specified by the file extension.
random range of cells via cell names
best way protect unprotected cells
Command Button Question
conditional format - table - cell empty return default color
Run code from another workbook
Arrays and scattered cell values or another way?
Advice on multiple macros, same code just a different column
Adding custom menus to existing excel application
Problems with AutoFilter macro
Opening a list of Excel files and run a macro in each
how can i activate control+alt+impr pant in a command button?
recordset vs collection
"DoEvents"-type behavior in Solver?
non basic code in call stack
Sending e-mails from specific email address
My macro doesn't work if sheet is protected but it works if not protected
Drawn Objects Q
Runtime error 91: Object variable or With block variable not set
Export specific fields from access to Excel
convert columns to rows
export excel data to access table using ADO
conditional formatting, filtering then copying to another sheet
Sum a variable length column
Macro converts time entered in column E and F from Indian time to CST( without daylight saving)
Excel 95 equivalent of modern events?
VBA Conditional Formatting .IconSets plus one other icon/symbol
passing cell address to sub - write that cell
Help with copying a sheet from One workbook to another workbook
loop through only public functions?
VBA Programming
Taking control from Option Button into RefEdit in Excel 2010 behaving oddly
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated
File sharing
single cell time entry as time - time; Ever seen this?
Code to add comments to selected cells within a selected range
Excel VBA to extract MS Outlook Name and JobTitle values
Monthly percentage greater than a value
How open notepad.exe and write text line by line via excel vba?
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why?
Re: Format header in page setup
Convert string to military time string
find and scroll to cell string value in Excel
Adjust cell size for long strings?
Runtime error 13 : type mismatch
Border formatting row of cells
Handling internet explorer memory leaks from Excel VBA
CUT not COPY but errors
hidden rows, column copy-paste
InputBox for column letter problem
Software for "repetitions"
Shed some light on this WS_Calculate macro.
Conditional Formatting with VBA
Change_Event not responding to change made by formula.
list box
how to find words in large list box
Cell values to an array, then array transpose to another workbook
button names changed on copied sheet
form buttons on sheet collapse on unhide - sometimes
Change_Event troubles, no error & no work.
Excel 2010 WEB queries
columns width in a single vba statement
How to delete ALL cells containing the same data
conditional format fails when copied
Re: converting csv to qif
Macro help
get Data Validation to stop, list supplied, duplicate data entries
application.activesheet, should I use it?
function which includes its own list - no table
Cookie warning
excel and reqular expressions; what?????
Define specific page breaks when printing to PDF
Getting correct labels in Excel pivot
Advanced filter on last months results
Capturing web page load times from VBA
Re: Bezier Smoothing Algoritm Used in Excel Charts
Not Resizable textbox
What is Wrong with This?
VBA Configure Proxy Server Settings of IE
Code for adding datas into an excel sheet from an user form
How to create a mail in which a distribution list is taken from an excel list
DREAM FEATURE: A macro that moves a row but asks me where to move it
test mail- Need to join this group
Excellent code now a question of Feasibility
Export Macro to new Workbook based on Email Address
How to Use VBA to Group and Transpose Data...
Truncate
Truncate
Truncate
Run macro on all files in a specific folder
A simple if <> nn then Msgbox "No Match"
Iframe of Excel Webpage Wont Render Transparent
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013
Code copies ONLY last j from sheet
Tried and true copy code lines fail me here
Delimiting across multiple columns
Delimit across multiple columns
Tracking Changes in a different workbook
DTPicker control missing (Win XP/Excel 2007)
Some trouble assigning a string to a variable
Return last row no. of column with blanks at top
Conditional Formatting - Highlighting Certain cells if one of them is blank
how do you deal with excel versions?
Remove specific cells in a column.
Delete sheets code error requires object
Open four Wbooks, copy four columns from each to Master Wbook
Use Value of Dynamically Created Variable
How to rank multiple columns by different contribution levels to rankin Excel?
Eliminate blanks while copy row and transpose
HIDE VALUE 0 FROM CHART
Stay on Active Sheet
Dump ListBox Contents to Sheet & Stay on Active Sheet
Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers
Macro to generate FileName of the source file
Macro to SAVE and EXIT from EXCEL
Change event code Find .Activate does not activate Target.value
I need ONLY subtotals copied to a second sheet
Issue with ExportAsFixedFormat PDF (and solution)
Array code only works on selected sheet
VBA Assigning cell value to variable giving runtime error
sumifs return #value
Excel is removing Macros from workbook
Search Sheet Names Across Excel Files
Export registry keys?
Macro to copy files from Folders/Subfolders
To SQL Expert: VBA Function that Calls SQL Query
Format change with VBA language dependent?
Delete rows takes forever
Code copies twice...?
=trim
Page Break when a column changes
Count the highest number of days without “errors”
Find the correct sheet then find a value on that sheet
Math formula help
Excel data vs Access database
Modify Sort Routine to inlcude All Data
Viewing my Macro
Proper Case
Get text metrics of fonts?
Testing a string againsts a list of strings
Fixing text wrap in merged cells
Removing rows of data based on two collumn match
Delete from Registry using VBA
Private Macros
VBA Pivot Table: Determining item from one field based on anotherfield item
Runtime error 1004: Select method of worksheet class failed
Client Access File Transfer from Excel 2010
Copy columns and paste with blank column between
DiagramNode Object
macro to control tabs (different worksheets)
Using VBA to create charts
Macro to Format Multiple Sheets based on "Master" Format
VBA dropdownlist to put in cell's comment creates runtime error whenthe dropdownlist is above 266 lines
On Double Click - Filter Transactions to New WorkSheet
Macro to run SUM function
Macro for Dates
How to pass parameters to excel from wscript (Windows script)
Need help with correct syntax please
Macro to copy from active cell and down
Need macro to add numbers in rows
Compute percentage
Compute percentages
add a specific slide to an array of slides
Set Column choice to a variable from a Drop Down
Simple Variable to someone
Can I still register a function in a DLL using ExecuteExcel4Macro REGISTER?
Reading codelines?
Copy & Paste Only Those That Don't Exist
No response to change_event
list of workbook tabs
Find Specific Rows in Range and Create New Tab
Using Multiple Monitors with Excel Spreadsheet with VBA Code
quick zip/unzip form vba
Excel Macro open link in chrome - Gmail compose
Macro to Combine Data from Multiple Sheets with Cell References
Automatic cell selection
Use a MACRO to Merge two sheets of data
VBA Pivot Table Error
Return BLANK is cell value sought is blank
If statement based on cell formatting/style
Macro to Compile Data from Different Sheets
VBA Error Handling
Custom Excel backstage
Auto sort multiple colums alphabetically
Concat a three column range into one cell Then Next...
Select Case Code does not run...
Getting information from access table in excel
Convert code to lookup three criteria return fourth
For Eachcell in Range tranpose comma seperated values to a list in D
Unhide sheet, copy and rename new sheets from list, rehide sheet
How to read Excel Array to vb.net Arrays?
Summing Percentages
Comparing numbers
Unwanted workbooks on startup
Formula to fill in fields when cell is blank
Need Help solving this equation
Average data based on unique change in date, ignoring time
Adjusting height of text cells
modified pivot table using a macro
Code works but goes into endless loop and crashes
How to read index value and selected text of dropdown excel in C#
VBA CreateNames (ignores last 5 rows?)
RE: Indirect In formulas
Copy value of textbox to clipboard for use in another application
Converting NumberFormatLocal to NumberFormat
Too much data for this code?
INDIRECT informulas
OFFSET LOOKUP function in VBA?
Excel application main window background
Object variable or with Block variable not set
Not getting "argument type mismatch"
Excel crashes and restarts when accessing newly created worksheet
Formulas
Run or Call a sub from the list of subs in a drop down.
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet
Worksheet_Change Woes
Paste Special Values
Combining Multiple Schedules into One Schedule
Programatically changing the macro content.
Add a Value to a Cell Q
filter function
Pass condition formatting across worksheets via vba.
Create if partial match then copy and paste data from one cell to another
A data validation question
ActiveCell on inactive sheet
Snag in invoice generator. How to change the "series"
text wrap merged cells
linking sheets and workbooks
The Placement property does not seem to be working.
Sequential numbering formula
How do I exclude a cell from a range?
remembering the same filtering criteria
Delete all, but the last 23 lines of an external text file
SQL not importing records from ACCDB
Open to modify
SQL data from VBA - Sort into groups via heading.
Similar Book to Book Code, one works other does not
Find/Replace MSWord wildcard characters from within Excel
Select Case code error
Reference a workbook level named variable.
Xpose twenty rows then the next twent etc.
Get/Find criteria and copy sum
If value in a colum the same concatenate another colume
Run Macro on All Sheets Q
Resize a row but copy but skip columns I don't want to copy
IF argument limit - how convert formula to VBA?
Checking if a workbook is open
VBA Help with Form
If cancel list box don't enter FALSE in list
Code copies between key word is in reverse order
Click on button using VBA
How to determine Last row of a Page in Excel
excel 2010 opens blank from network drive
Add days to a specific date to get a later date.
Runtime error 424 in Windows 8 environment
Custom Fill in Listbox
Update specific cell at a specific time
Can't get Worksheet_Activate() to work in one spreadsheet.
VBA Code== Goto a webpage using a command button in a UserForm
Data Validation List problem
Loop thru xx No. of sheets until the four strValue combo's are found
Determine a computer's fingerprint?
Claus code works on my data not on OP's data
Set value of a cell with a dropdown list during run time (C#)
Read Dropdown list from Excel column
Populate and create duplicates on second worksheet
Combine two spreadsheets into one
Insert Row also adds formulas and moves cursor
Sort partially hidden data
Find string from column A in Range("B2:F7") list the header of that column/s
Microsoft Dynamics AX 2012 Installation and Configuration
Windows Common Controls (MSCOMCT2.OCX)
Can a formula do this?
Time issues in code
New problem! All variables have to be defined?
Is row visible?
Best Practice for Public Variables for Column Headings
Search column for date format; cut and paste multiple cells to row above
Functions to get information from Active Directoy
Worksheet sorting code/technique advise
Using C# .setSubtotals
Loop Through Text and Test for Scenarios Q
List ConnectionString of linked, external Excel file
After sort and concant, one too many semi-colon
populate a combobox based on unique values in another workbook
Running an Access function (with parameters) from Excel
Excel VB to create and send an outlook appointment with html code
Excel VB to capture the current cells row number
A For Each in Range... with a .Find(what:="TJ", ... in it problem
VBA for data validation in 3rd column does not run. I need help.
i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!?
VBA to run all variable combinations in a calculation model and store result
Formatting and copy or copy and formatting ??
Eliminate blank row at top of Text Box entries
PasteSpecial method of Range class failed Error 1004
SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary
VBA to copy from one workbook into another
Reference a row programmatically
Create a dynamic list on a userform outside of a list control
help with excel timesheet formulas
Auto duplicate rows
Handle Pop-Up While Navigating with IE
Help in sorting data
Code Cleaner menu entry disappeared
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row
Copy and past into browser?
Subtracting AD and/or BC dates
Browser in Excel
Change report firlds in pivot tables and charts with one selection
Arrey VAriable - How to initialise
Code does not error but no copy either
code suddenly stoips wiorking in Excel 2010
InputBox entries & advice
Dim IndxNum As Long & Dim c As Variant
Data Validation List (conditional)
Active XText box vbcr shows symbol instead of an actual carraige return
"ElseIf c.Value = "X_Clear" Then" and "...Target.Cells.Count > 1"don't work
Look up?
Setting IE Object Properties w/ VBA - Proxy Server & Port
Conditional listbox cell populating
Cell Counter/Increment
Code to Concat a row in loop
Code to sort rows getting hung up by merged cells
Macro beginner help with making tables
getting text out of TextBox into code
Finding last constant in range
Indirect formula errors if file is closed
multiple nest vert
VBA Combobox "Enter"
Need help with gmail compose
Help merging two VBA codes
Need help linking a macros to a drop down menu
Run macro if conditions meet
Problem with using addreslocal
Want code to copy to ABOVE row 22 column A on sheet 1
Survey - how much do you rely on Free/Open Source Software?
Error with calling Format sub
Text To Column max 26 characters
Value from one sheet paste under same value on other sheet.
Clean this select case code up a bit.
Columns as variable in Vlookup
Firing Event in another user form
Sound repeats unending until closing workbook
Copy/Paste Picture Fails - then works
Run a SQL Stored Procedure from VBA
Calculations
Pass value variable to worksheet event
Stop Command Question
[EASY] I'll become mad ' & "" in variables
Concatenate a row that is selected and include blank cells
Debug.Print statement causes Excel crash
Array to Multiple Arrays
Copy Array to Array, how to and should I?
Apply multiple filters from list
Array with excel sheet inside (need 2 code rows please)
How to find duplicate column (not the cell values)
range naming and conditional creation
Copy row info but not in normal column sequence
Excel file compare (each sheet). Is there something already available?.
Exceltastic brings back the classic Excel menus
Error Handling
Applying a style depending on currently selected cell?
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected
merging workbooks with userforms
Spellcheck a single cell
Basic vba excel syntax tuto on my website, your thoughts if any
Outlook VBA Problem
Adding table into existing access database via ADO
How I can set dynamic pivot table ONLY when I have enough data point
Re: linking sage to excel with odbc
Code works on sheet but not from code-to-sheet
Macro required
OnTime Change_Event macro AND copy to sheet2 macro trouble
Statusbar cell values?
Highlight multiple items in listbox based on textbox item
Practically Free Live 3 to 5 day Online Codecamps on Grails, Rails,jQuery, Spring, Java SE, Java EE, HTML5, Android
Application.quit error
Revision number
Problem with hyperlink macro
Top-Level Domain
Storing values
Now You Can Use Visual Studio 2012 To Work with Excel in .net and reporting services
Loop to skip some sheets in workbook
Vertical scrollbar screwed up
VBA Macro to customize Right Header
MS Query
Standard column width in points...
Compare shorter date range against longer date range
Columnwidth in milimeters?
Loop thru folder and get similar names
VBA Loop through Specific Subfolders to find files (drill down 4 levels)
VBA macro delete row - Help needed
"NxtRow = Cells(Rows.Count," giving me fits
Adjust code to run anywhere on sheet
Question about a range
VBA help with selecting multiple data ranges
Macro to Publish as PDF
Undo a select operation?
Too W i d e
Determine if a userform is visible
for each in a range
counting number of columns
Deleting Lines
Add sheet and name it unless it already exists
From where is my UDF called?
Web Queries?
how do i loop thru all the worksheets in 2 files one by one
Macro to Copy/Paste Multiple images
Assign a sound to a variable
Password Cracker for Excel Worksheets/ Workbooks
How to Restrict my addin usage to one pc only
Save preview picture
Setting Excel hyperlink base in VBA
vlookup using date ranges
Copy hyperlinks
Double click fails to run the code, just selects the cell
If loop based on logic function
Get rid of need for F2.Select
Excel VBA as a web service
Digital certificate for VBA code signing in Office 365
Strip out certain rows that have merged cells
Addition to current VBA - Keep text format
Load data from Word into Excel
using 1 through 9...equal 23
how to update a record from combo-box in user form?
Time format
Intricate Cell Formatting Question
Access to Excel format
Snake pre-defined range from multiple worksheets.
No need to password protect a sheet?
copy and save as csv
VBA Copy & Paste multiple ranges
Deleting entire row
Custom pop-up menus?
Emailing a sheet from a workbook with VBA
Copy & Pasting Problem ?
create ramdisk from VBA
Ctrl-Click to change TRUE and FALSE in a cell
How do I combine IF(ISNUMBER(SEARCH and VLOOKUP( formulas
Userform Calculation
Defining a dynamic table_array for vlookup
Highlight a cell after update in a specific range
Copy cells to different sheet if value found
For-Next by a row Counting consecutive Zero in the column
Tranfer data from Excel to word (Docx) via VBA in Excel
Sheet to sheet code Type Mismatch
VBA code to import worksheets from other workbooks
Attendance sheet
increment IP address.
Copy/paste in based on duplicate value in previous row
Import multiple Access Queries
How to make web image on Excel worksheet permanent
Copy and paste from one tab to another with certain rules using VBA
Col widths
Pop up window with totals?
Conditional Formating: MAX & MIN
Quote constant?
VBA Code to create reminders in Outlook from Excel
VBA code for for telnet
vba code to filter the data like a group with group header
Avoid compile error if userform doesn't exists???
How to execute a command in VBA
Return a value from Userform.Show()?
make use of cell defined data validation in vba
Hyperlink to Same sheet but after that want to hide link sheet
Double click a range
Question about "autocomplete"
Delete a row that is double clicked
transformed vloopup
Plot Polyline using XY coordinates
best way to validate data in forms; 2010
Copy adjacent Sheet and name from a list
Select method failed - Error 400
Excel Update
How to get a value from 1 table to a 2nd.
Permutations andText to column problem
Shifting rows down in a table
Need to create an excel template with many dependencies between columns and some prog
ScrollBars in 6.5
VLOOKUP Multiple Tables Value Return
Loop returns only one value, does not loop & an assignment to columnhow-to problem.
Input Box flaw?
Transpose data into a single cloumn
Text boxes moving to Cell A1 on top of each other after turning off AutoFilter
VBA code for pasting links -- modifying RDB code for summary workbook
Code with hidden flaw ERROR 400
select data entry by typing first letter which causes drop down list
Copy, paste to active workbook?
Sheet name=Cell value
excel tables, searching via sql interface?
Combobox Rowsource
Process dumped into an array...and then back to sheet
Conditional formatting within macro?
Removing Objects
Issue With Macro Sheduling Using On Time Event
userform textbox returns changeable date
Copy FROM - TO Object/Block variable not set
Ranking without skipping ranks and percentile
Import sheets with picture
Getting Outlook version number
Draw two lines at given angles
Gears
only the date part
Reference must be to a macro sheet?
list box remove item by combobox
Absolutely turn off all messaging/alerts/debug - ontime()
Need help with Macro
Sort Order
How activate "NUM" thingie?
Userform to query?
Need to Capture the initial value of a cell.
Sheet Selection
contacting .... press escape to cancel
VBA Code to monitor standard toolbar buttons.
VBA and SOAP in Excel 2010
I'm trying to do a "count" function at the end of a dynamic pivot table
Keeping formulas on an insert
AllowFiltering vs EnableAutoFilter
Range passed to a function - trying to just move through the range
What is going on here? (macro mystery)
Quicker way to enable macros?
Conditional Validation In Excel
Automatic cursor move
Path to desktop
How to copy only the numbers that are between quotation marks in new cells
Somewhat complex code to copy data from one sheet to another
excel auto dial cell phone via bluetooth
excel dial phone via bluetooth
quick way to prohibit all editing/changes to workbook (2010)
can variable names end with a $ or &
Highlight Cell as per System Date
Cell Auto Lock After Entering
UPDATE through a QueryTable? Or?
PlaySound error (Chip Pearson site)
Worksheet_SelectionChange & Worksheet_Change results in different Targets
Macro storing as a date?
Macro stops running if date is not in past...
index function in vba
VBA to VB6
Convert numerals
Right justify a string
Working with Word Documents from within an Excel Macro
Check if there is a space in a string as test for IF
Check for values in column A and if found then column B must have value.
How to use Sumifs with vertically and horizontally criterias
Use a listbox as a dynamic array?
Change event to add button
execution speed issue when closing files
Macro to restore previous content of clipboard
Macro to search range for a portion of a specific value and if findit - then paste formula in another cell.
Inaccurate count with code
String centering
user defined function which increase consecutively while passingbelow cells
Convert to Excel Macro
Convert to Excel Macro
Macro for Creating Word Document!!
Slight VBA hickup
Pivot Table Management
Collect User Input
GridLines Inadvertantly Goes Away with Macro
Number stored as text
How to differentiate two images inside the excel ? (only 2 type ofimages, needs to differentiate as boolean)
Blank Spaces on ComboBox
Searching for a word and then copy the whole row
Finding Next Largest Number Based on Criteria
Which numbers are missing?
Name the range AFTER copied to new sheet
Input, copy, new book?
Status bar on a UserForm?
Send mail code from Ron
InputBox to name a range
Remove Hyperlinks Without Changing background shading
CSE with function returning an array?
Code Snippet - Data Filter
If .Column > 7 And .Row > 25 then go to B8
Spread Project Costs Over Months Using Bell Curve
Throwing #Value in a UDF written in Excel VBA
Override protected sheet message?
UDF does not show up in Autocomplete
Key Card Software (Auric)
string compression
Help Needed !
best way to express the range "column N to column M"?
Cut bottom 300 rows to next sheet & repeat
check the value in cell
Formula for calulating percentage
Close na "on the fly" created Listbox if ignored by the user?
Automatically copy with save?
MOD giving different results???
Macro Related to Paste Values
Excel 2010 Sendmail .Display works, but not .Send --- Please help
Date Stamp by User and cell value
using defined name in UDF
Update calendar for 2013 - 2020 with events from the database sheet
function works okay, unless I save personal.xlsb
how to have multiple drop down lists filter rows
how to have 2 drop down lists filter rows
Excel 2007 Conditional Formatting
Sort The Date at the center of string with VBA
Toggling save warning message on or off
Set a Range to a variable
Transpose cells
QueryTable inserts empty column?
Date formatting in VBA
Variables in a Popup prompt
revise CONCATENATE code
CONCATENATE code
Chinese New Year
Custom Document Properties in Word documents and Excel workbooks
get calendar item of another user (not in present in public folder !! )
all above entered first
comparing two columns in vba
using vlookup in vba
Problem with multilingual VBA Programming
Transpose code has ceased to transpose
Shared Workbooks & Code
Cell value that changes previously entered value
leading zeros using ActiveCell.Offset().value to insert row and value
User Agent to get source code
Deleting rows which are not highlighted
Ignoring a runtime error
Perplexing IF statement
Return a string by reference?
Test if a string contains only whitespaces
VB Editor Access
Check for invalid file types?
Application.OnDoubleClick
Moving cell data left
Autofill a dynamic range with a formula.
Object range failed
Help with copy/paste sub
Another regular expression question
Let user choose multiple files?
Date match problem
Addin to gereate Buy and Sell signals
Changing the test of checkboxes (shapes) programmatically?
Macro to Consolidate Data from Various Excel Files
Runtime error 1004 Application-defined or object defined error" on data sort
Copying row into new sheet if it contains certain text
Fill both cells if one cell has a negative amount
Fill color if amount is negative
Currency formatting (Issue with globalization/localization)
Fill color when negative
Concatenate when pasting.
Need to embed a graphic, then make a call to it
Time within time
Make long strings visible?
Control printing?
VBA Read-Manipulate-Save Text File
Excel 2003 with VBA - "Can't find project or library"
Altered pasting functionality
Find matching cell and return value of a different cell
Fixing Error 2029 (#NAME?)
Couple subs need help with
School Athletics Inter House Meet
Auto Calculate selected worksheets
Problems with VBA mailmerge
Converting UTM to Google Earth coordinates?
Hide Co9lumns based on cell value
Automatically email from spreadsheet?
Eliminating cells
hiding blank rows
Help Needed
submit button and auto update for workbook?
multiple column filtration
active row copy into Outlook
Excel Geography Game Example Using VBA and MapPoint - StateIdentification Game
Complete Excel-Based Game Using MapPoint With Source Code
Copying Solver results of each iteration to a given location in a workbook
Macroto delete extra space in a cell
How to obtain the transit time
Conditional format if difference in cell values greater than 0.50%
Time Now() minus ten minutes
Sort on 3 columns when number of rows vary daily
Code to insert a coma
Convert A1 value to a sheet name and copy to it
Combinazione di numeri
Re: refering to a sheet by codename
Change fomula in multiple cells
Help creating an optimizing formula
Special language request
Open Windows Explorer from Excel and select specific file
Insert a link to a pdf file
Excel 2007 and Security key cards
delete 2 dynamic ranges with VBA
Re: Does anyone know how I can concat duplicate cells associating info?
select all cell containing any formula and not text or number
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows
Formula error when created via VBA
Get status messages from Oracle sql queries
Need macro from basic table to a reorganized table
Unique value of Excel file
List sorting and macros
how to detect host id of a computer using excel
Duplicate last row and other progressive numbers
Graphing Negative Time
ie certificate error click on overridelink
Maximize VBE Window?
Need Help with Excel Cross Reference Formula
Excel freezes while running macro
Cration date
Sheet name to cell
filter column unique for alphanumeric
I really need help
Delete rows if time is greater than present time
Set Up Calendar To Account For Leap Years
Macros to Rearrange Data??
is is any stuff for stock market heat map then pls share
Compare dates
Finding and Replacing Data in a Header Row
Looking up specific text then adding a number(s) associated with the text
i am unable to post on group can any one tell me the group's e-mail id
ActiveCell.Offset(i, 0) = Chr(ActiveCell.Row + 62) returns all A's
= CHAR(Row() + 61)
Help VBA code - Create a table based on user input
Chip Pearson UDF returns #VALUE! error please help, just cannotfigure out why?
Re: Email Macro-using range for email address,ccc,bcc,subject andbody. Office Outlook as email
Transpose columns to rows in groups
Finding Date in an overseas format
Re: Event Study with Excel?
VBA to surf and login certain website
Backwards compatibile macro
Excel New Tool
Searching for specific name on main sheet then copying row data associated with name
Chop picture in VBA?
write usb flash drive information in to excel cell
Link, drop link, relink
Apply cell formatting using VBA
Excel 2003 - VBA to get a list of Module names in the project
input info when pasted in cells
Control of cell comments lsot in Office10
Find #N/A in column D
Listbox
Apply 1 formula against certian cells in a column
Date subtraction
MRound
Disable/enable or lock/unlock cells in VBA dependent on other cells values
Runtime error 438
Re: OnTime LatestTime Use
VBA Help needed
Calculated Field - vLookup
Looking for a Date forming function
Extract image paths from within html in a column
Mass covertion from faction odds to decimal odds
How to count cells with same fill colour containing same text...JoeMoe
Averaging Formula
Replace existing rows or add to end
Query of List Option
Add to existing macro
Comparing two workbooks - Excel 2010 - not using Add-ins
Sheet synching
UDF works in single-step, but not in spreadsheet.
UDF OK when single-stepped (F8) but NOT in spreadsheet
compare dates with different formats
Macro to pull/add data and populate new sheet
Can you decipher this timestamp?
email workbooks to three people
Using the OnTimer event to lock out users between specific time window.
Macro to delete row if cells greater than certain value
avoid reset after CodeModule InsertLines
LoadPicture into UserForm
Only work if target is in particular col
Help with MACRO for opening workbook
UDF in personal.xlsb is not recognized
delete selection in pivotcolumn
linefeed in msgbox
Problem using &
new v/s createObject ... IXMLDOMNodeList
VBA call xlfit
Curious general format rounding
excel sheets to PDF
Deleting Duplicate Data in Excel
processing time (revised and re-posted)
macro for reseting size of comment with no text
Processing time
Macro to choose data and export in another workbook
Newb: Asking about a tweak in code
help needed with borders
Case Sensitive SumProduct
Duplicate worksheet
sorting: cleared/null v/s ""
Problem sorting a range of columns using VBA
How to implement subtraction from a range
Need help on macro to do ranking
copying to new workbook
International Date formatting
Sort in striing?
help to understand 'querytable'
Identifying common data between 2 cells
vba code does not run
Macro to copy row based on value into new sheet of same name
Textbox input goes to 2 sheets in same wbk
Where did all the newsgroups go?
problem opening file thru code
Delete rows in Table
VLookups and processing speed
Prevent loss of SetPixel changes by window repaint
export excel chart to image from C# without using interop
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart
Monthly view calendar
hyperlinks to folders - flakey?
Validation of cell based on Drop down list
Issue with OLE DB Query - Date Search
Range.Find problem
How to get all the possible 6 number combinations from numbers 1-36
Trying to summarize same values
How can i not copy the headers?
Specified formula cannot be entered bc it uses more than 64 levels of nesting.
If Cells.Find returns run-time error '91': Object variableor With block variable not set
loop help
unic no
macro not register my conditional format formula
conditional formatting suddenly disabled
Chart label alignment
plot excel chart against datetime
How to display an "icon" instead of cell value
Flashing screen even with Application.ScreenUpdating = False
How can I branch from to
Number and names of courses may change later
Weird ignoring of one item in a loop
Bar-chart intervals
date corruption? 00/01/1900
execute assigned data validation in vba?
Is it possible after creating a new sheet to insert code in it?
Copy to Next Blank Row of Different Workbook
VBA to clear multiple ranges from list of sheets
Get text from last and first cell in a column
Multiple criteria in same column
Cell Reference and Concatenate
Returned position address on protected sheet
Alarm 2
Error message 1004
Change macro button text when macro is invoked.
insert new row every day.
Naming non-contigent cells with vba
importing cvs file!!
Help with loop
Add up cell from sheet 1 to show on sheet 2
How to write a macro to selectively output certain data to a different table based on
Dir function on Excel 2011 for Mac
Repport bugs to Microsoft?
Collecting data from different sheet
Several Password
File Dialog Folder Picker open to particular folder
Cannot find path!
Advanced IF statements .xla add-in
hide & unhide toggle button
Audible Alarm
Slight Annoyance
Save and closed excel workbook from the sheet
Help Required
Masking the character in input box
macro to find bottom of column
Cause and Effect chart convertion
Open print dialogue box when click on print icon in tool bar
Move rows based on cell info
Printing issue
Auto run macro
how to apply the code to the whole of the worksheet?
Find values of a column in another and paste range of rows
Command button wz 2 function
Wildcard Filtering on ADO Recordset
Average Ifs in Excel 2010
Count down a certain number of rows?
conditional format based on column statistics and loop over columns
macros to hide sheet with protection
Search , then copy and paste from multiple worksheets. VBA help
open sheet more than once?
Formula Array Help in VBA
comparing two arrays
VBA Filter
Forcing xl2K7 Column Count back to xl2K3 size
macro on different reports CTRL+F in formula
Unprotect sheet when Saving As
Need help to fix vlookup function in macro
help with array
End process at last row of data
Sending a mail via outlook excel 2003
OpenDatabase recommended practise
DES Decryption
Help - Creating Tip Pooling Worksheet
Data from excel range to User form in textbox
Worksheet within a macro
matching data with sequence in different cells
Count the duplicate string in the cell
How to delete item from listbox?
Sumproduct to populate 0 if cell is blank
Assign range to userform labels and textboxes
Excel template that is able to collect data from other excel sheetsbased on different criterias
Loop through named workbooks
Load User form
select case syntax to other sheets
user-define type not defined
How to get the value of
Macros to delete duplicate entry
Dynamic Autofill Error
SaveAs using VB
using replace to get the desired value?
formula to format text with single quotes
Open a workbook in VBA using UNC pathname
Update this macro to make it generate a counter as text
Macros replace if arguments
Getting the FULL text of a Comment
calculated form field
Trying to do a refresh type function
Subtotal Formatting
fill in data that is not empty
Macro to copy A1 tp J(bottom)
Formatting automatically filled cells
Buying mathematical algorithms vs. programming
Very Urgent Required : Senior System Analyst for Bahrain
Pasting to visible cells only?
HPageBreak not working - More info
Remove Duplicates (Macro)
HPageBreak not working
Programmatically updating document properties of closed file
Date formatting issue VB
How do I add a break after each subtotal?
Is there an incompatibility between language?
Bottom Up search for multiple entries
Macro to copy cell value if part of string exist
Search the list of Ids in the records
VLookup using VB
Macro to copy top 3 value in column
Automate Nuance PDF Converter Enterprise 7.3
Training in VBA
How to exchange data?
Re-save Macro-Enabled Workbook as an xlsx file in VBA
Excel VBA to delete records in Access table and reset the Autonumber
Skip copying empty column where remaining rows are filled
VBA Macro to Create Sheets Based on Column of Values
Excel Automation using OLE
Macro will not be assigned to a toolbar button.
Macro Challenge – Create Table with Hours Worked and Copy Data
Converting currency value into text
this code is VERY slow, is it the code or perhaps a worksheet issue
Changing 2 pivot tables source name per sheet x 15 sheets in Workbook?
Excel VBA Macro to input data on website - problem with HTML language
Excel Macro Programing Problem
combo box
Language independent VBA - hiding "blank" in pivot?
macro to set bottom and top values for randbetween
filter that yeilds no results
Excel - Data - From Web - Error
How to make a VBA Function return a value in percent format
Time Data Conversion
SelfCert Cannot create certificate
The Best IT Certification Material
Copy & Paste Conditional Formatted duplicates w/vba
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server
adding hours and minutes to a time value.