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. Solved: Excel VBA Code for higlighting Pass Or Fail profile (9 replies)
  2. replace text/integer within a formula (4 replies)
  3. Solved: color (8 replies)
  4. edit values of a cell through textbox in a user form (4 replies)
  5. Solved: Need help with adding yes/no msgbox to Find Procedure (5 replies)
  6. change the (Worksheet_Change) event for a module (Sub). (19 replies)
  7. Allow Group/Ungroup on protected sheet (3 replies)
  8. Solved: Paste block of data into certain cells (2 replies)
  9. Solved: Expression not running all the way through (2 replies)
  10. Solved: More on SumProduct (2 replies)
  11. Solved: Blank cells (1 replies)
  12. Force user to enable macros (6 replies)
  13. Solved: Using ElseIF (3 replies)
  14. Error of Advanced filter, copy & paste from different worksheets using 1 cmd button (0 replies)
  15. Solved: SumProduct Help (5 replies)
  16. Solved: Trim extra characters from Column F (4 replies)
  17. Solved: Quintiles and Conditional Formatting (3 replies)
  18. Combine Data that obviously the same (1 replies)
  19. Import data from website (3 replies)
  20. VBA to logon to Webpage (JSP)? (0 replies)
  21. Date and time calculation (2 replies)
  22. populate combobox when workbook is open (1 replies)
  23. Recall data to my userform (1 replies)
  24. Check Box Issue (2 replies)
  25. Sleeper: Select column and row(s) and change format (4 replies)
  26. I feel Computer Illeterate (1 replies)
  27. Autoupdate Dropbox Values (8 replies)
  28. Solved: Modify Copy to spreadsheet (4 replies)
  29. Worksheet_BeforeDoubleClick is not invoked (2 replies)
  30. Count of distributors based on criteria (2 replies)
  31. Add value in empty cell always same line column after column (2 replies)
  32. Adding Data Rows into excel using user inputs. (1 replies)
  33. Solved: Choose a folder in a directory if found. (6 replies)
  34. VB+Excel help (2 replies)
  35. Solved: Option Buttons in Multipage Form (10 replies)
  36. [SOLVED:] How to stop a specific VBA loop?? (10 replies)
  37. Unselect missing line in "References VBAProject" (3 replies)
  38. Solved: Find final Row In Mearge TOP Cell (6 replies)
  39. Shade Weekends in Calendar (13 replies)
  40. Solved: merge blank record in first column (4 replies)
  41. Problem in adding record using macro (2 replies)
  42. sum of mismatch records (1 replies)
  43. Date Tranformation (6 replies)
  44. Error when set value to an worksheet object (10 replies)
  45. Solved: Looking for a more 'flexible' Match() (6 replies)
  46. [SLEEPER:] OnTime Problem ..? (2 replies)
  47. Workbook Parameters compare (1 replies)
  48. Data Validation List (1 replies)
  49. Solved: Find a string and align left (13 replies)
  50. sumproduct help .. (6 replies)
  51. Solved: Find Last Used Cell In a Table (5 replies)
  52. Look up values through hierarchies (2 replies)
  53. Solved: Extend Range selection Down (2 replies)
  54. Solved: Help with Pivot Tables (2 replies)
  55. Pesky users, causing issues with userform (5 replies)
  56. The active cell in a sheet other than the active sheet (VBA Excel) (1 replies)
  57. Problem with OnAction (3 replies)
  58. Write Hebrew characters to file in VBA (1 replies)
  59. Solved: Open Txt File and Copy data (10 replies)
  60. Help with Excel & Office Web Component!! (5 replies)
  61. pause and continue (5 replies)
  62. How to analyze and sort data using VBA (3 replies)
  63. insert row above button (retrieve position of button) (8 replies)
  64. Error using .Find across worksheets (4 replies)
  65. Solved: UF Count Tally (4 replies)
  66. Cell copy the data to another cell with offset (2 replies)
  67. Frequently bought together (11 replies)
  68. Plotting an arrow in excel using VBA (3 replies)
  69. Calculate Correlations Based on Changing Parameters (16 replies)
  70. Solved: whats the difference (3 replies)
  71. Assigning macro to print button code help (8 replies)
  72. [SOLVED:] Interchanging data on different sheets (26 replies)
  73. Solved: copy data to another spreadsheet (12 replies)
  74. Solved: Producing multiple spreadsheets by running data from excel database (10 replies)
  75. expired workbook (6 replies)
  76. ListBox Index Select (2 replies)
  77. Transpose Range on Key (6 replies)
  78. Dont Change Folder/Zip File after Zipping & Unzipping (10 replies)
  79. match or vlookup help (6 replies)
  80. Solved: Delete Empty cells with condition (25 replies)
  81. improving class modules with syntax sugar (5 replies)
  82. need help with a code (2 replies)
  83. Next and Prev. command (2 replies)
  84. Assign Keyboard Shortcut to Ribbon Item Excel 2007 (1 replies)
  85. Excel 2010 fuzzy vlookup add in (0 replies)
  86. VBA drop down and he internet (0 replies)
  87. Real challenge from my professor (2 replies)
  88. Array function (5 replies)
  89. Solved: Writing data from workbook to text file (4 replies)
  90. Converting conditional format to permanent and reference to shapes (0 replies)
  91. Solved: Create Monthly Calendar using Userform (17 replies)
  92. Solved: Save as and File Directory (22 replies)
  93. VB ClearContents if add-on (Excel 2003) (2 replies)
  94. Solved: Delete Unused rows in a table (10 replies)
  95. userform combobox requirement (2 replies)
  96. unable to set focus (5 replies)
  97. extract data from multiples excel files (2 replies)
  98. pivot table automation (1 replies)
  99. Find and Replace of Formula Result (1 replies)
  100. Solved: VBA Code help. (5 replies)
  101. Solved: Make text in a cell bold (4 replies)
  102. Question about Slicers (1 replies)
  103. Arrange Images relative to each other (4 replies)
  104. Hidden ActiveX Controls Disappearing (5 replies)
  105. Solved: Inserting a formula with VBA (6 replies)
  106. cell blinking (3 replies)
  107. Solved: Avoid Screen flickering and selection (5 replies)
  108. Solved: vbs creates .xml from folders - how to run excel macro at end (24 replies)
  109. [SOLVED:] Worksheet event does nothing (2 replies)
  110. formula copy (1 replies)
  111. Macro - transpose - audit (2 replies)
  112. [SOLVED:] Multiplying cells in a range only if they have content (7 replies)
  113. [SOLVED:] Borders on a Range of Cells (2 replies)
  114. [SOLVED:] backup of file with date (4 replies)
  115. [SOLVED:] Hide and Unhide rows based on the condition set (4 replies)
  116. auto select (5 replies)
  117. search and count values (12 replies)
  118. Solved: Excel Functions VBA (16 replies)
  119. [SOLVED:] NOVICE QUESTION: Referencing Integer Arrays (8 replies)
  120. Converting Access SQL to EXCEL SQL (8 replies)
  121. [SOLVED:] Using array and column data to creat new sheets (3 replies)
  122. run Time error '76 -looking for files within Sharepoint (2 replies)
  123. [SOLVED:] Highlight row based on cell value (5 replies)
  124. Solved: Cell Name as a variable to feed (5 replies)
  125. Understanding brettdj multiple goal seek code (25 replies)
  126. [SOLVED:] Formula In Entire COlumn (8 replies)
  127. Solved: Fine Tuning an Application Event (30 replies)
  128. [SOLVED:] Hiding multiple non-contiguous rows simultaneously and quickly (7 replies)
  129. Excel Phonebook (3 replies)
  130. auto populate with cell change event? (7 replies)
  131. add message to macro (2 replies)
  132. 3 pairs of If and end if (2 replies)
  133. VBA for Dynamic source data for charts (2 replies)
  134. Copy data to Master file from Different Sheets (1 replies)
  135. VBA AND XML (1 replies)
  136. Create blank lines between all current (1 replies)
  137. [SOLVED:] UserForm Radio Buttons (5 replies)
  138. How to save webpage as html to drive (1 replies)
  139. Solved: locked method of range failed (1 replies)
  140. Need Macro to create a Format (5 replies)
  141. Excel 2010 VBA Insert new row changes formula (4 replies)
  142. Dates (5 replies)
  143. Solved: Select the last used row in a column using VBA (9 replies)
  144. Solved: Referencing objects (8 replies)
  145. Comparison (1 replies)
  146. Find all possible paths in a Flowchart (0 replies)
  147. Filling Arrays (2 replies)
  148. Solved: Run code when workbook opens (6 replies)
  149. FindNext (3 replies)
  150. Search in every column for a value in a specific row, then insert a column before IF (1 replies)
  151. PasteSpecial (5 replies)
  152. Solved: Run a macro by refernce to a cell (5 replies)
  153. Solved: Conditional Formatting Help excel 2003 (5 replies)
  154. [SOLVED:] Condtional format but if Cell next displays "Y", conditional colour should Green (2 replies)
  155. VBA pulling data from a table (0 replies)
  156. Sumif for text + concatenation (2 replies)
  157. Paste the file names in a excel sheet (13 replies)
  158. compile error (2 replies)
  159. Solved: where to put end if (36 replies)
  160. how to write a vba code to perform complex calculations (12 replies)
  161. Import specific cells from a website table (0 replies)
  162. VB Code help on Worksheets (48 replies)
  163. VBA email - MERGE addresses (3 replies)
  164. Merge all data in 1 cell with format (1 replies)
  165. Merging Cell EntireRow.Insert Excel 2003 (2 replies)
  166. Shortening VB Code (3 replies)
  167. Solved: Average if (11 replies)
  168. Sort By Value In Cell (5 replies)
  169. Solved: Updating Data Multipage 2 to Page 1 Combo box (10 replies)
  170. CrePivot Table To Show All Value/Field Columns (5 replies)
  171. Add the file name in the header of the PDF (2 replies)
  172. Excel Calender (2 replies)
  173. Reading/writing MP3 properties with Excel VBA (10 replies)
  174. Solved: Trying to create a text box in word from excel (7 replies)
  175. Foreign language (1 replies)
  176. serial search (5 replies)
  177. Speed up a slow code (14 replies)
  178. Macro to combine output of two sheet into one (2 replies)
  179. Export to text file (5 replies)
  180. Solved: Adding another code the original VBA code (Excel 2003) (10 replies)
  181. Loop until found / user cancels (12 replies)
  182. Simple multiplication (3 replies)
  183. Applying code to entire column (5 replies)
  184. click and move (1 replies)
  185. Solved: Find and Replace not working (20 replies)
  186. Solved: sort data on cell by value order (14 replies)
  187. Split sheet to different files - variable number of rows (11 replies)
  188. How to speed up this macro? How to use an array? (9 replies)
  189. Get details button from a data. (8 replies)
  190. Compare 2 VBA Projects (code) (28 replies)
  191. Solved: Cdate in range form number => date (14 replies)
  192. hyperlink (5 replies)
  193. Send email when changes made (3 replies)
  194. Solved: create html code from parsed xml data on worksheet (4 replies)
  195. Conditional format an indentation based upon a formula from separate cell (4 replies)
  196. Get Data from Closed Wrokbook based on Criteria (0 replies)
  197. Equalities (2 replies)
  198. Solved: Excel VBA changing case (3 replies)
  199. Combination (2 replies)
  200. How check if add ins run? (2 replies)
  201. Solved: formula to collection (9 replies)
  202. Solved: Run time error 91 (11 replies)
  203. copy found data to other cloumn (1 replies)
  204. [SOLVED:] Macro to sum each row if have same value (2 replies)
  205. Solved: move data with * symbol to another sheet (3 replies)
  206. Prob in substitution (5 replies)
  207. Wanna sb can do sth would help!Ty in advanced anyways. (0 replies)
  208. Solved: Listbox value as input (5 replies)
  209. Dates (1 replies)
  210. Solved: Compare 2 sheets and delete matched rows (2 replies)
  211. Using ADO to import Data (6 replies)
  212. Search and Compare (6 replies)
  213. using formula in coding (6 replies)
  214. Solved: Macro to convert num to char (4 replies)
  215. PLEASE Help with Looping (2 replies)
  216. Excel VBA and CUDA (0 replies)
  217. Subscript out of range (5 replies)
  218. Search for row, check and count max match with another range (23 replies)
  219. Solved: hyperlink a cell to a textbox (5 replies)
  220. VBA to automate a process (10 replies)
  221. Solved: Date format (2 replies)
  222. Solved: compare 1 cell with 5 cell (13 replies)
  223. Solved: Delete dash with space (2 replies)
  224. Solved: extract data from website to excel (5 replies)
  225. go to (2 replies)
  226. Merge all data in column just to 1 cell (2 replies)
  227. Solved: Excel countif multiple criteria (2 replies)
  228. Hide and unhide the worksheets in vba with dialog box (8 replies)
  229. Browse a Folder and Populate Listbox with Folder Items (21 replies)
  230. Solved: Convert exponential format to a number ? (3 replies)
  231. Writing a macro within an exel document (1 replies)
  232. Difference between .responsetext and .document (3 replies)
  233. Sleeper: vba Appointment body (16 replies)
  234. New here: I have som questions about Excel and VBA (0 replies)
  235. [SLEEPER:] Set Pie Chart & Pie Chart Tags to be Same (2 replies)
  236. help with user forms (1 replies)
  237. MERGING SHEETS (2 replies)
  238. Unlock all VBA projects (1 replies)
  239. macro loop through 2 worksheets (2 replies)
  240. Excel VBA Error 'Excel Ran out resources' - Reg (0 replies)
  241. Solved: Check if today is a specific date that falls on certain weekday regardless of year (3 replies)
  242. Solved: Auto Hyperlink to Folders (3 replies)
  243. vba sumifs (2 replies)
  244. Error occurs then the code is already launched (2 replies)
  245. Error occuring then code is already launched (1 replies)
  246. Looking for a faster way to autohide rows (3 replies)
  247. Scroll to column via Combobox (4 replies)
  248. Solved: vlookup problems (4 replies)
  249. A simple printing pages depending on cell value (3 replies)
  250. moving objects from excel to PowerPoint can not turn lock aspect ratio off (0 replies)