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