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

view full version: back to formated view

23101: Copy and Paste seperate ranges in excel
23102: Setting Chart Range
23103: Change Format of Only Some Text in Cell
23104: create a file, put a excel sheet in and a icon
23105: Excel template link to table
23106: VBA with Linest non-equal observations
23107: Confirm Data from Other Cells
23108: MORE combobox questions
23109: Read from source of a Website to Excel
23110: Ribbon command idMso for "Insert Cells"?
23111: Help with code for selecting pivot table field by typing in a cell
23112: Choose a macro from within a macro
23113: code to save as webpage
23114: format all sheets
23115: target.offset(0,-1) does not work as assumed
23116: Prevent Repeating Data Entry
23117: Timer to lock spreadsheet?
23118: workbook_open no longer occurs
23119: Decimal Symbol
23120: ODBC bridge to oracle with vbs
23121: Sleep Mode
23122: Have macro ignore error
23123: Concatenate list of cell values into one cell
23124: Excel / Access User Conference
23125: Form Click event...
23126: Cell pattern-style and color in Excel 2007
23127: Query Error? (Works in mySQL)
23128: close workbook/pdf conversion
23129: Help setting chart series values with non-continuous range
23130: how to consolidate two ranges in a new workbook
23131: "Catastrophic Failure" error using ADO to query Excel Workbook...
23132: Return to module after userform
23133: Loop works correctly but takes extremely long to execute
23134: Vista Registry Entries
23135: Excel conditional formatting - how to make exceptions?
23136: Combine data in rows based on two citeria
23137: How to get a date stamp whenever a value is changed?
23138: Workbook reference
23139: Pause while user clicks on chart series
23140: Add-in version check
23141: determine if cell is #N/A
23142: Double Double Quotes
23143: passing objects
23144: Excel Calander code changes
23145: Loop through range and open files
23146: Capture OLE Error
23147: Formula Programming
23148: myRow = Cells(Rows.Count, 2).End(xlUp).Row
23149: New China Sex Hotline!
23150: New China Sex Hotline!
23151: Two columns combined into one dropdownlist
23152: Programing a button to copy and email
23153: Highlighting when a cells contents has changed
23154: PivotCharts On The Same Sheet
23155: New China Sex Hotline!
23156: New China Sex Hotline!
23157: Hyperlink or Command Button Program
23158: Theory behind passing workbook
23159: "%^{F9}" doesn't cause calcaulation
23160: Program a cell to add its contents to another cell
23161: Test on Username
23162: re-asking for help
23163: Excel 2007 - Crash
23164: VBA FEatures Not Working
23165: Vlookup error
23166: Tricky chart axes synchronising question
23167: Setting Autofilter using code
23168: Convert Excel file to Txt file
23169: Filling Lists with Workbook_Open
23170: Reversing bytes
23171: Sorting product row with header result
23172: edit and Forward email
23173: Any way to use R1C1 notation to access an online spreadsheet in a ZIP file??
23174: Re-size active window
23175: Close Shell
23176: Macro for opening and copying
23177: Populating One Listbox from a second listbox
23178: running code only in selected module
23179: SORT: Is it possible to supply operands via function / vba sub?
23180: Application.match - apparent error?
23181: Format problem
23182: PivotTable.columnfields(index) vs Pivotcell.columnitem(index)
23183: Keep formating from old sheet in the new sheet
23184: Querytable Class Module
23185: Listbox ColumnCount = 3
23186: If statement to call module based on cell value
23187: Display ONLY the LEFT Most 6 Charaters
23188: Restore an invisible commandbutton on open?
23189: RE: Gaining the correct Listbox Column value
23190: Avoid Window Message while deleting a sheet
23191: Method 'Union' of object '_Application' failed (Runtime Error 1004
23192: UCase Column BH in a Sheet
23193: converting cell formulas to into VB
23194: sent as attachment
23195: Pause While User Clicks on Chart Series
23196: Script works very slow!
23197: chart formatting
23198: Text string to a number
23199: Cell pattern-style and color in Excel 2007
23200: Interview test questions?
23201: First Time VBA user- really easy question :-)
23202: Program Pivot Table Buttons
23203: Program so that clicking on a cell will copy that cell to another
23204: Call and list Specific Files Under One Directory
23205: chart formatting
23206: create a folder
23207: 2002 Vs 2003
23208: Using Goal Seek without a macro
23209: Call Macro
23210: Tab color, Font color
23211: Find and Replace
23212: active Printer
23213: adding ComboBox programitacally
23214: dont confirm save with yes/no/cancell
23215: Selecting the item in combobox in excel file through C# application
23216: taborder excel
23217: Sub to check & force open Parent.xls
23218: Rows Group -looping issue
23219: Deleting Workbook
23220: Browse to Network Share
23221: Passing Excel Values back to a SQL Table
23222: code to run once on first open after save
23223: Programing a button in excel
23224: merge sheets based on common id with VBA
23225: ADO Error Handling
23226: Data Validation Unique List & Alphabetized
23227: Minimum/Maximum Dates in Range
23228: Updating a datasheet without all the blinking
23229: "Code Page" ??
23230: Workbook.Open Question
23231: VBA editor problem
23232: Macro not exiting correctly
23233: Can I write a macro to ask for a specific number?
23234: Copy a Range of Data to another Work Sheet
23235: Deploying an Excel 2003 Automation addin (C#)
23236: Adding event when sheet created
23237: extracting data in an array
23238: Radio Buttons
23239: Two problems with Application.Run "ATPVBAEN.XLA!Random"
23240: Searching for values in a given range and then prepending a formula
23241: date created on picture files
23242: Rental fees
23243: Menu add-in
23244: Countif type thingy...
23245: changing font colour
23246: SheetBeforeDoubleClick and merged cells
23247: send to command/ e-mail and attachments
23248: send information to word
23249: Hide Scrollbars
23250: update multiple cells by a percentage
23251: Writing own formula
23252: Open "xlDialogChangeLink" Dialog with VBA/VB.Net
23253: Is it possible to get data from several word files having static format to one excel worksheet.
23254: Macro or VBA Code to un tick CheckBox
23255: HELP ListBox Save Data to Hidden Sheet, and ReLoad It upon opening
23256: Opening a file
23257: Very simple...early vba learner - range name in excel and in vba...
23258: No sound with display
23259: Accessing a Remote Server
23260: macro to run on first open after save and close
23261: Print form from other application
23262: macro from desktop
23263: refreshing web queries
23264: Populating Cells From Dropdown Lists Aimed At Other Worksheets?
23265: Day calculator form Given Date
23266: VBA Converters Excel 2000 to Excel 2007
23267: auto safe macro for workbook
23268: Help with Copy based on dates code!
23269: Paste Problem
23270: paste macro to a workbook code
23271: VBScript from VBA excel / wshShell.Run failed, error 80070483
23272: export a workbook to specific loc on other computer via internet
23273: Old VBA code in MS office 2007?
23274: .activate on hidden sheet
23275: auto save code for vb in excell
23276: Is it feasible to use Excel as a database front-end?
23277: Hiding the Insert New Worksheet tab in Excel 2007
23278: if a cell equal to zero how can it delete entire row
23279: Autofill in Database problem
23280: excel prob - cant save worksheet if someone has it open in a veiwe
23281: Generate sheet names from list, assign data to summary sheet.
23282: Macros in Excel that work with Word - 2003
23283: pivot tables long string formula for calculated field
23284: Strange userform activate behavior
23285: how to create a new workbook based on a template...
23286: VBA code store address with areas separated with "," and I need it sometimes with ";" instead
23287: Faster way to find what part of a range (actually addresses) not intersect with another one?
23288: Embedding Data From MS Access Table?
23289: Partitions in Short Cut menues
23290: VBA reference via code
23291: Help in highlighting and displaying found data.
23292: problem with With, End with...
23293: VBA Run time error 91
23294: Return blank cell from conditional
23295: how do i get system id to a excel sheet
23296: Delete All VBA
23297: Arrays and Loops
23298: Sendkeys in Visual Basic
23299: controls in excel
23300: restricting data entry to non-times
23301: data validation
23302: Total Value of a Range
23303: Breaking the data of column A into two columns First Name & Last name.
23304: Who launched Excell?
23305: Change Case for Names
23306: Lost Important data
23307: Launch external file based on cell value
23308: How to delete selected columns?
23309: data entry restricted to non-times
23310: Combine like rows
23311: Unable to open file
23312: Unable to Open Excel File
23313: Use VB to move to adjacent cell
23314: Testing for and ungrouping grouped sheets
23315: Sort Runtime Erroe 1004
23316: Unhide 1 column at a time from named range
23317: Print Charts
23318: Formula will not evaluate in VBA
23319: Macro - how to
23320: Need help with an excel macro im trying to make
23321: VB Code for saving PDF Print File
23322: Macro to delete rows with different data
23323: TextToColumns Method: How to use xlFixedWidth?
23324: Exit All Sub Command?
23325: VBA userform troubles... adding to database no problem....updating modifying info = :(
23326: Help: Unprotect Sheet Re-Protect Permitting 1 row Deletion
23327: macro to locate picture
23328: Need help with multi-row filter/sort
23329: Excel VBA cause Word to Crash
23330: Not existing procedure correctly
23331: How can I download from the web thru VBA
23332: referencing file paths
23333: How to Use a ListBox to Print Files in a particular order
23334: Color Palette
23335: Prompt for user information at startup
23336: summing groups in a column
23337: Need an explanation
23338: How I calculate an integral in VBA for excel
23339: animated image in user form
23340: Code to check if word doc is already open
23341: Adding to rows - sign issue??
23342: For...Next Loop
23343: Chart Events...
23344: Find the last cell in a selected range?
23345: I Dunno
23346: Having "Or" in If statements in VB doesn't work?
23347: If blank cell continue macro
23348: Setting a user's "Regional Options - Short Date" from Excel?
23349: Range Syntax for Script
23350: grab values from a range
23351: Creating VBA Functions When Creating Spreadsheet Via VBA?
23352: Trying to write macro to combine data in multiple tabs into a single tab.
23353: How to sort in most effcient way?
23354: Getting data from IE
23355: automatically numbering cells for large data from other sheets
23356: auto count-if with subtotal's autofiltered layout
23357: Most efficient code to "flip" a range of values + vs -
23358: Set Focus on dialog box
23359: Equating page filter value to a cell drop-down value
23360: Highlighting cells when errors occur
23361: Download text file from website
23362: Beta distribution t test
23363: Applying a macro to a range of cells
23364: Merging excel worksheets
23365: File Name
23366: MS Query
23367: Disable only the Insert Column option in Right Click
23368: early beginner not satisfied with simple macro
23369: Finding the first instance of a name or partial name in a list of names
23370: stringed userforms won't hide
23371: Manual created in Lotus
23372: Excel 2007 builtin dialogs
23373: general query about reporting of procedures
23374: Convert Date/time to date only in vba
23375: HOW CAN I do"T0 C0NVERT TIMEING IN TO MONEY WITH 'IF' CONDITION"
23376: Data from Access using ADO
23377: Help! Plotting to scatter graph
23378: Last Entry
23379: Tree View; selecting and pasting data to cell
23380: change format of dropdown list in combo box
23381: Gaining the correct Listbox Column value
23382: Combine similiar rows
23383: Using a Macro Button to Move to a Different Cell
23384: setting up library check out
23385: Best position in VBA code line for
23386: Hiding/Restoring Built-In CommandBars?
23387: Range and non contiguous cells
23388: Creating a Pivot Table with VBA
23389: combobox in userform
23390: check to ensure all files in folder
23391: Documenting a macro
23392: VBA Find and Replace isn't working on apostrophe within cell value
23393: [Excel 2007] Set Focus on Dialog
23394: Updating a SQL table with information entered in an Excel Database
23395: Input Color Scheme for Date Column
23396: Combobox drop down
23397: Need to loop
23398: Random Number Array
23399: From Access to Excel Question - VBA review
23400: Find the Length of a Text File
23401: vba to loop until process finished
23402: Iterating Through Workbook if Don't Know Sheet Names
23403: How do I Compare common fields to update a Master table
23404: Comparing multiple fields in an array with multiple fields in a table.
23405: RefEdit Control
23406: Merge into a Template Form?
23407: Need help with formula please
23408: Adding two columns ...please help
23409: copying every other row
23410: export to outlook task list...
23411: Long shot? Copy rows but have XL2K insert a space between each row??
23412: Insert to Access table
23413: Complicated Formula?
23414: Highlighting whole row in this macro
23415: Worksheet_Change - determine how it is triggered
23416: Procedures stop with no indication of problem
23417: Capturing a Drop Event
23418: Function reading range with formulas
23419: Need error trap
23420: Open a wb and keep the focus on it
23421: Macro to select multiple columns
23422: Determining formula reference type
23423: Looping over non-contiguous column selection
23424: Forcing PT page filter values to equal my cell value on summary pa
23425: Macro to change pictures
23426: Problem with Format function
23427: Customized Menu Executes Without Mouse Click
23428: Nulls within a .Find command
23429: Save a copy from cell data and close orignal
23430: How to detect if a macro is in the middle of running
23431: How to insert the Thousands Separator (comma) in Excel?
23432: Sum Range of Cells to a Target Value
23433: help me clean up this code
23434: combo box list error
23435: Find and Replace Exact Match
23436: Cut/Paste Duplicates code?
23437: Automatically "Click" Default Button on Message Boxes
23438: Created automatically sequence numbers
23439: Testing each cell for error
23440: Replace method problems
23441: create formula with seperate cells
23442: ADODB over HTTP?
23443: distributed vba project - multiple thread / concurrent file access
23444: Entry Form Problem
23445: Charting - bubble series
23446: Accessing external excel files
23447: Missing "Examples" and "See Also" in VBA help
23448: Private Student Loan Consolidation Programs
23449: Uppercase in non adjacent columns
23450: ADO: run a stored Access query from Excel