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