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: VBA to write a formula while referencing a Named Range (3 replies)
  2. Range cells combination problem (4 replies)
  3. Copy paste data based on criteria in a loop (3 replies)
  4. Sleeper: Looks for some codes than copy (5 replies)
  5. Finding the text Dismantle and filling respective row with a color then copy All Dism (1 replies)
  6. Solved: run-time save file as 2007 (8 replies)
  7. Import Data Help (8 replies)
  8. Solved: Range("A4").End(xlDown) Error (5 replies)
  9. Solved: Every other line (5 replies)
  10. sheetbeforerightclick and addin (1 replies)
  11. Solved: linking to a range of cells (12 replies)
  12. Solved: summing range (21 replies)
  13. Need help copying cell values to email body (3 replies)
  14. Problems with Range property (4 replies)
  15. column name (4 replies)
  16. Solved: Excel running inside Internet Explorer (5 replies)
  17. Is this possible (1 replies)
  18. Solved: pivot table issue (6 replies)
  19. Solved: case statement for sheets (6 replies)
  20. Solved: Save and Close automatically if inactive (2 replies)
  21. [SLEEPER:] Prevent Modification of a Range via VBA Instead of Sheet Protection (4 replies)
  22. Dbl Click in cell(dot) ? (5 replies)
  23. Solved: Worksheet_Change Question (20 replies)
  24. AR Aging - will not skip blank cells (6 replies)
  25. Solved: Clear Cells Except Cells with Formula (11 replies)
  26. Dialog Box in Insert option (1 replies)
  27. Creating a new CSV file using VBA code (5 replies)
  28. Solved: Summing range and copying accross (5 replies)
  29. RefEdit in non-modal form (2 replies)
  30. Solved: Previous Month (2 replies)
  31. Solved: How to open a form from another form (4 replies)
  32. [SOLVED:] Incremental Loop (22 replies)
  33. Imported array and vlookup named range (2 replies)
  34. Solved: Self Closing Message Box (8 replies)
  35. Solved: Change Cell Colors VBA (3 replies)
  36. Solved: Countif conditions (2 replies)
  37. Solved: Form not Uploading (21 replies)
  38. Solved: Find cell value from a range & resize and copy to a worksheet (5 replies)
  39. Loading a Picture gives Runtime Error 424 (4 replies)
  40. Solved: Graph populated by Dropdown (10 replies)
  41. Solved: show/hide label/textbox based value (2 replies)
  42. MMUlt not working (6 replies)
  43. Email Active Worksheet using Groupwise - HELP (0 replies)
  44. Trying to Automation Scheduler via VBA or Formula (0 replies)
  45. Solved: Omitting Path in ActiveWorkbook.Saveas (6 replies)
  46. Solved: CONCATENATE - help needed (3 replies)
  47. Solved: populate ComboBox from text (13 replies)
  48. Solved: Rename sheet using NOW function ??? (5 replies)
  49. Adding combo box values thro VBA (5 replies)
  50. Sleeper: Copy/Paste results of an if & else from all wrksheets to a wrksheet (0 replies)
  51. Solved: VBA Reporting Too Many Worksheets (4 replies)
  52. Solved: Creating Buttons (4 replies)
  53. programmatically copying a sheet (2 replies)
  54. Solved: DATE Difference (3 replies)
  55. [SOLVED:] Paste Special / Values / Transpose (7 replies)
  56. xls to 2007 file type (4 replies)
  57. Help - Need to Lock all cells in range if Column Header <> Today (3 replies)
  58. Solved: Formula Problems (1 replies)
  59. Solved: Folder Size within a directory - tweak code (7 replies)
  60. Results of my equation and function don't match (5 replies)
  61. last row variable in auto filter (3 replies)
  62. Solved: Removing Duplicates In Excel (1 replies)
  63. Solved: Various formulae Questions (13 replies)
  64. [SOLVED:] date formats changing in filter? (2 replies)
  65. Turning cariage returns into new column in excel (3 replies)
  66. [SOLVED:] toggleButtons... (1 replies)
  67. Open a word document from a webpage (2 replies)
  68. Solved: How to Delete Diagonal (Border) Lines (5 replies)
  69. Solved: Creating &quot;At and Angle&quot; Symbol in VBA (16 replies)
  70. Paste / Special / Transpose Code (2 replies)
  71. Solved: Random Vocabulary Terms (5 replies)
  72. Solved: delete rows (5 replies)
  73. COPY FROM CELL (4 replies)
  74. Solved: Automating a Macro (16 replies)
  75. Downloading attachment from a specific user's email to hard disk, deleting the mail (2 replies)
  76. Code Stopped Working..sort of... (12 replies)
  77. Filtered Mode Copying and pasting as value yield as error? (1 replies)
  78. Extracting A Substring (4 replies)
  79. Solved: Get data from web page and paste to excel (21 replies)
  80. Downloading a non-excel file from server through Excel (0 replies)
  81. Solved: XLAM file replacement (7 replies)
  82. Complex Number Matrix Multiplication (2 replies)
  83. Solved: uncalled for msg (2 replies)
  84. Solved: Give result for duplications (2 replies)
  85. Solved: search help (6 replies)
  86. Solved: Entering Negative numbers (1 replies)
  87. Solved: Hiding Unused Rows (3 replies)
  88. Solved: need space in titled saveas (4 replies)
  89. Finding data range reference for a series in chart using vba (7 replies)
  90. [SOLVED:] Problem with Range using Auto Filter (8 replies)
  91. Select & drag all fields to Data area in Pivot in one key stroke (8 replies)
  92. Solved: Setting Paramaters for Builtin Dialogs (11 replies)
  93. VBA to copy/paste etc.. (6 replies)
  94. Solved By Xld Hit A Snag (14 replies)
  95. Solved: Row reference through selection in custom Function (8 replies)
  96. Autofilter function 2003 vs 2007 (1 replies)
  97. Solved: vba dir() need sorting by filename (1 replies)
  98. Solved: Move Row by Row in a listbox??? (2 replies)
  99. Solved: Adding Calculation code (9 replies)
  100. Solved: Excel VBA Sort with user Input (8 replies)
  101. Solved: Bottom controlled Do While loop (4 replies)
  102. Solved: Company Name and Full URL Separation (3 replies)
  103. Solved: Using Sumproduct to Calculate Weekly Totals (9 replies)
  104. Paste/Special/Values (3 replies)
  105. Solved: Combine worksheets - Specifying one sheet name from multiple workbooks to combine (12 replies)
  106. VBA to Filter Excel Data to a Different Sheet (2 replies)
  107. Solved: moving files greater than 1mg (4 replies)
  108. Solved: Resize a Cell thru Macro (2 replies)
  109. Solved: Refresh Pricing Data --&gt; Date (6 replies)
  110. Solved: Code for not found (11 replies)
  111. Automatically updating pivot tables (2 replies)
  112. Solved: Save a Worksheet using VBA with more then 255 Characters (6 replies)
  113. Copy many workbooks into one master Workbook (5 replies)
  114. Solved: Converting FY formula into a VBA (5 replies)
  115. Solved: Disable UserForm OK icon until a selection has been made (3 replies)
  116. Foreign version of excel (1 replies)
  117. [SOLVED:] Export excel rows to doc (7 replies)
  118. stopwatch in Excel (2 replies)
  119. letters help (1 replies)
  120. How to count days between Months? (1 replies)
  121. Conditional Formatting of cells (5 replies)
  122. Total Months in Between Two Dates (4 replies)
  123. Solved: Form Help (3 replies)
  124. Solved: Code Runs on Excel 2000 but not on Excel 2002 (3 replies)
  125. macro help (3 replies)
  126. Delete rows with blank cells, do not check column A (3 replies)
  127. Solved: OpenText Method and Find Replace Syntax (10 replies)
  128. COPY DATA (9 replies)
  129. [SOLVED:] Insert blank rows automatically - based on cell value (4 replies)
  130. Solved: Conditional Format for percentage (2 replies)
  131. timer code (2 replies)
  132. Import multiple photos into excel (0 replies)
  133. error 1004 (5 replies)
  134. Solved: Copy row down based on last row of different sheet (4 replies)
  135. Adding numerous named ranges (4 replies)
  136. Compile Error Variable not Defined (2 replies)
  137. Disable Drag & Drop/Cut & Paste on worksheet (1 replies)
  138. [SOLVED:] Option Buttons in UserForm (3 replies)
  139. Solved: Userform checkbox active checkbox in sheet (3 replies)
  140. Error creating PP slide from Excel within IE (0 replies)
  141. Solved: Arrays of Array (7 replies)
  142. Solved: Generate Email BCC from Column of Email Addresses (19 replies)
  143. VBA Code: Reorganise data (1 replies)
  144. Solved: Multi line Msgbox (5 replies)
  145. copy cell without range (2 replies)
  146. Sleeper: Data entry validations (0 replies)
  147. dynamic search content (2 replies)
  148. find code & select multiple lines (2 replies)
  149. Transferring data from a closed workbook (1 replies)
  150. Solved: Testing entries in a text box (5 replies)
  151. unreadable content (1 replies)
  152. Get the name of the workbook on a different workbook (0 replies)
  153. How to stop screen flashing (2 replies)
  154. pull data from multiple workbooks....cell vs range (3 replies)
  155. Match up data (12 replies)
  156. Pivot table code (3 replies)
  157. OPEN a file,COPY a range and PASTE it (5 replies)
  158. Solved: Need to auto-populate a Status Indicator (2 replies)
  159. Solved: VLOOKUP Problem (9 replies)
  160. Solved: I need a &quot;MATCH&quot; help (2 replies)
  161. [SOLVED:] Handle to ribbon controls (4 replies)
  162. Filling an excel range from a vb function (7 replies)
  163. [SOLVED:] Name not getting captured in 2 input userform (12 replies)
  164. Solved: Enter date in a cell (4 replies)
  165. Solved: Replacing Special Characters &amp; Symbols (10 replies)
  166. Userform textbox and calendar formula (2 replies)
  167. Need help to solve this critical scenario (9 replies)
  168. Accessing Worksheets (4 replies)
  169. List selection in pivot table report filter (2 replies)
  170. An impossible search and paste?Maybe not (6 replies)
  171. Solved: Help with VBA &amp; html spidering/downloading! (5 replies)
  172. Solved: Save outlook message in Excel (2 replies)
  173. Sort in a Shared Workbook (1 replies)
  174. Solved: Automatically Populate dropdown for each new worksheet created (9 replies)
  175. Solved: VBA timer trouble (9 replies)
  176. [SLEEPER:] Object Required Error (5 replies)
  177. VB date error and transitioning to Case (2 replies)
  178. Solved: Find by phrase (22 replies)
  179. Conditional drop down lists (2 replies)
  180. Solved: excel help - adding checkboxes to sheet (6 replies)
  181. Need Listbox to be stored. (1 replies)
  182. column (3 replies)
  183. AVERAGE PROBLEM (3 replies)
  184. How do I take an output of a macro and place it into a single cell (3 replies)
  185. Solved: Need Help With Methodology (7 replies)
  186. Error message (11 replies)
  187. Disabling Toolbars in 2003 (2 replies)
  188. Activating mouse scroll wheel in listbox (7 replies)
  189. Cascading combo boxes from SQL Server (3 replies)
  190. Micro for TAT (9 replies)
  191. Solved: OPEN FILE (10 replies)
  192. Solved: How do I export my xls correctly? (2 replies)
  193. Excel file close (4 replies)
  194. Solved: Custom Array function for calculating variance (5 replies)
  195. Run-Time Error 3704 with ADO & SQL (1 replies)
  196. MAX and MIM problem in Arrays (1 replies)
  197. Solved: Using Variables in Named Ranges (7 replies)
  198. VBA Create Charts (0 replies)
  199. Solved: wildcard use with xlSheetVeryHidden ? (2 replies)
  200. Solved: Sorting using range names (4 replies)
  201. VBA - GOTO named range (1 replies)
  202. How do i Configure the I.E within Excel (2 replies)
  203. Solved: VBA Subscript out of range errors on sheet code (3 replies)
  204. Creating conditional lists using VBA (2 replies)
  205. Wrap text in text box (4 replies)
  206. time format display (3 replies)
  207. Solved: Delete select columns (2 replies)
  208. Manipulating Shapes in VBA (7 replies)
  209. Solved: BeforeClose not firing on hidden personal.xls (7 replies)
  210. Solved: date conversion macro (7 replies)
  211. Solved: How to answer the msg box automatically? (6 replies)
  212. Solved: Prevent save as .xlsx (8 replies)
  213. Solved: MIN formula (7 replies)
  214. Solved: Using msoFileDialogFilePicker (10 replies)
  215. Password Protected drives (1 replies)
  216. Change Application width of active worksheet focus (2 replies)
  217. simple loop macro (3 replies)
  218. Excel data Connections to pull data (0 replies)
  219. Solved: LOOKUP, But Exact match (8 replies)
  220. Need help with a Formula Creation (1 replies)
  221. Solved: Populate listbox based on folder contents (3 replies)
  222. Solved: Macro To Loop through a column in the workbook (4 replies)
  223. Solved: Open 1st workbook from userform in workbook 2 (11 replies)
  224. Solved: Sort - convert code to work on 2003 ? (2 replies)
  225. Formula Error Message in Excel 2007 Sheet (6 replies)
  226. Solved: Select Specific Cell Range (2 replies)
  227. [SOLVED:] Delete Rows based on Multiple Cell Criteria (8 replies)
  228. get data from other excel files dynamically (6 replies)
  229. Solved: Shell command to open pdf file in Acrobat 8.0 (3 replies)
  230. Hyperlink Error - Need Help! (2 replies)
  231. Excel screen stretching (4 replies)
  232. Solved: Difference between two times - Macro (4 replies)
  233. Writing the character " into Cell (4 replies)
  234. Dynamicalyy set range depending on the populated cells (4 replies)
  235. delete value (4 replies)
  236. cells value (2 replies)
  237. Solved: Set Range depending on font colour (7 replies)
  238. Unable to Assign a Macro to a "Shape" in Excel 2007 (3 replies)
  239. Solved: Some sheets no hyperlinks. (7 replies)
  240. Change Font Within Formula (4 replies)
  241. Solved: vb &quot;Upper&quot; (2 replies)
  242. Calendar Control 12.0 enquiry (3 replies)
  243. Solved: Personal.xls not loading - usual solutions not working (8 replies)
  244. Monthly repayments (10 replies)
  245. Extracting a specific part from a string (5 replies)
  246. OLEObjects.Add and Worksheet_Change event (2 replies)
  247. Data Validation Question (17 replies)
  248. Moving cells from 1 line to another (5 replies)
  249. Browse Folder (16 replies)
  250. Solved: Cell value from cell in different sheet (2 replies)