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

  1. Hi guys can you correct my code here?
  2. macro not working in 2007 (working in 2010)
  3. Solved: Problem in using Custom Format through VBA
  4. Solved: Detect when VBA code has finished
  5. Sorting multiple rows in descending order with their respective columns
  6. Solved: VBA EXCEL - Best way to add, divide, subtract and multiply.
  7. Formulas and Conditional Formatting
  8. use vba to copy a chart in excel to ms paint
  9. right formula
  10. copy data to another sheet
  11. String Variable - Compile Error Expected End of Statment
  12. Solved: VBA to select Filter Criteria
  13. VBA for Outlook
  14. Solved: Delete Column if row is blank
  15. Return Lowest Value of Row = todays date.
  16. Solved: Delete same rows
  17. VBA Macro for copy dates in new sheet(s)
  18. Find and replace text in Powerpoint from Excel
  19. Solved: Copy the latest row of sheet A to another sheet
  20. Solved: Converting Strings to Conditions
  21. Crystal Reports
  22. Solved: Replace part of a formula with its calculated value
  23. Code need help ... thanks
  24. Solved: how to prevent macro name visible to user.
  25. Solved: Question about User Defined Functions
  26. VBA Script to get Commision Amt
  27. Solved: Convert String?
  28. Solved: Hide Rows under the criteria above
  29. Solved: AutoRun the script
  30. Solved: simple If statement help
  31. Create formulas using multiple pop-up input boxes?
  32. Hyperlinks and Cell references
  33. VBA Prevent Duplicate Entry via Input Box Help
  34. Solved: Prep many tabs for new year of data
  35. Custom filters
  36. Solved: code to insert data to cell
  37. Special characters on macros
  38. VBA Error when inserting file into Word
  39. Create Outlook email to send out
  40. Subscript out of range (Error 9)
  41. why cant i see the message box on screen?
  42. Copy 2 sheet from 1 workbook to another workbook
  43. Create macro that inserts variable number of rows into tables
  44. Solved: Explicit Range References Keep Changing
  45. Insert colums and fill down - Variables
  46. VBA Internet Explorer Radio Button Help Needed
  47. Programme in VBA, help
  48. Macro value "Text" linking to input cell value of another sheet
  49. Pass Range param from custom function
  50. Getting Password Prompt while exiting vba project..
  51. Update Master File from other workbook
  52. Solved: producing multiple records from a list
  53. vlookup, find and relace the column headers
  54. Inserting Row above filtered data
  55. [SOLVED] Linear Interpolation
  56. Concatenate two columns in a sheet
  57. problem with date formula
  58. Colour cells using VBA
  59. Use logical OR in ADO parameters
  60. Split the Files based on a Cell Ref - Problem
  61. Automation of outlook mails based on the excel list
  62. Combine data from several worksheets into one with conditions
  63. Solved: VBA to Zip a file
  64. Solved: running dynamic data range from xml workbook into specific worksheet
  65. Solved: 6 month moving tracker
  66. Need formula to arrange column data into different rows
  67. control wordpad from Excel using VBA
  68. Reduce the size of macro enable file
  69. Excel not picking libraries from where it is instructed to pick from
  70. Macro to copy and paste in another Worksheet
  71. Solved: Combine Formula
  72. VBA Web Query
  73. Date validation in VBA
  74. userform search
  75. Loop not working
  76. Microsoft Office Excel has encountered a problem and needs to close...
  77. Solved: Loop just in activesheet rather than all worksheets
  78. newline data entry
  79. Solved: Invalid cell references generated from macro
  80. Solved: Color on userform
  81. Solved: Filter using dates
  82. Open external file as administrator
  83. Need VBA Code rectification
  84. Solved: not finding workbook
  85. Calculate a week later and then to fall always on Monday.
  86. ms progress bar 6.0
  87. open cash drawer using USB printer
  88. Solved: Set a permanent reference to powerpoint
  89. Help , copy cells with condition
  90. Track changes insert column/row
  91. Solved: Change text string
  92. Solved: VBA and Email
  93. Question about Sort Events
  94. Vba send outlook email
  95. Autofiltered values to a new sheet
  96. prevent your from changing filter
  97. vba to find data in excel
  98. Excel 2007 - export data from Excel to Word 2007
  99. Solved: Why am I getting an error?
  100. VBA Form Opt. buttons scoring
  101. For/Next and custom formatting
  102. Macro to Paste Cells when Column A=0
  103. Bi-Monthly date calculation and results as the column header
  104. Solved: sumif/countif for 'older'
  105. Solved: Inserting new rows
  106. Excel add-in problem, workbook.
  107. Split a cell into multiple cells
  108. PDF into Exce. KB doc
  109. Solved: nasted if/sumproduct help
  110. move rows to another worksheet
  111. Solved: Counter in Range
  112. Solved: Calculate the cell type that value to calculate
  113. How to automatically create excel templates and send via email
  114. Solved: macro doesn't work anymore
  115. 255 Character Limit when copying worksheet
  116. Solved: Emailing by broker
  117. Solved: Error on VBA Code in 600000 Row
  118. txt to xls excel macro help
  119. Solved: Export a column to text file of certain name
  120. TAB Order Workbook on KB
  121. Solved: only partly activity in Evene_Change
  122. matching with a particular error
  123. link two workbooks
  124. Create multiple workbooks
  125. request formula
  126. Solved: For Loop help
  127. Solved: Modifying code to select specific data
  128. External Links issue
  129. Updating my CSV File
  130. highlight Cell
  131. Solved: what are these filter things called and how do you add them
  132. How can I formate the date in a text box on a user form.
  133. Solved: VBA Coding Question
  134. Conditional Formatting in VBA
  135. Excel Wont Open Full Screen
  136. compare few columns of data
  137. Solved: How to comparing two columns
  138. Solved: if its not broke... recreate it, using userforms
  139. VBA Basics - automating the process of running commands down thousands of rows
  140. is there an opposite of 'selectedsheets'
  141. Search another spreadsheet to populate userform
  142. Anyone see the compile error?
  143. Error 642 in Word Automation and Style that is not applied
  144. Code Optimisation: Name new sheets from a merge after the filename?
  145. Problem with UDF
  146. Solved: 65536 Row Problem
  147. Solved: Merging Duplicate
  148. Gathering data from one book for summary in another
  149. Import Active X fields in word doc to Excel
  150. Solved: Error Message when trying to highlight specific cell
  151. Problem on Merging
  152. Solved: Insert Delete Rows Help.
  153. delete rows that do not contain a defined set
  154. Solved: Vlookup in other workbooks fail
  155. Solved: Delete Dash on each cell
  156. Solved: Spreadsheet not updating when I open it daily?
  157. save combobox list to array
  158. Solved: Set Font Color of Cell(s)
  159. Solved: problem with array loop
  160. Solved: Text in a Triangle Drawing Object
  161. Delete rows based on dynamic data range
  162. Macro to search for string in multiple worksheets and display results
  163. Append rows to existing workbook in different folder and save in different location
  164. Multiply
  165. Solved: copy the first row on sheet to lastest blank row of another Sheet .
  166. VBA Project - Registration process
  167. Importing data from XL file has two sheets
  168. total value of a column in all the sheets to be consolidated in another worksheet
  169. Quick Find of most recent date/time without having to sort.
  170. Solved: Need Help Hiding Columns
  171. Solved: Criteria based counting
  172. Need Help using array(i) with user form label
  173. Returning Maximized WindowState with QueryClose_
  174. Solved: Clear Content of a4:q900 if=0
  175. Solved: Copy Some cells from row 10 depending on which cells are selected in the active row.
  176. Compare Column Value copy cell
  177. Solved: Compare the active row, to row 10
  178. UK Date Format not US
  179. updata e graph in ppt with excel data using vba in ppt
  180. Checking URL's
  181. Custom Get Open File Dialog
  182. Need help to create a series of covariance matrices in my worksheet
  183. File Browse InitialFileName not working on one Excel 2007 machine only
  184. Solved: Copy Xrows from WrkBk to New WrkBk
  185. Solved: Label and textbox on microsoft Forms 2.0 Frame
  186. Solved: Befuddled
  187. Protect created or saved file as encrypt documents with my user name only
  188. Needed help on copying the data from .csv file to another excel sheet
  189. Delete Rows In A Sheet
  190. Reply to Closed Thread!
  191. Creating a detailed pivot from an existing master pivot
  192. Parse data from Excel to IE using VBA
  193. Solved: Re-arranging Data
  194. PDF Tracker Help!
  195. Solved: Find cells that contain a string, extract it, then cocatenate to value in Col 15
  196. Macro for CheckBox
  197. Collation of error.
  198. Row index and first three characters in VBA
  199. Trigger macro when user opening any excel file
  200. text format cells be treated as text
  201. Need Help Searching Folder/SubFolder, then Copying to different Folder
  202. Trouble creating a macro for multiplying matrices
  203. Solved: Button movement
  204. Determining if 'End Mode' is on
  205. Solved: Todays Date and Time
  206. Excel 2003 - Prevent Comments in protected locked cells
  207. List all function, properties and classes
  208. Macro to compare excel sheets and add missing data
  209. Solved: find number then +1
  210. Solved: Autofilling select sells
  211. Skipping part of a code
  212. Solved: Autofilter: using * in criteria for zip codes
  213. VBA test
  214. Compare two workbook and copy column content if match.
  215. Outlokk MAcro to Maintain the text formating
  216. Delete Specific Lines from Text File
  217. VBA Excel .OCX Control
  218. Error 0: subscript out of order when populating an array
  219. Invalid or Unqualified Reference
  220. Solved: linking userforms
  221. Force users to classify documents before close
  222. Solved: VBA Shortcut - Paste Values, Formats, Both
  223. Column Autochange?
  224. Solved: Running a sub based on the value in a cell
  225. Excel 2010 and HPC Compute Cluster
  226. userform combox based on previous selection
  227. Seeking assistance on automating some functions in Excel
  228. Rewriting/Improving Formula
  229. KeyPres, KeyUp, KeyDown - Debug.Print KeyCode
  230. Pivot Table Filter works in 2007, it doesn't in 2003
  231. Excel VBA Error Report
  232. Criteria based macro
  233. Solved: help
  234. Solved: Copying Filtered Data
  235. compare mulitple columns and the status in another column based on the the criteria
  236. Solved: Speed up excel code
  237. A final push
  238. Refresh button to update value of cell?
  239. Solved: Help to copy the formula
  240. Solved: advisor name entered in one cell to auto populate their managers name in other cell
  241. Inserting columns using VBA
  242. Selecting: Just part of a string in a cell
  243. staff / alternative
  244. Please help in auto data classification based on mapping
  245. Solved: Advanced filter - vba method 'range' of object '_worksheet' failed
  246. Calculate only the given range.
  247. Urgent :How to FAST write large recordset in to a text file?
  248. How to add a Custom menu TAB for Seperate work book
  249. How to combine the text into one cell?
  250. Solved: VBA to assign positions for outputs