View Full Version : Excel Help
	- [SLEEPER:] Prevent user from viewing the code (1 replies)
 
	-  Solved: 6 dependant drop down boxes (12 replies)
 
	-  Solved: Load IE to Excel Sheet (5 replies)
 
	-  Help with USerForm Contain MultiPages (0 replies)
 
	-  Solved: Protect UserForm but not module (1 replies)
 
	-  Solved: How get TargetPath of .lnk or .url shortcut files? (8 replies)
 
	-  Excel Print Specific word document page (5 replies)
 
	-  Cycle thru worksheets and import shape according to dynamic values (3 replies)
 
	-  Excel 2003 Query Sharepoint List (0 replies)
 
	-  Solved: Rearranging data (9 replies)
 
	-  Excel Chart (0 replies)
 
	-  Excel Visible/Invisible (4 replies)
 
	-  Solved: Excel 2003: Disable screen refresh during intensive chart updating (8 replies)
 
	-  How to write a click event from a list box??? (2 replies)
 
	-  Two add-ins for one custom ribbon tab (2 replies)
 
	- [SOLVED:] Excel to World find Wholeword (1 replies)
 
	-  IF Formula (0 replies)
 
	-  Write to text file question (15 replies)
 
	-  vlookup and hlookup on multiple criteria (12 replies)
 
	- [SOLVED:] sumifs in VBA (5 replies)
 
	- [SOLVED:] Prevent variable from being initialized (2 replies)
 
	-  Find maximum and minimum values each day (2 replies)
 
	-  Solved: Avoiding a <type mismatch> error using IsError ? (4 replies)
 
	-  Solved: Problem in personal worksheet (18 replies)
 
	-  redefinition type in VBA (1 replies)
 
	-  dates in columns (2 replies)
 
	-  refresh all on protected sheet (7 replies)
 
	-  Advice: Redefine type of variable (3 replies)
 
	-  Solved: Find Value in Column And Paste data into it (15 replies)
 
	-  Solved: Insert Image from Userform Commandbutton. (6 replies)
 
	-  Solved: Identify column or number (6 replies)
 
	-  test of KB code on Disable Cut, Copy, Paste (6 replies)
 
	-  Solved: VLOOKUP problem (2 replies)
 
	-  Solved: move cursor to row X in active column (14 replies)
 
	-  Solved: Adding a button to a commandbar (Excel '97) (2 replies)
 
	-  Solved: ListFillRange from another workbook (4 replies)
 
	-  Vlookup problem (0 replies)
 
	-  VBA code to use a hyperlink to email file (3 replies)
 
	-  Any way to prevent deleting a specific WS? (5 replies)
 
	-  Disable Cut, Copy, Paste (2 replies)
 
	- [SOLVED:] Problem with deleting empty cells (2 replies)
 
	-  Conditional formatting question (4 replies)
 
	-  List File Attributes of Directory and Sub-directories (6 replies)
 
	-  Solved: color code range (4 replies)
 
	-  VBA to click OK in Javascript popup box? (1 replies)
 
	-  Solved: Creating directories from within excel? (2 replies)
 
	-  Time Out and auto close after expired time (1 replies)
 
	-  Solved: Filtering multiple worksheets based on master worksheet (1 replies)
 
	-  Force users to enable macros in a workbook (5 replies)
 
	-  Probably simple VBA issue (5 replies)
 
	-  Solved: ADO Assistance (Excel into Access) ('97 versions) (7 replies)
 
	-  Tough VBA data pulling from IE to Excel coding question (1 replies)
 
	-  Detect Change in Row . . (4 replies)
 
	-  Data number, symbols, sectors (3 replies)
 
	-  Input Line (11 replies)
 
	-  Solved: changing cell value/mapping (3 replies)
 
	-  VBA issue exporting Chart to Word (1 replies)
 
	-  SPLIT TEXT BY MACROS (8 replies)
 
	-  Moving files from one folder to another (6 replies)
 
	-  Add dynamic subtotals and then hide all blank rows (2 replies)
 
	-  Saving an activeworkbook as a time stamp (2 replies)
 
	-  anchor picture to cell (3 replies)
 
	-  VBA to perform specific instruction upon identification of duplicate entries (1 replies)
 
	-  selecting a range from a user defined reference in another sheet (7 replies)
 
	-  Excel VB Programing (8 replies)
 
	-  Drop down validation using array (2 replies)
 
	-  excel to powerpoint (1 replies)
 
	-  Solved: Correct method for a second FindThis criteria (13 replies)
 
	-  Solved: Getb Special Folders with Enums (17 replies)
 
	-  Controlling powerpoint from excel (1 replies)
 
	-  VB Button Code, HELP (1 replies)
 
	-  Embeding HTML in Excel (1 replies)
 
	-  need VB solution for comparing trendlines (1 replies)
 
	-  Run code when cell changes (1 replies)
 
	- [SLEEPER:] Okay, here is a wierd one for you!!! (11 replies)
 
	-  VB Formula Assistance needed (3 replies)
 
	-  Solved: Excel chart (6 replies)
 
	-  VBA to adjust print area based on UsedRange (3 replies)
 
	-  For a website, are Excel scripts better than other programming language scripts? (7 replies)
 
	-  VB Stopwatch Code (3 replies)
 
	-  vlookup probs (3 replies)
 
	-  Solved: Simple error message (6 replies)
 
	-  Design of set up (9 replies)
 
	-  Solved: Lost Workbook (4 replies)
 
	-  vba open workbooks (2 replies)
 
	-  Solved: Can macro let user click to choose workbook (23 replies)
 
	-  Convert Sheet To PDF Before Emailing (7 replies)
 
	-  SpaceChart plot does not show up (0 replies)
 
	-  VBA to extract information from Pivot Table (13 replies)
 
	- [SOLVED:] Multiple nested arrays to fill from a worksheet (4 replies)
 
	-  basic syntax query (2 replies)
 
	-  sum then devide by a hundred (2 replies)
 
	-  Trying to create a chart without a Legend (0 replies)
 
	-  "Should Cost" Model template in Excel (1 replies)
 
	-  Compiling Multiple XML Workbooks (5 replies)
 
	- [SLEEPER:] Test for Parenthesis at end of string (8 replies)
 
	-  Solved: If range has values then..... (20 replies)
 
	-  Solved: Shift rows to columns by condition (2 replies)
 
	-  Treat Several Columns as one in Pivot Report (3 replies)
 
	-  Extract Application information (2 replies)
 
	- [SOLVED:] Value Matching Validation (5 replies)
 
	-  Solved: Userform writing to worksheet (20 replies)
 
	-  ListView .finditem syntax (0 replies)
 
	-  Formula and Insert the Column problem (1 replies)
 
	-  Solved: How to draw following plot is excel? (5 replies)
 
	- [SOLVED:] Split cell based on a multiple delimiters list (4 replies)
 
	-  Need Help: Updating dates monthly (7 replies)
 
	-  Transfer zip code to another column (11 replies)
 
	-  Solved: How to find broken links (3 replies)
 
	-  Solved: VBA: Find next empty cell in a certain range (4 replies)
 
	-  Solved: VBA: Extract Number from Cell (5 replies)
 
	-  Solved: VBA : multidimensional arrays to fill from a worksheet (5 replies)
 
	-  average over several columns/spreadsheets (2 replies)
 
	-  Solved: VBA create hyperlink (3 replies)
 
	-  Solved: Change value of one cell based on another cell (Tree logic) (17 replies)
 
	-  Adding Criteria to UDF functions (7 replies)
 
	-  IF Statement on Cell Format (2 replies)
 
	-  default text in (8 replies)
 
	-  UserInterfaceOnly problem (1 replies)
 
	-  Solved: Copy images with VBA (3 replies)
 
	-  AutoCAD referencefiles? (0 replies)
 
	-  VBA Splitting the text 1-8 to (1,2,3,4,5,6,7,8) (4 replies)
 
	-  Solved: listbox little bug (16 replies)
 
	-  Loading Reference aborts Sub (2 replies)
 
	-  Solved: extract a column to 5 column (4 replies)
 
	-  exporting excel charts to Word (4 replies)
 
	-  Solved: Make NewWebQuery with URL-variable. (3 replies)
 
	-  Funtions: For non-english Excel users (4 replies)
 
	-  Help W/UserForm (5 replies)
 
	-  Copy Workbook, Saveas NewFile, Edit NewFile (5 replies)
 
	-  Check Box Click() (15 replies)
 
	-  Help with Function (4 replies)
 
	-  Help W/Small Code . . (3 replies)
 
	-  Saving a screen capture ~ PrintScreen (Excel '97) (3 replies)
 
	-  Solved: XLD - Chart Help (2 replies)
 
	-  Sub reference as Cell (7 replies)
 
	-  Autofilling a formulae to lastrow (4 replies)
 
	-  Open and refresh (4 replies)
 
	-  Solved: Limit Entries (2 replies)
 
	-  Solved: Performing a task in vba if time is between 2 times? (2 replies)
 
	-  Solved: Disable Cmd Button (2 replies)
 
	-  Solved: Find String and Merge Cells (9 replies)
 
	-  Solved: data validation question (2 replies)
 
	-  Solved: Cmd Button Caption (4 replies)
 
	-  Solved: ComboBox won't respond to repeat of previous selection (14 replies)
 
	-  Solved: Button to insert row in multiple worksheets and update (10 replies)
 
	-  VBA help - Vlookup (2 replies)
 
	-  Solved: Listbox with data from other sheet problem (7 replies)
 
	-  Solved: VBA strangeness, need help please (8 replies)
 
	-  Solved: Big Automation Question with Pivot Tables and Graphs (10 replies)
 
	-  help with: suming only colour filled cells in a column (2 replies)
 
	-  Solved: Email through Outlook contacts (11 replies)
 
	-  Solved: file name extensions (4 replies)
 
	-  Solved: Counting number of pages in word (2 replies)
 
	-  Solved: macro for every cell on the sheet (5 replies)
 
	-  Solved: Create a rolling reference number (2 replies)
 
	-  Transfer items from list to textbox (6 replies)
 
	-  Solved: Worksheets name (1 replies)
 
	-  Ignore Hidden Sheets in vlookup macro (1 replies)
 
	-  chasing ranges that move (6 replies)
 
	-  Solved: Row to hide on drop down selection (7 replies)
 
	-  Complex workbook_open solution needed (0 replies)
 
	-  macro to delete files - three days later (3 replies)
 
	-  How to retrieve DataSource of chart (1 replies)
 
	-  X-Y scatter graph refering a series of data log (7 replies)
 
	-  Macros in personal.xls execution based on different file names (7 replies)
 
	-  Solved: Inrease a number in a column basd on condition (4 replies)
 
	-  Solved: Display items of a collection in a message box? (2 replies)
 
	-  need a code..... (25 replies)
 
	-  "yyyymmdd_hhmm" change to Date, Time format (9 replies)
 
	-  Option Buttons (7 replies)
 
	-  VLOOKUP MACRO NOT WORKING PROPERLY (0 replies)
 
	-  Solved: SOme one help find out what is happening (0 replies)
 
	-  referencing of cells shows formula not values (3 replies)
 
	-  Solved: Help using For loop in a IF then statement (3 replies)
 
	-  Need Help W/Sort (5 replies)
 
	-  Solved: Create History (5 replies)
 
	-  Workbook_Open Does Not Work (2 replies)
 
	-  hlookup and vlookup (4 replies)
 
	-  List population dependent on another cell (1 replies)
 
	-  Solved: IF CASE (3 replies)
 
	-  Confused about RefersTo (6 replies)
 
	-  Solved: Transpose selected cells and place result on other sheet (4 replies)
 
	-  Excel Map gets destroyed when opened (6 replies)
 
	-  Solved: Replicating changes to one WS to others (6 replies)
 
	-  Solved: Handling large ranges (1 replies)
 
	-  Solved: VBA for "IF" function (2 replies)
 
	- [SOLVED:] Populate list (1 replies)
 
	-  Duplicate names for same range (1 replies)
 
	- [SLEEPER:] Referencing Other Open Workbooks. (3 replies)
 
	-  Copy Excel Range Into Outlook Email As Bitmap? (5 replies)
 
	-  Adjusting macro from L.Notes to Outlook (7 replies)
 
	- [SLEEPER:] Backgroundquery:=false seems to fail (1 replies)
 
	-  Polygon's (14 replies)
 
	-  Solved: AutoFilter macro issues (3 replies)
 
	-  For Input as #1 Question (2 replies)
 
	-  Clearing my autofilter (2 replies)
 
	-  Solved: Blank cells (3 replies)
 
	- [SOLVED:] If a condition is True how to add a number (3 replies)
 
	-  For Each-Next code tidying up (2 replies)
 
	-  Solved: Stop excel from calculating (2 replies)
 
	-  create report for list of numbers (1 replies)
 
	-  Solved: Excel in Parallels Word not... Help (2 replies)
 
	-  Sum for sub total and grand total (1 replies)
 
	- [SLEEPER:] trailing zeroes (6 replies)
 
	-  Solved: Repeat Column Insertation (It's simple!) (2 replies)
 
	-  using (iserror) in if statement (5 replies)
 
	-  Solved: Code for printing. (2 replies)
 
	-  Solved: Convert row into multiple rows of data (ARRAYS) (9 replies)
 
	-  Code for detecting when a Msg box opens (4 replies)
 
	-  Flash the TaskBar (13 replies)
 
	-  Solved: Links to other data sources. (2 replies)
 
	- [SOLVED:] Test if an item exists within a collection data type (3 replies)
 
	-  Solved: matching that finds the greatest/least amount (3 replies)
 
	-  Click OK on a dialogue popup box (2 replies)
 
	-  Solved: How do I create a range based on a column name? (4 replies)
 
	-  WinHttpRequest with HTTPS (3 replies)
 
	-  Excel form - listbox (6 replies)
 
	-  Solved: WorkSheet range Activate issue (6 replies)
 
	-  Solved: Run code on cell selection (5 replies)
 
	-  Solved: Pivot Table Update Data Source (1 replies)
 
	-  bind ListObject to Recordset? (1 replies)
 
	-  VBA Excel and IE login info "Not Sharing" (1 replies)
 
	-  Solved: Set FollowHyperlink default Web browser (9 replies)
 
	-  Solved: Strange Excel Error (3 replies)
 
	-  Solved: INDIRECT OR INDEX OR WHAT? I'M LOST (9 replies)
 
	-  SaveAs script (1 replies)
 
	-  Solved: Cut and Paste macro (2 replies)
 
	-  Solved: Deleting Empty Rows (8 replies)
 
	-  FInd Problems (11 replies)
 
	-  Selecting sheets in add-in (1 replies)
 
	-  Runtime Error - Email Code (2 replies)
 
	-  got error 1004 when executing this code (6 replies)
 
	-  Solved: Inserting & Naming New Columns in Multiple Worksheets (4 replies)
 
	-  Solved: Autofill Cells (2 replies)
 
	-  A different Change event (8 replies)
 
	-  Transferring data from two dimensional VBA array to Excel range - (6 replies)
 
	-  Select Case & Data Validation Issues (7 replies)
 
	-  Solved: Finding Last column in Row (6 replies)
 
	- [SLEEPER:] Referencing a named range for a UserForm? (12 replies)
 
	-  Color Code row based on cell content (1 replies)
 
	-  Solved: Show custom error message if file already opened by someone else (3 replies)
 
	-  Solved: Excel Freezing every 30 seconds (1 replies)
 
	-  how to hide all menus from excel woorkbook? (7 replies)
 
	-  Solved: Deleteing indertiminate spaces (9 replies)
 
	-  Solved: Code to Move to next sheet (15 replies)
 
	-  Convert row into multiple rows of data (ARRAYS) (6 replies)
 
	-  If statement not working (8 replies)
 
	- [SOLVED:] Get absolute address for hyperlinks (3 replies)
 
	-  How do I copy and paste cells that contain "@ml.com" (1 replies)
 
 
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.