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

  1. Alter code to paste into separate sheet
  2. Highlight Cell According to List and Criteria
  3. Copying macro and associated button to new file/sheet "in flight"
  4. ListBox not displaying Horizontal Scroll bar
  5. vb if help
  6. Solved: Select a column with merged cells
  7. attach a macro
  8. New to Excel, Can this even be done?
  9. Auto run macro on file opening
  10. Use worksheet as user interface for database
  11. Catering for columns that will move
  12. VBA Training Levels 2 and 3
  13. Trying to display result of function as a userform label control
  14. Compare not-exact cells
  15. Pasting Functions by 5's
  16. Exporting defined ranges into word
  17. ESC key to unload a form
  18. Pasting CSV File
  19. How to interpolate values between the Troughs/valleys in series
  20. How to min/max user form
  21. fill some values in another workbook without opening it??
  22. in sheet if in the userform button ok was clicked perofm action if not then no...
  23. Automatically remove unwanted rows based on a known value
  24. Mobile Tariff Plan Monthly Spend Comparison Tool
  25. Partial cell contents matching
  26. Use same UserForm
  27. Solved: Text file data import issue
  28. Solved: Max sheet tab name length
  29. Solved: ComboBox and Named Range
  30. Removing First few characters of a String
  31. Need Help 2 Find First Few Letters and Move 'em!
  32. Solved: Enter to days date on opening correct sheet
  33. Solved: Cleaning Cells with inverted Name and Surname
  34. Solved: Force user to enter data be for close
  35. Solved: how to know from which sheet a button was clicked??
  36. Email Help
  37. Emailing Unsaved Spreadsheet
  38. Solved: Delete everything but...
  39. Solved: Fill combox from given column
  40. Pull in column Data, perform calculation, Copy Results, and repeating
  41. call code in a different workbook
  42. How to copy data from one Excel file to another very fast?
  43. Solved: How Can I Move Data w/out Overwriting Existing Data?
  44. Solved: Display results from a formula into a form
  45. Accessing a PivotTable Data via VBAX
  46. Copy File
  47. Solved: Sort data in a listbox
  48. Date -Format problems
  49. multiple string search at sametime
  50. restrict search to column A
  51. Solved: Can U Move Whole Rows or Just Cells?
  52. Solved: update linked values without opening
  53. Numbers into lines
  54. Update pivot tables with task scheduler
  55. Repeating hlookup addition within a cell
  56. Solved: Delete Command Button
  57. VLOOKUP not updating on copied sheets
  58. VBA to search google maps in excel
  59. Solved: return formatted number from function?
  60. Image Slide Show
  61. Image Control Help
  62. Solved: newbie problem
  63. Solved: userform...when click OK button ask if the input values are true if not put them agai
  64. Password in Workbook open VBA code?
  65. Solved: every month copy whole workbook into new made folder ?? is this posible??
  66. Combining two sheets
  67. Open a PPS file VBA
  68. Force excel download on webpage
  69. Solved: can i use cell ref from a input box in this way?
  70. Tile pictures on a worksheet & "Save As" option
  71. Pull data from multiple spreadsheets
  72. The object invoked has disconnected from it's clients modify protected sht validation
  73. Solved: Divide and Conquer
  74. Populate Listbox with autofiltered sheet
  75. Solved: make ALL labels invisible (visible=false)
  76. Solved: countif contains multiple text values
  77. Solved: Getting the handle of A Web Page
  78. ActiveSheet.DrawingObjects.delete except...
  79. Solved: refer to a named range in input box?
  80. SearchWord
  81. Solved: Display all visible columns in multi-column drop box selection?
  82. Solved: show visible if true
  83. Delete duplicate rows
  84. Highlight duplicate values of certain columns only
  85. Solved: No More New Fonts????
  86. Open up csv files and save as excel files macro
  87. protected sheet...two password posible?one has ability to change only specific range?
  88. wData worksheet
  89. Solved: Sumif using named ranges
  90. Solved: What stops this code from working?
  91. Any way to apply changes to one excel document to hundreds of excel documents?
  92. Multiple WorkBooks Question
  93. UserForm save spreadsheet on change
  94. Solved: Please check one line of my code
  95. Need help on Matrix multiplication
  96. Solved: Populate empty cells
  97. Solved: Displaying total runtime of Macro
  98. Copy and Paste Values To Another Sheet Without Showing The Switch When Run
  99. rmdir driving me nuts...pleeeeease help
  100. EXPERT CHALLENGE: HYPERLINK NOT WORKING?
  101. Advanced find
  102. Copy columns
  103. autofilter dates
  104. Solved: Account Receivable Templates
  105. Update linked cells
  106. Create Multiple Charts from a Pivot Table
  107. Fill combobox from column and with n rows
  108. using vlookup with user form
  109. Recall Data to Userform
  110. By Ref & By Val
  111. Advanced filter running *really* slow
  112. background noise
  113. Solved: manipulating other applications
  114. Solved: Wildcards
  115. hide and seek
  116. cell cursor
  117. Solved: Call for Data from folder
  118. Update time for the userform.caption
  119. Solved: excel and access
  120. macro assistance needed...temp convert
  121. Solved: macro to fill empty cells (by copy/paste)
  122. It's The Time Of The Seasons, AGAIN...
  123. Solved: Download a file viw FTP using VBA code?
  124. Solved: Formula to return totals of printed pages
  125. Preventing duplicates rows
  126. Solved: name of file to launch
  127. Copy selected value from listbox into a cell
  128. Making Formulas into Words
  129. Solved: Cycling through Pivot Table Items
  130. Solved: Excel - MS Project "The remote server machine does not exist or is unavailable"
  131. the column Next to
  132. Solved: comparing two workbooks
  133. Display cell value into a textbox
  134. Solved: How to get the word "Solved" in the title once problem is solved?
  135. five second interval
  136. Solved: Problem with VB CASE statement
  137. Dismiss variables problem ?
  138. How to prevent Entry more than specified value.
  139. Print detail and summary report
  140. Seek help to exceed limit excel 65536
  141. Update Link
  142. problem working with psDivide and psMultiply
  143. How to open an Outlook .msg file in Excel VBA?
  144. Solved: To few digits
  145. Fill a combo Box from a range
  146. Save Question
  147. Keep cell font bold off
  148. all comments in activesheet
  149. Truncate and Rounding
  150. transfer 2 forms to spreadhsheet
  151. Empty Cells in Pivot Table
  152. Checking for file presence
  153. hiding workbooks
  154. VBA help
  155. Solved: User Help Files for Function Arguments
  156. Creating pivot table & adding formulas in VB
  157. RE: Complex Lookup Help
  158. Solved: Pivot Table:Percentage of sub-totals?
  159. Solved: Alter exsisting code to find duplicate entries
  160. Solved: Creating Formulas for Dynamic Ranges using VBA
  161. Embedding chart into userform
  162. Combo Box/List Box Problem
  163. Solved: Print Preview and forms
  164. Solved: month and year
  165. Duplicate Control Names = Disaster
  166. New Sheets Based on Cell Info
  167. "Insert Function" Dialog Box Control
  168. Solved: Clear Textboxes
  169. Refresh Stock Quotes
  170. Solved: Do Events
  171. Solved: ctrl+shift+home
  172. Solved: bypassing clipboard
  173. Solved: MatchSumOffset
  174. Insert Scatter Plot with Variable Range Data?
  175. Solved: Customviews Name
  176. import data
  177. Print data from sheet to another one after one
  178. Vlookup Or Find With Textbox On Another Workbook
  179. Solved: filedialog
  180. Solved: Progress Indicator Form
  181. Solved: Loops sending me loopy
  182. Solved: text to columns
  183. Solved: transferspreadsheet method
  184. Assigning recordset to array errors when zero records returned
  185. Problems with macro based on "Simple Floating Toolbar" (lucas)
  186. Solved: putting code on a sheet or module
  187. Solved: Different versions of References
  188. Sorting over multiple sheets
  189. Filtering macros with a date and a number of days
  190. Userform.printform problem
  191. Programmatically Open Locked VBAProject
  192. Open different files in a folder
  193. How to match the value of active cell with other value cell
  194. Autofilter custom shortcut
  195. VBA date macro
  196. Office 2003 Service Pack Disables Older File Formats
  197. Solved: Copy Worksheets from Source Workbook to another Workbook
  198. Solved: Dynamic Ranges
  199. Matching values in a range
  200. Get the content from the fixed cell & variable cell and combine it
  201. Solved: Auto capitalize a column
  202. Solved: worksheets functions
  203. Solved: Help - Ranking Cells in non-continuous range
  204. Solved: Lost changes to Workbook/Worksheets
  205. Need help creating Search box assign macro to search from various worksheet!
  206. Solved: Calling subs in modules/sheet modules
  207. Code change question
  208. Solved: Transfer data from Array declared with Userdefined Type variable to Excel
  209. Help me to complete this code
  210. Solved: Sheet Tab naming on opening
  211. Solved: Linking the elements of a Select Case scenario
  212. Embedded word document into a form
  213. Validation on a Textbox entry
  214. Disable "This workbook contains links to other data sources" window
  215. Data Transfer from User Forms
  216. Solved: Another userform query
  217. Adding a Zero
  218. Named ranges - cross polination
  219. script help
  220. Regular Expression syntax
  221. Module not seeing functions in ThisWorkbook
  222. Runs OK on my PC but not on another
  223. summing range of row
  224. Button to copy buttons
  225. Insert Rows and add Title
  226. Solved: generate random sample without replacement and with second criteria
  227. Solved: Message box alert if cells not filled in on time
  228. Solved: remove letter from TxtBox
  229. What is the difference betweem Range and Usedrange ?
  230. Extract the data from source workbooks into the active sheet
  231. Filepath Variable
  232. Error when using vlookup in VBA
  233. Looking to learn how to parse XML files into Excel with VBA
  234. Looping through a flat tabled spreadsheet
  235. Auto Corrupt/Delete an Excel File
  236. How to change mouse Icon when move above one of cell?
  237. Solved: checking if a database is open
  238. Solved: create a copy
  239. Solved: interacting with non-MS apps
  240. Solved: types of programming
  241. searching for and subtracting values
  242. Adding comments to a worksheet
  243. Active Tab change Backcolor
  244. What does mean this property ScreenUpdating
  245. Solved: AND not working in loop
  246. Blinking Text in Formula
  247. check for errors
  248. Switch from Excel to Access
  249. Solved: sorting a single column
  250. Solved: sum total based on month