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

view full version: back to formated view

30801: Change Text Colour if Value is in a List Q
30802: PAStE SPECIAL
30803: link to other worksheets
30804: Question
30805: Detecting text fits into column
30806: Unable to figure out VBA Code needed
30807: CUSTOM PRINTING !
30808: HOW TO DISABLE CUT N PASTE OR HIGHLIGHT N DRAG IN VB
30809: getting msg box for no match!
30810: Unlock protected VBA
30811: More than one cell answers??????
30812: Solver with limit
30813: Using Code Editor Slows execution speed
30814: Help with vlookup with certain cell change
30815: Populating a cell with concatenated text...
30816: Selection Grid
30817: #DIV/0! Error
30818: remove outliers in a time series
30819: dynamic range and series
30820: Saving Macro - need help
30821: I don't want to repeat the same number
30822: Error in loading DLL
30823: Paste Column Width Language
30824: compare and compile nonblank data from seperate workbooks in an automated user form
30825: Place Thin Border around Cell
30826: procedural help lease
30827: Find duplicate range or cell ref (as precedents) in a cell's formula - an example
30828: How do I make a word in Excel flash?
30829: Worksheet Listbox Populate Problem
30830: How do I use looping and offsets thru 2 tables to generate a cash flow per week
30831: vba to delete rows
30832: SaveAs Dialog comes up twice???
30833: UserForm fill by Range
30834: Selecting a range of cells, how to ?
30835: Selecting a range of cells , how to ?
30836: If then VB statement
30837: Hide Row Per Value in Two Columns
30838: Run Two Macros from Same Button
30839: IF cell equals then help
30840: How to extract file name for use in a cell?
30841: SplashScreen
30842: Copy Range including Formats and Forumulas
30843: Pose questions to Microsoft when an answer is not forthcoming in g
30844: VBA code to import stacked text files
30845: Pictures based on conditional and used more than one time
30846: iterate through chart series collection
30847: Worksheet to be saved in current directory
30848: Marking a range True or False based on a single Checkbox
30849: C++ Access to Windowclass Excel<
30850: Opening a file and disabling open events
30851: Move cursor down one cell
30852: Show/hide details in pivot chart
30853: Time sheet totalization
30854: Determine delimiter in csv or txt file
30855: VBA Code...
30856: Closing Form and prevention
30857: MATCH NUMBER From another wooksheet Macro
30858: Macro to hide blank rows
30859: Assigning Formula to a Range
30860: Changing cell text color based on cell number
30861: spell check ranges in a do loop
30862: Setting CenterFooter on Multiple Worksheets
30863: Deleting Rows that Match/Contain Search Criteria
30864: calling a shared lib from VBA in Excel
30865: Excel vba loop?
30866: Multiple graphs
30867: Avoid "MK_E_UNAVAILABLE" with a COM in Excel
30868: Need an Excel Add-In.........
30869: validation
30870: using UsedRange.SpecialCells(xlCellTypeVisible).Areas(2)
30871: Selecting 10 charcters on one cell and pasting to another cell
30872: VBE Code
30873: CalculatedItem suppress running total
30874: deleting automatic links
30875: Source Code Control
30876: Make directory structure variable
30877: Pivot table - Hide the Data Sheet
30878: worksheet_change colour of a row on change of cell
30879: Debugging suddenly stops...
30880: Debugging suddenly stops...
30881: collating/consolidating large amount of data in excel
30882: Aliases Cell formulas Convert to VBA
30883: Identifying rows selected by filter
30884: Script to Pull info from website into Excel
30885: Data of Sheet1 should gets autometically posted in Sheet2
30886: Rew Macro For Computation
30887: totalling dates
30888: Reducing Size of the file
30889: How to be notified when user changes cell value in selected column?
30890: how do i calculate a running payoff amount?
30891: Getting system OS language and then.....
30892: Close Button Removal
30893: Saving Forms
30894: Setting chart Xvalue errors
30895: How do I create a formula that will enter the most recent data?
30896: SUMPRODUCT #value! error
30897: How do I disable the right-click shortcut menu on charts
30898: Excel Not Entering Data
30899: Comparing Large Data Sets in Excel
30900: How to validate that input was entered into Input Box
30901: How to pen the Find dialog box with a macro
30902: Round off error
30903: Col alignment problem
30904: Go straight to next value in a For... Next loop
30905: Try Before You Buy Install
30906: Find specific column and copy row.
30907: turn off pivotfield sort
30908: Adding totals to columns where number of rows varies
30909: Do Multiple Regression with VBA Code
30910: Travelling cell values with filter in Excel macro.
30911: 'On Error' within 'For' loop
30912: Excel SaveAs not using specified FileFormat
30913: Pivot Table Calculations
30914: Have User select a column
30915: Calculating revenue over fiscal quarters
30916: multiple pivot tables from 1 pivot cache
30917: Randomly sorting a group of 5 values multiple times
30918: Check Mark appears when a letter is entered in a field
30919: continuing: Incorporating error handling to Bob's code
30920: Excel VBA as a programming language
30921: DisplayAlerts not working
30922: right click menu
30923: How do I get input from an edit box to a worksheet?
30924: Similar SaveAs
30925: Spash screen on a Mac?
30926: VB code in excel.
30927: Error using Application.WorksheetFunction
30928: Excel automation: are there some timing constraints?
30929: Block sheet entirely....
30930: Firstname Lastname Field, Split two cells
30931: Anouther loop question
30932: Creating Report
30933: Using the values in range of cells in an SQL query
30934: code for counting/shifting
30935: New Group in Menu
30936: help with loop to delete rows
30937: SaveAs Macro - Build filename from cell contents HOW?
30938: Automatic Sheet updating
30939: Recording macro to save file with name change
30940: multiple choices from pulldown... how to apply to several pulldown
30941: Search wildcard to limit only alpha characters
30942: VBA programming expert required
30943: Which Fires First?
30944: Layout troubles with VBA-generated OrgChart in Excel
30945: averaging arrays
30946: Saving takes soooo long
30947: Do until loop
30948: Workbook_onChange that shows/hides rows crashes after printing?
30949: different results when debugging
30950: pivot chart exclude rows
30951: setSourcedata
30952: exclude cells from calculation if custom format
30953: Setting Combo Box to display a blank
30954: Cut a range between 2 cells containing found data
30955: Clearing the keyboard buffer after sendkeys
30956: User Form
30957: Barcode reader - to store data in Excel
30958: DDEPoke only pushes the text contents from excel to word
30959: exit macro after test of cell value
30960: Merging selected fields from 4 worksheets to a Master Worksheet
30961: detecting formula containing a constant
30962: Column Chart with two axes
30963: copy several sheets from a workbook to a single sheet in a new wor
30964: can excel show due dates automatically?
30965: Reversing a filter using a checkbox
30966: Computer Name with VBA
30967: change event; return focus to original textbox
30968: Macro Required for Lookup Function
30969: Can you Click the "Enter" key to go to the next line in a Textbox without Exiting the Textbox ?
30970: How do I stop chart dialogs from appearing
30971: Copy variable sized range to single column...
30972: Transferring data in Excel
30973: I still have trouble with Date Formats. Why is it so ?
30974: Array copying to a filtered region
30975: Name checking
30976: Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ?
30977: Refrence a workbook procedure from another workbook
30978: use vlook up function
30979: Opening some workbooks with a Macro renames them
30980: need to determine what named range a cell is in
30981: VBA Find & Replace Intelligently
30982: removing legend entries
30983: Cut/Paste - More problems
30984: Copy TextBox Text
30985: Unselect? Deselect?
30986: VLOOKUP and stopping at the last record
30987: averaging
30988: Select another Textbox After Selection
30989: Naming and saving a workbook
30990: Copy worksheets to new worksheet and add a worksheet name column to new sheet.
30991: Worksheet.Match the best way to go?
30992: Macro to move a cell to centre screen
30993: Macro and range names
30994: Help changing one line on a macro
30995: Templates in Add-in
30996: Create Phone List From HR Worksheet
30997: Excel VBA Program Won't Run After Auto-Save
30998: Userform Values into Excel sheet
30999: VBA - saving strings to a text file
31000: Taking data from multiple workbooks?
31001: pivot chart format recording & applying
31002: Insert UserForm Values into Excel sheet
31003: Userform Values into Excel sheet
31004: Wild Card for partial matches.
31005: cannot record macro
31006: Fixed Width
31007: Looping through buttons on a worksheet.
31008: Code to find and replace words inside of a text box
31009: Comma
31010: Counting Colours
31011: list separator
31012: Autofit for entire sheet?
31013: Check number of rows?
31014: How to discovery the color...
31015: password recovery
31016: Conditional Copy/Paste
31017: macro to subtract across columns
31018: Multiple Lists from Unique Data
31019: Excel Object in Word Document
31020: can't create excel add-in macro to use with other workbooks
31021: Macro stops part way through !
31022: Load Dll
31023: Code Works for Some Worksheets, But Not Others
31024: Adding a button with Add-in
31025: Macro works on one computer but not another
31026: ActiveWorkbook.Names.Add -- Problem
31027: Theoretical question: graph & trendlines in Excel
31028: Customized toolbar button trigger macro in a different file
31029: Actualisation problem :(
31030: Create dummy file structure?
31031: Date Format in a Userform Listbox
31032: File size keeps fluctuating wildly!
31033: send excel workbook as attachment to multiple users
31034: How to Change Worksheet Properties
31035: Need Help: Determine Equipment Capacity
31036: Programmatically Select Tab on Ribbon?
31037: Adding worksheets
31038: GetOpenFilename - with a difference
31039: Date format is not picked up correctly while filtering
31040: Gather data from multiple XML sheets?
31041: Searching for words used in VBA code
31042: My code fails
31043: Unique Listbox Scripting Dictionary
31044: Print area composed by more range
31045: Closing Files Opened Using the FileToOpen
31046: Adding a Value List to Combo Box
31047: Filtering Results in Excel & VBA
31048: Microsoft Internet Tools not accessable
31049: Conversion of WP12 file to Excel
31050: Conversion of WP12 file to Excel
31051: Printer Paper Source Setup
31052: Search Range for string, then copy that cell to another worksheet
31053: Runtime 1004
31054: macro with multiple csv
31055: Referencing a workbook in the same directory
31056: Linking to separate worksheet with 2 criteria
31057: not sure where to start
31058: Return Array from Function
31059: random assignments of workload to set # of people
31060: programatically creating worksheets
31061: if...color
31062: Duplicate chart on new sheets
31063: Let's try again: VBA Code stops randomly
31064: How do I set Up a random sports scheduler
31065: Scaling Graphs
31066: Userform direction
31067: How can I link (not embed) to a graphic on the internet in Excel?
31068: Have a Big Question
31069: renaming a query
31070: Digital certificate blocked
31071: Excel Camera Object
31072: Excel forms enters .exd in registry
31073: Determine Cells(5,4) IN SPITE of hidden rows/columns
31074: Question for Jim Thomlinson
31075: code to attach files
31076: Text Box Value
31077: Sum cells based on two criteria
31078: Trouble Creating Formula in a Macro
31079: Macro's checking for errors
31080: macro question
31081: Parsing after multiple selection in drop-down?
31082: more than 2 option buttons on a form
31083: Selecting a Range with a Variable in VB
31084: Can I start the text import wizard automatically?
31085: Using cell row # in a VB macro
31086: Non unique records only
31087: Creating Macro/Formula
31088: Auto Calculate Question
31089: SaveAs AutoRecover error?
31090: VLOOKUP equation in VBA
31091: Re-Post: Sorting Listbox Source
31092: Copying Column in R1C convention
31093: insert copied cells to a different workbook
31094: convert string to integer
31095: How to hide a column in combobox?
31096: Method to get dates based on Month
31097: deleting "0" rows
31098: MsgBox repeated two times (Excel COM Add-in)
31099: Open Office Compatibility with Microsoft office
31100: Copy row formatting down
31101: Add break in macro
31102: Count only Mon-Thurs?
31103: program for dialog box
31104: Automatically use or update links between two sheets using VBA?
31105: Opening Excel-files in several directories
31106: Overcome "expected end of statement error"
31107: Macro for Inserting Rows
31108: ADO compatibility between Excel XP and 2003
31109: Execution comments
31110: Sheet Show
31111: Export Excel in Power Point
31112: Debugging Loop script
31113: Worksheet Open Event Q
31114: How to open Word from Excel with VBA (Office 2003)
31115: scanner twain
31116: Help with Macro that searches a Range for specified information
31117: insert a macro into a workbook using vba
31118: Is there a way to kill all files in a folder?
31119: Run macro when file is opened and closed
31120: date format change when opening file with vb
31121: Opening files by VBA
31122: Any api to Insert objects in Excel
31123: Import Outlook Journal Items into Excel
31124: add the addin in the Tools menu of Excel
31125: Formula doest work in Excel
31126: I get Subscript out of Range second time, not the first time
31127: Excel Colum and Rows Problem
31128: How find maximum top+height property of a collection of shapes
31129: Spin Button's What can they do?
31130: Re: Is there something wrong with my code?
31131: ListBox Selection to fire Macro
31132: Looking for DMEDIAN
31133: How To Quit Subroutine from a called subroutine
31134: Pasted values keep changing to time number format
31135: Maintaining Information in a Cell
31136: Saving a workbook to a specific directory
31137: clearing cells and checkboxes **ROOKIE HERE**
31138: Find Record in Access Using Excel
31139: Update current record in Access using Excel
31140: XML Web Imports
31141: How to Improve my "Vlookup" on Steroids function.....
31142: Freeze Panes C#
31143: Simple Find/Replace Question
31144: Can I count total lines of VBA Code Executed in a Series of Subs?
31145: Textbox in user form
31146: Formulas for multiple functions
31147: Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options
31148: Insert a formula into a cell
31149: Sorting ListBox Source
31150: Increase font size within my formula bar