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

view full version: back to formated view

17151: Run Time Error 6028: Help?
17152: Import data from a secure website to Excel
17153: Button to email?
17154: Whats happened?
17155: Find a Number and Date - VBA
17156: pivot table running total problem
17157: Stamp a Cell with Time Q
17158: Help with For Each ... Next and control
17159: row index number in a hlookup formula
17160: Data Validation Macro
17161: Compound IF statement
17162: File Exist
17163: Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
17164: all open workbooks
17165: end if without block if error
17166: Dates and Conditional Formatting
17167: Return Value from MsgBox
17168: Is Worksheet Empty?
17169: Macro function to read text file
17170: Selective Worksheet printing
17171: Save it giving as a name the content of a cell
17172: named range as rowsource
17173: Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"
17174: How to Find the last non empty row
17175: Two related Data Validation lists
17176: Table Live
17177: a1+a2=a3 How can I change a2,keep old a2 value & increase a3
17178: MsgBox with Two Questions
17179: Cal formula upon sorting
17180: linked cells not updating
17181: can't activate chart
17182: Null Value
17183: Copy Module to new Workbook
17184: creating a formula with a loop
17185: Tidying Recorded Macro Code
17186: Macro to change font
17187: Cannot change column name in Excel's MS Query tool
17188: Accessing the text of a form command button from underlying macro
17189: Make shortcut to Excelfile on desktop
17190: select data from dropdown menu
17191: Error on E-Mailing Q
17192: Build whre statement
17193: Invoke Edit Mode
17194: Changing a two-dimensional, one row array to one-dimensional
17195: value of one cell in a named range
17196: NUMERICALS CAN CHANGE IN ALPHABHATS
17197: How do I create a pulldown value list for data entry?
17198: form population macro
17199: How to write code for find a word in excel?
17200: Pivot Table Custom Filters
17201: Find a Number and Date ...
17202: Transfer data from one workbook to another workbook based on a key
17203: Pivot Tables - DisplayEmptyColumn question
17204: AutoFilter
17205: Visual Basic v6.3 and Excel v2002
17206: VB Help/Request? Compare and insert to different data in columns
17207: Capturing Listbox Selections
17208: Conditional Formatted numbers add based on color?
17209: On File Open
17210: Counting Worksheets
17211: Finding the path of a folder
17212: if questions
17213: Buttons disappear when projected
17214: Any way to enable the 2007 pivot table option Defer Layout Update with VBA?
17215: Question on this conversion code switching between r1c1 to A1 format tia sal2
17216: Hiding Columns
17217: goal seek reference
17218: Run-time error
17219: type mismatch error when passing collection byRef
17220: Only want to see half of my result
17221: Remove a cell from a range
17222: running Access procedure from Excel
17223: Macro to delete rows
17224: how to suppress auto correct?
17225: Xlusrgal
17226: Import from MS Access - Lose the drive letter..link only to drive
17227: Fill Cell with Asterix
17228: Hide all toolbars/menu bar when open file
17229: Counting elements of array and range type data
17230: Answer msgbox with macro
17231: Copy Command Button Code.
17232: Undefined MergeArea when MergeCells is true
17233: Changing Numeric value to text
17234: IF statement in excel
17235: Key combinations not used by Excel to use in macro keyboard shortcuts?
17236: Find error!!!! Is there any other way to do this?
17237: Find error!!!! Is there any other way to do this?
17238: how to recognise a c# dll in vba excel
17239: Not Enough Memory to run Microsoft Office Excel.
17240: allcaps option in excel like word
17241: Preventing corruption of dynamic range names on cell deletion
17242: Application.Volatile not working
17243: Deactivate Code
17244: transforming poll data from rows to colums
17245: Help- It's only a tiny change
17246: Exception occured
17247: TreeView1
17248: Open Forum 4 ALL
17249: Check a workbook exists before opening
17250: "view page breaks"
17251: Getting file name and Modified date
17252: Linking to several other spreadsheets
17253: I need help programming a joke on a friend.
17254: Conditional formatting based on what function is used in a cell.
17255: Columns limit 512
17256: Using an Array to Speed-Up Range Copy
17257: Set Class1Var = New Class1
17258: Working with huge cells
17259: Matching two worksheet?
17260: align left and right in listbox
17261: How to print out matching names?
17262: macro to color all text red in worksheet if within certain date
17263: Excel error message
17264: check control names
17265: Deleting Rows if certain criteria isnt met
17266: Starting excel and running it on the same process
17267: excel 2003 Reading workbook properties / details from an XLA how do you do it?
17268: excel 2003 Reading workbook properties / details from an XLA how do you do it?
17269: Auto number formatting
17270: Hide rows and prevent unhiding
17271: Inserting sender in voting response
17272: Workbooks.Add = Macro Regression in 2007
17273: sql
17274: Macro to copy data with a date criteria
17275: Use cell values as object names
17276: VBA code to email 1 worksheet in a workbook
17277: Instead of the word "dropped" could I use an arrow?
17278: VBA Question - Delete set if any member meets criteria
17279: Removing Blank Rows for Excel VB Newb
17280: Calendar with weeknumber?
17281: How do I use the Shift+Ctrl+down feature in a macro
17282: code reopens file
17283: Active worksheet problem
17284: macro to close file and not save changes
17285: Partial sheet protection
17286: Copy only basic number without dollar sign or commas (or cell formatting)?
17287: Best way to import .csv
17288: Is there a way to run a procedure before the paste command?
17289: Tab printing Macro
17290: Macro acting wierd with Zip Codes
17291: Missing Reference causing strange errors
17292: What's the fastest way to push this data around?
17293: hide sheet
17294: Code to Print single cells
17295: Worksheet_Change
17296: Grouping Checkboxes in a UserForm
17297: display cell contents
17298: range values
17299: Two Parter: filter list and search for a match for the password
17300: If Then statement comparing date values
17301: Flag me if macro errors
17302: Worksheet Change event code, but retain Undo?
17303: Why does VBA mess up
17304: Checking if a property contains another specific string
17305: Batch deleting invalid defined names from a workbook
17306: this code crashes excel. How come?
17307: Code to Create a Command Button
17308: Can VBA Code change itself?
17309: Printing to Local Printer and the not the default printer.
17310: Location of Cell with Value in Merge Area
17311: Finding Embedded Object Type in Worksheet
17312: Finding embedded object type in Excel Worksheet
17313: Excel / Access User Conference - Oct 24-26, St Loiuis
17314: use a variable for a worksheet name in a formula
17315: How to create a time log sheet
17316: Excel cannot complete this task with available resources. choose less data or close other applications
17317: defined name with formula as source in VBA
17318: Copy-pasting from Excel to Word
17319: opening a file from a cell reference
17320: Is there a code to clear clipboard to prevent pasting on mouse mov
17321: Export and Import Userform from Excel-file to another Excel-file
17322: Using Shape's OnAction property in C#
17323: Draw Entries
17324: Error in Insert Row command.
17325: Conversion from columnwise to rowwise
17326: Excel macros
17327: Find function using chr
17328: Track Changes History sheet (Who changed the last cell)
17329: Code Needed For a Macro
17330: Selection.Replace What and double quotes
17331: help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
17332: Hiding Columns
17333: Split first name and Surname
17334: copy checkbox to multiple cells?
17335: Formatting the excel window
17336: Sheet CodeNames
17337: Stop a user from opening Excel if the Add-in is not found
17338: Sumproduct, array
17339: Option Explicit when install Essbase
17340: can't transfer to worksheet
17341: Auto size named range by .Net or VBA
17342: How do they do that?
17343: Macro not running when it is supposed too
17344: array data to cells
17345: Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
17346: Arrays [Why does this not work?]
17347: if database exists... MS Query
17348: Nested IF problem
17349: TRANSPOSE and INDEX limit in Excel2007
17350: Hiding checkboxes
17351: Convert numbers to text (from product id # to name of product)
17352: Search all worksheets
17353: Search all worksheets
17354: help with this loop macro
17355: Finding the nearest match without reusing results
17356: List Worksheet Names in a Dialog
17357: End(XlDown).Row - Problem if only 1 row
17358: Named range reference in VBA for Excel 2007
17359: CHANGING FONT SIZE
17360: How to read a string from a variant array ?
17361: VBA or VBE
17362: Selecting a file in a macro
17363: Formulas
17364: Automatically Creating a Command Button
17365: Open a read only file as a writable file
17366: Change PivotTable Field By Code
17367: Call macro in worksheet from userform?
17368: Specifying a range within an array
17369: Copy a range of cells to all workbooks in a folder?
17370: deleting duplicates
17371: Get the Data Type of a Property
17372: Copy-pasting (unformatted) to a word document
17373: Summary Sheet from range specified in a worksheet
17374: Help saving file; exporting as .csv
17375: Wrong code?
17376: Detecting open workbook
17377: VB Editor Window
17378: Solution: Actual Row Count
17379: VB programming
17380: Replace with an Offset?
17381: Shortcut keys not working .... <grrrr>
17382: Deleting Rows Based on Column Critieria
17383: Simple query
17384: IMPORTING WORD TO EXCEL
17385: Enhanced Inputbox
17386: comments in cell and web pages
17387: Get cell address from Lookup function results
17388: Sheets("Sheet").Copy problem
17389: File save As
17390: UDF won't refresh - please help
17391: Custom Button that will automatically open another application (SA
17392: Convert to HTML and e-mail selection as the body of the e-mail.
17393: Refreshing external data
17394: CallByName() doesn't
17395: Remove Command Bar when excel file closes
17396: Referencing an add-in in VBA
17397: ADO Recordset to Msgbox
17398: Trach Changes Without sharing the workbook
17399: Counting data
17400: Reading files in alphabetic order
17401: Copy and past using a lookup
17402: UDF using Dates
17403: Validating/Checking data integrity in cells
17404: Adding an appointment to Outlook
17405: VBA Help downloadable ?
17406: Mandatory Field in Excel 2002
17407: Update Links after Closing Linked File
17408: Textbox font color change (update, but still not quite there)
17409: Fixed Width Layout
17410: copy certain data in a excel to another excel
17411: Delete Cells when error
17412: How do I: Query AD from a list of usernames in Excel
17413: Using dedicated spreadsheet
17414: Converting a Column of Numbers Displayed as Text to Numbers
17415: xl2007 limits on TRANSPOSE and INDEX functions?
17416: Insert Formula
17417: Storing flag values at worksheet level (Property or Properties)
17418: Making a selection while using a formula in case of redundant records?
17419: worksheet change problems
17420: Having trouble with this code
17421: weird bug - Excel 2007
17422: If cell equals anything then
17423: Selectiemenu in Excel
17424: FileDialog question
17425: vlookup - Multiple references
17426: On_timer Q
17427: Input box format variable to $0.00 Format
17428: UserForm text does not wrap
17429: Reference offset cell
17430: Excel into Excel
17431: Add Custom Button to Quick Access Toolbar
17432: Excel issue ...
17433: making a function usable in every sheet
17434: Copy/Paste Column Issue Using a Range
17435: procedure too large
17436: Why is my variable assignment not working?
17437: branching macro
17438: Dynamic dropdown?
17439: Compare two worksheets and Highlight duplicates in each
17440: Edit/Replace from table or named range?
17441: Rotate Control
17442: Show Tabs by date
17443: Passing contents of a cell to a macro
17444: Excel to Word Bitmap PasteSpecial Problem
17445: Macro Help
17446: Formula JLI
17447: VLOOKUP
17448: Change SELECT FROM When Using Excel to Query Excel
17449: Bitmap PasteSpecial to Word Application
17450: Renaming modules
17451: Copy & Paste to Last Empty Row
17452: Refering to new sheet name
17453: Integrating Excel with Outlook
17454: Using stored variable in a formula
17455: Update Protected Links
17456: Unable extract data from WEB query
17457: Class struggle
17458: Bitmap Pasting to a Word Application
17459: Need help writing output to a file without <cr><lf> carriage contr
17460: SumProduct If?
17461: Why can't I run an assigned macro?
17462: Macro to record sheet name
17463: Append print job to an existing PDF
17464: supress message
17465: WorkSheet customproperties
17466: Personal.xls in Office 2007 and Office 2000
17467: Macro to search for a text string
17468: Help on this code please
17469: Application.StatusBar not refreshing after ThisWorkbook.Close
17470: Macro to AutoAnswer
17471: evaluate contents and select correct column
17472: Find & Replace Whole Words
17473: Newbie: Problem with 'Select Case' testing syntax
17474: RON DE BRUIN: Help with CDO Please
17475: How do I pass a value in a range command
17476: Text lookup and return
17477: programme run help
17478: Help required
17479: Code help
17480: Macro to go to the last value
17481: VBA Userform Textbox help
17482: Web Query
17483: Macro to Search
17484: Need help on the formula
17485: Old Excel 2000 macro won't run under Windows XP
17486: copy until certain condition
17487: Worksheet.Change macro doesn't run in 2007
17488: Copy Selected Range to new sheet
17489: Excel Macros work in Webpage ?
17490: ado connection sql script select via listbox
17491: add multiple controls
17492: Run-time error '9': Subscript out of range
17493: cycle thru controls
17494: Intentionally not validate Sub or Function
17495: Set focus on field not on active page of a multipage
17496: Protected sheet question -- way to allow user to change text alignment and font style?
17497: Macro Removes Cell Borders
17498: splitting text in one column into multiple columns
17499: Export file as a fixed width file
17500: Combining 2 arrays side-by-side