Excel Programming [Archive]

Rusty at excel, could use a hand with a macro
looking for any summary formulation program
exel xlsm - line argument for automatic allow modify and contents
adding if then statement in the formula below
VBA delete certain cell contents if condition is met
Formula to determine the number of work hours per month
Save file with date from cell
@ operator inconsistency in VBA .formula
Undo all changes
Delete range with formatting
Activate the cell which was found by vlookup formula
How to suppress a message box from popping up during a macro
Date conversion
Trapping an Excel crash
Creating track on map from position data
Rich text box control
Activex component cannot create object Excel 365 for mac
Overflow error
Extract text from text string
Extract segments of an array
Multi-column listbox help
Insert into presorted list
Split up or delineate data
VBA Script for Radio Button
Listbox with dynamic strings
Changing workbook name in named cell
Path string has spaces
Handle keyboard events
Compare two Columns , and if is it a Match , copy
Worksheet_BeforeDoubleClick subtract sum of cells below top cell
Problem with hlookup formula
Avoid ,,Select" and ,,Selection" in a few lines of code
CRviewer14.dll - Crystal repotrs wiht VBA
VBA Does not recognize cell contents
Copy paste different size problem
Help with named-cell referencing
Eliminate duplicate words from string
Step() Function
Script Runner Pro
Why this tooltip works ?
Converting Numeral to Time equivalent
Converting a Number to Time
Deleting rows when Worksheet_Change active
how to error-check text box values
UserForm triggers File Corruption
Moving a number
Enabling/Disabling ActiveX Command Buttons
VBA
File Extension
Converting three calculators in a workbook into one with a dropdown box (hardcoded)
Copy paste in last row
VBA for Selecting Last Row in Range
Identifying PERSONAL.XLSB macros
Express Array Function as VB
Help pasing cell reference to user-defined VBA function
X Y Scatter Excel Graph X Axis Customization
Coordinates of a grouped line
Excel VSTO: Selecting range according to properties
Determine the end coordinates of an Arc and then add textbox
Adding code behind newly created chartsheet - subscript out of range
Skipping sheets when copying
Syntax?
Array formula for lookup a max value cost too much time
Mark the first Unique Record in a list with VBA
Reserve the Horizontal line numbers and information , but the calculation result is c
Select identical column/rows based on the active cell and copy datato another sheet
Can I put buttons on a sheet without selecting?
Regular expression problem
not sure but think sumif problem
Fixed Pivot Table Row Headings
Row by Row Comparison & Deletion
Row by Row comparison
Macro needed for identify relations between rows.
Counts unique values based on 2 criteria in other columns (200.000 records)
Dynamic Sheet & Range Page Setup & Printing
Nested For statements
microsoft 365
Problem with class variable and Personal.xlsb
Re: Odd or Even numbers (VBA for Excel)
populate and list and sumup
I need help with a formula
Need help formatting a cell
Importing multiple .txt files in a directory
Macro to Find and Replace in a loop for a long list of rows
how use SheetActivate in vba code
auto load call vba in sheet excel
countif sum for column
same function edit vba excel
My own text using right click "New note"
Programmatic alternative to SendKeys
Vba excel one colomn one colomn
Shortcuts pinned to Excel on taskbar cannot be moved up and down
vba excel copy paste 1 column to 1 column
Extraction of emails based on criteria.
Using registry for data storage and transfer?
Web query and script errors
ISNUMBER function
Excel print object?
Cell to be activated, which is a result of a vlookup formula
Variable reference to noncontiguous cells...
Copy multi-line variable to first empty row
Get operator of a formula
Running macros from UIeditor ribbon - Strange Step Into behavior
VBA code to change numeric value to string
Getting a variable's contents onto the clipboard
After made a filter selection, hide to select visible rows based onthe registration in the visible cell related to the visible row above
Using PowerShell instead of VBA, to automate Excel
Excel 2007 VBA Book
Help with VBA script for Excel
Excel VBA Add-In - How to sell
Problem loading Solver
Simple Macro to Delete an Excel file at a specific Folder Location
Excel Help
Getting Office Version Number from Excel VBA
Extract digits
VBA "=STEP" equivalent
Need to create custom function of this formula
Recording a VBA Macro from keystrokes
VBA Get operator in a formula
Counting and unduplicating values based on the date
Early exit from function?
Parse substrings
Count number of tab characters in a string
Find position of date in string
ByRef argument type mismatch
Double-click event for cells?
Unable to open Word file from Excel
Sorting columns
Copy a complete modulesheet from file to another file
Search specific columnheading and copy/insert this column to locationcolumn A
Application.substitute
Use ADO to open a Word file from Excel?
VBA time conversion
Determine clipboard data type?
Copy rows as many there are 'slashes' in the cell and split out thecontent of that cell in the copied rows
Fixed length padded string
Adding photos to command buttons
Best way to load an existing spreadsheet?
Load iexplore in a new window?
Save rich text somewhere in Excel?
Paste text into Notepad?
Report within a row the Last used ColumnNr minus ForeLast Used ColumnNr
Reporting the maximum date within rows with the same keydata
only one of 2 xlsm files shows up in vba editor
Re: Excel is Waiting for another Application to complete OLE Action......
Re: Code need to be changed
Set column width to fixed size if there's no data in it at all(except heading in row1)
IF/AND statement with a Countif included
Mac Excel 2019 XLL add-in
Mark cell with a color based on 2 values setup in a text with a signin between
Rollup/combine data from several below rows into the TopRow based on keys
Cell Display
Sum product formula with conditions
EXCEL VBA Caching GET request?
API Call Caching?
Identify rows if in the row one of the cells within a range is colored
Check row for conditional formatting (color)
Using the red X (Upper right hand corner) for another purpose.
Why the heck doesn't this work?
Count the sum of multiply values in one cell, registered as part of atextcode, combine them per column and show the results in the next sheet
Copy data of records to a templatesheet and save this template as pdffile (and then the other records one by one)
Error during file read?
64K line limit still in excel 2010?
Array Logic Test
microsoft.public.excel.programming
Questions
Tricky regular expression
Converting dates
VBA for Adjusting Range of Named Area?
How to Use QuestionToMessageBox with Input for Cell
Error message: "Bad file name or number"
Question... Marking the unique- and the first one of the doubles with1 or 0 in the column next
Loop for text check in three colums and set a text code based on thisin another column
Question; Combine datafields from different rows into one row and onecolumn if the data in column A is identical
Code needed to populate a message box during a macro
How do I add a column on 3 worksheets. and get 1 total
the incredible shriking font
creating a text prompt
executing VBA macro in Excel from OLE
Macro to find/report text in several files at once needs translationfor finding colored cells on the same way
Pick up specific marked text (one or more then one) out of a cell andcombine them into another
Split row into multiply rows based on combined values in a cell andthen make the values unique
Dynamic Pushbutton caption
populate or summarize data
Userform textboxes not allowing input of any kind
Searching cell with zero value and delete their content
Update numbers
Print Setting in a sheet for specifc area.
move values from top of column B to bottom of column A
covert data from text file into columns
Cells(1)
How to access API from excel VBA coding
Delete rows depending on time value
delete data in an execl from c++
a button to add 1 to a SPECIFIC cell
Code does not select
Problem encountered with Debug.Print message being passed to subroutine
Loop for updating data from sheet2 to sheet1 based with some rules
Unable to 'Change Data Source' on Pivot Table
ThisWorkbook.Save is suddenly slow
Change a Search/report code for text into search/report color
Enable Outlining / Workbook_Open / Auto_Open
Remove leading zeros from string
excel vba number of days expressed in weeks and days
How to determine the name of a macro ran from the quick links menu
Test request on Excel 365 for the Mac
Re: Load bitmap on a button?
Removing Words from Cell
Relative reference problem
Email: Establishing Primary Cell vs. Ranges & Matches
Step thru Row No & Array Match
screenshot window and send via whatsapp to contact
Counting & Summing Multiple criteria over variable row range
For each c in myRng insert 6 rows
A unique ID for each row, also automatically after inserting a new row.
cleanup if and sumif in worksheet/workbook
Displayed results
select one of 6 cells down in column
Save and Close
Help required for macro
Run time error: 1004 General ODBC Error
select rows that has particular number in Col D
Data missing from chart
Data in cells missing from chart
Copy/Paste problem with =Proper function
rows.count property returns 2 even though only 1 row was imported by querytables.add
Excel VBA Code for Old Value New Value
Range.Style code gives Run-time error 450
Problem getting a pointer to a User Defined Type (UDT)
Check how date is entered
Task pane suppression
Copy data from multiple sheets to new workbook
Compute duration and miles-per-hour and total miles
Time formula
Pivot Table run-time error 1004 (PivotField class)
footer character limit issue in Excel
Pop up message needed dependend on certain conditions
ActiveX ComboBox not working
Installing and loading AddIns in multiuser environment
Reverse Vlookup?
File Path Issue in Excel 2016 for Mac
Compute time differences
XL2016 Form Controls OptionButtons - moving and/or graying option buttons
Performance lag issue
Prevent printing of certain sheets
Change cell if wrong time entered
Impossible to move a window with VBA 2016 for Mac
Enter value in compute cell location?
move data from a worksheet to another worksheet "form"
Find Text, Then Return the Sum of its values in Col D
date format
Code Count the items in a named range
Is it possible from VBA to run excel as administrator?
How to proceed after crash with message: Microsoft Excel has stopped working
VBA - Importing Access Query into Excel using ADO
returning current date in form
Code to replace specific text
Copying many columns into one column
Putting multiple rows of data at the top of each sheet
Copying and sorting with some twists
IE ActiveX Settings Launched from Excel
Split and transpose cell value
Help with my quicksort function
Background color in cells
How to do an auto sort on sheet2
Including date in SQL Where-clause in Excel 2007
Registrate date/time in a specific column for multiply selected rows
Expanding range
Help with removing Time from Date
Code to show how to insert an in-cell drop down calculator and insertvalue of calculation
Excel printing FOO
Run Time Error 1004
Formula required for Month wise calculation
Count of time (attendance)
Select the highest Date/Time stamp in a column, Show it in a MsgBoxand delete those after confirmation
Select case target.address
Changing plot color
Incremental counter for change across multiple columns
Macro for Copy PAste from different Workbook
Re: Number of leap year days between two dates
Formating cell from a specific text from a drop down box
Comparison of Time
vba Index Match Match
Assistance in transposing multiple sets of data
Case Select with 2 string conditions.
Help on code to sample data
Empty cell?
Sequential variables (no array)
Subtotal use macro to Sumif
Calling operators in formulas
Remove duplicates
How to include meta characters in forms
Recursive To non-Recursive Procedure
Login to intranet and download excel file using vba
Best practice sheet Change/Calculate?
Clear some columns but not all columns and keep headers in all columns
Code works okay, minor adjustments wanted
New and Exciting Excel Content
Turn positive values to negative values if condition is true
How To Find Data Between Two Dates In Excel Vba ?
extract number from a cell
Excel Vba Class Modul Examples
message box error trapping issue
VLOOKUP formulas only set to values
Delete CheckBoxes
Data Cleaning Macro Continues to generate Error
Copy one cell and merge into another
Retrieving records from closed Excel workbook
Input box, find number and go to cell
Error Executing a Macro on Opening Q
Breaking apart email addresses that list more than one on a row
Incorrect number entry on Excel for Mac 2011
Code to filter a pivot table
list 2 cell values in saveas filename
Help with adding hyperlinks to images
Macro Required - 13th April 2017.
Excel and VBA calculate the same formula differently
Call subroutine based on combination of Option buttons (two groups)
Re: Embedding Existing Excel chart into VB6 form
Using timer to refresh webpage
Change active cells - Excel 2010
New Newsgroup
Formatting multiple sheets within workbook.
use chrome as ie
Intersect operation
how to use ADO to get sheets from closed file and the excel tab order(figured out with DAO)
I need help getting spreadsheet names from closed file using ADODBwith tab order
help with loop code
need help with this send email micro
Help with Counting Multiple Criterias
Array list writing to an Array of 'scattered cells' ?
Customized Inventory Software Required in Excel VBA
VBA- Finding texts built from regex patterns
Syntax for Cell type
Excel Help!!
Delimiter(?)
Excel export to Outlook:- Missing Microsoft Outlook 16.0 object library
Help condensing 2 step process
separating text and numbers into different columns
Create an array based on the subroutines in a module
Controlling xlTiled windows arrangement
Several issues
Formula to extract certain texts
Simple alpha numeric sorting
Change event for all sheets in WBook
Comparing two columns in different sheets
Populating Publisher document from Excel using VBA
close adobe reader window
Running Word to Save as PDF
Change the Values in a Column to 'Minus' If Q
Split data in one cell like ALT-Enter
Web reads - synchronous and asynchronous - long
grouping cells within a column for a chart
Conditional selection and printing of sheets
Copy Row Above, with a Twist Q
conditional formatting, bleh
Claus
select case help
close a pdf file opened via shellexecute
FreezePanes is a window property
data connection table date help
SQL help? group? anything?
User-defined type not defined
replace() funciton with multiple tests....
Select rows that are 'blinking'
MsgBox if within selected rows a specific column is not filled in
sheet specific desktop shortcut
Insert 5 Row if a Certain Value in Column A Q
posting this here cuz the outlook programing group is very inactive...
Out of Memory
Count and report the number of red colored cells in a row
Compare 2 Lists and Take an Action Q
Sheet names in a drop down
Fill Cell with Colour if Q
Multiple Sort Ranges via VBA Q
Autofill VBA Q
Complicated VBA report... help
Complicated VBA report... help
Cumulative Column when using Sub Totals Q
Copy of coloring format, now in diferent files (change of earlierrecieved code)
activating activeX objects
Re: FileDateTime(path) - doesn't work across network???
File cannot be accessed
Sort isn't working correctly
Sort isn't working correctly
suspending code execution
Convert date/time to serial number and compare serial numbers
Convert to serial numbers and compare serial numbers
Convert dates and times into serial number and compare serial numbers
Huge data set Find-Replace
Watchdog timer issues
Macro to Insert Picture
Re: Earliest date & time
Copy from workbk & Paste to project window
Copy Active Sheet
Simple array macro works on one sheet only
Earliest date and time
Macros to Refresh all filled Cells.
Search Word document based on text in Excel cell.
Interior.ColorIndex of a field based on filled colors in other fieldsin the same row
Which activeX control currently has the focus?
Check of related records in a column have data filled in in the next colum
Copy format based on identical datafields
Compare cell contents
VBA to delete link to inserted image
Copy a by macro special selected nr of rows into another file
Camera picture resolution or sharpness
Colormarking of fields based on colors in another sheet (difficult !!)
How to different value from duplicate selection - macro help
please help in VBA or Formula
Stupid Excel tricks
Save Excel VBA as tab delimited text file without quotes
subroutine stops running unexpectedly
tracking table data
find different value from duplicate data - macro help
loop ends unexpectedly before finishing loop
Help with xPath - SearchNodes not returning any nodes
! exclamation point as pointer to active sheet with R1C1 reference
Using very hidden macros (plus other macros) on a shared file
for next with if
Import Module weirdness
VBA Code to find the Row Number of the last repeated row of aparticular date field
vba code to send a filename to word without starting a new session
Transfer data from one workbook to another workbook resident inNetwork, based on Date Filters
Read (and parse) file on the web
record counter based on column value
ColorIndex count function
Converting Excel Formula Arrays to Dynamic VB Array Code Help
Inserting Rows based on cell differences and interpolating in between
How to create backups of your workbooks as you open and as you close
Worksheet_Calculate
a twist on counting unique values in a range which contains blankcells, using a formula. the formula can't use SUMPRODUCT or FREQUENCY
Get data for matching headers thru macro
Capture # of Button pressed to pass to another form
Index and Match Help
Error on paste
Email on save
ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly
VBA - How to "execute" a dynamic variable assignment
"Continue?" Message Box
Number of records for last 7 days
Need Macro help to stop repeating some info
Convert Numeric Values in Column to Text via VBA
Click on Webpage Box
data filter via VBA
Print, Save as PDF, Email PDF code
Find and Replace Q
Programing to save who and when someone update the file
Multiple selections simultaneously from a data validated dropdown list
Copying/cloning an object
Error in VB Editor Coding
Comments do not appear
Active x control
reverse of CHR function
Writing formulae from array to range
Clear Contents and Checkboxes Button
VBA to read save messages on an Excel sheet
Pivot wrt active sheet & current region
HLookup/Needing Formula Question
VBA to send Outlook email - stuck in Outbox
using formula - extract text separated by 2 spaces
.SpecialCells(xlCellTypeBlanks).Delete without going to the sheet
Putting Focus into Textbox
Why full path in the formula to an UDF function?
Checkbox Quandry
Temporarily Suppressing the Printing of Page Footers
Excel Add-ins for 2010
My code stops working
Key press alternative for Ctrl+Break
Critique my filter/copy/visiblecells code...
Automatically (w/o macro or vb) dynamically mirror one excel tableonto another
A tale of two tables
Conditional Formatting
Exit when Cancel clicked.
Modify Code to loop back through table after its been updated and process it
Memory Overflow issue (clear worksheet that has Worksheet_Change action)
MID and FIND function in vba
Loop through a filtered range and copy unique values to a second sheet
Loop thru filtered sheet, copy unique values to another sheet
[ NEED HELP ] Loop in VBA
Run time error '49': Bad DLL calling convention - solved
populate =IF(... dynamically in loop, possible?
dynamically change IF formula in macro, possible?
Need to get a Page Number for a Cell
Need help in creating sum macro
Sub or Function not defined - Call to a sub in and XLAM addin
VBA Programming
VBA assistance needed
data validation using VBA, best practice?
req. for ideas for numeric worksheet
VBA: Can I Use Named Columns for Sorting?
Set value from comparison of other cell values?
Convert a Find/Loop to an Array macro
Copy/Destination & Copy/PasteSpecial>Formats SLOW for formats
Embed drawing toolbar textbox or word doc in sheet, how to refer toit?
Even larger fonts
activeworkbook connections.delete not working
Is it possible to copy vba macros into a workbook using a vba macroto do the copying
Working from data converted from a pdf file
VBA assistance needed, Grouping and Tables
Can't find project or library
Copy sheet name to same cell on each sheet, 50 sheets; run code onany worhseet beforedoubleclick
Macros not enabled
Upload an image depending on the value of cells
Determine closest control to MouseUp event?
Deleting rows from a structured table based on the value of a column
F1 help in VBA environment opens sheet; send VBA to background. Howto stop?
Trouble Counting how many times a Cell Value Occurs when Condition isin a Row and not a Column
Getting #Value error on Sumproduct with non-contiguous cells
VBA error 1004 on With worksheet.Paste
Copying down conditional formatting alone
Remove unicode characters from cell containing values
Hide colums based on a value in cell A1 (refered to the number in thefirst row of each column)
Hide rows without data in a column based on active cell
Set the copy to column to a variable
COUNTIF VBA
Worksheet Change event question
Conditional formatting activecell offset
Columns I to Q range variable definition
Insert from paint and resize
insert from paint & resize
Excel Experts
Hyperlink usage
How to get Next Drill Down Value from Pivot Table via VBA code
Question about Macros in Excel
Repeat values in a list x number of times
Currency change via vba
Currency change via vba
is a database user a member of a group in active directory
Writing array to a range
Issues with Slow Print to PDF Program...
Pivot table - VB code
Possible resources issue after running macro
range does not return limits correctly every time
Help with VBA and Counting Conditionally Formatted Cells
Question
I need help cross referencing...
global user-defined name (range) - or help with holidays
Issues comparing the values of 2 input boxes to cells and have eithervalue be able to be text or numeric
Concatenating strings into a variable
Graphics quality degrading
activex Control (ComboBox)
Excel automatic mail (Gmail), with conditions (verify cell content)
Conditional Formatting to display text in one cell according to whattext is displayed in another...Please Help
Extract Data from Dataset
Help Please - picture not embedding
Median Regression
Help needed: Conditional Formatting for 3 columns, any two of whichmust have data
Need help with a slightly modified Internal Rate of Return calculation
Help with a simple macro
Date range in Data Validation foiled by "Today()" function
Question
Find And replace macro
SUMPRODUCT throwing a #VALUE error when using range instead of single cell
Calculating the average value with criteria
Converting personal.xlsb to personal.xls
object.CopyFile() has an error?
Question about ActiveWorkbook.SaveAs()
Excel to new database project
VBA Code for Hyperlink 23rd Dec 2015
Trouble sending email via VBA using specific account
Help Required (19th Dec 2015)
Basic question about dates
Copy a folder's contents into another folder?
Best place to find an Excel contractor?
Select multipler folders?
Text with stripes?
New sheets from a Pivot Table
Worksheets dilemma
Query for Array !!!
Write to other sheets cells and include Cells.SpecialCells(xlCellTypeComments)
Query for Macro
Change_Event macro dismiss table1 copy reinstate Table1
VBA to stop if autofilter macro will wipe out all data
For Each sheet in WkBook problem
Can this code be optimized?
A LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox
Signature software Win10 linx tablet
VBA to launch camera app, take photo & insert in a cell
INSTR find copy sheet to sheet issue
Office 365 Home Premium Excel VBA greyed out on Developer tab
MATCH in reverse direction?
Randomly pick/select cells in a range
Repeat data on all sheets
Logical based Horizontal Lookup
Copy to sheet name in column 1
Rearrange numbers in a range
Date picker on a form?
Tracking unduplicated clients
Vlookup using 2 sheets
IF statement with multiple VLOOKUPs
list excel wookbooks and worksheets
Update of two cells from a cell.
Manage errors with multiple InPut Boxes
For Each c In Range... is slow
VBA to search for possible files in Windows Explorer
Sheets(MyArr(i)).Range("L2:L20") to a variable range of column L
trying to sum range in one sheet depending on the date in cell on other sheet
Different criteria in the same pivot table or synchronized navigationin outline format pivot tables
Calendar manipulation
Re: Can you use VBA to toggle design mode on/off in Excel?
Merging rows and data vertically based on first sno column
Help with CopyModule coding
VBA Rounding
Re: ms antivirus started finding "trojan" in workbooks, any ideas howto narrow down what module it's coming from?
Lookup in Excel from Table in Access
identifying a cell with worksheet_change
How to extract excel attachment from outlook email
Code to add a comment and the text from a sheet range
Delete Pictures in Excel 2010
Transpose a column list to every other cell in a row on anothersheet, then center
Resolving VBA reference error
Bold & increase font size of inStr(...) character's position
User Selection as to which Function to Run
Calculate event to do what Change event does.
Copy to the rows between 49 up to 29
Macro to paste from clipboard
Calling Analysis Toolpak.Regress (Regression)
Application.Match problem
Q to Automate Removal of Characters from Cells
send temporary data without saving the workbook
Use of MID function for Variable Extraction
Extracting numbers greater than 5 digits from a string (variable position)
If clipboard is empty..
how to loop through textboxes
Code to capture filter settings works but not for color filters
Code to write to Index Match intersection
pass value from combobox on form1 to a label.caption
Macro to copy figures from Mainframe screen and paste at excel
populate a combobox with filenames in a specific folder
VLOOKUP to return value AND cell color
Excel vba error when adding norwegian translated SUBTOTAL formula tolist - function name not recognized
Quick and dirty function to test for MM/DD/YYYY value
Combining VLOOKUP and IF formulas
De-convert Dates
Checkboxes and Captions Not Able to Return Value
.Value "issue"
Find Combinations
Find multiple matches in other sheet column return row data
Find Loop - not terminating
Ghost Cells
CheckBoxes and the Split function
Code to do complete a Find and Replace on long list of values
Referring a dynamic range in for Application.WorksheetFunction.Vlookup
Excel formulas
Loop for myRng for next set of 9 rows
Excel Tables - extracting data
VBA Sorting
Unable to run excel via vbscript
Excel 2010 Question
Rearranging columns in a large spreadsheet
generating e-mail w/ links to excel file
Filter criteria in as a variable
How to increment the k in LARGE(array,k)
HELP! Private Declare Function won't go away
Loop not quite working correctly
Before_Close macro, How to...?
Loading a unique list of names from a range into a combobox
On Open macro not running correctly
Dynamic range for Pivot-generating Macro
how many rows since the last time this happened
Iterate through all words
Fast string comparison
Open file in this document? (Word)
Unique values in combobox2 in excel VBA
DoubleClick worksheet macro to copy paste cell value to another sheet
Paths and filenames
Number and date
Macro that repeats 4 relatively straighforward steps until end of list
Delete the rows of the duplicates in a column, keep single entries only
Application.GetOpenFilename
Efficient storage
Please explain copy/pastespecial issue
Delete Rows on Conditions & Long Processing Time
Deleting Rows on condition & Long processing time
Worksheet for designing a garden
Strange behaviour - empty cell being evaluated as numeric
What is the proper dot.syntax to insert a select case within a With /End With Statement
External links change values simply by opening workbook with commonexternal reference?
Excel in dialy official use
Add comment with author and text code.
GPS Data from JPEG's
A Boolean expression
How do I Delete Rows on Range Criteria for Column A Cells Not Equalto specific values ?
compare x to values in a range
Auto Filter one short list vs another very long list
A faster code maybe?
Event codes don't fire with change or calculate
The sheet name to copy to is in column H of the If Statement row
chronological date selection
Contains 29 February
AccumulatedInterest Function
how can i define x as 988 and then use x in several macros?
Naming different ranges in the same column
Table column in VBA
Summing To Same Cell Reference
Breaking down my macros into pieces
copy row from one sheet to another if certain condition is met
Modify this Array
Deferred row deepening
Dynamic sort
Loop thru cells & isolate numeric string
break out lines 8 times and apply a decimal to selected values
Filter column A and copy column if cell in row has header
ambiguous names
CR LF problem
Change column width
Dynamic Autofilter using VBA
Get_Cell_Number
regEx replace
ByRef argument type mismatch (repost)
ERROR MESSAGE ON CONDITIONAL MESSAGE
Access Query
Array instead of loop I'm sure
Fast string replacement
Fast way to truncate string
Re: Debug Macro Usiing Step Into
Delete Pictures in excel
Parse with newline "0D 0D 0A"
Must add 1 to InputBox entry for code to work properly
VBA to access data from closed workbooks
Extend a macro rule for setting color and specific text
Monthend Dates Extraction
Please help in fixing my Macro
Delete Object, not Working Correctly
Get character code within string
Remove newline char from string
multiline inputbox
Returning Value Based on Two Different Ranges
Line Input is reading extra lines?
Import multiple text files
Code to copy header does not copy
Use string variable as Object name
Extract word after 3 spaces
Listing of sales categories...
Strange Condition on Date Value
Cross reference 2 excel docs
run time error 32809
Split Monthly Forecast into Weekly Buckets
compare text in cells
Duplicate declaration in current scope, but not so
vba worksheetfunciton.sumifs w/ nested array help
excel 97 -Trusted source security tab now missing
How to extract all numbers preceded by a dash
Understanding Issues with INTERSECT function in VBA
understanding issues with INTERSECT function in VBA
Conditianl formating with AND formula
Extract paragraphs from text file
Ctrl's renamed from 2013 to 2010
has Excel software updates disabled VBA functions?
COM addin won't connect when workbook opened via another workbookfrom another instance
My Never ending ARRAY code problems
Supressing a #VALUE! error returned?
Array coding type mismatch
CommonButton was out of function since Dec 2014
Paramterization in Excel using VB/Macros
Cell comments
Trying to find a way to calculate subtotals for different sections data validation
Help with IF/And Function statements.
Hide / Unhide each row from StartRow to LastRow for multiple conditions
Progressive number in different sheets
IF(AND(Complex Formula in Error in data import before I process it
interesting take on knapsack problem
using dhRichClient3 across a LAN
Change Event code
Re: Access to sharepoint via VBA?
Custom class, Stack overflow error
Clear a "moving" range offset from Target
Re: Can you use VBA to toggle design mode on/off in Excel?
Reference sheets named by DAY
inconsistent dir() behavior
Command Button Invisible
formattig word paragraphs from excel
Count latest number of continous not-empty cells in a row.
Start Do/Loop within conditional statement
writing excel data into word document
If ActiveCell has a comment then exit sub
Command button does not run code
HOw do I create a rolling day excel sheet
userform program keeps crashing
Transfer array element offset value to a matched value
Export range to new file (using classes)
Need help with a stock spreadsheet
can i use VBA in one XLS file to change VBA in another?
Counting Criteria Values with For Loop
Conflict
VBA Countif across sheets?
Arithmetic with Cell Dates
Generate Check Digit
xslt and .net
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the Evaluate method
Weighted randbetween text list
Need help with Macro sending data to different sheet
Delete unused rows / clear unused rows
Named Range maker code
xml and excel
Ambiguous Dates Crashing VBA User Forms
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is protected)
ADO retrieval from close workbook-data type issue
Re: Repositioning after hyperlink.....
buy real/fake Australian driver licenses
VBA Debug Issue
Run macro from active workbook whose name keeps changing
How to change add-in object from within worksheet module.
Need Macro...
array data type issues -
Alt+Enter character
Mid column sum formulas with varied ranges to sum
vba array logic
Cells with varying number of lines
How to do this simple Excercise in Excel
Problem with a loop and column references
sloppy code help
Macro to Update Conditional Formatting Formulae
Printing full pages on one sheet
Write to intersect of a row and column
Mirror data in two sheets
Save As text file
Excel customization will not be loaded
Iterative consolidation macro can't complete - memory overload?
calendar spinbutton
Excel is changing date format incorrectly
ERROR 400 on identical codes different range
How to hide password?
vArray = Sheet2.Range("A1:A" & lr) troubles ahoy
Re: Every 10 second autosave/excel macro
ThisWorkbook.Close()
Rows with cells of varying number of lines
lastrow function help
Cell's data fills out the rest of spreadsheet
Multiple rows into one cell
Userform textbox string to header causes unwanted double spacing
textbox string to header causes double spacing
Paste in column B using Last row of either column B, C or D.
Passing data to an event handler
clear all sheets code
ADO sorting issue (repost)
Scraping web data
Efficient printing
Excel spreadsheet to Word document
Multiple SUM's in a column
Advanced Filter Error - I cannot spot my Error
i = row number of last occurance of duplicate string Column A
Send numbers from textbox with multiline property to specific columnby identifying first 8 digits
4 alternatives to all questions need randomization
Custom SaveAs dialog - need list of supported filetypes
Make Macro Work On A Different PC
Efficient standard to military time
Intercepting data typed into cells.
Extracting data from website onto excel
How to Unlock Excel Workbook protected by MACRO Password
Code for multiple select of cells
Macro that will insert a simple text string in top cell of text file
Range(sheet2) = Range(sheet1)
Using XML in Excel
Cancel Input Box error
For next loop suddenly not working, any ideas?
Copying a formula to a range
Swiss Teams for bridge tournament
Alternative to writing to a closed spreadsheet
Using ADO to write into a spreadsheet
Need to flag the lead ID of any contiguous ID's from a sorted list of ID's.
Add to a "number as text"
Runtime error 1004 when trying to insert formula in cells
Vlookup with multiple FOR condition
Excel and xml
Multiple selection on dropdown in same cell
Fill cell with value above it (with validation).
When found add it to the last and display total in Msgbox
Extract lines with regular expressions?
pivot table macro with a filtering variable
Eliminating Duplicate Entries in a Column
Retrieving Data From Excel
Vlookup result in a message box
If Macro Run From Form Control Button/Shape, "Find" Command Not Working
Send Mail From Lotus Notes using Client Mailbox via VBA Macro
Copy value from changing cells without VBA
Can UDF entered as a formula in names return a value to VBA?
Find a value in a sheet and replace it with another value if it matches
How to write a VBA code to check whether TCP port (e.g.3306) isblocked or not?
Count cells containing text, multiple criteria
Macro to generate powerpoint slides
Datavalidation with shrinking non blank values
Modify Claus code "Sub Array_Var_Column_Sort()"
Macros to COPY pivot table selection
ExportToExcel Macro
Ado add an id variable to a table
Resize to last entry in row and copy to sheet 1
filtering
convert this to Excel vba
Date Modification
Copy / Append values of a named range from Workbook A Sheet1 to aclosed Workbook B Sheet1 in same folder
Copy data to all cells in group
Applying Variables to SORT
Send emails on behalf of a group - VBA - Lotus Notes
ADO left join sorting issue
Array code troubles
Quick file overwrite script
Combine IsNumeric & CountA in single If statement
Read SQLLite3 .DB files?
Porting from Excel 2003 to Excel 2010
Array VLOOKUP lookup_Value does not increment
Copy to a mid column range Row 10 - Row 20
UnSelect the copied to range after copy...
merging multple columns into one column (dynamically)
Unable to Group in Pivot Table
Post my named ranges in column A
Run two macros for two different sheets
How to write some text in textarea on a webpage using Selenium WebDriver
Text color in textbox
Excel VBA to Merge Word Documents
Paste special syntax Book to Book
ADO with mixed data
Open a word mail-merge document from Excel VBA
VBA Script to insert image
Hide and show ribbon excel 2013 using vba
Sum work hours to hours & nearest 10th of an hour
Help with BVA code
Re: Solution: Excel hangs on open, close & vba6.dll not found errors
Transpose??
Scattered array cells copy to scattered array cells another workbook
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text"
enter key behavior - by sheet
Find latest effective month and delete others
If value occurs more than once then delete all of them
Vba help needed.
Find sometimes ignores Application.FindFormat
On-sheet activeX component disables copy/paste
VBA copy and paste data
How to Disable/Enable hide entire row ability
List found strings on sheet
Path from path???
Excel macros to plot data in a line graph
Using Find as lookup method goes to semi endless loop
Save As and new workbook new name used in existing code
Calling module procedure from sheet procedure
Ribbon, Backstage, getVisible
Disable 'Save/Save As', Enable 'Save as PDF'
Excel 2013 animation feature....
Saving/updating an Excel(xlam) add-in
How to add Row in Table in Lotus Notes
Copy excel cell to webform (search box) and press enter
How to add straight line from cell value in pivot table chart
Excel VBA help: Text file formatting
Dynamic Offset from an Application.Goto cell = Date or Time
Need formula or VBA code to find integer
Change_Event target either of two cells
Expand and collapse
Column number of last column that returns value ignore formulas
Using Regression Function in VBA Macro
FTP using CMD via VBA
Code to name numerous ranges
Counting Bordered Cells
Code rounds to whole numbers, need it to stay with decimals
Find dupes, list in MsgBox with cell.address convert ws wide code toone sheet
Combine three InputBoxes into one?
Read a range into an array
Code Enhancement?
MultiSelect Listbox Question
Adding Worksheets to a Workbook using a MultiSelect List Box
Ribbons depending on ActiveSheet
Large Model Question
Macro for all Excel Workbooks to print to PDF
Deleting specific information
ADO left join count matches
Search an array of sheets for an array of numbers & return count of numbers
Auto Copy Data from one worksheet to another
Weird Behaviour of Compiler Directives?
Placing the MsgBox "No ID found" statement in my code??
Prgrammatically added OLE Listbox, now cannot select from it
Cell Toolbar Dilemma xl2013
Re: 'Save as' dialog opens despite Application.DisplayAlerts = False
Array with many cells from a row but not in order or together
Code character limit with Resize or Transpose or cell?
Vlookup Function
Excel - Cross Check
Default browser?
Get a color name from any RGB combination?
Trying to calculate next sequential number using multiple columns
Junp start my Select Case Macro
Ubound for variant not working for some reason, can anyone see why?
CSV files and having numbers and strings in there...
Reference named range in closed workbook
Where am I going wrong? Cells reference to a range appears to havestopped working!
Code to Resize a variable number of rows including target
Paste a range and shifting away existing data
Color Scheme
i to = column in Formula
Excel 2013 Merge Data
Macro Error
To protect user's privacy
Limit occurrences using VBA
Command for calculate except datatables
How to merge multiple .xps file into one via VBA Excel?
Binary and
modified date of the file
Inability to add quotation mark around a variable by concatenation in VBA
Second run of macro hangs on .show of application.filedialog object!
Curious string error in named range automation attempt - just doesn'tseem to make sense!
Re: adding scroll bar to a chart