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 161

  1. Parse .txt file
  2. Concatenate From within formula
  3. Dynamic Scatterplot
  4. Solved: Trim formula needed in condiational formatting
  5. Solved: Sort specific workbook
  6. Modify a macros
  7. Solved: Error in Workbook Code
  8. Store ordered list in string.
  9. form fields in excel
  10. required fields based on IF statement
  11. Solved: how to swap firstname lastname in cell?
  12. Hyperlinks as result in Random Sample
  13. Excel VBA website content copy
  14. printarea with rectangles
  15. Changing the time zone
  16. Solved: User Defined Function not giving fresh results
  17. Stop skipping rows!!
  18. Solved: reduce size of macro
  19. Processing Time
  20. VBA Macro Code to Enter Intranet's Login/Pass?
  21. Drill Down
  22. Solved: edit macro cancel step
  23. Decimal value of characters in cell
  24. HELP macro to Delete Row based on two cells
  25. auto print
  26. Solved: Find, Copy Text from Word and paste in excel
  27. Solved: HELP Worksheet.CodeName is not consistent when copying a worksheet into a workbook
  28. Solved: simplifying formulae
  29. Solved: Showing IP Address
  30. Solved: VBA Speech References Library
  31. Solved: Inputbox method to pick a range in another workbook
  32. Find Names and copy to a new sheet
  33. Internet Explorer controls error
  34. Suppressing display of CUM line chart for future periods
  35. Error Importing XLS sheet into Access via VBA
  36. Copy Files in a folder into a single Master file.
  37. Solved: Exporting data to another Workbook
  38. Maddening, non-repeatable bug
  39. Solved: Sort adds an extra line
  40. Solved: An N-by-1 variant array throws runtime error when N gets down to 1
  41. Solved: Compare date before event execution?
  42. Solved: Close all but Activesheet
  43. Solved: Month and Day swap places when OK cmd button is pressed
  44. Solved: Variable Data with Date
  45. Self defined date format [$-130000]
  46. Solved: IF AND PROBLEM
  47. Solved: Open file path
  48. Copy Worksheet
  49. ctrl c and ctrl v breaks a merge cell
  50. ReDim Question
  51. Solved: Re-start the value if reached a value
  52. Solved: Iterate through columns
  53. Solved: Urgent: Application File Search
  54. populating a cell with value from another
  55. elimanate zero while taking minimum value
  56. Solved: Referencing using a number for column
  57. If 3 times greater than delete row
  58. Solved: Whats the value of y given X
  59. Solved: passing data from a list box to a spreadsheet
  60. Spreadsheet vlookup help.
  61. Solved: Calculating Height of a range
  62. Solved: Filling empty cells across workbooks with zero
  63. select multiple areas in a textbox
  64. count shapes
  65. Importing tables from multiple HTML files, into one spreadsheet. Please Help
  66. Using a worksheet as a database
  67. Copy cell from multiple sheets, into one row in one sheet
  68. Solved: VLOOKUP on multiple criteria
  69. A 'floating' rounded rectangle
  70. CombineFiles - Move instead of Copy
  71. Can I edit a source cell from the linked cell?
  72. Delete Rows Based on Current Date
  73. Solved: Is Insert > Name > Create evil?
  74. TextBox to Cell Freeze
  75. Solved: How to write VBA code to copy data from Word to Excel?
  76. Solved: How do I delete code from a sheet module under program control?
  77. VBA Code to pull selected data from a huge database
  78. Solved: Calculation not working
  79. Solved: Select Checkboxes in Internet Explorer
  80. Solved: running macro runs the wrong macro
  81. Solved: HELP with TRIM !!
  82. CSV Files & Userform Problem
  83. Solved: Unable to connect to Oracle
  84. Solved: Share a workbook without a prompt
  85. Solved: Workbooks(NewFN).Close SaveChanges:=False Index Issue
  86. Solved: Filling comboboxes with filtered data
  87. implied do loop in excel write # statement
  88. Solved: How to Concatenate Text
  89. Solved: Set cell value from one workshee equal to found cell in another workbook
  90. Solved: OnExit
  91. Solved: Delete a specific record from an Excel VBA array?
  92. Function for of sum of square of mean deviation
  93. Help With MsgBox if duplicate range
  94. Solved: Writing data to a table in word from excel vba
  95. Listboxes - automatically unselecting themselves?!
  96. automatically scale pivot chart from highest to smallest
  97. How do I "install" custom functions
  98. chart update problem help!!
  99. OWC Spreadsheet Scrolling
  100. Solved: Workbook_Before Close problem
  101. Solved: add differenet worksheet names to current macro
  102. Solved: Copy Paste from workbook to workbook
  103. Solved: Do Loop until rowHeight is between two numbers
  104. Solved: Using arrow keys to navigate through userform fields
  105. Read and Write Binary Registry Keys
  106. Solved: need to add a macro on save
  107. [SOLVED] Sort Multidimensional Array
  108. amend formula
  109. compile error
  110. disable print screen
  111. Solved: sort will not sort - why?
  112. Solved: Save and encrypt sheets
  113. Solved: duplicate file & strip code from workbook
  114. Solved: Find Multiple Entries Then Delete Row
  115. Set default save path
  116. Unmerge cells & copy line from above
  117. Solved: Looping through a shapes listbox
  118. Solved: Need help easy formula
  119. sum to the last column with data
  120. Lock cell after entry
  121. Solved: Enter today's date based on another cell
  122. Solved: Help with Case statement
  123. Solved: Can text be copied out of a cell to another cell?
  124. Solved: Merge Data between worksheet
  125. Solved: OnClick event
  126. Solved: Clean up of Custom Menu items
  127. Copy 2 sheets to Network and rename
  128. Solved: Ignore error without converting to number
  129. Solved: Multipage and combo box
  130. Solved: vba copy function
  131. Solved: Scheduling suggestions
  132. Worksheet Formulas and VBA
  133. Solved: Moving rows up and down a table with VBA
  134. how to run a sumif after formula
  135. CheckIn, CheckOut API's - general question
  136. Copy non blank rows from each workbook in a folder to current workbook under eachotha
  137. Solved: dynamic named ranges
  138. Solved:
  139. Solved: Confused about Workbooks object
  140. Ask for values and delete row
  141. Solved: Ask for values and save as
  142. do copy macro
  143. Solved: Check if 2 Values Exist in 2 Columns
  144. Robin Hammond's Progress Bar?
  145. Userforms and Other Excel Application
  146. Need help on loop
  147. check my code pls
  148. vb help
  149. For/IF problem
  150. Solved: search for multiple characters in a cell
  151. Disable Copy Paste
  152. Setting checkboxes with Boolean effect
  153. Search as You Type ~~ Narrow down List
  154. Solved: Copy Paste Cell Value To Word as Text Only
  155. How to combine 6 different file(but same format) become one
  156. Solved: Excel to Word: A few issues on the Excel part of things
  157. Import data file
  158. Solved: formula not changing the row values accorrdingly
  159. Populating sheets with data from another sheet
  160. Solved: Compare two workbooks and count matches
  161. run time erro 424
  162. Solved: runtime error '1004' unable to set the formula property of the series class.
  163. Solved: Separate every 3 entries into 2 arrays? (or other solution)
  164. Auto shut down of spreadsheet if inactive.
  165. How to protect Excel Program more seriously?
  166. macro deleting important data in column F:EC
  167. Using Find to Search for a Date
  168. Voltage Ramp
  169. Solved: Store values meeting certain criteria and paste them into other area
  170. Implied Volatility
  171. Implements Keyword in VBA
  172. Solved: Capturing Error Message
  173. Color Backgrounds for Independant Cells
  174. Solved: Adapt code by Tom Ogilvy
  175. Solved: how to detect when the mouse leaves a control on a userform
  176. Matching variable formats
  177. Solved: Which column is the calling button (mostly) in?
  178. Solved: Controlling Dialog Boxes
  179. Solved: VBA- Smallest non-negative number in a range
  180. macros language help ?
  181. Referencing User Selected Workbooks
  182. Solved: Select Date Range
  183. Solved: Worksheet_Change and .PasteSpecial
  184. Identifying the optimal solution in an array
  185. Time Stamp VBA - Need help please!
  186. Solved: Drop-down for each cell under a column
  187. Solved: how to sum rows in columns with Sun
  188. Solved: VBA , min of 2 nox , >0
  189. Replacement of IF function
  190. Solved: Colouring ranges based on data being entered by User
  191. Cant Shift date problem!
  192. Solved: How to format columns on 'Workbook Open'
  193. Solved: Excel insert rows based on value of previous row
  194. Solved: Selecting range of cells
  195. Issue with ActiveWorkbook.FollowHyperlink
  196. assign macro to tollbar buttons(excel2003)
  197. Solved: Finding last row of a column
  198. Solved: Run Userform via macro toolbar button
  199. Crash after add-in install
  200. Speed up calculation
  201. Solved: paste to last empty row and beyond
  202. Set Focus On Excel Instead Of Powerpoint
  203. Insert tabs in to an excel worksheet
  204. Autofill Rows with formula
  205. Solved: Filter unique values and count their frequency
  206. Solved: UDF Inserting Unwanted Quotation Marks
  207. VBA Check Cells - Easy but help!
  208. Solved: connect with access
  209. Solved: Show the next months Lists
  210. Solved: send active worksheet to outlook mail recipient as an attachment
  211. Solved: Really basic stuff
  212. Font Color Cell
  213. Solved: Application-defined or object-defined error - Len(c.Offset(0,-1).value)
  214. Solved: Error when I attempt to filter worksheet
  215. Solved: How to copy a dynamic range
  216. Solved: Delete Sheets in Add-in
  217. How To Count The Number Of Records Selected By AutoFilter
  218. Solved: Deleting Rows
  219. Help with autocomplete in textBoxes
  220. Solved: min of 2 nos, if positive
  221. Solved: MS Query on open workbook
  222. how run a sumif column name is true
  223. Solved: Delete the Row based on criteria
  224. Solved: How to Link two sets of ranges
  225. Solved: Autofill a column with text
  226. Excel search files
  227. Solved: How to merge Empty cells in a selection
  228. Solved: password lock a worksheet using a userform
  229. Email from excel
  230. Solved: Find Multiple Entries - Change Cell Value
  231. creating a folder then giving a user ID modify permissions to it
  232. Size chart to Word cell
  233. Solved: Namespace
  234. Solved: How to do arithmetic on addresses
  235. Solved: VBA Code . Max of 4 nos and min of 4 nos
  236. Solved: how to avoid LITTLE GREEN TRIANGLE error
  237. Function with circular reference - VBA
  238. Solved: Adding A "ScreenTip" or Pop-Up Message When A User Hovers Their Mouse Over An Image??
  239. payroll weekly time excel formula
  240. Solved: Calculating average based on some criterion
  241. Solved: Source and location function
  242. Solved: Add New sheet every day
  243. Record varying length of text in cells
  244. Solved: Undo a Hyperlink
  245. Cumulative % in Pivot
  246. Solved: Any way to retrieve deleted file
  247. Solved: Data Management In Excel - Theory/Design
  248. Solved: Hundreds of links on Multiple Sheets
  249. Solved: Auto Load Form when Excel Launches
  250. Autofilter/Delete Duplicates/Find Changes