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

  1. Solved: Computer identification
  2. Solved: Exit behaviour for last field in a frame
  3. Solved: Search for Tab
  4. Solved: Missing Add-in
  5. Create Random String
  6. Solved: modify the program(InsertRow&Formatting)
  7. How to reopen VBA editor using password?
  8. VBA Display Named Range
  9. Delete VBA Code of another Excel
  10. Finding Print Area in a excel worksheet
  11. Run Time err 1004: Unable to get the vlookup property of the worksheet function class
  12. Retain Comments in Printout of excel
  13. Solved: Digits in number
  14. Solved: Trying to Remove Quotes in txt File
  15. Application-defined or object-defined error
  16. Include Multiple column groups on every page?
  17. Conditional formatting
  18. Problem Changing Defined Name Scope in Excel 2007
  19. VBA to AutoSave and Copy to diff location
  20. SetFocus Method Not working
  21. Solved: How to write format code in VBA?
  22. Find Next Column
  23. Save range as a new file?
  24. Macro for comparing cells on 2 sheets in Excel
  25. Array of a custom class???
  26. Solved: No of characters in a formula
  27. Passwords Security
  28. Each subtotal signature require only at last page for each subtotal.
  29. Single or Double
  30. Solved: Print, Save As, Exit Sheet & close Current workbook
  31. Integer division
  32. Adding Custom button in titlebar of userform
  33. Creating number
  34. Resetting Used range with VBA
  35. Identify Conditional Formatting
  36. excel to work passing data dynamically with bookmarks in word
  37. Working with various Ranges (Named Range) and Worsheet Events
  38. Solved: Display Calculotor
  39. Solved: Place a comma in between two words
  40. How do i print LISTBOX CONTENTS INTO EXCELL SPREADSHEET
  41. Solved: truncate string and onward
  42. Solved: Sorting Email Addresses column
  43. Similar data
  44. Printing equation into cell
  45. Simulating mouse click on web page
  46. Solved: opening excel file using VBA
  47. Solved: How to start pasting on the last row?
  48. Start time help
  49. Excel open dialog box
  50. Solved: Add Formula to Cell Using VBA
  51. Solved: Copy data from one Spreadsheet to another and validate
  52. Help with creating Array from Checkboxes
  53. VBA code to force invoke Excel 2007 instead of 2003 (from Access)
  54. Solved: Toolbox icon in VBA
  55. Solved: Trim titles
  56. Combining and aligning data from multiple sheets
  57. Help with Arrays
  58. Solved: Offset to 1st & 2nd cell in row
  59. Solved: Copy a subset of a named range using Union
  60. Solved: How to use LookUp/If-Then in VBA?
  61. Script to remove custom views
  62. Solved: Pivot Cache Consolidation
  63. Solved: How to make a folder in the same path
  64. "File Locked for Editing" When Not Even Open
  65. Dividing merge cell into ten equal rectangles for inputing Digit?
  66. Solved: Finding non numeric in range using an array
  67. How to List Named-Ranges only from specific Sheet
  68. How can I grab the data from a LISTBOX and insert it on COLUMN "G1"
  69. Hide VBA operations
  70. Solved: hide the button for certain time of the day
  71. Solved: Row to repeat at bottom
  72. Solved: What's wrong with my Paste Special Transpose Code?
  73. validating values in excel using VBA
  74. Solved: Help deleting rows please
  75. Solved: Pivot Cache Consolidation
  76. Solved: How to Replace Horizontal Tab in Excel
  77. Solved: Worksheet Menu Bar
  78. Parsing Name Help
  79. Solved: reset picture# in Excel
  80. Solved: I'm stumped ....please help
  81. Disable "Show sheet tabs" option
  82. MsgBox vbYesNo help
  83. Solved: Convert Monthly to Quarterly using Macro
  84. Solved: Another Problem
  85. Evaluate method & For Loop: which on is faster
  86. End If without Block If
  87. Solved: Error "400" in VBA
  88. Adding code to a worksheet on the fly
  89. Solved: keep cursor in textbox...
  90. delete all except the last duplicate
  91. Help!!!!
  92. repeat rows at bottom of page
  93. Solved: How Does VBA Handle Multiple Conditions Within an If Statement
  94. Textbox help with msgbox
  95. Return Value from UserForm
  96. Put textfile on desktop
  97. School exercise, i'm desperate
  98. VBa Code exist?
  99. VBA Calendar
  100. Permanently Hide Sheet Tabs
  101. Solved: Edit/update code in multiple workbooks
  102. Solved: Select a particular cell before closing
  103. Improve functionality of table
  104. Solved: SIMILAR NUMBERS
  105. Solved: Count Cell if it is numeric
  106. Worksheet Change event not triggering sub
  107. Solved: Renaming an opened workbook
  108. formating the calculation result
  109. New to forum, need help
  110. Solved: Select, Insert & Print Macro
  111. Solved: Auto populate a column
  112. Solved: Deleting unwanted worksheets in WB
  113. update page footer
  114. VBA to get details of files in a folder
  115. Solved: Delete a Sub Not needed anymore
  116. color cells
  117. Solved: INDEX/MATCH ...VLOOKUP?
  118. VBA - Advanced filter with data Validation
  119. Solved: Search different sheets
  120. Two search category & two search terms
  121. Duplicates and Deletes
  122. Solved: Search function VBA
  123. Solved: Help with my vlookup formula
  124. External Data
  125. cross tab excel refresh
  126. Solved: VBA Password Protection
  127. Solved: Limit Scrolling VBA
  128. Solved: Quite a complicated one...perhaps?
  129. Solved: External data problem
  130. Saving a copy of an Excel file without code behined it
  131. Getting the file name
  132. Compare dates of different years
  133. Asking the user where to output the macro's results
  134. Problem with copy data from a closed workbook
  135. filesystemobject
  136. hiding ribbons
  137. Find All and Return related Value
  138. Calling Excel shortcuts from VBA
  139. Solved: Merging Sheets
  140. Is it possible to link Excel and Access?
  141. Call value from worksheet
  142. Solved: Create 4 cell range to copy
  143. Issue with Listbox on Excel Userform.
  144. Copy specific cell range from different workbook to one excel sheet
  145. Solved: Sharing Modules
  146. Solved: Listbox selection as a parameter in data extraction macro.
  147. Solved: MROUND Function
  148. look for value then put them to the SampleSheet
  149. Pivot Table Conditional Formatting
  150. Shared workbooks and who is using them.
  151. Solved: If Statement
  152. Solved: Index / Match NA
  153. Conditional Formatting - Shapes
  154. minimising and unminimising ribbons event
  155. Pivot Table Formats
  156. Solved: ActiveChart Source PlotBy…With Scroll.
  157. Excel Vba and Access
  158. Force Excel to Stop Recognizing Numbers
  159. Exit userform and save changes
  160. Sort Question
  161. Solved: =IF Formula Help
  162. Paste Results to Spreadsheet
  163. Solved: How to create autofilter code using Textbox Userform?
  164. Solved: Conversion
  165. Solved: Clear The contents of Adjacent Cell
  166. Protection
  167. Solved: Copy rows from one sheet to another.....
  168. Solved: How do you eliminate the dropdown arrow in my autofilter code?
  169. Solved: MkDir advice.....please!!!
  170. WebBrowser in Excel UserForm
  171. Solved: how to do BACK (in workbook between sheets)
  172. How to delete expansion buttons???
  173. Solved: Checkbox code?
  174. combobos rowsource
  175. Data Validation list referencing
  176. Return web site data using Excel and VBA
  177. Solved: countif meet two conditions
  178. How to use of Macro to AutoFilter data on a shared workbook?
  179. Private Function problem
  180. Find out the minimum interior colorindex in each column
  181. problem with Find()
  182. Solved: Using data validation to return values
  183. Solved: Modify exiting VBA code for copied the particular sheet from multiple excel files.
  184. Excel VBA - retrieve Sybase TEXT data type
  185. Excel Turn Around Time Calculation
  186. entire row
  187. Solved: Object library invalid........
  188. subtraction
  189. Problems opening files
  190. Send Email to address in previous box
  191. Here's an easy one...MONTH
  192. Manipulate Cell Comments
  193. Solved: Get cell comment text in another cell
  194. Solved: Add prefix to a number
  195. Solved: Speed with array vs. dictionary
  196. Avg last ten
  197. Ont-time Alert on breaking threshold
  198. Copy range by condition
  199. Using conditional formatting in 2007
  200. Solved: AutoFilter, Criteria, Header
  201. Solved: How do you write this formula in VBA code?
  202. Solved: change font color after updated
  203. Solved: copy data automatically to another sheet
  204. filter
  205. Solved: Identify Button that has been clicked
  206. Run-time error for Highlighting
  207. Solved: Redim a range
  208. Solved: Excel VBA code to merge 2 columns into 1
  209. Select cell before sheet deactivate
  210. Solved: UserForm Help for Travel Log
  211. Solved: VBA - Range and value match and replace
  212. Solved: Merging data from two spreadsheets
  213. Solved: insert a date for the current year
  214. Solved: Combine multiple sheet become one
  215. Can't get Match Index Formula right
  216. Solved: {Solved}calculation:multiply
  217. Solved: Always open a new instance of excel
  218. Data validation.........vba array
  219. Function to write the Interior Color
  220. entirerow.
  221. Solved: Range Select and Delete certain Values
  222. entirerow.delete
  223. Unable to set the Visible property of the Worksheet class
  224. need typo conditional formating code
  225. Solved: Modify exiting VBA code to open one sheet instead of several multiple sheet copied
  226. Using the Number Formatting Language to Specify the “BOLD” Attribute
  227. Variable
  228. Duplicate numbers
  229. Solved: How to get data from TextBox?
  230. VBA Code: Populating data in different sheets
  231. combined Vlookup & Hlookup?
  232. Exit Userform and close excel
  233. Print a UserForm
  234. Solved: Syntax to "print in header"
  235. Solved: UF Copy Textbox Value
  236. Visual Basic (for applications)
  237. UF Radio Button get value
  238. How to find the Count of Records in List in atleast one-null scenario?
  239. Creating Userform Instructions
  240. Is there a faster way to perform this function?
  241. Solved: Tab
  242. vba Trim help
  243. VBA for pasting excel chart in powerpoint
  244. Getting the PivotTable Page data from another sheet
  245. Solved: Help with simple Macro (I'm sure)
  246. Solved: Help to apply contract penalties
  247. Solved: Prompt to enable macro
  248. Activesheet is not working. What may be the cause?
  249. How to call value from one sheet to another sheet using VBA macro
  250. UF Case Mutliple values in cell