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 have spreadsheets changed your work? (18 replies)
  2. Hide Row if cell has specified word (2 replies)
  3. Setting up an array (3 replies)
  4. Creating a List Array for use in an ADO query (3 replies)
  5. Read Only to Read/Write and back again (4 replies)
  6. [SOLVED:] Solver in 2007 (1 replies)
  7. Calculation keeps getting changed (2 replies)
  8. Use FIND, skipping one (3 replies)
  9. Solved: Another Array Question (4 replies)
  10. Need help combining two sets of code into one sheet (1 replies)
  11. apply this VBA code to work in two worksheets in one workbook (17 replies)
  12. Solved: Compatibility (5 replies)
  13. Set the default file path and Extract the last value in nth occurence (4 replies)
  14. Solved: Mapping Excel Links (5 replies)
  15. Solved: Change Powerpoint Textboxes (2 replies)
  16. Capturing a list of files (for email attachments) (2 replies)
  17. What IS the purpose of "Design View"? (4 replies)
  18. Excel locking up when trying to delete all cell contents or select columns (5 replies)
  19. Breaking up a cell (2 replies)
  20. Solved: Summing Problem (4 replies)
  21. Solved: Deleting rows with odd conditions (3 replies)
  22. Problems with winhttp (0 replies)
  23. Working two worksheets into a third worksheet (1 replies)
  24. Find & Rename Text (9 replies)
  25. Solved: Deleting Columns on Conditions Matched with an Array (2 replies)
  26. Test if column has only one value? (11 replies)
  27. Sending E-mail from Excel via Comman Button (8 replies)
  28. Need help transfering data into another workbook (28 replies)
  29. [SLEEPER:] how to create file open dialogue box for consolidation (5 replies)
  30. Add sheets and copy data (2 replies)
  31. Solved: Dos Command in excel: "COPY " & file1 & " " & file2 (1 replies)
  32. [SOLVED:] Empty Cell Highlight (2 replies)
  33. extract text in strings (4 replies)
  34. Removing a cell from a selected range (8 replies)
  35. Solved: creating a summary report based on column data (8 replies)
  36. Date & time problem (2 replies)
  37. Solved: Copy entire sheet to a new workbook (4 replies)
  38. Excel 2007- Who is Using and Is it worth upgrading? (2 replies)
  39. Solved: Delete row range based on criteria in multiple columns (8 replies)
  40. Solved: hide columns based on value (3 replies)
  41. Solved: Duplicates (17 replies)
  42. automatically delet pictures (3 replies)
  43. Relational Lookup (7 replies)
  44. Looping Through an Array (5 replies)
  45. Solved: Copy Range and paste it into a insert comment (12 replies)
  46. Change Focus to non-office window. (5 replies)
  47. Solved: How to keep number value displaying fractional value (2 replies)
  48. Keystrokes from Office Macro into third party App (SolidEdge 2D free) (2 replies)
  49. Connection String in Excel VBA (5 replies)
  50. Export data to new WB and Add sheets (1 replies)
  51. turn formula to value (10 replies)
  52. [SOLVED:] Pull data from web (1 replies)
  53. Open minimized & save report (Newbie!) (2 replies)
  54. Solved: Find all instances of and then count (3 replies)
  55. Solved: "save as" subroutine and checking for saved status (6 replies)
  56. Date Update (17 replies)
  57. Solved: powerpoint paste (8 replies)
  58. Copying active worksheet to new workbook with module to go (19 replies)
  59. Keyboard (5 replies)
  60. Disable link prompt from showing (0 replies)
  61. xlVeryHidden in WorkBook_Open (4 replies)
  62. Solved: Multiple Tab Data to Chart (10 replies)
  63. input same value in multiple cells (4 replies)
  64. Solved: Create duplicate workbooks based on list (6 replies)
  65. help: Nested function as simple as UDF, but faster in calculation speed (8 replies)
  66. Solved: Open a Web Page on Validation (3 replies)
  67. Challenging project - Date (1 replies)
  68. Solved: Solver querstion (7 replies)
  69. [SOLVED:] dynamic reminder (2 replies)
  70. Multiple User sheet protection and access (4 replies)
  71. Need data from another ss (6 replies)
  72. Auto Save (13 replies)
  73. [SOLVED:] Loop problem (7 replies)
  74. misbehaving DirectPrecedents (9 replies)
  75. Solved: add data in one cell based on condition (6 replies)
  76. Solved: function help (11 replies)
  77. How to exit loop (7 replies)
  78. Inputbox format (3 replies)
  79. Delete row based on Data in two Columns (3 replies)
  80. Solved: Renaming Worksheet during Copy fails (19 replies)
  81. Solved: Manipulating Activesheet Shapes? (4 replies)
  82. making calculation easier through data organization (3 replies)
  83. Scroll Bar/Control Toolbox/Forms (6 replies)
  84. how to close an excel file from command line? (2 replies)
  85. Solved: highlight same model (3 replies)
  86. Code help: dialogue box to add a toolbar (17 replies)
  87. Autofilter Field (3 replies)
  88. Solved: Delete Certain Columns (2 replies)
  89. automatic run module (7 replies)
  90. Moving data in sequential order (29 replies)
  91. Solved: Msg Box to appear once on opening a WB (4 replies)
  92. Excel sending data to Several E-mails (4 replies)
  93. Solved: Last Used Cell (8 replies)
  94. Solved: Consolidation macro (23 replies)
  95. Call Stack overflow (1 replies)
  96. Watches Window: View what row active? (1 replies)
  97. check cells content before executes macro (5 replies)
  98. data and dates (17 replies)
  99. Which method: Vlookup, InStr, Other? (6 replies)
  100. Fixing Numbers (6 replies)
  101. Solved: Textbox always displays end instead of start (2 replies)
  102. Solved: use formula in VBA for vlookup (33 replies)
  103. Data Validation (2 replies)
  104. [SOLVED:] Putting A Date Into A Cell (9 replies)
  105. Distinguish the xlup and xldown (3 replies)
  106. Solved: Filtering Values and splitting worksheet according to the values (2 replies)
  107. [SOLVED:] Prevent User from moving userform (7 replies)
  108. Populate URL address using VBA (0 replies)
  109. VBA module's name. (2 replies)
  110. InputBox Auto-Complete Function (7 replies)
  111. How to creat Dynamic Text box in term of size (8 replies)
  112. Appel = 10 in Excel spread sheet? (12 replies)
  113. Page subtotal macro combine (0 replies)
  114. Question for the file(s) in the listbox (3 replies)
  115. Watch Window to jump to cell? (2 replies)
  116. Solved: Delete Rows-However keep the first found Row (2 replies)
  117. Solved: Loop through controls on userform (5 replies)
  118. Solved: Calendar value to form (2 replies)
  119. Calling multiple sub procedures fails after 1st Sub! (5 replies)
  120. Drag & Drop TreeView (0 replies)
  121. Solved: two routines under one event, but they don't work? (35 replies)
  122. Monitor the Caps Lock Key (2 replies)
  123. Change properties of a Combobox (1 replies)
  124. Cell formula question (5 replies)
  125. Help: How to change color pallet? (5 replies)
  126. Goto nested if's (7 replies)
  127. Solved: Highlight Duplicates (12 replies)
  128. Solved: Workbook_SheetSelectionChange Event (7 replies)
  129. Solved: Copy Paste using macro involving 6 different workbooks (28 replies)
  130. Instring Replace: Error (26 replies)
  131. Don't show the opening/closing workbooks (4 replies)
  132. Copying from a Dynamic Source! (4 replies)
  133. If your search string isn't found... (1 replies)
  134. including string in string (2 replies)
  135. Changes formula to value- wrong number format (24 replies)
  136. Target Line on Plots (2 replies)
  137. [SOLVED:] Prevent minimize window (11 replies)
  138. [SOLVED:] Truncate and add two text boxes into third (3 replies)
  139. [SOLVED:] Open a workbook & copy data using (3 replies)
  140. Find all instances of a word and return the results in a userfrom - not working (2 replies)
  141. How to identify non-whole number? (7 replies)
  142. [SOLVED:] Working with visible rows (2 replies)
  143. Possible 1-liner (2 replies)
  144. Solved: Onchange event to check a date (12 replies)
  145. Solved: Help w/ Summing Range (3 replies)
  146. Solved: Difference between UDF & sub routine (6 replies)
  147. Compare 4 worksheets in a workbook (0 replies)
  148. Solved: explain formula (3 replies)
  149. Solved: Two instances of the same form? (5 replies)
  150. Delete duplicated rows 2 (8 replies)
  151. Solved: More than 1 Validation in Single cell (11 replies)
  152. [SOLVED:] Change event in range selection (2 replies)
  153. Solved: Activate sheet after add/sort sheet executed (13 replies)
  154. Solved: How to copy data from one sheet to another (4 replies)
  155. Solved: Cannot Open The Excel File (6 replies)
  156. Solved: Tool to check VBA code (2 replies)
  157. Disabling worning message while closing a workbook. (3 replies)
  158. For-Next Loop Help (14 replies)
  159. Solved: Search for Missing Module/Code? (34 replies)
  160. Opening an Access Form via Excel (1 replies)
  161. ASCii code to allow a space (11 replies)
  162. Macro on Window Activation (8 replies)
  163. Solved: Is there a way to have code trigger an event when trying to save or print? (34 replies)
  164. Sorting producing wrong result (4 replies)
  165. Solved: Extract number of digits/characters of a variable (15 replies)
  166. Problems in calculation of Means, Max, Min in VBA (9 replies)
  167. Solved: Populate UserForm TextBox based on Worksheet Lookup (7 replies)
  168. Solved: Prohibit or restrict copy (7 replies)
  169. Solved: Nomenclature for referencing named cells in .Formula Code (7 replies)
  170. Solved: Migrating frm Excel 2003 to 2007 (4 replies)
  171. Solved: Delete duplicated rows (7 replies)
  172. How to Give Upper & Lower Limits to a Plot? (2 replies)
  173. [SOLVED:] Linking Again? (16 replies)
  174. Dynamic Plotting (1 replies)
  175. Solved: populate combobox problem (4 replies)
  176. Problem using arbitrary column length in a user defined function (9 replies)
  177. Sort data and past into new sheet (1 replies)
  178. Dummy post so I can creat4e an attachement (2 replies)
  179. [SOLVED:] Automatic close and save (7 replies)
  180. Adding sheets to summary (15 replies)
  181. Solved: Help with Lookup Function (6 replies)
  182. Solved: Populate Column based on contents of range (3 replies)
  183. VBA obfuscate data & find cell (1 replies)
  184. Solved: IsError Function (3 replies)
  185. Problem in the Range Row index (4 replies)
  186. Solved: delete columns with an array collection (4 replies)
  187. Print Setup via VBA (7 replies)
  188. Problem of open all file(s) in the listbox (2 replies)
  189. Counting Multiple Criteria (12 replies)
  190. Playing w/ Arrays (13 replies)
  191. I want to change the color of some letters, but it does't work (4 replies)
  192. Solved: Conditional formatting (6 replies)
  193. [SOLVED:] Vlookup worksheet formula error: sub or function not defined? (8 replies)
  194. Making URLS Hyperlinks (4 replies)
  195. Diaplay text in a cell (8 replies)
  196. [SLEEPER:] Loop Comparison Theory Discussion: For.Nxt vs. For Each (6 replies)
  197. Extract Text (8 replies)
  198. Solved: Hyperlink Address (4 replies)
  199. Transfer the data from the multiple files into 1 worksheets (7 replies)
  200. Solved: Remove Formula (5 replies)
  201. VBA to EXE (3 replies)
  202. inporting external data (4 replies)
  203. delete rows based upon external list (2 replies)
  204. Multi-Delete Function Problem in ListBox1 (11 replies)
  205. Solved: Amend cell in row based on value in first cell (4 replies)
  206. Solved: removing spaces (5 replies)
  207. Solved: Message box Format?? (6 replies)
  208. Version clash (7 replies)
  209. [SOLVED:] Excel 2007 ExportAsFixedFormat (8 replies)
  210. Creating charts automaticaly in Excel (7 replies)
  211. Solved: Prompt to save on close (askes if already saved?) (24 replies)
  212. Solved: Copying Workbooks without disrupting the original (1 replies)
  213. Row entry without keeping any row blank (2 replies)
  214. Solved: Data Validation Code To Force Prior Cell Entry (2 replies)
  215. Hide Rows based if column I = 0, then set print area from row 80 to everything visibl (2 replies)
  216. Create Summary Sheet (1 replies)
  217. Excel Lists (6 replies)
  218. 180 Day Calendar (24 replies)
  219. Solved: Sloved:Why GetOpenFilename not working (9 replies)
  220. Need help setting tab orders (28 replies)
  221. Show sheet based on serial number (4 replies)
  222. Searching a range (1 replies)
  223. Solved: clear cells if, like reset (15 replies)
  224. Union Query in VBA (12 replies)
  225. Macro - Pivot Tables (7 replies)
  226. Calculations between Textbox values on Form (2 replies)
  227. Solved: Looping required (2 replies)
  228. Seek help to highlight number. (55 replies)
  229. Newbie help: advanced table manipulation (10 replies)
  230. Auditing in Excel (4 replies)
  231. Solved: Paste Special,Text question (3 replies)
  232. Solved: "Tagging" a Cell (7 replies)
  233. CellColor Macro Not Working (13 replies)
  234. Publish Selection to Web (1 replies)
  235. Hide rows based on cell in row (3 replies)
  236. Prevent VBA generated charts from refreshing (3 replies)
  237. Solved: word wrap or new line (2 replies)
  238. Find Method To Find 2nd Occurence (9 replies)
  239. Solved: Question on sheet names and Copy (3 replies)
  240. Row and Column Numbers in VBA (8 replies)
  241. Solved: Help with array formula (9 replies)
  242. Last Date Used: (3 replies)
  243. print multiple sheets based on user choices (17 replies)
  244. Help:Just some clarification... (4 replies)
  245. Disabling the "Unsafe ActiveX controls" promt in excel (3 replies)
  246. VBA Help in books (3 replies)
  247. How to change sheet name at close excel workbook (17 replies)
  248. Using spinner in a protected sheet (2 replies)
  249. Solved: Hide column on selection change (14 replies)
  250. removing duplicates (4 replies)