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. Conditional selection in excel VBA? (3 replies)
  2. [SOLVED:] Need Help : VBA in EXCEL / (if possible in DIAdem software) (25 replies)
  3. Vlookup from two cells (5 replies)
  4. highlighting over due dates (1 replies)
  5. Simple find? (8 replies)
  6. Solved: Cell Interior.ColorIndex Property Changing (2 replies)
  7. Solved: VBA HTML - how do I access this button? (2 replies)
  8. Solved: Formula to capture cell's displayed value (6 replies)
  9. Solved: populate text box from combo box via vlookup function (4 replies)
  10. Solved: Editing Cell Comments Via VBA (2 replies)
  11. New to VBA (6 replies)
  12. Solved: .AddItme help (4 replies)
  13. Removing duplicates with a difference (2 replies)
  14. activecell.value - change from sub (3 replies)
  15. Compting 99% of a col range while autofilter is on. (1 replies)
  16. Conditional Formatting & Reading Fill Value (5 replies)
  17. Solved: Passing Variables from Sheet Code to Module Code (1 replies)
  18. Formula in VBA problem (3 replies)
  19. 2 dimensonial lookup formula not working (1 replies)
  20. Solved: Combo Box question (2 replies)
  21. Closing Excel & Opening Access (1 replies)
  22. Solved: Insert Formula by VBA method (5 replies)
  23. Solved: for loop (1 replies)
  24. How to Fetch Web Data into Excle (19 replies)
  25. Solved: Read Only: Disable opening/or disable prompt-to-save-as? (5 replies)
  26. Tooltip Variable Values Vanished from VBE! (0 replies)
  27. lines in a cell or dropdown to next cell (10 replies)
  28. How to randomly choose sample rows after using Autofilter?? (19 replies)
  29. using sumproduct or sumif (6 replies)
  30. Setting the value of a cell to the value of a variable (6 replies)
  31. qty breakdown for inventory (5 replies)
  32. [SOLVED:] Before print function (4 replies)
  33. Solved: If/then statment where "then" does multiple actions? (6 replies)
  34. Excel and Access (1 replies)
  35. excel vba to autofit row after cell update (1 replies)
  36. Solved: Select Case with > 1 Variable (3 replies)
  37. Help RC FORMULA STYLE (3 replies)
  38. Copying to next empty row (0 replies)
  39. auto create text (3 replies)
  40. Solved: Add Text to Old Call/New Call (7 replies)
  41. PIvot Tabel macro no longer works since upgrade to Excel 2007 (0 replies)
  42. Inserting a row and moving a particular cell down one row (6 replies)
  43. txtDate (6 replies)
  44. Solved: How did I screw up Johnske's routine to force macro enabling? (2 replies)
  45. Automation of Data Transformation and Consolidation (0 replies)
  46. help with re-calculating Excel UDF (3 replies)
  47. Accessing files on webpage (0 replies)
  48. Excel 2007 Populate table with web query (0 replies)
  49. Compare cells and highlight on a result (2 replies)
  50. change formulas to (8 replies)
  51. Copy Entire Row if Column Value is Negative (20 replies)
  52. Solved: named ranges (3 replies)
  53. Solved: move sheets from specific files each time a macro runs (8 replies)
  54. Can we compare the Excel columns alone (5 replies)
  55. Problem when using OFFSET (7 replies)
  56. Solved: BIN2HEX Worksheet Problem (8 replies)
  57. [SLEEPER:] Initialize cell with mmult formula (2 replies)
  58. Solved: Pass an InputBox value into number of rows (3 replies)
  59. set cell value (3 replies)
  60. Solved: Select large array of non-contiguous ranges (4 replies)
  61. Ticking Clock (4 replies)
  62. First Time VBA'(er?) (2 replies)
  63. Solved: Using A Date in DSum formula (1 replies)
  64. Solved: Setting default date in calendar (4 replies)
  65. Help require in lookin for option button click event code. (1 replies)
  66. number format (2 replies)
  67. Execute diferent formula depending on cell value (3 replies)
  68. Problem with SetFocus (8 replies)
  69. Solved: Counting based on 2 criteria (2 replies)
  70. Solved: Looking up date and calculating monthly returns (11 replies)
  71. Activate Method of Range Fails (2 replies)
  72. Solved: Formula Improvement - Hours * Rate (2 replies)
  73. Tabing issue in Combo box (12 replies)
  74. [SOLVED:] Worksheet change event to populate timestamp (3 replies)
  75. Finding Holidays Formula (3 replies)
  76. Solved: Loop Through cells and sum (5 replies)
  77. Solved: Extract Date (7 replies)
  78. Speeding up loop: deleting rows (7 replies)
  79. Solved: Date Picker default date (9 replies)
  80. Solved: Userform Show/Hide Problem (2 replies)
  81. Restricting access to a user to update a cell that is being updated by another user (3 replies)
  82. Screen Flickers with screenupdating set to false (4 replies)
  83. [SLEEPER:] Compare two lists... and make changes (2 replies)
  84. Solved: Save Data Based on Vlookup (2 replies)
  85. Solved: Populating Combo Box With Values VBA (2 replies)
  86. Delete the row if cell contains null value else as it is ? (4 replies)
  87. Extracting data text and so on. (4 replies)
  88. show popup of all sheet tabs (8 replies)
  89. Populate combo box from selection of different combo box (11 replies)
  90. Solved: Lookup Intersection and copy column data into another sheet (6 replies)
  91. Solved: Need help "Run-Time error 91" (7 replies)
  92. Open to specific location of worksheet (6 replies)
  93. Excel Creating an Email Error (3 replies)
  94. Solved: Formula property compile error (8 replies)
  95. Solved: userform textbox format for currency (2 replies)
  96. Solved: Get state of checkboxes (3 replies)
  97. Blank or null string in drop-down (17 replies)
  98. Solved: variables carrying over from userform to Module (11 replies)
  99. find next and loop combined (4 replies)
  100. Solved: Return Sheet Index of Last Sheet (2 replies)
  101. Solved: reversed sequences in code (1 replies)
  102. Solved: Find does not do an exact match (2 replies)
  103. Sampling after Auto-filtering (9 replies)
  104. Solved: Finding the rows of a Selection (6 replies)
  105. count subfolders (2 replies)
  106. consolidating the difference in counts on hourly basis (6 replies)
  107. Protect a column ins workbook with macros (8 replies)
  108. [SOLVED:] Validation In Cell (14 replies)
  109. Solved: Delete a CSV Workbook from Another Workbook? (1 replies)
  110. A little (?) VBA help (8 replies)
  111. Copying Worksheet to another book with new name (2 replies)
  112. Solved: Converting Minutes Into Hours (1 replies)
  113. How can i speed this up? (3 replies)
  114. Hide comments programmatetically (1 replies)
  115. Solved: Hide row with a 1 on selection change (4 replies)
  116. Link userform check boxes with corresponding text boxes (4 replies)
  117. Solved: Selecting a hyperlink using Data Validation (8 replies)
  118. Solved: How to rename text file to date and time format (3 replies)
  119. Need Code to Check if .CSV file has finished writing (2 replies)
  120. Solved: Finding Specific Days In a Year (6 replies)
  121. Solved: deleting duplicate rows (3 replies)
  122. Solved: Create Multiple Sheets and Save As CSV (COMMA DILIMITED) FORMAT (8 replies)
  123. Regarding getting values for Multi Column LISTBOX (5 replies)
  124. Hyperlink to Chart or Range by Double-click Named range (1 replies)
  125. working on range (6 replies)
  126. Solved: Using comments to track changes (6 replies)
  127. Excel values to Website, web data extractn back to Xls. PLEASE Help!!! (1 replies)
  128. [SLEEPER:] Linking excel with folders and show the content (5 replies)
  129. IF, Solver and Clearing Cells based on the IF (1 replies)
  130. Button w/drop down list (3 replies)
  131. [SOLVED:] TAT Calculate in office hours (3 replies)
  132. Copy/Past cell contents into a PDF Field (0 replies)
  133. Look For and delete (5 replies)
  134. Accessing Excel Spreadsheet via Sharepoint (0 replies)
  135. Excel CSV Read issue (5 replies)
  136. Compare Columns (3 replies)
  137. VBA Performance Query (3 replies)
  138. Cnverting Excel if into UDF. (4 replies)
  139. Solved: excel's IF function (3 replies)
  140. Solved: excels AND function (6 replies)
  141. Solved: shapes in a worksheet (2 replies)
  142. Solved: Simple question for CheckBox in sheet (1 replies)
  143. Make other cells invisible or locked programmatically (6 replies)
  144. Need a solver (3 replies)
  145. Save different filename based on multiple selection (3 replies)
  146. Insert Rows (8 replies)
  147. Match function for 2 columns (5 replies)
  148. Solved: excel to word for Labels (3 replies)
  149. Combine 2 similar worksheets (live document) (1 replies)
  150. Return cell address in messagebox (5 replies)
  151. Exclude a single xl file from macro (13 replies)
  152. Excel Macro that creates an Auto Macro (1 replies)
  153. Formula Referencing other cells (5 replies)
  154. Cant read txt file with Unicode symbols and store it to cell (2 replies)
  155. Solved: vba to make formulas work (3 replies)
  156. Closed: sendkeys (1 replies)
  157. entirecolumn.hidden with autofilter result (3 replies)
  158. Solved: VBA code for a button with user supplied titles (1 replies)
  159. [SLEEPER:] Filling an array with a for..each construct (4 replies)
  160. Case Select Statement (4 replies)
  161. Solved: Combo Box inside pop-up Message Box ? (13 replies)
  162. Call tracker - VBA coding help (15 replies)
  163. multiple search and filter (1 replies)
  164. Unhide a Hidden Workbook (4 replies)
  165. Solved: Force users to enable macros in a workbook code by Ken Puls. (2 replies)
  166. problem with activecell is blank or zero (1 replies)
  167. Problem with Cancel Button in Input Box (6 replies)
  168. enter commas (3 replies)
  169. Really Quick Precision Question (2 replies)
  170. Solved: Using Bold with .Cells Object? (2 replies)
  171. Compare Workbook to 2nd workbook (Newbie) (3 replies)
  172. removing items from collections (7 replies)
  173. Solved: Extracting 5 or 6 digit numbers from a cell (31 replies)
  174. optionbuttons and vba (4 replies)
  175. Excel multi criteria search (8 replies)
  176. Solved: Copy module from present file to PERSONAL.XLS (10 replies)
  177. Imbedding Image File Instead of Referencing? (9 replies)
  178. Carriage Return not working (2 replies)
  179. Trouble With Assigning Value to Cell (5 replies)
  180. [SOLVED:] Delete VBA Project (3 replies)
  181. Solved: Initializing Entire Array at Once:: Syntax Error (4 replies)
  182. zodiac userform to display zodiac sign picture based on users birthdate (5 replies)
  183. Save As Issues (excel 2003 and excel 2007) (1 replies)
  184. Need a String Function (7 replies)
  185. Delete WB-Open sub as WB is saved (2 replies)
  186. Custom menu top left (8 replies)
  187. force users enable macros and auto save&close if idle (9 replies)
  188. Solved: Deleting rows from selected cells. (3 replies)
  189. Not Highlighting Errors (2 replies)
  190. Solved: Argument Not Optional Error (1 replies)
  191. Solved: Find string in the cell and then output value (11 replies)
  192. Return a value from an activex (2 replies)
  193. [SOLVED:] Extract Data From Text File (2 replies)
  194. Combining vba for forcing macros and expiry (3 replies)
  195. Array help, deleting columns. (3 replies)
  196. Pasting charts in the same document - avoiding new instance creation (3 replies)
  197. Solved: Passing variables between suns and functions (3 replies)
  198. Solved: Command Buttons to SAVE, SAVE and EXIT and to EXIT without SAVING (5 replies)
  199. Update the value from B file to A file (4 replies)
  200. Searching a record or row. (2 replies)
  201. Solved: .bas vba export question (9 replies)
  202. Solved: copying dynamic range from Sheet1 to Sheet2 (11 replies)
  203. Solved: to accept changes (5 replies)
  204. Remove the file extention from the file list (5 replies)
  205. Insert A row in workbook A automatically if a row is inserted in WOrkbook B (4 replies)
  206. transferring selections from one list box to another (1 replies)
  207. Solved: strange Unload Me behaviour (1 replies)
  208. Solved: Arrows in Excel Document (3 replies)
  209. Solved: Delete row (numbered) all other rows (numbers) change in sequence (31 replies)
  210. Fusing chart and shapes before copying (1 replies)
  211. Finding mode of array in VBA (1 replies)
  212. Need to nest .Find routines in VBA (4 replies)
  213. Solved: Multidimensional Array Sort (3 replies)
  214. [SLEEPER:] Check for visible rows after filter (4 replies)
  215. Solved: Deleting multiple values within range of rows (2 replies)
  216. Insert Template Macro (3 replies)
  217. Solved: Small macro, simpler way of writing it? (4 replies)
  218. calculate % of each items total in a year in Pivot Table (5 replies)
  219. Solved: counting number of observations under condition (5 replies)
  220. Solved: Filter Workbook when protection is on (2 replies)
  221. Solved: UDF for mann-whitney statistical test? (21 replies)
  222. Solved: Batch Renaming all files in a folder (2 replies)
  223. parsing in vbscript (18 replies)
  224. Combination from binary bit to Hexdecimal (5 replies)
  225. Solved: add slash in string (2 replies)
  226. copying information from another tab (1 replies)
  227. Reading pdf file into excel 2007. (6 replies)
  228. Delete Custom Document Properties? (1 replies)
  229. [SOLVED:] From Excel, create table of selected rows in Word (11 replies)
  230. Count all unique entries in a column (mission impossible?!) (12 replies)
  231. Solved: VBA to delete text between < > (4 replies)
  232. Solved: Excel insists on changing the format of cells (4 replies)
  233. Selecting a sheet within a workbook by using a macro (11 replies)
  234. ListBox Item queries (2 replies)
  235. Set TextOrProperty attribute change the name of company (4 replies)
  236. Autohyperlink to and replace file names in worksheet (4 replies)
  237. calculating monthly returns in table from historical data (6 replies)
  238. Late-binding --pls sort out the confusion (3 replies)
  239. Using data in a worksheet and vba to complete a form on a website. (0 replies)
  240. Solved: Highlight only certain words in cells (2 replies)
  241. is it possible to do screen tips without hyperlinks (4 replies)
  242. Worksheet change - single click>value entered (1 replies)
  243. Solved: Set X-Axis Value to match row numbers (9 replies)
  244. EXCEL TO WORD BOOKMARK (0 replies)
  245. Sorting CurrentRegion? (1 replies)
  246. Solved: Printout Problems (5 replies)
  247. Importing part of textfile (3 replies)
  248. start search from beginning with static variable (3 replies)
  249. Excel 2003 File Size (12 replies)
  250. How to make a text box mandatory? (5 replies)