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