Log in

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. Removing rows based on "0" Value but keeping Headers... (2 replies)
  2. Solved: Easy format Question (13 replies)
  3. Solved: Vlookup you helped me with yesterday not working again!!! (7 replies)
  4. Variables not stored globally? (6 replies)
  5. Solved: Email function on spreadsheet (4 replies)
  6. Can you use the min & average function with cells and not ranges? (8 replies)
  7. switching focus from userform to spreadsheet? (3 replies)
  8. How to update Office 2003 code to compatible with Offfice 2007 (0 replies)
  9. Solved: How to populate listbox (6 replies)
  10. Solved: User can extend 'RowSource' (2 replies)
  11. Solved: Assigning formula to a range of cells usign VBA (7 replies)
  12. file (xls, doc, pdf, jpeg etc) adding to mysql database ? (0 replies)
  13. Solved: Saving output as a text file with pre-fixed space between columns (2 replies)
  14. [SLEEPER:] Inserting Rows during Worksheet_Change Event (2 replies)
  15. Run another Sub from within active Sub (6 replies)
  16. [SOLVED:] Range selection and other questions (18 replies)
  17. can't find project library (1 replies)
  18. Words in a String to Columns (3 replies)
  19. Vlookup from another Sheet in the same Workbook (11 replies)
  20. Copy without using the clipboard (4 replies)
  21. Solved: Saving output as a text file with pre-fixed space between columns (4 replies)
  22. Solved: Listbox With Checkboxes inside (24 replies)
  23. If...Then...Else - Help! (3 replies)
  24. array.copy (5 replies)
  25. Wrong number of arguments or invalid property assignment (8 replies)
  26. Basic Question? (3 replies)
  27. Rounding numbers with user defined increment (6 replies)
  28. Help with highlight macro (1 replies)
  29. Sub or Function not defined (2 replies)
  30. Open a simple email template out of excel (1 replies)
  31. Delete empty column in mutliple excel worksheets (1 replies)
  32. Need help with macro to only unhide 5 rows at a time based on cell value (4 replies)
  33. Date wise calculation (4 replies)
  34. Solved: Index match with command button (3 replies)
  35. Strange Behaviour from Excel (3 replies)
  36. Solved: Recieving a "FALSE" in If function. Need Help! (3 replies)
  37. Writing to the next empty cell (4 replies)
  38. Solved: Unique Lists (12 replies)
  39. fill list box with txt file (2 replies)
  40. Number ranges (3 replies)
  41. getting rid of all user form objects in a workbook (6 replies)
  42. Greyed Out Menu Items when Editing in Cell (4 replies)
  43. copying sheets without references to the original workbook (3 replies)
  44. Solved: How To Delete Column O/empty columns from all sheets in a work book? (5 replies)
  45. [SOLVED:] Function to add/write cells (6 replies)
  46. Exporting Drawing Objects from Excel (1 replies)
  47. Selecting from a column and more... (2 replies)
  48. Solved: nightmare fractions in formulas (3 replies)
  49. Solved: Printing multiple worksheets to a single pdf file (23 replies)
  50. Moving controls (6 replies)
  51. [SLEEPER:] Export data from Excel to SQL (8 replies)
  52. Show the time and date of when the code is being executed (4 replies)
  53. Solved: Difference between 2 count last row/column command (3 replies)
  54. Solved: Timer for code execution (2 replies)
  55. Solved: Alert before delete a record (4 replies)
  56. Need to use VBA to send email using Lotus Notes From Inside Excel (2 replies)
  57. Change Row into a Column (3 replies)
  58. Solved: Remove Hyperlinks (7 replies)
  59. Solved: Userform events for dynamic controls (5 replies)
  60. Getting username for last update on closed xl wb (1 replies)
  61. [SOLVED:] Copy open event to active workbook (7 replies)
  62. Solved: Look up Values in Access (7 replies)
  63. Import data from Access to Excel (6 replies)
  64. Solved: VBA To insert File Path Footer at bottom of each sheet (4 replies)
  65. Solved: Dumping data from AD If statement issue (14 replies)
  66. Show Menu Bar (24 replies)
  67. Solved: VBA to set print area on several worksheets to 1 wide and N tall + Landscape (6 replies)
  68. Automatic Updating of Functions in Excel (2 replies)
  69. Solved: How Do I clear leading spaces from a column? (5 replies)
  70. Email from excel (10 replies)
  71. Solved: Is it possible to set a bit in a long integer ? (5 replies)
  72. Solved: Copy results to sheet2 (2 replies)
  73. Hide Rows if the Value is ZERO (1 replies)
  74. [SLEEPER:] Can Excel Transparence UserForm Show Only Control in Form (2 replies)
  75. Insert Row when cell Value differs from above (4 replies)
  76. Explanation of Cell Comments? (1 replies)
  77. Solved: Creating a log file help required (0 replies)
  78. From KBase (17 replies)
  79. Solved: copy cells from many .xls files to master file (6 replies)
  80. Solved: Stubborn Styles (How To Remove Them?) (11 replies)
  81. Using Arrays to Populate Listbox (5 replies)
  82. Solved: Using an array as a parameter in an ADO query (6 replies)
  83. Seemingly impossible replacement task. (2 replies)
  84. Solved: How To Re-edit The Sheet Names In VBE Project Window? (2 replies)
  85. Solved: Redim Preserve (1 replies)
  86. Solved: Printing Zeros. 1.000 Zeros disappear, why? (2 replies)
  87. Solved: Last Date of Last Month (5 replies)
  88. Solved: Print macro (3 replies)
  89. how to write code for doing format cells/ patterns/ no vcolors? (1 replies)
  90. Solved: countif question (7 replies)
  91. Import with troubles - Date format (3 replies)
  92. Add " at the beginning and end of a string (7 replies)
  93. Solved: Hidding Data Hides Chart, Why? (4 replies)
  94. Creating a List in Memory (1 replies)
  95. Combine rows from multiple different worksheets / workbooks into a Master workbook (2 replies)
  96. I'm new to this and trying to fix an error (3 replies)
  97. Solved: how to find charecters in texts? (2 replies)
  98. Importing CSV Files Without Preserving External Links (4 replies)
  99. [SOLVED:] LastRow on every page (13 replies)
  100. Save as the active sheet into a new workbook (5 replies)
  101. Delete Rows Based on Partial Cell Value (5 replies)
  102. Solved: ?Cells? and ?Range? Properties (4 replies)
  103. How to make a range dynamic? (4 replies)
  104. Solved: Question on Option Buttons on Forms vs Control (2 replies)
  105. Convert Formula R1C1 to Range (20 replies)
  106. Solved: Array as a Public Const (5 replies)
  107. Uninstall ADD-INS (2 replies)
  108. Additional Control in Vista (6 replies)
  109. Generate Exe from Workbook (3 replies)
  110. Create/Clean-up of Objects (6 replies)
  111. Auto deletion of data when deleted from master file (9 replies)
  112. Solved: Looping required (8 replies)
  113. Solved: Choose sheet code (13 replies)
  114. Solved: Add text in title bar (4 replies)
  115. Solved: Combobox column width (2 replies)
  116. Ignore blank in Data Validation (3 replies)
  117. Solved: extracting info from cells (13 replies)
  118. Solved: Populate Specific Column Cell based on ListBox Selection (6 replies)
  119. [SLEEPER:] Multiple Worksheet Entry (1 replies)
  120. save file as CSV (2 replies)
  121. Solved: VBA tutorial greenhorn (7 replies)
  122. Solved: File Exists Issue (2 replies)
  123. how to connect one excel file to another? (6 replies)
  124. Solved: Find Method not working properly (5 replies)
  125. Solved: Insert code to worksheet programmatically and run it in the same Sub - compiler error (12 replies)
  126. Sheet and cell validation (2 replies)
  127. workbooks.open question (5 replies)
  128. Solved: Need help with this macro (10 replies)
  129. Sort (3 replies)
  130. Solved: User Defined Function (5 replies)
  131. Selection not displaying in dropdown box (2 replies)
  132. [SOLVED:] How to Clear the ?Last Cell? (7 replies)
  133. Solved: How to Determine Which Fonts Are Being Used (Loaded) (5 replies)
  134. Error - manipulate dates in VBA (3 replies)
  135. Solved: graying out check boxes (10 replies)
  136. Mask the Salary (12 replies)
  137. Solved: Copying and Pasting from each Spreadsheet in a Folder (4 replies)
  138. Solved: Data Validation / Array (2 replies)
  139. Formula help (2 replies)
  140. [SOLVED:] ADODB.Connection Copy RecordSet to Array (8 replies)
  141. [SOLVED:] Force user to fill cell (11 replies)
  142. Items in Dropdown box of Internet Form (0 replies)
  143. Solved: how to diferentiate between text and value? (4 replies)
  144. concatenating strings & data from ranges without typing a formula (4 replies)
  145. Solved: Make cells inactive (9 replies)
  146. Solved: function to retrieve characters between to given values (7 replies)
  147. [SOLVED:] Delete empty rows (3 replies)
  148. Solved: Find empty cell (4 replies)
  149. Solved: Copy PDF into Excel and Keep PDF Structure (2 replies)
  150. file search/auto import in excel 2000 (1 replies)
  151. Excel 2007 - Application.ScreenUpdating won't change? (5 replies)
  152. Solved: application.speech.speak (5 replies)
  153. Solved: Any way to prevent repeating the same executing code for 4 worksheets? (8 replies)
  154. Access to Excel transferspreadsheet and automatic sort data (3 replies)
  155. Solved: Can you set Security through VBA? (11 replies)
  156. Solved: Import Word Table & text into Excel (1 replies)
  157. Solved: add leading zero(s) (16 replies)
  158. Open Up a Store Email Template out of Excel (0 replies)
  159. Solved: Auto_Open Query (3 replies)
  160. VBA pass by reference or value (1 replies)
  161. Solved: VBA beginner: Code in the Workbook_Open() does not get called (10 replies)
  162. Solved: Select Range with variables (15 replies)
  163. Listbox column Headings (1 replies)
  164. Solved: If....Flash cell-Module (12 replies)
  165. Stock data downloading code (3 replies)
  166. Listbox control help (1 replies)
  167. Data manipulation with files (0 replies)
  168. user form (5 replies)
  169. Solved: Trying to delete rows based on 3 variables (1 replies)
  170. Solved: Can excel disable close button at right corner (12 replies)
  171. Solved: Select printer & sheet code modification (9 replies)
  172. date (1 replies)
  173. How to add a column to a collection (4 replies)
  174. examning if a cell is emty (2 replies)
  175. to automate cells with a hyperlink (6 replies)
  176. Convert a range to Proper Case (4 replies)
  177. [SOLVED:] Tricks with Zips (2 replies)
  178. Setting Default Property in a Class Module (9 replies)
  179. Solved: Hide hyperlink address (3 replies)
  180. Solved: Text Format (11 replies)
  181. get cell address without the $'s (11 replies)
  182. How do you search a cell for key words? (2 replies)
  183. Hide Rows based on 3 column variables (6 replies)
  184. Change Directory on Workbook Open? (1 replies)
  185. [SLEEPER:] Combining 2 files in one (1 replies)
  186. Compare 2 Columns & Return In Third (1 replies)
  187. [SOLVED:] How to paste a value (43 replies)
  188. Solved: Command Bar Position (4 replies)
  189. Solved: How does this line Select D5 (38 replies)
  190. Search table, copy rown and paste into new sheet (8 replies)
  191. Insert row code help (14 replies)
  192. Solved: User form to appear when certain cell are clicked (6 replies)
  193. Solved: Display records against Single Date (1 replies)
  194. Solved: Pivot Chart Positioning (9 replies)
  195. Solved: File Address (2 replies)
  196. ENABLE FILE SAVE & REMAIN IN THE SAME WORKSHEET (6 replies)
  197. Solved: Creating success variable from FollowHyperlink (8 replies)
  198. Solved: Dynamic Autofill? (9 replies)
  199. Solved: Save As and replace existing file (3 replies)
  200. Solved: Multi Column Listbox (2 replies)
  201. Looping through worksheets question (4 replies)
  202. [SLEEPER:] Find string in sheet and pass location to variable? (22 replies)
  203. Solved: Accessing Target Spreadsheets existing VBA Code (6 replies)
  204. Solved: update from master data (8 replies)
  205. Solved: Creating Drop Down Lists that Filter (6 replies)
  206. What's the difference between VBA.method vs Strings.method (3 replies)
  207. Solved: Add textbox values to database using loop (17 replies)
  208. SumIf using background color as criteria (2 replies)
  209. Solved: Weird Error Message (6 replies)
  210. Add toolbar on workbook open (5 replies)
  211. Add hyperlink to unknown sheet (1 replies)
  212. Elseif ? (14 replies)
  213. Solved: Add item to File Menu Bar in certain position (1 replies)
  214. Check Lotus Notes if Open (8 replies)
  215. Disable Cut in a Specific Range (11 replies)
  216. Solved: Convert to proper (20 replies)
  217. Email using VBA and AOL (2 replies)
  218. Solved: Detect if a form is opened (2 replies)
  219. Solved: Data From Previous Months file (13 replies)
  220. Solved: Paste Special between Worksheets (2 replies)
  221. VBA to open spreadsheet (name dynamic through var call), extract and process data (1 replies)
  222. Solved: Entering Cell Comments On A Protected Worksheet (2 replies)
  223. Password Help PLEEEASE ! (6 replies)
  224. Solved: Hash Problems (2 replies)
  225. Solved: Trim Function... (13 replies)
  226. reference myinput in vlookup formula (2 replies)
  227. Solved: Transform the position of data on a table (16 replies)
  228. Solved: Hide WorkBook then Userform Show (4 replies)
  229. Adding Description to UDF (3 replies)
  230. Discussion on Objects (7 replies)
  231. Solved: Two validation in one cell (7 replies)
  232. collection keys (6 replies)
  233. Solved: UCase Procedure is converting formulas (1 replies)
  234. How to copy Name (7 replies)
  235. Object disconnected from its client error (4 replies)
  236. Solved: Add a named workbook (3 replies)
  237. Solved: return missing value (3 replies)
  238. Solved: vlookup filename (2 replies)
  239. If statement..run macro (5 replies)
  240. Solved: Insert rows while preserving data (4 replies)
  241. Solved: Parameter passing with Command Button (3 replies)
  242. Replace function not working in script form. (4 replies)
  243. Solved: not able to show all data autofilter problem (8 replies)
  244. Link Update (1 replies)
  245. Variable scope problem (5 replies)
  246. Good online tutorials/Where do you learn vba from? (15 replies)
  247. Solved: Left zero to appear as blank (3 replies)
  248. UserForm(Excel/Project/MSForms) - Color/Font List Box (11 replies)
  249. Copy Filtered list / hidden data (1 replies)
  250. Solved: Auto Close WorkBook when Idle (2 replies)