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 162 163 164 165 166 167

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