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:] Textbox on a form deletes rows (7 replies)
  2. InputBox help (5 replies)
  3. [SOLVED:] Work Week dates from Week Numbers (2 replies)
  4. [SOLVED:] Determine level of folder in path string (e.g. C:\Level 1\Level 2\Level 3 return 3) (6 replies)
  5. [SOLVED:] VBA Find and Message Box Execution (14 replies)
  6. UserForm - Add and Use Controls at RunTime. (16 replies)
  7. [SOLVED:] Picture Copy Help (5 replies)
  8. [SOLVED:] Searching and copying values within a sheet (2 different operations) (8 replies)
  9. [SOLVED:] Listbox conditional Adding Items (2 replies)
  10. [SOLVED:] Combo box using OLEobjects (1 replies)
  11. Need more robust "find text" VBA (3 replies)
  12. Help - VBA to automatically reorder columns (3 replies)
  13. Fullseriescollection - replacing Excel 2013 VBA with Excel 2010 - help! (2 replies)
  14. VBA to pull data from word document (0 replies)
  15. [SOLVED:] SQL Statement with WHERE condition (2 replies)
  16. [SOLVED:] VBA ListBox right alignment display issue (19 replies)
  17. [SOLVED:] Adding cells via button (4 replies)
  18. Data Sets and Regression (14 replies)
  19. Arithmetic Errors (1 replies)
  20. [SOLVED:] Resize Array (2 replies)
  21. [SOLVED:] Copy range from sheets with similar name. (4 replies)
  22. Outlook signature (from an excel spreadsheet) (2 replies)
  23. Loop through tasks to GetObject() (19 replies)
  24. [SOLVED:] Complex file merging, step one: fill empty cells with cells from another column. (5 replies)
  25. Is my Code Too long?? (6 replies)
  26. Resize a range/shape in excel beore pasting it in Powerpoint (1 replies)
  27. [SOLVED:] Using Copy Destination for values and number formatting (4 replies)
  28. [SOLVED:] Coloring Selection (14 replies)
  29. Copy the unique value from all sheets & paste new file & E-Mail it to party wise (0 replies)
  30. [SOLVED:] get filename from url (7 replies)
  31. Using macro to import stock symbol (1 replies)
  32. search, help needed (5 replies)
  33. 2 lists, copy unique rows (2 replies)
  34. Refreshing All Pivot Tables in all Worksheets (1 replies)
  35. Change cells number format off an other cells value (3 replies)
  36. IN VBA create a Data Vaildation List from a Case Selection (10 replies)
  37. How do I search a URL on a mac? (with VBA) (1 replies)
  38. [SOLVED:] Baffling problem inserting Formula into Range, error 1004 (2 replies)
  39. [SOLVED:] Textbox data validation (6 replies)
  40. VBA Help (2 replies)
  41. [SOLVED:] How do I import data from URL's in an excel sheet (11 replies)
  42. [SOLVED:] Find and replace in word doc from excel vba. (5 replies)
  43. How do I add values to cells at the end of a row I just inserted through my VB code (7 replies)
  44. [SOLVED:] How to sum cells based on ?? (array? constants?) (6 replies)
  45. [SOLVED:] UserFrom TextBox search in ListBox in the same UserForm? (12 replies)
  46. [SOLVED:] Code behaving differently between "Module Sub" and "Private Sub Workbook_Open()" (3 replies)
  47. What is the correct code to delete only the values in a range? (3 replies)
  48. Drop downs in Excel (1 replies)
  49. VBA code to copy and paste row based on certain criteria (6 replies)
  50. Launch Shortcut(lnk) through VBA (1 replies)
  51. [SOLVED:] Error Message when value appears in a range (2 replies)
  52. [SOLVED:] Copy content of Several Webpages (7 replies)
  53. Get file names from folder problem! (4 replies)
  54. query : to track the time spent on a VBA project (1 replies)
  55. [SOLVED:] Getting Hyperlink Address (3 replies)
  56. validations code for negative and changed values (1 replies)
  57. [SOLVED:] VBA to compare sheet 1 and sheet 2 (2 replies)
  58. [SOLVED:] schedule to yearschudele (1 replies)
  59. [SOLVED:] Deletes a row if it does start with a number+ Loop (3 replies)
  60. Value of Cell to be displayed (1 replies)
  61. How to Find the First Blank row on my Excel Sheet usin VBA (4 replies)
  62. [SOLVED:] Listbox help (7 replies)
  63. VBA - Issue with index (I think) - Please Help (2 replies)
  64. Creating multiple sheet along with suffix or prefix assign as per user defined (13 replies)
  65. [SOLVED:] Sum Help (1 replies)
  66. [SOLVED:] What's wrong with my "Select Case" (9 replies)
  67. Power Point Generation with Excel (11 replies)
  68. Copy filenames from a folder and fetch data in respective rows from those files (6 replies)
  69. [SOLVED:] Accumulating sheet with a range of cells in the other sheet with a range of cells (9 replies)
  70. VBA to Open Workbook (4 replies)
  71. Remove Multiple Header Rows (5 replies)
  72. validation for Negative number (2 replies)
  73. Fetch Data automatically in a single cell (6 replies)
  74. vba - Fetch Data automatically in a single cell (2 replies)
  75. Search Engine for files inside Common Folders. (9 replies)
  76. copy every 2 rows of data into a pipe delimited text file (5 replies)
  77. Matrix Multiplication VBA (2 replies)
  78. [SOLVED:] Excluding worksheets from the Table of Contents (5 replies)
  79. [SOLVED:] Format column in workbook (3 replies)
  80. Find earliest and latest date in ranges with blanks (12 replies)
  81. Landscape and Portrait format at the same sheet (2 replies)
  82. [SOLVED:] Compare lines in two sheets (19 replies)
  83. [SOLVED:] sending listbox contents to access (12 replies)
  84. [SOLVED:] Copy from Active workbook to opened Master Workbook (2 replies)
  85. Autofilter Issue (8 replies)
  86. Copy/Parse Data from MS Word to MS Excel (12 replies)
  87. [SOLVED:] Forms always visible (6 replies)
  88. VBA to extract Data from Word to Excel (1 replies)
  89. [SOLVED:] How to keep the value of a variable between 2 Sub (same module) (5 replies)
  90. [SOLVED:] Filter Excel Data using vba Multiple Columns Multiple Criteria (8 replies)
  91. [SOLVED:] I can not activate these two macros together (6 replies)
  92. [SOLVED:] Need VBA to delete all link in sheet except sum formula (2 replies)
  93. Exel File Corrupt when opening (1 replies)
  94. [SOLVED:] Open File name contained in specific cell (4 replies)
  95. Random Selection in Excel using VBA (7 replies)
  96. Cannot Find Source of Error 9 (3 replies)
  97. [SOLVED:] Change a Command Button Caption at certain conditions. (11 replies)
  98. [SOLVED:] Macro show/hide with show/hide zeros in cells (3 replies)
  99. [SOLVED:] Convert from Worksheet_Change to manual (4 replies)
  100. [SOLVED:] Summary to be generated from excel files in vba. (5 replies)
  101. intranet web site (0 replies)
  102. Loop through array of buttons on a Pivot table (1 replies)
  103. [SOLVED:] Obtaining password from worksheet range (5 replies)
  104. [SOLVED:] Message Box using vbYesNo (10 replies)
  105. [SOLVED:] Create new text files using Cell values as titles (3 replies)
  106. Help with Public Variable Not Retaining Value (6 replies)
  107. [SOLVED:] Help with parsing string from right.. (6 replies)
  108. Business System Ideas - Advice Needed! (14 replies)
  109. First two digits delete from text file by macro (0 replies)
  110. [SOLVED:] Link word table to excel (2 replies)
  111. macros code help ! (1 replies)
  112. Loops vs. Arrays (5 replies)
  113. Three Dimensional Linear Interpolation UDF (14 replies)
  114. Copy Row to another Sheet By Value in Column (2 replies)
  115. Name & Save workbook from a specific sheet cell value (2 replies)
  116. How to protect excel sheet and formulas (1 replies)
  117. Macro limits saving of the data (30 replies)
  118. Macro adds a row up without data (2 replies)
  119. Compare and extract column (2 replies)
  120. Macro to Match Values on two sheets (3 replies)
  121. Appending files (16 replies)
  122. [SOLVED:] Can someone check these 5 lines of code? (9 replies)
  123. [SOLVED:] Macro to do one thing before 16:00 Hrs & something else after 16:00 hrs (2 replies)
  124. Less than or equal to code (1 replies)
  125. loop through multiple word files and import content control info to excel (8 replies)
  126. [SOLVED:] Position modeless userform to top right of Activewindow (10 replies)
  127. [SOLVED:] Modeless progress bar (6 replies)
  128. Activate DropDown List and Calendar when Cell Selected (5 replies)
  129. Copy Pasting Data across Excel Sheets using VBA (in background & without clipboard)? (2 replies)
  130. [SOLVED:] If Cell in range = 0 then three different scenarios (2 replies)
  131. [SOLVED:] Un-parallel lists - need HELP (3 replies)
  132. VBA function for mortgage calculations (3 replies)
  133. [SOLVED:] Transposing formulas (24 replies)
  134. [SOLVED:] Macro eliminates row and fix alignment (2 replies)
  135. [SOLVED:] Input mask percentages (4 replies)
  136. Macro detects data and paste into another spreadsheet (11 replies)
  137. SLA Response Formula for 2 diff SLA times (1 replies)
  138. [SOLVED:] Large-Scale Find/Replace In Word With Excel Lists (17 replies)
  139. [SOLVED:] Excel Macro - What am I missing? (3 replies)
  140. Algorithm For Compare Rows by Three Columns (4 replies)
  141. [SOLVED:] chr 10 (5 replies)
  142. [SOLVED:] Remove specific contains (3 replies)
  143. Guidance saught: Switching to/from excel using AppActivate (1 replies)
  144. use variable in formula (3 replies)
  145. Save invoice problem (3 replies)
  146. sum of 3 dates (3 replies)
  147. Formattung lost when copying/pasting into excel cell using VBa (2 replies)
  148. Run-time error 91 when trying to close workbook without saving (4 replies)
  149. [SOLVED:] Unhiding multiple sheet based on choice prompted after entering password (5 replies)
  150. Excel macro (3 replies)
  151. Sleeper: Access Textbox and Button inside the form of a frame of a webpage (0 replies)
  152. searching a string and adding to it (5 replies)
  153. [SOLVED:] dynamically display Activex control by the active worksheet (2 replies)
  154. [SOLVED:] For/Next for Blanking Fields (3 replies)
  155. Cell format changing when file open manually and VBA (3 replies)
  156. Copy data from one Excel sheet to another but on if data in to columns match (1 replies)
  157. [SLEEPER:] Copy a column from one tab to another using a column reference (5 replies)
  158. hi help me for my project (18 replies)
  159. Force marcos to be enabled and lock cells (2 replies)
  160. Button - Create/Fill/Export (1 replies)
  161. [SOLVED:] Including Special Characters (i.e. parenthesis) Within Text (2 replies)
  162. How to insert any user name into a file path (2 replies)
  163. [SOLVED:] Format ActiveX Listbox for Currency (17 replies)
  164. BAR CODES IN EXCEL (2 replies)
  165. [SLEEPER:] application.filesearch not working in Excel 2010 (2 replies)
  166. [SOLVED:] VBA Consolidate Multiple Files (9 replies)
  167. [SOLVED:] Changes & creation of Code for hiding & unhiding columns & Sheet (18 replies)
  168. [SOLVED:] Macro adds a row and make a change (2 replies)
  169. [SOLVED:] Split String After 15 Characters (3 replies)
  170. [SOLVED:] Which Worksheet Event is best for calculations? (16 replies)
  171. Return corresponding match count (1 replies)
  172. NEED HELP : LOOKUP VBA CODING (1 replies)
  173. [SOLVED:] Pivot Table Creation with Optional Arguments (11 replies)
  174. Userforms (codes and formulas) (11 replies)
  175. VBA Pivot Table Update Run Time Error (0 replies)
  176. [SOLVED:] Textbox to regain focus (13 replies)
  177. [SOLVED:] Need input box when user does not enter a number or presses cancel (7 replies)
  178. Sort two columns - not working (4 replies)
  179. Word macro - need to run it from excel... (21 replies)
  180. [SOLVED:] Comparing Data & Marking Differences (6 replies)
  181. List Folder Names (3 replies)
  182. [SOLVED:] Highlighting cells different colors for pending expiration date (2 replies)
  183. Please Help me!! My Shift+Del recovered XLS file is having data in unknow language! (5 replies)
  184. Extracting data from html files (within certaing tags) into Excel file (0 replies)
  185. compare 2 list and find missing entry (2 replies)
  186. Data exctraction from one sheet to another (3 replies)
  187. VBA Script to import Sheet content from external workbook (4 replies)
  188. CSV files processing (7 replies)
  189. Open Password protected zip file using vba (5 replies)
  190. Paste as text not BMP! in lotus notes (2 replies)
  191. Update SharePoint List from Excel using VBA (1 replies)
  192. [SOLVED:] Excel 2013 - text box glitch - tiny cursor on entry, font size fine on exit (4 replies)
  193. [SOLVED:] excel userform calendar for leave tracking (10 replies)
  194. Macro to Clear Rows Not Containing a Particular Word/Text Across Worksheets (2 replies)
  195. Require macro for the attached scenario (1 replies)
  196. Shared document/Multiple Users - tops please :) (1 replies)
  197. Sleeper: Copy Data From INTERNET EXPLORER into Excel using vba (0 replies)
  198. total Fridays in a range (11 replies)
  199. [SOLVED:] Please help Chart data (9 replies)
  200. Bitten off more than I can chew. (5 replies)
  201. [SOLVED:] Using multiple if criteria in VBA (2 replies)
  202. Sleeper: Macro built on Win64 not running on Win32 (6 replies)
  203. [SOLVED:] Issues in conditional formatting (2 replies)
  204. Copy Columns With Specific Headers--Paste Into Separate Workbook Based On Header (3 replies)
  205. [SOLVED:] Re-Activating OnSave Macro (8 replies)
  206. [SOLVED:] Need Error Check (10 replies)
  207. [SOLVED:] Renaming a text file and extension from content (6 replies)
  208. Run Access create table query from Excel with msgbox displaying records created (3 replies)
  209. [SOLVED:] Bypass Run-time error '13'? (3 replies)
  210. Extract portion of web page to excel using VBA (0 replies)
  211. When choosing an image according to the number in a cell to show marked (6 replies)
  212. Re-Arrange Data based on FLAG (6 replies)
  213. [SOLVED:] How to Make Copy of Word Document (5 replies)
  214. [SOLVED:] Changing the Row reference of a formula (7 replies)
  215. Show Zero Value in Cell (3 replies)
  216. Excel 2010 huge file size (3 replies)
  217. INDIRECT() function doesn't work: "Can't Find Object or Library" (7 replies)
  218. Strange delay in execution of MailTo Macro code (4 replies)
  219. Help With Counting (4 replies)
  220. Prevent form from closing after programmatically adding code (7 replies)
  221. [SOLVED:] Paste a columns formats and formulas not its values (3 replies)
  222. Fastest way to temporarily store results for further analysis (23 replies)
  223. HELP : Extract value with criteria color (1 replies)
  224. [SOLVED:] Code Execution Interrupted when Reloading Userform (5 replies)
  225. [SOLVED:] Repeat a column Insert in the same position on two other sheets. (4 replies)
  226. Hello my fellow nerds (1 replies)
  227. [SOLVED:] InStr reading cells - doing something wrong (4 replies)
  228. VBA code to merge cells (7 replies)
  229. [SOLVED:] Macro code for matching and replacing the values (4 replies)
  230. [SOLVED:] time utilization (2 replies)
  231. [SOLVED:] Selecting Multiple Items in a Pivotfield, Hoping to be able to Toggle with a Hotkey (6 replies)
  232. Auto paste special on lookup formulas if value is found (1 replies)
  233. [SOLVED:] VBA Code to populate to end of data (4 replies)
  234. [SOLVED:] vba function to return random sign (2 replies)
  235. [SOLVED:] VBA MACRO CODE FOR REMOVING CELLS AND APPEARING IT CONTINOUSLY (2 replies)
  236. [SOLVED:] Sum Based On condition! (6 replies)
  237. Put Data On One Row in Excel With Many Forms (4 replies)
  238. Fill in InputBox using VBA (6 replies)
  239. [SOLVED:] VBA Coding to Repalce a List of Words with one word. (9 replies)
  240. Interpolation and calculation from table (6 replies)
  241. [SOLVED:] Worksheet focus change issues with userform(s) (13 replies)
  242. [SOLVED:] Calculating Min,Max,Quartile in dynamic ranges (22 replies)
  243. VBA: extract systematiically 5 rows and save them in a new excell file as .txt (4 replies)
  244. Object variable or With block variable not set error (1 replies)
  245. [SOLVED:] Check & Copy Data (5 replies)
  246. VBA Index/Multiple Match criteria (1 replies)
  247. [SOLVED:] Select Case nested in If Else... where's the break? (4 replies)
  248. [SOLVED:] Average times as long as between 2 dates (5 replies)
  249. [SOLVED:] Close a command button after it has been clicked (6 replies)
  250. [SOLVED:] Export embedded Word document and set data (2 replies)