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 168 169 170 171 172 173 174

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