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