Excel Help [Archive] - Page 151

[SOLVED:] VLOOKUP and skip blanks
Sheet Not Fully Active after Selecting or Activating
Email userform
Workbook that forces users to enable Macros and automatically closes after some time
VBA code to make sheet uneditable after I save
insert rows and paste in section from a range
Counter sums quantity of files in said folder but doesnt update unless double clicked
Remove duplicated values from 1d string array vba
count up cell value by one and automatically be protected
[SOLVED:] Option Button Value
VBA with Vlookup dynamic
[SOLVED:] Search workbook for worksheet name, IF yes then run code, IF not display MsgBox
[SOLVED:] Subtotal??
Check If URL Returns 404
Copy Cells with Range(Cells R,C). match returning location in numbers
[SOLVED:] Help to get one or more filename from folder in excel and make it hyperlink to it
UserForm has Minimize Button. How do I execute it via code.
[SOLVED:] How to set formula equal to a series of numbers
[SOLVED:] Another Delete Sheets Macro
Multipage Tiff file in Excel VBA Userform
how to check network file through VBA
[SOLVED:] Generating results from different sheet by filters
[SOLVED:] Dynamically populate multiple ComboBoxes
Help about dynamic value table array in Vlookup
[SOLVED:] Comparing two range of cells to find out the number of matches
Export / Save as PDF in specific folder.
VBA Auto Filter
Run-time Error 1004
Generating a Pareto chart based on date
How to combine Selection. PasteSpecial and Selection.insert Shift in one VBA code ?
Win10 + Excel 2016 fail to connect WebDav with ADODB.connection
Copying rows over to new workbooks based on unique column values
VBA SUMIFS Function
[SOLVED:] Passing UserForm Text from One Excel Application to Another
Monthly/Yearly Bills workbook
[SOLVED:] How to open windows folder using double click on a cell.
[SOLVED:] Error on adding validation list
APIs for Hiding UserForm "X" and\or Adding UserForm Minimize (32 & 64 bit)
Using Countif iterating thru rows in a sheet
[SOLVED:] Autofilter with variable criteria & field
Why will my loop not move through different worksheets (tabs)
FIFO-GAIN-STOCK PROBLEM
Ctrl Shift Enter on FormulaArray VBA
[SOLVED:] Array Filtered without Spaces after 1aRow
[SOLVED:] Faster way delete strikethrough
Management weekly report
Unable to use formula in Shapes
[SOLVED:] Print Hidden Worksheets from Userform
VBA error 1004
[SOLVED:] complie error: Expected: end of statement
[SOLVED:] Trying to copy multiple worksheets into new workbooks
code optimization
Get XLA file
Listbox items as Hyperlinks
No Locals Window
Call code when text is in a Range, NOT every time it appears in the Range.
progress bar
[SOLVED:] Message Box Still Appearing When Code Runs Correctly
[SOLVED:] VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row
Error 400
[SOLVED:] Open CSV UTF-8 files (no acces to editing BOM)
[SOLVED:] Windows Folder Creation From Excel & How to Check A Folder Has Not Been Created
vba help
vba to copy and paste each file name
[SOLVED:] Copy Column Table x times and add counter
[SOLVED:] Range Syntax
[SLEEPER:] Multiselect Multicolumn Listbox allow users to add data?
VBA ListBox List - Want only selected columns to be displayed
[SOLVED:] Composing Email using Macro
[SOLVED:] Formula Support Issue
Time Conversion into text
Advance filter help
Find value in Excel from Array within Word
[SOLVED:] Assigning two macros to one shape to run on different actions
Find duplicate values accross columns per row
Making VBA program more user friendly
[SOLVED:] Condensing IF statements
Creating a official form in Excel using VBA!!
Search From a User Form and Display Results in a Worksheet
Macro to move from windows media player to an Excel worksheet
[SLEEPER:] Search for Values that meet a Criteria and Paste Location in a New Sheet
Can multiple Range but not individual cells.
[SOLVED:] Permutation Combination using Macro
different footer for every page
[SOLVED:] Create a production schedule from a different workbook using cell values.
[SOLVED:] Test for Overlapping Project Assignment
insert sumifs with last row based on another sheet
Signature Block on Locked Form - Workaround
[SOLVED:] Mismatch Error
Save a part of the sheet with a specific name
Grouping of defined sections
[SOLVED:] Copy Module to New Workbook
Sleeper: VBA hour calculation over 24h
the body of the vba generated mail is empty
[SOLVED:] calling selected shape help
save selected worksheet as separate pdf file
[SOLVED:] Filtering SKU List to Show Items with Multiple Descriptions Only
Kill Excel after user close userform
Update row cells based on listbox cell value
[SOLVED:] Need help in ExecuteExcel4Macro VBA
[SOLVED:] Transpose Table - Removing Duplicates
Search Replace Offset - substitute
VBA Excel 2013 Prompting users to select a file & retain value.
sieve of eratosthenes vba code explanation
Entering input Data to next available cell in another sheet
vba consolidation of specific sheets data and Pasting in specific Mater sheets
need help writing a code for copy and paste special (values)
Output VBA Code Results to ThisWorkbook
[SOLVED:] Need Help with VBA, True Vs False
[SOLVED:] How to display all hidden rows and columns
VBA Help in Converting text result of Date into Date Format !!
Sort Userform ListBox
How to sort Listbox with Multiple columns
placing different windows on my screen
NEED HELP! Average Duplicates and Print them separately
Excel Data Tables
VBA: compare values in columns and list the missmatches in a new sheet
[SOLVED:] Deleting a row
Application Match error 13
Sharepoint coding
A way to speed up code VBA in for loop with ExecuteExcel4Macro
Adding Formula in VBA ...Need help
Copy paste loop Multiple sheets column wise
[SOLVED:] PrintForm opens a 'greyed out' UserForm1
Deactivate "EDIT" after Digital Signature (or add Password)?
[SOLVED:] 2 Column messagebox spacing of data
Help with a Formula
[SOLVED:] VBA TO Correct Date format
[SOLVED:] Modify line of VBA code
[SOLVED:] Skip Empty Cells or Ones with a Word in Them and Run function
[SOLVED:] How can I print the sorted array back into worksheet?
Drawing two para
Worksheet edit VBA code
VBA: Splitting a big string with no good delimiters
using excel to collect and store data
[SOLVED:] Sumifs? can this be done with a ranged criteria?
Loop for excel functions
[SOLVED:] Change VBA code to fit 64-bit environment
[SLEEPER:] User Form Help
Authenticating Access to an External Database using VBA
Delete out of date rows
Generate personal schedule from overview
Hide Pivot items based on table
VBA separate uppercase words from lowercase words.
Using VBA to import BDH from Bloomberg
Help: "Method 'SaveAs' of object'_Workbook' failed" - Tried different codes, no luck
Help Needed Regarding Linear Interpolation and Extrapolation
[SOLVED:] form question
[SOLVED:] Complicated formula, i'm at a loss
[SOLVED:] Multiple Offset - Insert into
Sleeper: Declare Global Variable - Private Worksheet
[SOLVED:] Array formula - need formula to pick from 2 ranges to use in calculation
Text Box formatting.
Copy Data to Next Empty Rrow
[SOLVED:] HELP FIND HIGHEST VALUE USING VBA
vba - help removing selection
[SOLVED:] Data grouping?
Variable sheetname in formula
Text Boxes visible not visible on user form
Follow Up Question About the Ribbon
Can I Change Textbox Languege ?
Saving a workbook with macros when they open it.
Vlookup #N/A using VBA
[SLEEPER:] VlookUp giving random values instead of #N/A.
Keyword Identification and Changes
capture few columns from xml file
Matching multiple values from different column
VBA-XML-SEARCH ZIP AND HOUSE NUMBER
Using Wildcards
select a range using 2 address and find if range is empty/has data
Copy Ranges between sheets with Cycles
[SOLVED:] Opened/Populated by MS ACCESS, Excel WB can't see cell value on WB OPEN Event
[SOLVED:] Print userform to PDF
[SOLVED:] VBA: Error when range(variant) condists of only 1 cell
I want to find first 0 in column in vba
[SLEEPER:] Pasting a range into an email, while also adding text to body and keeping signature
[SOLVED:] VBA problem: Merge two sheets into one
[SOLVED:] How to find out URL from where on the website CSV data is benign downloaded
VBA code for attendance template - In time & Out Time
loop an excel table to update styles
find a date in a range - exact match
Target Specific Array Elements Group
run-time error "4198"
Get table values from HTML IE website custom generated table
[SOLVED:] Array Prefix & Suffix Methods
[SOLVED:] vba copy active sheet to closed workbook
Creating a dynamic #N/A Filter for EXCEL.
[SOLVED:] sum cells above every blank cell
Using VBA in Excel macro to extract data from table and reconstruct table
Formula help please
sumproduct?
Import Outlook-Taks in an Excel-Sheet
[SOLVED:] Display values based on matching column data
[SOLVED:] VBA macro for data filter and copy
[SLEEPER:] Implementing formulas with variables into VBA
[SOLVED:] trouble hiding columns
Copy paste values from another workbook if criteria is met
[SOLVED:] Macro for moving the columns
[SOLVED:] finding the value and paste in another sheet .
vba help
Pasting an Image Into Cell, Merging Cells, and then Resizing
calculate time difference between cells
[SOLVED:] Problem with VBA code in Excel
Comparing to Excel Sheets based on a Key Column Value - Semi Working
VBA script not working what have I missed
[SOLVED:] Run-time error 53 when moving files
Pick directory and merge 2 files into 1 workbook
[SOLVED:] SUM by colour
Save to PDF
syncing files
Skip a fault 13 with an If code and go on with the macro
Check if Directory Exists
Launch windows powershell using VBA
Multiple Digital Signatures - on different TABS???
[SOLVED:] auto filter and send by outlook
VBA: How to prevent chart / picture / button from moving in Excel?
Calculating Compliance
auto filter on adding rows
[SOLVED:] Loop Thru Columns
Need help to click on ID using VBA
[SOLVED:] Userform: Change Textbox color in loop
Counting Employee hours booked
Move Cells Up after Content is Cleared
Error When Open From Protected View
[SLEEPER:] Macro for data validation with two condition and high-light row
[SOLVED:] Code for a changable range in COUNTIF function
Combination of cells to match a specified cell
Move informaiton based on a match
Co-Authoring Issues - Auto-Updating
[SOLVED:] Printing Multiple Sheets to PDF (Excel 2013)
[SOLVED:] Color Chart Columns by Conditionally Formatted Cell Color
[SOLVED:] Copy paste Cell inside Table under certain conditions 2
[SOLVED:] When I move the cursor more than one cell become highlighted
create Calendar from table
[SOLVED:] calculating time difference
Connect to two barcode scanners
Naming a sheet to the current year
Copying excel ranges to powerpoint
Autofill column B based on dynamic range in column A in multiple sheets except some
Duplicates in named range
Possible to apply conditional formatting across multiple ranges?
Code that adds new appointments to Outlook
Adding a Filter to a Pivot Table Inquiry
copy data from multiple workbook ranges into one workbook sheet ranges
[SOLVED:] VBA to compare multiple worksheets and produce report of cells where data varies
Workbooks.Open - Convert .CSV
Sendkeys and windows 10
[SOLVED:] Summing individual rows, for overall group total
organize data in groups with near equal Totals
[SOLVED:] Combine multiple DIMs into one line instead of separate?