TheMSsForum.com >> Excel Programming >> Archive Page 26 - The Microsoft Software Forum

view full version: back to formated view

8751: Need formula to calculate the average number of consecutive cells
8752: Loop to copy rows down
8753: Splitting decimals
8754: convert second word in range to Proper when first variable length -
8755: select the range with the cell's position is a variable.
8756: DECLARE VARIABLES PROBLEM
8757: F11 Crashes Excel
8758: Two Open Workbooks
8759: Linked Cells and Sort Issues
8760: RunTime error 462: Remote Server not avaliable???
8761: Copy & Paste "Equal" Function: Adding Distance
8762: Query SQL Server On Entry
8763: Excel macro to open Notepad and save with Date/Time in filename
8764: AutoFilter... not quite right
8765: Sort blocks of data as if each block was a single record
8766: comment or input message
8767: Avoid saving file with code in
8768: Printer
8769: Seaching a Word Document from Excel Part ii
8770: copy data from a list
8771: how can a macro be paused for input and then resume executio
8772: InputBox Help
8773: Creating separate spreadsheets from a master spreadsheet
8774: how do i set number in cell to add 1 upon opening sheet
8775: Use count data in formula
8776: Area Chart not refreshing/updating properly
8777: Listbox Max Columns
8778: Getting Picture Into Image In UserForm
8779: Excel 2007 Oracle DB Help
8780: MACRO
8781: Permanently enabling macros...
8782: sum cluster of cells based on values
8783: Clickbox control help needed
8784: Solver VBA - Defining Solver Options
8785: Close Excel server after activating OLE object
8786: insert, name and format new worksheet
8787: Hide a Spreadsheet in an Add-in
8788: Calender matrix in Excel
8789: Microsoft Office 2003 Web Services Toolkit
8790: using Excel's regression analysis to compare correlation of FX rat
8791: receiving drag-n-drop from PivotTable field list
8792: VLOOKUP or MATCH >=255
8793: Border Problem
8794: Textbox value copy from one worksheet to another worksheet
8795: UserForm Labels not Showing Properly
8796: sort and copy selection to other worksheet
8797: deleting record with a range
8798: Save as
8799: Code to insert check mark
8800: Hidden Cells
8801: Works in 2000 not in 2003?
8802: How to disable and hide ALL menu in Excel 2007?
8803: Data checking- a better way!
8804: Excel connectivity issue from .net application
8805: Combox In Form
8806: Macro Update Macro
8807: how to allow insert hyperlink and grouping together under protecti
8808: Application Crash Whie adding Code lines using VBA
8809: Hiding rows only when a condition has been met
8810: How do I invoke the "Reset" button in the VB Editior via code?
8811: Copy from one workbook to another
8812: Exclude Leading Blank Rows From Selection
8813: ADO sql server password
8814: how do i protect one cell for write but not for select?
8815: Workbook_SheetChange event
8816: How to Execute macro after importing external data ranges
8817: Pivot Tables and Macros
8818: Worksheet Tabs
8819: Can I programmatically access the MS Office Clipboard?
8820: How to enforce input and delete order of cells?
8821: Dropdown list to populate sheet
8822: Vlookup then subtotal
8823: Delete rows if value matches
8824: Array of Charts in Excel
8825: Find Command
8826: protect formulas only
8827: Lotus Notes get all the recipients
8828: to Ron de Bruin Please
8829: Nested Search and Replace
8830: combobox fraction
8831: This is killing me
8832: Need help adding If/Then/Else Statement
8833: Model User Forms
8834: is there a "workbook.calculation" command ??
8835: Generate list of number
8836: How to remove carriage return symbol before importing into excel
8837: remove vba code before emailing as attachment
8838: Textbox value - rename worksheet with
8839: hiding pivot tables
8840: updating macros
8841: How to change process bar % when macro is running
8842: Returning the IP results from a ping?
8843: Converting pdf tables into Excel files
8844: How to stop macro with cancel button
8845: RemoveDuplicates not removing all duplicate entries
8846: How do I disable "save as the new xml format for additional securi
8847: Looping Listbox in Userform
8848: Activate the cursor in a cell
8849: return ADO record set from Add-In?
8850: How do I direct a macro to a newly opened workbook
8851: looping struggle with index/match
8852: Print Selection
8853: ActiveWorkbook.SendMail and IE - odd problem
8854: Adding button to worksheet
8855: Status Bar Freezing 2nd Try
8856: Links broken when spreadsheet emailed
8857: Screen Updating For Status Bar
8858: How to "step into" in the middle of a long piece of code
8859: XML schema validation fails
8860: Macro additional information
8861: search button on sheet (ctrl+f)
8862: Buttons don't show
8863: Changing a variable which is to be specified through a loop
8864: Listbox to Array
8865: excel 2000 help
8866: Text Orientation in Published Worksheet
8867: Open / Close Grouping through VBA
8868: Loop to move #'s from one column to next
8869: Macro - Search one book, replace with data from another
8870: same sheet copy/paste special
8871: Initiating Excel VBA Code From Access
8872: use part of date in cell for save as name
8873: help with part of my macro
8874: Maintaining a list of unique entries in a list
8875: Uppercase Check
8876: replace . to / in dates
8877: How to Pass a date from a calendar control to a field on a form
8878: Most non built-in command bars invisible in Excel 2007...
8879: Combo control to execute code BEFORE change - please help
8880: Protect/hide VB code?
8881: How to give combo box the focus
8882: can I force formula to be applied automatically?
8883: Excel Cell Comments
8884: What keystrokes indents/outdents a block of code?
8885: copy paste code not working(troubleshoot pls)
8886: copy data in turqouise colour cells from n to a
8887: Please Help! Need to add a Variable Range in my Excel Macro with
8888: Including ActiveX Controls in Names Range Selection
8889: Can't perform requested operation in excel macro
8890: Excel Footer
8891: importing data from closed Excel workbook
8892: Using ADO to query CSV with no unpredictable headings
8893: Shname = Array("Sick Graph","Accident Graph")
8894: Complicated replacement values in list issue
8895: Please help on coding
8896: Message box
8897: Assigning array values to seriescollection
8898: Custom AutoFilter to Compare Due Dates to Current Date
8899: highlight duplicate rows comparing two cells
8900: Extend a Range
8901: importing data from closed workbook
8902: How do I goto column B in the current row using VBA?
8903: #VALUE! from Function()...Posted in Excel General Questions by mis
8904: Issue with File Name changing in cell
8905: How to read xml file using VBA macro
8906: copy/paste special
8907: vlookup STRANGE
8908: Macro File path problem
8909: Problem with ranges
8910: Pause to select cell
8911: Text Import Wizard
8912: Adding sum to varying columns lengths
8913: how to save *.xls in a DB in Acces
8914: USEING IF FUNCTION TO COPY IN ANOTHER WORKBOOK
8915: vba code on seperate excel file
8916: Zero Division
8917: macro to open an existing email message
8918: Macro
8919: Match , copy paste (using find?)
8920: Enter NA() into All Blank Cells in Range
8921: Range as a variable
8922: How do I prevent an error from crashing my macro?
8923: Printing Consecutive Number (One spreadsheet) on Each Sheet
8924: One macro two versions
8925: Dynamically select range
8926: Force a File to Open in a New Excel Instance
8927: Using ADO to insert values into CSV file
8928: Loop thru folders
8929: Combining sheets with variable layout
8930: Mouse rollover pop-up message
8931: convert multiple sheets into PDF
8932: Execute VB code against certain open workbooks
8933: keeping an object in view
8934: Boolean Declaration
8935: Copy a Cell with a macro
8936: Tab Function for textboxes on Worksheet not UserForm
8937: Rename Tab with Textbox on Worksheet
8938: .find not finding formula result
8939: Convert Input String Formula to Number
8940: Adding an alarm
8941: Dynamic Workbook in VBA
8942: Identity Specification
8943: Find empty cell and input data for other cells
8944: Code to Follow Hyperlink to media player without a new window opening
8945: Format particular words in a string
8946: Macro to copy a certain a cell to a dynamic range
8947: Automatic Sheet Naming
8948: Automatic Sheet Naming
8949: Saving Excel Workbook to a stream using Excel 2007 Plug-in
8950: it training institutes details ............
8951: select, copy and past all cells with specific colour
8952: Error: Type mismatch
8953: .Value 9999 not recognised
8954: ADO Syntax proble
8955: Excel Data to Powerpoint
8956: Enhance sub to paste charts as well
8957: Pivot Table from external CSV file using VBA
8958: Help on coding?
8959: Insert column and hide columns
8960: Using Caller with sub-menu selection in 2007
8961: Userform close
8962: Excel addin - how to deploy?
8963: VBA Continuation Lines, Best Practices Mar08
8964: IMPORTANT!Conditionally formatting just 2 of many characters in a
8965: Passing ranges to a subroutine
8966: Using ADO to Excel with this Query will not work?
8967: Rename first X number of worksheets predefined names
8968: Stuck and need help
8969: Opening a Workbook within VB
8970: Error saying Control object does not have Enable property.
8971: Macro to convert mmddyyyy format into mm/dd/yyyy format
8972: ActiveSheet.QueryTables.Add
8973: Disappearing Images
8974: Display Math Equation in Userform
8975: Help modify macro
8976: 'Composing' numbers
8977: Paste special validation
8978: Public Sub ProcessData()
8979: FILE 2 SLOW
8980: checkbox centered in cell
8981: How to permanently activate Macros?
8982: Copying Worksheets from one workbook to another
8983: pick from list and automatically enter corresponding cell
8984: extract data from Outlook
8985: Hyperlink Underline
8986: Named Constant
8987: assign Drop Down selections with values
8988: Multiple questions
8989: Error Trapping on Data Entry
8990: Worksheet_Change - initiate macro on another worksheet
8991: select cells with this/that colour with macro
8992: web query for driving directions
8993: if cell text repeats, move the adjacent column to the same row
8994: Macro to put records of same person on same row and delete duplica
8995: Passing reference to a checkbox to a subroutine.
8996: Conditional formats
8997: Delete rows based on an array
8998: Help wCombo Box Setup
8999: RTD issue with Excel 2007
9000: Finding and copying from 1 worksheet to another.
9001: Referencing an Excel Name from a different Workbook in VBA
9002: Error 800a01a8
9003: Shared Workbook - "1/0/1900" displays for some users
9004: .Refresh BackgroundQuery:=False
9005: dim problem when using cell() reference
9006: Column Combinatorics
9007: Help with external drop down lists
9008: Getting around Protected Worksheet (number format)
9009: Undo problems... again *sigh*
9010: Variable headers
9011: How to return mulitple values based on the contents of another cel
9012: Email Formatting
9013: Urgent Help
9014: Export range to XML?
9015: reorganising data
9016: Image Enhancement Software... 3D... Cool Freeware
9017: GetOpenFileName + Type Mismatch error
9018: Please help me edit this code..Thanks in advance :-)
9019: Excel email attachment from outlookexpress
9020: Conditional formatting - based on indentation
9021: How do I add the sum of a multiplication formula to another cell
9022: Excel application logs
9023: Excel queries
9024: Copy data to next empty row in a range
9025: Delete specific menu item from custom menu
9026: Can Excel pull live information from the Web???
9027: copying data in a sheet to a new Word document problem
9028: Your favorite Excel Add-ins
9029: Error handler question in Worksheet_Change event
9030: Excel registry key
9031: parameter
9032: Parse email text
9033: Disable Shortcuts
9034: Modeless Userform
9035: Custome Format Alpha
9036: name the sheet the same as the file name
9037: Quick Access Toolbar
9038: A better way to get Min and Max date
9039: Minimise/Restore
9040: Changing case in a cell
9041: weekly totals
9042: Refer to combox from activecontrol name
9043: formula that once it is true info stays in new cell?
9044: Counting Colored Cells
9045: how to save in the excel some additional invisible information
9046: SORTING MACRO TO CLEANUP MESSY SHEET
9047: macro/vba
9048: Disappearing Personalised settings
9049: Create New Sheets from Filtered List - help on macro
9050: Rich Text Box
9051: Searching a Word Document from Excel
9052: Startup
9053: Free Tutorial website And Ebooks programing tutorials
9054: how secure is projectProperty Protection?
9055: how to have checkBox in ToolBar (Icon) ?
9056: Colouring cells based on day of week?
9057: Variables & strings
9058: Can you write the contents of an Excel Named Range to Word?
9059: range and visibility
9060: How to paste a image into a VB UserFrame in Excel?
9061: Help with code please !!!
9062: multiply text and number
9063: Userform driving me insane
9064: Vertical Line in an XY Chart at Today's Date
9065: MenuBar/CommandBar(s) reappearing after being disabled??
9066: Macro to understand how wide or long the data range is
9067: If source cell is bolded then destination cell becomes bolded too.
9068: need macro to repeat two rows at top of each page
9069: check if any cell in column A has text
9070: nothing selected in listbox, but listindex <> -1
9071: macro to repeat non contiguous rows at top of ea page
9072: How do I make a copy of a macro?
9073: Hide Zero Rows - But Not Blank Rows
9074: Behavior - Option Buttons
9075: Lop to delete rows
9076: Code for Copying and Pasting data to a separate Workbook
9077: Batch file rename macro
9078: VBA How to
9079: Windows API Functions
9080: Boost up Your Business through Data Entry Outsourcing By saving time
9081: random number generator for scientific simulation purposes
9082: Enable/Disable Macro
9083: Excel Chart
9084: Copy Values based on a Match Q
9085: Conditional Formatting based on multiple criteria
9086: why do hyperlinks on userforms in excel work but not word
9087: Recommend: object intermediate between Application and Project
9088: Excel 2003 - Writing a Macro - How Do I...?
9089: how to insert a row at regular intervals of row
9090: split in vba
9091: Help with Design
9092: Question about the Queue of Commands in Undo
9093: Need VBA/Macro help in Excel (I think)
9094: Days360 Formula in VBA error
9095: Creating new worksheets and appending data from multiple worksheets.
9096: Automated e-mail from Excel
9097: loop through matches
9098: TreeView Control V - 6.0 - Drag-Drop Nodes
9099: Formulas
9100: Macros?