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. [SOLVED:] Test cells for scientific formatting (12 replies)
  2. Sleeper: Loop through range to copy/paste hyperlink (25 replies)
  3. [SOLVED:] Determing Array Size (3 replies)
  4. [SOLVED:] Can't Create New Sheet by "Running" Macro (19 replies)
  5. Solved: Defined Name Errors...Please Interpret (2 replies)
  6. [SOLVED:] Conditionally Color Drop-down Choices (6 replies)
  7. [SOLVED:] Open path given in txtbox1 (5 replies)
  8. [SOLVED:] Find everything to left of ":" (2 replies)
  9. [SOLVED:] Keyboard shortcut to skip through sheets in a open MS Excel workbook (1 replies)
  10. [SOLVED:] Selection.Font.Bold (12 replies)
  11. [SOLVED:] Concantonate Cells (2 replies)
  12. [SOLVED:] Check if the text is ALL UpperCase (UCase) (1 replies)
  13. Solved: cell formatting row wise (3 replies)
  14. [SOLVED:] UDF's (18 replies)
  15. [SOLVED:] Can VBA Statements Be Stacked? (10 replies)
  16. Sleeper: Excel formula (1 replies)
  17. [SOLVED:] Clearing Cond. Fmts from a Range (3 replies)
  18. [SOLVED:] Is there a Scroll Event? (6 replies)
  19. [SOLVED:] Interior.ColorIndex (22 replies)
  20. [SOLVED:] Remove any formatting from cells (5 replies)
  21. Sleeper: Making this code more dynamic (8 replies)
  22. [SOLVED:] Is there a way to retrieve the product key. (2 replies)
  23. [SOLVED:] Macro for Find & Replace (16 replies)
  24. [SOLVED:] Insert VBA code in new Workbook via VBA (8 replies)
  25. [SOLVED:] Chart Limitations (Plotting from Arrays) (4 replies)
  26. [SOLVED:] Click AutoShape and close the workbook w/ option to save. (5 replies)
  27. A (fiendly) Challenge to brettdj (20 replies)
  28. Sleeper: Simple Hyperlink Question (4 replies)
  29. [SOLVED:] Help combine workbooks into 1 (7 replies)
  30. Sleeper: Dates and times (1 replies)
  31. Sleeper: Auto formatting (3 replies)
  32. [SOLVED:] Header (2 replies)
  33. Sleeper: Launching xls via shortcut duplicates macro prompt (11 replies)
  34. [SOLVED:] Problem with simple loop! (16 replies)
  35. Sleeper: Move Cursor Of Second Sheet As Per The First Sheet (5 replies)
  36. Sleeper: Converting Hrs:Mins to general/currency value (1 replies)
  37. [SOLVED:] Border around a range of cells (1 replies)
  38. [SOLVED:] Hiding Rows with a special column? (Please see attached.) (2 replies)
  39. Sleeper: Select and delete (3 replies)
  40. [SOLVED:] Clear contents of cells (34 replies)
  41. sort and create new sheets from CSV data (13 replies)
  42. [SOLVED:] Multidimensional Array Initialization (4 replies)
  43. [SOLVED:] Comparing text to cells but only partial match (2 replies)
  44. [SOLVED:] Transposing Data (9 replies)
  45. [SOLVED:] Copying cells when switching to excel (2 replies)
  46. [SOLVED:] Adding a Column Total to a Printed Report (4 replies)
  47. [SOLVED:] Populating csv. file with text values (4 replies)
  48. [SOLVED:] Total in user form (22 replies)
  49. Sleeper: Read-Only ... Shared Access ... etc Problem (0 replies)
  50. Sleeper: The difference between Hidden and VeryHidden (13 replies)
  51. [SOLVED:] Select given month in various years (5 replies)
  52. [SOLVED:] Cant determine a cells contents (15 replies)
  53. GetOpenFilename multiselect (8 replies)
  54. [SOLVED:] Shared workbook (7 replies)
  55. [SOLVED:] Another sumif - sumproduct delima (2 replies)
  56. Sleeper: Could not find installable ISAM (2 replies)
  57. [SOLVED:] Problem Formatting Date for Display (7 replies)
  58. [SOLVED:] How to NOT Plot a Cell with Formula = Blank (3 replies)
  59. Sleeper: Help with optimizing formulas and workarounds... (4 replies)
  60. Sleeper: Detect and change column width (1 replies)
  61. [SOLVED:] Get sheets name (4 replies)
  62. Solved: display progress bar (20 replies)
  63. [SOLVED:] Delete all non-matching sheet names (3 replies)
  64. [SOLVED:] John Walkenbach's FaceIDs Display (4 replies)
  65. Sleeper: Shuffling Data onto a new Worksheet (6 replies)
  66. [SOLVED:] Get server name (11 replies)
  67. Sleeper: Copy a range of cells in a for loop (4 replies)
  68. Solved: write cell address in text file through vba (4 replies)
  69. [SOLVED:] open notepad, select all, copy, paste in excel (6 replies)
  70. Sleeper: How to create a sort instruction (1 replies)
  71. [SOLVED:] Excel ** (7 replies)
  72. [SOLVED:] A harder Hyperlink question. (7 replies)
  73. [SOLVED:] Summarize data. VBA CODE (10 replies)
  74. Sleeper: Excel-Outlook-Access Link (5 replies)
  75. [SOLVED:] Can you hyperlink to a hidden sheet? (4 replies)
  76. [SOLVED:] Hyperlink on sheet 1 to sheet 2 in same workbook? (3 replies)
  77. [SOLVED:] Add new record in spreadsheet (1 replies)
  78. [SOLVED:] VBA Code Library (this site) (5 replies)
  79. [SOLVED:] Remove Macros from a workbook with VBA (4 replies)
  80. [SOLVED:] Overflow error 6 (15 replies)
  81. [SOLVED:] Arrange sheet names in sequence (2 replies)
  82. Sleeper: Page footer: page one of x, sub page 1 of 2 (4 replies)
  83. [SOLVED:] Count how many cells have been merged to make one cell. (1 replies)
  84. [SOLVED:] Problem with "ReDim Preserve" (7 replies)
  85. [SOLVED:] Saving as .csv (6 replies)
  86. [SOLVED:] Count the number of cells in a row that are not empty (3 replies)
  87. [SOLVED:] How to fix last row in a worksheet (12 replies)
  88. [SOLVED:] Open UserForm from an Add-In (4 replies)
  89. [SOLVED:] Find the last used column (13 replies)
  90. [SOLVED:] Factorial sub (3 replies)
  91. [SOLVED:] Autohiding Empty Rows. VBA code (8 replies)
  92. [SOLVED:] Hiding rows if the linked cells are unused (10 replies)
  93. Sleeper: ChartSheet Generates Bogus External Reference (1 replies)
  94. [SOLVED:] disable/enable controls (3 replies)
  95. Variable string for cell reference (4 replies)
  96. Solved: Counting sort for multi-dimensional arrays? (20 replies)
  97. Sleeper: Can't interface vb to excel with autosave on (0 replies)
  98. Sleeper: Excel and mysql (1 replies)
  99. [SOLVED:] Compare Sheet1 with Sheet2 (21 replies)
  100. Solved: delete all images from spreadsheet (4 replies)
  101. copying to XML from excel (1 replies)
  102. [SOLVED:] Visual Basic Editor only saves the modules/project sometimes (25 replies)
  103. Sleeper: Copy all workbook contents into a new one (10 replies)
  104. [SOLVED:] Rename sheets (15 replies)
  105. Sleeper: Problems with Solver.XLA (3 replies)
  106. Sleeper: Excel cannot complete this task with available resources. (2 replies)
  107. [SOLVED:] Populate a Listbox from an Access database (27 replies)
  108. Sleeper: Workbook and Forms (3 replies)
  109. [SOLVED:] Search that loops through inputs (8 replies)
  110. [SOLVED:] EXCEL to ACCESS (5 replies)
  111. [SOLVED:] Open next file if not found the one to open (23 replies)
  112. Sleeper: Compare 2 workbook (1 replies)
  113. [SOLVED:] Combining Excel Chart Types (8 replies)
  114. [SOLVED:] Failure Using Logical Operators in Cond. Fmting Formulas (20 replies)
  115. Sleeper: File Exists issue (2 replies)
  116. [SOLVED:] Help to complete a code (30 replies)
  117. [SOLVED:] Help needed with counting formula (3 replies)
  118. [SOLVED:] Change color and text of an Autoshape (3 replies)
  119. Sleeper: Stumped.....Phase calculator (4 replies)
  120. [SLEEPER:] Do Not Update Links - On WB Open (2 replies)
  121. Sleeper: Header Drop Down Box (11 replies)
  122. [SOLVED:] Repeat Rows at the Top (1 replies)
  123. [SOLVED:] Parameters (5 replies)
  124. [SOLVED:] Rows Repeat at Top (1 replies)
  125. Sleeper: Discount Cash Flow (8 replies)
  126. Sleeper: Linking protect to enable=false (6 replies)
  127. [SOLVED:] Check Month and Day (3 replies)
  128. Sleeper: How to delete the 'grand total value' in a pivot table? (1 replies)
  129. [SOLVED:] Delete a sheet IF sheetname doesnt contain the string 'rules' (3 replies)
  130. [SOLVED:] Check the creation date of a file and delete a file when older then... (5 replies)
  131. Solved: Embedded swf (7 replies)
  132. Sleeper : Function SQRT, SUM... (0 replies)
  133. [SOLVED:] Code to organize sheets skipping hidden or specific ones (2 replies)
  134. [SOLVED:] Line break within a cell (4 replies)
  135. [SOLVED:] Loop thru worksheets and run macro (19 replies)
  136. [SOLVED:] Run time error 91 (5 replies)
  137. [SOLVED:] Solved: Get file location in textbook upon clicking button (2 replies)
  138. Sleeper: How to obtain the value of the last row? (10 replies)
  139. [SOLVED:] Delete characters if matching (4 replies)
  140. [SOLVED:] Showing a dialog box during saving (3 replies)
  141. [SOLVED:] Prompting to Save (12 replies)
  142. [SOLVED:] Auto update Excel Charts (3 replies)
  143. Sleeper: VBA - "group by" function (4 replies)
  144. [SOLVED:] Divide a value by a cell (6 replies)
  145. [SOLVED:] Values Adding (6 replies)
  146. Sleeper: 2 Projects (3 replies)
  147. [SOLVED:] Testing multipe counters (20 replies)
  148. Sleeper: Compare Actual vs System (1 replies)
  149. Sleeper: SQUARE of the difference from two columns (1 replies)
  150. [SOLVED:] Counting like cells to determine coverage (1 replies)
  151. Sleeper: Two comboboxes update puzzle (1 replies)
  152. [SOLVED:] Sorting drop down box output (4 replies)
  153. Sleeper: How to change automatically the format of a range of cells? (6 replies)
  154. Sleeper: Cell References & Links - Please help (8 replies)
  155. [SOLVED:] Metmorphisis of a Variable Into an Array (11 replies)
  156. [SOLVED:] Can't Find Shortcut Notation Using Prefixes (7 replies)
  157. Solved: Add an item for MACROS to the Excel menu bar (22 replies)
  158. [SOLVED:] Advanced Filter (14 replies)
  159. Sleeper: UserForm Error from Thin Air (4 replies)
  160. Sleeper: VBA - sort data (7 replies)
  161. [SOLVED:] Working with "time" (10 replies)
  162. Sleeper: How to sort my data using VBA? (1 replies)
  163. [SOLVED:] Range Address (24 replies)
  164. [SOLVED:] Assigning a Macro to a VBE Toolbar Button (4 replies)
  165. [SOLVED:] Function average using VBA (12 replies)
  166. [SOLVED:] Conditional Format Cells (47 replies)
  167. Sleeper: Problem Pivot table &VBA (2 replies)
  168. [SOLVED:] Balance Forward Method (6 replies)
  169. [SLEEPER:] Extract file using vba macro (2 replies)
  170. [SOLVED:] Protect sheet on idle (3 replies)
  171. [SLEEPER:] Looking for guidance on saving file (2 replies)
  172. [SOLVED:] The Quest For How to Insert a Line in a Macro (4 replies)
  173. Sleeper: VBA problem activate window inside a window (4 replies)
  174. [SLEEPER:] Input values in appropiate textbox on first userform (2 replies)
  175. [SOLVED:] Return path (3 replies)
  176. [SOLVED:] Values Adding (4 replies)
  177. [SOLVED:] Range all sheets to cell "A1" before closing file (3 replies)
  178. [SLEEPER:] Display data in UserForm (4 replies)
  179. [SOLVED:] VBA code: FILTER DATA (7 replies)
  180. [SOLVED:] Insert lines in two or more sheets at the same time (2 replies)
  181. [SOLVED:] Automatically change Lowercase to Uppercase (20 replies)
  182. Disable Password/Login Request on Web Query (2 replies)
  183. Range Names : Good or Bad programming practice? (121 replies)
  184. [SLEEPER:] Range Names: Good or Bad? (5 replies)
  185. [SOLVED:] how to move a selection area? (5 replies)
  186. [SOLVED:] Formula to match non case sensitive text (7 replies)
  187. [SOLVED:] Is it possible to display the highlight text in VBE (16 replies)
  188. [SOLVED:] Excel / Word / E-mail (10 replies)
  189. [SLEEPER:] How Can I create a Pivot table using VBA? (1 replies)
  190. Disable Insert Worksheet Command from toolbar (10 replies)
  191. [SOLVED:] Any Extra Execution Time? (4 replies)
  192. [SOLVED:] Help with excel macro (13 replies)
  193. [SOLVED:] Determining "Local" Directory (2 replies)
  194. [SOLVED:] Blank Cells with Formula (2 replies)
  195. [SLEEPER:] Blank Cells with Formula (1 replies)
  196. Sleeper: Changing Print Range with Protection (2 replies)
  197. [SOLVED:] Counting Cells (4 replies)
  198. [SOLVED:] Compare two columns to two other columns (3 replies)
  199. [SLEEPER:] Updating Links from Files with Passwords (3 replies)
  200. [SLEEPER:] Create a Fixed Table (1 replies)
  201. [SLEEPER:] Condional format (3 replies)
  202. [SLEEPER:] Memory Issue (3 replies)
  203. [SLEEPER:] Printing in VBA (1 replies)
  204. [SOLVED:] Div/0! Question (2 replies)
  205. [SOLVED:] Perform a "Find" on 2 criteria on an "or" basis (7 replies)
  206. [SOLVED:] Counter, part II (4 replies)
  207. [SOLVED:] Protecting Page SetUp Properties (3 replies)
  208. Sleeper: Help with Zip Codes (5 replies)
  209. [SOLVED:] Add new line to .txt file (3 replies)
  210. [SOLVED:] Scrolling multiple sheets to the same row (4 replies)
  211. [SOLVED:] Counter (3 replies)
  212. [SOLVED:] Shared Workbook - How can macro work? (2 replies)
  213. [SLEEPER:] Setting VBA Project Password in Code (2 replies)
  214. [SOLVED:] Does knowledge of Visual Basic.NEt help with VBA? (14 replies)
  215. [SLEEPER:] Help with Excel and reflection script (1 replies)
  216. [SOLVED:] Need a macro to change font in unique cells (6 replies)
  217. [SOLVED:] Protect/Unprotect Cells with VBA (4 replies)
  218. [SOLVED:] Fill in data from Search routine (2 replies)
  219. [SLEEPER:] Simple Print Word doc from Excel (4 replies)
  220. Solved: Pls HELP!! w/ email a worksheet (19 replies)
  221. [SOLVED:] Search a worksheet (5 replies)
  222. [SOLVED:] Easy sort question (4 replies)
  223. [SOLVED:] working with named ranges & automated labelling (4 replies)
  224. [SOLVED:] DisplayAlerts (3 replies)
  225. [SOLVED:] Doubt about Hlookup (6 replies)
  226. [SLEEPER:] Hyperlink issue (3 replies)
  227. [SOLVED:] Create a Mailing List from unformatted data (6 replies)
  228. [SOLVED:] Goto a specific part of a list (4 replies)
  229. [SOLVED:] Removing password on excel file (3 replies)
  230. [SOLVED:] Enable/Disable Macro POPUP question (7 replies)
  231. Solved: Naming rows according to data in column A (11 replies)
  232. [SOLVED:] Remove asterisk symbol (3 replies)
  233. [SOLVED:] Drop down list excel 2000 (3 replies)
  234. [SOLVED:] Help with error (3 replies)
  235. [SOLVED:] Sort new record after add (17 replies)
  236. [SOLVED:] deleting rows with zeros (7 replies)
  237. [SOLVED:] Erasing a link (3 replies)
  238. [SLEEPER:] Pivot Table Too Large (1 replies)
  239. [SOLVED:] Insert a value into a cell after a row has been inserted. (5 replies)
  240. [SOLVED:] Loging invoices/quotes (15 replies)
  241. [SLEEPER:] Looking for a data validation-like function (1 replies)
  242. [SLEEPER:] Link updates (1 replies)
  243. VBA question (1 replies)
  244. [SOLVED:] Excel Userform List box question (2 replies)
  245. [SOLVED:] Saving as .csv with parmaeters (5 replies)
  246. [SOLVED:] HLookup without sorted data? (1 replies)
  247. [SOLVED:] Delete Range With Condition (6 replies)
  248. [SOLVED:] Sleeper: Control Range Scanned (1 replies)
  249. [SOLVED:] Tabbing in a user form (4 replies)
  250. [SOLVED:] Simple question about strings? (7 replies)