Excel Help [Archive] - Page 138

Generate Shapes, Align, Group, Cut and Paste
Macro to find and replace based on different text within one cell
Web query Looping from table selection
[SOLVED:] UserForm that Stays Visible on Screen When Scrolling
Compare data from two workbooks
[SOLVED:] How to check if value starts with text
[SOLVED:] ListBox_Click event fires without clicking
excel help
Macro to copy values from one sheet to another based on specific conditions
Reference specific text strings despite being repeated elsewhere?
[SOLVED:] Macro to delete all rows between two different text stings in column A
Problem with copying the text format.
How to execute a VBA program and halting another VBA code till the old program ends
[SOLVED:] Very omplicated calculation of hours worked (PLEASE HELP)
Redim Preserve Change LBOUND
How to insert a formula in a dynamic range using VBA
[SOLVED:] VBA - Change code to work on whole workbook
[SOLVED:] Difficulty using KeyPress Command
need a vba code HELLLLLPPPPPP
How to generate Sum formula in excel
Populating a Cell with a Table
[SOLVED:] Type Mismatch Error Confusion
Checkbox make values to textbox
save and close an excel sheet when I press the Windows + L buttons
Problem between macro event and SpinButton
Unable to get pivottable property of class
Saving Screenshots in excel
Select number of rows based cell value
VBA VLOOKUP
macro prompt?
[SOLVED:] Run-time error '445' - Object doesn't support this activity
VBA Macro Help - Extract from Multiple Closed Workbooks
Import particular data from book1 to book2
Help with text file row count - only want the last 13 rows
[SOLVED:] Sum Up Cells Value When Specific Value Match
Userform with changeable headers/ listboxes to opt for creating reports from Excel DB
Selective listing of files in a folder
copy filtered data into different worksheet
[SOLVED:] Load data from TXT to Excel sheet (numbers with decimal get like text)
Macro Help - Pasting
vba code To Save Copy As Cell.Value
[SOLVED:] Find average of all values between two index match values in table
Sleeper: Need help with my code as it doesnt seem to be appearing
Avoid duplication in copying
Combobox from external database, not working
invalid or unqualified reference
Color Code Data According by Categories
Using a barcode scanner with Excel
filter multiple columns simultaneously using Vbscript
[SOLVED:] Accessing Excel Tab data from Button
A variable SUM formula in excel
Excel 2013 Macros Click-Activated Shapes
Writing to a cell in a loop
Help with the meaning of this code
Macro to remove marker line and border
How to find and use the maximum value in VBA code
[SOLVED:] Can I use an excel sheet to calculate in a vba program?
Convert Table to Calendar (Wincalendar functionality)
Creating a form to filter data?
[SOLVED:] HELP ON FIND/REPLACE
Checking Excel background image with VBA
NEW TO VBA...Need Help..driving me nuts
Excel formula help
course analysis from bitcoins with VBA
Advice needed to speed this code.
I need to count the amount of weeks a piece of text has appeared since last change
Hyperlink to specific sheets in workbook based on drop down selection
Macro to pull outlook info based on excel values
Join Error
[SOLVED:] How to export variable from textbox into a cell after clicking on a button?
VBA excel help
Sleeper: Merge worksheets
How can I refresh a webpage in VBA before downloading it?
Need to copy from all sheets from all workbooks
VBA code to copy / paste values only + auto change cell value
Runtime 1004 error
Save As Help
[SOLVED:] How to extract date range into multiple rows?
Why is the default value of UserInterfaceOnly False?
Macro To Add DSN
Procedure Too Large
[SOLVED:] vba or formula to find number of duplicates in a range
Why is the sub or Function not defined for the following code
[SOLVED:] Help Needed! Macro to pull if cell does not equal criteria
VBA matching, data manipulation across different worksheets
[SOLVED:] Filter and copy to WorkSheet help
New VBA Code
[SOLVED:] Applying a multiplication by macro on a column
[SOLVED:] Problem using keyPress command
Populate vlookup formula 1Million item
Auto updating of worksheets in an Excel Workbook
Last entry in a Column
Percentage covered by values using VBA
[SOLVED:] Pivot Table Grand Total
VBA Current region minus header and last column
[SOLVED:] Creating Sheets from Cell Value IF Only!
[SOLVED:] vba to loop through multiple worksheets and paste specific data based on a date
A day longer than 24 hours
[SOLVED:] Can this Conditional Formatting Code be simplified
Creating indivisual diaries from master rota
Hyperlink from a cell in another sheet. Not quite working for me.
[SOLVED:] Macro for copy/paste values for only that row where the change is made
VBA macro to hide rows based on cell value
VBA to Find & Fill a cell based on row & column headers?
IE WEBSITE FILE UPLOAD
VBC Excel to find latest creation date zip within folder, then open CSV file embedded
Auto Data Display by Scanning. Please help
[SOLVED:] Using Userform with Date Picker to Select Data Range in Excel
Lable the last know person to entra data to a cell from a list of names, populate dat
[SOLVED:] Easy If-Than code for comparison of multiple values doesn't return correct value
Textfile loop to find/replace characters
Save as Types
Pivot find and replace
[SOLVED:] Types inside a Type
Spreadsheet Consolidation based on specific path
[SOLVED:] Help needed with VBA to auto insert pic into comment
Remove string in text files
[SOLVED:] Clear multi - select Listbox
[SOLVED:] match delete vba
VBA - Auto Select Sheet, Save & Close after 1 hour
[SOLVED:] Vba find and replace with loop
[SOLVED:] Excel Loop WITH Function
[SOLVED:] Preserve exact formula, monthly analysis for full year
VBA to Search both Email subject and/or Email Body in Outlook
Intermittent errors after running macro varying number of times
Macro wont work with a cell which is updateing by formular
vba help
VBA wont run unless through the editor
[SOLVED:] Error when using variable when connecting to SQL from Excel
hide rows based on highlighted cell in column
Copy and Paste based on cell value
ODBC connection if not on users PC
Is it possible at all?
Using Range.Find to search another Open Workbook
[SOLVED:] What is wrong with my VBA code?
[SOLVED:] Several If statements inside For Loop
Embedded HTML Image Issues
Combining parts of 3 workbooks
[SOLVED:] If range contans "0", mark as incomplete
Values lookup in two different tables
[SOLVED:] Empty Row Deletion
VBA to Add 3 Aligned Footers with Custom Formatting and Text
Order Assignment Problem
Directing SendKeys to the Correct Application
Help -needed call named range based on cell value
What Do You Think About This?
[SOLVED:] Excel Book Recommendations
[SOLVED:] Clear activex listbox selection
[SOLVED:] Goal Seek without Cell Reference
Compares different rectangular areas and highlights equal values
VBA
[SOLVED:] pulling data from a csv file based on specific dates
VBA Cloudera Hadoop connection
Merging PDFs and Allowing for Filling of Adobe Fields
[SOLVED:] Help Understanding Code
Different references for same formula (more complicated than it sounds)
Put Excel image to PowerPoint in specific location?
SUM of Values by Region and District
Copy Multiple sheet as SaveAs
MATCH VALUE FROM TAB2 and UPDATE TAB1-CONDITIONAL
VBA: adjusting pivot table per macro
VBA to collect data from Pivot
[SOLVED:] How to connect to a RECORDSET
[SOLVED:] Loop through URLs, save source
Help with #Value! errors
[SOLVED:] How do I have a cell value displayed on my user form?
[SOLVED:] Apply different format to each column of selection
Counting rows in clipboard
[SOLVED:] Loop through combinations and add only Even & Odd numbers together within each.
Adjust placement of copy paste to suit last row of previous paste
Count texts in two colums and if no match write data
Count number of mondays
(VBA) error adding Title and Subtitle to PowerPoint Slide
Excel 2013 VBA Import Dynamic Range from other Workbook
Setting a range object & applying table style
[SOLVED:] How to replace a path in the code by a variable?
Excel Userform Listbox VBA Help
Enabling Content in access db with Excel VBA
[SOLVED:] Excel 2013>VBA>Function>Sum Visible Columns
VBA code to prompt user to select file folder but still keep the file name...
excel 2016 splitting datasets creating new separate sheets
[SOLVED:] Generate 5/50 lottery combination with selected odd sum or by even sum!!
Macro for copy & paste data from worksheets if path of file changes
[SOLVED:] Assigning values from a table
Display Data from Sheet
[SOLVED:] VBA Loop - If Cell is not empty then....
HELP!!! Fastest code in consolidating columns with different headers
Conditional Formatting not pasting correctly with macro
[SOLVED:] Excel 2013>VBA>Function>Average Visible Cells Horizontally
Using Vlookup to set ranges for Loop, not sure how to integrate it.
[SOLVED:] Do While Method to append data
Generate 3 sets combinations, which 3 sets sum match: to request target sum
[SOLVED:] Copy complete folder to another folder
[SOLVED:] Trying to name ranges over a number of columns
[SOLVED:] Excel 2013>VBA>PageSetup>User Defined Formula>Interference
[SOLVED:] Trying to get a range of cells to show up in my Combo Box
Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed
[SOLVED:] Using wildcards to filter list - help
[SOLVED:] Saving filename exists
VLOOKUP formula with subtotals
[SOLVED:] Excel Margins
Lotus Notes - VBA
[SOLVED:] File copy wont copy to the right folder.
VBA to trigger input box when criteria in data found
Help with Data in Column A and Shift...
[SOLVED:] Move files & folders from one location to another from excel
[SOLVED:] Check if activecell is in a column with date in the header in any table
[SOLVED:] Copy data from excel and paste it in to a word template at different places
[SOLVED:] Schedule code to run at a set time and then at intervals thereafter
Skip first sheet in For Each loop?
VBA -- Call Function Not Running Macros Properly
Help With Recursive Formula
VBA Find and Replace from Excel Range
90% there - Maybe paste as picture instead to esure cond format?
[SOLVED:] Create list of files in a folder and link to them in Excel
Microsoft Dynamics AX
ComboBox lag
[SOLVED:] Currentregion and autofilter Help
HELP!!! Need a VBA code to get a table from a site
[SOLVED:] Date Problem showing as 42463 ?
[SOLVED:] Require total in column B of positive & negative values
Excel Search Function
[SOLVED:] VBA loop to do multiple cut, transpose pastes within a loop, then repeat.
[SOLVED:] Dynamically Copy and Paste
month end variance analysis
Filter A Range And Chart It
[SOLVED:] VBA Array Function - Return Array from Range without Blanks
[SOLVED:] VBA - Filename Checker?
[SOLVED:] Need some very basic help
Search and copy macro with search criteria
Need macro that creates new rows and copies matching info from sheet 1 to Sheet 2
[SOLVED:] Need to change code in bottom line
[SOLVED:] Excel/Word/Access
[SOLVED:] VBA filter
[SOLVED:] Aligning two tables
[SOLVED:] Insert row & total other columns
if unique of column A b c then count ifs
Help with excel and word. Sounds easy, but its not.
Runtime error 13 : Excel vba pivot - please help
Formula getting a cell's data from another worksheet.
[SOLVED:] VBA Code Required
Using VBA to Copy Multiple Workbook Filenames into their Workbooks
[SOLVED:] Displaying numbers in fractions, not decimal (when concatenating)
using array to add 1 hour to column A
[SOLVED:] Delete filter outcome
Run Time Errror 91 when trying to find value
[SOLVED:] Directory mapping macro - need more robust code
Way to reference a number in a cell
Get child ID from parent ID
Elegant Way to Copy Cells from one Sheet to Another - Value only