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: Message box code (5 replies)
  2. Userforms (3 replies)
  3. Solved: SaveFileName As Concatenated Value (5 replies)
  4. Solved: Selecting Value from List based on Multiple Criteria (8 replies)
  5. Solved: Interest Rate (2 replies)
  6. Copy and pasting format and formula for new range. (8 replies)
  7. Using excel to read pixel color in .bmp files (4 replies)
  8. Inserting names from address list into user form (5 replies)
  9. Hiding Spreadsheets (5 replies)
  10. Worksheet_SelectionChange Now I can't Cut and Paste (1 replies)
  11. Solved: Search and copy question (5 replies)
  12. Solved: Spreadsheet Printing (3 replies)
  13. Problem with Calculated fields in the Pivot Table (1 replies)
  14. Existing data shuts down VBA (18 replies)
  15. Solved: Add new row to spreadsheet (5 replies)
  16. Find Excel workbooks in many SubFolders (5 replies)
  17. Solved: Working with Filtered Data (1 replies)
  18. Solved: Data from Userform to spreadsheet (4 replies)
  19. Menu Editor (19 replies)
  20. msgbox help wanted (9 replies)
  21. Calendar with comments (7 replies)
  22. Fill text to two sheets on entry (3 replies)
  23. Copying data from multiple sheets to one - feedback Req. (5 replies)
  24. Solved: Close Excel? (6 replies)
  25. Logging in problem again. (2 replies)
  26. Solved: Combo Box loses all entries after running code (5 replies)
  27. Converting normal cell into DropDown List (7 replies)
  28. Altering the Series Formula in a Chart (3 replies)
  29. Solved: Nested ifs Check Changed by val (6 replies)
  30. list box (8 replies)
  31. [SOLVED:] Floating button (16 replies)
  32. VB Code for saving a workbook with duplication prevention (13 replies)
  33. Solved: drop down list forced selection (5 replies)
  34. get first blank row and paste formula and format from range (11 replies)
  35. Clean way to create popup help balloons (4 replies)
  36. Solved: Userform updating worksheet incorrectly (4 replies)
  37. [SOLVED:] How to display a special character in a message box? (12 replies)
  38. Conditional transfer of data (3 replies)
  39. VLookup on more than one column (1 replies)
  40. Solved: validation techniques (3 replies)
  41. Solved: Syntax calculation error (7 replies)
  42. Constant (4 replies)
  43. Solved: Forcing a spreadsheet with a read only attribute to reopen as read/write (4 replies)
  44. Solved: Form Controls Vs Active X Controls (15 replies)
  45. Solved: click cell behind picture NOW EDITED (7 replies)
  46. Transfering data form to form (8 replies)
  47. Converting a Column Reference/Address to Points measurement for Shape alignment. (1 replies)
  48. Solved: row counting, pasting on trigger (7 replies)
  49. Solved: CSV File (6 replies)
  50. Extracting data from another file (3 replies)
  51. Get Column Letter (48 replies)
  52. Settings? (14 replies)
  53. extract data from notepad to xls (1 replies)
  54. Solved: From - Option Button & Focus issue (4 replies)
  55. Solved: Multiple instances of VBAProject (1 replies)
  56. Solved: Removing Blanks (18 replies)
  57. Solved: Help with Error Handling (3 replies)
  58. Solved: Duplicates removals! (11 replies)
  59. Set focus in a list box (19 replies)
  60. Cut and Paste Rows to New Worksheet based on date in column - protected worksheet (6 replies)
  61. Advice Needed (5 replies)
  62. User Selected Excel File (18 replies)
  63. Solved: Pop-up with list of sheets and checkboxes? (3 replies)
  64. Buttons Visible/Hidden (8 replies)
  65. FileSystemObject and Subfolders (9 replies)
  66. Solved: Check one range against another (11 replies)
  67. Solved: Perl Conversion (9 replies)
  68. test if more than one year (38 replies)
  69. Updating nested linked files (3 replies)
  70. Solved: Copy rows to 2 different workbooks (21 replies)
  71. Email sheet and cell reference (6 replies)
  72. Solved: Data Entry Control (53 replies)
  73. Solved: Pop-up calendar confusion (15 replies)
  74. Paste format + formula attached to " Add new " Button (3 replies)
  75. auto update link from password protected file (4 replies)
  76. Solved: Quantity at Operation based on In/Out marker (16 replies)
  77. Conditional code or format (No formula) (10 replies)
  78. Solved: Subscript Error (5 replies)
  79. List Boxes (19 replies)
  80. Solved: Help: Need to export image from Excel (10 replies)
  81. ComboBox - Using Combo Boxes to Change/Delete rows (13 replies)
  82. speedy page setup (8 replies)
  83. Solved: quick question (8 replies)
  84. Disable "shift" key (4 replies)
  85. Solved: Vlook up and two combo boxes (3 replies)
  86. Solved: Clearing old data from a table (4 replies)
  87. Solved: Automatic Cell formating (3 replies)
  88. add a description (2 replies)
  89. Solved: Problem with DB Path (2 replies)
  90. Using Case Statement (4 replies)
  91. VBA Code to Auto-Select Rows and Copy to New Worksheet (2 replies)
  92. Solved: Optimize Code (13 replies)
  93. can't get rid of Bold (2 replies)
  94. Solved: Trouble with format of a textbox in a userform (12 replies)
  95. Solved: merge and print with offset (18 replies)
  96. Solved: Preventing renaming sheets (18 replies)
  97. Solved: Removing Controls on the Fly (7 replies)
  98. create a save as box in a user form (4 replies)
  99. A Difficult thing indeed (9 replies)
  100. Adding Cell reference as a header prior to print (0 replies)
  101. return text in one column based on another one (4 replies)
  102. Solved: ToolTip for each item in combobox (6 replies)
  103. Execute macro on all sheets but last 6 (2 replies)
  104. Solved: get rid of duplications and data filtering! (9 replies)
  105. Solved: Find named range that activecell is in (3 replies)
  106. Solved: A Submit Button that Doesn?t (8 replies)
  107. Clear:Temporary Internet Files + Opened Website Address Names + DNSCache+Cookies+Temp (18 replies)
  108. Intelligent Copy Paste (22 replies)
  109. Solved: Delete specific rows from all spreadsheets (3 replies)
  110. Importing Data to a Form (15 replies)
  111. Cannot call "Format Cells" dialogue box - Excel Bug? (3 replies)
  112. Solved: Timesheet calculation using forms accounting for sick days (43 replies)
  113. Solved: VB Editor (2 replies)
  114. Transparent Background Colour? (2 replies)
  115. How does one obtain a folder name using VBA? (6 replies)
  116. combobox and listbox questions (3 replies)
  117. How to return large multi-dimensional arrays from VBA Excel functions? (3 replies)
  118. Conditional Formatting for row based on cell (7 replies)
  119. Don't have Frame1 & ListBox1 BackColor = fmBackStyleTransparent Property? (11 replies)
  120. Sleeper: Auto-Adjust Ranking (0 replies)
  121. Solved: Browse A Folder And Hyperlink All Modified WBs (32 replies)
  122. [SOLVED:] Muliple Userforms (13 replies)
  123. Solved: Retrieve Data From A Database To Excel Using SQL (9 replies)
  124. DATA VALADATION (7 replies)
  125. Solved: Merge Cells (11 replies)
  126. Help Creating Pivot Table w/ Specific Consolidation Ranges (4 replies)
  127. right click menu in a text box (5 replies)
  128. Solved: Auto Tab (5 replies)
  129. Refresh Listbox (2 replies)
  130. Solved: Looping Images (7 replies)
  131. sheetchange problem (9 replies)
  132. stretch to a4 (7 replies)
  133. Solved: Programmatically add code to Workbook_Open (15 replies)
  134. Names like McNeed etc. (8 replies)
  135. Addin for work (9 replies)
  136. Solved: Programmatically add controls 2 (4 replies)
  137. Solved: Programmatically add controls (2 replies)
  138. Solved: Defining variable Ranges? (4 replies)
  139. Solved: Form to change sheets (8 replies)
  140. Solved: I want to make code smaller and more optomized (10 replies)
  141. How to use DoEvents in VBA (2 replies)
  142. Paste Format (4 replies)
  143. Solved: Find / FindNext question (6 replies)
  144. email active sheet problems (5 replies)
  145. Solved: Solved:Totaly stuck (13 replies)
  146. Time question (4 replies)
  147. Can someone help me solve this issue pls? (2 replies)
  148. A problem with user defined data type (31 replies)
  149. Solved: Deleting text boxes (8 replies)
  150. Replace a tilde with the corresponding headword (16 replies)
  151. Run .exe from VBA code (4 replies)
  152. Keypress on Datepicker (4 replies)
  153. Solved: Difficult... Macro to search multiple workbooks for a match? (30 replies)
  154. Solved: Next cell any direction (8 replies)
  155. Run macro on passw protected TAB (21 replies)
  156. Solved: Change focus or unload between forms (4 replies)
  157. Automation: EVT Logs to Excel (6 replies)
  158. Solved: Parent and Child workbook relationships (29 replies)
  159. Solved: REF TO A CELLS NAME (5 replies)
  160. Solved: copy specific cells sheet1 into form sheet2 (23 replies)
  161. Text Boxes Won?t Stay Visible on Charts (7 replies)
  162. Solved: Loop to check every row (26 replies)
  163. Solved: Transform general format in time format (12 replies)
  164. Solved: ALL UPPER CASE FONTS (6 replies)
  165. using inputbox (5 replies)
  166. Solved: Pivot table (1 replies)
  167. Excel data format query (39 replies)
  168. Hide Rows based on variable (3 replies)
  169. Calculate Date Difference excluding Weekend (Saturday & Sunday) (9 replies)
  170. Solved: progress bar (7 replies)
  171. How to highlight precedents of formula (6 replies)
  172. Solved: Adding features to an excel worksheet (36 replies)
  173. Solved: Select All and Unselect all (8 replies)
  174. Solved: Assign VBA Variable from Excel Cell (3 replies)
  175. Fctns LARGE & SMALL Don't Work in Cond Fmtting Formulas (1 replies)
  176. Max from a certain range (23 replies)
  177. Solved: Sheetprotection and Save dialog (6 replies)
  178. Solved: Upper/Lower Case (9 replies)
  179. Solved: Change to column if more than one item is checked (21 replies)
  180. Solved: Don't allow Special Characters (14 replies)
  181. Fit To pages wide (5 replies)
  182. Solved: Complele Daily Entries before Closing Worksheet (3 replies)
  183. Solved: Select sheet based a combobox value (43 replies)
  184. Protect/Unprotect Closed workbook (1 replies)
  185. Solved: Probem with comparing list code. (15 replies)
  186. VBA Cell locked (6 replies)
  187. Solved: CSV FILE (3 replies)
  188. Forcing printer to print landscape (4 replies)
  189. Excel Range Math - anyone have a lookup? (9 replies)
  190. Solved: Page break after each new customer (4 replies)
  191. Solved: Opening a Word document from Excel in the running instance of Word (5 replies)
  192. Solved: Stop the cursor in a loop (3 replies)
  193. Solved: How to Assign ?Define Name? to a Button on a Toolbar (8 replies)
  194. find and move data macro (6 replies)
  195. Solved: Macro for Custom Formatting (5 replies)
  196. How to get all texts from clipboard? (16 replies)
  197. Windows and Mac difference...Code wise (6 replies)
  198. Move files between directories (12 replies)
  199. Solved: Problem with array (6 replies)
  200. Solved: Unprotecting All Worksheets While Macro RUNS (8 replies)
  201. Excel Functions in VBA (17 replies)
  202. Solved: Delete empty rows and copy to another worksheet (12 replies)
  203. Auto Transfer (10 replies)
  204. Solved: Format cells in noncontiguous selected rows (2 replies)
  205. Solved: Copy/Paste within a Macro (9 replies)
  206. hyperlinking to a macro? (7 replies)
  207. List of last date sold and price (9 replies)
  208. Sleeper: Landscape if 2 pages wide? (3 replies)
  209. Solved: Auto completion of Dates (6 replies)
  210. Copy worksheets to new workbook - Teach Me? (9 replies)
  211. Solved: How to sort worksheets? (8 replies)
  212. Quick few questions (4 replies)
  213. ?Can?t Find Project or Library? (4 replies)
  214. count a numberformat (6 replies)
  215. SOLVED: How do you create a worksheet with a given name? (10 replies)
  216. Solved: Modify Personal.xls Not Trusted Error (3 replies)
  217. Application.Ready (22 replies)
  218. Solved: Help with VBA (12 replies)
  219. Transfering information (9 replies)
  220. Solved: Saving as xlExcel5 from Excel 2000 (4 replies)
  221. Solved: Password sensitivity (10 replies)
  222. A Simple search (4 replies)
  223. Running/storing macros independently of worksheet (6 replies)
  224. Excel VBA to Script (8 replies)
  225. Solved: Saving to various sections on the same sheet (32 replies)
  226. Calculate period of time, excluding non-working hours (7 replies)
  227. combobox (2 replies)
  228. Solved: Complete Data Entry Before Close (10 replies)
  229. Solved: Excel Error Lists...? (2 replies)
  230. Solved: Copying rows into worksheet - problem with macro (2 replies)
  231. Solved: Macro Calling (2 replies)
  232. Solved: Save only one sheet (9 replies)
  233. Solved: Excel to word at position (11 replies)
  234. Solved: About Windows Media Player on UserForm (6 replies)
  235. Sharing Macros (3 replies)
  236. Solved: Deleting Row if word ends in "a" in column A? (29 replies)
  237. Calculate thru VBA (3 replies)
  238. Solved: Importing Non English Text (5 replies)
  239. [SOLVED:] Copy and Paste Error between Application instances (14 replies)
  240. Compare between two lists project (1 replies)
  241. Changing data selected in a UserForm (28 replies)
  242. Solved: Add NETWORKDAYS to a date (3 replies)
  243. Solved: Delete Duplicate Rows based on multiple columns (14 replies)
  244. Insert a new row after a certain number of rows (22 replies)
  245. Solved: treeview in worksheet (18 replies)
  246. Solved: Linking columns in different tabs of the same file (3 replies)
  247. check for hyperlink (5 replies)
  248. Solved: How to create a DLL via VBA editor? (25 replies)
  249. Solved: Problems with ?MERGE? and ?xlCenterAcrossSelection? (9 replies)
  250. Conditionally format a cell the same as another cell upon a match (26 replies)