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