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 168 169 170 171 172 173

  1. Dynamic Range Help
  2. Solved: Cut and Paste Value to matching Column
  3. Run VBA Code of diffrent sheet Automaticly
  4. Webquery
  5. Solved: Transfer Results of Conditional Formatting in one cell to another
  6. Help to Minimize VBA to be based in list range
  7. Solved: Find Position and Count instances of a character in a string
  8. Replace a sheet in all the files in a folder
  9. or formula
  10. Copy pivot data in every sheets and save as to a new file
  11. ADODB update stops working with a tired database
  12. Solved: Update multiple sheet
  13. How to read own filename
  14. Solved: Best method for passing a variable from one code to another code
  15. Solved: COPY CHARACTER FROM A CELL
  16. Solved: Automated pivot table will not handle large data.
  17. Solved: Mail problem
  18. Weekday function error
  19. Excel to search outlook global address list.
  20. how to search,compare and copy between sheets?
  21. How to move from one sheet to otherby condition?
  22. Solved: VBA help required
  23. Solved: Help with Array
  24. Solved: Change file path name
  25. VBA Code Help
  26. Any 'gotchas' here?
  27. Hyperlinking multiple cells based on another cell's contents
  28. Solved: Commandbutton.onAction
  29. EXCEL VBA code for assigning auto id
  30. Rounding off numbers.
  31. Solved: Finding the file name
  32. Excel VBA Form Help
  33. Solved: Protect cells on sheet to last row without protecting sheet
  34. how to find the last specified cell row in VBA
  35. [SLEEPER:] Delete all macros/all VBA and save as xls/xlsx
  36. Solved: Deleting "0%" from Pie Charts
  37. how to loop between two dates which moves every hour.
  38. Copy master sheet into multiple workworks from remote location
  39. Print text problems and other: please help!
  40. Copy multiple Sheets Ranges to New Book
  41. [SOLVED:] Using VBA how to Merge one excel file worksheet data to another file worksheet?
  42. Help Defining variables
  43. [SOLVED:] VBA code for Text to Columns
  44. Create a single cell from a column of number
  45. Solved: Open a Excel File from Specific Path and with a Specific Name and Date
  46. Solved: Prompt User if user enters a character
  47. Overwriting values in excel
  48. Solved: Multiple Selection for Dropdown
  49. VBA: issue fitting picture to cell range
  50. Solved: Posting rows to another sheet some copy, other move
  51. Textbox loses focus?
  52. Automatic modification
  53. Loop excel Macro to repeat as long as there is data in the colum
  54. Compare two tabs using vlookup
  55. Format gets lost
  56. Calculate Age of Project
  57. Solved: VBA To Run Macro From Menu Button
  58. Is it possible to automate vlookups functions? If so, how can it be done?
  59. Tab Order
  60. Just a small (huge) Thank You :)
  61. Macro help needed! excel->ppt
  62. ByVal and ByRef
  63. Solved: pulling data from multiple columns in one worksheet to others
  64. Solved: Sum individual cell values in two Ranges
  65. Generating calculations based on certain cells
  66. Solved: date type mismatch
  67. Loop as long as row above has data
  68. Solved: Enable Button Criteria
  69. VBA: textbox to equal cell value
  70. Solved: Locked Out of Workbook... Aaaargh...
  71. remove word
  72. How to zoom to specific area in excel graph
  73. [SOLVED:] Add values to a ComboBox in a dynamically created UserForm
  74. Add a picture from a folder with name specified in a cell
  75. Log Off or Lock Computer = Save/Exit Workbook
  76. formula errors
  77. Is it possible to get excel to pull data from websites?
  78. Hide Columns based on a value in a range
  79. Getting an Error when data entered is 4 letters but three or less works perfectly.
  80. userform_activate with textbox colour change not working
  81. Solved: Create a web service call from Excel 2007
  82. Solved: How to save the email attachment using vba
  83. What am i missing?
  84. Solved: Just How?
  85. Solved: Function needs to hide some Rows that have been filtered and sum remaining visible
  86. Progress Bar
  87. How to search a text and get the third row of from it.
  88. Worksheet_Selection not working
  89. Solved: Play 2 Wav in VBA
  90. Enabling Spellcheck in Locked Textbox
  91. Solved: Find then Hide rows where Col 1 cell is colored & empty or Col 3 cell matches a value
  92. Solved: Auto Email Information?
  93. Paste Special at Selected Cell: VBA
  94. Long Running Vb/a code Causing Screen issues
  95. Count matches between two columns based on complex criteria
  96. Cell Values in Header
  97. Solved: Is there a way to put a formula in a comment box????
  98. Search any first and last name using Excel VBA into outlook
  99. Opening 2010 .xlsm file in 2007 version of Excel
  100. Finding Duplicates in a Column
  101. listbox display more font type
  102. formula correction
  103. how to use class interface&objects
  104. Solved: Hidden sheets
  105. Menu issues
  106. COUNT
  107. Block typing in column 15
  108. Help with coding
  109. Solved: Search Text and loop the same thing for same text
  110. Combobox selection
  111. Registration of two parts
  112. Solved: Need VBS quick help with If loop :(
  113. Solved: Need Excel VBA help :(
  114. VBA Project? Guidance Needed!!
  115. close a userform after a timed period
  116. CopyfromRecordset: copy text only ?
  117. Adapting page break
  118. Find active IE tab
  119. My first request! VBA help
  120. URLDownloadToFile
  121. VBA code to count record
  122. 3 Inputs, 3 different Sounds
  123. F8 keeps running my whole code instead of stepping through it
  124. Filter Data in Sheet to ListView
  125. Reformatting Data Error
  126. Unzip the zip folders and rename the .gif files
  127. formula
  128. VB Script to display cell dependent references
  129. VB Code to Sort by Last Column With Date Not Including Headers
  130. Solved: Delete plus Trim word
  131. Solved: Hyperlinking problem
  132. Automate Filter
  133. Close multiple workbooks
  134. Naming and Deleting Shape
  135. Name and Delete Shape
  136. paste from clipboard into active window
  137. prevent shape flickering
  138. Solved: Retirement Spreadsheet Help
  139. I need Help
  140. Run-time error '1004' in protected sheet
  141. VBA XML/XSD DOM Method to Retrieve Attribute Restrictions
  142. Macro assigned keys
  143. VBA code for saving csv file to certain path
  144. Solved: Return result up to a maximum
  145. Solved: vba - detect "+" and "-" keys
  146. Problem
  147. Solved: Method 'Range' of object '_Global' failed
  148. Solved: 64 Bit Excel
  149. hiding data using other cells as reference
  150. plz Help: allow certen sheet to be printed with condition
  151. If Sat or Sun, then Monday
  152. [SLEEPER:] Search for text in every sheet]
  153. How to pass the active workbook to a function, getting subscript out of range error
  154. Trial period for spreadsheet
  155. VBA Importing all sheet data from a closed excel workbook
  156. Retrieve Selected Items from Multiselection List as String
  157. Show calculation progress of a data table
  158. Solved: VBA Conditional Formatting Range
  159. Bloomberg BDH Formula and VBA
  160. Solved: Identify which Excel version via Code
  161. Data extraction Automation via VBA
  162. How to stop following start-up message?
  163. Get Max Value - Compare cloumn with condition
  164. Solved: check the A Cloumn and copy to aother sheet
  165. Solved: if match column A and B move the row to another sheet
  166. Loop routine only finds first instance
  167. donít want the message box when delete a sheet
  168. Macro to merge data from 100 worbooks in a folder
  169. VBA MAcros for Calculation of multi columns
  170. Solved: Context Menu Control ID's
  171. Solved: Problem with compare and deleting in 3 column
  172. VBA code to check if file exixt and if yes than overwrite and no than exit
  173. VB Code To Normalize Big Dataset with One Value
  174. Help with vba macro
  175. insert the worksheet if the sheet is missing
  176. Autofill to the last Row
  177. Solved: Merge and Delete duplicate in 2 column
  178. Accessing X-Axis in a line graph
  179. Excel to find value and return multi values based on that
  180. Make VBA Cell a Formula
  181. Solved: Can the Text in a Form Control Button Be Read into VBA?
  182. 4 conditional formats based on dates
  183. Format line based on condition
  184. Arrange data sheet wise
  185. Grid of Buttons - Sizing and Positioning
  186. Solved: Worksheet Change?
  187. Match "2" values before marked as Duplicate
  188. Stuck with macros
  189. create new sheet based on another sheet filter
  190. sumif vba
  191. Sum Up Multiple Workbook
  192. Background
  193. Setting Print area
  194. Solved: Array Problem
  195. Time card workbook - need advice/help please
  196. Retrieve the file name if I specify the extension.
  197. Solved: Bulk assignment to VBA arrays
  198. Changing Sort Options
  199. create a new workbook and then move a sheet to there
  200. Date Population
  201. Solved: Code to lookup values from sheet and automatically enter in another
  202. Internet explorer automation/vba
  203. Handling large amount of data in one excel sheet
  204. Solved: CONDITIONNAL FORMAT OR MACRO
  205. Multiply selection by a variable
  206. Copy and Paste Code
  207. VBA Message box help
  208. Trouble with 64-bit VBA?
  209. Solved: Problem with Formula
  210. Lock Row on Cell input.
  211. sorting into different worksheets
  212. Pivot Table code that worked in 2003 not working with 2010
  213. How to paste from module to worksheet
  214. Solved: Click a command button to get the name of the previous button clicked
  215. What can be done to "clean" the palette (such as remove cell headers)
  216. Need color of source text in concatenated cell
  217. [SOLVED:] Identify String or Numeric Value in a Textbox
  218. Taking input from another worksheet cell in excel 2007
  219. Delete rows
  220. Re-arranging the columns as per columns given in another worsheet
  221. Solved: Loop is not going through all worksheets
  222. Change in a cell text, inserts an X in another cell
  223. Change image when different cell is selected
  224. How can sort Ascending for data in a Cell
  225. Solved: Amend and Move
  226. Solved: Sort will NOT Sort
  227. Allow cell entry only by shortcut key
  228. Dynamic VBA Generation
  229. Solved: Sort,format to report sheet
  230. Solved: Paste Special problem in found solution
  231. Emulation question
  232. MSQuery Pass Variable
  233. VBA Concatenate based on another cell value
  234. Solved: Row Count / Loop
  235. Solved: Adding Values in VBA but from a dynamic data query
  236. use excel vba to input data into MYOB
  237. Solved: macro to call "paste special"
  238. Java Code to VBA
  239. values based on the datetime stamp given by the user
  240. Append the values to the master sheet from pivot results
  241. Letter Template database in Excel Forms.
  242. Solved: Filtering with DTpicker
  243. Hide popup when saving as PDF
  244. Hi guys can you correct my code here?
  245. macro not working in 2007 (working in 2010)
  246. Solved: Problem in using Custom Format through VBA
  247. Solved: Detect when VBA code has finished
  248. Sorting multiple rows in descending order with their respective columns
  249. Solved: VBA EXCEL - Best way to add, divide, subtract and multiply.
  250. [SOLVED:] Formulas and Conditional Formatting