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

view full version: back to formated view

13651: change event
13652: using rowsource to fill a combobox
13653: Day of Week
13654: Control Number - A better way
13655: Cell Update on Paste
13656: Shortcut Key Assigned to Imported Macro (i.e. in personal.xls) Does Not Work
13657: Should TD be HTMLTableCell?
13658: getting the entire range before be filtered
13659: Loop through table of columns and rows
13660: additem removeitem
13661: Macro to schedule downloads
13662: Help me to first row matching First date and last row matching last
13663: Excel workbook save behavior using VB6 very confusing
13664: Delete Specific Sheets
13665: How to Place a Drawing Object on a Worksheet as a Control?
13666: Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code
13667: DialogActiveCellFont
13668: Need to paste/update info to correct row.
13669: Return Control to Userform
13670: List Box Highlight Selection from Sheet
13671: How to populate web page forms from Excel or DB? Is this possible?
13672: Match function not wokring on 2D array
13673: automatically create list of the worksheets
13674: Issue with marco for entire workbook
13675: find error
13676: How to install missing DBNamespace 1.0 Type Library
13677: Find first empty row in a range
13678: automating (alt & f11)
13679: Automatic Toolbar
13680: writing a text file in the same folder as my program
13681: Stripping HTML tags from excel
13682: Set message subject here ...
13683: Tip # 14 To color all sheets in the workbook
13684: Excel has encountered a problem and needs...
13685: macro to return value of worksheets
13686: referencing to external name range that would update automatically
13687: Sorting problem
13688: Linked file Excel 2007
13689: Excel file linking
13690: Excel tables vs. system tables
13691: Running macro in one workbook that refers to variable in another
13692: Delete Row Select Case
13693: I have the slowness problem also
13694: match function - date and time
13695: Subroutine Summing and Outlining
13696: Getting a range using row & col numbers?
13697: Retrieve selected data from Network file
13698: Error Handling Help
13699: alt & f11 via macro
13700: too much space
13701: User Form
13702: Cannot hide columns/rows
13703: combobox dropdown
13704: how to identify a shape as a picture in excel from VB
13705: error 70 permission denied in excel
13706: prefix in text box
13707: E-Mailing macro font options
13708: Formula for day of the week to relate to corresponding date cell
13709: Checking Web Queries
13710: add total from 6 textboxes and put in label
13711: last cell as label caption
13712: show userform/hide workbook
13713: Naming Ranges with code
13714: Displaying programatically worksheet errors messages in a cell
13715: Insert Row & format as per other rows, above/below
13716: manipulating Query data 'on the fly'Question
13717: lastcell
13718: "Toggle Switch" help needed
13719: force text/numbers in text box
13720: range value as label caption
13721: Addins - number of columns & rows in running version of Excel
13722: Triggering macro
13723: Select a series of cells
13724: Searching for a value for and then replacing when found.
13725: Concert number to time
13726: Ok what's the trick to do this?
13727: How to extract aggregate values from PivotTable
13728: Conditional formatting
13729: Cancel Button on file save
13730: Problem in automating using a button created by recording a macro
13731: test
13732: recently used file
13733: Saving multiple worksheets to a master file
13734: Excel Macro: Selecting items from another worksheet without
13735: loop help
13736: Loop help
13737: Sort Data auto on cell range when updated
13738: Add dimesion to Array already populated
13739: Copy & Paste Dynamic Named Range
13740: Help with code
13741: Help! Refrence a userform element from a textbox?
13742: Help! Refrence a userform element from a textbox?
13743: Create VBA function that returns many values
13744: Shell Command Fails (sometimes)
13745: Atofill Questions
13746: Passing result of multiple split function results to 1 Array
13747: sheets
13748: How to copy from each sheet and paste to a summary sheet
13749: Prevent a Worksheet from being deleted
13750: Get Save Prompt when closing workbook immediately after saving
13751: how to save a file and overwrite existing file
13752: Date and Time
13753: MS Excel 2007. ActiveChart.ApplyCustomType
13754: Restore "Delete..." and "Insert..." shortcuts
13755: Using Excel Interop via VS.NET 2005 to create and save a new Excel
13756: "Call" Commandbutton1()
13757: Excel 2007 VB function call return value syntax question
13758: Office 2007 VBA Compatibility??
13759: Filter and count hidden cells problem
13760: Set position of non frooze rows when panes are frooze
13761: Multipage Tab vs Regular Userform
13762: Extracting Text between 2nd and 3rddelimiter
13763: how would i wrtie this formula
13764: VBA for Exporting to Text file
13765: Opening workbook in same directory
13766: passing an argument
13767: Show Time Stamp in Cell when Command Button Clicked
13768: dynamic source range change in pivot table
13769: Copying across values based on criteria
13770: every fifth line
13771: Macro triggered by date
13772: error
13773: Connection problem using DAO
13774: Using Outlook Express for this Newsgroup
13775: Delete Row if value <>
13776: Delete a workbook...
13777: Excel Addin Install via Registry
13778: Leading Zero in .csv format
13779: copy cell until data doesnt exitst anymore
13780: can I copy "2" different Ranges from closed workbook (VBA)
13781: Open, print, close multiple pdf's from macro
13782: Userform Programming
13783: If JobNumber = Val(field(7)) Then Query
13784: hyperlink to sheet with name in cell
13785: Change event for several Textboxes on UserForm
13786: Advanced Filter Error 1004
13787: Search a column to match textbox value from a form
13788: Macro to merge text and delete rows
13789: Combobox drops down blank row
13790: Zero values in Pivot Tables
13791: PivotTable Show Properties in Report - stange behaviour
13792: Macro for export
13793: Updating workbook from protected workbooks...
13794: Input box
13795: ListBox
13796: Force CAPITAL LETTERS
13797: Problems printing Webbrowser Control with a worksheet.
13798: Print To WorkSheet
13799: retrieve text from a text file
13800: Excel Macros sending attachments to multiple e-mail addresses
13801: Automating excel though outlook
13802: re : Copying a range from WB01 and pasting to WB02
13803: How do I create a Graphical Report from Survey responses in Excel
13804: Send parameters in worksheet button > 255 characters
13805: date and time
13806: UDF that returns a date
13807: How to create .HLP for my VBA project
13808: How do I GetCurrentDirectory in Excel?
13809: Worksheet Change from Add-In
13810: Count Sum Problem
13811: cell is merged and contains "something"
13812: how to add
13813: Microsoft Office 2003 Web Services Toolkit 2.01
13814: Excel Macros: Sort which is not Worksheet Specific
13815: format cells so they do not resize
13816: default fill color
13817: Rows & Columns Disaggregation Help
13818: Making code global in workbook
13819: Excel file open in memory?
13820: How come VBA if clause fails?
13821: New user and need help
13822: Linking rows on multiple worksheets
13823: consolidating workbooks(not sheets)
13824: Check column for a value and if not there execute series of functi
13825: Pasting while in edit mode
13826: Is Active Cell in a Range?
13827: Protection on a sheet type thats new to me!
13828: UDF and dynamic range
13829: select and delete all pictures in a given range
13830: Skipping empty cells for a Range object?
13831: Indirect.ext Function Isn't Working for me
13832: How to create msg box if a cell contains value < 0
13833: Run procedure from worksheet change event
13834: Can a For statement work in reverse (from 40 to 1)
13835: multiple if then statements
13836: Analysis of 2 groups?
13837: Digital Certificate Question - Help
13838: Automation of report, daily, monthly then yearly as per need
13839: Running total of Found Substrings in MainString in Big Loop
13840: Copy data from Microsoft Word form into Excel
13841: cell data
13842: Make sense out of right-click class module
13843: Can't save any more in Excel 2007 Compatibility Mode
13844: VBA code executes fine, but compiler throws error. Huh?
13845: perform the same calculation in several spreadsheets
13846: Comment Automargins property
13847: User form
13848: Print causes crash
13849: F9 not working with SumByColor
13850: Run Time Error '91'
13851: Newbie floundering in the VBA code
13852: Another runtime 1004 error
13853: InserPictureInRange method for excel VBA
13854: Blatt-Schutz und Zellen formatieren
13855: find a string in one cells
13856: events
13857: DAO Syntax Problem
13858: VBA to delete leading space
13859: Disappearing Userform Label
13860: Help with VBA runtime error
13861: Activate an variable located workbook and copy 2 ranges?
13862: GETPIVOTDATA with date in referenced cell
13863: Email .From
13864: ComboBox search for variable...
13865: Logical functions AND,OR in array formulas work ?
13866: Creating Outlook Task from Excel
13867: Executing a macro
13868: how to display cell value in formula
13869: searching for shapes
13870: On Cell click, start macro
13871: On Cell click, start macro
13872: .NET and Python Programming with Resolver One Spreadsheet
13873: VLookup if criteria matched
13874: How to concatenate in macro across sheets
13875: Pivot Table Deconstruction
13876: Protect part of Insert comment
13877: Pay Reconciliation
13878: ask user to select a target sheet as an input for a macro
13879: vlookup - table array in cell
13880: 'Moving cells'
13881: Scroll function in VBA
13882: Retain focus of IE using DocumentComplete
13883: Is there a fancy way to open a workbook in a minimized window stat
13884: trouble loading a range into a comboBox
13885: Reading data from PPT and purge data to Excel and image
13886: still get runtime error 424
13887: Is Pivot table the way to go?
13888: Access Fields in Lotus Notes DB Forms
13889: Dumb newbie Q re. passing cell addresses to a UDF.
13890: run time error 424 object required - how to load control on Userfo
13891: Open "Insert Hyperlink" popup window with VBA?
13892: Prevent rows from being selected
13893: Delete Rows based on cell value
13894: Excel spread sheets do not close from vb.net
13895: Pivot tables - how to hide the total row?
13896: multidimensional array
13897: Excel Macro Help for Charts
13898: Fill down a row
13899: Excel Macro for Charts
13900: getting Runtime Error 1004
13901: Cell Content
13902: How can I see assembly code for VBA routine?
13903: Custom Cell Format Question
13904: Simple Code but slow
13905: Looping through a range
13906: Using Case and referencing a cell instead of a value
13907: Covert Columns to rows Macro
13908: Unwanted recalculation of UDF while running a Replace-statement
13909: Conditional Formatting in a For Each Worksheet Loop
13910: DAO connection problem
13911: Dynsmic Charts
13912: SQL Not In Query Problem
13913: Macro Help - ASAP - Please!
13914: How do I change Date Format ??
13915: Autoformat screws up with FormatConditions?
13916: VBA to create button on sheet after copy and to change the caption
13917: is blank
13918: VBA code to find macros associated with command buttons in an s/s
13919: conditional formatting
13920: Combo box help
13921: Track Changes Data
13922: copy a dynamic column range in macro?
13923: Lookup in numerous sheets
13924: Find end of number and copy/paste 5 columns
13925: Coping Range from another Excel file
13926: Excel automation on server
13927: Macro codes automatically opens when opening a excel file
13928: assign value to cell on different sheet
13929: Help with the following code...from EntireRow to set width
13930: VBA and PDF files
13931: Range values not being copied with same number of significant digits
13932: Excel spreadsheeet
13933: Auto Mail
13934: VBA Module Function???
13935: Linking Worksheets
13936: Excel Sorting - Finding Duplicate Entries
13937: Tracking changes in sheets
13938: NG and Word
13939: Microsoft Excel Triggers Microsoft Word
13940: Complex macro issue
13941: Source Code control vba
13942: cell change
13943: Formatting UserForm Text Field as Numeric
13944: Assign cell to checkbox
13945: Spin button
13946: Worksheet event to change formatting when date expires.
13947: Getting Chart Cursor information in Excel 2003
13948: Locking Cells
13949: Getting Chart "Cursor" information in Excel 2003
13950: Formula to ask what Time/Date it is.
13951: Property in lowercase
13952: Getting Chart "Cursor" information j
13953: SUBTOTAL SUM AND AVERAGE
13954: Extreme calculations
13955: Macro not running in Protect Sheet
13956: Macro not running in Protect Sheet
13957: How to write VBA code to make backup copy in another folder
13958: Drawing a Flow Chart / Schematic / (tree diagram?)
13959: Macro doesnt work from another sheet
13960: VBScript Event Sink Not Firing
13961: Dropd Down (validation: list) on the fly with a code - a problem
13962: Macro / vb query
13963: VBA time and date?
13964: Determining number of columns of 2 different ranges
13965: Appending multiple columns into a new worksheet
13966: Slow Macro...Takes at least 1 Hour to Run
13967: exporting to a server
13968: odd vlookup solution required - can you rise to the challenge?!
13969: How to change column size in VB6 and Excel 2002
13970: ActiveWorkbook.SaveAs
13971: Using MS Query to do a Jion for pivot table data
13972: Excel List Box
13973: Combining two ideas?
13974: Converstion of Complex Word VBA macro to Excel Macro
13975: "show office assistant" greyed out; code suspect
13976: maximizing the size of a UserForm
13977: Run Macro
13978: Capture Events on programmatically generated Charts
13979: Save from exe file to csv file
13980: I just want to add a W!
13981: visual basic Loop by rows in Excel
13982: Deactivate / Reactivate the Paste Function in excel
13983: Changing cell data with macro--HELP!!!!
13984: Text format in "Concatenate" function
13985: Excel automation issue---enter date into cell based on other cell
13986: Expand the NameBox in Excel 2003
13987: Function to call macro
13988: Offset VLOOKUP data by one row - example in message
13989: replace apostrophe with values above
13990: Change background color when value changes in a column.
13991: Macro Help ... Pass values to the excel based model and copy + pas
13992: close all worksheets accept the active one
13993: Merging cell using VB for Excel
13994: disable multiple toggle buttons
13995: format
13996: format number
13997: Excel VBA Help
13998: How can I embed a parameter for a stored proc into MS Query?
13999: Updating Workbook
14000: UserForm past data