PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 [86] 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. Solved: Event Macro to trigger if a query should refresh or not
  2. Solved: Excel 2003 - Is there a way I can speed up my AutoFill Formula for 15,000 rows?
  3. Solved: msg box then deleting field when cell changed
  4. Copy Pasting from one workbook to another
  5. Graphs: Return null value.
  6. Copyingmultiple worksheets
  7. Trial some VBA CD burn code
  8. Fill combobox from different worksheet
  9. Solved: Color banding
  10. scrolling text on a form
  11. Solved: referencing a tab name in a sumproduct formula
  12. Solved: Excel 2003 - Something faster than a Loop to check the used range surrounding Border
  13. Solved: WorksheetFunction.Match can't find date
  14. Create workbook from template, enable link updating
  15. VBA Forms - Passing a Variable
  16. Solved: Select Case with multiple criteria
  17. Office clipboard as datasource
  18. Archiving weekly data
  19. HELP with VB/HTML code.
  20. Solved: Check cell string in column
  21. Not able to get HTML text including formatting
  22. copy
  23. Solved: multiple Application objects
  24. Solved: copy cell data
  25. find/place based on cell but absolute reference issue/macro mainting sequential order
  26. Solved: LOAD only visible cells to combobox in userform
  27. Stuck in OFFICE12 folder after SendMail
  28. Solved: Slow Down On Running Code
  29. VBA Help
  30. Solved: COPY/PASTE OR JOIN
  31. Numbers from strings
  32. How to create one button for locking/unlocking all sheets
  33. Solved: Using Variable Cell in IF Statement Formula
  34. Show/Hide button - Excel vba macro - List
  35. macro for workbook source change
  36. indirect address + skipping cell
  37. Solved: Word to Excel
  38. Asking for VBA help
  39. code from snow
  40. Search
  41. [SOLVED] ListBox on a worksheet from Forms Controls Toolbox
  42. formula to vba
  43. Open text file and write to excel file
  44. end(xlup) cant work
  45. Solved: Select Collumn based on Cell Value
  46. Selecting Blank Cells with in the selection
  47. getting values dynamically from cells A1 t0 A100
  48. insert figure end of formula
  49. Copying Columns from One Sheet to Another
  50. VBA for Find & Replace
  51. Changing Tooltip size and color
  52. Updating fields on external input
  53. Input restriction
  54. Solved: Number Formatting
  55. Solved: Import Module via VBA code and delete existing Module with same name
  56. Using Index Match across multiple worksheets
  57. Solved: Excel 2003 - Need to clean extra commas from string
  58. Solved: Excel 2003 - Need to determine if any text has been entered into a numbers only cell
  59. Solved: Print different sheets - Print area does not clear - Print_area already exists
  60. Solved: Drop Down List
  61. Copying Contents from one sheet to another
  62. Automatically copy cell contents
  63. insert control Toolbox failed
  64. Solved: Autofill till cell left of it is empty
  65. Classic 2003 Excel Menu add-in for 2007?
  66. Control Internet Explorer using active URL
  67. Powerball Reconciliation
  68. Solved: MsgBox Item
  69. Excel-Copy worksheet and timestamp
  70. Solved: Change Event not triggering with "Tab" key
  71. userform cancel button
  72. Solved: Response Time Formula
  73. Excel 2003 - Need to detect Cell Insert shift left or shift down or Entire Column
  74. Connecting oracle and excel sheet
  75. Solved: Design Time Vs Run Time
  76. Modifying The Code to Check if the entry exists
  77. Different pivot charts 'different windows' in the same worksheet
  78. Returning Values
  79. Solved: Copy values to Empty cells below filled cells in selection
  80. UserForm Trouble
  81. Solved: Exporting word data to Excel vba
  82. Excel VBA - How to Create Read Write Edit Del by ADO - Jet.OLEDB - Access - MDB
  83. Solved: Excel 2003 - Delete rows with no values in Columns A thru E
  84. Solved: Macro with launch button
  85. VB Inserting image to specific cell in excel
  86. Excel 2003/2007 - AutoComplete is inconsistent
  87. Create "Save As" button on UserForm
  88. match/copy/paste
  89. Solved: countdown timer
  90. How To Do Relative xPath In CustomXMLNode?
  91. Application.Run (RptObj.Name & "!Main") vs Application.ExecuteExcel4Macro "RUN(""Main
  92. Solved: How to display information in other columns with missing information
  93. Solved: combo bug in userform (it makes roller)
  94. Tab from specific cell to cell
  95. display negative number if greater then 0
  96. File on hard drive or network drive
  97. Chart/picture location problem
  98. Solved: Data Collection
  99. open Microsoft windows mail and attach
  100. Solved: Populate values multiple times date wise
  101. Solved: Renewing data upon opening workbook
  102. Solved: Find values and distribute in cells
  103. How to count nbr of QueryTables in workbook
  104. How can I read a text file and write values into an excel sheet
  105. Reduce macro code size
  106. Solved: create the button on file A, but use it for file B
  107. Optional argument in a function error
  108. select a sheet from list
  109. move worksheet to end
  110. Solved: How to input data from a text to excel using Excel VBA?
  111. Controlling settings in Publisher from Excel
  112. Solved: Use Advanced Filter In Excel 2003
  113. Looping the String in SQL Statement
  114. Macro to paste a picture in Word
  115. Solved: Loop In VB Code
  116. Solved: How do I adapt this code to export Multiple Charts?
  117. Unlocking Options Buttons, Forms and Checkeboxes
  118. Solved: Unprotecting Cells
  119. Solved: Global Unknown Size Array
  120. Automation of an system issue.
  121. VBA Code (Excel) - Please Help
  122. Solved: Should be a simple sort, but is it?
  123. Solved: SUMIF or vba workaround
  124. Cleaning out pivot table and then using same pivot vache
  125. Solved: udf: countif for multiple ranges and sigle or multiple criteria
  126. list all items
  127. Using a loop and time delay
  128. Solved: Delete Column and Row
  129. how to check a given input is a String
  130. Safe save file in *. xls
  131. Solved: display 100% maximum
  132. Solved: Not to highlight when selected
  133. Solved: CountIF using two criteria
  134. clearing text without removing color
  135. Am stuck! how do I force exit a macro?
  136. 2003 vs 2007
  137. Excel:VB Sum up value in specific field
  138. Solved: Word to Excel Copy
  139. Sort Pivot Table based on value of Drop Down List
  140. Solved: Compare cells contents (VBA)
  141. Solved: Userform not opening with a Button
  142. Solved: Fill blank cells with date using a criteria
  143. Solved: remove the repeated words/numbers in a cell
  144. Check pivot table for value fields
  145. mail cc
  146. Solved: Extract Data for specific columns - Formula
  147. Change Chart Source Range Using Drop Down Box
  148. flashing code
  149. Protected Sheet and Data Validation
  150. Solved: Need help with a macro!
  151. handler for external event
  152. Solved: How To Set Global Parameter for macros based on the userform check box clicked
  153. Solved: Spell Check an ActiveX TextBox?
  154. Export a range of data From Excel to Access Database and check for duplication
  155. Copy Excel workbook without formulas??
  156. Solved: Holiday tracker - suggestions?
  157. Solved: Import sheet from closed work book?
  158. Copy Rows based on cell value!
  159. Problem with Union function when opening multiple datasets
  160. Command Button To Expand / Collaspe Subtotals
  161. Solved: How to reference an option box in a checkbox?
  162. Solved: Populate combo box
  163. Help! Prompt User for Pivot Table Sort Criteria?
  164. VBA Project password
  165. Consolidate files
  166. Solved: Help with replace [a-z][A-Z][0-9]
  167. Combine text using loop
  168. Solved: Sub arguments (simplifying code)
  169. Macro to Display Certain Items of a Pivot Field
  170. Solved: Remove Zero Calculated Rows from Pivot Table
  171. Macros crash Excel
  172. Solved: How to get an age from a DOB header with a Stop date?
  173. Automating Userform Mapping to worksheet
  174. Excel 2003 - Clean Up Formula Error Values and other
  175. Solved: Transposing Data with Non-Standard Fields
  176. Solved: Copy a Sheet,delete a range Then save the org Template
  177. Open PDF file
  178. Dislay an asterisk after a number
  179. When I type a word, a formula will be entered in the cell in column D on the same row
  180. Solved: Excel 2007 _Can I store a HELP .txt file inside and .xlsm file?
  181. Solved: insert letter into blank cells
  182. How to get International formats?
  183. Solved: extract specific data into the sheet
  184. Adding a functionality to change the color of ASINS
  185. SUMPRODUCT help needed!
  186. Solved: Lookup / Sumproduct Issue
  187. Creating a new worksheet with appropriate "(name)" attribute
  188. Solved: Private Sub Help
  189. display negative values as $0.00
  190. Solved: Automatically Importing CSV Files into Excel.
  191. Solved: compare two columns and delete matches
  192. mimimum length for a textbox
  193. Assigning a null value to an Integer
  194. Solved: Possible Index/Match formula
  195. Solved: Generate a random List of names from table
  196. Error 1004 when selecting a range of cells
  197. Solved: Iserror + Vlookup to color cells where value is present in a list
  198. Different ways to share an Excel Workbook
  199. run-time error 1004, microsoft office excel cannot paste the data
  200. Log in web querry
  201. Solved: One Question?
  202. Solved: How to call a macro in for - next
  203. Solved: Irregular Sum
  204. Solved: only numbers in a texbox
  205. Total Open Positions
  206. Solved: Stop Form Closing "X"
  207. Update Formulas to Reference New Cells Instead of Deleted Ones
  208. Window of my workbook becomes inactive.
  209. Solved: Code To Compare Data in two sheets and highlight differences
  210. Solved: specific lentgh for a textbox
  211. Solved: Vlookup on todays date
  212. Using Calendar Control to fill in dates
  213. Solved: is it possible to disable xl2003 file open in xl2007+
  214. userform.print problem
  215. Autofit Merged Cells / Autosize Formatting
  216. Runnung JavaScripts as a button.
  217. Solved: Looping through Dynamic Array
  218. Solved: Which sheets are select in a workbook?
  219. extract specific data from a txt file
  220. Calling other macros
  221. Insert row on value change and copy values from above
  222. Solved: how to determine the trimester of a date
  223. Looping a solving procedure?
  224. Can anyone help with an IF formula
  225. Issue Selection Data Validation List used to Filter Pivot Table Field
  226. Issue Selecting Unique Date: Data Validation List used to Filter Pivot Table Field
  227. Solved: User Id/Password
  228. Using Excel and VBA
  229. Incorrect Field Types in ADODB Recordsets
  230. Significant digit issue
  231. VBA E-mail Open Workbook as Attachment in LOTUS NOTES
  232. Import text file into spreadsheet
  233. Help writing a VBA code!!!
  234. Filter Sheet With date
  235. Code Error: object variable not set
  236. Solved: Excel 2003 - My for ea loop is not looping per inputbox number
  237. Solved: Excel 2003 - Need the numer value at the end of a string
  238. if..............in
  239. Solved: How to open a Specific file MsWord( example C:\MyW.doc) from MsEXcel...
  240. activating a window in the taskbar
  241. Displaying Images from Folder on Network in Excel Based on Cell Value
  242. Excel 2003 History log file of new row inserted and any data added into it.
  243. Excel 2003 - Can I notify user that I'm waiting for read/right access to a workbook?
  244. label right-click event
  245. Excel VBA to add/delete windows scheduled task
  246. Solved: remove the repeated words/numbers in a cell
  247. show numbers with commas
  248. How to fill all filenames into array without for-next or do-loop...
  249. Solved: Vba to Okay Digital Cert and Signing data?
  250. VBA Cond. Formatting, two sheets