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

view full version: back to formated view

20651: Excel 2007 autoopen shift key doesn't work
20652: match two excel spread sheet using macro
20653: PageSetup changes not working in VBA
20654: Looping thru multiple files to produce a consolidated summary by Cod
20655: SetText Format in Excel sheet Cell
20656: Enforcing worksheet Naming Conventions - Trapping Copy/Rename work
20657: How do I stop 2nd row deletion
20658: Can Outlook contact data be linked to an Excel Workbook cell?
20659: Auto-correct macro or VBA
20660: Help with insert a row
20661: Password protect worksheets
20662: Help on Macro
20663: Modified McCauley Duration From VBA?
20664: Macro to Unlock All Protected Worksheets
20665: Help with VBA date
20666: why doesnt my VSTO SE addin work?
20667: Macro to Modify a Macro?
20668: highlight a column
20669: Type Mismatch Error
20670: Filtering on String Length
20671: Summing while hiding?!
20672: If Range("J1").Text...Then
20673: What happen when a row is hidden?
20674: What happen when a row is hidden?
20675: What happen when a row is hidden?
20676: Is there a way to make the text blink on and off using Excel VB?
20677: Listing all cell references
20678: Finding chart on worksheet
20679: Updating Data between workbooks
20680: Find a substring
20681: Pivot-Multiple Items-Linked Pivot-Macro
20682: copy Module via macro
20683: Kill Error Message
20684: Save creating enormous temp files
20685: Alignment of Figures
20686: How do I display cell name with Msgbox?
20687: Excel "stuck"
20688: transpose Copyfromrowset
20689: Macro to expire after a specified date
20690: Command Bars - working with the built in buttons
20691: Call VB6 DLL from VBA wrapper
20692: How to determine type of function argument?
20693: How to Disable a special button
20694: How can I access Directory Names?
20695: Issue with mail merge date field
20696: delete blank rows and remove blanks from dropdown
20697: How to remove single quotes
20698: VBA/Macros in Cell Edit mode / Formula text selectio
20699: number to words
20700: Adding class object to collection repeats same object through collection?
20701: Define Range Dynamically
20702: sumif question
20703: Protecting & Unprotecting worksheet
20704: Variable type
20705: Compare xls & mpp files against a master file register then flag missing.
20706: What is Runtime Error 6028 and how can it be resolved?
20707: Improving the code from a recorded macro
20708: Run Time Error 6028: Help?
20709: Import data from a secure website to Excel
20710: Button to email?
20711: Whats happened?
20712: Find a Number and Date - VBA
20713: pivot table running total problem
20714: Stamp a Cell with Time Q
20715: Help with For Each ... Next and control
20716: row index number in a hlookup formula
20717: Data Validation Macro
20718: Compound IF statement
20719: File Exist
20720: Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
20721: all open workbooks
20722: end if without block if error
20723: Dates and Conditional Formatting
20724: Return Value from MsgBox
20725: Is Worksheet Empty?
20726: Macro function to read text file
20727: Selective Worksheet printing
20728: Save it giving as a name the content of a cell
20729: named range as rowsource
20730: Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"
20731: How to Find the last non empty row
20732: Two related Data Validation lists
20733: Table Live
20734: a1+a2=a3 How can I change a2,keep old a2 value & increase a3
20735: MsgBox with Two Questions
20736: Cal formula upon sorting
20737: linked cells not updating
20738: can't activate chart
20739: Null Value
20740: Copy Module to new Workbook
20741: creating a formula with a loop
20742: Tidying Recorded Macro Code
20743: Macro to change font
20744: Cannot change column name in Excel's MS Query tool
20745: Accessing the text of a form command button from underlying macro
20746: Make shortcut to Excelfile on desktop
20747: select data from dropdown menu
20748: Error on E-Mailing Q
20749: Build whre statement
20750: Invoke Edit Mode
20751: Changing a two-dimensional, one row array to one-dimensional
20752: value of one cell in a named range
20753: NUMERICALS CAN CHANGE IN ALPHABHATS
20754: How do I create a pulldown value list for data entry?
20755: form population macro
20756: How to write code for find a word in excel?
20757: Pivot Table Custom Filters
20758: Find a Number and Date ...
20759: Transfer data from one workbook to another workbook based on a key
20760: Pivot Tables - DisplayEmptyColumn question
20761: AutoFilter
20762: Visual Basic v6.3 and Excel v2002
20763: VB Help/Request? Compare and insert to different data in columns
20764: Capturing Listbox Selections
20765: Conditional Formatted numbers add based on color?
20766: On File Open
20767: Counting Worksheets
20768: Finding the path of a folder
20769: if questions
20770: Buttons disappear when projected
20771: Any way to enable the 2007 pivot table option Defer Layout Update with VBA?
20772: Question on this conversion code switching between r1c1 to A1 format tia sal2
20773: Hiding Columns
20774: goal seek reference
20775: Run-time error
20776: type mismatch error when passing collection byRef
20777: Only want to see half of my result
20778: Remove a cell from a range
20779: running Access procedure from Excel
20780: Macro to delete rows
20781: how to suppress auto correct?
20782: Xlusrgal
20783: Import from MS Access - Lose the drive letter..link only to drive
20784: Fill Cell with Asterix
20785: Hide all toolbars/menu bar when open file
20786: Counting elements of array and range type data
20787: Answer msgbox with macro
20788: Copy Command Button Code.
20789: Undefined MergeArea when MergeCells is true
20790: Changing Numeric value to text
20791: IF statement in excel
20792: Key combinations not used by Excel to use in macro keyboard shortcuts?
20793: Find error!!!! Is there any other way to do this?
20794: Find error!!!! Is there any other way to do this?
20795: how to recognise a c# dll in vba excel
20796: Not Enough Memory to run Microsoft Office Excel.
20797: allcaps option in excel like word
20798: Preventing corruption of dynamic range names on cell deletion
20799: Application.Volatile not working
20800: Deactivate Code
20801: transforming poll data from rows to colums
20802: Help- It's only a tiny change
20803: Exception occured
20804: TreeView1
20805: Open Forum 4 ALL
20806: Check a workbook exists before opening
20807: "view page breaks"
20808: Getting file name and Modified date
20809: Linking to several other spreadsheets
20810: I need help programming a joke on a friend.
20811: Conditional formatting based on what function is used in a cell.
20812: Columns limit 512
20813: Using an Array to Speed-Up Range Copy
20814: Set Class1Var = New Class1
20815: Working with huge cells
20816: Matching two worksheet?
20817: align left and right in listbox
20818: How to print out matching names?
20819: macro to color all text red in worksheet if within certain date
20820: Excel error message
20821: check control names
20822: Deleting Rows if certain criteria isnt met
20823: Starting excel and running it on the same process
20824: excel 2003 Reading workbook properties / details from an XLA how do you do it?
20825: excel 2003 Reading workbook properties / details from an XLA how do you do it?
20826: Auto number formatting
20827: Hide rows and prevent unhiding
20828: Inserting sender in voting response
20829: Workbooks.Add = Macro Regression in 2007
20830: sql
20831: Macro to copy data with a date criteria
20832: Use cell values as object names
20833: VBA code to email 1 worksheet in a workbook
20834: Instead of the word "dropped" could I use an arrow?
20835: VBA Question - Delete set if any member meets criteria
20836: Removing Blank Rows for Excel VB Newb
20837: Calendar with weeknumber?
20838: How do I use the Shift+Ctrl+down feature in a macro
20839: code reopens file
20840: Active worksheet problem
20841: macro to close file and not save changes
20842: Partial sheet protection
20843: Copy only basic number without dollar sign or commas (or cell formatting)?
20844: Best way to import .csv
20845: Is there a way to run a procedure before the paste command?
20846: Tab printing Macro
20847: Macro acting wierd with Zip Codes
20848: Missing Reference causing strange errors
20849: What's the fastest way to push this data around?
20850: hide sheet
20851: Code to Print single cells
20852: Worksheet_Change
20853: Grouping Checkboxes in a UserForm
20854: display cell contents
20855: range values
20856: Two Parter: filter list and search for a match for the password
20857: If Then statement comparing date values
20858: Flag me if macro errors
20859: Worksheet Change event code, but retain Undo?
20860: Why does VBA mess up
20861: Checking if a property contains another specific string
20862: Batch deleting invalid defined names from a workbook
20863: this code crashes excel. How come?
20864: Code to Create a Command Button
20865: Can VBA Code change itself?
20866: Printing to Local Printer and the not the default printer.
20867: Location of Cell with Value in Merge Area
20868: Finding Embedded Object Type in Worksheet
20869: Finding embedded object type in Excel Worksheet
20870: Excel / Access User Conference - Oct 24-26, St Loiuis
20871: use a variable for a worksheet name in a formula
20872: How to create a time log sheet
20873: Excel cannot complete this task with available resources. choose less data or close other applications
20874: defined name with formula as source in VBA
20875: Copy-pasting from Excel to Word
20876: opening a file from a cell reference
20877: Is there a code to clear clipboard to prevent pasting on mouse mov
20878: Export and Import Userform from Excel-file to another Excel-file
20879: Using Shape's OnAction property in C#
20880: Draw Entries
20881: Error in Insert Row command.
20882: Conversion from columnwise to rowwise
20883: Excel macros
20884: Find function using chr
20885: Track Changes History sheet (Who changed the last cell)
20886: Code Needed For a Macro
20887: Selection.Replace What and double quotes
20888: help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
20889: Hiding Columns
20890: Split first name and Surname
20891: copy checkbox to multiple cells?
20892: Formatting the excel window
20893: Sheet CodeNames
20894: Stop a user from opening Excel if the Add-in is not found
20895: Sumproduct, array
20896: Option Explicit when install Essbase
20897: can't transfer to worksheet
20898: Auto size named range by .Net or VBA
20899: How do they do that?
20900: Macro not running when it is supposed too
20901: array data to cells
20902: Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
20903: Arrays [Why does this not work?]
20904: if database exists... MS Query
20905: Nested IF problem
20906: TRANSPOSE and INDEX limit in Excel2007
20907: Hiding checkboxes
20908: Convert numbers to text (from product id # to name of product)
20909: Search all worksheets
20910: Search all worksheets
20911: help with this loop macro
20912: Finding the nearest match without reusing results
20913: List Worksheet Names in a Dialog
20914: End(XlDown).Row - Problem if only 1 row
20915: Named range reference in VBA for Excel 2007
20916: CHANGING FONT SIZE
20917: How to read a string from a variant array ?
20918: VBA or VBE
20919: Selecting a file in a macro
20920: Formulas
20921: Automatically Creating a Command Button
20922: Open a read only file as a writable file
20923: Change PivotTable Field By Code
20924: Call macro in worksheet from userform?
20925: Specifying a range within an array
20926: Copy a range of cells to all workbooks in a folder?
20927: deleting duplicates
20928: Get the Data Type of a Property
20929: Copy-pasting (unformatted) to a word document
20930: Summary Sheet from range specified in a worksheet
20931: Help saving file; exporting as .csv
20932: Wrong code?
20933: Detecting open workbook
20934: VB Editor Window
20935: Solution: Actual Row Count
20936: VB programming
20937: Replace with an Offset?
20938: Shortcut keys not working .... <grrrr>
20939: Deleting Rows Based on Column Critieria
20940: Simple query
20941: IMPORTING WORD TO EXCEL
20942: Enhanced Inputbox
20943: comments in cell and web pages
20944: Get cell address from Lookup function results
20945: Sheets("Sheet").Copy problem
20946: File save As
20947: UDF won't refresh - please help
20948: Custom Button that will automatically open another application (SA
20949: Convert to HTML and e-mail selection as the body of the e-mail.
20950: Refreshing external data
20951: CallByName() doesn't
20952: Remove Command Bar when excel file closes
20953: Referencing an add-in in VBA
20954: ADO Recordset to Msgbox
20955: Trach Changes Without sharing the workbook
20956: Counting data
20957: Reading files in alphabetic order
20958: Copy and past using a lookup
20959: UDF using Dates
20960: Validating/Checking data integrity in cells
20961: Adding an appointment to Outlook
20962: VBA Help downloadable ?
20963: Mandatory Field in Excel 2002
20964: Update Links after Closing Linked File
20965: Textbox font color change (update, but still not quite there)
20966: Fixed Width Layout
20967: copy certain data in a excel to another excel
20968: Delete Cells when error
20969: How do I: Query AD from a list of usernames in Excel
20970: Using dedicated spreadsheet
20971: Converting a Column of Numbers Displayed as Text to Numbers
20972: xl2007 limits on TRANSPOSE and INDEX functions?
20973: Insert Formula
20974: Storing flag values at worksheet level (Property or Properties)
20975: Making a selection while using a formula in case of redundant records?
20976: worksheet change problems
20977: Having trouble with this code
20978: weird bug - Excel 2007
20979: If cell equals anything then
20980: Selectiemenu in Excel
20981: FileDialog question
20982: vlookup - Multiple references
20983: On_timer Q
20984: Input box format variable to $0.00 Format
20985: UserForm text does not wrap
20986: Reference offset cell
20987: Excel into Excel
20988: Add Custom Button to Quick Access Toolbar
20989: Excel issue ...
20990: making a function usable in every sheet
20991: Copy/Paste Column Issue Using a Range
20992: procedure too large
20993: Why is my variable assignment not working?
20994: branching macro
20995: Dynamic dropdown?
20996: Compare two worksheets and Highlight duplicates in each
20997: Edit/Replace from table or named range?
20998: Rotate Control
20999: Show Tabs by date
21000: Passing contents of a cell to a macro