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. Delete and Move a row in excel (1 replies)
  2. Solved: Runing a macro by clicking on a sheet (2 replies)
  3. Solved: Insert Row after Specific Text (4 replies)
  4. Return Types in Excel VBA (1 replies)
  5. Solved: Not understanding Custom Icon Macro (3 replies)
  6. String and Combox Question (1 replies)
  7. Solved: Working on a not visible Worksheet (1 replies)
  8. Problem with VBA script reading from MySql database (3 replies)
  9. [SOLVED:] Make VBA code shorter (7 replies)
  10. Master Filter for Pivot Tables (0 replies)
  11. Solved: select worksheet and display selected sheet in workbook (2 replies)
  12. Find cells within range equal to 70% of sum of total range (14 replies)
  13. Solved: rd_filename = Active.Workbook.Name (3 replies)
  14. Sorting sheets within a workbook (2 replies)
  15. Macro Help: Replacement for cut and delete Speed wise (2 replies)
  16. on each day, at 6am, the excel file will be opened by itself (2 replies)
  17. Solved: MsgBox to list missing .references (3 replies)
  18. Debugging Runtime Error '13' Type Mismatch (1 replies)
  19. Compare two spreadsheets-Macro (8 replies)
  20. Sorting Options for Several Data (1 replies)
  21. Solved: making a list of the datasheet (5 replies)
  22. Reading values from a closed excel sheet (3 replies)
  23. Solved: UserForms: Passing inputs from one to another (10 replies)
  24. Solved: Speed up an Array Formula in VBA (8 replies)
  25. save as with auto name (2 replies)
  26. Solved: VBA Copy (11 replies)
  27. Solved: Application.Countif - separate workbook (2 replies)
  28. Solved: Allow Authorisation On 2 Computers (4 replies)
  29. Solved: VLOOKUP Code (8 replies)
  30. Solved: Filter and VBA (4 replies)
  31. Expressing a " in an excel Formula as VBA code (3 replies)
  32. Publishing Defined Names to single Htm page (1 replies)
  33. replacing characters in a column which occu at random positions (5 replies)
  34. Solved: Userform Option Button Issues (3 replies)
  35. Merge first sheet of multiple excel file (2 replies)
  36. Comparing string differences between two separate column of sheets??? (8 replies)
  37. Solved: Conditional Format 2 arguments; one of them is only a part of a cell contents (14 replies)
  38. VBA Excel Transpose all files in a folder (6 replies)
  39. Solved: Workbooks.Open issue in Excel 2010 (Network Drive) (4 replies)
  40. VBA Help (5 replies)
  41. Why the Set temp(0) = Activesheet.Columns(3).insert is not working? (4 replies)
  42. Converting Matlab Code to Vba (2 replies)
  43. saving spreadheet to network drive (3 replies)
  44. Solved: copy cells to column without blanks (6 replies)
  45. Solved: Strange problem when protecting/unprotecting sheets (6 replies)
  46. Filling in IE form with values from Excel (0 replies)
  47. Solved: Display the first word separated by comma in textbox (4 replies)
  48. [SOLVED:] Problem with more then one each.. for cicle (7 replies)
  49. Solved: VBA for updating every worksheet in workbook. (32 replies)
  50. Compare two spreadsheets (1 replies)
  51. Need Help - Macro Not Working Properly (14 replies)
  52. VBA Code Freezing (14 replies)
  53. RGB (R, G, B) to hex function (1 replies)
  54. How To Copy Paste File Named in Cell to Another Folder Named in Cell? (4 replies)
  55. Solved: Find text in a cell,copy row and paste into new sheet (6 replies)
  56. Solved: Sumproduct with HLookup (8 replies)
  57. userform filtered search (1 replies)
  58. Solved: Strange Error in simple VBA macro (1 replies)
  59. Problem with .xlsm file adding code via VBA (4 replies)
  60. connetct own help file in excelVBA function addina (7 replies)
  61. Solved: Copy from one workbook, to another, keeping format. (5 replies)
  62. Solved: Quick VBA Userform Pivot query (6 replies)
  63. Confusing issue with Copying and moving work tabs (4 replies)
  64. Copy Paste File Specified in Cell to Another Folder (0 replies)
  65. Solved: Listbox1: Highlight Pre selected Item (2 replies)
  66. VBA code to hide rows (14 replies)
  67. Solved: Delete Rows (13 replies)
  68. Solved: Stripping numbers from alphanumeric strings (4 replies)
  69. Solved: Shell and Wait Issue (17 replies)
  70. how to search for a string in text file (1 replies)
  71. Question about vba programming (2 replies)
  72. Replace Chart labels with Textboxs (1 replies)
  73. Solved: searching a word in lower and uppercase (10 replies)
  74. Solved: Setting wb.Name to string for VLOOKUP formula (9 replies)
  75. E-mailer from individual e-mail to 1 e-mail (2 replies)
  76. Convert UTC to local time with DST (1 replies)
  77. Tricking Sort Logic (3 replies)
  78. Solved: Find (2 replies)
  79. Create worksheets from a list (1 replies)
  80. Code understanding (1 replies)
  81. Solved: Cannot switch to an active excel workbook from word (4 replies)
  82. Solved: Range selection with array of ranges (10 replies)
  83. [SOLVED:] Conditional Formatting Help :-) (2 replies)
  84. Solved: error handling failed (2 replies)
  85. Solved: multiple interior.colorindex (2 replies)
  86. Solved: Range matrix (2 replies)
  87. Unhide bug (4 replies)
  88. Creating a list of variables (2 replies)
  89. VBA Data Analysis Loop Problem (1 replies)
  90. Cells that update automatically (8 replies)
  91. Solved: SUM Formula (6 replies)
  92. How to password protect grouping? (0 replies)
  93. Drop Down Validation Double Dependency (20 replies)
  94. Copying Characters to the Right of a Selected String in a .txt file (2 replies)
  95. Advanced Filter Command Buttons (1 replies)
  96. Unlock Blank Cells in Column G (4 replies)
  97. Combo box in Excel to query MySQL (0 replies)
  98. Help Exiting Loop (4 replies)
  99. Macro: Highlight Cell in Col B that DOES NOT exist in Col A (3 replies)
  100. Moving to Excel 2010 - worksheets.move compatibility (0 replies)
  101. Solved: Range Selection error (12 replies)
  102. HTML table code (1 replies)
  103. List Ranges with Missing Data in Column (3 replies)
  104. Solved: concatenate cells in IF statements (5 replies)
  105. Set the values for .TextFileFixedColumnWidths in code (2 replies)
  106. vlookup with input box to select a new month when run (8 replies)
  107. Move files and ignore file extension? (1 replies)
  108. Why doesn't the xlcelltypelastcell not giving the last cell inside a list? (1 replies)
  109. cannot get rid of error message (10 replies)
  110. Solved: Entering Value in Combobox with Dynamic Range (2 replies)
  111. Solved: Delete Empty Cells (5 replies)
  112. Make a report with data taken from cells (0 replies)
  113. Solved: Look excel range? (2 replies)
  114. Data Validation based on 2criteria (3 replies)
  115. Solved: VBA to Excel Add-in (7 replies)
  116. Solved: Basic VBA problem with Format (8 replies)
  117. Solved:Looping a section of code (3 replies)
  118. Solved: loop Error (3 replies)
  119. Linking dynamically allocated row offset to stacked column chart data range variable. (0 replies)
  120. Macro vlookup with fill down (3 replies)
  121. How to destroy (de-filter) individual advanced filters in a worksheet? (5 replies)
  122. Data Validation code error (1 replies)
  123. Drill into a Pivot Table using a Macro (1 replies)
  124. Height of Prina Area (0 replies)
  125. Copying a range from a different workbook (1 replies)
  126. Updating sheet automatically periodically (3 replies)
  127. Solved: Lookup County (2 replies)
  128. Textbox Userform: Autopopulate textbox from another textbox (7 replies)
  129. Reading Data and creating a table from it (11 replies)
  130. How to re-arrange the listcolumns? (1 replies)
  131. Macro to look at list in sheet1, if not in sheet2, pull in (12 replies)
  132. Getting Error when No visible Cells found. What to do? (1 replies)
  133. Count non empty cells (2 replies)
  134. Problem showing images in locked sheet (2 replies)
  135. timekeeping template (1 replies)
  136. Solved: Import Web Data with HTML format (1 replies)
  137. custom format (1 replies)
  138. Problem with If...Then...ElseIf Loop (10 replies)
  139. Copy data (1 replies)
  140. Solved: Red Font (7 replies)
  141. Solved: Help Date's (4 replies)
  142. Help with code (8 replies)
  143. help with vba code please (1 replies)
  144. Solved: 2003 Multibox Color fix (3 replies)
  145. Search Date in Worksheet and Set Format (7 replies)
  146. Solved: Dissect result (8 replies)
  147. find with xlprevious not working (11 replies)
  148. Solved: Data Validation: Combine Two Cells In Drop Down Only (31 replies)
  149. Function Help (7 replies)
  150. How to create the menu w/o the code as the attached file (13 replies)
  151. Search data within the spreadsheet to log (1 replies)
  152. Round off Issues and more... (9 replies)
  153. Search Function Problem (2 replies)
  154. Compare 4 columns & find dissimilar (2 replies)
  155. interact with web page (1 replies)
  156. Solved: goal seek w/ value from another workbook (2 replies)
  157. Copying a picture from a web page and pasting into Excel (3 replies)
  158. Deleting empty worksheets in a workbook (1 replies)
  159. [SLEEPER:] Changing Chart Titles (1 replies)
  160. How to generate weekly/monthly reports from daily report using macros (1 replies)
  161. Solved: To reflect latest data updated in a row range (15 replies)
  162. Append excel table into Access table on weekly or monthly basis (4 replies)
  163. Effect of AND and OR operators on Type Long (6 replies)
  164. Solved: Zero the negatives (2 replies)
  165. Solved: Checklist compare (3 replies)
  166. Share workbook with digital signature (1 replies)
  167. Solved: how fix it - vlookup in visible range (not invisible) (4 replies)
  168. copying a range from multiple csv files (2 replies)
  169. Solved: DoubleClick event in a textbox (4 replies)
  170. Excel VBA Coding for xls transformation (0 replies)
  171. Solved: Enabled Button (0 replies)
  172. Filter Problems (5 replies)
  173. Help to disable popup calendar (8 replies)
  174. Dynamic Looping Help (1 replies)
  175. Solved: Pivot Table (2 replies)
  176. Automation error (Error 440) (1 replies)
  177. Macro to drill into pivot table (4 replies)
  178. copy folder WB to a one workbook (1 replies)
  179. Solved: VBA code for checking possible combinations of 4 numeric digits (4 replies)
  180. Login to yahoo mail. (9 replies)
  181. Solved: Delete all info other than name on left side of cell. (2 replies)
  182. Solved: Calculate Time Left (14 replies)
  183. Solved: Deleting part of a merged cell (2 replies)
  184. Displaying missing values from 2 worksheets in another separate worksheet (4 replies)
  185. Effectively using Classes and Property Let/Get; referring to parent or sub class... (10 replies)
  186. Sum of column (6 replies)
  187. Auto print last filled page (4 replies)
  188. Convert workbook code to worksheet code (3 replies)
  189. Unstable event code (15 replies)
  190. Editing in Word and saving in Notepad while controlling everything in Excel (0 replies)
  191. Check if a shape is selected (2 replies)
  192. sheet protection options (3 replies)
  193. Calling macros (3 replies)
  194. help please (4 replies)
  195. Dates and Days (4 replies)
  196. Solved: For next i help (3 replies)
  197. Maximum size for a typical .xlsm file (1 replies)
  198. Delete Row sends Excel into an infinite loop (1 replies)
  199. Solved: activx component cant create object excel 2007 (1 replies)
  200. help with html extraction (2 replies)
  201. hide the row if the row has nothing or more than 1 cell has things (3 replies)
  202. [SLEEPER:] print rows 2,3, as headers on page if multiple pages (4 replies)
  203. Excel VBA controlling IE confirmation popup box (5 replies)
  204. Solved: Sort will not work ... (9 replies)
  205. Users Help (4 replies)
  206. application.match type mismatch (11 replies)
  207. Selecting Rows with More than one Constant (7 replies)
  208. List out all possible combination in the sheet (4 replies)
  209. How to display values in excel sheet from vba Form. (4 replies)
  210. Solved: formula problem, nested if (2 replies)
  211. Solved: Chart Creation (8 replies)
  212. Solved: Calculation with an asterisk (10 replies)
  213. how to sum based on data in corresponding rows (1 replies)
  214. type mismatch on application.run (4 replies)
  215. Code interrupted after running another workbook (3 replies)
  216. Function as Argument (2 replies)
  217. Stable progress bar (2 replies)
  218. How to apply Average formula with multiple criterias (1 replies)
  219. Solved: Copy unknown range size (7 replies)
  220. Solved: open macro security setting dialogue box (2 replies)
  221. Looping through commands (1 replies)
  222. Alternative of .SearchSubFolders = False for 2010 (2 replies)
  223. takefocusonclick checkbox (2 replies)
  224. Solved: force a refresh to workbook shared on network (1 replies)
  225. need help writing a program... (22 replies)
  226. Solved: part of Dir string vba (1 replies)
  227. CommandBarControl error (0 replies)
  228. input the names of all MS Word file in an Excel file. (1 replies)
  229. Calendar without add-ins (2 replies)
  230. Conditional macros (2 replies)
  231. Need help on Sumif formula (2 replies)
  232. Funky Character in CVS - Text To Columns (6 replies)
  233. Anyone In Auckland? (0 replies)
  234. Solved: Assigning formula to cell glitch? (2 replies)
  235. Change value of Cell to the integer in VBA (3 replies)
  236. Acomplex export from Excel to Powerpoint (0 replies)
  237. Conditional Formatting using VBA (3 replies)
  238. Solved: filter by month (12 replies)
  239. Sleeper: Simple problem (2 replies)
  240. need sort data (0 replies)
  241. [SOLVED:] IF and Offset Macro (4 replies)
  242. Solved: Sort Help VBA (2 replies)
  243. Solved: VBA Move Files to Sub Folder (4 replies)
  244. Call a sub from another open workbook (3 replies)
  245. Search for Certain Part of String (7 replies)
  246. [SLEEPER:] Copy from above cell (1 replies)
  247. copy workbooks to different folder (1 replies)
  248. Excel Add-inn Password Recover/Remover (7 replies)
  249. Solved: Macro for write value without duplicate (14 replies)
  250. exporting to csv (3 replies)