Excel Help [Archive] - Page 128

VBA excel access sharepoint slow connection
[SOLVED:] Loop through active columns and save to file
[SOLVED:] Simple syntax problem
[SOLVED:] Deleting all subsequent duplicates below first one in sorted list.
[SOLVED:] Use one cell to create a variable number of rows on a different sheet
using conbo boxes to populate data into text boxes
run time error 91 "object variable or with block variable not set
[SOLVED:] Emailing from Excdel only rows with data showing
macro to remove numbers before first alphabet in a cell
smart vlookup
[SOLVED:] Ofsetting Cell by 1, 0 vba
Search No. & text list
[SOLVED:] Sub-Procedure or Sub-Routine....??
Macro to copy column from multiple files to paste to one file
Function with FOR loop
[SOLVED:] add/insert data validation cell to if column value to left is a number
[SOLVED:] AND and OR formula into an IF
importing specific event log data into workbook
How to copy cells to same place but in another document?
[SOLVED:] Timer please
fullscreen userform
[SOLVED:] Sort current usded range
OCR by MODI via VBA Macro in Excel / Runtime Error -2147417848 (80010108)
Sendkeys not working - trying to copy dated data
Using Record Set in loop
[SOLVED:] combine data from 2 workbooks with matching cells in different locations
Counting files in a folder
Object variable not set
Copy Paste hide columns of Filtered data
[SOLVED:] Creating Functions From Formula
[SOLVED:] Modify code a bit, (combine function)
[SOLVED:] Select certain files with statement (combine files)
[SOLVED:] How to match two filenames?
Subtotal and Label Specific Data Sets
[SOLVED:] need to open file if file exists then merge
[SOLVED:] Minor formatting issue: allow capturing a (.) full-stop as decimal
VBA Copy cells paste +1 column
[SOLVED:] problem with open file Run-time error 1004
[SOLVED:] How to COmbine two files with this code need to modify
[SOLVED:] need help with combine files
[SOLVED:] Change SQL Query Syntax
[SOLVED:] Writing a sub, using arrays, to join information on two worksheets using VBA
Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2
[SLEEPER:] Transpose Script not copying one specific field
Format user input from inputbox into a lap time
VBA Code to Move row if criteria to tab within same Workbook
Macro to save book with diferent name each time ran
code sequence works manually but not as a macro?
Display VBA assigned values
[SOLVED:] Problem while open file script
[SOLVED:] Change value of a MS Word ActiveX Checkbox
[SOLVED:] Import script help.
[SOLVED:] Excel CF help
multiple comboboxes
[SOLVED:] automatic variable names
Activate Combobox dropdown when cell selected, not when doubleclicking
Add new Row (table)
[SOLVED:] search for the keywords and copy paste to another sheet
HELP... How to copy paste tabs content to another excel in the same order of tabs
Automation help with the current code in VBA excel.
Sleeper: Exit/hide combobox when item in dropdownlist is chosen
[SOLVED:] UF Reflect Sheets & Future Sheets
[SOLVED:] VBA to match data in one file and copy data to an existing file
Run Macro when a character is entered
[SOLVED:] Consolidate a table with keeping 3 column criteria
[SOLVED:] VBA msgBox executing before the previous line of code
Creating user names & passwords to an excel workbook and restricting the view of data
[SOLVED:] How do I automate color coding the highest performers on a chart?
How to bold values that are less than the average?
Combining All Worksheets of all Workbooks into one Workbook
round to even calculation
Combining Rows
Conditional row formatting based on multiple nested IF/AND statements
Assistance with a formula to return values based on time
[SOLVED:] excel UF link to Accesd DB
If Not Like - Checking string for date format
Excel VBA - Hide cell values based on ComboBox selection
Split Worksheet into separate workbooks
Need to transpose data from rows to columns
Userform to check 2 textboxes for duplicate & date check
Possible to create a link/macro to copy cell contents into an intranet page in IE?
[SOLVED:] Colour cell based on dropdown list
[SOLVED:] Vba code to transpose specific range of data from column A to another sheet
[SOLVED:] How to compare data in a spreadsheet and paste matched values in another sheet
Copying data from multiple worksheets to one summary sheet
Filter data based on the date provided by the user
[SOLVED:] [ASK] Excel VBA for multiple files in folder
Option buttons inside frames within a userform disappear partially when scrolling
Button for every sheet one new email
Return query from access to excel combobox
[SOLVED:] Count numbers in a string and add numbers together
Improving VBA code
[SOLVED:] Delete Duplicate Data
[SOLVED:] VLookup with VBA
Highlighting Duplicates in Excel that are not a perfect match
[SOLVED:] Returning a value in the textbox on the form
[SOLVED:] I need a Conditional Formatting formula
VBA code to copy data per month to another sheet
Refresh autofit row using VBA excel
[SOLVED:] [ask]split text with comma to new rows
Pivot Table: VBA code to filter dates based on a date in another cell
Help automating the macro
[SOLVED:] Match first column sheet A with first column sheet B
Having trouble with a VBA double loop iteration
[SOLVED:] VBA To Determine Row label reference values in Pivot Table
[SOLVED:] Remove the Index References table and continue to show the CF
create folder if does not exit
Copy cells in loop
Array (25rows x 6 colomns) to be filled with random numbers with rules
saving pdf file of the specified range
Formula excel Combining to cells
[SOLVED:] Adding range values to email
Excel - Sort data after report refresh and certain cell changes?
[SOLVED:] How to put Cursor in text box and move to next text box?
[SOLVED:] working code inside - need to add a delete the row after the data has been copied
[SOLVED:] VLOOKUP Workbook Reference Asking For Data Updates
[SOLVED:] Network days in VBA Calculation
Selecting dynamic range in Excel VBA
[SOLVED:] Copy a block of lines/rows and paste to another worksheet
Mismatch error
VBA Download File From Link
[SOLVED:] Setting ranges that could change in VBA
Private Sub Worksheet_Calculate() - Not running when workbook opens
Decreasing time by 1 hour
Compare values between 2 tables
[SOLVED:] Dynamically modify Chart source data?
VBA Macro Summary Sheet
"Subscript out of range" ... Issue
How do I mark my post as 'SOLVED'?
Help with worksheet and workbook objects
loop through cells
Create a dialogue prompt to filter down data?
[SLEEPER:] Run-time error '6': Overflow
Multiple Pivot Generation
[SOLVED:] Exporting Data to .txt - Need Help Setting Directory!
Adding a search box to an Excel sheet using VBA (very novice)
Running Macros in other Spreadsheets
[SOLVED:] Hide rows based on multiple criteria
Specific Sheets Very Hidden
variable counter
boolean variable
When/why does the VBIDE remember/forget its window state/position?
Select Cells based on values in another cell
Combobox from one form filters another combobox in another form
Transfer data from one list box to another in a userform
Add Chart to constantly changing stats table
Day/Time difference VBA
Userform Filter Search
Exel Power View worksheet
[SOLVED:] Is necessary "Set Object = Nothing"
[SOLVED:] Print Array
[SOLVED:] Date value error, need help
[SOLVED:] Help, loop finds overlaps, then adds not overlapped items, but misses the first match
[SLEEPER:] Re-indexing Excel Sheets
[SLEEPER:] Scatterplot Illustration Help
[SOLVED:] Vlookup a text and MsgBox it thanks to VBA
VBA UserForm: Updating Existing Data
2nd time a freefile is opened, exception is thrown
Saving information from the user form
Run Java code for web page via VBA
[SOLVED:] Preserve line breaks when inserting/pasting into a single Excel cell
[SOLVED:] copy cell value from one workbook to another based on two criterias
[SLEEPER:] Importing all outlook folders to excel using VBA
Pasting a function to be in edit mode in a cell in excel
Multi-Dimensional Array Sort
[SOLVED:] regular expression in excel
[SOLVED:] Go To Previous Worksheet / Go To Next Worksheet {Problem}
change code to incorporate other textboxes
adapting number code to incorporate () - -
[SOLVED:] Make specific text bold in cells
Saving Excel 97-2002 file to Excel 2013 warning about Script Objects
google translator vba code stop working
Converting an Excel macro to run from Word
VBA macro to delete all empty rows and columns
[SOLVED:] Toggle cell value on single click
Challenging VBA Web scraping coding
UDF To Concatenate
Closing a program without killing other workbooks / "Wait please" pop up window
[SOLVED:] filling combobox's issue
Fill Online Application - Acknowlegement number not generated
Delete row with same ID but if found B2B-111 in column C of that ID.
To Trigger an Event based on Certain Time and Certain Date
[SOLVED:] How To Write A Macro To Compare Active Row With Specific Columns In Above Row
Colour pattern matching
Hire Help
[SOLVED:] VBA FollowHyperlink
userform not behaving properly
Tidy up old verbose coding
[SOLVED:] Worksheet change code
[SOLVED:] Add password to togglebutton code?
How to Optimize 6 nested loop coding in VBA.
ListBox size issue
Save As button using VBA Code
[SOLVED:] Preventing VBA converting cell value to date when printing as .txt
VBA:comboboxes to present same date in different formats...ADAPT WITH CHANGE IN DATE
[SOLVED:] Simple Date to Text Conversion
Download files from URL, unknown file names
Need to match every reference in sheet 2 column A for a match in Sheet 1 Column A
3DES encryption using VBA
[SOLVED:] Transpose Nested Data
[SOLVED:] HELP -- Hyperlink Question
Prevent user edits to a workbook without making the workbook dirty
[SOLVED:] help needed with Vlookup and IF function
[SOLVED:] Else without If statement compiling error
[SOLVED:] Method 'Open of object 'Workbooks'Failed
Auto fill Cells Down if other cells have information
[SOLVED:] Running multiple VBA functions within one sub
GPIB to USB Controller
Quick VBA Rows Question
How to concatenate ComboBox name
VBA old test question help
VBA to override all upcoming code for certain users??
Help switching between two images
Import MS Project to Excel 2000
Delete row based on 3 conditions
[SLEEPER:] Help Calculating averages based on options selected in user form
Using worksheet function randbetween for non-contiguous number ranges
Use SaveAs to create new workbook
Help with Importing Part of a text readable file into Excel worksheet via Macro
Use ShellExecute to do a programmatic string search in an opened PDF file
[SOLVED:] Using VBA to rename files - from Auotgenerated microscope to multiple array location.
[SOLVED:] catching malformed data before sub runs
Putting a Variable into a formula
[SOLVED:] Extracting data in "Treeview" from web using VBA
How to email a pivot table using VBA
[SOLVED:] Macro to update columns depending on row identifier
[SOLVED:] Software Library from .nessus files
Lock Cells after date passed - VBA Code
MACRO or VBA Required
[SOLVED:] My filter by Invoice number skipping part of code
How to catch the duplicate number in excel
Vlookup in vba for dynamic range on data
Userform Help - Adding more than one record.
Audit Log - track changes to all cells in a workbook
Model cell colours
Need a formula to show the cell coordinates
Copy random numbers and sort.
VBA to do something 5 times then go back
[SOLVED:] Need some help pls. How to color cell A if cell B is an even number
Loop through worksheet and create a new column based on cell values in another column
Extract string from multiple files using vba
Need help with homework problem
[SLEEPER:] Need help with this review problem
[SOLVED:] Store individual cell contents in arrays, match terms and highlight when found
slowdown in performance when I write the result of the macro in cell
VBA Error Referencing Spreadsheet
Tool to automatically feed database