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

  1. Solved: Binding Macros to Buttons
  2. Trial Code Error
  3. can't get caluclate event to fire vba
  4. Search and Replace Macro
  5. User form OHR and Password break.
  6. macro search
  7. Lookup value in Table
  8. Extract data from MS Access table using excel macro.
  9. Rand() in excel 2000
  10. How can I put multiple codes in 1 sheet?
  11. Picking only records based on po #.
  12. Time capture activity require.
  13. Solved: How to Delete Data on the other sheet using VBA?
  14. OLE created workbook vs User Created
  15. Solved: stops all other macros except this one
  16. Solved: Test if Folder Exists
  17. Check box question
  18. Solved: Selecting Row with variable
  19. 'merge' sheet and adding new sheets; shname()
  20. how to Delete Data Row with use of VBA code
  21. Solved: Protect and unprotect worksheet change
  22. initial value for listview from excel
  23. Automatically Update/Populate Listbox based on selections of other listbox
  24. Solved: Enter a cummulative value into a cell
  25. Copy and Paste in Filter
  26. Copying rows in range based on criteria
  27. emailing cell range
  28. How to only keep duplicate values
  29. Save to new workbook and delete a specific sheet
  30. Solved: find the letter for the last colomn
  31. Solved: VLookup in VBA
  32. Solved: ISERROR VBA CODE
  33. Solved: Formulas are not being copied correctly
  34. Solved: How to delete columns that go through an area with merged cells
  35. Solved: Multipage/Treeview Expansion problem
  36. Solved: Working with a Filtered Dataset
  37. External Formula
  38. Solved: put a range into a variable
  39. Min,Max,First and Last Values within Time window
  40. hiding formulae in excel 2007
  41. Solved: Changing Arrays
  42. Solved: populate multicolumns of listview
  43. VBA - Dodgy IF statement results from certain numbers
  44. How To Write Find Function Using Macro
  45. Solved: Insert Rows, AutoFilter, xlCellTypeVisible
  46. working with ranges of merged cells
  47. Copy/Paste if cell contains "123" characters
  48. SaveAs and Fileformat
  49. A faster/more efficient way?
  50. Solved: Run Macro on Cell Change
  51. Scanning data series and plotting based on data
  52. Solved: Combining 1 Cell from sheets into List
  53. Delete Rows when Condition is met
  54. remote update of code
  55. Solved: Clear Contents on Workbook Close
  56. Solved: Does VBA need a pause inserted
  57. Adjusting macro to loop through criteria
  58. What are CUBES when used in Excel
  59. Solved: How to show a Calendar in Combo cube dropdown on a excel Userform.
  60. highlight specific cells in active row/column
  61. Using a case statement
  62. public object module error
  63. Solved: Questions regarding Excel vs VBA
  64. How to define workbook is open in which process
  65. How can i plot a Graph on Microsoft Excel?
  66. Solved: Need help exporting data based on listbox selection
  67. Save Excel using VBA
  68. Solved: Auto open macro help
  69. Solved: Add negatives?
  70. Solved: Similar case
  71. Solved: Listbox Related Question
  72. Solved: Combobox data to listbox or textbox?
  73. Data mapping from one excel workbook to another excel workbook
  74. Solved: Create backup to another location
  75. How to filter data with a multi-selection listbox
  76. Solved: IF Statement Limit Reached
  77. Solved: Delete zeros
  78. Filter not work with xl2007?
  79. How to colour an entire row, on row number click
  80. Solved: referencing specific worksheets in vba
  81. Number format of cell which contains formula
  82. Solved: macro to Delete entire row based on a criteria.
  83. Solved: macro to replace error formula cells in a column with some other text or number.
  84. Solved: A macro to saveas a worksheet as a new workbook
  85. Solved: Accessing specific sheet by password box
  86. cells contain hidden values
  87. Excel Status bar will not update
  88. how to open a existing worksheet from certain folder and creating new workbook
  89. sort columns via listview
  90. Solved: lookup function in VBA
  91. VBA script in excel! help
  92. Solved: If Esle..If VBA
  93. Solved: Unexpected error.
  94. Costing schedules
  95. Solved: Finding Last Visible Row
  96. New worksheet using template based on cell values
  97. At a loss for direction..
  98. Poll of numbers HELP!
  99. Computing 99% of COl M while cell is in filtered mode.
  100. Analysis of Amount based on following criterion.
  101. Solved: Changing Text in Buttons
  102. Copy Cell From Workbook and Paste to Another Workbook's Cell
  103. Solved: Referencing Another Sheet in Workbook
  104. Inserting a row or a column
  105. Next row down
  106. =OFFSET(EntrySht!$B$9,1,0,COUNTA(EntrySht!$B:$B)-1,1) working functionality require.
  107. Deleting the row that contain the text " Dismantle"
  108. line breaks & spaces
  109. Solved: Finding the Correct Value
  110. accessing gmail attachments
  111. Checking ref # status based on sheet2 ref #.
  112. Excel 2003 question ( using If )
  113. Solved: Where can I find a VBA guide?
  114. Excel 2003 VBA help
  115. How to copy different excel worksheets in one workbook?
  116. Solved: IF/ ELSEIF Help
  117. Solved: list data from 53 sheets
  118. Solved: 2 sheet search
  119. Solved: Sort Question
  120. Run Time Error 1004
  121. Solved: reference to a sheet
  122. Filter date from multiple Pivot tables
  123. Function or UDF
  124. Formula Help
  125. Best Place for Subs
  126. Solved: Excel AutoSum
  127. Solved: Auto Protection
  128. If filename is in sheet, return true/false?
  129. Finding the difference of two dates based on criterion.
  130. Automatically saved into the drop-down list and show edit comments
  131. Hiding column need to be unhide.
  132. Solved: Help on alpha numeric subraction...
  133. Speeding up a loop, that does an action when encounters a value
  134. Solved: Call Sub Help
  135. Groupwise attachment loop
  136. Problem with coding Sub
  137. Solved: Excel Formulas based on Lowest cost
  138. Solved: Update records without looping?
  139. Arrange columns of names & addresses into rows
  140. Need to test if Worksheet Name Exists
  141. Formula VBA Help
  142. Solved: Play .wav sound file when userform opened
  143. Solved: Error: 1004 - Application-defined...
  144. Solved: How will I modify a VBA code that will only calculate the last populated row?
  145. How to get currently logged on user's account name?
  146. Solved: .Copy Destination (Error)
  147. Problem with Date Filter between two dates
  148. Solved: How to troubleshoot error on my macro?
  149. data fram pdf
  150. Trim bug?
  151. Email macro stops after sending first email
  152. Solved: Extract data from text file
  153. Solved: How to open sheets as hidden
  154. Sorting and removing duplets
  155. executing T-sql stmts in Excel VBA
  156. Copy Records to Worksheets based on value
  157. display records by office
  158. Activate Excel Window
  159. Solved: Hiding Cells
  160. A rather nasty COUNTIFS statement issue
  161. Dynamically change size of Array
  162. Solved: Do a .Replace on an inactive sheet
  163. Need help with events in HTML Table - Excel 2007
  164. Solved: Write number as string
  165. display records by office
  166. Solved: combobox on the fly
  167. download file
  168. Help needed on variable workbook name.
  169. Solved: How to protect your VBA codes?
  170. Solved: How to change color of Form Control Button?
  171. Refining ListBoxes
  172. How do I do a best fitting line on Microsoft excel?
  173. Need help with MkDir form Cell
  174. Printing all worksheets in a workbook as a single file..
  175. Solved: Help needed with VBA for Alt+F11
  176. Solved: Drop Down Box -
  177. Solved: I want to add a textbox on the chart
  178. Excel Look up data in a access database
  179. VBA and cell references
  180. How to parse HTML file from VBA code into Excel ?
  181. Solved: Cell Reference
  182. Solved: Use of AddShape to add circle
  183. Object visibility?
  184. Resize Pictures
  185. Solved: Looping Goal Seek Function
  186. UserFrom ListBox FilterInPlace on inactive sheet
  187. Solved: Import External data into Excel
  188. Delete a worksheet without losing Formula reference
  189. Solved: looking for the correct sheet and fill in the value refer to date
  190. Problem saving as macro-enabled workbook
  191. Excel to open and run Access Macro
  192. Solved: Pivot Refresh Problem
  193. Delete rows if cell less than 4
  194. How to remove the blank space which is present at the end of the value in a cell
  195. Solved: how to stop duplicat data entry
  196. Solved: Password entry visible
  197. ByRef ByVal
  198. Multiple If statements with multiple date range
  199. Solved: If / Statement
  200. Select multiple rows based on selected column
  201. Solved: VBAProject (PERSONAL.XLS) Stays Open Forever?
  202. Solved: Keep common inputbox in background
  203. Solved: Can This be Simplified?
  204. Solved: Worksheet ListBox Selection
  205. Populating a Userform Textbox on userform open!
  206. Macro required for ALT+TAB keys
  207. Solved: Count weekly offs based on day of week
  208. loop to delete the row and replace the value in cell having problem
  209. Listbox selection and deselection triggers in userform
  210. Multiple selection from the cell.
  211. Solved: Unlocking several VBAProjects
  212. Delete the warning message.
  213. Solved: Division with remainder
  214. Use VBA to populate a VLOOKUP formula - then move that worksheet to another workbook.
  215. manual recalculation not for all sheets in wb
  216. Solved: UserForm List Box Problem
  217. excel multiple workbooks
  218. Case Statement
  219. Combining multiple excel workbooks in to a single sheet
  220. Solved: Protection Issue?
  221. Solved: Delete Row Skipping
  222. Hide "View" menu
  223. Comparing cells within a column
  224. Process bar
  225. Solved: Populating a listbox
  226. How to open workbook in another computer
  227. Solved: Input/Output text files fill in variables
  228. fill in the value accoding the date
  229. Solved: How to formulate sumifs based on weeknum?
  230. How to attached font when save Excel 2007 into Excel 2003 format
  231. Sending email from within Excel (.From) issue
  232. Data from Excel (macros) to Word using VBA
  233. Solved: Delete row
  234. Unable to get the SaveAs property of the Workbook class
  235. expand selection starting from dynamic range
  236. Hiding rows in a function
  237. Solved: VBA Code - Adding value to Comments
  238. can i define the Public contant WB and Sheet name for use in form ,macro and sub?
  239. Solved: prevent worksheet deletion.
  240. Solved: loop through selected cell
  241. How to use AutoIt to Open Excel and Enabe Macro
  242. Solved: counting
  243. Solved: is there a paste special for this data?
  244. Solved: Changing d/m/yyyy format in workbook
  245. Solved: Word Constants
  246. Solved: auto-fill webpage search form
  247. Query regarding worksheet function (Count IF) using in Excel VBA
  248. VBA - Populating Arrays Inside of Structures
  249. Solved: Hide columns not appearing in Sheet 3
  250. VBA Project help and overflow error