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. VBA - answer "yes" or "no" (3 replies)
  2. SUMIF IN VBA with external references (12 replies)
  3. Unhide Hidden Rows (9 replies)
  4. Solved: VeryHiding Sheets after given date (13 replies)
  5. Report Based on following sample of data (1 replies)
  6. Plugging time in excel sheet (4 replies)
  7. Solved: Data input macro help needed (4 replies)
  8. Solved: Finding Bad Names (13 replies)
  9. How to paste in selected rows of the selected column (19 replies)
  10. Set max value in array item? (6 replies)
  11. Solved: Code to stop all subsequent code and return to userform (6 replies)
  12. C&P format & formula if certain data entered (5 replies)
  13. Imported dates (15 replies)
  14. Solved: Counting Text with commas (5 replies)
  15. [SOLVED:] Show Desktop (2 replies)
  16. [SLEEPER:] Picking respective value from different col based on a particular value input. (1 replies)
  17. Code to save to a sub folder? (1 replies)
  18. Solved: VB code to save file to app directory? (6 replies)
  19. Solved: Calculating stock price volatility over and over and over... (7 replies)
  20. Solved: Ending a loop at the bottom of column (13 replies)
  21. Adding to Named Range and Disappearing coloring (3 replies)
  22. Problems with interface design for when long macros process (suggestions welcome!) (3 replies)
  23. Solved: Arrays with Arrays (20 replies)
  24. Solved: Comparing two columns of data and outputting the differences (3 replies)
  25. Solved: Create on the fly labels with click events (7 replies)
  26. Interacting the Search Dialogue Box (9 replies)
  27. Solved: Conditional Formatting (5 replies)
  28. Solved: Adding text to a cell with CheckBoxes (8 replies)
  29. Enable Macros when opening Worksheet (2 replies)
  30. Solved: Animation Control limitations (2 replies)
  31. Solved: MkDir, multiple directories? (3 replies)
  32. Solved: Age calculation (6 replies)
  33. AfterUpdate Event (5 replies)
  34. Interesting Issue With Labeling Data Points (1 replies)
  35. Solved: UDF in Conditional Formating (0 replies)
  36. Solved: Week Number Of The Month (0 replies)
  37. How to Make Handwritten Code or Macros (5 replies)
  38. Spin Button (2 replies)
  39. Solved: Macro processes too much, so Office apps hang until finished! Ideas? (6 replies)
  40. Staff ID Number format (13 replies)
  41. [SOLVED:] Userform + Range=#value (8 replies)
  42. Solved: label.caption take text from file (3 replies)
  43. [SOLVED:] Trigger Macro by change in formula value within a cell (7 replies)
  44. camembert (4 replies)
  45. Solved: Determining size of chart area? (2 replies)
  46. Solved: Run a macro with inputbox (2 replies)
  47. Solved: insert text in columns with itineration (9 replies)
  48. Import txt files into excel (3 replies)
  49. Bring chart infront of web browser (0 replies)
  50. Sending the Email by Excel by searching the Attachment names start with 302568 (0 replies)
  51. Solved: FindNext (16 replies)
  52. unable to set the text property of the characters class (14 replies)
  53. VBA: Identify Last Column with data in a specific Range and copy to next column (3 replies)
  54. Solved: other possibilities? (4 replies)
  55. Exporting Data into Different Cells at Set Intervals (3 replies)
  56. Macro to countif multiple criteria (3 replies)
  57. Excel File Properties in Windows Explorer (2 replies)
  58. Solved: ignore files which are blank? (2 replies)
  59. Solved: text box dependent on list box in userform (2 replies)
  60. Webbrowser control (1 replies)
  61. Populating Oracle SQL Queries in different Sheets in Excel using VBA code (9 replies)
  62. How to control which vba Excel program has control on computer (5 replies)
  63. Converting formula into values. (1 replies)
  64. Excel Custom Headers and Footer (1 replies)
  65. Dynamically Specifying Series and X/Y Values of a Chart (1 replies)
  66. Merging Cells (10 replies)
  67. copy down formula (1 replies)
  68. Solved: SUMIFS (2 replies)
  69. Extending chart series range (2 replies)
  70. Write to Module Using VBA (3 replies)
  71. Help in sorting in data or macro or simple method. (1 replies)
  72. Solved: Option Explicit (6 replies)
  73. Speeding Up Vlookups (2 replies)
  74. Autofilter on row 3 (2 replies)
  75. Solved: error when looping (5 replies)
  76. [SLEEPER:] VBA Column Looping (1 replies)
  77. Excel - transpose multiple records (9 replies)
  78. Solved: Make Code run only on xls files (4 replies)
  79. Solved: Displa first item in combo box (2 replies)
  80. Sumif formula (1 replies)
  81. Solved: Sort Not Working When Formatting Applied (2 replies)
  82. Loop trough workbooks and Paste values (5 replies)
  83. VBA Code to export formula to cells? (3 replies)
  84. Create a List based on Cell Values from multiple Sheets & Columns (2 replies)
  85. Macros for excel (2 replies)
  86. Solved: Applying an Advanced Filter Using VBA (6 replies)
  87. Inter related items (7 replies)
  88. Stop code from running when opening (1 replies)
  89. Solved: Adding pre-fixes (11 replies)
  90. [SOLVED:] Lookup question (3 replies)
  91. How to access menu items of Excel add-in? (3 replies)
  92. Solved: Checking if macro run again- same month (4 replies)
  93. Excel Crash (10 replies)
  94. Coloring depending on the Series (1 replies)
  95. Find the cursor position in a string (6 replies)
  96. Seeking help in creating an excel macro for shutting down pc (4 replies)
  97. Resetting Color Pallette (3 replies)
  98. Loop through charts (1 replies)
  99. Sleeper: Excel to Autocad (1 replies)
  100. ComboBox Help! (4 replies)
  101. Solved: Data Validation on User Form (8 replies)
  102. How to dyamically change which pages will print (0 replies)
  103. Hint about VBA functions (2 replies)
  104. Solved: Running two macros on opening (1 replies)
  105. Application.close information required (3 replies)
  106. Add formula to cell (2 replies)
  107. Animation in Excel (4 replies)
  108. If cell = [Word], hilight row (8 replies)
  109. Solved: Text and Value in 1 cell is it difficult? (4 replies)
  110. [SOLVED:] Creating the Game: Boggle (15 replies)
  111. [SOLVED:] Copy. (2 replies)
  112. Change Pivot Field function from xlCount to xlSum (1 replies)
  113. That Missing file!! (7 replies)
  114. How to use "For loop" until the cell.value becomes null? (1 replies)
  115. [SOLVED:] Question About Global Variables (26 replies)
  116. highlight 2 consecutive cells in same Col (2 replies)
  117. Solved: Counting to Last Cell (4 replies)
  118. Solved: Editing listbox in a row (8 replies)
  119. [SLEEPER:] Running total stat graph (8 replies)
  120. Solved: ListBox for the rows (2 replies)
  121. Web pages data search and autopopulation (8 replies)
  122. [SOLVED:] Create sheets out of data in Column A (8 replies)
  123. Need Help Combining 5 Macro's into 1 Macro (2 replies)
  124. Combine Specific Worksheets into One (4 replies)
  125. Move Column to next tab (3 replies)
  126. Solved: Loop find and replaced (2 replies)
  127. Solved: how to restrict copy, paste in workbook (2 replies)
  128. [SLEEPER:] How to Protect a workbook with different encryption in VBA (6 replies)
  129. Interpolation of data on Excel (2 replies)
  130. Text Box (12 replies)
  131. restrict a excel file opened open office (3 replies)
  132. Solved: Additional Controls menu doesn't appear (2 replies)
  133. Copy & paste based on value (4 replies)
  134. Solved: copy row and paste to next sheet (5 replies)
  135. Sending Mails Automatically (19 replies)
  136. Solved: insert date with vba (11 replies)
  137. Solved: Listbox Selected Items Count? (4 replies)
  138. Solved: Find String (2 replies)
  139. Solved: Auto Plot Chart routine fails (5 replies)
  140. Solved: Named Range Copy (3 replies)
  141. Hyperlink Address changing (1 replies)
  142. Need help altering macro to move columns not rows (2 replies)
  143. [SLEEPER:] Fixing Column Widths After Importing Data (28 replies)
  144. Word To Excel help (4 replies)
  145. Mouse Jiggler? Anybody got one? (3 replies)
  146. Solved: Having Trouble with For Each Loop (13 replies)
  147. Solved: Name Ranges (2 replies)
  148. Solved: converting relative addresses to absolute (4 replies)
  149. Right click - Paste Special Clear Formatting (3 replies)
  150. Solved: LastRow.Offset but for Colomn (4 replies)
  151. [SOLVED:] Deleting the space (3 replies)
  152. Disable printing and macros from specific date (4 replies)
  153. add picture to standard pictures excel (0 replies)
  154. [SLEEPER:] How can I combine the following 3 vba scripts to 1 (8 replies)
  155. [SOLVED:] Filtering Dates (28 replies)
  156. Solved: Match data with macro or lookup formulas (3 replies)
  157. Solved: For Next loop inside a If statement (4 replies)
  158. Solved: Remove ^ From Begining of Every Cell (12 replies)
  159. [SOLVED:] Finding in Reverse Order (3 replies)
  160. MkDir problem ?! (7 replies)
  161. columns spontaneously hidden when file reopened (7 replies)
  162. Creating Data for Missing Time Series (3 replies)
  163. Solved: Name (too long) (6 replies)
  164. Solved: Double a value multiple times (6 replies)
  165. Solved: FORMULA REQUIRED (5 replies)
  166. Paste a string (3 replies)
  167. Solved: Obtaining the Value from a Formula in VBA (4 replies)
  168. Solved: How to save a cell value to another sheet (5 replies)
  169. Type mismatch error (3 replies)
  170. Solved: VBA to write a formula while referencing a Named Range (3 replies)
  171. Range cells combination problem (4 replies)
  172. Copy paste data based on criteria in a loop (3 replies)
  173. Sleeper: Looks for some codes than copy (5 replies)
  174. Finding the text Dismantle and filling respective row with a color then copy All Dism (1 replies)
  175. Solved: run-time save file as 2007 (8 replies)
  176. Import Data Help (8 replies)
  177. Solved: Range("A4").End(xlDown) Error (5 replies)
  178. Solved: Every other line (5 replies)
  179. sheetbeforerightclick and addin (1 replies)
  180. Solved: linking to a range of cells (12 replies)
  181. Solved: summing range (21 replies)
  182. Need help copying cell values to email body (3 replies)
  183. Problems with Range property (4 replies)
  184. column name (4 replies)
  185. Solved: Excel running inside Internet Explorer (5 replies)
  186. [SOLVED:] Is this possible (1 replies)
  187. Solved: pivot table issue (6 replies)
  188. Solved: case statement for sheets (6 replies)
  189. Solved: Save and Close automatically if inactive (2 replies)
  190. [SLEEPER:] Prevent Modification of a Range via VBA Instead of Sheet Protection (4 replies)
  191. Dbl Click in cell(dot) ? (5 replies)
  192. Solved: Worksheet_Change Question (20 replies)
  193. AR Aging - will not skip blank cells (6 replies)
  194. Solved: Clear Cells Except Cells with Formula (11 replies)
  195. Dialog Box in Insert option (1 replies)
  196. [SOLVED:] Creating a new CSV file using VBA code (5 replies)
  197. Solved: Summing range and copying accross (5 replies)
  198. RefEdit in non-modal form (2 replies)
  199. Solved: Previous Month (2 replies)
  200. Solved: How to open a form from another form (4 replies)
  201. [SOLVED:] Incremental Loop (22 replies)
  202. Imported array and vlookup named range (2 replies)
  203. [SOLVED:] Self Closing Message Box (8 replies)
  204. [SOLVED:] Change Cell Colors VBA (3 replies)
  205. Solved: Countif conditions (2 replies)
  206. Solved: Form not Uploading (21 replies)
  207. Solved: Find cell value from a range & resize and copy to a worksheet (5 replies)
  208. Loading a Picture gives Runtime Error 424 (4 replies)
  209. Solved: Graph populated by Dropdown (10 replies)
  210. Solved: show/hide label/textbox based value (2 replies)
  211. MMUlt not working (6 replies)
  212. Email Active Worksheet using Groupwise - HELP (0 replies)
  213. Trying to Automation Scheduler via VBA or Formula (0 replies)
  214. Solved: Omitting Path in ActiveWorkbook.Saveas (6 replies)
  215. Solved: CONCATENATE - help needed (3 replies)
  216. Solved: populate ComboBox from text (13 replies)
  217. Solved: Rename sheet using NOW function ??? (5 replies)
  218. Adding combo box values thro VBA (5 replies)
  219. Sleeper: Copy/Paste results of an if & else from all wrksheets to a wrksheet (0 replies)
  220. Solved: VBA Reporting Too Many Worksheets (4 replies)
  221. Solved: Creating Buttons (4 replies)
  222. programmatically copying a sheet (2 replies)
  223. Solved: DATE Difference (3 replies)
  224. [SOLVED:] Paste Special / Values / Transpose (7 replies)
  225. xls to 2007 file type (4 replies)
  226. Help - Need to Lock all cells in range if Column Header <> Today (3 replies)
  227. [SOLVED:] Formula Problems (1 replies)
  228. [SOLVED:] Folder Size within a directory - tweak code (7 replies)
  229. Results of my equation and function don't match (5 replies)
  230. last row variable in auto filter (3 replies)
  231. [SOLVED:] Removing Duplicates In Excel (1 replies)
  232. Solved: Various formulae Questions (13 replies)
  233. [SOLVED:] date formats changing in filter? (2 replies)
  234. Turning cariage returns into new column in excel (3 replies)
  235. [SOLVED:] toggleButtons... (1 replies)
  236. [SLEEPER:] Open a word document from a webpage (2 replies)
  237. [SOLVED:] How to Delete Diagonal (Border) Lines (5 replies)
  238. Solved: Creating &quot;At and Angle&quot; Symbol in VBA (16 replies)
  239. Paste / Special / Transpose Code (2 replies)
  240. Solved: Random Vocabulary Terms (5 replies)
  241. Solved: delete rows (5 replies)
  242. COPY FROM CELL (4 replies)
  243. Solved: Automating a Macro (16 replies)
  244. Downloading attachment from a specific user's email to hard disk, deleting the mail (2 replies)
  245. Code Stopped Working..sort of... (12 replies)
  246. Filtered Mode Copying and pasting as value yield as error? (1 replies)
  247. Extracting A Substring (4 replies)
  248. Solved: Get data from web page and paste to excel (21 replies)
  249. Downloading a non-excel file from server through Excel (0 replies)
  250. Solved: XLAM file replacement (7 replies)