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 this loop to loop through all Sheets (17 replies)
  2. Solved: Code is calling Private Worksheet Code, Why? (24 replies)
  3. Solved: Forcing correct data entry (14 replies)
  4. Solved: ActiveWorkbook.Activesheet (3 replies)
  5. changing code with code (5 replies)
  6. Exporting charts as GIFs, help needed (3 replies)
  7. Solved: Counting 1's in a column (30 replies)
  8. Find Cut and Paste at bottom (9 replies)
  9. excel to access (3 replies)
  10. Solved: Using a range in a chart with VBA (2 replies)
  11. Solved: Mouse/Cursor Speed (2 replies)
  12. Solved: How do you make text wrap in a textbox? (5 replies)
  13. Using a Variable in a V-Look up formula (2 replies)
  14. [SOLVED:] Find Next (11 replies)
  15. is it possible to delete a workbook with code? (8 replies)
  16. Solved: Create worksheets based on column (11 replies)
  17. Making a Database out of Excel (1 replies)
  18. Need to open Outlook Template out of Excel (14 replies)
  19. Solved: Count Sheets With Specific Name (4 replies)
  20. Finding Print Area per Page (12 replies)
  21. Solved: Text file extract (9 replies)
  22. Solved: Any better suggestions for checking cells before row move? (31 replies)
  23. Solved: Charts - Using Two Y Axes (2 replies)
  24. Solved: auto population of data (2 replies)
  25. auto update (42 replies)
  26. auto email generation (11 replies)
  27. auto close (5 replies)
  28. Solved: save as excel file automatically (10 replies)
  29. UsedRange, copy paste values? (24 replies)
  30. Solved: Rename a macro module (2 replies)
  31. Solved: Ampersand function help (10 replies)
  32. hide active window using Auto_open (5 replies)
  33. VBA recolor fonts to paste into other apps (4 replies)
  34. Extract data from closed workbook using VBA with data range unknown at start! (1 replies)
  35. Solved: Multiplying cells (28 replies)
  36. Save Excel File to Fileserver via Macro (1 replies)
  37. If statement and Qualifying help-- please (10 replies)
  38. Add to Pivot Cache based on Criteria? (0 replies)
  39. Solved: Add If Statment to w/ Array to Loop (4 replies)
  40. Solved: Substitute Workbook Source Name? (3 replies)
  41. Solved: Enable & Disable Macro (9 replies)
  42. Solved: Listbox populated by Userform selections (6 replies)
  43. Can these functions work with arrays? (3 replies)
  44. Solved: CheckBoxes (3 replies)
  45. Solved: can we have Greek letters in label caption? (1 replies)
  46. initialize active X control (1 replies)
  47. Extracting Data from a PLC (0 replies)
  48. Code to add a menu, macros to it and remove when book closes (12 replies)
  49. Copy Variable Range (4 replies)
  50. Dynamically Created Toolbar with Custom Icons are Blurry (5 replies)
  51. Solved: What is wrong with this thing?? (16 replies)
  52. date in vba when paste defaults to american (8 replies)
  53. How to give a button a fill color? (2 replies)
  54. [SLEEPER:] Counting (3 replies)
  55. Sleeper: Do a v-lookup on a closed workbook (4 replies)
  56. Delete Add-in with code (3 replies)
  57. Looping/Code Consolidation (6 replies)
  58. FYI - Adjust zoom, orientation, and papersize automatically (3 replies)
  59. Solved: Macro help (10 replies)
  60. Findout Max value (7 replies)
  61. Excel GUI : Activate a button from macro (9 replies)
  62. Loop Help to find Intersection Cell Address (5 replies)
  63. Word.application???? (8 replies)
  64. If statement (5 replies)
  65. Solved: Number Stored as Text (19 replies)
  66. [SOLVED:] Indian number format (30 replies)
  67. Saving data from several objects to 1 cell (2 replies)
  68. Solved: Calling a Subroutine (7 replies)
  69. Solved: Windowstate = xlnormal then Center Position? (7 replies)
  70. Spreadsheet to Form Help (4 replies)
  71. Printing each sheet to pdf with a unique pdf password (1 replies)
  72. Solved: merging worksheets matched on 'key' in column (2 replies)
  73. Solved: Feed Word with changing data from excel (3 replies)
  74. save a file to a defined destination (1 replies)
  75. [SLEEPER:] Set a variable equal to the sub name (3 replies)
  76. Number format (4 replies)
  77. How to RAR a folder via VBA? (1 replies)
  78. Solved: Transfer Data to Another Workbook (15 replies)
  79. Formula for counting used rows - Anomalie? (2 replies)
  80. Getting chm help file to open from menu (39 replies)
  81. Installer for Macro (4 replies)
  82. [SOLVED:] How to Use VBTAB (12 replies)
  83. Code to Undo & Re-Do (5 replies)
  84. Solved: Search Formula limits exceeded (3 replies)
  85. Solved: Get The Replaced Cell's Address (2 replies)
  86. Passing multiple arrays between sub (5 replies)
  87. macros cannot be found (8 replies)
  88. Run-time error method ' ' of object ' ' fail (1 replies)
  89. Insert alternative rows (15 replies)
  90. Solved: Auto_Open/Auto_Close (12 replies)
  91. Copy updated sheet from closed workbook (1 replies)
  92. Deleting Rows w/ specifics datas (12 replies)
  93. Solved: Indirect reference for form controls (3 replies)
  94. Extracting Word From String... (26 replies)
  95. User form and tab key (11 replies)
  96. Solved: If a cell is full (5 replies)
  97. Userform to use a PIVOT (0 replies)
  98. Userform to do Filter Mode (2 replies)
  99. Drop down query (10 replies)
  100. Range format (3 replies)
  101. Solved: conditional format date (5 replies)
  102. Extracting multiple max & min values from a column (9 replies)
  103. Solved: TOOLBAR -> HELP! (3 replies)
  104. import outlook calender automaticly using vb (4 replies)
  105. currency in a concatenated string (5 replies)
  106. Form If Statement (10 replies)
  107. very simple one (5 replies)
  108. Solved: Mixed Date formats (0 replies)
  109. Phone dialer sheet is attached (3 replies)
  110. macro to set expiry date (2 replies)
  111. [SOLVED:] I need fixed decimal (2 replies)
  112. SUM(IF across multiple sheets in another workbook (2 replies)
  113. Solved: Print Prompt For Form (23 replies)
  114. Solved: loop, find value and replace assistance (19 replies)
  115. event driven actions in repsonse to data (2 replies)
  116. Private Sub userform_load()???? (9 replies)
  117. Allow user to set Button Caption (5 replies)
  118. msgBox with a Text Box Input (3 replies)
  119. Show todate as default (15 replies)
  120. subtotal at pagebreak (7 replies)
  121. how to show 4 digit number (18 replies)
  122. Solved: Loop Help (54 replies)
  123. Error 400 (4 replies)
  124. Solved: multipage page selection? (4 replies)
  125. Userform vs controls in worksheet (8 replies)
  126. [SOLVED:] Tick appropriate box (2 replies)
  127. Solved: Two versions of one project -- oops! (4 replies)
  128. Solved: Form to Spreadsheet problem (8 replies)
  129. Solved: A Loop To Create A Worksheet Formula (7 replies)
  130. Solved: Copy Data that meets criteria (3 replies)
  131. Solved: apply end of cell to paste (4 replies)
  132. Solved: conditional formating offset (10 replies)
  133. Solved: Vlookup loop (4 replies)
  134. Solved: Cut and copy new approach (9 replies)
  135. Solved: how to use match property of the worksheetfunction class? (8 replies)
  136. Solved: Copy Columns and paste in different sequence (3 replies)
  137. Addin to display under a menu (8 replies)
  138. Transfer Data From Excel to Access Table (1 replies)
  139. Consolidated Messages/Strings (5 replies)
  140. Reading a csv file using vba excel! (5 replies)
  141. Solved: Search Excel File and populate Web page (11 replies)
  142. Referencing a Workbook (6 replies)
  143. Solved: Combining Arrays (8 replies)
  144. Solved: AddItem help (29 replies)
  145. Form vb change help (3 replies)
  146. Controling WebBrowser font size (0 replies)
  147. Sporadic Error 1004 when creating a pivot table (0 replies)
  148. Solved: Match two criteria and display offsets? worksheet function (5 replies)
  149. Printing Comments (3 replies)
  150. Removing #na from excel cell (4 replies)
  151. Tabulation Form (4 replies)
  152. Solved: Problem With A Text Box On A Chart (5 replies)
  153. Check and Transpose (1 replies)
  154. USER FORM - lots of small problems - PLEASE HELP! (8 replies)
  155. Solved: Writing to VBE crashes Excel (2 replies)
  156. Removing Toolbar etc (24 replies)
  157. [SLEEPER:] Macro to print payslips (2 replies)
  158. Solved: Help AutoFilter 2 criteria at one time (3 replies)
  159. Solved: Analog Clock (3 replies)
  160. Checking Textboxes (2 replies)
  161. Solved: Formula to Script (7 replies)
  162. Getting data from diferent files in same Folder (4 replies)
  163. Help... I am so lost (3 replies)
  164. send Registry Settings with email (16 replies)
  165. copy and paste to new row (6 replies)
  166. Solved: Version Control (10 replies)
  167. Solved: Please Help - Major Problem (4 replies)
  168. Auto Filter (8 replies)
  169. Solved: Internal rate of return Function (7 replies)
  170. Solved: simple problem im sure (6 replies)
  171. Named Ranges in Excel VBA (1 replies)
  172. open worksheet (2 replies)
  173. how to define color of the cell by coding (2 replies)
  174. Sleeper: Advance Filter with command button (1 replies)
  175. Calculate doesn't seem to do anything (7 replies)
  176. Solved: Downloading XLS files from Web page (3 replies)
  177. Solved: Help with this code? (6 replies)
  178. Solved: Cut from Word and paste in Excel (3 replies)
  179. Search for the string and move the cells accordingly (2 replies)
  180. Solved: Web browser control (3 replies)
  181. Search a Userform Listbox for matching text from another Listbox (4 replies)
  182. UserForm Concept help (6 replies)
  183. Extracting max & min values with a condition (29 replies)
  184. BeforeDoubleClick Event (5 replies)
  185. Calling a UserForm when a user clicks a cell (15 replies)
  186. If Txtbox equals Chr then Show Image (14 replies)
  187. Solved: Worksheet_Calculate event (17 replies)
  188. Formula in a Control (5 replies)
  189. Header Problem with "text CC F&B" (3 replies)
  190. [SOLVED:] Thinking outside the Square (41 replies)
  191. Querying from Access (2 replies)
  192. Solved: Make list boxes visible=False (2 replies)
  193. Macro to generate documents from database (8 replies)
  194. Date Wise Max code (5 replies)
  195. Solved: Locate max number from column A (2 replies)
  196. Run time error '1004':Select method of worksheet class failed (3 replies)
  197. Copy certain range from the sheet matching conditions (2 replies)
  198. Interactive selection of worksheet and range (3 replies)
  199. [SLEEPER:] Found some interesting code: (4 replies)
  200. If-Then (12 replies)
  201. "Picture too large/truncated" error? (19 replies)
  202. Solved: Set Slider to Current Year (6 replies)
  203. Copying Custom Menu to another Computer (7 replies)
  204. Simple Filter (2 replies)
  205. Solved: Save As (22 replies)
  206. Solved: Run Time error 1004 (5 replies)
  207. loop that add lines alternately (7 replies)
  208. Solved: how to empty combobox? (1 replies)
  209. Telephone Dial (4 replies)
  210. Userform, Textbox data validation (4 replies)
  211. Solved: Combining cells using a function key (3 replies)
  212. Solved: More than 2 criteria - possible?? (22 replies)
  213. Solved: Adding Txt Boxes in Form (32 replies)
  214. Userform to Macro (1 replies)
  215. Prevent two network users from opening same workbook? (12 replies)
  216. Solved: Email code crashes if workbook isn't saved (8 replies)
  217. Solved: printing a dynamic named range problem with non contiguous data? (4 replies)
  218. Solved: Trimming "Leading" spaces from cells in VBA? (8 replies)
  219. Save Workbook on Webpage (4 replies)
  220. Coding of userform (2 replies)
  221. Running a macro for any workbook/worksheet (1 replies)
  222. Solved: Versatile Form (10 replies)
  223. same code does not workon diffrent sheet with same type of data (3 replies)
  224. copy range to diffrent book (9 replies)
  225. Solved: variables in formulas (2 replies)
  226. Locking embeded word object in excel (2 replies)
  227. Solved: If value "tick mark" then ... (3 replies)
  228. Solved: Mask in form (11 replies)
  229. Solved: Shorten this VBA code (2 replies)
  230. [SOLVED:] Display Picture in frame on userform follwing hyperlink? (10 replies)
  231. Conditional Copy of Data using the macro (8 replies)
  232. Transferring to VB.net (5 replies)
  233. Excel to SQL Connection? (1 replies)
  234. Solved: Build list of sheet names and create cell validation? (3 replies)
  235. Solved: Sub Menu in My Custom Menu (7 replies)
  236. Solved: Is there any tooltiptext in excel? (14 replies)
  237. Form List Help (16 replies)
  238. Help with making code more flexible (18 replies)
  239. [SOLVED:] Only allowing values to be copied between certain dates? (6 replies)
  240. problem in a form (28 replies)
  241. Solved: ListBox Columnwith (2 replies)
  242. checkdic as dictionary (4 replies)
  243. Merged Columns (5 replies)
  244. Help Setting which workbook a Macro will run (4 replies)
  245. Procedurally generated checkbox code (3 replies)
  246. Using ActiveX Objects in Excel (2 replies)
  247. Auto_open failure (9 replies)
  248. Solved: Form Help (3 replies)
  249. Email Selection (5 replies)
  250. Connecting To A Database Without The Local Machines Odbc (2 replies)