PDA

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. [SOLVED:] Highlighting cells different colors for pending expiration date
  2. List Folder Names
  3. [SOLVED:] Comparing Data & Marking Differences
  4. Word macro - need to run it from excel...
  5. Sort two columns - not working
  6. [SOLVED:] Need input box when user does not enter a number or presses cancel
  7. [SOLVED:] Textbox to regain focus
  8. VBA Pivot Table Update Run Time Error
  9. Userforms (codes and formulas)
  10. [SOLVED:] Pivot Table Creation with Optional Arguments
  11. NEED HELP : LOOKUP VBA CODING
  12. Return corresponding match count
  13. [SOLVED:] Which Worksheet Event is best for calculations?
  14. [SOLVED:] Split String After 15 Characters
  15. [SOLVED:] Macro adds a row and make a change
  16. [SOLVED:] Changes & creation of Code for hiding & unhiding columns & Sheet
  17. [SOLVED:] VBA Consolidate Multiple Files
  18. [SLEEPER:] application.filesearch not working in Excel 2010
  19. BAR CODES IN EXCEL
  20. [SOLVED:] Format ActiveX Listbox for Currency
  21. [SLEEPER:] How to insert any user name into a file path
  22. [SOLVED:] Including Special Characters (i.e. parenthesis) Within Text
  23. Button - Create/Fill/Export
  24. Force marcos to be enabled and lock cells
  25. hi help me for my project
  26. [SLEEPER:] Copy a column from one tab to another using a column reference
  27. Copy data from one Excel sheet to another but on if data in to columns match
  28. Cell format changing when file open manually and VBA
  29. [SOLVED:] For/Next for Blanking Fields
  30. [SOLVED:] dynamically display Activex control by the active worksheet
  31. searching a string and adding to it
  32. Sleeper: Access Textbox and Button inside the form of a frame of a webpage
  33. Excel macro
  34. [SOLVED:] Unhiding multiple sheet based on choice prompted after entering password
  35. Run-time error 91 when trying to close workbook without saving
  36. Formattung lost when copying/pasting into excel cell using VBa
  37. sum of 3 dates
  38. Save invoice problem
  39. use variable in formula
  40. Guidance saught: Switching to/from excel using AppActivate
  41. [SOLVED:] Remove specific contains
  42. [SOLVED:] chr 10
  43. Algorithm For Compare Rows by Three Columns
  44. [SOLVED:] Excel Macro - What am I missing?
  45. [SOLVED:] Large-Scale Find/Replace In Word With Excel Lists
  46. SLA Response Formula for 2 diff SLA times
  47. Macro detects data and paste into another spreadsheet
  48. [SOLVED:] Input mask percentages
  49. [SOLVED:] Macro eliminates row and fix alignment
  50. [SOLVED:] Transposing formulas
  51. VBA function for mortgage calculations
  52. [SOLVED:] Un-parallel lists - need HELP
  53. [SOLVED:] If Cell in range = 0 then three different scenarios
  54. Copy Pasting Data across Excel Sheets using VBA (in background & without clipboard)?
  55. Activate DropDown List and Calendar when Cell Selected
  56. [SOLVED:] Modeless progress bar
  57. [SOLVED:] Position modeless userform to top right of Activewindow
  58. loop through multiple word files and import content control info to excel
  59. Less than or equal to code
  60. [SOLVED:] Macro to do one thing before 16:00 Hrs & something else after 16:00 hrs
  61. [SOLVED:] Can someone check these 5 lines of code?
  62. Appending files
  63. Macro to Match Values on two sheets
  64. Compare and extract column
  65. Macro adds a row up without data
  66. Macro limits saving of the data
  67. How to protect excel sheet and formulas
  68. Name & Save workbook from a specific sheet cell value
  69. Copy Row to another Sheet By Value in Column
  70. [SLEEPER:] Three Dimensional Linear Interpolation UDF
  71. Loops vs. Arrays
  72. macros code help !
  73. [SOLVED:] Link word table to excel
  74. First two digits delete from text file by macro
  75. Business System Ideas - Advice Needed!
  76. [SOLVED:] Help with parsing string from right..
  77. Help with Public Variable Not Retaining Value
  78. [SOLVED:] Create new text files using Cell values as titles
  79. [SOLVED:] Message Box using vbYesNo
  80. [SOLVED:] Obtaining password from worksheet range
  81. Loop through array of buttons on a Pivot table
  82. intranet web site
  83. [SOLVED:] Summary to be generated from excel files in vba.
  84. [SOLVED:] Convert from Worksheet_Change to manual
  85. [SOLVED:] Macro show/hide with show/hide zeros in cells
  86. [SOLVED:] Change a Command Button Caption at certain conditions.
  87. [SLEEPER:] Cannot Find Source of Error 9
  88. Random Selection in Excel using VBA
  89. [SOLVED:] Open File name contained in specific cell
  90. Exel File Corrupt when opening
  91. [SOLVED:] Need VBA to delete all link in sheet except sum formula
  92. [SOLVED:] I can not activate these two macros together
  93. [SOLVED:] Filter Excel Data using vba Multiple Columns Multiple Criteria
  94. [SOLVED:] How to keep the value of a variable between 2 Sub (same module)
  95. VBA to extract Data from Word to Excel
  96. [SOLVED:] Forms always visible
  97. Copy/Parse Data from MS Word to MS Excel
  98. Autofilter Issue
  99. [SOLVED:] Copy from Active workbook to opened Master Workbook
  100. [SOLVED:] sending listbox contents to access
  101. [SOLVED:] Compare lines in two sheets
  102. Landscape and Portrait format at the same sheet
  103. [SLEEPER:] Find earliest and latest date in ranges with blanks
  104. [SOLVED:] Format column in workbook
  105. [SOLVED:] Excluding worksheets from the Table of Contents
  106. Matrix Multiplication VBA
  107. copy every 2 rows of data into a pipe delimited text file
  108. Search Engine for files inside Common Folders.
  109. vba - Fetch Data automatically in a single cell
  110. Fetch Data automatically in a single cell
  111. validation for Negative number
  112. Remove Multiple Header Rows
  113. VBA to Open Workbook
  114. [SOLVED:] Accumulating sheet with a range of cells in the other sheet with a range of cells
  115. Copy filenames from a folder and fetch data in respective rows from those files
  116. Power Point Generation with Excel
  117. [SOLVED:] What's wrong with my "Select Case"
  118. [SOLVED:] Sum Help
  119. Creating multiple sheet along with suffix or prefix assign as per user defined
  120. VBA - Issue with index (I think) - Please Help
  121. [SOLVED:] Listbox help
  122. How to Find the First Blank row on my Excel Sheet usin VBA
  123. Value of Cell to be displayed
  124. [SOLVED:] Deletes a row if it does start with a number+ Loop
  125. [SOLVED:] schedule to yearschudele
  126. [SOLVED:] VBA to compare sheet 1 and sheet 2
  127. validations code for negative and changed values
  128. [SOLVED:] Getting Hyperlink Address
  129. query : to track the time spent on a VBA project
  130. Get file names from folder problem!
  131. [SOLVED:] Copy content of Several Webpages
  132. [SOLVED:] Error Message when value appears in a range
  133. Launch Shortcut(lnk) through VBA
  134. VBA code to copy and paste row based on certain criteria
  135. Drop downs in Excel
  136. What is the correct code to delete only the values in a range?
  137. [SOLVED:] Code behaving differently between "Module Sub" and "Private Sub Workbook_Open()"
  138. [SOLVED:] UserFrom TextBox search in ListBox in the same UserForm?
  139. [SOLVED:] How to sum cells based on ?? (array? constants?)
  140. How do I add values to cells at the end of a row I just inserted through my VB code
  141. [SOLVED:] Find and replace in word doc from excel vba.
  142. [SOLVED:] How do I import data from URL's in an excel sheet
  143. VBA Help
  144. [SOLVED:] Textbox data validation
  145. [SOLVED:] Baffling problem inserting Formula into Range, error 1004
  146. How do I search a URL on a mac? (with VBA)
  147. IN VBA create a Data Vaildation List from a Case Selection
  148. Change cells number format off an other cells value
  149. Refreshing All Pivot Tables in all Worksheets
  150. 2 lists, copy unique rows
  151. search, help needed
  152. Using macro to import stock symbol
  153. [SOLVED:] get filename from url
  154. Copy the unique value from all sheets & paste new file & E-Mail it to party wise
  155. [SOLVED:] Coloring Selection
  156. [SOLVED:] Using Copy Destination for values and number formatting
  157. Resize a range/shape in excel beore pasting it in Powerpoint
  158. Is my Code Too long??
  159. [SOLVED:] Complex file merging, step one: fill empty cells with cells from another column.
  160. Loop through tasks to GetObject()
  161. Outlook signature (from an excel spreadsheet)
  162. [SOLVED:] Copy range from sheets with similar name.
  163. [SOLVED:] Resize Array
  164. Arithmetic Errors
  165. Data Sets and Regression
  166. [SOLVED:] Adding cells via button
  167. [SOLVED:] VBA ListBox right alignment display issue
  168. [SOLVED:] SQL Statement with WHERE condition
  169. VBA to pull data from word document
  170. Fullseriescollection - replacing Excel 2013 VBA with Excel 2010 - help!
  171. Help - VBA to automatically reorder columns
  172. Need more robust "find text" VBA
  173. [SOLVED:] Combo box using OLEobjects
  174. [SOLVED:] Listbox conditional Adding Items
  175. [SOLVED:] Searching and copying values within a sheet (2 different operations)
  176. [SOLVED:] Picture Copy Help
  177. UserForm - Add and Use Controls at RunTime.
  178. [SOLVED:] VBA Find and Message Box Execution
  179. [SOLVED:] Determine level of folder in path string (e.g. C:\Level 1\Level 2\Level 3 return 3)
  180. [SOLVED:] Work Week dates from Week Numbers
  181. InputBox help
  182. [SOLVED:] Textbox on a form deletes rows
  183. [SOLVED:] Code limits its operation
  184. VBA to open word document from excel
  185. [SOLVED:] Help needed to assign multiple values to multiple variables
  186. [SOLVED:] Open word document from excel and search and highlight in word document
  187. [SOLVED:] Send data from Word VBA Project to New Excel Worksheet
  188. [SOLVED:] Dynamic range from sheet 1 as input to combo box on sheet 2
  189. How to use the SQL Insert Into Statement w/Excel
  190. Application.Undo fails in a big VBA project
  191. How to use the SQL Insert Into Statement with\Excel (Reposting)
  192. [SOLVED:] VB6 and Office 2013
  193. GEnerate Random Table From two Lists With Restrictions
  194. Excel Help
  195. [SOLVED:] Sort data Only A2 to LastCell
  196. [SOLVED:] Paste data from a specific row
  197. [SOLVED:] Text Work Week to follow throughout year
  198. [SOLVED:] paste a value in a cell that meets 2 conditions
  199. [SOLVED:] message box when tasks due and not complete
  200. [SOLVED:] Starting paste data from a specific row
  201. [SOLVED:] Filling same value in cells between two specified drop down years
  202. Get Date from filename using excel vba
  203. [SOLVED:] Data validation using dynamic named range as input
  204. [SOLVED:] Need idea to block all macro in a simple way
  205. [SOLVED:] Exit excel if the cells are clean
  206. [SOLVED:] Run Macro 4 time
  207. VBA Code to Pick data from one sheet and update data in another sheet accordingly.
  208. [SOLVED:] macro to open workbook in shifting folders
  209. [SOLVED:] Countif or countifs with multiple critera
  210. [SOLVED:] Macro deletes the value in the cell but keep the formula
  211. Combo-box to Reference data in a different workbook/Sub-Folder
  212. [SOLVED:] URGENCY Please: Delete a row by a textbox
  213. FileSystemObject / Microsoft Scripting Runtime in Excel 2010 VBA
  214. [SOLVED:] Microsoft Outlook Object Library Reference Missing
  215. [SOLVED:] calling a macro from another workbook after opening the other workbook
  216. [SOLVED:] URGENCY: Textbox does the union of the other textboxes
  217. I cannot figure out why my code will not plot my graph!
  218. Filling Cells with a TextBox matching a ComboBox - VBA Code
  219. id/count of a created shape/sheet and taken by the maus click(OnAction) are different
  220. Copy Sheets to Blank Template
  221. [SOLVED:] I'm having trouble setting a range in some worksheet code
  222. Compare + Conditional Formatting Help
  223. Adding conditional Data to multi column listbox
  224. [SOLVED:] Calendar pop up reminder
  225. [SOLVED:] Checking Powerpoint shape type programmatically from Excel
  226. Loop Macro Needed
  227. Excel Help Please!!! Making Duplicate Spreadsheets
  228. Errors in programming of Runge Kutta method in VBA
  229. VBA: Find Formula
  230. [SOLVED:] Best way to determine if more than one cell is selected
  231. Updating a set of checkboxes once a listbox changes
  232. [SOLVED:] Macro to copy multiple tables in a single sheet from excel to word doc
  233. Data from Excel to Access in a macro?
  234. [SOLVED:] Quotes within quotes format problem
  235. [SOLVED:] DATESERIAL problem
  236. Import custom Outlook 2010 tasks from Excel 2010 using VBA
  237. Run-time error '1004': Application-defined or object-defined error
  238. [SOLVED:] Choose File to Open Question
  239. [SOLVED:] Automatic random code pattern
  240. Records Count
  241. [SOLVED:] String Into a Formula to be Pasted in a Range
  242. set worksheet error
  243. Summing textboxes
  244. Run time error 5????
  245. Random Numbers with Random Pattern....
  246. [SOLVED:] Copy Updated Data from Closed workbook to Open workbook
  247. How to return to the previously viewed worksheet?
  248. [SOLVED:] using Multipage within a Multipage form
  249. Sleeper: With Application.FileSearch not working in 2010 macro
  250. [SOLVED:] Format in date