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