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. [SOLVED:] Need Help Trying to Unlock Certain Cells (3 replies)
  2. Generate a message to Save and Not Open when downloading a file (6 replies)
  3. Solved: Remove blank series from a chart using VBA ? (4 replies)
  4. Hiding sepecific column on based of condition (3 replies)
  5. autofilling formulae across columns (1 replies)
  6. Making a cell noneditable based on dropdown value in another cell (8 replies)
  7. [SOLVED:] Database Connectivity Using Singleton Pattern (7 replies)
  8. Solved: Code to find a given string in a worksheet (4 replies)
  9. Solved: Excel Update Links Problem (4 replies)
  10. Solved: UserForm KeyDown Button Forces cursor to jump to next textbox (6 replies)
  11. Incorporating lastrow variables into sumproduct formula (8 replies)
  12. Looping through a range code (5 replies)
  13. Delete Copied Data (3 replies)
  14. Using Progress Bars (3 replies)
  15. VBA Statements work in debug, but not otherwise. (2 replies)
  16. Solved: Sheet Calculate Event Not Working (1 replies)
  17. Solved: Macro to add value to cell based on previous available cell valu (9 replies)
  18. Paste Combo Boxes so Cell Link is always in same row (3 replies)
  19. Disabling ActiveXControls Prompt (7 replies)
  20. Decent Grids (2 replies)
  21. Solved: Check list of folder files (5 replies)
  22. Match value in two columns & delete non-matching rows (13 replies)
  23. Self Destruct VBA Code (10 replies)
  24. Solved: Find a sheet name (4 replies)
  25. Copy to first filtered row problem (3 replies)
  26. Solved: Sync ListViews items (1 replies)
  27. Excel 2007 and if statements (3 replies)
  28. Unable to copy, paste; Right click disabled (14 replies)
  29. Solved: Insert a formula if a different cell is not blank (3 replies)
  30. Solved: Copy range from multiple excel files in one file (5 replies)
  31. Solved: Get cell reference from one cell (5 replies)
  32. move items in column up/down by criteria (5 replies)
  33. Update specific data in one sheet with NEW data from another? (4 replies)
  34. problem comparing cells based on a condition (6 replies)
  35. Functions (7 replies)
  36. How do I check if a word file is open from code? (9 replies)
  37. Selected Cell Color / Personal.xlsb (3 replies)
  38. Solved: clicking on option button (6 replies)
  39. Maximum users of an Excel File? (1 replies)
  40. Solved: Pattern match to find worksheet name (3 replies)
  41. Trapping UserForm Events In A Seperate Class (3 replies)
  42. Finding String2 in String1 (2 replies)
  43. Copy from a cell and insert in another on a new line with a date (4 replies)
  44. Excel 2007 Pivot chart - showing filters on pivot area (1 replies)
  45. Using Template To Produce Reports Where Number Of DataItems Changes - Advanced. (2 replies)
  46. Error when passing data from Excel into Access (Office '97) (2 replies)
  47. Solved: Calendar Control (3 replies)
  48. Tracking Deadlines with Excel and Groupwise (1 replies)
  49. Select/De-select items in list box (3 replies)
  50. Closed: My Macro keeps crashing! (2 replies)
  51. My Macro stinks (2 replies)
  52. Solved: Prevent duplicate data entry? (15 replies)
  53. [SOLVED:] Macro to make linegraphs (13 replies)
  54. How To Use Vertical Spacing - Make Equal (1 replies)
  55. Solved: vlookup problems, even formatted as numbers (4 replies)
  56. Referenzen permanent verfügbar machen (5 replies)
  57. How to open Other file types (3 replies)
  58. Option Button first IF not working..... (5 replies)
  59. Bot (1 replies)
  60. Icon Librarys (2 replies)
  61. Professional Looking UI Forms (1 replies)
  62. Sleeper: The opposite of TRIM (2 replies)
  63. Running a function of another file (3 replies)
  64. Pivot Table Macro to lock manual filter/remove blank rows from datasheet (0 replies)
  65. Solved: vlookup not cooperating with other code (0 replies)
  66. Getting user to log changes before workbook is closed. (4 replies)
  67. Solved: Split Control (6 replies)
  68. Pass date as parameter (3 replies)
  69. Error message for missing data in userform (6 replies)
  70. Solved: Copy/Import based on Column Header Name (0 replies)
  71. Source Control Of Spreadsheets (6 replies)
  72. Returning Arrays From Functions (4 replies)
  73. VBA Code to Automate Grouping (3 replies)
  74. How do I disable inserting of rows? (1 replies)
  75. Preparation of excel spreadsheet data for google motion charts api (VBA?) (1 replies)
  76. Column Formatting Works in one instance, but not another (6 replies)
  77. How to deal with quotes within a string (1 replies)
  78. How to line up input boxes on forms? (3 replies)
  79. VBA Strongly Typed Arguments (4 replies)
  80. Get help for telling me how to code VBA to pass argument from Userform to worksheet (6 replies)
  81. Comparing data against table of values to output new data. (2 replies)
  82. Solved: EXCEL communicating with hyperterminal (6 replies)
  83. Listbox items from an array (10 replies)
  84. filter based on active cell (23 replies)
  85. Solved: Loop and Compare cell value & value returned from ado query (0 replies)
  86. Finding average of a range with macro (3 replies)
  87. Solved: Print Preview (2 replies)
  88. Naming ranges of cells using cell content (4 replies)
  89. Deleting All Shapes Deletes Data Validation Forms (6 replies)
  90. Separating prices by month (1 replies)
  91. Solved: Simple delete entire row (6 replies)
  92. How to extract data from Oracle Database into Excel Spreadsheet via VBA code (5 replies)
  93. Scrollbar (1 replies)
  94. Thank You VBA Express. (6 replies)
  95. Solved: how to wrap pages in multipage control (2 replies)
  96. Solved: write log of changes in workbook (7 replies)
  97. Userform in Defult text box (4 replies)
  98. Solved: Search Macro and Merged Cells (5 replies)
  99. [SOLVED:] Date format incorrect from Text File (11 replies)
  100. Invoice (35 replies)
  101. Solved: Select numerous cells from active cell (2 replies)
  102. Cascading Lists via VBA (2 replies)
  103. Running a Function or macro of child file from a Master file (1 replies)
  104. Updating series for all charts on Worksheet (5 replies)
  105. How to make an input form? (35 replies)
  106. CHART Formula Change VBA (17 replies)
  107. Solved: Employee Rota: Worksheet_SelectionChange not working (3 replies)
  108. Get txt files from a folder to master file in different sheets (5 replies)
  109. Sum If Same Row in data table contains criteria (2 replies)
  110. Solved: if cell="yes" then colour row yellow? how could do this? (6 replies)
  111. Solved: Want to apply code to all sheets but wont work (1 replies)
  112. Solved: Automatically Save As when file opens (2 replies)
  113. Annoying privacy warning (11 replies)
  114. Creating Timestamps (5 replies)
  115. Data changed when imported (7 replies)
  116. Copying range value without cellformula (6 replies)
  117. Excel chart alert (32000 pts) (1 replies)
  118. Solved: Deleting rows as if by magic!! (11 replies)
  119. Solved: Using vlookup with changing end array column (5 replies)
  120. Combine 2 Codes (4 replies)
  121. Solved: Run-Time Error "13" - Type Mismatch (3 replies)
  122. [SOLVED:] Exporting select data to a .cvs (32 replies)
  123. Solved: Problem with textfile save (1 replies)
  124. copy rows to worksheet two and PDF to print (7 replies)
  125. Solved: Named cell reference (6 replies)
  126. Solved: Changing code (connecting range to dropdown selection) (14 replies)
  127. Solved: TextBox Deleter Mystery (18 replies)
  128. Solved: Create folder & export sheet, not working (1 replies)
  129. Solved: Copy content of upper cells (14 replies)
  130. Read Only view of a worksheet (3 replies)
  131. Solved: Long vs Double data type (8 replies)
  132. Solved: VBA issue with named ranges across workbooks (2 replies)
  133. Solved: Covert number to absolute value (2 replies)
  134. Solved: YesNo Box - Options Query (3 replies)
  135. Solved: Vlookup in VBA - problems (8 replies)
  136. Combobox vs protected sheets (4 replies)
  137. ScrollBar value * call Macro (3 replies)
  138. Email code problem, stopped working (3 replies)
  139. Solved: Index Match Formula - Odd Behaviour (2 replies)
  140. Solved: rearranging Code, separating OffsetResize (4 replies)
  141. Solved: Interesting Auto-Number Problem VBA (11 replies)
  142. Solved: Subtracting Named Ranges from combo box selection (5 replies)
  143. Solved: Autofilling a formula within row parameters (2 replies)
  144. Solved: Create A Short Cut Key in Menu (11 replies)
  145. copying data from a closed workbook (1 replies)
  146. Solved: help with copy and paste (4 replies)
  147. Solved: Drop down lists tutorial (2 replies)
  148. [SOLVED:] Dynamic Controls (7 replies)
  149. [SOLVED:] Solved: Check if Sheet Name Already Exists (2 replies)
  150. Solved: Deleting Worksheets without OKing "Warning Message" (2 replies)
  151. Solved: multiply statusbar (29 replies)
  152. Solved: VBA Sort (8 replies)
  153. Solved: Insert Image from file (2 replies)
  154. Solved: VBA Hyperlink Problem (6 replies)
  155. Solved: Run time error 1004 (2 replies)
  156. Solved: Text Import - cell format issue (2 replies)
  157. insert array formula into range based on option button selection (5 replies)
  158. Solved: Formula For Less Than / Greater Than (2 replies)
  159. Please help to tweak my VBA codes (0 replies)
  160. Solved: How to bring back Recording / Stop Recording floating tool bar (2 replies)
  161. Solved: Active Cell Help (18 replies)
  162. [SOLVED:] Loop not looping properly (2 replies)
  163. [SOLVED:] check lengh of the values and move to next sheet (29 replies)
  164. Solved: Cut Paste data into different sheet (2 replies)
  165. Data And control operations from a closed workbooks being applied on report (0 replies)
  166. Solved: Highlighting Option Buttons (3 replies)
  167. Moving Data from one table to another based on value input (1 replies)
  168. Solved: Adding and Naming a Worksheet using VBA (3 replies)
  169. Solved: VBA Userforms and Cell based formulas not getting on together! (4 replies)
  170. Solved: Using is empty on a range (4 replies)
  171. Solved: Alphanumeric Sort (7 replies)
  172. Solved: Delete workbook on date.... (4 replies)
  173. Solved: Creating a drop down list with source from another sheet (3 replies)
  174. Solved: index/match with more than one match (7 replies)
  175. Solved: Downloading Excel File from Website (7 replies)
  176. Solved: check file for xls and xlsx extensions (3 replies)
  177. Error Generation during copypaste macro run (5 replies)
  178. VBA for copying and pasting and insertion of rows (0 replies)
  179. Solved: Different Passwords for all Users to view W/sheets 1 master password (40 replies)
  180. Solved: Search for first open cell in Row (4 replies)
  181. linking ranges into dropdown and option boxes (3 replies)
  182. Solved: Autofilter using date (4 replies)
  183. Solved: Print 2 pdf VBA error (9 replies)
  184. [SOLVED:] Column number conversion: hex to dec and dec to hex (11 replies)
  185. [SOLVED:] Counting Cells Where Formula Does Not Return "" (3 replies)
  186. Solved: want to remove #div/0 error by vbnull string (1 replies)
  187. Solved: create a named range with a changing area (2 replies)
  188. Update Links in multiple workbooks (2 replies)
  189. Solved: Creating a name range in one column (1 replies)
  190. Solved: Increment offset (3 replies)
  191. Solved: Noob question (1 replies)
  192. Solved: File IO low level functions -- not working (1 replies)
  193. Cost Forecast spreadsheet (1 replies)
  194. Solved: Manipulate String based on Carriage Return (8 replies)
  195. Userform runs ok in VBA Editor, but not when started from macro in workbook (1 replies)
  196. Solved: TextBox display columA & B (19 replies)
  197. Solved: Minimize/Maximize Userform (6 replies)
  198. Solved: dateserial format (2 replies)
  199. Solved: Using Countif with multiple criteria (4 replies)
  200. FollowHyperlink (5 replies)
  201. [SOLVED:] Exporting data to Word (13 replies)
  202. How Sheet formulae is called (9 replies)
  203. Solved: Move row to correct sheet if column V = "Y" (2 replies)
  204. Solved: Coloring sheet tab conditionnally (4 replies)
  205. Excel and Bloomberg (1 replies)
  206. Questioner Form (2 replies)
  207. how to count items in a column (2 replies)
  208. Solved: Macro is off... need help with copy & paste function (4 replies)
  209. Solved: Looking for VBA resources? (2 replies)
  210. Solved: Where can I find some VBA scripts or related scripts such as VB & VBS? (1 replies)
  211. Could you give me an example of a VBA script that automates writing scripts? (1 replies)
  212. Linking cells to sheets & Duplicate W/Sheets (1 replies)
  213. Soap Action Fails: redux and challenge (1 replies)
  214. Solved: Code works without proper Dims, why? (3 replies)
  215. Solved: Converting 3 Rows to 8 columns (6 replies)
  216. Solved: Excel does not allow importing* accdb files (1 replies)
  217. Solved: multiply values from a textbox and combobox in a userform (10 replies)
  218. Solved: Change based upon a cell value (2 replies)
  219. Solved: Combobox Colors (3 replies)
  220. Solved: save sheet to desktop with name from cell (5 replies)
  221. Solved: Save changes to Add-in on application close (5 replies)
  222. Adding controls to a form at runtime (4 replies)
  223. Solved: Delete a Worksheet Command Button (12 replies)
  224. Solved: identify last row and change formula accordingly (4 replies)
  225. Solved: Hide button with associated row (6 replies)
  226. Solved: If Not fso.FileExists ? (2 replies)
  227. Solved: Solved Zoom in if specific cells are selected (3 replies)
  228. Solved: Forms (5 replies)
  229. Need help writing an Input Function (7 replies)
  230. Solved: Array Help! (3 replies)
  231. Solved: Excel Charts - Naming (4 replies)
  232. Solved: Sort Data Help (0 replies)
  233. Worksheet_change (2 replies)
  234. Combo Box question (12 replies)
  235. Solved: Insert set parts in list (23 replies)
  236. Delete blank series from a XY Scatter Chart (2 replies)
  237. Solved: filtering on named ranges. (8 replies)
  238. Match function (4 replies)
  239. Solved: Problems converting date into required format (5 replies)
  240. Formatting TextBox (6 replies)
  241. multiply value with 1 - optimization (9 replies)
  242. Solved: Format code for multiple areas (2 replies)
  243. Automatic Reconciliation (0 replies)
  244. Solved: How to copy only formats and formulas, not values (3 replies)
  245. How do I launch a program from Excel? (1 replies)
  246. Solved: Text boxes (8 replies)
  247. What is the VBA code to enter text from a cell into a website's form? (12 replies)
  248. Hlookup (5 replies)
  249. Report to show >2 Instances of an Absence (5 replies)
  250. color grid (3 replies)