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. Solved: Removing Controls on the Fly (7 replies)
  2. create a save as box in a user form (4 replies)
  3. A Difficult thing indeed (9 replies)
  4. Adding Cell reference as a header prior to print (0 replies)
  5. return text in one column based on another one (4 replies)
  6. Solved: ToolTip for each item in combobox (6 replies)
  7. Execute macro on all sheets but last 6 (2 replies)
  8. Solved: get rid of duplications and data filtering! (9 replies)
  9. Solved: Find named range that activecell is in (3 replies)
  10. Solved: A Submit Button that Doesn?t (8 replies)
  11. Clear:Temporary Internet Files + Opened Website Address Names + DNSCache+Cookies+Temp (18 replies)
  12. Intelligent Copy Paste (22 replies)
  13. Solved: Delete specific rows from all spreadsheets (3 replies)
  14. Importing Data to a Form (15 replies)
  15. Cannot call "Format Cells" dialogue box - Excel Bug? (3 replies)
  16. Solved: Timesheet calculation using forms accounting for sick days (43 replies)
  17. Solved: VB Editor (2 replies)
  18. Transparent Background Colour? (2 replies)
  19. How does one obtain a folder name using VBA? (6 replies)
  20. combobox and listbox questions (3 replies)
  21. How to return large multi-dimensional arrays from VBA Excel functions? (3 replies)
  22. Conditional Formatting for row based on cell (7 replies)
  23. Don't have Frame1 & ListBox1 BackColor = fmBackStyleTransparent Property? (11 replies)
  24. Sleeper: Auto-Adjust Ranking (0 replies)
  25. Solved: Browse A Folder And Hyperlink All Modified WBs (32 replies)
  26. [SOLVED:] Muliple Userforms (13 replies)
  27. Solved: Retrieve Data From A Database To Excel Using SQL (9 replies)
  28. DATA VALADATION (7 replies)
  29. Solved: Merge Cells (11 replies)
  30. Help Creating Pivot Table w/ Specific Consolidation Ranges (4 replies)
  31. right click menu in a text box (5 replies)
  32. Solved: Auto Tab (5 replies)
  33. Refresh Listbox (2 replies)
  34. Solved: Looping Images (7 replies)
  35. sheetchange problem (9 replies)
  36. stretch to a4 (7 replies)
  37. Solved: Programmatically add code to Workbook_Open (15 replies)
  38. Names like McNeed etc. (8 replies)
  39. Addin for work (9 replies)
  40. Solved: Programmatically add controls 2 (4 replies)
  41. Solved: Programmatically add controls (2 replies)
  42. Solved: Defining variable Ranges? (4 replies)
  43. Solved: Form to change sheets (8 replies)
  44. Solved: I want to make code smaller and more optomized (10 replies)
  45. How to use DoEvents in VBA (2 replies)
  46. Paste Format (4 replies)
  47. Solved: Find / FindNext question (6 replies)
  48. email active sheet problems (5 replies)
  49. Solved: Solved:Totaly stuck (13 replies)
  50. Time question (4 replies)
  51. Can someone help me solve this issue pls? (2 replies)
  52. A problem with user defined data type (31 replies)
  53. Solved: Deleting text boxes (8 replies)
  54. Replace a tilde with the corresponding headword (16 replies)
  55. Run .exe from VBA code (4 replies)
  56. Keypress on Datepicker (4 replies)
  57. Solved: Difficult... Macro to search multiple workbooks for a match? (30 replies)
  58. Solved: Next cell any direction (8 replies)
  59. Run macro on passw protected TAB (21 replies)
  60. Solved: Change focus or unload between forms (4 replies)
  61. Automation: EVT Logs to Excel (6 replies)
  62. Solved: Parent and Child workbook relationships (29 replies)
  63. Solved: REF TO A CELLS NAME (5 replies)
  64. Solved: copy specific cells sheet1 into form sheet2 (23 replies)
  65. Text Boxes Won?t Stay Visible on Charts (7 replies)
  66. Solved: Loop to check every row (26 replies)
  67. Solved: Transform general format in time format (12 replies)
  68. Solved: ALL UPPER CASE FONTS (6 replies)
  69. using inputbox (5 replies)
  70. Solved: Pivot table (1 replies)
  71. Excel data format query (39 replies)
  72. Hide Rows based on variable (3 replies)
  73. Calculate Date Difference excluding Weekend (Saturday & Sunday) (9 replies)
  74. Solved: progress bar (7 replies)
  75. How to highlight precedents of formula (6 replies)
  76. Solved: Adding features to an excel worksheet (36 replies)
  77. Solved: Select All and Unselect all (8 replies)
  78. Solved: Assign VBA Variable from Excel Cell (3 replies)
  79. Fctns LARGE & SMALL Don't Work in Cond Fmtting Formulas (1 replies)
  80. Max from a certain range (23 replies)
  81. Solved: Sheetprotection and Save dialog (6 replies)
  82. Solved: Upper/Lower Case (9 replies)
  83. Solved: Change to column if more than one item is checked (21 replies)
  84. Solved: Don't allow Special Characters (14 replies)
  85. Fit To pages wide (5 replies)
  86. Solved: Complele Daily Entries before Closing Worksheet (3 replies)
  87. Solved: Select sheet based a combobox value (43 replies)
  88. Protect/Unprotect Closed workbook (1 replies)
  89. Solved: Probem with comparing list code. (15 replies)
  90. VBA Cell locked (6 replies)
  91. Solved: CSV FILE (3 replies)
  92. Forcing printer to print landscape (4 replies)
  93. Excel Range Math - anyone have a lookup? (9 replies)
  94. Solved: Page break after each new customer (4 replies)
  95. Solved: Opening a Word document from Excel in the running instance of Word (5 replies)
  96. Solved: Stop the cursor in a loop (3 replies)
  97. Solved: How to Assign ?Define Name? to a Button on a Toolbar (8 replies)
  98. find and move data macro (6 replies)
  99. Solved: Macro for Custom Formatting (5 replies)
  100. How to get all texts from clipboard? (16 replies)
  101. Windows and Mac difference...Code wise (6 replies)
  102. Move files between directories (12 replies)
  103. Solved: Problem with array (6 replies)
  104. Solved: Unprotecting All Worksheets While Macro RUNS (8 replies)
  105. Excel Functions in VBA (17 replies)
  106. Solved: Delete empty rows and copy to another worksheet (12 replies)
  107. Auto Transfer (10 replies)
  108. Solved: Format cells in noncontiguous selected rows (2 replies)
  109. Solved: Copy/Paste within a Macro (9 replies)
  110. hyperlinking to a macro? (7 replies)
  111. List of last date sold and price (9 replies)
  112. Sleeper: Landscape if 2 pages wide? (3 replies)
  113. Solved: Auto completion of Dates (6 replies)
  114. Copy worksheets to new workbook - Teach Me? (9 replies)
  115. Solved: How to sort worksheets? (8 replies)
  116. Quick few questions (4 replies)
  117. ?Can?t Find Project or Library? (4 replies)
  118. count a numberformat (6 replies)
  119. SOLVED: How do you create a worksheet with a given name? (10 replies)
  120. Solved: Modify Personal.xls Not Trusted Error (3 replies)
  121. Application.Ready (22 replies)
  122. Solved: Help with VBA (12 replies)
  123. Transfering information (9 replies)
  124. Solved: Saving as xlExcel5 from Excel 2000 (4 replies)
  125. Solved: Password sensitivity (10 replies)
  126. A Simple search (4 replies)
  127. Running/storing macros independently of worksheet (6 replies)
  128. Excel VBA to Script (8 replies)
  129. Solved: Saving to various sections on the same sheet (32 replies)
  130. Calculate period of time, excluding non-working hours (7 replies)
  131. combobox (2 replies)
  132. Solved: Complete Data Entry Before Close (10 replies)
  133. Solved: Excel Error Lists...? (2 replies)
  134. Solved: Copying rows into worksheet - problem with macro (2 replies)
  135. Solved: Macro Calling (2 replies)
  136. Solved: Save only one sheet (9 replies)
  137. Solved: Excel to word at position (11 replies)
  138. Solved: About Windows Media Player on UserForm (6 replies)
  139. Sharing Macros (3 replies)
  140. Solved: Deleting Row if word ends in "a" in column A? (29 replies)
  141. Calculate thru VBA (3 replies)
  142. Solved: Importing Non English Text (5 replies)
  143. [SOLVED:] Copy and Paste Error between Application instances (14 replies)
  144. Compare between two lists project (1 replies)
  145. Changing data selected in a UserForm (28 replies)
  146. Solved: Add NETWORKDAYS to a date (3 replies)
  147. Solved: Delete Duplicate Rows based on multiple columns (14 replies)
  148. Insert a new row after a certain number of rows (22 replies)
  149. Solved: treeview in worksheet (18 replies)
  150. Solved: Linking columns in different tabs of the same file (3 replies)
  151. check for hyperlink (5 replies)
  152. Solved: How to create a DLL via VBA editor? (25 replies)
  153. Solved: Problems with ?MERGE? and ?xlCenterAcrossSelection? (9 replies)
  154. Conditionally format a cell the same as another cell upon a match (26 replies)
  155. Solved: Qanalys - Quantitative analys of Manuscripts (2 replies)
  156. Solved: Not displaying N/A but showing a blank "" (16 replies)
  157. Repeating search (9 replies)
  158. Solved: ToolTip for VBA checkbox in Excel (3 replies)
  159. Modeless Userform to act like "Find and Replace" modeless form (14 replies)
  160. Line chart (9 replies)
  161. Protecting coding (10 replies)
  162. Solved: Test for Null in Listbox Value (3 replies)
  163. Copying and pasting rows based on criteria in saved a list (1 replies)
  164. Solved: Combo Box help.... (2 replies)
  165. Print "Repeat rows from bottom of worksheet" (3 replies)
  166. comparing.... (1 replies)
  167. Merging-Copy Row-Marking Solved... (6 replies)
  168. Solved: What does this Dim mean? (5 replies)
  169. Print area... (11 replies)
  170. Userform? (3 replies)
  171. Solved: Number Format (6 replies)
  172. Chart, mark value that varies (10 replies)
  173. Location Change for a Chart (3 replies)
  174. view hyperlink on a userform (4 replies)
  175. Solved: Why Doesn?t This INDIRECT Work? (4 replies)
  176. Solved: Checking For Data In A Cell (5 replies)
  177. Conditional formatting (12 replies)
  178. Solved: Vlook up..? (8 replies)
  179. Conditional count (two conditions) (9 replies)
  180. How to retrieve the alphabets of a word (17 replies)
  181. Solved: How Do I Write This Formula? (2 replies)
  182. Macros (8 replies)
  183. Time difference (2 replies)
  184. Insert page break after each row that has a cell with a specified value (14 replies)
  185. Solved: Blackjack (10 replies)
  186. Solved: How to speed-up Macro? (9 replies)
  187. Solved: New Member-Formula act within a range (6 replies)
  188. Solved: A Loop? (20 replies)
  189. enable copy and paste (10 replies)
  190. Combinations (8 replies)
  191. Passing a Variable from a Form (12 replies)
  192. Excel 2007 and Date of Easter (25 replies)
  193. Multiple language support in excel (0 replies)
  194. MSXML2 - getElementsByTagName() (2 replies)
  195. Solved: Make enable-disable a special toolbar depended a condition? (25 replies)
  196. Run time 1004 error in VBA (5 replies)
  197. Solved: Problem with Formulas (2 replies)
  198. Problem understanding formula for weekdays. (2 replies)
  199. Using Average command (4 replies)
  200. Macro speed (27 replies)
  201. Progress.dll not found (4 replies)
  202. Solved: Move Files to New Directory Yearly and Save as YYYY (19 replies)
  203. multi column list box and combobox (19 replies)
  204. Solved: printing multiple workbooks from a check list (14 replies)
  205. Conditional Sum....is this possible? (2 replies)
  206. Solved: conditional delete of shape(s) (11 replies)
  207. Solved: Clear cell content from protected cells (4 replies)
  208. Solved: With security in mind, which concept rates higher? (6 replies)
  209. Solved: Skip Blank Cells (2 replies)
  210. Formula to Show Julian Date (5 replies)
  211. Solved: Repairing Defined Names (6 replies)
  212. Solved: Transfer new Color Scheme to Existing (7 replies)
  213. Solved: Formula in moving array (4 replies)
  214. loop in creating oleobjects (5 replies)
  215. Email + Attachment w/GroupWise (1 replies)
  216. Solved: How Do I Count 2 (2 replies)
  217. Solved: Concatenation (15 replies)
  218. How to get a list of avaiable network printers. (7 replies)
  219. [SOLVED:] Multiple Columns to Single Column (3 replies)
  220. Formula with no error message? (3 replies)
  221. Workbook unprotects after running macro... (6 replies)
  222. Solved: Toggle between 2 workbooks (5 replies)
  223. How to write in a closed workbook (28 replies)
  224. Need Help with hyperlinking (2 replies)
  225. Macro with two different sheets (8 replies)
  226. Solved: Adding an extra range to formula? (22 replies)
  227. Solved: Identify column number from address (2 replies)
  228. Solved: Cell format problem (2 replies)
  229. Launching .lnk and url's from excel buttons (3 replies)
  230. Solved: How do you post "Solved" (2 replies)
  231. Solved: Stop VBA Code From Running when Opening an Excel File?? (3 replies)
  232. OXO' Game in VBA, against CPU (4 replies)
  233. Process files from directory and hyperlink them (2 replies)
  234. copy cells from xml to word: loop through files (1 replies)
  235. Create Object (2 replies)
  236. Solved: Incomplete ADO load (8 replies)
  237. workbook full path (3 replies)
  238. Shape - Gradient Fill (3 replies)
  239. Msgbox Disabling (6 replies)
  240. [SLEEPER:] Top and Left properties for images (3 replies)
  241. Solved: Combine Dynamic Range (9 replies)
  242. Solved: MsgBox problem.. (18 replies)
  243. Excel Alarm/Alert Code (6 replies)
  244. Find (3 replies)
  245. Solved: hide and protect column (11 replies)
  246. Multiple/Dynamic Conditional Formating (7 replies)
  247. Writing to a PDF file from Excel (3 replies)
  248. I Want Get =EMBED("Forms.ListBox.1";"")'s Value to Cell... (3 replies)
  249. Solved: Find or Match - to delete column (4 replies)
  250. Solved: Loop all columns, sheets, files in folder and copy cells (1 replies)