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: Readonly
  2. Modify recorded macro to Worksheet Activate
  3. Copy paste all data with duplicates to new sheet
  4. Test if DocVariable exists from within Excel
  5. data representation in flowchart???
  6. Formula Editing in vba
  7. Solved: All matched values in one Row
  8. Extract Numbers and copy into new cell
  9. Solved: Create listbox via vba: populating listfillrange
  10. Solved: Prevent Users from leaving blank cells
  11. Macro into VB
  12. Textbox formatting question
  13. Textbox - cannot tab to it on user form
  14. Small problem : Filter/copy/past
  15. OPEN TO SPECIFIC SHEET
  16. Finding Max or Large in non contiguos range
  17. How to export random samples from multiple sheets to a new workbook
  18. Insert rows condition but ingore the blank cells.
  19. Combining HTML and text box entry into message body
  20. Solved: Dual Worksheet Duplicates
  21. Copy Data from table based on Criteria
  22. Solved: Application.Calculation . . . Explain Please
  23. Insert Picture into Comment
  24. Solved: Loading a listbox with sheet names
  25. Solved: Merging Data from 2 Sheets
  26. Solved: loop
  27. Solved: Choosen some checkbox
  28. Auto Filter ....
  29. Solved: Find / Replace not working - why?
  30. [SOLVED:] Customized macro button
  31. Solved: Option Buttons
  32. Solved: VBA: Left & Find function Error
  33. Code required to remove a button
  34. open charts from list
  35. Solved: Concatenate multiple un-adjacent columns
  36. Add macro button to worksheet - tricky
  37. Solved: Saving files increment of 1
  38. Using Excel with ACT
  39. Counting Multiple Cells
  40. Solved: Working with two workbooks
  41. Macro for color fill
  42. Writing a Macro for Checkbox Form
  43. Playing Midi Files in VBA
  44. Display info from Spreadsheet in listbox
  45. Solved: Define number of cells that should contain data
  46. Append data from EXCEL to SQL Server
  47. [SOLVED:] Seconds Counter
  48. Using Trendline Formulae
  49. Copy a range ?
  50. Problem with Excel...
  51. Jump to another cell on a different sheet
  52. Solved: SysTray - reduce form or workbook to...
  53. Command button to save and add data?
  54. Solved: Find String
  55. Solved: Week No Formula
  56. Solved: Advice, please - VBA vs. Visual Basic.Net
  57. Solved: How to auto count a data
  58. Solved: Listbox Format
  59. Solved: Loop in Column P to Convert value
  60. Excel bar Chart invisible
  61. [SOLVED:] Cell value unseen on first open
  62. Opening Data File automatically
  63. recurrence
  64. pivot table counting blank cells in data range
  65. Solved: Excel Recovery Tools
  66. Solved: Macro/ Cell referencing and separate sheets
  67. VBA conditional formatting for rows (more than 3)
  68. If..Then for Empty Column
  69. Solved: Storing a range as a variable?
  70. Solved: Copying Rows
  71. [SOLVED:] unselecting all PivotTable rows in a PivotField?
  72. Can't Get This Code to Run in Excel 2007
  73. Macro to Hide/Unhide 3 Sheets
  74. [SOLVED:] Start from the 2nd row
  75. invoice.txt
  76. [SOLVED:] Create checkbox
  77. Solved: Resize to last cell and select
  78. Solved: Selection Triggerred Macro
  79. Continued: pivot table counting blank cells in data table
  80. Refreshing Pivot Tables
  81. Solved: Help with IF statements in Excel
  82. import data to Excel from old accounting system
  83. Solved: Last Row, CopyPaste
  84. Custom Menus
  85. Solved: Can't suppress "Do you want to save..."
  86. search and delete
  87. Looping through a column
  88. Solved: Help with SendKeys
  89. Solved: Move and delete row
  90. Loop - usage
  91. Solved: Run code if workbook abc.xls is open
  92. [SOLVED:] Auto add code to [ThisWorkbook] while running macro from different location
  93. Array Forumla Help
  94. Solved: Adding another column to a listbox?
  95. Need help with deleting duplicates
  96. [SLEEPER:] cancel button click events
  97. Help with Embedded Add-In Links in a Spreadsheet
  98. Solved: Change the state of cell by clicking on it
  99. Solved: Display Sheet Name If Cell Criteria Is Met
  100. Color fill when >= date entered
  101. [SOLVED:] Adding Formula into Loop
  102. Solved: Find Max Value across Wkshts and display max in alert
  103. difficult macro to count values
  104. Problems with Workbook_Beforesave
  105. [SOLVED:] Range method failed
  106. Solved: Vlookup and negative numbers
  107. Select date in page field
  108. [SOLVED:] How to enter just time in a cell
  109. PrintPreview failed
  110. Solved: Get MS Word OptionButton value from Excel VBA
  111. Solved: Problem with averaging netdays with criteria
  112. Create Copies of Workbook
  113. Attached alpha numeric based on criteria
  114. Solved: Select Cases using two columns
  115. Solved: Splitting cell values into two defferent columns
  116. Solved: VBA active cell
  117. Solved: Export Shapes to PowerPoint
  118. InputBox
  119. Solved: cycle through rows
  120. excel 2007 stop pop up
  121. Auto Enable Macro in 2007
  122. Error
  123. Solved: Help Basics Input Data
  124. Regarding Application.ScreenUpdating=False
  125. [SLEEPER:] Activating Excel VBA References programatically
  126. Solved: If loops
  127. Solved: Excel accounting spreadsheet macro
  128. Solved: Newbie VBA help in Excel (Moving cells)
  129. Wildcard in SUMPRODUCT
  130. Solved: Finding avg of ranges
  131. How do I reference the current cell?
  132. auto populate cell in worksheet
  133. "one hundred" converted to 100
  134. Populate Array from a range in a closed workbook in vba
  135. Trying to call a amcro on selection of a cell in a range
  136. Modeless Userform event
  137. Solved: Why is vba not obeying an if statement to skip a sheet?
  138. VBA Copy/Paste Offset Values Between Sheets
  139. Solved: Copy Entire Row based on Cell
  140. Solved: Why is the sorted array Not being returned?
  141. Linking-updating worksheets?
  142. [Excel] Data transfer to new file
  143. VBA "ignoring" request to not copy from sheet
  144. Comment box listing sheet names from active cell
  145. Values from Spreadsheet into Userform Textbox
  146. i want to learn VBA
  147. Extract entire row based on the cell value
  148. [SOLVED:] List all sheets of opened workbook into ComboBox
  149. delete row is A(x) is blank
  150. How to write this kind of code
  151. Solved: How to insert ToolTips in Cell?
  152. Adding rows and copying cells
  153. Solved: ActiveCell rw,col
  154. Converting English number Fomat to German number Format
  155. search for mulitiple text strings, return value
  156. Solved: Copy cells with no spaces and paste with semi-colon
  157. (Limited) Loop Through Sheets.
  158. Solved: Auto_Run macro that only auto_runs once
  159. [SOLVED:] How to check if a shape Exists?
  160. Class Project for bnwhite
  161. Compare Private Function help.
  162. Solved: IF(IsNumber
  163. changing chart colours dynamically
  164. [SOLVED:] Chart titles with varied font sizes
  165. Data Values in chart
  166. Select All Data
  167. Trying to modify an macros
  168. Importing data; action when ready
  169. Solved: Help opening csv files in Excel
  170. Conditional count
  171. Apply macros to an other workbook
  172. Solved: Read in Excel, Write out to Text
  173. VBA Split Workbook macro
  174. Solved: Help with Excel roster matching...
  175. Drop down in one cell & fill another cell
  176. Solved: Randomly picked winners
  177. Solved: Copy input range
  178. Compare Data from one sheet to another
  179. Can you make VLOOKUPS conditional?
  180. Solved: Switching the Worksheet Deletion Warning Off?
  181. Chart scaling and adjusting
  182. Use vlookup formual in data validation
  183. saving a MSP file to open up in Excel and back
  184. Pivot Table - Blank rows/columns
  185. Solved: Autofilter
  186. Excel crasches while opening files with references.addfromfile
  187. Problems with Evaluate method in VBA: Variance of the product of two ranges
  188. Conditional [Color] Formatting not recognized with formula
  189. Solved: Find & Replace problem
  190. Solved: Userform query
  191. Help!! Excel Data gets cut off when pasting to ppt slide
  192. determine if "File Download" window is there
  193. Excel 2003 speed up code???
  194. Copy and paste part of data to new workbook and save in specific directory
  195. Excel sends email with low importance
  196. Sleeper: Unfinished Macro Copy cells from different Workbooks to a Main Workbook
  197. Save As File Type 'Options'
  198. [SOLVED:] stupid questions
  199. Help needed with this function call
  200. Change series of a chart without using relative reference....
  201. Excel 2007 Color Compatibility Issue
  202. Emailing in Excel using VBA Groupwise
  203. Solved: Adding and apostophe to the beginning of numbers within cell
  204. Unique Rows In New Workbook
  205. Different access for different users
  206. Solved: Which button is Chosen
  207. Parse Phone Numbers (Main, Office, Cell)
  208. VBA Conditional Page breaks
  209. Sheet to Sheet Range To Range Copy (VBA)
  210. listbox multi selection problem
  211. Solved: How to prevent user from selecting other background color
  212. Extract STATE from address string
  213. Replace/Remove word/characters from a String
  214. excel cannot complete this task with available resources
  215. Solved: Parsing string elements in an array
  216. Else error
  217. [SOLVED:] Copy excel settings from a pc to another
  218. Environ Function Help!
  219. Solved: Calculate 2 cells
  220. copy contents of a template sheet to another sheet
  221. Application.calculatefull problems!
  222. Need front end for db form??
  223. Logic of multiple search criteria. Help Please!
  224. Delete Selected Sheet
  225. Solved: Add data to a closed workbook
  226. [SOLVED:] Ignore Message Box in excel
  227. domain availability
  228. Add New Worksheet to Include Date
  229. ADODB.Connection Error: Compile Error
  230. Solved: Count unique records using multiple criteria
  231. New line in tiptext
  232. Solved: Do not know how to approach this one?
  233. Reposition Jpg in the middle of the screen?
  234. Autorun a macro when workbook is open
  235. Solved: PLZ HELP...muliple criteria in Excel
  236. Solved: Frame On Excel
  237. Solved: Problems formatting different date formats
  238. changing range
  239. Add Comment Picture: Maintain Perspective Ratio
  240. Format Command Button (Form based)
  241. Solved: InString Function
  242. Copy Errors
  243. Solved: Unprotect Worksheets
  244. select/copy cells in a range that contain data
  245. Solved: Insert a specific row at the ActiveCell
  246. Solved: deleting rows based on content of cells
  247. Floating Comments over Command Button
  248. Solved: Total
  249. Macro to choose Specific Workbook from a directory
  250. Solved: Combination list using VBA