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. How to use variable column number in vba (2 replies)
  2. [SOLVED:] Problem Reading Text file with Excel Macro (VBA) (2 replies)
  3. Solved: Need help to understand this code (2 replies)
  4. Concatenate Data with Column Headings (3 replies)
  5. Solved: Running a Function from a Worksheet (7 replies)
  6. Userform_activate from immediate window? (1 replies)
  7. Array to fill combobox (6 replies)
  8. Increase row number (2 replies)
  9. Open a File from a folder Excel Vba (5 replies)
  10. Help to Create Addins XLA for user control access (1 replies)
  11. Solved: Vlookup help filling combo box (10 replies)
  12. cut, paste, blank cell.... (1 replies)
  13. Solved: Auto Numbering Alternative Column using VBA Macros (6 replies)
  14. need vbd string to number (7 replies)
  15. VBA Generating List (23 replies)
  16. Solved: the last cell in each column (16 replies)
  17. Solved: VBA If statement using and OR function (4 replies)
  18. if sheets("sheet1") doesn't exist, then a message box will appear (1 replies)
  19. pivot help (1 replies)
  20. Prevent Clear Contents (2 replies)
  21. Adv Data Seperation (6 replies)
  22. check if workbook open - if not open it (2 replies)
  23. Solved: Print Selective Area (8 replies)
  24. Solved: trying to dynamically create a userform (6 replies)
  25. Copying from only cells with data in range (3 replies)
  26. [SOLVED:] Msg Box on 1st of every month (6 replies)
  27. insert empty row where the content between two lines are different (3 replies)
  28. skipping ahead in for loop (9 replies)
  29. expression for offset() (5 replies)
  30. Hyperlink problem (2 replies)
  31. macro to generate next serial NO (5 replies)
  32. Solved: Lotus Notes (1 replies)
  33. Email with updated spreadsheet attached (2 replies)
  34. regex function isn't working (4 replies)
  35. [SOLVED:] error when changing font color with VBA based on cell value (5 replies)
  36. Clear out static variables (3 replies)
  37. Solved: Simple Segregation of Sums (6 replies)
  38. Solved: Incorporating dynamic ranges into CORREL function using VBA (12 replies)
  39. [SOLVED:] VBA Code for Sum by condition for each date (2 replies)
  40. [SOLVED:] Infinite Loop problem (2 replies)
  41. Run macro at different intervals based on cell date's distance from today's date (5 replies)
  42. textbox to integer (6 replies)
  43. Cell Tab Order (1 replies)
  44. VBA Code for Calendar Date Button (16 replies)
  45. How can I let the macro determine if the contents of a cell is numeric or text (4 replies)
  46. Password encrypted (1 replies)
  47. Worksheet_Change and DDE (4 replies)
  48. Back to user form (5 replies)
  49. [SLEEPER:] Excel VBA - load and search a Word Doc? (1 replies)
  50. Solved: Enter Times Without the Colon (3 replies)
  51. Criteria Based web query in excel (1 replies)
  52. How to add calender controls button in toolbox (3 replies)
  53. Cumulative mismatch records to single one (6 replies)
  54. Solved: VBA code for number sequence excel (2 replies)
  55. Who Can Solve This Problem? (10 replies)
  56. Shell with an array result - check items 1 by 1 (1 replies)
  57. SQL statements with VBA (2 replies)
  58. Solved: Chr(34) returning "" (12 replies)
  59. invalid property value error with combobox (9 replies)
  60. Reference a word doc embedded into excel (6 replies)
  61. [SLEEPER:] Pivot table multiple filters (3 replies)
  62. Solved: evaluate some numbers (4 replies)
  63. VBA Problem taking cell data from IE (6 replies)
  64. Solved: VBA VLookup not working (6 replies)
  65. Solved: AlphaNumber Formula (10 replies)
  66. WRITE FORMULA TO WORKBOOKS HAVE PASSWORD (EXCEL 2007) (0 replies)
  67. [Excel 2010 VBA] Get events of an object created on a Frame, OLEObjects. (1 replies)
  68. [SOLVED:] Run time error 424 object required (3 replies)
  69. filter data and than load it into master file (5 replies)
  70. Change format of Variable to Time (1 replies)
  71. Solved: Display Message after Submission on a Data Validation List (2 replies)
  72. Solved: Hyperlinking to bookmarks in a word document (7 replies)
  73. Creating a control (6 replies)
  74. Removing Punctuation Macro Also Removing Leading Zeroes (2 replies)
  75. Help perfecting some VBA from a recorded macro (9 replies)
  76. expression for the code "cells.find(..)" (15 replies)
  77. [SOLVED:] Deleting blank rows in a specific range (2 replies)
  78. Copy data from several worksheets to one existing worksheet with VBA (0 replies)
  79. Sum unknown rows with know columns (4 replies)
  80. next number in column (2 replies)
  81. Array or Collection - building a file summary (6 replies)
  82. Solved: Find key words in a column and color the row (7 replies)
  83. export word tables into excel (4 replies)
  84. Create Sheet (12 replies)
  85. [SOLVED:] Hyperlinking photos from directory (25 replies)
  86. [SOLVED:] Merge multiple .txt files into one .txt thru Excel VBA (6 replies)
  87. Copy data from Multiple Sheets (7 replies)
  88. Formula Help (1 replies)
  89. Delete Row If Cell Doesn't Contain Word (3 replies)
  90. Fill Rows Based On Cell Above (1 replies)
  91. VBA overflow problem, export data (3 replies)
  92. Formatting a cell's value as a date (3 replies)
  93. Error in Picking the specific excel file (2 replies)
  94. Solved: Convert formula to Macro; find closest value and return adjacent values (2 replies)
  95. Solved: Formula to extract string help (5 replies)
  96. Solved: Using Dir() (5 replies)
  97. Find Function - ONLY find what is specified (3 replies)
  98. split workbook into 2 by criteria (10 replies)
  99. Solved: Creating folder with drive selection. (4 replies)
  100. Solved: Search Through Subfolders of a Selected Folder (0 replies)
  101. Store Value in A temporary Variable (2 replies)
  102. Remove Duplicates by Date Range (8 replies)
  103. find number of work days in month (5 replies)
  104. Solved: combine data from spreadsheet help (13 replies)
  105. sort by upcoming date 60 days from today (1 replies)
  106. read write format text files (3 replies)
  107. Multiple columns into multiple rows (14 replies)
  108. Solved: How to perform code on all pages except first one (9 replies)
  109. Auto Email (4 replies)
  110. Solved: problem with sum product formula (3 replies)
  111. Solved: if-else query (5 replies)
  112. Extract substring (5 replies)
  113. Minimise use of SELECT in macro copying data from one sheet to another (9 replies)
  114. Sum x number of rows (3 replies)
  115. VBA Code to copy required data into Separate Sheet (8 replies)
  116. Use PlaySound and control left/right volume independently (1 replies)
  117. userform combobox error (0 replies)
  118. [SOLVED:] Close and re-open (4 replies)
  119. Collecting Data (5 replies)
  120. How to disable Paste Special->Keep Source Formatting - Excel 2010 (0 replies)
  121. Same ComboBox Value to show in 3 other ComboBoxes in Seperate Userforms (10 replies)
  122. copy cells to one page from others (11 replies)
  123. need help with simple macros (19 replies)
  124. More Robust Directory List Generator? (37 replies)
  125. ActiveCell.Offset in a Data filtered sheet (4 replies)
  126. Show / Hide part of Tabstrip or Multipage (4 replies)
  127. [SOLVED:] Deploying Add-in (2 replies)
  128. Comparing spreadsheet - VBA almost working.. (4 replies)
  129. Lookup and Match data (6 replies)
  130. Extract missing digits (1 replies)
  131. Close messages (2 replies)
  132. Edit macro to pull from column instead of line in macro (2 replies)
  133. Solved: Sheet Protection and Clipboard (4 replies)
  134. Updating Linked Data (6 replies)
  135. [SLEEPER:] Obtaining the standard deviation of a range in vba code (1 replies)
  136. VBA Print Range (6 replies)
  137. Solved: excel can't calculate formula (4 replies)
  138. COUNTIF formula with text color (3 replies)
  139. [SOLVED:] Delete all rows under a group (10 replies)
  140. How to go through a list on two different worksheets comparing values using VBA (3 replies)
  141. Solved: Delete Duplicate Colums (2 replies)
  142. Formatting not alligning properly on macro run (8 replies)
  143. Solved: Macro embedded in workbook (2 replies)
  144. Locking Cells (4 replies)
  145. Solved: Excel VBA Code for higlighting Pass Or Fail profile (9 replies)
  146. replace text/integer within a formula (4 replies)
  147. Solved: color (8 replies)
  148. edit values of a cell through textbox in a user form (4 replies)
  149. Solved: Need help with adding yes/no msgbox to Find Procedure (5 replies)
  150. change the (Worksheet_Change) event for a module (Sub). (19 replies)
  151. Allow Group/Ungroup on protected sheet (3 replies)
  152. Solved: Paste block of data into certain cells (2 replies)
  153. Solved: Expression not running all the way through (2 replies)
  154. Solved: More on SumProduct (2 replies)
  155. Solved: Blank cells (1 replies)
  156. Force user to enable macros (6 replies)
  157. Solved: Using ElseIF (3 replies)
  158. [SLEEPER:] Error of Advanced filter, copy & paste from different worksheets using 1 cmd button (0 replies)
  159. Solved: SumProduct Help (5 replies)
  160. Solved: Trim extra characters from Column F (4 replies)
  161. [SOLVED:] Quintiles and Conditional Formatting (3 replies)
  162. Combine Data that obviously the same (1 replies)
  163. Import data from website (3 replies)
  164. VBA to logon to Webpage (JSP)? (0 replies)
  165. Date and time calculation (2 replies)
  166. populate combobox when workbook is open (1 replies)
  167. Recall data to my userform (1 replies)
  168. Check Box Issue (2 replies)
  169. Sleeper: Select column and row(s) and change format (4 replies)
  170. I feel Computer Illeterate (1 replies)
  171. Autoupdate Dropbox Values (8 replies)
  172. Solved: Modify Copy to spreadsheet (4 replies)
  173. Worksheet_BeforeDoubleClick is not invoked (2 replies)
  174. Count of distributors based on criteria (2 replies)
  175. Add value in empty cell always same line column after column (2 replies)
  176. Adding Data Rows into excel using user inputs. (1 replies)
  177. Solved: Choose a folder in a directory if found. (6 replies)
  178. VB+Excel help (2 replies)
  179. Solved: Option Buttons in Multipage Form (10 replies)
  180. [SOLVED:] How to stop a specific VBA loop?? (10 replies)
  181. Unselect missing line in "References VBAProject" (3 replies)
  182. Solved: Find final Row In Mearge TOP Cell (6 replies)
  183. Shade Weekends in Calendar (13 replies)
  184. Solved: merge blank record in first column (4 replies)
  185. Problem in adding record using macro (2 replies)
  186. sum of mismatch records (1 replies)
  187. Date Tranformation (6 replies)
  188. Error when set value to an worksheet object (10 replies)
  189. Solved: Looking for a more 'flexible' Match() (6 replies)
  190. [SLEEPER:] OnTime Problem ..? (2 replies)
  191. Workbook Parameters compare (1 replies)
  192. Data Validation List (1 replies)
  193. Solved: Find a string and align left (13 replies)
  194. sumproduct help .. (6 replies)
  195. Solved: Find Last Used Cell In a Table (5 replies)
  196. Look up values through hierarchies (2 replies)
  197. Solved: Extend Range selection Down (2 replies)
  198. Solved: Help with Pivot Tables (2 replies)
  199. Pesky users, causing issues with userform (5 replies)
  200. The active cell in a sheet other than the active sheet (VBA Excel) (1 replies)
  201. Problem with OnAction (3 replies)
  202. Write Hebrew characters to file in VBA (1 replies)
  203. Solved: Open Txt File and Copy data (10 replies)
  204. Help with Excel & Office Web Component!! (5 replies)
  205. pause and continue (5 replies)
  206. How to analyze and sort data using VBA (3 replies)
  207. insert row above button (retrieve position of button) (8 replies)
  208. Error using .Find across worksheets (4 replies)
  209. Solved: UF Count Tally (4 replies)
  210. Cell copy the data to another cell with offset (2 replies)
  211. Frequently bought together (11 replies)
  212. Plotting an arrow in excel using VBA (3 replies)
  213. Calculate Correlations Based on Changing Parameters (16 replies)
  214. Solved: whats the difference (3 replies)
  215. Assigning macro to print button code help (8 replies)
  216. [SOLVED:] Interchanging data on different sheets (26 replies)
  217. Solved: copy data to another spreadsheet (12 replies)
  218. Solved: Producing multiple spreadsheets by running data from excel database (10 replies)
  219. expired workbook (6 replies)
  220. ListBox Index Select (2 replies)
  221. Transpose Range on Key (6 replies)
  222. Dont Change Folder/Zip File after Zipping & Unzipping (10 replies)
  223. match or vlookup help (6 replies)
  224. Solved: Delete Empty cells with condition (25 replies)
  225. improving class modules with syntax sugar (5 replies)
  226. need help with a code (2 replies)
  227. Next and Prev. command (2 replies)
  228. Assign Keyboard Shortcut to Ribbon Item Excel 2007 (1 replies)
  229. Excel 2010 fuzzy vlookup add in (0 replies)
  230. VBA drop down and he internet (0 replies)
  231. Real challenge from my professor (2 replies)
  232. Array function (5 replies)
  233. Solved: Writing data from workbook to text file (4 replies)
  234. Converting conditional format to permanent and reference to shapes (0 replies)
  235. Solved: Create Monthly Calendar using Userform (17 replies)
  236. Solved: Save as and File Directory (22 replies)
  237. VB ClearContents if add-on (Excel 2003) (2 replies)
  238. Solved: Delete Unused rows in a table (10 replies)
  239. userform combobox requirement (2 replies)
  240. unable to set focus (5 replies)
  241. extract data from multiples excel files (2 replies)
  242. pivot table automation (1 replies)
  243. Find and Replace of Formula Result (1 replies)
  244. Solved: VBA Code help. (5 replies)
  245. [SOLVED:] Make text in a cell bold (4 replies)
  246. Question about Slicers (1 replies)
  247. Arrange Images relative to each other (4 replies)
  248. Hidden ActiveX Controls Disappearing (5 replies)
  249. Solved: Inserting a formula with VBA (6 replies)
  250. cell blinking (3 replies)