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

  1. If statement within formula
  2. Any teachers?
  3. Stranger problem
  4. Solved: Sorting A1 through A10...
  5. Do Loop until end of a full column
  6. Prohibit making a copy of a workbook
  7. SaveAs question
  8. IfThenElseIfElse statement within For..Next loop
  9. Convert Excel Worksheets into Database
  10. My Blog - Student Hacker
  11. Is there any way to make this faster
  12. VLOOKUP/database
  13. Pasting to the next row in a list
  14. Unusual request for Userform
  15. Solved: User Form Problems
  16. Solved: Listbox Populated by Veryhidden Worksheets
  17. Solved: To Redim a two-dimensional dynamic array
  18. Excel function to get last value of collection of numbers?
  19. Calculus in Excel
  20. function returns 0 for some reason
  21. Solved: Code Help
  22. Solved: Using Resize to copy and paste?
  23. Solved: example of using listobject
  24. Solved: Range select error
  25. Solved: how do I have code run conditionally?
  26. Problem in this code
  27. How to remove a member from a collection.
  28. Solved: Turn bold first of set in a list
  29. Filter column data from csv file
  30. I need an on-the-fly vba compression routine/addin to read/write text files
  31. Validation source list from another workbook
  32. Count blank cells against criteria
  33. Message box display if data not matching
  34. Solved: Auto Copy & Paste when a certain condition is met.
  35. Activesheet Name to Change col_index_number of a vlookup
  36. Sum a shifting range
  37. ---Need Help with Sheetchange---
  38. Solved: If/Then that only grabs first 5 text entries
  39. cut, paste, return loop
  40. Retrieve Date from NTP server with VBA
  41. Solved: Well I Thought I Was Done???
  42. MS BROWSER TO EXCEL
  43. MS BROWSER TO EXCEL
  44. Solved: Prevent viewing/running of Macro
  45. Solved: Copy Data Without Cell Borders
  46. Solved: Compile Error - Project or Library Not Found
  47. Solved: Filter code help
  48. Formula Possible
  49. For Each Problem
  50. Dynamic Excel Chart VBA
  51. Name a range
  52. Solved: Listview bug
  53. Solved: sound with msgbox
  54. Solved: Need to extract to new workbook
  55. Solved: Number unique numbers in list (cells as checkboxes)
  56. Solved: Help:Function not calculate...
  57. syncronizing 2 sheets problem
  58. updating values by vba
  59. Solved: Compile error
  60. Import all files into Excel
  61. Solved: .xls File Size Diet
  62. Solved: VLOOKUP with capital text!!
  63. Form Error Type Not understood
  64. Combo Box Pick assigned to next empty row
  65. Populating Listbox with Combo Box Picks
  66. Unusual Request for Userform (Continued)
  67. copy dynamic range from one sheet to another
  68. undo
  69. Open protected Access database file in Excel
  70. VBA, Excel, Access file attachments
  71. RoundDown value in Application.WorksheetFunction
  72. Solved: Data Change
  73. Copying Data
  74. ToggleButton OnAction Problem
  75. Solved: Offset Count off another Sheets todays date
  76. Sumproduct Function Help
  77. Histogram
  78. Solved: How to retrieve a closed application
  79. IE Control using VBA
  80. Anyone Bored? VBA Project. Tucson?
  81. Merging 5 files into 1
  82. Scroll List help
  83. Solved: Default workbook view
  84. Implementing Forum code at work?
  85. Solved: Macro to creat a values only version of Activeworkbook
  86. Solved: Special Color Palette's in VBE
  87. Solved: Data double validation
  88. Open xls file based on text in a specific cell
  89. Looping a format style macro
  90. Structure Help??
  91. Need help with pivot table data range
  92. Removing duplicates
  93. Autofilter VBA
  94. Hidding Rows with "0" Values
  95. Scrolls List Help - XLD you just helped me here
  96. Solved: Option Buttons
  97. Creating Microsoft Project in Excel
  98. More option button help
  99. Solved: is that possible to copy from any text of listview to textbox
  100. IF Function or VBA to validate NOT Null
  101. How to send text that contain subscript and superscript from a macro to a cell?
  102. Solved: Placement of code causes error
  103. Print macro
  104. Solved: Single cells updating and slowing calculation
  105. Unable to read file
  106. Solved: VBA Code to Delete Records on Condition
  107. Solved: Userform
  108. Simple Array Help.
  109. Solved: Referencing open workbooks
  110. Breaking processing for User Input
  111. Run a command stored in a variable
  112. Solved: Worksheets are Not Remaiming xlVeryHidden
  113. Solved: Create a log in list from the mainscreen
  114. Solved: Deleting Text
  115. Solved: I want to show the time it took for macro to run
  116. Solved: Joining Code of several Add Buttons on a UserForm
  117. Weird Bug
  118. Still Trying to figure this one out "over my head"
  119. Solved: Multiple lines in msgbox
  120. Solved: Search- 2 Sets of Dates Between 2 Other Sets Of Dates
  121. Whats wrong with this code?
  122. how do I loop through every comment on all of my sheets?
  123. Solved: Recalling A Workbook
  124. Solved: Find current folder
  125. CSV SaveAs, how to override are you sure questions
  126. Solved: ADO Delete Access Record from Excel Userform
  127. does cellvalue have . and :?
  128. Solved: Pickup numeric data only.
  129. Solved: Advanced Filter Error
  130. Solved: Creating toolbar specific to workbook
  131. Solved: Specify data range and copy to other sheet
  132. Solved: Making macros available for every excell worksheet
  133. macro help
  134. Need help to create template
  135. Solved: Data Change 2
  136. Count of Columns in string
  137. filling up excel row
  138. Copy from Excel to Word error - table alignment
  139. Solved: Edit Access Table Info
  140. Sumproduct vs Ctrl+Shift+Enter arrays
  141. small help required.
  142. Code now gives an error
  143. Solved: Copy one cell to another using VBA
  144. Calculated Pivot Field
  145. Dyanamic Charting in Office 2007
  146. Solved: How to Disable ComboArrow while maintaining readability?
  147. Solved: How to make like the button
  148. Solved: Auto data entry
  149. Solved: "Save As" Date as part of file name
  150. screenupdating error
  151. Solved: Time format problem
  152. nested if iserror formula error - please help!
  153. Solved: Search For and then Go To Searched Reference in Workbook
  154. Highlight duplicate value in a column
  155. Solved: go through column and highlight cells
  156. Simplify Code and return results to UF - ADO Access/Excel
  157. Write ADO SQL results to Userform Spreadsheet1 control
  158. Treeview shifts position on multipage form
  159. Edit linked Excel file from Visio.
  160. "remove formula from cell"
  161. How to read data from a worksheet into an array in a module?
  162. Please help on macro coding
  163. Deleting certain rows on conditions
  164. Click on Cell and open worksheet
  165. After RightClick, stop menu appearing
  166. How to prevent Hyperlink virus warning dialog
  167. Access Function from Excel
  168. Solved: Enter a changing formula a massive worksheet
  169. Solved: Simple VBA change
  170. Formatting a paragraph from some excell cells into another program
  171. Solved: Can Someone Explain Why This is Happening
  172. QueryTables.add with SQL query
  173. New chart series without legend entry
  174. Solved: grouping based on cell value
  175. Problem with For Loop
  176. Solved: Problem with For Loop
  177. Excel 2007 - Max. path length for named ranges
  178. Extract Time Values from Other Sheets
  179. Factorial help
  180. Change Format color cell text under VBA
  181. Solved: Changing formula on massive worksheet needs to change again slightly
  182. Unexpected file lock
  183. Simple problem with form sizing
  184. Hide Zero Values
  185. Sheet PrintOut Halt
  186. Solved: Problem, need more than 7 if statements
  187. Solved: In over my head...again
  188. Coding a VBA SQL Formatter
  189. Remove all Page Breaks
  190. Combining cell (nCr- Probability)
  191. How to display Variable in xl custom header
  192. Summing data
  193. Solved: Several problems with charts
  194. Clear cell without deleting formula?
  195. Solved: Combobox
  196. Help with filtering
  197. event / error trapping?
  198. Solved: WordArt Object Blocking Cell Selection
  199. Solved: Automate data import
  200. Solved: % using the color of a cell
  201. Help with search macro
  202. part of code to slow?!
  203. Solved: Moving Page Breaks
  204. Macro to Saving Data Before Deleting
  205. Importing a text file into an excel template
  206. Filter and hide macro help
  207. Load database values into Worksheet
  208. JULIAN dates
  209. looking for some help on to work out earliest event time
  210. Weaving Two "If Not Intersecting" in One Worksheet Change
  211. Progress
  212. BeforeClose event
  213. Converting Columns to Rows (365 to 8760)
  214. Autofilter problem
  215. Can User Select a cell on Different Worksheet?
  216. Database search and return of results
  217. Solved: Sorting and Charting multiple Ranges
  218. Solved: Variable Filename / No Drive Letter Chosen
  219. Manipulating Chart Title
  220. Userform Unload Data onto Two Worksheets
  221. Delete Rows
  222. Solved: Resolved: Delete row after 3 months
  223. Solved: Code Help
  224. Make columns in pivot tables consistent
  225. Don't delete sheet if don't wirte a password in inputbox
  226. Searching text entries
  227. Solved: Userform Updating Query
  228. Simple Question about notes
  229. 2d array looping through x,1
  230. Solved: Listbox Not Loading But should
  231. Solved: For loop using columns as counter?
  232. Solved: Rename a text file from within Excel
  233. [SOLVED] Solved: Macro extract external links from Edit>Links and update
  234. Solved: copy rows from worksheet to worksheet
  235. Solved: Copy cells in select columns that match other cells in select columns
  236. Force Open File
  237. Solved: Looping pivot tables
  238. Strange IE7 quirk when macro is run
  239. Solved: Macro Not Updating Worksheets
  240. Solved: file size with macro
  241. Solved: write reserved
  242. Solved: when autofilter returns nothing
  243. Solved: rows.count in a range
  244. Solved: open file without links
  245. Solved: forms - passing valued returned to code
  246. Solved: switching columns around
  247. Solved: Question about hyperlinks
  248. Solved: Complie Error: Expected End Of Statement
  249. Solved: Multiplying cells from gathered information using VBA Excel ONLY
  250. Sort-Excel-Custom Cell