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

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