Excel Help [Archive] - Page 113

Using arrays to scale up binary formulas
Solved: My seemingly simply code is VERY slow
page setup setting
help with Excel Application.Filesearch replacement
Run-time error '2147024809'
Email most recent file in a folder
Copy cell from named sheet and paste
Solved: strange behavior from special cells
Solved:Macro to delete selected by my rows, columns, cells
Referencing Worksheets through a list
Solved: OnTime events with Userforms
Paste content control text from word doc into excel cells
[SLEEPER:] Hiding Named Sheet
Solved: userform to only accept mobile number
Question on Numbered Month
Solved: Referencing a cell plus its formatting
For each class("addressbox") in html document follow link
Format Functions Excel Add-in
Repetition de de copier/coller avec saut de ligne
write changes in log
Solved: Transfer variable to form
Time Adherence Sheet for Excel
Solved: Left Function on Object
Solved: criterion for cell with formula, and the date on another cell
Solved: 2 dimensional arrays
Vba Code Automatically Sort Rows Large To Small
Code does not pull data correctly at login
Macro Security
Solved: Hyperlink pivot pagefield control - not working
Code won't run on previous Excel version
Solved: Code which formats cells
Solved: VBA VLookup Number return Text
Macro to populate Data from Columns into Rows.
Solved: How to Hide Pivot rows with empty DataBodyRangevalues
Solved: Excel Application.Filesearch
Solved: Copy Selection Paste btw 2 sheets
[SOLVED:] Copy Formulas Down Just One Row
VBA to access website with passwords
time keeps showing as 1:00 Am when it is 1:00 PM
Solved: string with asterisk
Editing a Macro in one file using VBA in another file
Weighted/Conditional LINEST in VBA
Solved: Test Last Row Value before update
Row Fomula entry
Macro to delete rows if criteria is referenced in other sheets?
Cannot test us userform unloaded / terminated
'UserForm Calander Control
Easy Copy paste - Reconciliation macro
Solved: Help with IE loop Automation
Solved: module Excel VBA for manage parking places
[SLEEPER:] Dynamic Chart won't Update
Solved: Worksheet Change...
I need help edit code vba automatically copy of cell
VB help
VB error while running the project
Can One Class Hold Many Objects
generic matrix multiplier
VBA Code Indent
VBA - Activeworkbook.save & Workbook_BeforeSave problems
Give only named users acces
Solved: VLOOKUP Syntax in VBA Using WB w-Dynamic Name
[SLEEPER:] Run-Time Error '5': Invalid procedure call or argument
Password Protected userform
if statement
Excel to Word Insert Table Help!!
Conditionally format Pivot Table cell color base on value (text)
Prevent deleting worksheet
determine the unit for left margin (Excel 2003)
Visual Basic Out of Memory
Popup Message when Specific Text Selected in a Range
VBA code for Alert Message and highlight duplicate
Solved: Open Password Protected Workbooks in VBA
Loop cycle not copying and pasting correct cells
Solved: Delete entire row if cell contains string data on Cloumn A
Solved: generate a Code from Column A and B
Help formatting text to columns using VBA
Solved: VBA to find a value and copy values from sheet2
Connecting to database from macro
Solved: Need help with setting a range to some text.
Solved: Combinging AND and OR in Nested If Statements
Solved: int() does this weird thing. Can someone explain this to me?
Save the modification
May be MID and Find function
Solved: How to test formulas results?
[SOLVED:] Reconciling data using a VB Script
Macro creation
Textbox expand horizontally
Formatting a cell based on 2 cells.
Solved: Copy Values from Information Tab to Main Tab
Searching folders & subfolders from root for specific file & copy that file
insert 3 blank row if find a string data on column A
Solved: How to edit field values in ADO recordset ?
Opening a New Instance Of Excel
Auto Update (without clicking on scrollbar (on worksheet) every second!
Sleeper: Code is not copying correct cells
help save worksheet to new wb
Tick Mark
VBA to append 0000 to string dependent upon state
Combine print with dynamic print areas
[SOLVED:] save certain sheets as a pdf from a closed wb
Multiselect listbox values to a textbox
VBA code to delete certain rows.
Solved: Counting by Vehicle number
1 Userform and 60 ComboBoxes
Today's date and following 6 working days
Solved: multiple font colors
VBA to record the field settings of a pivot
Creating Pop-Up Calendar: How to do in Excel 2010?Hi, I've been researching into add
Delete the dash from first and end of cell
[SLEEPER:] VBA code to search XPS document
VBA or Possible with Excel Functions ?
Copy Range Based on Condition
ExecuteExcel4Macro(String)
obtain current SSID's
Solved: Non-Continuous Range with Pivot Table
print userform
[SOLVED:] Simple Printer Control
[SOLVED:] SQL query format
Problem with the VBA code to copy cell and paste in new workbook
Populate Excel Template from another worksheet
Solved: Selection reference
Solved: Name #? error
Solved: Delete Column that do not have headers "XYZ"
Solved: Another countdown query
[SLEEPER:] Prevent Copy & Paste From Overwriting Data Validation
[SOLVED:] Just Keep 1 Row for each Account
Delete ** in end of each cell of right
For loop help
Solved: VBA "Lookup"
Calculate between two spreadsheets
Send outlook
To Compare two cells in row and insert column
Solved: Help with comparison please
Solved: Convert file
vba for replacing the charater in cell
Solved: Pivot Table Is Not Consolidating
VBA query to SQLServer 2012 times out - Solved
VBA web query java Timer with limited time
Recursive Procedure/Function Caller Tree
With Selection.Format.TextFrame2. Run Error
calculate only when macro has been enable.
Solved: Time as string with decimals?
Reference #N/A
Subtract adjacent values based on a condition
[SOLVED:] Create a Table Using Listobject without Generating Autofilters
Improper Drill-down format
Sum get error
[SOLVED:] Range Concatenation Help Needed
Sleeper: Screen scraping
Solved: Formatting help
Solved: Copy From One Sheet to Another
Better solution for stock charts
Solved: How to let Excel "monitor" for opening or closing a random file?
[SOLVED:] Creating Index Items with Dynamic Hyperlinks to Cells in Workbook
Solved: VBA to update source data for excel charts
Trying to save on computers with different FileFormats
Copy col help
Evoid Registering with duplications
If row 55 is not on page 1, then keep reducing the bottom margin by 0.1
code_montecarlo
Solved: excel 2013 conflicting with 2010 vba
Solved: Writing in any cell in the range and check the remaining sheets replay
Change tab colour when condition is met
Insert CheckBox to a SubItem of ListView Control
How to get around userform inability to "remember"
Update Progress Bar at EXACTLY 1 second Interval
Solved: Add an Auto increment number in blank cell in column A
VBA programming assistance
[SOLVED:] Update Cell Value Based on Match to Outside Workbook
Empty Fields
Solved: Clearing Value in ComboBox
SQL Select *
help find target !!
Solved: worksheetfunction.vlookup
Solved: Output of DOS command to excel using VBA
Solved: Split 2 Column to 2 columns with 85 record
fitler by keyword
Work on table while filtering
[SOLVED:] VBA Copy data based on name & paste into workbook w/ named tab
Copying values from a dynamic range
Calling DLL function from Excel VBA doesn't return value
Help with VB code please?
Solved: Find row above and below searchvalue, VBA
Solved: Convert time
Data Validation List Macro
Finding a specific text string within a cell
Help with SendKeys
Copy,Paste,Transpose in VBA loop -Thank you so much!
lock autofilter range or autofilter part of range
Having a problem debugging using SendKeys
Encrypt a worksheet in a workbook using VBA
delete the duplication value between 2 WS
Solved: PIVOT FILTER
Coding not works sometime
How to access a Checkbox in a ListView per row?
[SOLVED:] CLearcontent or delete rows: Keep proper count of used row
[SOLVED:] How to format differently 2 parts of same string?
[SOLVED:] excel automate copying cells from row
Populate Listbox in "alpabetic order"
Small VBA program - fast
Date format problem
[SOLVED:] Autosum error
[SOLVED:] Subtotals
Solved: Unlock Row If cell Equals Specific Value
Help with Loop
Character symbols for file types
multiple condition if statement
[SOLVED:] Reference to same word in excel
VLook Up with Multiple criteria
How to Link 2Combo Box select Date and Cell name
[SOLVED:] VBA Code or Forumula
I need help secure a workbook with a password
Creating an Object Model
Solved: Read Sheet name from a Cell
As Integer datatype allows fractions
Sumif to VBA
Solved: VBA to go the sheets specified and run the macro.
Project Analyzer - Procedure call tree
[SOLVED:] Could this be a buffering problem?
Solved: 5 small subs into 1 sub. HELP!
Unable to set visible property of the pivotitem class
How to test Querytable connection before actually executing SQL query
Excel add multiple radio buttons
Capturing Data from a user form
Basic: Copy-Paste Data using xlDown multiple times
Date format,crosstab in SQL statement
[SOLVED:] Row Number of Cell
Excel 2010 Slicer selection range
Solved: VBA logical test
VBA not doing Mathmitical calculation when its ran
Solved: Allowing time for the SQL query to fully run
[SLEEPER:] VBA to ungroup only selected values
VBA to collect internet search term hyperlinks
Solved: Extend selection to next three cells
Solved: Conditional Formatting: Copy Formats
Building a formula using VBA
working with ranges in custom function
Stopwatch In Excel
Solved: extract row from multi row range
Message box pop up for command button
Complex-ish macro including averageing and choosing-data-by-identifier
Does not work if there is only 1 entry in column, works for more than one enteries
Solved: How update tow Chart after import by VBA finish
Solved: AddIn - Unhelpful Error Message - please illuminate!
Loop Issues
Break Text at First Space Before Char 75, Insert Line and Move Char 75+ to New Line
Solved: Pivot Chart Help
Macro to print chart
Is there an Easier way to do this? Sum Sheets based on Name *
connect to the Internet with a click of a button