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

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