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. Here's an easy one...MONTH (5 replies)
  2. Send Email to address in previous box (12 replies)
  3. Problems opening files (4 replies)
  4. subtraction (9 replies)
  5. Solved: Object library invalid........ (5 replies)
  6. entire row (3 replies)
  7. Excel Turn Around Time Calculation (13 replies)
  8. Excel VBA - retrieve Sybase TEXT data type (0 replies)
  9. Solved: Modify exiting VBA code for copied the particular sheet from multiple excel files. (5 replies)
  10. Solved: Using data validation to return values (5 replies)
  11. problem with Find() (1 replies)
  12. Find out the minimum interior colorindex in each column (3 replies)
  13. Private Function problem (1 replies)
  14. How to use of Macro to AutoFilter data on a shared workbook? (0 replies)
  15. Solved: countif meet two conditions (2 replies)
  16. Return web site data using Excel and VBA (10 replies)
  17. Data Validation list referencing (2 replies)
  18. combobos rowsource (1 replies)
  19. Solved: Checkbox code? (1 replies)
  20. How to delete expansion buttons??? (3 replies)
  21. Solved: how to do BACK (in workbook between sheets) (5 replies)
  22. WebBrowser in Excel UserForm (0 replies)
  23. Solved: MkDir advice.....please!!! (2 replies)
  24. Solved: How do you eliminate the dropdown arrow in my autofilter code? (5 replies)
  25. Solved: Copy rows from one sheet to another..... (3 replies)
  26. Protection (12 replies)
  27. Solved: Clear The contents of Adjacent Cell (2 replies)
  28. Solved: Conversion (6 replies)
  29. Solved: How to create autofilter code using Textbox Userform? (3 replies)
  30. Paste Results to Spreadsheet (2 replies)
  31. Solved: =IF Formula Help (7 replies)
  32. Sort Question (2 replies)
  33. Exit userform and save changes (1 replies)
  34. Force Excel to Stop Recognizing Numbers (3 replies)
  35. Excel Vba and Access (0 replies)
  36. Solved: ActiveChart Source PlotBy…With Scroll. (2 replies)
  37. Pivot Table Formats (0 replies)
  38. minimising and unminimising ribbons event (0 replies)
  39. Conditional Formatting - Shapes (0 replies)
  40. Solved: Index / Match NA (3 replies)
  41. Solved: If Statement (4 replies)
  42. Shared workbooks and who is using them. (3 replies)
  43. Pivot Table Conditional Formatting (2 replies)
  44. look for value then put them to the SampleSheet (0 replies)
  45. Solved: MROUND Function (2 replies)
  46. Solved: Listbox selection as a parameter in data extraction macro. (3 replies)
  47. [SOLVED:] Sharing Modules (6 replies)
  48. Copy specific cell range from different workbook to one excel sheet (4 replies)
  49. Issue with Listbox on Excel Userform. (4 replies)
  50. Solved: Create 4 cell range to copy (3 replies)
  51. Call value from worksheet (1 replies)
  52. Is it possible to link Excel and Access? (2 replies)
  53. Solved: Merging Sheets (8 replies)
  54. Calling Excel shortcuts from VBA (3 replies)
  55. Find All and Return related Value (9 replies)
  56. hiding ribbons (3 replies)
  57. filesystemobject (1 replies)
  58. Problem with copy data from a closed workbook (5 replies)
  59. Asking the user where to output the macro's results (4 replies)
  60. Compare dates of different years (6 replies)
  61. Getting the file name (7 replies)
  62. Saving a copy of an Excel file without code behined it (3 replies)
  63. Solved: External data problem (1 replies)
  64. Solved: Quite a complicated one...perhaps? (12 replies)
  65. Solved: Limit Scrolling VBA (5 replies)
  66. Solved: VBA Password Protection (4 replies)
  67. cross tab excel refresh (0 replies)
  68. External Data (9 replies)
  69. Solved: Help with my vlookup formula (4 replies)
  70. Solved: Search function VBA (2 replies)
  71. Duplicates and Deletes (6 replies)
  72. Two search category & two search terms (3 replies)
  73. Solved: Search different sheets (3 replies)
  74. VBA - Advanced filter with data Validation (4 replies)
  75. Solved: INDEX/MATCH ...VLOOKUP? (4 replies)
  76. color cells (9 replies)
  77. Solved: Delete a Sub Not needed anymore (12 replies)
  78. VBA to get details of files in a folder (4 replies)
  79. update page footer (4 replies)
  80. Solved: Deleting unwanted worksheets in WB (3 replies)
  81. Solved: Auto populate a column (4 replies)
  82. Solved: Select, Insert & Print Macro (6 replies)
  83. New to forum, need help (1 replies)
  84. formating the calculation result (0 replies)
  85. Solved: Renaming an opened workbook (5 replies)
  86. Worksheet Change event not triggering sub (5 replies)
  87. Solved: Count Cell if it is numeric (3 replies)
  88. Solved: SIMILAR NUMBERS (24 replies)
  89. Improve functionality of table (3 replies)
  90. Solved: Select a particular cell before closing (10 replies)
  91. Solved: Edit/update code in multiple workbooks (14 replies)
  92. Permanently Hide Sheet Tabs (4 replies)
  93. VBA Calendar (9 replies)
  94. VBa Code exist? (2 replies)
  95. School exercise, i'm desperate (8 replies)
  96. Put textfile on desktop (4 replies)
  97. Return Value from UserForm (14 replies)
  98. Textbox help with msgbox (5 replies)
  99. Solved: How Does VBA Handle Multiple Conditions Within an If Statement (11 replies)
  100. repeat rows at bottom of page (1 replies)
  101. Help!!!! (2 replies)
  102. delete all except the last duplicate (3 replies)
  103. Solved: keep cursor in textbox... (6 replies)
  104. Adding code to a worksheet on the fly (2 replies)
  105. Solved: Error "400" in VBA (12 replies)
  106. End If without Block If (4 replies)
  107. Sleeper: Evaluate method & For Loop: which on is faster (2 replies)
  108. Solved: Another Problem (2 replies)
  109. Solved: Convert Monthly to Quarterly using Macro (13 replies)
  110. MsgBox vbYesNo help (8 replies)
  111. Sleeper: Disable "Show sheet tabs" option (1 replies)
  112. Solved: I'm stumped ....please help (4 replies)
  113. Solved: reset picture# in Excel (3 replies)
  114. Parsing Name Help (1 replies)
  115. Solved: Worksheet Menu Bar (6 replies)
  116. Solved: How to Replace Horizontal Tab in Excel (4 replies)
  117. Solved: Pivot Cache Consolidation (4 replies)
  118. Solved: Help deleting rows please (3 replies)
  119. validating values in excel using VBA (3 replies)
  120. Solved: What's wrong with my Paste Special Transpose Code? (3 replies)
  121. Solved: Row to repeat at bottom (13 replies)
  122. Solved: hide the button for certain time of the day (2 replies)
  123. Sleeper: Hide VBA operations (2 replies)
  124. How can I grab the data from a LISTBOX and insert it on COLUMN "G1" (3 replies)
  125. How to List Named-Ranges only from specific Sheet (3 replies)
  126. Solved: Finding non numeric in range using an array (5 replies)
  127. Dividing merge cell into ten equal rectangles for inputing Digit? (1 replies)
  128. "File Locked for Editing" When Not Even Open (5 replies)
  129. Solved: How to make a folder in the same path (5 replies)
  130. Solved: Pivot Cache Consolidation (1 replies)
  131. Script to remove custom views (1 replies)
  132. Solved: How to use LookUp/If-Then in VBA? (20 replies)
  133. Solved: Copy a subset of a named range using Union (1 replies)
  134. Solved: Offset to 1st & 2nd cell in row (7 replies)
  135. Help with Arrays (4 replies)
  136. Combining and aligning data from multiple sheets (10 replies)
  137. Solved: Trim titles (2 replies)
  138. Solved: Toolbox icon in VBA (11 replies)
  139. VBA code to force invoke Excel 2007 instead of 2003 (from Access) (1 replies)
  140. Help with creating Array from Checkboxes (14 replies)
  141. Solved: Copy data from one Spreadsheet to another and validate (10 replies)
  142. Solved: Add Formula to Cell Using VBA (4 replies)
  143. Excel open dialog box (1 replies)
  144. Start time help (6 replies)
  145. Solved: How to start pasting on the last row? (14 replies)
  146. Solved: opening excel file using VBA (6 replies)
  147. Simulating mouse click on web page (2 replies)
  148. Printing equation into cell (4 replies)
  149. Sleeper: Similar data (8 replies)
  150. Solved: Sorting Email Addresses column (3 replies)
  151. Solved: truncate string and onward (12 replies)
  152. How do i print LISTBOX CONTENTS INTO EXCELL SPREADSHEET (3 replies)
  153. Solved: Place a comma in between two words (2 replies)
  154. Solved: Display Calculotor (3 replies)
  155. Working with various Ranges (Named Range) and Worsheet Events (6 replies)
  156. excel to work passing data dynamically with bookmarks in word (8 replies)
  157. Identify Conditional Formatting (3 replies)
  158. Sleeper: Resetting Used range with VBA (1 replies)
  159. Creating number (4 replies)
  160. Adding Custom button in titlebar of userform (12 replies)
  161. Integer division (2 replies)
  162. Solved: Print, Save As, Exit Sheet & close Current workbook (2 replies)
  163. Single or Double (2 replies)
  164. Each subtotal signature require only at last page for each subtotal. (1 replies)
  165. Passwords Security (2 replies)
  166. Solved: No of characters in a formula (4 replies)
  167. Array of a custom class??? (2 replies)
  168. Macro for comparing cells on 2 sheets in Excel (8 replies)
  169. Save range as a new file? (11 replies)
  170. Find Next Column (6 replies)
  171. Solved: How to write format code in VBA? (4 replies)
  172. SetFocus Method Not working (2 replies)
  173. VBA to AutoSave and Copy to diff location (5 replies)
  174. Problem Changing Defined Name Scope in Excel 2007 (2 replies)
  175. Conditional formatting (29 replies)
  176. Include Multiple column groups on every page? (4 replies)
  177. Application-defined or object-defined error (5 replies)
  178. Solved: Trying to Remove Quotes in txt File (4 replies)
  179. Solved: Digits in number (4 replies)
  180. Retain Comments in Printout of excel (5 replies)
  181. Run Time err 1004: Unable to get the vlookup property of the worksheet function class (2 replies)
  182. Finding Print Area in a excel worksheet (2 replies)
  183. Delete VBA Code of another Excel (6 replies)
  184. VBA Display Named Range (2 replies)
  185. How to reopen VBA editor using password? (2 replies)
  186. Solved: modify the program(InsertRow&Formatting) (0 replies)
  187. Create Random String (4 replies)
  188. Solved: Missing Add-in (4 replies)
  189. Solved: Search for Tab (3 replies)
  190. Solved: Exit behaviour for last field in a frame (2 replies)
  191. Solved: Computer identification (11 replies)
  192. Solved: Transpose table of data (8 replies)
  193. VBA Project help and overflow error (52 replies)
  194. Solved: Hide columns not appearing in Sheet 3 (4 replies)
  195. VBA - Populating Arrays Inside of Structures (4 replies)
  196. Query regarding worksheet function (Count IF) using in Excel VBA (2 replies)
  197. Solved: auto-fill webpage search form (3 replies)
  198. Solved: Word Constants (5 replies)
  199. Solved: Changing d/m/yyyy format in workbook (2 replies)
  200. Solved: is there a paste special for this data? (6 replies)
  201. Solved: counting (3 replies)
  202. How to use AutoIt to Open Excel and Enabe Macro (1 replies)
  203. Solved: loop through selected cell (7 replies)
  204. Solved: prevent worksheet deletion. (4 replies)
  205. can i define the Public contant WB and Sheet name for use in form ,macro and sub? (8 replies)
  206. Solved: VBA Code - Adding value to Comments (5 replies)
  207. [SOLVED:] Hiding rows in a function (17 replies)
  208. expand selection starting from dynamic range (2 replies)
  209. Unable to get the SaveAs property of the Workbook class (3 replies)
  210. Solved: Delete row (3 replies)
  211. Data from Excel (macros) to Word using VBA (3 replies)
  212. Sending email from within Excel (.From) issue (4 replies)
  213. How to attached font when save Excel 2007 into Excel 2003 format (2 replies)
  214. Solved: How to formulate sumifs based on weeknum? (4 replies)
  215. fill in the value accoding the date (15 replies)
  216. Solved: Input/Output text files fill in variables (14 replies)
  217. How to open workbook in another computer (5 replies)
  218. Solved: Populating a listbox (4 replies)
  219. Process bar (1 replies)
  220. Comparing cells within a column (4 replies)
  221. Hide "View" menu (12 replies)
  222. [SOLVED:] Delete Row Skipping (4 replies)
  223. Solved: Protection Issue? (6 replies)
  224. Combining multiple excel workbooks in to a single sheet (3 replies)
  225. Case Statement (6 replies)
  226. excel multiple workbooks (11 replies)
  227. Solved: UserForm List Box Problem (4 replies)
  228. manual recalculation not for all sheets in wb (2 replies)
  229. Use VBA to populate a VLOOKUP formula - then move that worksheet to another workbook. (3 replies)
  230. Solved: Division with remainder (2 replies)
  231. Delete the warning message. (2 replies)
  232. [SOLVED:] Unlocking several VBAProjects (26 replies)
  233. Multiple selection from the cell. (2 replies)
  234. Listbox selection and deselection triggers in userform (3 replies)
  235. loop to delete the row and replace the value in cell having problem (9 replies)
  236. Solved: Count weekly offs based on day of week (2 replies)
  237. Macro required for ALT+TAB keys (8 replies)
  238. Populating a Userform Textbox on userform open! (5 replies)
  239. Solved: Worksheet ListBox Selection (7 replies)
  240. Solved: Can This be Simplified? (8 replies)
  241. [SLEEPER:] Keep common input box in background (0 replies)
  242. Solved: VBAProject (PERSONAL.XLS) Stays Open Forever? (4 replies)
  243. Select multiple rows based on selected column (5 replies)
  244. Solved: If / Statement (7 replies)
  245. Multiple If statements with multiple date range (6 replies)
  246. ByRef ByVal (3 replies)
  247. Solved: Password entry visible (13 replies)
  248. Solved: how to stop duplicat data entry (5 replies)
  249. How to remove the blank space which is present at the end of the value in a cell (14 replies)
  250. Delete rows if cell less than 4 (7 replies)