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