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

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