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

view full version: back to formated view

14351: Compare Columns, Find Matches
14352: MultiPage Page Order
14353: Add custom icon using VBA
14354: Reading Directories
14355: Extract data from seperate files-macro
14356: ADODB Connection in Same Excel File
14357: Identify defined name range by another cell value
14358: How to create pivot table from web query
14359: Formula for list summary
14360: MACRO TO BRING WORDART ON CELL VALUE
14361: Invalid Precision: cbColDef value out of range
14362: find
14363: Selecting dates from current week with Macro
14364: try to email with vba, but more than one sheet and convert to pdf
14365: Problems with an if (using rng Nothing) - only to produce sheet given
14366: Make excel Worksheet as data base
14367: How do you programatically format embedded charts
14368: Restoring the Macro Recorder to Default w/ relative references sho
14369: Code that will rerun or refresh a pivot table (after new data is
14370: Last cell with constant in a sheet
14371: how do I disable spell check in email sent from Excel macro
14372: Auto Number Excel Forms During Save As
14373: Synchronize Combo Boxes?
14374: Listing installed COM add-ins
14375: Deleting Duplicate Rows In a Selection with a True Statement
14376: Making changes on "grouped" sheets via code
14377: SQL with Excel ranges
14378: Inconsistent behavior using VLOOKUP
14379: vba editor comes up everytime this specific macro is run
14380: Determine if a shared workbook is open
14381: vba editor comes up whenever macro is run.
14382: VBA and Excel 2007
14383: Plot Area Changes Automatically When Updated
14384: Sum / countif data range
14385: pulling apart a field
14386: pivot table order
14387: return to first column of next row
14388: Limit Dates in Pivot Table
14389: Invalid Precision: cbColDef value out of range
14390: Numbers Not Calculating Correct on Userform
14391: Formula to add a date to a cell that is 6 months from today
14392: Maximum number of named ranges?
14393: Adding validation fails with automation error
14394: Goal Seek with dynamic Goal Seek
14395: ExportAsFixedFormat for Multiple Sheets in a Single Excel File
14396: Configure Built-in Font Color Command Button?
14397: align and resize controls
14398: Conditional Formatting and Text Alignment
14399: If column = value sum another column and place result in cell
14400: From VB6 how to determine if an Excel cell string contains
14401: Pivot table from xml data
14402: Code for file download
14403: Code for file download
14404: No... while trying to update to Excel file
14405: COPY FORMULA TO THE LAST CELL
14406: Save As PDF / XPS
14407: Range is nothing
14408: Replace last three characters
14409: Zip and mail more than one sheet from the ActiveWorkbook
14410: disable clear all using VBA
14411: Display formula result in a popup.
14412: Time conversions from data dump
14413: Integartion of BDC into Excel services
14414: Help passing Range to Class Module method
14415: identifying the end of a data column
14416: Vlookup and #N/A
14417: Text Box
14418: VBA block cell copying.
14419: Multiple Windows in Single file
14420: DATE IN COMPUTATION
14421: most efficient way to filter out and iterate through XLS databases
14422: Loops stop working and presents "1004':
14423: SumIF
14424: EVALUATE method returns zero
14425: Custom menus don't appear under custom ribbon tab
14426: Adding AUTOSUM to Cell menu in Excel 2007
14427: Loops stop working and presents "Run time error '91':
14428: Variables in Variables
14429: Conditional Format
14430: Workbook Open bypasses Query Refresh
14431: Filtering one or more items in 2 columns
14432: coding for variable rows
14433: How to see cell value exactly as Excel displays it?
14434: Need help to enter text in Polish language
14435: outlook express 6 glitch
14436: Why is my vbasum(F1:F45) called 46 times?
14437: Message Box Help
14438: return row header as answer
14439: .Formula vs .Value?
14440: Check cells in row for last cell with data to use as multiplier?
14441: Set Formatting Menu Font Color with VBA
14442: UserForm and user input
14443: For Each ws autofill
14444: Create worksheets based on value
14445: How to refresh a pivot table that uses changing source data
14446: Bloomberg API: Preserving Values?
14447: Sending Email to non-standard address using CDO?
14448: return chart's source data location/range
14449: Record Not in Access DB
14450: Random phantom breakpoints and random bogus compile errors
14451: PLEASE HELP!!
14452: Importing Specific Data From Multiple Pages From The Web
14453: Change background color based on cell value in vb?? Current code not
14454: How can I hide contents of a cell and password protect to reveal
14455: VBA 6.5 on older systems
14456: GetPivotData - Why does the reference not change when I drag the
14457: format in VBA
14458: Subscript out of Range
14459: Obj Variable or withblock variable not set?
14460: Save Copy or Cut Reference
14461: Use criteria in an Advanced Autofilter's single column
14462: Transpose 3 columns into Single column
14463: Return the first 2 letters of a Cell Value
14464: Vlookup across workbooks
14465: Inserting rows if a particular item is chosen from a list
14466: copy formulas on a weekly basis to next available
14467: having trouble with a chart range
14468: Excel runs much slower in console app
14469: Zip and mail more than one sheet from the ActiveWorkbook
14470: How to run a process in the background?
14471: Multi-level User Definet Types
14472: respostX2 - deleting blank rows after macro-generated pivot table
14473: respostX2 - deleting blank rows after macro-generated pivot table
14474: VBA Error
14475: Passwords on files used in calculation
14476: Macro to Transpose All Items in a Vertical List, and Add a Comma
14477: Downloading into a column
14478: Which cell is calling a user-defined function?
14479: Getting/using the File path of a spreadsheet
14480: Help needed with macro
14481: Excel program
14482: Look up data.. help please :-)
14483: Referring to merged columns in range object
14484: count column c with condition in column A
14485: Using the result of an input box
14486: Creating a line break (newline) in a cell with SpreadsheetML
14487: Reset of radio button values without calling _Click() function
14488: Custom Context menu (Right click menu) not working in sheet change
14489: Copy worsheet from different files in to one file
14490: Crash on ActiveWindow.Close
14491: Variable not seen
14492: Simple question
14493: exclude holidays on UserForm Calendar control
14494: application.filesearch error in excel 2007
14495: Sheet Select
14496: Look Up sheets
14497: Unable to view search results
14498: HELP Debug
14499: Code for a Macro that allows a Pivot table to be repeatedly run (for
14500: application.goto reference using references in the worksheet
14501: Converting a number todate
14502: Macro not running when Image/Button Object is pressed
14503: delete all rows where cell is not date format
14504: if cell is not date format delete row
14505: if cell is not date format delete row
14506: if cell is not date format delete row
14507: Scrambleing data when refresh
14508: Combobox that populates text boxes on userform
14509: Reactivating file based on text value producees subscript error
14510: help with "Goto" command
14511: Combo Box Wont Show Values
14512: Help with autofiltering a list based on criteria
14513: How can I tell the shape of a Variant containing an Array?
14514: Calendar using TODAY function
14515: Insert "/" into cells that contain data, using a macro
14516: app.quit
14517: why would a large addin save in 2 seconds or 18 seconds
14518: run code *after* drop down list choice
14519: page header multiple rows
14520: wait function
14521: if - then actions
14522: Changing a horizontal axis crosses value using VBA
14523: circular argument
14524: check column -A- and fill out column -B- by vba
14525: Ranges in VBA
14526: Writing text at end of spreadsheet
14527: Conditional Formating
14528: transpose loop
14529: CC Field Q
14530: Automate Monthly Task
14531: user form tabs
14532: Filtering Data Based On Different Criteria
14533: Programmatically adding code to worksheet
14534: Pivot Tables
14535: Concatenate Rows depending on cell value in rows
14536: What does it take to get class functions to execute?
14537: html help and custom msgbox
14538: Page Fields Converting to Text
14539: Using calculated fields to count unique items in a pivot table
14540: getting data from website's url and webpage
14541: Rename worksheet tabs
14542: Copy a Range that matches Todays date Q
14543: v lookup problem
14544: cell top of screen
14545: How can I sort contents of one column based on the contents of
14546: Dialogs(xlDialog...).Show arguments usage
14547: getformat
14548: Pivot Table Macro - How to describe the Active range (so that the
14549: Why doesnt this work?
14550: AutoShape Macro Help
14551: comparing values that don't equal but do equal?
14552: Filter Data based on criteria
14553: Seperate letters and numbers in a cell
14554: Protect workbook when saving
14555: Excel Automation
14556: Adding Cells and Indexing
14557: ScreenUpdating Not Working
14558: delete rows where value in Column B=0
14559: Need loop guidance
14560: Using Cell Numbers in a range
14561: Row number of filtered row
14562: Variable value
14563: R1:C1 format
14564: Function
14565: Using ADO from Excel form to relational Access Db
14566: Referencing two versions Object models
14567: Locking worksheet based on the cell value
14568: Copy/Paste data based on a criteria
14569: array formula to extract members of list A that are not in list B
14570: How to include field name in CopyFromRecordset
14571: Filesearch error in Excel 2007
14572: Find first empty cell in range and paste formula??
14573: Control don't refresh
14574: How to add a text box with scroll bars in excel 2007?
14575: Minimum references required
14576: Count items in a column
14577: Excel Functionality
14578: Code Help
14579: Code Crashing
14580: use option button background color to format cells
14581: Value cells
14582: Skip part of macro on re-run?
14583: msgbox
14584: worksheet as data entry for Access database?
14585: Increasing and decreasing cell values
14586: Copy and pasting based on criteria
14587: Coded to delete extra rows after pivot table
14588: Open And Close Form
14589: Adding a second line in a header or footer through VBA
14590: Paste not working again
14591: How can I change the caller cell's format into "mm/dd/yyyy"?
14592: Macro to split data
14593: Passing Parameters to an ODBC
14594: Opening files from Excel
14595: Accessibility of a server
14596: What programming to use in VBA to convert in to number?
14597: lost reference to activesheet when opening workbook inside IE
14598: read Matrix
14599: OUT OF OFFICE IN OUTLOOK 2007
14600: Copy to
14601: Query refreshing inside a loop - out of memory
14602: Getting error using Month()
14603: Asian file names
14604: Totally Lost
14605: Macro freeze up
14606: blank display while macro runs
14607: Excel 2007 filesearch
14608: Instr
14609: Excel 2007 ambiguous name detected:Worksheet_Change
14610: links
14611: Need help with a macro that takes information from another workboo
14612: Can Not Complete This Task with Available Resources
14613: Import text files to cells
14614: Copying a chart included in a range
14615: Counting Octals.
14616: Userform
14617: How to put a button on a cell and assign macro to it?
14618: Deploying Excel 2007 VBA Project in an Office 2007 Standard enviro
14619: Looping through columns
14620: AMENDMENT IN MACRO
14621: extract certain values from multiple workbooks into a new file
14622: highlighting rows
14623: calling .net exe file from within SSIS script task
14624: Summary page
14625: Getting #VALUE! while entering UDF as an array function
14626: Activating a workbook
14627: Custom Toolbar question - newbie
14628: userform closing after input
14629: Code that searches a column, then copies and pastes any matches into
14630: Setting a variable = ActiveWorkbook
14631: code to delete all rows beneath and columns right of pivot table
14632: peraphs impossible... order line base color...
14633: Copy data from worksheet to another automatically
14634: Closing VBE systematically
14635: Remove/Inactivate "X" in UserForm
14636: Pivot Tables: Hide detail for a RowField via code: Get an Error?
14637: Exclude rows with result 1
14638: Calling a user Function in Worksheet
14639: If cell value = x or y then perform formula set else skip
14640: How to read in cell border?
14641: Copy Error
14642: Average - without zero?
14643: Best Substitute for Range(cells(),cells()) in worksheet
14644: Windows API - File Menu Processing...
14645: Easy Question: Cell Value
14646: Bloomberg download
14647: Image in Userform looses quality
14648: Excel 2007 VBA - Can't type in VBA editor
14649: Automatically populating new rows with formuals above
14650: Forcing cell value update/refresh
14651: Add Column at the end with concatenate formula
14652: Count CheckBoxes in a Frame that are True
14653: How to set Range variable to point to End(xlDown) cell?
14654: Conditional Formatting
14655: Advanced tool uses TrueType fonts to represent tiny charts
14656: Filter out Non-Number (i.e. Text) Cells
14657: Combobox
14658: VBA, copy lines with specific value
14659: Save Changes to Add-In
14660: VBA Project Passwords
14661: save and add to CSV file
14662: save workbook without code
14663: How to get the last valid (non blank) cell index?
14664: how to detect if macros been disabled
14665: Copy & Paste...if
14666: Import from Excel to an access database using Jet in vb.net
14667: hide name box
14668: IF statement for lookup matchup
14669: Excel Error
14670: UDF Function or Macro Needed
14671: Updating Listbox in Excel Form
14672: Updating Listbox in Excel Form
14673: Updating Listbox in Excel Form
14674: Public oMyClass As New MyProject.MyClass
14675: best way to get an updatable SQL Server 2000 recordset into Excel?
14676: Not ScreenUpdating with PrintOut Property
14677: Enter Key Press Event
14678: Inserting a picture into a Userform from a stored location
14679: Using VBA to change the color of the active cell if the value in that
14680: How to automate Print Zoom to fill page
14681: An old macro needs updating
14682: Macro's
14683: drop down change event
14684: isblank macro
14685: DELETE ROWS ACCORDING TO FIGURES
14686: Run time error 2147319765(8002802b)
14687: Setting cells to change colors as a date approaches
14688: Shopping Cart application
14689: range with variable row
14690: protect my sql query
14691: Checking Data, Help Please
14692: Information dependent on other information
14693: Block games in Excel
14694: Deleting Worksheets
14695: Questions on Ron de Bruin's Excel Email Macro
14696: hyperlink follow through and save file
14697: If Then else
14698: Circular reference, Maximum number of formulas
14699: 0E560 = 0?
14700: Withdrawing a template from "Data tracking"