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:] Proper case question (5 replies)
  2. [SOLVED:] Pasting Links (5 replies)
  3. [SOLVED:] Remove module from closed workbook (2 replies)
  4. [SOLVED:] Something better than IF(OR (9 replies)
  5. Sleeper: UserForms help (5 replies)
  6. [SOLVED:] Advanced Filter with duplicate deletions (10 replies)
  7. Sleeper: Summing & average by numberformat (3 replies)
  8. [SOLVED:] Freeze Pane (8 replies)
  9. Sleeper: Return a value if the selction is blank (1 replies)
  10. Sleeper: Customize KB Code to Delete Rows (2 replies)
  11. Sleeper: Cell reference for Duplicates (2 replies)
  12. Sleeper: Using VBA to count documents within a folder (3 replies)
  13. [SOLVED:] Fill ascending numbers (5 replies)
  14. [SOLVED:] Summing based on data range (7 replies)
  15. [SOLVED:] increasing strings or adding strings (8 replies)
  16. [SOLVED:] Distinguishing Between FALSE and 0 (8 replies)
  17. Sleeper: Change text to upper case after specified symbols (1 replies)
  18. Sleeper: Concetenate with bold letter for one line (11 replies)
  19. [SOLVED:] Effect of "Else:" (6 replies)
  20. Sleeper: Summing based on numberformat (20 replies)
  21. Sleeper: Export to text files (23 replies)
  22. Sleeper: Macro Code for Save but no Dialog Boxes (5 replies)
  23. [SOLVED:] Copy from one location and split to two locations (4 replies)
  24. Sleeper: Aggregated charts (1 replies)
  25. Hyperlinking to an Adobe PDF file? (1 replies)
  26. Sleeper: Machine configuration for Excel VBA (1 replies)
  27. [SOLVED:] highlighting the last row (1 replies)
  28. Sleeper: Populating Ranges (10 replies)
  29. [SOLVED:] Putting data where you want it!! (3 replies)
  30. [SOLVED:] Excel - how can I fill a column with determinated values? (4 replies)
  31. Sleeper: Load Folder Content in Single Column List Box (40 replies)
  32. Sleeper: FEM Solution using Excel/VBA (2 replies)
  33. Sleeper: Adding a character to a defined name??? (4 replies)
  34. [SOLVED:] Linked Spreadsheet (3 replies)
  35. [SOLVED:] Auto open folder and click button help (6 replies)
  36. [SOLVED:] About Subtract Function (13 replies)
  37. [SOLVED:] What's with this "Run time Error 1004?" (2 replies)
  38. [SOLVED:] Two Dynamic Named Range Copy/Paste (11 replies)
  39. [SOLVED:] Activating a pop up calendar by clicking in a cell (5 replies)
  40. [SOLVED:] Clear Cells Except First Row (8 replies)
  41. [SOLVED:] Read Each Row Output Text File (6 replies)
  42. Sleeper: Sub & Function (6 replies)
  43. [SOLVED:] List Box - Row Source (22 replies)
  44. [SOLVED:] Print all sheets (8 replies)
  45. [SOLVED:] Formula wont copy down correctly (3 replies)
  46. [SOLVED:] Mapping old to new with VBA (10 replies)
  47. Copy data from one file to another in Excel (2 replies)
  48. Sleeper: Copy columns to new sheets (4 replies)
  49. [SOLVED:] Unprotect cell (4 replies)
  50. [SOLVED:] Validation bugbears (6 replies)
  51. Sleeper: How could I fill automatically a column using VBA? (1 replies)
  52. Sleeper: Enter Data In Worksheet & Delete Empty Rows (4 replies)
  53. [SOLVED:] Finding selected optionbutton on a userform (8 replies)
  54. [SOLVED:] my firefiter (3 replies)
  55. [SOLVED:] Differrences between Rnd and Randomize (14 replies)
  56. [SOLVED:] Eliminating blinking cursor in UserForm Text box (2 replies)
  57. [SOLVED:] A loop question & write texts (13 replies)
  58. Sleeper: Macro's and Dates (7 replies)
  59. [SOLVED:] A Looping Question (2 replies)
  60. [SOLVED:] Rounding up question (3 replies)
  61. [SOLVED:] Grid Box (4 replies)
  62. [SOLVED:] Assign Macro to Button on Spreadsheet (4 replies)
  63. [SOLVED:] Call Function (4 replies)
  64. [SOLVED:] Output GUI Components' Names of Form (4 replies)
  65. [SOLVED:] Cell formating (5 replies)
  66. [SOLVED:] Change Font of UserForm1 (16 replies)
  67. [SOLVED:] Pitfalls of Earlier versions of Excel (3 replies)
  68. [SOLVED:] Enable CTRL+HOME, CTRL+END (7 replies)
  69. [SOLVED:] Crazy Request (4 replies)
  70. Sleeper: Conditional rows deleting (2 replies)
  71. [SOLVED:] Automatically rearrange columns (28 replies)
  72. [SLEEPER:] Adding a sheet (2 replies)
  73. Sleeper: Clear cell ranges if reference cell changes (8 replies)
  74. [SOLVED:] Pivot table (data range). (3 replies)
  75. Solved: Placing cursor in a specific textbox when form opens (26 replies)
  76. [SOLVED:] How to do sorting by values? (6 replies)
  77. Sleeper: Dynamically write data in cell (1 replies)
  78. [SOLVED:] Run Outlook from Excel (3 replies)
  79. Sleeper: Copy all files in a directory (3 replies)
  80. [SOLVED:] Question About the "Resume" Statement (3 replies)
  81. Sleeper: Conditional formats to make things easier on the eye (6 replies)
  82. Sleeper: Add unprotected rows to protected sheet (12 replies)
  83. Sleeper: Open web browser with specific address (3 replies)
  84. Sleeper: Copy all sheets (filter some rows) (2 replies)
  85. Sleeper: Problem in coding (5 replies)
  86. [SOLVED:] Compare 2 sheets different sizes (14 replies)
  87. Sleeper: File opens as read only (9 replies)
  88. [SOLVED:] Application.ScreenUpdating (26 replies)
  89. [SOLVED:] Combobox help (2 replies)
  90. [SOLVED:] Compile error: vba VIA vba (5 replies)
  91. [SOLVED:] Program to Identify duplicate entries (22 replies)
  92. Sleeper: Checking that a document in Word was printed from Excel? (3 replies)
  93. [SOLVED:] Advanced Filter Criteria Non Adjacent Cells (6 replies)
  94. [SOLVED:] Sorting macro (3 replies)
  95. [SOLVED:] Decimal Type ? (11 replies)
  96. [SOLVED:] Opening Text files (3 replies)
  97. [SOLVED:] CD-ROM - List File Attributes of Directory and Subdirectores (like brettdj's KB) (17 replies)
  98. Sleeper: Using vba variable to create data series for pi and bar graphs (4 replies)
  99. Sleeper: Display correct toolbar icon on starting excel application program (2 replies)
  100. Sleeper: Pivot table summarizing by sum (2 replies)
  101. [SOLVED:] selecting cells (8 replies)
  102. [SOLVED:] Tab Column in VBA Form (6 replies)
  103. [SOLVED:] Copy from multiple sheets paste to new Sheet (7 replies)
  104. Sleeper: Help with macro please (13 replies)
  105. [SOLVED:] Chk sheet names of 2 wrkbk & delete if not matching (2 replies)
  106. Sleeper: TicTacToe Smarts (4 replies)
  107. Sleeper: Adjustment to Hyperlink KB Code (0 replies)
  108. [SOLVED:] Convert Decimal To Binary (21 replies)
  109. Sleeper: Sorting sheets by month from different workbooks into one (3 replies)
  110. [SOLVED:] Need help with date manipulation (6 replies)
  111. Sleeper: Function defintion in comment (2 replies)
  112. [SOLVED:] How to cut one sheet's values and paste it in other sheet? (12 replies)
  113. [SOLVED:] How to insert rows based on different values (6 replies)
  114. [SOLVED:] Problem with "On Error" Not Trapping (8 replies)
  115. [SOLVED:] Formatting MsgBox (7 replies)
  116. [SOLVED:] Adding Time written with Text (11 replies)
  117. Sleeper: Print to different printer based on cell value (10 replies)
  118. [SOLVED:] Automatic launch of a MsgBox (5 replies)
  119. [SOLVED:] Get all sheet names in comboBox of activeworkbook and export when selected (4 replies)
  120. [SOLVED:] How to force the user to make entry(ies) in a specific worksheet before continuing? (11 replies)
  121. Sleeper: User defined range and sheet (2 replies)
  122. [SOLVED:] How to install Calendar Control 11.0 (3 replies)
  123. Sleeper: Sort worksheet by suffix (3 replies)
  124. Sleeper: Accessing an Excel Module (5 replies)
  125. Solved: Conditional Formatting (8 replies)
  126. [SOLVED:] Using Lookup command I think (5 replies)
  127. [SOLVED:] The equivalent for CInt for creating a long (4 replies)
  128. Sleeper: Copy and paste (3 replies)
  129. Sleeper: Word object in Excel (1 replies)
  130. [SOLVED:] VBA Naming Convention; Parameter; ByVal & ByRef; (7 replies)
  131. [SOLVED:] Send Link? (3 replies)
  132. Sleeper: Insert Object (1 replies)
  133. [SOLVED:] Document workbook Properties (7 replies)
  134. Sleeper: Clean and speed up code. (1 replies)
  135. [SOLVED:] Boolean true (6 replies)
  136. Sleeper: Search string 2 (3 replies)
  137. Sleeper: Look right until there are no more cells with content (3 replies)
  138. Sleeper: Input Box asks for input twice! (4 replies)
  139. Sleeper: Filter ListBox Items (6 replies)
  140. Sleeper: Multiple Charts with dynamic ranges (3 replies)
  141. Sleeper: Easy Cell Reference - "Guide" Lines (3 replies)
  142. [SOLVED:] Array Function? (3 replies)
  143. Sleeper: Getting one cell to stay on top of all sheets (3 replies)
  144. [SOLVED:] Help with Lookup (2 replies)
  145. Sleeper: Print Log (6 replies)
  146. [SOLVED:] Pass value to sub in .xla (3 replies)
  147. Sleeper: Dependent lists in order to restrict choices (5 replies)
  148. Sleeper: Close Workbook and via Close Excel (2 replies)
  149. [SOLVED:] Long Loop Time (7 replies)
  150. Sleeper: Multiple Value List Box (13 replies)
  151. [SOLVED:] Sort Alphabetically List Box (3 replies)
  152. Sleeper: Using TextBoxes for Numbers (8 replies)
  153. [SOLVED:] Print Macro (5 replies)
  154. Sleeper: Trigger event when rows are inserted or deleted (5 replies)
  155. [SOLVED:] find a string (4 replies)
  156. [SOLVED:] Range Dynamic Query (7 replies)
  157. [SOLVED:] On error behaviour (2 replies)
  158. [SOLVED:] Populate ListBox from Excel Column (11 replies)
  159. [SOLVED:] Progress Bar / Status Bar (5 replies)
  160. Check for Blank Cells in Column (13 replies)
  161. Sleeper: The sound played upon displaying a msgbox (2 replies)
  162. [SOLVED:] DatePart (Format Standard Date Time) (2 replies)
  163. [SOLVED:] Why is this text and not number? (2 replies)
  164. [SOLVED:] Help linking page (5 replies)
  165. Sleeper: Security issue (6 replies)
  166. [SOLVED:] Home key action (2 replies)
  167. [SOLVED:] Subtotals (0 replies)
  168. [SOLVED:] Checking Checkbox values (8 replies)
  169. [SOLVED:] Passing Variables through sheets (2 replies)
  170. [SOLVED:] am I doing this right ? del sheet if there, else... (11 replies)
  171. [SOLVED:] Macro sends sheets to printer in ascending order, but they're not printed so. (2 replies)
  172. Sleeper: Can not open excel ss (2 replies)
  173. [SOLVED:] Lock Column or Rows (Editing restriction) (2 replies)
  174. [SOLVED:] Forcing Hyperlinks to Open in a new Window (3 replies)
  175. [SOLVED:] VBA: Put Day in Footer/Header (2 replies)
  176. Sleeper: Help with copy import script (4 replies)
  177. [SOLVED:] Help finding the last cell in a range. (8 replies)
  178. [SOLVED:] Add to a stock symbol (3 replies)
  179. [SOLVED:] Font.Size (1 replies)
  180. External Data Help (1 replies)
  181. Sleeper: Transfer to a Different Macro When Stepping Thru Execution (2 replies)
  182. [SOLVED:] Data Validation List (2 replies)
  183. [SOLVED:] Clear cells based on length of cell (6 replies)
  184. Sleeper: Printing to PDF (3 replies)
  185. [SOLVED:] How to link to a file one folder up. (1 replies)
  186. [SOLVED:] need help with VB script, error on cancel.. (2 replies)
  187. [SOLVED:] Worksheet VBA naming (15 replies)
  188. Sleeper: Format summary lines (1 replies)
  189. [SOLVED:] Need Help with a Change Event (7 replies)
  190. Sleeper: Unable to focus on another sheet (4 replies)
  191. [SOLVED:] VBA Like statement (6 replies)
  192. [SOLVED:] colour From LEFT to RIGHT of a cell starting from where a COLON is found (1 replies)
  193. Sleeper: Excel bombs out when I try and Save the workbook (5 replies)
  194. Sleeper: Pivot table naming causing error (2 replies)
  195. [SOLVED:] Help with case statement (16 replies)
  196. [SOLVED:] Select - deselect chkboxes (8 replies)
  197. [SOLVED:] Check sheet names and display MsgBox (8 replies)
  198. Sleeper: Opening Template (1 replies)
  199. [SOLVED:] Test cells for scientific formatting (12 replies)
  200. Sleeper: Loop through range to copy/paste hyperlink (25 replies)
  201. [SOLVED:] Determing Array Size (3 replies)
  202. [SOLVED:] Can't Create New Sheet by "Running" Macro (19 replies)
  203. Solved: Defined Name Errors...Please Interpret (2 replies)
  204. [SOLVED:] Conditionally Color Drop-down Choices (6 replies)
  205. [SOLVED:] Open path given in txtbox1 (5 replies)
  206. [SOLVED:] Find everything to left of ":" (2 replies)
  207. [SOLVED:] Keyboard shortcut to skip through sheets in a open MS Excel workbook (1 replies)
  208. [SOLVED:] Selection.Font.Bold (12 replies)
  209. [SOLVED:] Concantonate Cells (2 replies)
  210. [SOLVED:] Check if the text is ALL UpperCase (UCase) (1 replies)
  211. Solved: cell formatting row wise (3 replies)
  212. [SOLVED:] UDF's (18 replies)
  213. [SOLVED:] Can VBA Statements Be Stacked? (10 replies)
  214. Sleeper: Excel formula (1 replies)
  215. [SOLVED:] Clearing Cond. Fmts from a Range (3 replies)
  216. [SOLVED:] Is there a Scroll Event? (6 replies)
  217. [SOLVED:] Interior.ColorIndex (22 replies)
  218. [SOLVED:] Remove any formatting from cells (5 replies)
  219. Sleeper: Making this code more dynamic (8 replies)
  220. [SOLVED:] Is there a way to retrieve the product key. (2 replies)
  221. [SOLVED:] Macro for Find & Replace (16 replies)
  222. [SOLVED:] Insert VBA code in new Workbook via VBA (8 replies)
  223. [SOLVED:] Chart Limitations (Plotting from Arrays) (4 replies)
  224. [SOLVED:] Click AutoShape and close the workbook w/ option to save. (5 replies)
  225. A (fiendly) Challenge to brettdj (20 replies)
  226. Sleeper: Simple Hyperlink Question (4 replies)
  227. [SOLVED:] Help combine workbooks into 1 (7 replies)
  228. Sleeper: Dates and times (1 replies)
  229. Sleeper: Auto formatting (3 replies)
  230. [SOLVED:] Header (2 replies)
  231. Sleeper: Launching xls via shortcut duplicates macro prompt (11 replies)
  232. [SOLVED:] Problem with simple loop! (16 replies)
  233. Sleeper: Move Cursor Of Second Sheet As Per The First Sheet (5 replies)
  234. Sleeper: Converting Hrs:Mins to general/currency value (1 replies)
  235. [SOLVED:] Border around a range of cells (1 replies)
  236. [SOLVED:] Hiding Rows with a special column? (Please see attached.) (2 replies)
  237. Sleeper: Select and delete (3 replies)
  238. [SOLVED:] Clear contents of cells (34 replies)
  239. sort and create new sheets from CSV data (13 replies)
  240. [SOLVED:] Multidimensional Array Initialization (4 replies)
  241. [SOLVED:] Comparing text to cells but only partial match (2 replies)
  242. [SOLVED:] Transposing Data (9 replies)
  243. [SOLVED:] Copying cells when switching to excel (2 replies)
  244. [SOLVED:] Adding a Column Total to a Printed Report (4 replies)
  245. [SOLVED:] Populating csv. file with text values (4 replies)
  246. [SOLVED:] Total in user form (22 replies)
  247. Sleeper: Read-Only ... Shared Access ... etc Problem (0 replies)
  248. Sleeper: The difference between Hidden and VeryHidden (13 replies)
  249. [SOLVED:] Select given month in various years (5 replies)
  250. [SOLVED:] Cant determine a cells contents (15 replies)