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

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