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. How do I close an instance of Quickbooks in VBA? (3 replies)
  2. Print workbook - disable (3 replies)
  3. creating a data base using Excel & VBA (1 replies)
  4. File (path to a folder) not found (1 replies)
  5. Solved: Two listboxes on same userform problem (2 replies)
  6. Read external data from dynamic text range, then calculate stats (5 replies)
  7. Excel 2003 VBA coding tweak (1 replies)
  8. Excel 2003 VBA coding and "pop up button" help (1 replies)
  9. VBA Chart fill area (8 replies)
  10. Insert Hyperlink from External Source to a Protected Sheet (3 replies)
  11. Automatic Macro execution (2 replies)
  12. Excel 64bit issue with Winsock UDP connection (0 replies)
  13. Using Yes No Message Box (6 replies)
  14. Solved: Problem with copy/paste "Formats" (4 replies)
  15. SUM IF in vba and result in message box (1 replies)
  16. Update code in 220 objects (10 replies)
  17. SSN Format (3 replies)
  18. Solved: Code not updating all worksheets (2 replies)
  19. Solved: Selection Rows CountA? (2 replies)
  20. Excel Problem (1 replies)
  21. [SLEEPER:] Extract rows to new worksheet and save as new workbook (5 replies)
  22. Solved: Locate values from List (7 replies)
  23. Using vba to open website (1 replies)
  24. Solved: how do i get the the name of the user who opened the file? (4 replies)
  25. Using iMacros in a loop with input from Excel (2 replies)
  26. Solved: Excel, append & retrieve numbers in a txt file with next number in increments one (27 replies)
  27. data model in excel (4 replies)
  28. Formatting a column into "text" (2 replies)
  29. Menu tree (0 replies)
  30. Solved: POP UP Message when a criteria is met (1 replies)
  31. Create 1 Public Sub for 5 textboxes (4 replies)
  32. Navigating Through a Recordset (Adding a Record Counter) (1 replies)
  33. Solved: Make sure numbers are increasing (26 replies)
  34. Searching from a list in Excel, extract Phone#'s from contact's in outlook 2003 (4 replies)
  35. Solved: Loop through controls and add data from cells (3 replies)
  36. Solved: Import a Silhouette & select X & Y coordinates then do a vlookup Based on the value (0 replies)
  37. Solved: Conditional Formatting only when value is present (5 replies)
  38. Is it possible to transfer data from ms access to excel using vba code? (5 replies)
  39. email different sheets to different people - code needs changing (4 replies)
  40. Clear contents in the last populated cell (3 replies)
  41. using Excel function TRIM rather than VBA function TRIM (1 replies)
  42. Listbox active workbooks and copy data (9 replies)
  43. Solved: Enter the next consecutive number (3 replies)
  44. comparing the 2 excel (1 replies)
  45. Solved: Need to loop thru a folder of workbooks and extract customer addresses (17 replies)
  46. option button macro (1 replies)
  47. Solved: need dynamic range (3 replies)
  48. Excel + Access Help (1 replies)
  49. [SOLVED:] Is it Vlookup or Sum Product ? (4 replies)
  50. Solved: TRIM in VBA (10 replies)
  51. Solved: Positioning UserForms (2 replies)
  52. Solved: Login Prompt (0 replies)
  53. Retrieving Data from another Worksheet (0 replies)
  54. Solved: Using Excel To Send Emails Through Lotus Notes (42 replies)
  55. "FindNext" function (7 replies)
  56. Is it possible to write vba code to create a conditional format on cells? (2 replies)
  57. VBA for combo box (4 replies)
  58. checking string in IF Loop (3 replies)
  59. Delete rows when the code gets deleted. (2 replies)
  60. Edit objects (4 replies)
  61. Solved: display msgbox once (3 replies)
  62. Excel Chart Object Name (3 replies)
  63. Adding a chart (2 replies)
  64. Consolidating multiple sheets onto one "parent" report sheet. (1 replies)
  65. cells colour (2 replies)
  66. [SOLVED:] Question on Hpyerlink (2 replies)
  67. Find problem (7 replies)
  68. Noob with a (probably) simple one (4 replies)
  69. Solved: VBA - Value Copy Multiple Criteria (4 replies)
  70. Solved: Validation data - excluded from list (3 replies)
  71. Solved: Array Formula not recognizing Imported Data as a Number (3 replies)
  72. do not display hide worksheets in data validation list (1 replies)
  73. Error handling: #REF! (1 replies)
  74. [SOLVED:] Rounding in units of 0.5 (7 replies)
  75. Solved: Trouble Storing Worksheet in a Variable (12 replies)
  76. Automatic Cut/Paste to new sheet at every month end (3 replies)
  77. Strange formula - now sure how it works (2 replies)
  78. Macro help - "Force Use Macros" plus "Auto Close" (5 replies)
  79. Solved: Printing Problem (2 replies)
  80. Selecting a range of sheets using crit in my Criteria (2 replies)
  81. Custome objects and Collections Classes. Help Please!!! (7 replies)
  82. Solved: Concatenate If in an Array (3 replies)
  83. Toolbare with option (3 replies)
  84. [SOLVED:] Further variation of Index/Match (5 replies)
  85. how to remove some range of cell only, (4 replies)
  86. Need a reference on where I can hire a local vba Excel expert to work on a project (4 replies)
  87. Solved: Copy/Paste All Cells on a Non-active worksheet (2 replies)
  88. [SOLVED:] Optionbutton deselection erases range value (2 replies)
  89. Excel VBA. Calculating worktime with different overtimes (5 replies)
  90. Solved: TextBox: Entering Date in specific format (5 replies)
  91. Solved: copy paste doesn't work (2 replies)
  92. Solved: .FormulaR1C1 = "=" & Formula_A (4 replies)
  93. Macro to do logic based on other column (3 replies)
  94. Solved: number format 0.00 €/m² (1 replies)
  95. Solved: cell.adress question (2 replies)
  96. Check box control on a worksheet (5 replies)
  97. Solved: Sales forecast (7 replies)
  98. ANNIVERSARY DATE (3 replies)
  99. Combinations (1 replies)
  100. tab colour (3 replies)
  101. Solved: Supressing '#N/A' in WorksheetFunction.VLookup (20 replies)
  102. Solved: VBA Assigning Variable / Runtime Error 1004 (4 replies)
  103. Solved: Formula results are different then Pivot Table (2 replies)
  104. sorted data (6 replies)
  105. Solved: Using Vlookup On UserForm (11 replies)
  106. [SOLVED:] Building Tables from List (4 replies)
  107. Solved: For Next Loop not completing (3 replies)
  108. user form textbox issue (2 replies)
  109. Couple days of work - now lost (3 replies)
  110. Pastespecial xlvalues (6 replies)
  111. Solved: Restrict Text Box (5 replies)
  112. Variables declared with 'New' cannot be made Nothing! (2 replies)
  113. Solved: Excel 2003 and 2007 - Cannot make selection in Listbox2 if click Button twice (4 replies)
  114. VBA Cond. Formatting, two sheets (17 replies)
  115. Solved: Vba to Okay Digital Cert and Signing data? (3 replies)
  116. [SLEEPER:] How to fill all filenames into array without for-next or do-loop... (5 replies)
  117. show numbers with commas (5 replies)
  118. Solved: remove the repeated words/numbers in a cell (2 replies)
  119. Excel VBA to add/delete windows scheduled task (4 replies)
  120. label right-click event (4 replies)
  121. Excel 2003 - Can I notify user that I'm waiting for read/right access to a workbook? (3 replies)
  122. Excel 2003 – History log file of new row inserted and any data added into it. (0 replies)
  123. Displaying Images from Folder on Network in Excel Based on Cell Value (11 replies)
  124. activating a window in the taskbar (1 replies)
  125. Solved: How to open a Specific file MsWord( example C:\MyW.doc) from MsEXcel... (17 replies)
  126. if..............in (2 replies)
  127. Solved: Excel 2003 - Need the numer value at the end of a string (3 replies)
  128. Solved: Excel 2003 - My for ea loop is not looping per inputbox number (3 replies)
  129. Code Error: object variable not set (5 replies)
  130. Filter Sheet With date (3 replies)
  131. Help writing a VBA code!!! (1 replies)
  132. Import text file into spreadsheet (3 replies)
  133. VBA E-mail Open Workbook as Attachment in LOTUS NOTES (0 replies)
  134. Significant digit issue (7 replies)
  135. Incorrect Field Types in ADODB Recordsets (5 replies)
  136. Using Excel and VBA (2 replies)
  137. Solved: User Id/Password (7 replies)
  138. Issue Selecting Unique Date: Data Validation List used to Filter Pivot Table Field (0 replies)
  139. Issue Selection Data Validation List used to Filter Pivot Table Field (0 replies)
  140. Can anyone help with an IF formula (1 replies)
  141. Looping a solving procedure? (5 replies)
  142. Solved: how to determine the trimester of a date (4 replies)
  143. Insert row on value change and copy values from above (1 replies)
  144. Calling other macros (1 replies)
  145. extract specific data from a txt file (8 replies)
  146. Solved: Which sheets are select in a workbook? (4 replies)
  147. Solved: Looping through Dynamic Array (5 replies)
  148. Runnung JavaScripts as a button. (2 replies)
  149. Autofit Merged Cells / Autosize Formatting (4 replies)
  150. userform.print problem (4 replies)
  151. Solved: is it possible to disable xl2003 file open in xl2007+ (9 replies)
  152. Using Calendar Control to fill in dates (6 replies)
  153. Solved: Vlookup on todays date (2 replies)
  154. Solved: specific lentgh for a textbox (6 replies)
  155. Solved: Code To Compare Data in two sheets and highlight differences (1 replies)
  156. Window of my workbook becomes inactive. (6 replies)
  157. Update Formulas to Reference New Cells Instead of Deleted Ones (1 replies)
  158. Solved: Stop Form Closing "X" (2 replies)
  159. Total Open Positions (6 replies)
  160. [SOLVED:] Only numbers in a texbox (9 replies)
  161. Solved: Irregular Sum (2 replies)
  162. Solved: How to call a macro in for - next (8 replies)
  163. Solved: One Question? (2 replies)
  164. Log in web querry (1 replies)
  165. run-time error 1004, microsoft office excel cannot paste the data (8 replies)
  166. Different ways to share an Excel Workbook (1 replies)
  167. Solved: Iserror + Vlookup to color cells where value is present in a list (1 replies)
  168. Error 1004 when selecting a range of cells (2 replies)
  169. Solved: Generate a random List of names from table (3 replies)
  170. Solved: Possible Index/Match formula (2 replies)
  171. Assigning a null value to an Integer (2 replies)
  172. mimimum length for a textbox (1 replies)
  173. Solved: compare two columns and delete matches (3 replies)
  174. Solved: Automatically Importing CSV Files into Excel. (10 replies)
  175. display negative values as $0.00 (2 replies)
  176. Solved: Private Sub Help (9 replies)
  177. Creating a new worksheet with appropriate "(name)" attribute (6 replies)
  178. Solved: Lookup / Sumproduct Issue (3 replies)
  179. SUMPRODUCT help needed! (2 replies)
  180. [SOLVED:] Adding a functionality to change the color of ASINS (6 replies)
  181. Solved: extract specific data into the sheet (2 replies)
  182. How to get International formats? (9 replies)
  183. Solved: insert letter into blank cells (2 replies)
  184. Solved: Excel 2007 _Can I store a HELP .txt file inside and .xlsm file? (5 replies)
  185. When I type a word, a formula will be entered in the cell in column D on the same row (3 replies)
  186. Dislay an asterisk after a number (6 replies)
  187. Open PDF file (0 replies)
  188. Solved: Copy a Sheet,delete a range Then save the org Template (1 replies)
  189. Solved: Transposing Data with Non-Standard Fields (13 replies)
  190. Excel 2003 - Clean Up Formula Error Values and other (6 replies)
  191. [SOLVED:] Automating Userform Mapping to worksheet (2 replies)
  192. Solved: How to get an age from a DOB header with a Stop date? (2 replies)
  193. Macros crash Excel (4 replies)
  194. Solved: Remove Zero Calculated Rows from Pivot Table (2 replies)
  195. Macro to Display Certain Items of a Pivot Field (0 replies)
  196. Solved: Sub arguments (simplifying code) (6 replies)
  197. Combine text using loop (5 replies)
  198. Solved: Help with replace [a-z][A-Z][0-9] (8 replies)
  199. Sleeper: Consolidate files (6 replies)
  200. VBA Project password (2 replies)
  201. Help! Prompt User for Pivot Table Sort Criteria? (0 replies)
  202. Solved: Populate combo box (2 replies)
  203. Solved: How to reference an option box in a checkbox? (5 replies)
  204. Command Button To Expand / Collaspe Subtotals (1 replies)
  205. Problem with Union function when opening multiple datasets (12 replies)
  206. Copy Rows based on cell value! (29 replies)
  207. Solved: Import sheet from closed work book? (2 replies)
  208. Solved: Holiday tracker - suggestions? (1 replies)
  209. Copy Excel workbook without formulas?? (18 replies)
  210. Export a range of data From Excel to Access Database and check for duplication (7 replies)
  211. [SOLVED:] Spell Check an ActiveX TextBox? (5 replies)
  212. Solved: How To Set Global Parameter for macros based on the userform check box clicked (5 replies)
  213. handler for external event (5 replies)
  214. [SOLVED:] Need help with a macro! (2 replies)
  215. Protected Sheet and Data Validation (1 replies)
  216. flashing code (1 replies)
  217. Change Chart Source Range Using Drop Down Box (10 replies)
  218. Solved: Extract Data for specific columns - Formula (2 replies)
  219. mail cc (1 replies)
  220. Check pivot table for value fields (0 replies)
  221. Solved: remove the repeated words/numbers in a cell (6 replies)
  222. Solved: Fill blank cells with date using a criteria (5 replies)
  223. Solved: Userform not opening with a Button (5 replies)
  224. Solved: Compare cells contents (VBA) (2 replies)
  225. Sort Pivot Table based on value of Drop Down List (0 replies)
  226. Solved: Word to Excel Copy (3 replies)
  227. Excel:VB Sum up value in specific field (5 replies)
  228. 2003 vs 2007 (4 replies)
  229. Am stuck! how do I force exit a macro? (4 replies)
  230. clearing text without removing color (1 replies)
  231. Solved: CountIF using two criteria (11 replies)
  232. Solved: Not to highlight when selected (4 replies)
  233. Solved: display 100% maximum (2 replies)
  234. Safe save file in *. xls (12 replies)
  235. [SOLVED:] how to check a given input is a String (3 replies)
  236. Solved: Delete Column and Row (2 replies)
  237. Using a loop and time delay (5 replies)
  238. list all items (1 replies)
  239. Solved: udf: countif for multiple ranges and sigle or multiple criteria (6 replies)
  240. Cleaning out pivot table and then using same pivot vache (2 replies)
  241. Solved: SUMIF or vba workaround (3 replies)
  242. Solved: Should be a simple sort, but is it? (15 replies)
  243. [SLEEPER:] Auto creating Pivot tables fails with missing data (4 replies)
  244. Automation of an system issue. (7 replies)
  245. Solved: Global Unknown Size Array (5 replies)
  246. Solved: Unprotecting Cells (3 replies)
  247. Unlocking Options Buttons, Forms and Checkeboxes (7 replies)
  248. Solved: How do I adapt this code to export Multiple Charts? (10 replies)
  249. Solved: Loop In VB Code (6 replies)
  250. Macro to paste a picture in Word (0 replies)