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. Syntaxes for Worksheets and RC formula (2 replies)
  2. Force fullscreen mode (5 replies)
  3. Hooking LIstBox in Class Module (2 replies)
  4. How to get information from a ListBox to an Excel Worksheet (3 replies)
  5. Autofilter in VBA for selected string in a cell (3 replies)
  6. Solved: Unwanted hiding of a column (3 replies)
  7. running count if total (5 replies)
  8. Solved: Modifying the Search to include Searching in another worksheet (0 replies)
  9. Solved: Force close (4 replies)
  10. Denying a cell to be changed in any way (20 replies)
  11. Excel VBA Automation of Internet Explorer (11 replies)
  12. [SLEEPER:] Return "0" instead of "N/A" in Pivot Table reference (1 replies)
  13. Userform - Copy active row and move to last row (4 replies)
  14. Solved: Deleting blank spaces in front and after a number in a cell (4 replies)
  15. Prevent duplicate entries in two sheets (13 replies)
  16. Sum data if week number is <= current weeknumber (4 replies)
  17. Not able to retrieve historic values - link updating issues (0 replies)
  18. Positive (3 replies)
  19. Solved: vlookup for part of word with separator (4 replies)
  20. Deselect Object (5 replies)
  21. Hyperlink to another sheet (1 replies)
  22. copy form one WB and paste in a different WB (9 replies)
  23. Solved: delete rows without open files (5 replies)
  24. Screen updating with textboxes/labels (14 replies)
  25. How to set an object type dynamically? (1 replies)
  26. [SLEEPER:] How to find an object's type? (18 replies)
  27. Solved: Run time error 91: Object variable or with block variable not set (2 replies)
  28. setting dynamically (1 replies)
  29. Running macros after converting excel files to exe files? (1 replies)
  30. Solved: Excel macro for &quot;=sum()&quot; (5 replies)
  31. Solved: scheduled task question (7 replies)
  32. VBA Save As with Password (4 replies)
  33. Solved: Excel2003 - Hide Col2 in Sheet1 &amp; Sheet2 Very Hidden, if Workbook Opened as Read Only (3 replies)
  34. Solved: Maing sure xlCalculationAutomatic = true (8 replies)
  35. Solved: Forcing User To Enable Macros (2 replies)
  36. Solved: Need to sort Excel by Colored Row, and Cell values (5 replies)
  37. Solved: Need to append todays date as text to the end of the selected Cell Text (2 replies)
  38. Generate / Create PDF using VBA and Password protect PDF (8 replies)
  39. Procedure dependable on multiple constants? (6 replies)
  40. Solved: Call to other sub within a sub (10 replies)
  41. split one column to three column in other sheet (10 replies)
  42. Search Range and Delete any Blank Rows (7 replies)
  43. [SLEEPER:] macro calling another macro (4 replies)
  44. Solved: Send Email with a link to the Excel file (2 replies)
  45. macro Code Short Cut to Hide Column (6 replies)
  46. Solved: clear contents based on conditions (2 replies)
  47. Solved: Macro to Hide Columns Based on Options? (4 replies)
  48. Solved: Activate open workbook (15 replies)
  49. Solved: 2 VBA-Projects named the same after saving/opening file (3 replies)
  50. Solved: Check if workbook is open or is active workbook (10 replies)
  51. Solved: Copy Values and Formats to a new workbook VBA (6 replies)
  52. Find And Replace - Excel 2007 - VBA (2 replies)
  53. Solved: Import Class file from Visual Studio to Excel (1 replies)
  54. How to locate nth Visible cell in the filtered columns? (3 replies)
  55. Web query VBA (3 replies)
  56. External Data SQL Server & Destination (1 replies)
  57. File.Search Alternative for Excel 2007 (8 replies)
  58. Solved: loop through named area (8 replies)
  59. Specify the position of a Minimized Userform (2 replies)
  60. Solved: Copy Data from One Sheet to another if cell is NOT empty (3 replies)
  61. Web query and 'splash' screen (2 replies)
  62. How to do this? (1 replies)
  63. Solved: Drop Down Data Validation - Quirks (8 replies)
  64. Summarize data (1 replies)
  65. Solved: how can change the same data raw selected in ListBox? (2 replies)
  66. Selection of sheets to run VBA routine (3 replies)
  67. Solved: Counter Number Non start with 1 (5 replies)
  68. finding active inernet url (2 replies)
  69. VBA Excel Macro Copy/Paste Rows (2 replies)
  70. Solved: Load data into TreeView (15 replies)
  71. Solved: Help with Formula please (3 replies)
  72. Solved: independents from system separators (1 replies)
  73. [SOLVED:] Getting a filename Into a cell content (9 replies)
  74. How to pass a part of a Nested Array to a function? (4 replies)
  75. Autofilter Macro with 3 criteria in 1 field (4 replies)
  76. Excel macro help (1 replies)
  77. Error (4 replies)
  78. Need code for automated summary (6 replies)
  79. Open then Close Workbook with userforms (1 replies)
  80. Solved: How to refer to a range? (1 replies)
  81. Run-time error '9' Problem (1 replies)
  82. Solved: Code makes excel crash! (6 replies)
  83. Solved: Problem starting app from Range (8 replies)
  84. Solved: Close excel if last open workbook (3 replies)
  85. Solved: Cell Protection (5 replies)
  86. Opening files in a folder with a certain word in filename (1 replies)
  87. Solved: summed one, two or more textboxes in mathematical way (6 replies)
  88. Solved: opening a file using textbox and combobox as the destination path and filename (2 replies)
  89. Solved: Copy cells + manual input! (10 replies)
  90. Solved: Commandbutton visibility (5 replies)
  91. How to create a macro that will produce a csv file from a button (3 replies)
  92. Syntax error (3 replies)
  93. Solved: Hide columns (2 replies)
  94. [SOLVED:] Copy cell from diferrent workbook (7 replies)
  95. Solved: ClosedWorkbook/Filter (3 replies)
  96. Unzip code error (2 replies)
  97. Solved: CSV to ASCII (7 replies)
  98. Compare 3 Columns and Return all Matches (1 replies)
  99. Solved: problem in opening a specific filename (2 replies)
  100. Combine (1 replies)
  101. Solved: Help with Checkboxes and OptionButton (15 replies)
  102. combobox change event loop (4 replies)
  103. copy sheet to workbook; with new sheet name (5 replies)
  104. Solved: how can i code the micro to copy cell value to deferment row? (2 replies)
  105. Solved: Different terms for saving a file (6 replies)
  106. Solved: how to convert first later to upper case and after onward lower case? (3 replies)
  107. Error Problem (4 replies)
  108. Solved: Highlight unlisted names (14 replies)
  109. Solved: Open a &quot;variable.exe&quot; (4 replies)
  110. Solved: Undo &amp;amp; redo macro (3 replies)
  111. Solved: Messagebox in macro (2 replies)
  112. Solved: VBA Form Problem (3 replies)
  113. autostart Macro with Date and Time (2 replies)
  114. Adjusting Page Layout for printing (0 replies)
  115. Solved: Auto Fill (4 replies)
  116. Solved: cells from tables sumed + checkboxes (3 replies)
  117. Solved: Cells not being Locked correctly! (2 replies)
  118. Close workbook (11 replies)
  119. Autosolved - basic working with PDF (14 replies)
  120. Hide Any New Column Fields in Pivot Table (0 replies)
  121. Command Button To Save & Close (3 replies)
  122. Error 70 Permission Denied (1 replies)
  123. Solved: Find &amp; clear blank rows (5 replies)
  124. Solved: multiple if formula and checkbox (6 replies)
  125. Matching failed (19 replies)
  126. Solved: Changing Range for Formula (9 replies)
  127. Help Splitting levels from Pivot Table into a table. (4 replies)
  128. [SOLVED:] Userform to Userform (6 replies)
  129. Run-time error: 9 Subscript Out of Range (4 replies)
  130. FIX code for search variable from copy excel cell or clipboard (1 replies)
  131. A macro used to migrate data from a csv file into ms excel 2007 (3 replies)
  132. Solved: extract data in row 1 of sheet 1 into sheet 2 (5 replies)
  133. creating a macro on a button to search for a file (8 replies)
  134. Solved: Read in value to use as array size (2 replies)
  135. Solved: Data Form (5 replies)
  136. workbook on server close (1 replies)
  137. Solved: Sort Problem 2003 to 2007 (9 replies)
  138. Application.SendKeys not working (2 replies)
  139. Solved: Extract Multiple State or cities names - excel function (5 replies)
  140. Create table from list (4 replies)
  141. Solved: Worksheet Consolidation of Rows that Meet Certain Criteria (1 replies)
  142. Scroll bar continuing to change after one click (1 replies)
  143. Resorting document using VBA (3 replies)
  144. AutoFilter and Non Contiguous Ranges (1 replies)
  145. [SOLVED:] Find number in string (6 replies)
  146. Solved: Extract State names - excel function (3 replies)
  147. Excel Export to Webpage Form Fields (2 replies)
  148. Solved: Date formula (17 replies)
  149. v-lookup to order a column in alphabetical order (2 replies)
  150. Solved: Populate ListBox from Worksheet Data (13 replies)
  151. Solved: Vlookup error (7 replies)
  152. [SOLVED:] how to find next but a new word? (14 replies)
  153. [SOLVED:] combine contents from a column (9 replies)
  154. Solved: insert picture (8 replies)
  155. Writing and understanding equations using excel (1 replies)
  156. Need macros or something similar (5 replies)
  157. Solved: counting with text help (3 replies)
  158. Solved: need help with a check (4 replies)
  159. different the Capital letter in 1st 5 character using VBA excel 2003 (1 replies)
  160. Loop (4 replies)
  161. Adding lines that affect formula (18 replies)
  162. Solved: Populating Userform under specific cells (7 replies)
  163. Restricted Access to Folders (2 replies)
  164. search and compare (1 replies)
  165. Matching imported hyperlinks to another cell (4 replies)
  166. [SOLVED:] Employee Scheduler in Excel (13 replies)
  167. Solved: Save Sheet as xls (2 replies)
  168. Solved: Formula too long for vba? (6 replies)
  169. VBA vs VB vs Other (14 replies)
  170. Solved: Subtracting Totals (2 replies)
  171. Hide Rows and Columns (7 replies)
  172. Solved: Query Data in Excel WorkBook and Return Results in Same Workbook (2 replies)
  173. Solved: TXTbox filter (4 replies)
  174. How do I get full Name into a Variable? (2 replies)
  175. VBA macros used update and transfer data from sql (1 replies)
  176. Solved: Clear Cell Content (4 replies)
  177. Mysterious file growth on sorting (4 replies)
  178. Random numbers in range (5 replies)
  179. Open and Delete all VBA Components -- on locked Files (3 replies)
  180. Mouse-click event (5 replies)
  181. combo box custom rowsource and data on the fly (0 replies)
  182. [SLEEPER:] Speed up the macro-page layout? (5 replies)
  183. Solved: Data Input Restrictions (7 replies)
  184. Using Variable Index with FormulaR1C1 (2 replies)
  185. Static Variable (4 replies)
  186. [SOLVED:] Compare columns from two sheets (7 replies)
  187. Solved: Saving a Workbook (13 replies)
  188. Solved: Unhide 5 Rows below when entering date Row Above (2 replies)
  189. get data from txt file (3 replies)
  190. Area under curve -Integral Sumproduct? (1 replies)
  191. Solved: Restricting Access to Spreadsheet by Network User Name/ID (16 replies)
  192. Some kind of lookup or macro?? (1 replies)
  193. Sleeper: may be userform (0 replies)
  194. Before send as attachment (1 replies)
  195. Match and copy values from one workbook to another (13 replies)
  196. [SOLVED:] find selected combobox item's row (2 replies)
  197. run time error '438' - Object doesn't support this property or method (2 replies)
  198. [SOLVED:] MsgBox (2 replies)
  199. Trying to write code in a shorter way (3 replies)
  200. Count of blank values in Pivot table (5 replies)
  201. [SLEEPER:] Filter Column B based on Column A values (1 replies)
  202. Solved: Elseif select case not working (5 replies)
  203. Copy files (9 replies)
  204. Solved: Macro to calculate only in cells filled with blue color (1 replies)
  205. Transfer Form Data To Worksheet (1 replies)
  206. How to create a macro that updates a spreadsheet calculation (4 replies)
  207. What do each of these VLookups mean? (1 replies)
  208. Expected End of Statement (15 replies)
  209. Copy duplicate instead of deleting (3 replies)
  210. Conditional Formatting with a Named Range (3 replies)
  211. Macros that can do automatic calculations with v-lookups on large data sets (1 replies)
  212. Not able to extract text from a webpage (3 replies)
  213. code for printers (2 replies)
  214. extract only specific words/lines from a txt file (12 replies)
  215. Solved: How to trigger macros from Validation List? (3 replies)
  216. Automatically send email (1 replies)
  217. Solved: Call an AddIn - Compile Error (3 replies)
  218. How do I open hyperlinks in a new window? (2 replies)
  219. Adding Records to an Excel table Vba (2 replies)
  220. Setting a Range Equal to an Array (4 replies)
  221. Solved: Count filled cells (17 replies)
  222. Solved: Copy Data from Sheet 1 to sheet 2 with auto (2 replies)
  223. Solved: open all file type (3 replies)
  224. To recover Spreadsheet (1 replies)
  225. Solved: If statement in an Array Formula (13 replies)
  226. Solved: How do you insert Columns using VBA? (2 replies)
  227. Solved: &quot;erroneous&quot; result with IF condition!! (7 replies)
  228. Solved: Set a variable as todays date minus X days. (2 replies)
  229. Solved: Need help with VBA syntax (10 replies)
  230. Solved: Getting macro to work on network and local drive ?? (10 replies)
  231. How to create a scaled down bar chart from a pivot table. Can this be done? (1 replies)
  232. Solved: Excel 2003/07 - I need to Bold two portion's of a string? (2 replies)
  233. Solved: Creating CSV file: double-quote problem (2 replies)
  234. Solved: Excel 2003/07 - Why does using Application.ScreenUpdating not hiding sheet select (1 replies)
  235. Solved: Pause/resume execution (3 replies)
  236. Compile error (9 replies)
  237. Solved: SaveAsUI.... cleanup before close. (4 replies)
  238. Solved: If with an OR or &amp; (5 replies)
  239. excel (9 replies)
  240. Looping a Macro (2 replies)
  241. Solved: Highlight row when a cell within it has been selected and 'un-highlight' when not (3 replies)
  242. Solved: Excel 2003 to 2007 &quot;ENABLE MACROS&quot; (4 replies)
  243. Variable Not Defined (15 replies)
  244. How to save a excel sheet into .txt file using macro (4 replies)
  245. Snake Eyes Program (3 replies)
  246. uncompress a (zlib-compressed) string using ZLib in VBA (3 replies)
  247. Mortgage Application Userform (7 replies)
  248. Solved: Cycling through multiple files in a directory (4 replies)
  249. Solved: Why using Range() works but Cells() doesn't?? (4 replies)
  250. Help to modify: "Combine All Data From All Worksheets in All Workbooks" (mvidas) (1 replies)