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. insert 3 blank row if find a string data on column A (5 replies)
  2. Searching folders & subfolders from root for specific file & copy that file (0 replies)
  3. Solved: Copy Values from Information Tab to Main Tab (8 replies)
  4. Formatting a cell based on 2 cells. (2 replies)
  5. Textbox expand horizontally (0 replies)
  6. Macro creation (8 replies)
  7. [SOLVED:] Reconciling data using a VB Script (11 replies)
  8. Solved: How to test formulas results? (1 replies)
  9. May be MID and Find function (7 replies)
  10. Save the modification (3 replies)
  11. Solved: int() does this weird thing. Can someone explain this to me? (10 replies)
  12. Solved: Combinging AND and OR in Nested If Statements (5 replies)
  13. Solved: Need help with setting a range to some text. (5 replies)
  14. Connecting to database from macro (0 replies)
  15. Solved: VBA to find a value and copy values from sheet2 (5 replies)
  16. Help formatting text to columns using VBA (44 replies)
  17. Solved: generate a Code from Column A and B (3 replies)
  18. Solved: Delete entire row if cell contains string data on Cloumn A (2 replies)
  19. Loop cycle not copying and pasting correct cells (22 replies)
  20. Solved: Open Password Protected Workbooks in VBA (4 replies)
  21. VBA code for Alert Message and highlight duplicate (2 replies)
  22. Popup Message when Specific Text Selected in a Range (3 replies)
  23. Visual Basic Out of Memory (4 replies)
  24. determine the unit for left margin (Excel 2003) (3 replies)
  25. Prevent deleting worksheet (3 replies)
  26. Conditionally format Pivot Table cell color base on value (text) (3 replies)
  27. Excel to Word Insert Table Help!! (33 replies)
  28. if statement (2 replies)
  29. Password Protected userform (1 replies)
  30. Run-Time Error '5': Invalid procedure call or argument (9 replies)
  31. Solved: VLOOKUP Syntax in VBA Using WB w-Dynamic Name (12 replies)
  32. Give only named users acces (5 replies)
  33. VBA - Activeworkbook.save & Workbook_BeforeSave problems (3 replies)
  34. VBA Code Indent (7 replies)
  35. generic matrix multiplier (2 replies)
  36. Can One Class Hold Many Objects (4 replies)
  37. VB error while running the project (0 replies)
  38. VB help (2 replies)
  39. I need help edit code vba automatically copy of cell (2 replies)
  40. Solved: Worksheet Change... (1 replies)
  41. [SLEEPER:] Dynamic Chart won't Update (0 replies)
  42. Solved: module Excel VBA for manage parking places (11 replies)
  43. Solved: Help with IE loop Automation (13 replies)
  44. Easy Copy paste - Reconciliation macro (3 replies)
  45. 'UserForm Calander Control (4 replies)
  46. Cannot test us userform unloaded / terminated (9 replies)
  47. Macro to delete rows if criteria is referenced in other sheets? (1 replies)
  48. Row Fomula entry (2 replies)
  49. Solved: Test Last Row Value before update (4 replies)
  50. Weighted/Conditional LINEST in VBA (1 replies)
  51. Editing a Macro in one file using VBA in another file (11 replies)
  52. Solved: string with asterisk (3 replies)
  53. time keeps showing as 1:00 Am when it is 1:00 PM (4 replies)
  54. VBA to access website with passwords (2 replies)
  55. [SOLVED:] Copy Formulas Down Just One Row (5 replies)
  56. Solved: Copy Selection Paste btw 2 sheets (4 replies)
  57. Solved: Excel Application.Filesearch (3 replies)
  58. Solved: How to Hide Pivot rows with empty DataBodyRangevalues (1 replies)
  59. Macro to populate Data from Columns into Rows. (11 replies)
  60. Solved: VBA VLookup Number return Text (2 replies)
  61. Solved: Code which formats cells (9 replies)
  62. Code won't run on previous Excel version (13 replies)
  63. Solved: Hyperlink pivot pagefield control - not working (4 replies)
  64. Macro Security (3 replies)
  65. Code does not pull data correctly at login (7 replies)
  66. Vba Code Automatically Sort Rows Large To Small (18 replies)
  67. Solved: 2 dimensional arrays (14 replies)
  68. Solved: criterion for cell with formula, and the date on another cell (18 replies)
  69. Solved: Left Function on Object (9 replies)
  70. Time Adherence Sheet for Excel (2 replies)
  71. Solved: Transfer variable to form (3 replies)
  72. write changes in log (7 replies)
  73. Repetition de de copier/coller avec saut de ligne (4 replies)
  74. Format Functions Excel Add-in (1 replies)
  75. For each class("addressbox") in html document follow link (2 replies)
  76. Solved: Referencing a cell plus its formatting (28 replies)
  77. Question on Numbered Month (1 replies)
  78. Solved: userform to only accept mobile number (6 replies)
  79. [SLEEPER:] Hiding Named Sheet (3 replies)
  80. Paste content control text from word doc into excel cells (1 replies)
  81. Solved: OnTime events with Userforms (6 replies)
  82. Referencing Worksheets through a list (18 replies)
  83. Solved:Macro to delete selected by my rows, columns, cells (5 replies)
  84. Solved: strange behavior from special cells (1 replies)
  85. Copy cell from named sheet and paste (3 replies)
  86. Email most recent file in a folder (3 replies)
  87. Run-time error '2147024809' (0 replies)
  88. help with Excel Application.Filesearch replacement (2 replies)
  89. page setup setting (2 replies)
  90. Solved: My seemingly simply code is VERY slow (13 replies)
  91. Using arrays to scale up binary formulas (7 replies)
  92. Solved: Conditional formatting, if cell1-cell2>0.2 (12 replies)
  93. Copy from Listbox to empty sheet (4 replies)
  94. Copy data in a Filter table then email it (0 replies)
  95. error in displaying value on a cover page (1 replies)
  96. Help with Copy and paste (2 replies)
  97. Copy cell range to anther sheet containing;.. (5 replies)
  98. Google Maps, inputting destinations (9 replies)
  99. Solved: open with filedialog and copy to my workbook (29 replies)
  100. Question on Formula (3 replies)
  101. Solved: Formatting Data Imported From Web (14 replies)
  102. Z Axis of 3D Graph (26 replies)
  103. Turn an image into a toggle button (3 replies)
  104. Solved: Worksheet change copy to next cell (13 replies)
  105. set color saturation of image with vba (5 replies)
  106. Solved: Obtain Pivot Table Cell properties with VBA (4 replies)
  107. Compare one column with one cel and input result on a second column (5 replies)
  108. VBA Or Macro: To format data in a column and delete columns and create new column (4 replies)
  109. VBA to delete multiple rows based on multiple criteria? (7 replies)
  110. Putting Values of 3 columns into one column using If ElseIf statements (3 replies)
  111. Count unique values based on another column (4 replies)
  112. Saving the return value of oracle function in a string (9 replies)
  113. Solved: file name via function (19 replies)
  114. help with Payroll employees (1 replies)
  115. Solved: How to use VBA to test if a number is a prime or not? (4 replies)
  116. Solved: Setting Pivot Table Filter with VBA (3 replies)
  117. Help with crating a tab based on cell value (1 replies)
  118. Add-in file path Excel 2000? (4 replies)
  119. Userforms, Listboxes, Virtual space. (4 replies)
  120. Solved: OLEObject Vlookup help (0 replies)
  121. Solved: Macro not working properly (11 replies)
  122. Clearing Auto-Filter with Password Protection on (4 replies)
  123. Generate HTML email with file attached - please help (4 replies)
  124. Read Excel using SQL Statements (1 replies)
  125. Solved: Sorting data problem...need to sort at midpoint of data table (1 replies)
  126. [SOLVED:] Solved: Change selected cells to common range (7 replies)
  127. Displaying Search Results (3 replies)
  128. [SOLVED:] Matrix Multiplication of Arrays (6 replies)
  129. Solved: VBA to remove duplicates as per the date (2 replies)
  130. Find the Max Value when a cell contain Text and Number (3 replies)
  131. Programming for the null case (4 replies)
  132. Solved: Popularize Listbox using Textbox (11 replies)
  133. [SOLVED:] Working with String in VBA (1 replies)
  134. VBA Prevent File From Saving (3 replies)
  135. [SOLVED:] VBA code for pivot filtering (9 replies)
  136. Solved: Change the place of alphabets to numeric (5 replies)
  137. Solved: Error while printing pdf from excel (5 replies)
  138. Copying and Paste files (5 replies)
  139. Add signature to email (4 replies)
  140. Solved: Show the working days without holidays (2 replies)
  141. Solved: Making a macro compatible among multiple users (2 replies)
  142. Solved: Status Bar Message With Extract Macro (3 replies)
  143. Solved: Show All Data From Two Columns Matching Todays Date In A Msgbox (2 replies)
  144. [SLEEPER:] Run Time Error '76' - Path Not Found (2 replies)
  145. Solved: copy entire row to new sheet along with header (7 replies)
  146. Treeview in 2010 64Bit (2 replies)
  147. Protecting Cells With A Password In different Work Sheets With Code? (4 replies)
  148. adAsyncExecute apparently gets cut off (2 replies)
  149. Solved: Remove certain charachters from a cell (8 replies)
  150. Solved: Macro Equation (6 replies)
  151. Select an item from a website tree (0 replies)
  152. Solved: Array Formula Question (5 replies)
  153. Solved: need help with finding the minimum in a 1D array (2 replies)
  154. Excel 2003 User Defined Function (1 replies)
  155. Solved: worksheet tab options unintentionally disabled (2 replies)
  156. Solved: If statement (6 replies)
  157. Passing Array Issues (3 replies)
  158. Solved: Fetching data from excel (3 replies)
  159. Creating Summary/ VBA code (1 replies)
  160. Unexpected "Subscription out of range" error (3 replies)
  161. Get last row of a page (13 replies)
  162. Solved: Getting average of a range within a loop (11 replies)
  163. HELP, user-defined type not defined (5 replies)
  164. PIVOT table - Change sub column label (4 replies)
  165. [SOLVED:] Countif? within a loop (12 replies)
  166. Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change) (3 replies)
  167. Help with Sorting by first name (28 replies)
  168. Solved: Insert header rows (14 replies)
  169. Solved: New procedure at end of code? (3 replies)
  170. Using HLookup (2 replies)
  171. Macro to fill values of row numbers in a 10x20 grid (2 replies)
  172. Simple VBA Statement (3 replies)
  173. how to get profit as per fifo method (1 replies)
  174. repeated user input (1 replies)
  175. ContextMenu example errors (3 replies)
  176. code created text box not firing change event (12 replies)
  177. Solved: VBA Pogress Bar (2 replies)
  178. Solved: Empty Cells Will Not Delete (2 replies)
  179. Solved: copy from excel to word unmerged table (13 replies)
  180. VBA Form that uses data from a worksheet (2 replies)
  181. Save As Query (5 replies)
  182. Class Modules in AddIn .xlam (14 replies)
  183. Solved: Smallest 3 numbers in range (4 replies)
  184. Paste special data till last updated row (4 replies)
  185. Solved: Application or object based error (3 replies)
  186. [SOLVED:] search folder structure and return paths only (2 replies)
  187. Solved: Refresh my pivot table (4 replies)
  188. Solved: Make folder path and file name with VBA code (2 replies)
  189. Consolidate data from different excel files (VBA) (9 replies)
  190. Help with code to copy to another worksheet (0 replies)
  191. [SOLVED:] Getwindowstext and settext (4 replies)
  192. Compile error: Expected line number or label or statement or end of statement? (0 replies)
  193. Merseene Twister VBA app easy issue to solve (with zip file) (0 replies)
  194. Solved: EASY VBA ISSUE TO FINALIZE THE IMPLEMENTATION OF THE MERSEENE TWISTER RNG (19 replies)
  195. Embedded gif in userform (6 replies)
  196. Solved: Use a spreadsheet specifies interval even if another is active (2 replies)
  197. Remove gaps in a combobox list (3 replies)
  198. Muti Solver VBA (0 replies)
  199. RunTime error 462 - The remote Server machine does not exist. (0 replies)
  200. Line list box (0 replies)
  201. conditional formatting text conditions (2 replies)
  202. Text Box, text formatting (0 replies)
  203. execute macro if change to range (2 replies)
  204. CONDITIONAL FORMULA with Percentage (2 replies)
  205. VBA Show All Data (6 replies)
  206. Solved: Sort All sheets in a workbook (4 replies)
  207. Capture window help (1 replies)
  208. data send to zohosheet (0 replies)
  209. pivot vba (0 replies)
  210. VBA Excel HTML e-mail? (4 replies)
  211. [SOLVED:] Excel chart - identify the selected data point through macro. (5 replies)
  212. Opening a new file of a different format (2 replies)
  213. Multiple conditional values from Excel in VBA listbox (0 replies)
  214. Excel vba script to insert data into Outlook (1 replies)
  215. datestamp on cell CHANGE (3 replies)
  216. OFFSET of result from vlookup (8 replies)
  217. Runtime err 1004 (0 replies)
  218. Running Macro Automatically if a cell value is True. (2 replies)
  219. Export Selected Sheets to New workbook (0 replies)
  220. VBA - Macro to create/update documents in Lotus Notes database (1 replies)
  221. Solved: cell checking (2 replies)
  222. Attachment to gmail (3 replies)
  223. Solved: Function that's not working as should (5 replies)
  224. Solved: change name tab office (4 replies)
  225. [SLEEPER:] Disappearing calc field in pivot table (9 replies)
  226. Special Sort needed - Sorting labels contained in one column (4 replies)
  227. group and hide blank space (1 replies)
  228. Multiple Criteria Lookup (1 replies)
  229. Solved: Type mismatch error on If Not Range... (8 replies)
  230. Solved: user name (4 replies)
  231. vba to find and replace exact matches of cell value in a sheet (3 replies)
  232. Solved: sort columns dynamic (13 replies)
  233. Solved: Add third column to listbox (6 replies)
  234. VBA - CELL VALUES EXCEED 12 (MONTHS) (4 replies)
  235. Multiple currency format from UserForm (9 replies)
  236. Can not get rid of "Do you want to Save changes" (1 replies)
  237. Use a list from Excel to move files on computer (5 replies)
  238. Solved: Double Click Event for Shapes (16 replies)
  239. Excel Automation of IE - help click this button (5 replies)
  240. [SOLVED:] Byref argument type mismatch array (6 replies)
  241. Solved: Remove Freeze Panes From Inactive Window (4 replies)
  242. Solved: Return a value from another sheet (3 replies)
  243. Solved: Worksheet Change Function: Created WS? (4 replies)
  244. Solved: Excel- align rows by column. Works but too slow! (2 replies)
  245. Solved: Help with automatically fill in cells by VBA loops (0 replies)
  246. Solved: Add date to Userform (4 replies)
  247. How to get records in excel ADO (1 replies)
  248. Problem Using Kill File (5 replies)
  249. Solved: Incorrect VBA Sort on Workbook Close (6 replies)
  250. Solved: Help with Find/Delete Entire Row (3 replies)