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: cell contents were missing once i reopen a file (4 replies)
  2. Solved: Excel 2003 How can I delete a specific shape type within the ActiveSheet (2 replies)
  3. Solved: Excel 2003 Change Event to concatenate Column 8 value to Column 12 Value (2 replies)
  4. Solved: vlookup:Search from bottom row instead of top row (3 replies)
  5. [SOLVED:] Compare/Copy new location. Isn't working! (4 replies)
  6. Check FirstName&LastName duplicates (1 replies)
  7. Solved: Combine cells values from two sheets into 1 cell (2 replies)
  8. Solved: Compare/replace based on equivalence list (10 replies)
  9. Solved: Upload file into website (2 replies)
  10. Cmd button for Redo Function (1 replies)
  11. Code for formatting Email from Excel (0 replies)
  12. Identifying pdf charts by VBA (0 replies)
  13. Combining OFFSET and VLOOKUP (1 replies)
  14. Solved: Activating Java table with Vba (3 replies)
  15. Grouping cells so that they can be sorted together in excel (0 replies)
  16. Solved: Value Function (2 replies)
  17. Solved: Excel’s Speak Cells feature (3 replies)
  18. Unwanted change of font while pasting into Word (3 replies)
  19. How do i Copy numbers only. (4 replies)
  20. Opening UTF-16 text file with VBA (3 replies)
  21. Solved: just values insted formula (3 replies)
  22. Data Input Restrictions (7 replies)
  23. Simple Sheet copy problem: Workbook to Workbook (2 replies)
  24. Solved: Data Validation (2 replies)
  25. check if userform is visible (5 replies)
  26. Solved: Make a chart from 1 column (2 replies)
  27. Update Sales Territory Shifts/Changes through VBA (8 replies)
  28. I need a simple code. (1 replies)
  29. Solved: Close Worksheet Macro (4 replies)
  30. SUMPRODUCT (10 replies)
  31. Deleting a Record from a Worksheet (4 replies)
  32. Solved: Deactivate Commandbutton and Hide (10 replies)
  33. Sleeper: Internet Explorer Form Automation (0 replies)
  34. Undead Data, or: what's a "block of data", anyway? (5 replies)
  35. Moving Data to Another Worksheet (2 replies)
  36. Upload using VBA to a Google Sites Filing cabinet (0 replies)
  37. Create a block diagram from text (8 replies)
  38. Master Workbook linked to Two Workbooks (0 replies)
  39. Solved: Number fill - randomly (5 replies)
  40. Solved: using macro to edit macro (4 replies)
  41. Force save another open workbook (7 replies)
  42. How to Hide Specified Cells? (3 replies)
  43. Solved: Paste from Excel to Word (9 replies)
  44. Solved: How to return a worksheet name based on found data (2 replies)
  45. Find and replace tab names (4 replies)
  46. Nest do loops (13 replies)
  47. Solved: deleting specific words from a cell (10 replies)
  48. copy sheet based on list of names once only (11 replies)
  49. Solved: New to VBA (4 replies)
  50. set y = “the row number” at which the button I click locates (3 replies)
  51. What is the MaxLocksperfile property? (2 replies)
  52. how to reset the value of .FileSearch to null or nothing? (7 replies)
  53. Solved: Statusbar black on black (0 replies)
  54. Inserting pictures and the path. (4 replies)
  55. User Defined Function and calculate (5 replies)
  56. Keeping Cells that are Conditional Formated when Sorting Data (9 replies)
  57. [SOLVED:] Read Only Prompt When Saving (4 replies)
  58. Send Mail range to each person (13 replies)
  59. Consolidation of various files based on cell value/Filter (1 replies)
  60. ComboBox crashes in 2002, SP3 but works fine in 2010 (2 replies)
  61. Find all function returns the cell or the value? (11 replies)
  62. Solved: Creating folder (2 replies)
  63. Help plotting a graph in VBA (3 replies)
  64. ExcelDiet (5 replies)
  65. Need Help with controlling internet using Excel Macro !!! (1 replies)
  66. double vlookup (1 replies)
  67. Solved: Vlookup/Match (1 replies)
  68. deny changes after entering data (2 replies)
  69. Problem installing Format Functions add-in (5 replies)
  70. click a button to open a picture (8 replies)
  71. Solved: Hiding 120 tabs (6 replies)
  72. Solved: Modifying Data in a Worksheet from a Userform (7 replies)
  73. Solved: extracr specific data from a file (14 replies)
  74. Solved: How to find subtotals from formula currency converted cells (4 replies)
  75. [SOLVED:] Compare a cell with another cell (1 replies)
  76. Cannot Insert Object (3 replies)
  77. Solved: Find the words "*-*Shares" from ColF and move to ColG (3 replies)
  78. Formula or Macro? Help (5 replies)
  79. Delimiting a cell to the rows below (8 replies)
  80. Solved: index, match (13 replies)
  81. Selecting a range for a barchart in vba (1 replies)
  82. Tab Error on CSV File (2 replies)
  83. simple chart with 2 yaxes and 1 x axes (0 replies)
  84. Modifying Data on Another Worksheet (0 replies)
  85. Solved: find values separated by a slash (4 replies)
  86. Syntaxes for Worksheets and RC formula (2 replies)
  87. Force fullscreen mode (5 replies)
  88. Hooking LIstBox in Class Module (2 replies)
  89. How to get information from a ListBox to an Excel Worksheet (3 replies)
  90. Autofilter in VBA for selected string in a cell (3 replies)
  91. Solved: Unwanted hiding of a column (3 replies)
  92. running count if total (5 replies)
  93. Solved: Modifying the Search to include Searching in another worksheet (0 replies)
  94. Solved: Force close (4 replies)
  95. Denying a cell to be changed in any way (20 replies)
  96. Excel VBA Automation of Internet Explorer (11 replies)
  97. Return "0" instead of "N/A" in Pivot Table reference (1 replies)
  98. Userform - Copy active row and move to last row (4 replies)
  99. Solved: Deleting blank spaces in front and after a number in a cell (4 replies)
  100. Prevent duplicate entries in two sheets (13 replies)
  101. Sum data if week number is <= current weeknumber (4 replies)
  102. Not able to retrieve historic values - link updating issues (0 replies)
  103. Positive (3 replies)
  104. Solved: vlookup for part of word with separator (4 replies)
  105. Deselect Object (5 replies)
  106. Hyperlink to another sheet (1 replies)
  107. copy form one WB and paste in a different WB (9 replies)
  108. Solved: delete rows without open files (5 replies)
  109. Screen updating with textboxes/labels (14 replies)
  110. How to set an object type dynamically? (1 replies)
  111. How to find an object's type? (18 replies)
  112. Solved: Run time error 91: Object variable or with block variable not set (2 replies)
  113. setting dynamically (1 replies)
  114. Running macros after converting excel files to exe files? (1 replies)
  115. Solved: Excel macro for &quot;=sum()&quot; (5 replies)
  116. Solved: scheduled task question (7 replies)
  117. VBA Save As with Password (4 replies)
  118. Solved: Excel2003 - Hide Col2 in Sheet1 &amp; Sheet2 Very Hidden, if Workbook Opened as Read Only (3 replies)
  119. Solved: Maing sure xlCalculationAutomatic = true (8 replies)
  120. Solved: Forcing User To Enable Macros (2 replies)
  121. Solved: Need to sort Excel by Colored Row, and Cell values (5 replies)
  122. Solved: Need to append todays date as text to the end of the selected Cell Text (2 replies)
  123. Generate / Create PDF using VBA and Password protect PDF (8 replies)
  124. Procedure dependable on multiple constants? (6 replies)
  125. Solved: Call to other sub within a sub (10 replies)
  126. split one column to three column in other sheet (10 replies)
  127. Search Range and Delete any Blank Rows (7 replies)
  128. macro calling another macro (4 replies)
  129. Solved: Send Email with a link to the Excel file (2 replies)
  130. macro Code Short Cut to Hide Column (6 replies)
  131. Solved: clear contents based on conditions (2 replies)
  132. Solved: Macro to Hide Columns Based on Options? (4 replies)
  133. Solved: Activate open workbook (15 replies)
  134. Solved: 2 VBA-Projects named the same after saving/opening file (3 replies)
  135. Solved: Check if workbook is open or is active workbook (10 replies)
  136. Solved: Copy Values and Formats to a new workbook VBA (6 replies)
  137. Find And Replace - Excel 2007 - VBA (2 replies)
  138. Solved: Import Class file from Visual Studio to Excel (1 replies)
  139. How to locate nth Visible cell in the filtered columns? (3 replies)
  140. Web query VBA (3 replies)
  141. External Data SQL Server & Destination (1 replies)
  142. File.Search Alternative for Excel 2007 (8 replies)
  143. Solved: loop through named area (8 replies)
  144. Specify the position of a Minimized Userform (2 replies)
  145. Solved: Copy Data from One Sheet to another if cell is NOT empty (3 replies)
  146. Web query and 'splash' screen (2 replies)
  147. How to do this? (1 replies)
  148. Solved: Drop Down Data Validation - Quirks (8 replies)
  149. Summarize data (1 replies)
  150. Solved: how can change the same data raw selected in ListBox? (2 replies)
  151. Selection of sheets to run VBA routine (3 replies)
  152. Solved: Counter Number Non start with 1 (5 replies)
  153. finding active inernet url (2 replies)
  154. VBA Excel Macro Copy/Paste Rows (2 replies)
  155. Solved: Load data into TreeView (15 replies)
  156. Solved: Help with Formula please (3 replies)
  157. Solved: independents from system separators (1 replies)
  158. [SOLVED:] Getting a filename Into a cell content (9 replies)
  159. How to pass a part of a Nested Array to a function? (4 replies)
  160. Autofilter Macro with 3 criteria in 1 field (4 replies)
  161. Excel macro help (1 replies)
  162. Error (4 replies)
  163. Need code for automated summary (6 replies)
  164. Open then Close Workbook with userforms (1 replies)
  165. Solved: How to refer to a range? (1 replies)
  166. Run-time error '9' Problem (1 replies)
  167. Solved: Code makes excel crash! (6 replies)
  168. Solved: Problem starting app from Range (8 replies)
  169. Solved: Close excel if last open workbook (3 replies)
  170. Solved: Cell Protection (5 replies)
  171. Opening files in a folder with a certain word in filename (1 replies)
  172. Solved: summed one, two or more textboxes in mathematical way (6 replies)
  173. Solved: opening a file using textbox and combobox as the destination path and filename (2 replies)
  174. Solved: Copy cells + manual input! (10 replies)
  175. Solved: Commandbutton visibility (5 replies)
  176. How to create a macro that will produce a csv file from a button (3 replies)
  177. Syntax error (3 replies)
  178. Solved: Hide columns (2 replies)
  179. [SOLVED:] Copy cell from diferrent workbook (7 replies)
  180. Solved: ClosedWorkbook/Filter (3 replies)
  181. Unzip code error (2 replies)
  182. Solved: CSV to ASCII (7 replies)
  183. Compare 3 Columns and Return all Matches (1 replies)
  184. Solved: problem in opening a specific filename (2 replies)
  185. Combine (1 replies)
  186. Solved: Help with Checkboxes and OptionButton (15 replies)
  187. combobox change event loop (4 replies)
  188. copy sheet to workbook; with new sheet name (5 replies)
  189. Solved: how can i code the micro to copy cell value to deferment row? (2 replies)
  190. Solved: Different terms for saving a file (6 replies)
  191. Solved: how to convert first later to upper case and after onward lower case? (3 replies)
  192. Error Problem (4 replies)
  193. Solved: Highlight unlisted names (14 replies)
  194. Solved: Open a &quot;variable.exe&quot; (4 replies)
  195. Solved: Undo &amp;amp; redo macro (3 replies)
  196. Solved: Messagebox in macro (2 replies)
  197. Solved: VBA Form Problem (3 replies)
  198. autostart Macro with Date and Time (2 replies)
  199. Adjusting Page Layout for printing (0 replies)
  200. Solved: Auto Fill (4 replies)
  201. Solved: cells from tables sumed + checkboxes (3 replies)
  202. Solved: Cells not being Locked correctly! (2 replies)
  203. Close workbook (11 replies)
  204. Autosolved - basic working with PDF (14 replies)
  205. Hide Any New Column Fields in Pivot Table (0 replies)
  206. Command Button To Save & Close (3 replies)
  207. Error 70 Permission Denied (1 replies)
  208. Solved: Find &amp; clear blank rows (5 replies)
  209. Solved: multiple if formula and checkbox (6 replies)
  210. Matching failed (19 replies)
  211. Solved: Changing Range for Formula (9 replies)
  212. Help Splitting levels from Pivot Table into a table. (4 replies)
  213. Solved: Userform to Userform (6 replies)
  214. Run-time error: 9 Subscript Out of Range (4 replies)
  215. FIX code for search variable from copy excel cell or clipboard (1 replies)
  216. A macro used to migrate data from a csv file into ms excel 2007 (3 replies)
  217. Solved: extract data in row 1 of sheet 1 into sheet 2 (5 replies)
  218. creating a macro on a button to search for a file (8 replies)
  219. Solved: Read in value to use as array size (2 replies)
  220. Solved: Data Form (5 replies)
  221. workbook on server close (1 replies)
  222. Solved: Sort Problem 2003 to 2007 (9 replies)
  223. Application.SendKeys not working (2 replies)
  224. Solved: Extract Multiple State or cities names - excel function (5 replies)
  225. Create table from list (4 replies)
  226. Solved: Worksheet Consolidation of Rows that Meet Certain Criteria (1 replies)
  227. Scroll bar continuing to change after one click (1 replies)
  228. Resorting document using VBA (3 replies)
  229. AutoFilter and Non Contiguous Ranges (1 replies)
  230. Solved: find number in string (6 replies)
  231. Solved: Extract State names - excel function (3 replies)
  232. Excel Export to Webpage Form Fields (2 replies)
  233. Solved: Date formula (17 replies)
  234. v-lookup to order a column in alphabetical order (2 replies)
  235. Solved: Populate ListBox from Worksheet Data (13 replies)
  236. Solved: Vlookup error (7 replies)
  237. [SOLVED:] how to find next but a new word? (14 replies)
  238. [SOLVED:] combine contents from a column (9 replies)
  239. Solved: insert picture (8 replies)
  240. Writing and understanding equations using excel (1 replies)
  241. Need macros or something similar (5 replies)
  242. Solved: counting with text help (3 replies)
  243. Solved: need help with a check (4 replies)
  244. different the Capital letter in 1st 5 character using VBA excel 2003 (1 replies)
  245. Loop (4 replies)
  246. Adding lines that affect formula (18 replies)
  247. Solved: Populating Userform under specific cells (7 replies)
  248. Restricted Access to Folders (2 replies)
  249. search and compare (1 replies)
  250. Matching imported hyperlinks to another cell (4 replies)