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

  1. VBA Date Range Argument (4 replies)
  2. Take the size of the Array (3 replies)
  3. Paste Especial/Value/Transpose . . . (8 replies)
  4. Solved: Checkbox control(s)........looping (7 replies)
  5. open multiple workbooks and enable macros, then close (6 replies)
  6. How to get this formula shorter (3 replies)
  7. Solved: Extract data from Website to Excel (5 replies)
  8. windows services in Excel VBA (2 replies)
  9. Holiday and earned time minor problem (2 replies)
  10. delete (33 replies)
  11. Solved: Restrict Saving WorkBook (2 replies)
  12. Calculating 99% in entire cell in Col M. Col M is filtered (5 replies)
  13. How to copy only the headers and columns of requested (3 replies)
  14. Strange things happening (1 replies)
  15. Text Format need help (2 replies)
  16. Solved: the number in this cell is formatted as text (6 replies)
  17. Solved: How to create a VBA program based on lookup formula (10 replies)
  18. Extract GPS data from jpeg file properties with VBA? (5 replies)
  19. A macro to authorize a user to run another macro. (3 replies)
  20. copy transpose (5 replies)
  21. How to alter Paste Range in VBA (2 replies)
  22. Solved: Date Delete (7 replies)
  23. Copy Colours (7 replies)
  24. A macro code to check whether any workbook is currently open or not. (2 replies)
  25. [SOLVED:] Make Selection on sheet1 that will duplicate on all worksheets (5 replies)
  26. Sleeper: Get Combobox2 value if a value is selected in combobox1 in the WorkSheet (1 replies)
  27. Book Recommendation (3 replies)
  28. pivot table question (2 replies)
  29. loop (1 replies)
  30. Solved: Convert time entered on row to ascending dates (6 replies)
  31. Solved: Misserable example.... (3 replies)
  32. Solved: How to assign different face id to macros in a toolbar (3 replies)
  33. display label as Year & text (1 replies)
  34. Solved: Copy Sheets to new workbook and save copy (4 replies)
  35. [SOLVED:] Please Help with Checkbox Alternative (9 replies)
  36. Solved: Populating a userform.... (11 replies)
  37. Column to headings& heading contents to rows (13 replies)
  38. Center userform using Printform (1 replies)
  39. Solved: moltyply times (2 replies)
  40. Solved: DELETE LAST (1 replies)
  41. Solved: Formula Problem (2 replies)
  42. mark duplicate row with condition (1 replies)
  43. INDIRECT VLOOKUP formula problem (4 replies)
  44. Instant messenger in EXCEL (0 replies)
  45. Solved: translate from Excel in VBA (9 replies)
  46. Solved: Calculating Hours Earned (12 replies)
  47. VBA Macro for Log File (5 replies)
  48. Solved: Move columns (8 replies)
  49. Solved: QueryTable wont work in Excel 2007 (3 replies)
  50. Display percent value (5 replies)
  51. Solved: Help With a Formula (14 replies)
  52. Adding values (5 replies)
  53. Solved: Problems with running pre-Excel 2007 macros (1 replies)
  54. Autofilter, copy-paste to new sheet (3 replies)
  55. Solved: VLOOKUP in multiple arrays (17 replies)
  56. Solved: Listing file/folder attributes from user input (2 replies)
  57. Create userForm by code (8 replies)
  58. Solved: Calculating Hours Earned (4 replies)
  59. Solved: How modify VBA to split multiple cell? (4 replies)
  60. Combining multiple worksheets WITHOUT the same arrangement. (1 replies)
  61. Solved: Sort Data Based on Value of a Cell (11 replies)
  62. Solved: Finding Matching Date (7 replies)
  63. Solved: FILE DATE (8 replies)
  64. Solved: Debugging a VBA programm in Visual Basic Editor (VBA Excel ) (1 replies)
  65. Solved: (location) inside of the combobox (5 replies)
  66. Solved: Inserting dynamic range into new table (2 replies)
  67. Solved: Keep selected cell centred (3 replies)
  68. Solved: Macro to sort data ascending (6 replies)
  69. Excel 2000 vs 2003; additional control; substitute (6 replies)
  70. Solved: Managing the Case of First Letter (5 replies)
  71. Sleeper: Invalid references table and copy the valids to another table (1 replies)
  72. Solved: How to calculate running totals (2 replies)
  73. Solved: Question About Circular References (2 replies)
  74. Restrict Worksheet Scrolling Help (4 replies)
  75. Solved: Nested IF function (4 replies)
  76. Solved: One variable defined as text, the other as integer Problem (4 replies)
  77. excel formula in vba (2 replies)
  78. Referring to an array in many subs (1 replies)
  79. How to create a UDF Function? (10 replies)
  80. [SOLVED:] Circular reference in a formula (4 replies)
  81. Mapping Values (1 replies)
  82. VBA - answer "yes" or "no" (3 replies)
  83. SUMIF IN VBA with external references (12 replies)
  84. Unhide Hidden Rows (9 replies)
  85. Solved: VeryHiding Sheets after given date (13 replies)
  86. Report Based on following sample of data (1 replies)
  87. Plugging time in excel sheet (4 replies)
  88. Solved: Data input macro help needed (4 replies)
  89. Solved: Finding Bad Names (13 replies)
  90. How to paste in selected rows of the selected column (19 replies)
  91. Set max value in array item? (6 replies)
  92. Solved: Code to stop all subsequent code and return to userform (6 replies)
  93. C&P format & formula if certain data entered (5 replies)
  94. Imported dates (15 replies)
  95. Solved: Counting Text with commas (5 replies)
  96. Solved: Show Desktop (2 replies)
  97. Picking respective value from different col based on a particular value input. (1 replies)
  98. Code to save to a sub folder? (1 replies)
  99. Solved: VB code to save file to app directory? (6 replies)
  100. Solved: Calculating stock price volatility over and over and over... (7 replies)
  101. Solved: Ending a loop at the bottom of column (13 replies)
  102. Adding to Named Range and Disappearing coloring (3 replies)
  103. Problems with interface design for when long macros process (suggestions welcome!) (3 replies)
  104. Solved: Arrays with Arrays (20 replies)
  105. Solved: Comparing two columns of data and outputting the differences (3 replies)
  106. Solved: Create on the fly labels with click events (7 replies)
  107. Interacting the Search Dialogue Box (9 replies)
  108. Solved: Conditional Formatting (5 replies)
  109. Solved: Adding text to a cell with CheckBoxes (8 replies)
  110. Enable Macros when opening Worksheet (2 replies)
  111. Solved: Animation Control limitations (2 replies)
  112. Solved: MkDir, multiple directories? (3 replies)
  113. Solved: Age calculation (6 replies)
  114. AfterUpdate Event (5 replies)
  115. Interesting Issue With Labeling Data Points (1 replies)
  116. Solved: UDF in Conditional Formating (0 replies)
  117. Solved: Week Number Of The Month (0 replies)
  118. How to Make Handwritten Code or Macros (5 replies)
  119. Spin Button (2 replies)
  120. Solved: Macro processes too much, so Office apps hang until finished! Ideas? (6 replies)
  121. Staff ID Number format (13 replies)
  122. Solved: Userform + Range=#value (8 replies)
  123. Solved: label.caption take text from file (3 replies)
  124. Trigger Macro by change in formula value within a cell (7 replies)
  125. camembert (4 replies)
  126. Solved: Determining size of chart area? (2 replies)
  127. Solved: Run a macro with inputbox (2 replies)
  128. Solved: insert text in columns with itineration (9 replies)
  129. Import txt files into excel (3 replies)
  130. Bring chart infront of web browser (0 replies)
  131. Sending the Email by Excel by searching the Attachment names start with 302568 (0 replies)
  132. Solved: FindNext (16 replies)
  133. unable to set the text property of the characters class (14 replies)
  134. VBA: Identify Last Column with data in a specific Range and copy to next column (3 replies)
  135. Solved: other possibilities? (4 replies)
  136. Exporting Data into Different Cells at Set Intervals (3 replies)
  137. Macro to countif multiple criteria (3 replies)
  138. Excel File Properties in Windows Explorer (2 replies)
  139. Solved: ignore files which are blank? (2 replies)
  140. Solved: text box dependent on list box in userform (2 replies)
  141. Webbrowser control (1 replies)
  142. Populating Oracle SQL Queries in different Sheets in Excel using VBA code (9 replies)
  143. How to control which vba Excel program has control on computer (5 replies)
  144. Converting formula into values. (1 replies)
  145. Excel Custom Headers and Footer (1 replies)
  146. Dynamically Specifying Series and X/Y Values of a Chart (1 replies)
  147. Merging Cells (10 replies)
  148. copy down formula (1 replies)
  149. Solved: SUMIFS (2 replies)
  150. Extending chart series range (2 replies)
  151. Write to Module Using VBA (3 replies)
  152. Help in sorting in data or macro or simple method. (1 replies)
  153. Solved: Option Explicit (6 replies)
  154. Speeding Up Vlookups (2 replies)
  155. Autofilter on row 3 (2 replies)
  156. Solved: error when looping (5 replies)
  157. VBA Column Looping (1 replies)
  158. Excel - transpose multiple records (9 replies)
  159. Solved: Make Code run only on xls files (4 replies)
  160. Solved: Displa first item in combo box (2 replies)
  161. Sumif formula (1 replies)
  162. Solved: Sort Not Working When Formatting Applied (2 replies)
  163. Loop trough workbooks and Paste values (5 replies)
  164. VBA Code to export formula to cells? (3 replies)
  165. Create a List based on Cell Values from multiple Sheets & Columns (2 replies)
  166. Macros for excel (2 replies)
  167. Solved: Applying an Advanced Filter Using VBA (6 replies)
  168. Inter related items (7 replies)
  169. Stop code from running when opening (1 replies)
  170. Solved: Adding pre-fixes (11 replies)
  171. [SOLVED:] Lookup question (3 replies)
  172. How to access menu items of Excel add-in? (3 replies)
  173. Solved: Checking if macro run again- same month (4 replies)
  174. Excel Crash (10 replies)
  175. Coloring depending on the Series (1 replies)
  176. Find the cursor position in a string (6 replies)
  177. Seeking help in creating an excel macro for shutting down pc (4 replies)
  178. Resetting Color Pallette (3 replies)
  179. Loop through charts (1 replies)
  180. Sleeper: Excel to Autocad (1 replies)
  181. ComboBox Help! (4 replies)
  182. Solved: Data Validation on User Form (8 replies)
  183. How to dyamically change which pages will print (0 replies)
  184. Hint about VBA functions (2 replies)
  185. Solved: Running two macros on opening (1 replies)
  186. Application.close information required (3 replies)
  187. Add formula to cell (2 replies)
  188. Animation in Excel (4 replies)
  189. If cell = [Word], hilight row (8 replies)
  190. Solved: Text and Value in 1 cell is it difficult? (4 replies)
  191. [SOLVED:] Creating the Game: Boggle (15 replies)
  192. Solved: Copy. (2 replies)
  193. Change Pivot Field function from xlCount to xlSum (1 replies)
  194. That Missing file!! (7 replies)
  195. How to use "For loop" until the cell.value becomes null? (1 replies)
  196. Solved: Question About Global Variables (26 replies)
  197. highlight 2 consecutive cells in same Col (2 replies)
  198. Solved: Counting to Last Cell (4 replies)
  199. Solved: Editing listbox in a row (8 replies)
  200. Running total stat graph (8 replies)
  201. Solved: ListBox for the rows (2 replies)
  202. Web pages data search and autopopulation (8 replies)
  203. Solved: Macro. (8 replies)
  204. Need Help Combining 5 Macro's into 1 Macro (2 replies)
  205. Combine Specific Worksheets into One (4 replies)
  206. Move Column to next tab (3 replies)
  207. Solved: Loop find and replaced (2 replies)
  208. Solved: how to restrict copy, paste in workbook (2 replies)
  209. How to Protect a workbook with different encryption in VBA (6 replies)
  210. Interpolation of data on Excel (2 replies)
  211. Text Box (12 replies)
  212. restrict a excel file opened open office (3 replies)
  213. Solved: Additional Controls menu doesn't appear (2 replies)
  214. Copy & paste based on value (4 replies)
  215. Solved: copy row and paste to next sheet (5 replies)
  216. Sending Mails Automatically (19 replies)
  217. Solved: insert date with vba (11 replies)
  218. Solved: Listbox Selected Items Count? (4 replies)
  219. Solved: Find String (2 replies)
  220. Solved: Auto Plot Chart routine fails (5 replies)
  221. Solved: Named Range Copy (3 replies)
  222. Hyperlink Address changing (1 replies)
  223. Need help altering macro to move columns not rows (2 replies)
  224. [SLEEPER:] Fixing Column Widths After Importing Data (28 replies)
  225. Word To Excel help (4 replies)
  226. Mouse Jiggler? Anybody got one? (3 replies)
  227. Solved: Having Trouble with For Each Loop (13 replies)
  228. Solved: Name Ranges (2 replies)
  229. Solved: converting relative addresses to absolute (4 replies)
  230. Right click - Paste Special Clear Formatting (3 replies)
  231. Solved: LastRow.Offset but for Colomn (4 replies)
  232. [SOLVED:] Deleting the space (3 replies)
  233. Disable printing and macros from specific date (4 replies)
  234. add picture to standard pictures excel (0 replies)
  235. [SLEEPER:] How can I combine the following 3 vba scripts to 1 (8 replies)
  236. Solved: Filtering Dates (28 replies)
  237. Solved: Match data with macro or lookup formulas (3 replies)
  238. Solved: For Next loop inside a If statement (4 replies)
  239. Solved: Remove ^ From Begining of Every Cell (12 replies)
  240. Solved: Finding in Reverse Order (3 replies)
  241. MkDir problem ?! (7 replies)
  242. columns spontaneously hidden when file reopened (7 replies)
  243. Creating Data for Missing Time Series (3 replies)
  244. Solved: Name (too long) (6 replies)
  245. Solved: Double a value multiple times (6 replies)
  246. Solved: FORMULA REQUIRED (5 replies)
  247. Paste a string (3 replies)
  248. Solved: Obtaining the Value from a Formula in VBA (4 replies)
  249. Solved: How to save a cell value to another sheet (5 replies)
  250. Type mismatch error (3 replies)