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. Creating and renaming work sheets to correspond with worksheets of a nother WB (2 replies)
  2. Macro Toolbar, disable buttons (3 replies)
  3. Solved: Code Help for FX conversion and formatting (5 replies)
  4. Pagesetup and set PrintArea for multiple ranges and sheets (1 replies)
  5. Message Response Loop Problem (6 replies)
  6. got following error after export excel file . (0 replies)
  7. SORT COLUMNS VBA (9 replies)
  8. Solved: Creating File Path for Hyperlink (4 replies)
  9. item.send security dialog box (7 replies)
  10. Solved: Need help te create formula or vba code (4 replies)
  11. Double Click Table Header to Sort (6 replies)
  12. Remembering a file path ... (2 replies)
  13. Sending Birthday Greetings via Email using list of addresses in Excel Sheet (3 replies)
  14. Solved: Find Replace from external file (9 replies)
  15. Copying sheets multiple times in the same workbook (2 replies)
  16. Solved: Formatting Macro Problem (3 replies)
  17. [SLEEPER:] Multiple commands in BeforeClose (2 replies)
  18. Solved: Sending email using 'IfThen' (15 replies)
  19. Replacing in VBA (6 replies)
  20. [SOLVED:] Getting rid of a popup on closing a workbook (3 replies)
  21. [SOLVED:] Format only blank cells in the range (5 replies)
  22. VBA Excel (variable range) help (15 replies)
  23. Sleeper: Convert all excels files from a folder to pdf (0 replies)
  24. Copy Range From External Workbook to Range in Open Workbook (2 replies)
  25. Solved: Count if two criteria meet requirement (3 replies)
  26. Solved: Import Spreedsheet from a closed workbook to another workbook (8 replies)
  27. Copy paste data from activerow into existing powerpoint presentation (4 replies)
  28. GUI Excel (4 replies)
  29. checking for space bar (2 replies)
  30. Solved: IsNumber question (3 replies)
  31. [SLEEPER:] Send Keys does not work in my remote application (5 replies)
  32. Hide rows in excel (4 replies)
  33. [SOLVED:] Filter criteria in active column (51 replies)
  34. Solved: Select chart series with option button (2 replies)
  35. Solved: Looking to change a character to another... (5 replies)
  36. Sending email using Loops/If Then? (11 replies)
  37. Hide subtotal row in pivot table (0 replies)
  38. Help VBA - Importing Data (2 replies)
  39. Solved: returning the previous tuesday at 2pm (6 replies)
  40. Excel 2007, Aditional Controls (3 replies)
  41. Solved: Userform;TextBox:Update Data (11 replies)
  42. Chart (1 replies)
  43. Solved: Comparing elements in 2 arrays (5 replies)
  44. Solved: Help with VBA code (15 replies)
  45. Solved: Generating a 1 or 0 randomly with frequency l (2 replies)
  46. Solved: Charts & Ranges (14 replies)
  47. Solved: Sumif Concatenate VBA code (11 replies)
  48. Solved: Multiple Questions (Chiinv function & dragging cells) (9 replies)
  49. Solved: Error when clicking "Cancel" Button (8 replies)
  50. Solved: [Excel 2007] Apply custom number format based on column header (13 replies)
  51. [SOLVED:] sending data to powerpoint charts table (2 replies)
  52. Solved: Infamous "Excel cannot complete this task" message. (20 replies)
  53. Solved: Hyperlink in a Userform (4 replies)
  54. VBA Code runs too slow (7 replies)
  55. Solved: Paste Listbox Variable to cells (3 replies)
  56. Solved: Autofilter, copy and paste into new sheet problem (4 replies)
  57. Solved: Times Now & Rounding (4 replies)
  58. Code execution has been interrupted (4 replies)
  59. Copying Forumla Down In One Column (1 replies)
  60. I need help with a code to change the scale of a bar chart. (2 replies)
  61. Solved: Need help creating a function with loop. (4 replies)
  62. [SOLVED:] Change Check box Value to Text (2 replies)
  63. Switching workbooks in VBA (5 replies)
  64. initialize 2d array (2 replies)
  65. Listbox Question (1 replies)
  66. Looping until a Frame is ready? (1 replies)
  67. Solved: Application.Help doesn't work on terminal server (1 replies)
  68. Macro to sort Ascending,identify duplicates& highlight yellow (16 replies)
  69. Change to "SKIP BLANKS" when pasting? (2 replies)
  70. Checkbox checking...then unchecking on its own? (1 replies)
  71. Microsoft Query hangs (4 replies)
  72. Multi-condition function (11 replies)
  73. Solved: Automatically import data from Access DB in Excel (5 replies)
  74. Solved: Assistance with character counting (Excel '97) (9 replies)
  75. problem deleting rows based on a condition in another workbook (6 replies)
  76. Opening embedded word document through VBA (4 replies)
  77. Solved: naming sheet after cell value (6 replies)
  78. Sleeper: Copy rows to worksheet two (10 replies)
  79. Solved: Run time error 424 - object required. Why? (2 replies)
  80. Solved: Speed up or new code for deleteing rows (6 replies)
  81. [SLEEPER:] VBA Code for clicking a link? (2 replies)
  82. specifying range when returning an array (3 replies)
  83. Solved: Please help with this Code (5 replies)
  84. Solved: Excel Graph w/cubic function (4 replies)
  85. Solved: delete trailing empty rows from 2d array (2 replies)
  86. Solved: VLookUp Error in VBA (10 replies)
  87. Solved: Hide range of column on sheet2 from sheet1 (2 replies)
  88. Excel VBA Code Help!! (3 replies)
  89. Cut Copy Paste disable in Excel 2007 (13 replies)
  90. Solved: Create button which is always shown in excel (6 replies)
  91. Vlookup in vba (3 replies)
  92. ComboBox;Filter value (4 replies)
  93. progress box (3 replies)
  94. Solved: in Excel 2007, pasting to visible cells only (12 replies)
  95. Solved: VBA not reading .Value (8 replies)
  96. Solved: Shifting rows???? (4 replies)
  97. [SOLVED:] I need help referring to last and first sheets (3 replies)
  98. Solved: Macro to make duplicates to be displayed in one row (11 replies)
  99. Solved: Add Sub-Folders (7 replies)
  100. Solved: “Move Select After Enter” Problem (3 replies)
  101. problem comparing rows and copying result to another sheet (6 replies)
  102. Solved: Cut and paste into new sheet (23 replies)
  103. isnull problems (1 replies)
  104. Solved: Merge rows with same Info in to one (4 replies)
  105. Solved: Secure workbook by finding a file (6 replies)
  106. Sleeper: Moving data from rows to adjacent columns (1 replies)
  107. MultiSheet Print Preview not including Charts (7 replies)
  108. Method 'Select' of object '_Worksheet' failed (4 replies)
  109. Solved: Column Values Duplicate (6 replies)
  110. Delete an Access table using vba (3 replies)
  111. Solved: If Question (14 replies)
  112. Solved: DSUM (14 replies)
  113. excel add-in document properties (1 replies)
  114. Modify "Errors (1 replies)
  115. Solved: Comma Delimited Data Arranging (4 replies)
  116. Color Rows or Colums (6 replies)
  117. running a macro on an otherwise protected workbook (4 replies)
  118. Showing and Hiding a picture (15 replies)
  119. Empty cell in a selection (8 replies)
  120. Dim array in userform (9 replies)
  121. Import the text file data into different worksheet of xls based on certain value. (1 replies)
  122. Passing variables not working (17 replies)
  123. like comparason (3 replies)
  124. Solved: AutoFill Macro (5 replies)
  125. Solved: Universal error trap (17 replies)
  126. Solved: CSV Files (3 replies)
  127. Please Help W/Conflicting Codes (3 replies)
  128. Solved: OLEObject Click Event (2 replies)
  129. [SLEEPER:] Help tidying up some current code that causes errors (13 replies)
  130. How to use IsMissing when the optional parameter is integer? (9 replies)
  131. "Enter" textbox upon UF initialize (12 replies)
  132. Update data from text file in worksheet starting at particualr cell. (2 replies)
  133. Solved: Shifting cells to the right???? (3 replies)
  134. Inserting Pic with other Data Entry Field. (0 replies)
  135. Extract all workbooks cell names and formulas in a spreadsheet (5 replies)
  136. Solved: Insert URL Image (1 replies)
  137. Solved: Merging columns (4 replies)
  138. How to pass an Array in a Class Module? (7 replies)
  139. Newbie needs help with "slideshow" macro (4 replies)
  140. Simple VBA question (2 replies)
  141. Download a txt file from Website using excel (5 replies)
  142. Sleeper: Help W/AutoFilter (1 replies)
  143. [SOLVED:] How to subtract cell values (12 replies)
  144. Solved: Help w/ simple 'For-Next' loop (11 replies)
  145. range to array (1 replies)
  146. Compare Numbers Strings Using VBA (multiple criteria) (12 replies)
  147. Run Time Error 13 Message, very strange ! (4 replies)
  148. listBox Issues (2 replies)
  149. Solved: Subsciprt out of Range Error with Mulitple Workbooks (3 replies)
  150. ReadOnly Column (7 replies)
  151. Copy to closed wbk (3 replies)
  152. Solved: Need help with Click Event of OptionButton / CheckBox (3 replies)
  153. [SOLVED:] More efective sumproduct (2 replies)
  154. Solved: VBA code to copy rows from one sheet to another based on 2 criteria? (15 replies)
  155. Apply only the Font part of a Style (3 replies)
  156. Solved: find blanks= 0 (10 replies)
  157. Inserting, Renaming and Moving/Sorting Worksheets (2 replies)
  158. Solved: paste from multi sheets to 1 (3 replies)
  159. Change the Background Color of button added to worksheet using vba (2 replies)
  160. Solved: Selecting subtotal and grand total cells only(not entire row) (13 replies)
  161. Solved: Copying Formula Results (11 replies)
  162. open/activate book and edit without readonly -query (26 replies)
  163. Word frm to Excel (8 replies)
  164. Solved: Unusual Error Trap (7 replies)
  165. Macros match / Lookup (3 replies)
  166. Need help clearing (removing) buttons (2 replies)
  167. Apply macros on filtered columns (2 replies)
  168. Solved: Where to put additional code (11 replies)
  169. Loop into Excel (6 replies)
  170. Error when Export data into Excel (1 replies)
  171. Solved: Get values from cell with VBA (3 replies)
  172. Lookup Nth occurrence: cells formats (6 replies)
  173. Solved: Code Select Sheet & Range single step (2 replies)
  174. Help with macro to copy and paste based on formula result (5 replies)
  175. Insert Photo in Cell, using Userform (3 replies)
  176. Solved: Command Button Naming (3 replies)
  177. Solved: calculation (2 replies)
  178. [SOLVED:] Opening another file with title equal to a cell entry (2 replies)
  179. Solved: Loop through sheets (6 replies)
  180. Solved: Moving data to a Word document (22 replies)
  181. Transferring data from an array to a range - strange error (8 replies)
  182. Solved: Updating an access record from an excel userform (excel '97) (24 replies)
  183. top 5 and top 10 (4 replies)
  184. Solved: disable calculation (2 replies)
  185. Solved: Shifting rows to the right. (1 replies)
  186. Trouble Looping to eliminate multiple data (5 replies)
  187. Solved: Validating entry on a userform (Excel '97) (6 replies)
  188. Replace fonction vba (1 replies)
  189. Solved: How do I copy and insert rows (2 replies)
  190. How to find an error in my VBA !! (6 replies)
  191. counting data (4 replies)
  192. Formatting of data from text file into Excel File. (10 replies)
  193. days of the week (7 replies)
  194. code does work at home but not at work >< (1 replies)
  195. Error Checking for EOF / BOF Debug (1 replies)
  196. Solved: Show asterisk(****) in password VBA code (1 replies)
  197. Find function (7 replies)
  198. Solved: Only save with a Macro Button (2 replies)
  199. how to use vara function in vba (7 replies)
  200. Solved: Clearing Clip Art (8 replies)
  201. Solved: Naming a File (5 replies)
  202. Solved: Count Files in folder &amp; cell.value=NewFile.Name (8 replies)
  203. Solved: Error '1004' pops up randomly (3 replies)
  204. Hide / Unhide toolbars for a particular worksheet (8 replies)
  205. check for the values in the sheet 2 and count the values (11 replies)
  206. Solved: Merge Workbooks (6 replies)
  207. How to automaticlly disable a spreadsheet after a period of time (3 replies)
  208. Export Problem (2 replies)
  209. Error: 1004 (4 replies)
  210. [SOLVED:] Code added by VBA ends up on wrong sheet? (2 replies)
  211. Solved: Macro will not save (31 replies)
  212. Deleting all rows of named merged range (5 replies)
  213. Solved: Convert number to letter (16 replies)
  214. Last non-blank cell in a row or column (2 replies)
  215. Pop Messag Box required if value is different (2 replies)
  216. Updating external reference of a picture (0 replies)
  217. Hide/Uhide rows without macro (2 replies)
  218. Dynamic Group by, with Subtotal and Grandtotal (6 replies)
  219. UserForm;ListBox Select show Picture (7 replies)
  220. User Form Looping Problem (18 replies)
  221. Solved: should work but doesn't - application.inputbox problem? (3 replies)
  222. Unhide based on Calculate event (7 replies)
  223. Worksheet_Calculate() Multiple Ranges (2 replies)
  224. Create a working CommandButton in a Userformusing VBA Code (23 replies)
  225. Macro Help (11 replies)
  226. force enable macros (9 replies)
  227. Solved: DAYS360 function within VB (3 replies)
  228. Basic FTP upload problems please help, kinda urgent? (11 replies)
  229. Merging text from selected range of cell (16 replies)
  230. Solved: substitute &quot;.&quot; with &quot;&quot; and give format (21 replies)
  231. Solved: Checkbox with userform (3 replies)
  232. Solved: Problems with GetOpenFileName (4 replies)
  233. Solved: But it was working 5 minutes ago.... (8 replies)
  234. Phantom MsgBox (12 replies)
  235. Solved: Pagesetup.PaperSize (2 replies)
  236. side by side stack charts (10 replies)
  237. Sleeper: Sum rows based on column criteria (1 replies)
  238. Solved: Excel ShapeRange.Align (1 replies)
  239. Open all files in a directory and merge to one file (10 replies)
  240. CASE Statement type mismatch (2 replies)
  241. Passing a value to another sub routine (4 replies)
  242. VBA can not use Mshflexgrid.ocx SP6 (1 replies)
  243. Next With out for error (4 replies)
  244. Get a value from a cell (3 replies)
  245. Values used for multiple button clicks (3 replies)
  246. Solved: copying comments (9 replies)
  247. Solved: Finding local maximums in same cells on many sheets (21 replies)
  248. Conditional colouring (6 replies)
  249. userform toolbox (11 replies)
  250. row selection (18 replies)