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: Edit/update code in multiple workbooks (14 replies)
  2. Permanently Hide Sheet Tabs (4 replies)
  3. VBA Calendar (9 replies)
  4. VBa Code exist? (2 replies)
  5. School exercise, i'm desperate (8 replies)
  6. Put textfile on desktop (4 replies)
  7. [SLEEPER:] Return Value from UserForm (14 replies)
  8. Textbox help with msgbox (5 replies)
  9. Solved: How Does VBA Handle Multiple Conditions Within an If Statement (11 replies)
  10. repeat rows at bottom of page (1 replies)
  11. Help!!!! (2 replies)
  12. delete all except the last duplicate (3 replies)
  13. Solved: keep cursor in textbox... (6 replies)
  14. Adding code to a worksheet on the fly (2 replies)
  15. Solved: Error "400" in VBA (12 replies)
  16. End If without Block If (4 replies)
  17. Sleeper: Evaluate method & For Loop: which on is faster (2 replies)
  18. Solved: Another Problem (2 replies)
  19. Solved: Convert Monthly to Quarterly using Macro (13 replies)
  20. MsgBox vbYesNo help (8 replies)
  21. Sleeper: Disable "Show sheet tabs" option (1 replies)
  22. Solved: I'm stumped ....please help (4 replies)
  23. Solved: reset picture# in Excel (3 replies)
  24. Parsing Name Help (1 replies)
  25. Solved: Worksheet Menu Bar (6 replies)
  26. Solved: How to Replace Horizontal Tab in Excel (4 replies)
  27. Solved: Pivot Cache Consolidation (4 replies)
  28. Solved: Help deleting rows please (3 replies)
  29. validating values in excel using VBA (3 replies)
  30. Solved: What's wrong with my Paste Special Transpose Code? (3 replies)
  31. Solved: Row to repeat at bottom (13 replies)
  32. Solved: hide the button for certain time of the day (2 replies)
  33. Sleeper: Hide VBA operations (2 replies)
  34. How can I grab the data from a LISTBOX and insert it on COLUMN "G1" (3 replies)
  35. How to List Named-Ranges only from specific Sheet (3 replies)
  36. Solved: Finding non numeric in range using an array (5 replies)
  37. Dividing merge cell into ten equal rectangles for inputing Digit? (1 replies)
  38. "File Locked for Editing" When Not Even Open (5 replies)
  39. Solved: How to make a folder in the same path (5 replies)
  40. Solved: Pivot Cache Consolidation (1 replies)
  41. Script to remove custom views (1 replies)
  42. Solved: How to use LookUp/If-Then in VBA? (20 replies)
  43. Solved: Copy a subset of a named range using Union (1 replies)
  44. Solved: Offset to 1st & 2nd cell in row (7 replies)
  45. Help with Arrays (4 replies)
  46. Combining and aligning data from multiple sheets (10 replies)
  47. Solved: Trim titles (2 replies)
  48. Solved: Toolbox icon in VBA (11 replies)
  49. VBA code to force invoke Excel 2007 instead of 2003 (from Access) (1 replies)
  50. Help with creating Array from Checkboxes (14 replies)
  51. Solved: Copy data from one Spreadsheet to another and validate (10 replies)
  52. Solved: Add Formula to Cell Using VBA (4 replies)
  53. Excel open dialog box (1 replies)
  54. Start time help (6 replies)
  55. Solved: How to start pasting on the last row? (14 replies)
  56. Solved: opening excel file using VBA (6 replies)
  57. Simulating mouse click on web page (2 replies)
  58. Printing equation into cell (4 replies)
  59. Sleeper: Similar data (8 replies)
  60. Solved: Sorting Email Addresses column (3 replies)
  61. Solved: truncate string and onward (12 replies)
  62. How do i print LISTBOX CONTENTS INTO EXCELL SPREADSHEET (3 replies)
  63. Solved: Place a comma in between two words (2 replies)
  64. Solved: Display Calculotor (3 replies)
  65. Working with various Ranges (Named Range) and Worsheet Events (6 replies)
  66. excel to work passing data dynamically with bookmarks in word (8 replies)
  67. Identify Conditional Formatting (3 replies)
  68. Sleeper: Resetting Used range with VBA (1 replies)
  69. Creating number (4 replies)
  70. Adding Custom button in titlebar of userform (12 replies)
  71. Integer division (2 replies)
  72. Solved: Print, Save As, Exit Sheet & close Current workbook (2 replies)
  73. Single or Double (2 replies)
  74. Each subtotal signature require only at last page for each subtotal. (1 replies)
  75. Passwords Security (2 replies)
  76. Solved: No of characters in a formula (4 replies)
  77. Array of a custom class??? (2 replies)
  78. Macro for comparing cells on 2 sheets in Excel (8 replies)
  79. Save range as a new file? (11 replies)
  80. Find Next Column (6 replies)
  81. Solved: How to write format code in VBA? (4 replies)
  82. SetFocus Method Not working (2 replies)
  83. VBA to AutoSave and Copy to diff location (5 replies)
  84. Problem Changing Defined Name Scope in Excel 2007 (2 replies)
  85. Conditional formatting (29 replies)
  86. Include Multiple column groups on every page? (4 replies)
  87. Application-defined or object-defined error (5 replies)
  88. Solved: Trying to Remove Quotes in txt File (4 replies)
  89. Solved: Digits in number (4 replies)
  90. Retain Comments in Printout of excel (5 replies)
  91. Run Time err 1004: Unable to get the vlookup property of the worksheet function class (2 replies)
  92. Finding Print Area in a excel worksheet (2 replies)
  93. Delete VBA Code of another Excel (6 replies)
  94. VBA Display Named Range (2 replies)
  95. How to reopen VBA editor using password? (2 replies)
  96. Solved: modify the program(InsertRow&Formatting) (0 replies)
  97. Create Random String (4 replies)
  98. Solved: Missing Add-in (4 replies)
  99. Solved: Search for Tab (3 replies)
  100. Solved: Exit behaviour for last field in a frame (2 replies)
  101. Solved: Computer identification (11 replies)
  102. Solved: Transpose table of data (8 replies)
  103. VBA Project help and overflow error (52 replies)
  104. Solved: Hide columns not appearing in Sheet 3 (4 replies)
  105. VBA - Populating Arrays Inside of Structures (4 replies)
  106. Query regarding worksheet function (Count IF) using in Excel VBA (2 replies)
  107. Solved: auto-fill webpage search form (3 replies)
  108. Solved: Word Constants (5 replies)
  109. Solved: Changing d/m/yyyy format in workbook (2 replies)
  110. Solved: is there a paste special for this data? (6 replies)
  111. Solved: counting (3 replies)
  112. How to use AutoIt to Open Excel and Enabe Macro (1 replies)
  113. Solved: loop through selected cell (7 replies)
  114. Solved: prevent worksheet deletion. (4 replies)
  115. can i define the Public contant WB and Sheet name for use in form ,macro and sub? (8 replies)
  116. Solved: VBA Code - Adding value to Comments (5 replies)
  117. [SOLVED:] Hiding rows in a function (17 replies)
  118. expand selection starting from dynamic range (2 replies)
  119. Unable to get the SaveAs property of the Workbook class (3 replies)
  120. Solved: Delete row (3 replies)
  121. Data from Excel (macros) to Word using VBA (3 replies)
  122. Sending email from within Excel (.From) issue (4 replies)
  123. How to attached font when save Excel 2007 into Excel 2003 format (2 replies)
  124. Solved: How to formulate sumifs based on weeknum? (4 replies)
  125. fill in the value accoding the date (15 replies)
  126. Solved: Input/Output text files fill in variables (14 replies)
  127. How to open workbook in another computer (5 replies)
  128. Solved: Populating a listbox (4 replies)
  129. Process bar (1 replies)
  130. Comparing cells within a column (4 replies)
  131. Hide "View" menu (12 replies)
  132. [SOLVED:] Delete Row Skipping (4 replies)
  133. Solved: Protection Issue? (6 replies)
  134. Combining multiple excel workbooks in to a single sheet (3 replies)
  135. [SLEEPER:] Case Statement (6 replies)
  136. excel multiple workbooks (11 replies)
  137. Solved: UserForm List Box Problem (4 replies)
  138. manual recalculation not for all sheets in wb (2 replies)
  139. Use VBA to populate a VLOOKUP formula - then move that worksheet to another workbook. (3 replies)
  140. Solved: Division with remainder (2 replies)
  141. Delete the warning message. (2 replies)
  142. [SOLVED:] Unlocking several VBAProjects (26 replies)
  143. Multiple selection from the cell. (2 replies)
  144. Listbox selection and deselection triggers in userform (3 replies)
  145. loop to delete the row and replace the value in cell having problem (9 replies)
  146. Solved: Count weekly offs based on day of week (2 replies)
  147. Macro required for ALT+TAB keys (8 replies)
  148. [SLEEPER:] Populating a Userform Textbox on userform open! (5 replies)
  149. Solved: Worksheet ListBox Selection (7 replies)
  150. Solved: Can This be Simplified? (8 replies)
  151. [SLEEPER:] Keep common input box in background (0 replies)
  152. Solved: VBAProject (PERSONAL.XLS) Stays Open Forever? (4 replies)
  153. Select multiple rows based on selected column (5 replies)
  154. Solved: If / Statement (7 replies)
  155. Multiple If statements with multiple date range (6 replies)
  156. ByRef ByVal (3 replies)
  157. Solved: Password entry visible (13 replies)
  158. Solved: how to stop duplicat data entry (5 replies)
  159. How to remove the blank space which is present at the end of the value in a cell (14 replies)
  160. [SOLVED:] Delete rows if cell less than 4 (7 replies)
  161. Solved: Pivot Refresh Problem (6 replies)
  162. [SLEEPER:] Excel to open and run Access Macro (0 replies)
  163. Problem saving as macro-enabled workbook (7 replies)
  164. [SLEEPER:] Looking for the correct sheet and fill in the value refer to date (0 replies)
  165. Delete a worksheet without losing Formula reference (1 replies)
  166. Solved: Import External data into Excel (1 replies)
  167. UserFrom ListBox FilterInPlace on inactive sheet (0 replies)
  168. Solved: Looping Goal Seek Function (8 replies)
  169. Resize Pictures (3 replies)
  170. Object visibility? (4 replies)
  171. Solved: Use of AddShape to add circle (2 replies)
  172. Solved: Cell Reference (6 replies)
  173. [SLEEPER:] How to parse HTML file from VBA code into Excel ? (5 replies)
  174. VBA and cell references (7 replies)
  175. Excel Look up data in a access database (0 replies)
  176. Solved: I want to add a textbox on the chart (1 replies)
  177. Solved: Drop Down Box - (10 replies)
  178. Solved: Help needed with VBA for Alt+F11 (6 replies)
  179. Printing all worksheets in a workbook as a single file.. (6 replies)
  180. Need help with MkDir form Cell (10 replies)
  181. How do I do a best fitting line on Microsoft excel? (1 replies)
  182. Refining ListBoxes (2 replies)
  183. Solved: How to change color of Form Control Button? (2 replies)
  184. Solved: How to protect your VBA codes? (2 replies)
  185. Help needed on variable workbook name. (7 replies)
  186. download file (0 replies)
  187. [SOLVED:] Combobox on the fly (5 replies)
  188. display records by office (4 replies)
  189. Solved: Write number as string (3 replies)
  190. Need help with events in HTML Table - Excel 2007 (7 replies)
  191. Solved: Do a .Replace on an inactive sheet (1 replies)
  192. Dynamically change size of Array (5 replies)
  193. A rather nasty COUNTIFS statement issue (16 replies)
  194. Solved: Hiding Cells (4 replies)
  195. Activate Excel Window (2 replies)
  196. display records by office (1 replies)
  197. Copy Records to Worksheets based on value (2 replies)
  198. executing T-sql stmts in Excel VBA (3 replies)
  199. Sorting and removing duplets (4 replies)
  200. Solved: How to open sheets as hidden (3 replies)
  201. Solved: Extract data from text file (4 replies)
  202. Email macro stops after sending first email (1 replies)
  203. Trim bug? (0 replies)
  204. data fram pdf (9 replies)
  205. Solved: How to troubleshoot error on my macro? (2 replies)
  206. [SLEEPER:] Problem with Date Filter between two dates (2 replies)
  207. Solved: .Copy Destination (Error) (2 replies)
  208. How to get currently logged on user's account name? (5 replies)
  209. Solved: How will I modify a VBA code that will only calculate the last populated row? (4 replies)
  210. Solved: Error: 1004 - Application-defined... (6 replies)
  211. Solved: Play .wav sound file when userform opened (4 replies)
  212. Formula VBA Help (8 replies)
  213. Need to test if Worksheet Name Exists (4 replies)
  214. Arrange columns of names & addresses into rows (10 replies)
  215. Solved: Update records without looping? (7 replies)
  216. Solved: Excel Formulas based on Lowest cost (8 replies)
  217. Problem with coding Sub (2 replies)
  218. Groupwise attachment loop (0 replies)
  219. Solved: Call Sub Help (11 replies)
  220. Speeding up a loop, that does an action when encounters a value (3 replies)
  221. Solved: Help on alpha numeric subraction... (2 replies)
  222. Hiding column need to be unhide. (2 replies)
  223. Automatically saved into the drop-down list and show edit comments (1 replies)
  224. Finding the difference of two dates based on criterion. (1 replies)
  225. If filename is in sheet, return true/false? (3 replies)
  226. Solved: Auto Protection (7 replies)
  227. Solved: Excel AutoSum (2 replies)
  228. Best Place for Subs (7 replies)
  229. Formula Help (8 replies)
  230. Function or UDF (7 replies)
  231. Filter date from multiple Pivot tables (0 replies)
  232. Solved: reference to a sheet (2 replies)
  233. Run Time Error 1004 (6 replies)
  234. Solved: Sort Question (2 replies)
  235. Solved: 2 sheet search (5 replies)
  236. Solved: list data from 53 sheets (11 replies)
  237. Solved: IF/ ELSEIF Help (10 replies)
  238. How to copy different excel worksheets in one workbook? (1 replies)
  239. Excel 2003 VBA help (9 replies)
  240. Solved: Where can I find a VBA guide? (11 replies)
  241. Excel 2003 question ( using If ) (8 replies)
  242. Checking ref # status based on sheet2 ref #. (0 replies)
  243. accessing gmail attachments (3 replies)
  244. Solved: Finding the Correct Value (3 replies)
  245. line breaks & spaces (6 replies)
  246. Deleting the row that contain the text " Dismantle" (2 replies)
  247. =OFFSET(EntrySht!$B$9,1,0,COUNTA(EntrySht!$B:$B)-1,1) working functionality require. (2 replies)
  248. Next row down (1 replies)
  249. Inserting a row or a column (5 replies)
  250. Solved: Referencing Another Sheet in Workbook (16 replies)