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

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