Excel Help [Archive] - Page 123

On Error Issues
Run-time error '429': ActiveX component can't create object
[SOLVED] Is Variable Allocated
[SOLVED] Macro needs to recognize existing filename
Looping through and Deleting data in Pivot chart
[SOLVED] Extracting values from cell where total has been rounded
[SOLVED] Code Not Iterating Each Worksheet
Sheet Reference error
[SOLVED] Tab Button Control
[SOLVED] Formula
Writing a loop with an offset and storing value in code while summing
[SOLVED] Count functions, mostly at COUNTIF() Question
Cant access functions from a VBA add in
Web Service Call and Authentification
[SOLVED] FileDateTime Question
How to apply the colour of a cell to another when its an exact duplicate
Automate copying rows based on counter number increment
Hi there
Strange behavior of for... next loop
'Double' Random Selection in VBA
Efficiency Help
VBA for Import worksheet Selected Range Data from Another Closed workbook
[SOLVED] Diary System - automation
Extract specific data from a website
Read Data From Excel File W/O Opening
Add-in uninstalls after running on a CSV file
[SOLVED] Sending OutLook message no Attachment
Sheet Reference based on a Cell Value???
[SOLVED] Looping through cutting and pasting values between two dates
[SOLVED] Splitting first, middle initial, and last name
(VBA) Conditionnal formatting with multiple conditions
Help! Error whilst record Macro ""Too many line continuations"
[SOLVED] Show userform without showing excel
SQL Server Connection problem
Help Getting Started (New Project)
VBA code finding duplicates in two Excel column.
VBA Code for VLOOKUP
VBA codes to draw charts with data from multiple sheets
[SOLVED] Looking for similar value
Regex expression to retrieve data from HTML
How to make print area fit entire page?
[SOLVED] Fill Userform textbox after clicking in sheet (return column number)
scheduled task & can't create outlook object
Funny Formating
Excel crashing every time I run my macro
Delete all Datalabels on Chart Except Current Dates
Need help improving this VBA Code to make it run faster
New to VBA! Code for a sales calculator, how to output tables to user interface?
[SOLVED] Link to Word document
Macros/VBA to do a loop and insert text
Chart pop up
[SOLVED] VBA Timer?
VBA dropdown help
[SOLVED] Weeks and Months
[SOLVED] Connecting to Access 2010
populating dynamic arrays from a dynamic array
VBA Small Weather Forecast Spreadsheet
Excel VBA Multiple Automatic Goal Seek Required – Please Assist us
Real-Time plus Countdown Timer
VBA for calculations
VBA to run formula on Selected cells
[SOLVED] Help need to inser Carriage return in chart series name.
HELP! application.filesearch wont work in excel 2010
Enhancement of "Find text in Workbook and create link to cells"
[SOLVED] Generating formula for summing time / date values.
Highlight Adjacent Cells Above Highlighted Cell
Clear styles error
HELP - SUMIF more than 3 conditions + operations in the sum
Which copy/paste option
Compiling data questions
Reoccurring Data Transfer
Issue with pictures upload using vba code into excel- they disapear
Change value of adjacent cell if field in form matches
[SOLVED] Failing miserably at populating combobox
Vba to copy excel worksheet orientation to word document
Checking in a Document in SharePoint from Excel Macros
[SOLVED] REFERENCING A VARIABLE FORM NAME
Searching for multiple values in string
VBA script to help sort and distribute data
[SOLVED] Excel VBA - Open Word template and create bulleted list based on cell values
[SOLVED] Scoring data by finding duplicate names.
[SOLVED] Look For Sheets Wildcard no Loop
Opening multiple doc/html files into excel worksheets within a single workbook
[SOLVED] Help with vba Code
TimeSerial does not reflect Windows Regional Settings
Calculating difference between months
Save As PDF in a particular order
VBA Code Help Needed. Lookup Value Ranges
[SOLVED] How to make Todays Date visible on Pivot Table Filters
VBA to stop dsiplaying the debugging option on pressing CTRL+Pause Break
Paste values copied from a webpage
[SOLVED] Find and extract information from multiple excel files
Please help spot the error!!!
VBA-code Import from website to excel
calculate data and find outliers
[SOLVED] Extract numbers from text string
[SOLVED] splitting a range to a variable number
Index Match Match
VLOOKUP with a SUM
Filter dates and blanks
[SOLVED] if find the spicify word copy data
User-Defined Type Not Defined Error
Looping and combining macros - help needed
Almost there: Loop to search website
[SOLVED] Find the last cell in a column conditionally formatted
How to find certain cells and add up adjacent cells
BOM Compare - compare between tow versions of data
formatting numbers extracted with a web querry
[SOLVED] interpolate value Every at Chainage 1750
Search for and extract data from one Excel workbook and paste in another Excel workb
[SOLVED] Count distinct values in an array
Minimizing error to fit numerical data points into categories.
VBA: Workbook re-open after closing
[SOLVED] Move Pivot Table row to end automatically
[SOLVED] Counting Names in List that have completed any one of a Number of Courses
Find All files in a Folder that were created and/or Modified after a set date (x), Op
variations on import vba
Permutation List Code
[SOLVED] Overlaying Shapeor Picture based on contents of a cell
loop to go through a list find an empty cell and then place something in the cell
Find date and return value
[SOLVED] vba to keep the focus on userform last used textbox
Open PDF file after creating multiple pages into one PDF
[SOLVED] Excel loop
VBA help loop search and check status of item
[SOLVED] is sheet selection by variable possible?
[SOLVED] Identifying mixed Managers
Access different tabs in Excel forms
Macro to save in txt format web pages
[SOLVED] Range selection fail when integrating with PowerPoint
VBA, retreive information from a word document and store it in the Excel
keyboard shortcut to copy the url of a cell
VBA code required:Compare sheet1 with sheet2 and copy the difference
[SOLVED] Fast compare values of Non-Contiguous Cells row in two different workbooks
Search a table on a website for a word & extract the 3rd cell to the Right of it.
#Value error msg in VBA code
Formula won't work past a certain date
How to add alternate column in worksheet
Send Macro cell rang as attachment to outlook with default signature
[SOLVED] Cell formating
[SOLVED] SendKeys really working
[SOLVED] Macro to compile a list in another workbook
Setting column number and row number to variables leads to lots of issues
Modifying excel data through VBA
Creating letters quicker from spreadsheet
Hi
Default Cumulative Cost Curve (VBA)
Macro Keeps changing date to American format
VBA - the lowest number not working
Problem solved - sorry
Save as user form
[SOLVED] How to enable macro
MacBook Pro Comparison
Runtime error 462
CountIf Help
scrape excel sheet embedded in an intranet page
Used Opentext command, - How do i select the pop-up Workbook?
Weather Forecast Spreadsheet User Form Help
Update variabel to be = string, specified in a cell?(Splitting a cell and distribute)
Tracking old & new formula changes & other changes w/ links to original cells
[SOLVED] Time/Date Formula for Analysis
Halp! Excel data exporting
Table of content or Hyperlink for different Table Name in work-book
[SOLVED] Summing of sheets macro needed.
Enlarge and restore an embedded chart from a group of charts
[SOLVED] Show in Label value in cell specific column (everey minute)
can anyone see an isue with this line? object defined error
Match words in 2 cells
VBA - importing all excel files in subfolders
[SOLVED] Copying to another sheet.
Return data from different sheets and variated cells Macro
Linking numerical value occurrence to a date
[SOLVED] Loop in VBA
[SOLVED] Find and replace macro bugging out with finding #VALUE!
Calendar not linking to Userforms.
[SOLVED] KB: Group All Command Buttons on a Userform
Automated Data import from website
Vlookup through VBA: Dynamic Range
Excel - Send sheet & use range as body
Export Excel 2010 to Project 2010 VBA adding columns to Project
Create a Stopwatch for time study
[SOLVED] eliminate question mark box when enter key is pressed
[SOLVED] If Condition returns Formula
search rows in VBA
How To Create Macro To Pull Tables From SQL Server
[SOLVED] How to produce two workbooks from a larger workbook
[SOLVED] Current Code works, then when I add a line, Excel Crashes
VBA Code Cannot Access Database In SQL Server
Any 64-bit Office users?
[SOLVED] trouble viewing code
Insert data inside filed form in WEB
Macro to sum between headers
Enable Maximize button and change userform size by manually dragging borders. VBA
VBA - Excel/Word 2007 - Using excel to compile a report in word
[SOLVED] Clean the row if column B to O is empty
[SOLVED] Referencing a subset of text within a cell
[SOLVED] How to search values in external workbook and pull out information from the same line
Find 2 identical values in 2 columns - looking for error message
Run time Error on Save Data
use arrow in vba formula?
Need help with VBA passing an argument
[SOLVED] Clear worksheets from list
Syntax to identify if something does NOT match a Wildcard?
Create individual folders for next day
HELP: How to format certain texts enclosed by specific characters
Excel vba jump to specific row in worksheet
NEED CORRECTION IN MACRO
[SOLVED] Optimizing VBA code so that it can execute on a workbook of 50,000 rows w/o crashing
Need a VBA coding
sortind dates
help me please
[SOLVED] VBA - Determine cell value of specific column and row in userform
[SOLVED] VBA Sorting multiple rows
Various items - exporting to various .txt files where duplicates
Excel vba copy paste with formulas
[SOLVED] Showing help on object elements from a form?
[SOLVED] Combi Box disappearing from the screen.
[SOLVED] Summing of multiple totals.
Combine data from many worksheet into one worksheet
VBA for Page Headers
How to save each change in list in new workbook
Remove Duplicate macro, modify to delete adjacent cell
VBA Match & Copy
[SOLVED] What did I miss? (get constant value from the string text)
Printing Visible Data Only
How can I fill Database with VBA on Mac?
Moving duplicate and unique values from one sheet to another.
[SOLVED] Pivot table not showing the selected items when filter added
Recognizing linked changes, Worksheet_Change(ByVal Target As Range)
Validation Of Names Required from given List :confused
Macros - Upgrading from Excel 2003 to Excel 2010
Help sorting data
User must fill in certain cells before they can close the workbook
allocating the totals - to numbers equally
VBA Creates Pivot Table Except when Row 1 is blank
VBA help: Copy, offset, add cells, repeat, all on one button?
Excel VBA user form
Getting 1004 Error from sorting a range and cannot figure out why.
opening a word document
Syntax to selecting multiple columns/particular column with its contents in Excel VBA
ActiveCell.Offset(1, 0).Range("A1").Select?
VBA Type Mismatch Error on Pivot Table Creation
[SOLVED] Problem Copying two Sheets from one workbook to another workbook
VBA assistance required for copy values
Need Help: Changing Date Formatting, Filter Unique Value, Sort
[SOLVED] Looping Through Calculations
After mail merge code want save as box for Word doc
Disable "Save" & "SaveAs"
Searching for a string and move it's data to different sheets
Action to cells in a specific column of selected rows