View Full Version : Excel Help
	-  To be sure looping through all the rows
 
	-  Looping through rows by colomn name?
 
	-  Change font in cell based on value
 
	-  20 Second Wait tied into a Progress Bar
 
	-  excel2k FormatConditions question
 
	-  Problem with printing data from sheet to another
 
	-  Need differnt cell format from pivot table
 
	-  Solved: ActiveCell is current/horrible solution... need fix
 
	-  Solved: Hide/show column base on checkbox caption
 
	-  Yes/No Validation List with One Condition
 
	-  Deleting Blank Rows using VBA
 
	-  Finding Last Empty Cell
 
	-  To validate date format in Excel
 
	-  Solved: COUNTIF with multiple criteria
 
	-  finding the wordwarp charactere ?
 
	-  If Kill help
 
	-  Lost Password for Sheet Protection
 
	-  Hide all userforms that are open
 
	-  Solved: How to Detect a Time Entry
 
	- [SOLVED:] Setting Value for Checkboxes
 
	-  How to return an array from a function ? And handle the result after ?
 
	-  Solved: spreadsheet formatting problems
 
	- [SOLVED:] Keep track of value from another sheet base on time
 
	-  Password creation
 
	-  Solved: Two Passwords (User & Master)
 
	-  Generate list of dates
 
	-  navigate with scrollbar
 
	-  Solved: Open VBA Project from Excel Button
 
	-  select last sheet added
 
	-  VBA Code Delete Row
 
	-  Call macro pending on value
 
	- [SLEEPER:] What is wrong with this If statement?
 
	-  Solved: Why doesn't the dialog disappear
 
	-  Validating set of entries
 
	-  Solved: length of array
 
	-  Solved: Passing Worksheets
 
	-  Solved: userform not catching up
 
	-  Solved: sumif in vba
 
	-  Solved: AutoFilter Question
 
	-  Macro Adjustment
 
	-  Solved: Combine text data from 9 cells into 1 cell
 
	-  need help to get list
 
	-  VBA Open Dialogue Box to Select Multiple Files
 
	-  Solved: SQL error
 
	-  Night vs day working hours
 
	-  Solved: Import Multiple Tables
 
	-  Spreadsheet in dialog
 
	-  want to find max time & min time
 
	-  Disable menus / toolbars
 
	-  Question from a rookie VBA user
 
	-  Solved: parsing text & combinations
 
	-  Excel in Word
 
	-  Solved: Eliminate prompt
 
	-  Resize button control when clicked
 
	-  Pivot table to org chart
 
	-  Delete Rows from a Range
 
	-  Solved: better Array support??? to avoid Dim, ReDim, Preserve etc
 
	-  Error if file exists
 
	-  A quick copy/paste question
 
	-  Drop down data validation list
 
	-  Solved: Run two macros from one button
 
	- [SOLVED:] SQL JOIN error
 
	-  Solved: Question regarding Filter function
 
	-  vlookup error?
 
	-  Format Cell by Left Click- On and Off
 
	-  Automation Error?
 
	- [SOLVED:] Using two values from a list box
 
	-  Solved: check for empty cells
 
	-  Importing an excel file into a template excel sheet that will enable automation
 
	-  Solved: Copy and Paste to an Active Cell on a Different Worksheet
 
	-  need loop code
 
	-  copy excel to word
 
	-  heybd_event  Info
 
	-  Sumif and Sumproduct According to Multiple Criteria Function
 
	-  handle to IE to populate data
 
	-  Saving data to Access databse
 
	-  Cell Formatting VBA Help
 
	-  Help: How to pop-up plot point description when mouse cover
 
	-  spreadsheet 10 control
 
	-  Sleeper: Updating values in worksheet from CSV Files
 
	-  row and column headers
 
	-  Advice: Determine Excel in Edit Mode
 
	-  Forum Rules and HTML Help
 
	- [SLEEPER:] Newby-Putting together price build up for quotes
 
	-  Solved: Count unique numbers
 
	-  Solved: Copy and paste worksheets to a new workbook, minus the formulas
 
	-  Solved: NUMBER STORED AS TEXT
 
	-  Expand a financial statement
 
	-  Solved: Verify pre-requisites BEFORE running macro
 
	-  Copying,Pasting,Looping, Confusing!!!
 
	-  Check to see if add-in installed
 
	-  Multiple Cells Appear Active
 
	-  Solved: Pivot Table problem
 
	-  Org Chart problem
 
	-  Solved: Passing listview control value
 
	-  All charts in same sheet
 
	-  Last Row
 
	-  Solved: Mapping cells from column to column with UID?
 
	-  Solved: Need help modifying this code
 
	- [SOLVED:] Error in Sumproduct
 
	-  Solved: Help with VBA code
 
	-  Application.ontime discover
 
	-  Open/Activate other Excel files from one
 
	-  Open/Activate other Excel files from one
 
	-  multiple workbooks with application.ontime
 
	-  EXCEL VBA
 
	-  Someone can help me out with writing a simple function??
 
	-  Resize elements of an org chart
 
	-  Dynamic Name Range in chart code
 
	-  excel to access w/ vba
 
	-  send email
 
	-  Solved: Sum If I think
 
	-  Solved: HELP me figure out how to use the formula commands
 
	-  How to copy many values...comparing with smae values
 
	-  VBA to copy .txt file
 
	-  Adjust UserForm Show Location on the Screen
 
	-  Solved: Limit Blinking Text To 30 Seconds
 
	-  VLookup with dynamic Filename
 
	-  Solved: Turning Off Email safety in VBA?
 
	-  Solved: Dialog Sheets
 
	-  Removing Close Button on UserForm Caption Bar
 
	-  Solved: countif
 
	-  Need help with Import and exporting a file
 
	-  count a filtered sheet
 
	-  Solved: VBA Help with Chr(13) problems
 
	-  Solved: macro slows down each time
 
	-  Solved: difference between activate and select
 
	-  Solved: format memory
 
	-  Solved: application.volatile
 
	-  Solved: email recipients
 
	-  Validating a column Head
 
	-  Scroll through worksheets using spinbutton
 
	-  Solved: Can a Constant be used as function parameter?
 
	-  Solved: Drop Down Menu to Display Other Sheets
 
	-  Function for validating a column name and length of entries
 
	-  Combine array with lookup in VB
 
	-  Solved: set reference to addin using code
 
	-  KB Article not running
 
	-  Solved: Copying non-sortable data into a new location in a new order
 
	-  Remove formula / Hardcode Data
 
	-  Printing All File formats using VBA
 
	-  Solved: multiple subtotals problem
 
	-  Search Criteria in User form (VBA- Excel)
 
	-  Interface Error
 
	-  Solved: 2003 Excel Listbox ? saving multiple selections
 
	-  Checkbox code
 
	-  Color Worksheet Tabs
 
	-  Solved: What is the mistake in this code
 
	-  Read current .Find Method settings
 
	-  peraphs impossible... order line base color...
 
	-  Open a database using vba
 
	- [SLEEPER:] Row VBA questions.
 
	-  Find Function Fail on Three-Four Letter Words
 
	-  Axis feature: how to switch off "crosses between categories"
 
	-  how to automate geocoding & maping
 
	-  Application.FileSearch query
 
	- [SOLVED:] Select all workbooks and Global FIND/ REPLACE
 
	-  Solved: Range Copy problem
 
	-  Solved: Alter code for macro to all worksheets for duplicates
 
	-  Disable Save from Ctrl S
 
	-  How to determine that category axis is related to time?
 
	- [SLEEPER:] Page Break Help please
 
	-  Solved: Filtered results to userform listbox problems!
 
	- [SOLVED:] How to quickly count number of lines in a CSV or Text File?
 
	-  Need Macro to convert formula to value
 
	-  Solved: Keep date look in the result of a formula
 
	-  What is wrong with my code?
 
	-  Solved: What is wrong with my Validation code?
 
	-  Solved: UserForm Help needed
 
	-  SELECT A EXCEL ROW USING MACRO VBA
 
	-  Need userform to perform search and calculate
 
	-  ComboBox - Highlight default when userform loads
 
	-  Help me please
 
	-  Solved: Find Then Unhide Help
 
	-  Change Tabs in the Ribbon
 
	-  Solved: Help with Chart Lines
 
	-  Solved: Problems calculating static dates.
 
	-  Why Data Validation is not working?
 
	-  Seach Worksheet Names and Return Data
 
	-  Embedded Ppt in Excel Doc
 
	-  Filter Top 3 and display them in another sheet
 
	-  Assign Formula to Chart Sheet Text Box (migrating from Excel 2003 to Excel 2007)
 
	-  Changing an existing formatting macro
 
	-  Sheets Selection Through Combobox
 
	-  Solved: Delete Code After Copy
 
	-  Macro Edit
 
	-  custom random array
 
	-  Excel VBS SQL Code Problem
 
	-  Format with different colors
 
	-  VBA: how to interpret this code?
 
	-  Sleeper: Email, CSV, VBA
 
	-  Solved: Parsing?RegEx? Finding 1st character after 2nd Dash "-"
 
	-  Solved: Reduce x number of 'with' loops using code to update ranges from userform entries?
 
	-  Solved: Problem in Month days Calculation
 
	-  vlookup maybe ?
 
	-  Increase of the EXCEL.EXE memory
 
	-  comparing dates in vba
 
	-  Disable all textboxes in a userform
 
	-  Row Search & paste string
 
	-  Solved: Store a sequence of numbers in an array and recall them as required.
 
	-  Final Row help
 
	-  Need help with this Function code
 
	-  Need help with this Function code
 
	-  Solved: Save a sheet in workbook to a specific folder automatically
 
	-  Solved: Looking for a KB
 
	-  Solved: How to determine the axis title width?
 
	- [SLEEPER:] Add-in question
 
	-  Alternate row colours within a Listbox
 
	-  vb statement
 
	-  Solved: Retrieve value from chart data label
 
	-  Solved: Returning the Path of a Shortcut as a String
 
	-  Just checking the month
 
	-  Solved: Find and convert unix timestamps
 
	- [SLEEPER:] GUID for Excel 2007
 
	-  Tell VBA script to look for info in a cell
 
	-  Save As Location
 
	-  Multiple Filter
 
	-  Macro to add sequential WS and update summary
 
	- [SLEEPER:] Format entire column
 
	-  VBA Cell Format based on In-Cell Formula Result
 
	-  Copy specific data
 
	-  Solved: Copy data from multiple worksheets in a workbook
 
	-  Solved: Force users to enable macros in a workbook
 
	-  Solved: colornumber in excell
 
	-  How to auto log-in into IP Address using vba
 
	-  Counting Dates
 
	-  Please Help in Converting Excel spreadsheet to access 2003 table
 
	-  Solved: Triple Value Check Boxes
 
	-  Solved: Problem with save texts of UserForm.ListBox
 
	-  sort worksheets by tabcolor
 
	-  How to Make CountA Function Not to Count Hidden columns data
 
	-  Searching for a Consensus sequence
 
	-  Do Not Refresh
 
	-  How do I ignore Saturdays and Sundays with Autofilter?
 
	-  Exporting an Excel file to a text file with format .txt
 
	-  Need remote control vba help for my classroom
 
	-  Help: How to update all imported data in Excel
 
	-  Bind a key to a macro
 
	-  delete all comments
 
	-  Solved: copying ROW numbers into an array
 
	-  Critical Path Analysis
 
	-  Solved: Newb to vba need help with trig
 
	-  compare 1 out of  1,600,000
 
	-  Variable scope
 
	-  Adjust the CurrentRegion when copying
 
	-  Solved: Loop files on shared folder
 
	-  Error help BeforeClose
 
	-  Userform hidden and my macro stops
 
	- [SOLVED:] Excel: comment pulled from cell text?
 
	-  I need help matching text strings....
 
 
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.