View Full Version : Excel Help
	-  Solved: Validate Input Data in Userform
 
	-  Solved: Save current workbook to filename in format dd.mm.yy+string variable
 
	-  Loop through listView & update checkbox
 
	-  Opening A Sheet From A Combobox
 
	-  UDF to calculate moving average
 
	-  Sleeper: Can't shut down excel.exe process
 
	-  Convert sql to vba code
 
	-  Solved: Several issues with my code
 
	- [SOLVED:] VBA Email - Reply to Address
 
	-  Advance Filter
 
	-  Solved: Dynamic List of Worksheet Names based on criteria
 
	-  Solved: Copy & Paste and Adjust Data
 
	-  Copy & Paste data from column I
 
	-  Want to convert a Date
 
	-  Switch to an Active web browser windows with specific title
 
	-  Categorize Deadlines Based On Past Due/Period Remaining
 
	-  Comparing lists in columns?
 
	-  Solved: Userform query
 
	-  Solved: Colour entire row
 
	-  Solved: Timing my macro
 
	-  EXCEL CHARTS
 
	-  Solved: subtract date/time formatted fields
 
	-  Accessing Addin functions with VBA
 
	-  Calculating installments left
 
	-  Can't get PasteSpecial to work
 
	-  Solved: fill blank/black cells with 0
 
	-  Solved: Copy more than one sheet to new workbook
 
	-  Calculating project time
 
	-  Run Command When Push Print Button?
 
	-  Solved: Getting Rid of an Annoying Feature in Excel
 
	-  Getting date format in comboboxes?
 
	-  Solved: VLOOKUP Help
 
	-  Time and column spacing
 
	- [SOLVED:] Want to halp USEFORM
 
	-  How to change mixed case names to proper case?
 
	-  Solved: Force Hide Formula Bar
 
	-  Validating values of a column in a file from another file
 
	-  Solved: Script out of Range on Variant Array
 
	-  Solved: Problem when trying to use close method of workbook object
 
	-  Sum not correct
 
	-  Modify a macro
 
	-  Solved: Dynamical generate name ranges
 
	-  Find and replace (Excel&Word)
 
	-  Logging into website
 
	-  Solved: Amend Macro in worksheet Cashflow Yearly
 
	-  Solved: SearchWord Help
 
	-  Solved: VLOOKUP AND COLUMN FUNCTION
 
	-  Solved: Alternative to "vlookup" function
 
	- [SOLVED:] Tricky copy and paste macro
 
	-  Solved: Automatically Update graph
 
	-  ploting the graph according to the sheet selected
 
	-  ploting the graph according to the sheet selected
 
	-  Rowheight plus a little bit more
 
	- [SOLVED:] Delete Rows that contain X in column Y?
 
	-  Modifying the existing graph
 
	- [SOLVED:] Beep in Excel
 
	-  How to select changing cells within a column
 
	- [SOLVED:] How to paste X in column A according to the length of column B
 
	-  Amend Forumla
 
	- [SOLVED:] Return a Range in a function
 
	-  Debug Help with a Delete button
 
	-  Viewing records in workbook\worksheet form
 
	-  Email/Excel/based on a condition
 
	- [SOLVED:] Ranges as arguments in a VBA function called from the formula bar
 
	- [SOLVED:] Between dates in vba
 
	- [SOLVED:] Dcount Last Character In Column
 
	-  Solved: List all files in folders
 
	- [SOLVED:] Summing Macro
 
	-  Solved: Add To Code
 
	-  Solved: ListView control with images
 
	-  Data shifts on adding new customers
 
	-  FONT COLOUR DROP DOWN ON CELL
 
	-  A program to delete certain cells
 
	-  Solved: IF THEN COMMANDS??
 
	-  Solved: Vb New Line
 
	-  Chnage formula to ONLY allow column D and K
 
	-  Email Run-time error predicament
 
	-  Problems with Saving permissions
 
	-  Networkdays Formula
 
	-  Solved: Find cell and return value as string
 
	-  VBA Cell value mutiplication
 
	-  Solved: Need help with Loop routine to enable 20+ checkboxes
 
	-  Solved: excel2000 question
 
	-  Solved: Save As an Excel using VB
 
	-  Count non-hidden cells in a pivot table
 
	-  setting a workbook as a constant
 
	-  Hide value in Listbox if 2nd Column = 0
 
	-  Solved: 2 dimensional dictionary object
 
	-  excel spreadsheet to .EXE
 
	-  Solved: sum values based upon 2 conditions
 
	-  SUM/COUNT CELLS BY FILL COLOUR
 
	-  Solved: Very Custom Program
 
	-  Processing XSD schemas using VBA
 
	-  Double Entries
 
	-  Solved: Populate Listbox with Mulitple Columns
 
	-  Copy data from web
 
	-  Solved: Leave TextBoxes Blank
 
	-  Solved: Hide Row Based On First Few Letters
 
	-  Solved: Change PivotTable Data Field in VBA
 
	-  Solved: It's late, please help simplify this formula
 
	-  Error's want to help
 
	-  Copy variable range and copy to another sheet
 
	-  Solved: Save as Filename with a variable text
 
	-  Set SummaryRow format
 
	-  Combine2 Name Colums to Create emails
 
	- [SOLVED:] Help with Replace Function
 
	-  Edit a cell depending on previous choice.
 
	-  Solved: Available Resources issue
 
	-  Solved: Vlookup from data in unopened file?
 
	-  Solved: variable not defined in
 
	-  How to enter date into pop up, which enters into spreadsheet
 
	-  How to compare the difference between 2 excel files
 
	- [SLEEPER:] Create request
 
	-  Last Duplicate Value in Column
 
	-  VB code
 
	-  Solved: Followhyperlink code
 
	-  Solved: Custom Formats
 
	-  Copy data from Multiple to SINGLE worksheet.
 
	-  Pivot Page fields to new sheets
 
	-  greatest date and time
 
	-  Solved: adding locked cells via macro
 
	-  Solved: Copy range from one sheet to another
 
	-  Solved: Copy row of sheet2 (if data does not match sheet1).
 
	-  Advancedfilter Delete Row(s)
 
	-  IF STATEMENT TO extract result
 
	- [SOLVED:] Alter Code To Allow Spread Sheet To Close
 
	-  Insert today's date, save file and close
 
	-  Excel Signing Invalid because of XLA location change
 
	- [SOLVED:] Insert column
 
	-  How to delete all rows that don't have a specific name - e.g. "XYZ"
 
	-  Number format Question?
 
	-  Run macro automatically when a cell value changes
 
	-  Select check box on web page
 
	-  highlight cells between two dates in cluding the cells with the dates
 
	-  Font color
 
	-  Help using Excel as a database
 
	-  How to give a dataset corresponding ranges?
 
	-  Print when Command button is pushed
 
	- [SOLVED:] Message Box Input calls Tab Name
 
	- [SOLVED:] Loop for Value True/ Copy 4 cells to other sheet
 
	-  VBA Question - How to find the contents of one cell in another worksheet?
 
	-  Solved: Macro Problem - Hanging
 
	-  Solved: copy sheet and change formula reference
 
	-  Solved: Removing numbers from a text block
 
	-  Sleeper: Linking worksheet together
 
	-  Formula Error
 
	-  Code to allow A Customers ID to only go in a spread up to 3 times?
 
	-  Place in first empty textbox?????????
 
	-  Placing in the same row as a spefic customer
 
	-  UDT Question
 
	-  Solved: Save button
 
	- [SOLVED:] Press a button and it will make a calculation of +30days!
 
	-  Solved: What can i do when it says not a legal object name.. and then wont let me do anythin?
 
	-  Solved: Save button
 
	-  When using a combo bow to select a row
 
	-  Solved: find duplicate entries in colunms
 
	-  Solved: Edit code to change cell value
 
	-  Solved: Loop through sheets
 
	-  Solved: Restrict Menus & Right Click Menus & short keys
 
	-  Solved: How can I create linked Vlookup data from multiple closed workbooks
 
	-  Find and Replace Page Down in excel
 
	-  Multiple Charts To Multiple Slides
 
	-  conditional adding through sheets in a loop. Novice.
 
	-  Solved: Jump to last worksheet
 
	-  Runtime error in macro
 
	-  Solved: Save in both Excel 2003 and 2007
 
	-  Solved: Remove ' from text
 
	-  Simplify Code
 
	-  Duplicate Master freeware utility?
 
	-  Custom Sort
 
	-  Sort, Page Break and Page Header according to cell values in different worksheet
 
	-  Solved: Passing variables through properties
 
	-  Sub or Function for IF ...
 
	-  Split text between cells Help Needed
 
	-  collection issue with custom type variable
 
	- [SOLVED:] Move sheets to new book (array)
 
	-  Copy and paste data after printing
 
	-  Solved: Partial String ListBox search to populate another ListBox
 
	-  New Excel Application
 
	-  Solved: Green if zero, Red if not
 
	-  Subtotals using Macro ...
 
	-  Notification when macro is executed
 
	-  Solved: Notification when macro is executed
 
	- [SOLVED:] How do you return / pass values?
 
	-  When looping through sheets remove subtotals only works on first
 
	-  Solved: Combining macros
 
	-  Using a combo box to select a named worksheet
 
	-  Command Button to save, print and clear
 
	-  How to delete a row if it contains a word?
 
	-  Solved: Code change to allow for Data table changes
 
	-  Solved: Loop through one column on any sheet in workbook....
 
	-  CommendBox
 
	-  Solved: Feeling dumb today!!!
 
	-  Getting Data from an Excel Spreadsheet object to a normal excel spreadsheet
 
	- [SOLVED:] Add Border if Statement
 
	-  Count coloured cells and display result in table.
 
	-  Group 2 cells like in a userform.
 
	-  Excel Right Click Menu Always Up
 
	-  rectangle question
 
	-  Solved: Saving As Text adds double quotes to some lines!
 
	-  VBA for time display
 
	-  Check if a file on the web exists
 
	-  Controlling Internet Explorer's "Print pop-up"
 
	- [SOLVED:] Clipboard is full
 
	-  Solved: move up
 
	-  Random number generation
 
	-  Summing a column based on two criteria in other columns
 
	-  Listview help
 
	-  Pass a named range into function issue
 
	-  How to find the last duplicate value
 
	-  Solved: Problem auto-installing VBA add-in
 
	-  Formatting entire row based on text in first column
 
	-  Combobox Visibility After Drop List Selection
 
	-  Help! I'm working with two spread sheets
 
	-  [Help Please]Parsing parameters to event
 
	-  If no dependents msgbox and resume loop
 
	-  C&P all data of all the sheets/workbooks in a folder.
 
	-  Execel, OLEObjects (buttons) sometimes not firing, triggering
 
	-  Excel Macro Help Please
 
	-  problem using a function from an external library in vba
 
	- [SOLVED:] Variable Columns Lengths
 
	-  Solved: Create a worksheet for each value in Column A
 
	-  Split string into multiple parts no bigger than 240 chars?
 
	-  Solved: alpha-numeric 2
 
	-  Solved: case yes-no, can the code be smaler?
 
	- [SOLVED:] Easy!  How to make a button that generates a random number?
 
	-  Solved: using a worksheet function in vba
 
	-  Solved: Sum and compile list of entries
 
	-  Solved: any value in a range = 0 then return 0 ?
 
	-  Solved: From one array to another
 
	-  Solved: problems saveing two copies.
 
	-  Solved: Userform buttons to enter numbers into textbox
 
	-  Solved: problem of structure
 
	-  copy range, skip empty cells
 
	-  Solved: Fast Compare using Filter
 
	-  Alternative to Eomonth formulae question
 
	-  Solved: make a dynamic if statment?
 
	- [SOLVED:] Special Transpose
 
	-  From one sheet to another...
 
	-  loop + offset/resize problem
 
	-  Extracting certain data to another sheet
 
	-  Macro Security
 
	-  worksheet is not picked up in Vba
 
	-  Solved: Stop Them Deleting Rows
 
	-  Solved: Hours to be worked by Month
 
	-  Date Format
 
	-  MACRO/VBA help!!! :S new line... etc
 
	-  Getting around Pivot Table 256 Col Limitation
 
	-  Connections in MS Excel 2007
 
	-  Solved: Delete function failing
 
 
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.