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

  1. Add formula to cell
  2. Application.close information required
  3. Solved: Running two macros on opening
  4. Hint about VBA functions
  5. How to dyamically change which pages will print
  6. Solved: Data Validation on User Form
  7. ComboBox Help!
  8. Sleeper: Excel to Autocad
  9. Loop through charts
  10. Resetting Color Pallette
  11. Seeking help in creating an excel macro for shutting down pc
  12. Find the cursor position in a string
  13. Coloring depending on the Series
  14. Excel Crash
  15. Solved: Checking if macro run again- same month
  16. How to access menu items of Excel add-in?
  17. [SOLVED:] Lookup question
  18. Solved: Adding pre-fixes
  19. Stop code from running when opening
  20. Inter related items
  21. Solved: Applying an Advanced Filter Using VBA
  22. Macros for excel
  23. Create a List based on Cell Values from multiple Sheets & Columns
  24. VBA Code to export formula to cells?
  25. Loop trough workbooks and Paste values
  26. Solved: Sort Not Working When Formatting Applied
  27. Sumif formula
  28. Solved: Displa first item in combo box
  29. Solved: Make Code run only on xls files
  30. Excel - transpose multiple records
  31. VBA Column Looping
  32. Solved: error when looping
  33. Autofilter on row 3
  34. Speeding Up Vlookups
  35. Solved: Option Explicit
  36. Help in sorting in data or macro or simple method.
  37. Write to Module Using VBA
  38. Extending chart series range
  39. Solved: SUMIFS
  40. copy down formula
  41. Merging Cells
  42. Dynamically Specifying Series and X/Y Values of a Chart
  43. Excel Custom Headers and Footer
  44. Converting formula into values.
  45. How to control which vba Excel program has control on computer
  46. Populating Oracle SQL Queries in different Sheets in Excel using VBA code
  47. Webbrowser control
  48. Solved: text box dependent on list box in userform
  49. Solved: ignore files which are blank?
  50. Excel File Properties in Windows Explorer
  51. Macro to countif multiple criteria
  52. Exporting Data into Different Cells at Set Intervals
  53. Solved: other possibilities?
  54. VBA: Identify Last Column with data in a specific Range and copy to next column
  55. unable to set the text property of the characters class
  56. Solved: FindNext
  57. Sending the Email by Excel by searching the Attachment names start with 302568
  58. Bring chart infront of web browser
  59. Import txt files into excel
  60. Solved: insert text in columns with itineration
  61. Solved: Run a macro with inputbox
  62. Solved: Determining size of chart area?
  63. camembert
  64. Trigger Macro by change in formula value within a cell
  65. Solved: label.caption take text from file
  66. Solved: Userform + Range=#value
  67. Staff ID Number format
  68. Solved: Macro processes too much, so Office apps hang until finished! Ideas?
  69. Spin Button
  70. How to Make Handwritten Code or Macros
  71. Solved: Week Number Of The Month
  72. Solved: UDF in Conditional Formating
  73. Interesting Issue With Labeling Data Points
  74. AfterUpdate Event
  75. Solved: Age calculation
  76. Solved: MkDir, multiple directories?
  77. Solved: Animation Control limitations
  78. Enable Macros when opening Worksheet
  79. Solved: Adding text to a cell with CheckBoxes
  80. Solved: Conditional Formatting
  81. Interacting the Search Dialogue Box
  82. Solved: Create on the fly labels with click events
  83. Solved: Comparing two columns of data and outputting the differences
  84. Solved: Arrays with Arrays
  85. Problems with interface design for when long macros process (suggestions welcome!)
  86. Adding to Named Range and Disappearing coloring
  87. Solved: Ending a loop at the bottom of column
  88. Solved: Calculating stock price volatility over and over and over...
  89. Solved: VB code to save file to app directory?
  90. Code to save to a sub folder?
  91. Picking respective value from different col based on a particular value input.
  92. Solved: Show Desktop
  93. Solved: Counting Text with commas
  94. Imported dates
  95. C&P format & formula if certain data entered
  96. Solved: Code to stop all subsequent code and return to userform
  97. Set max value in array item?
  98. How to paste in selected rows of the selected column
  99. Solved: Finding Bad Names
  100. Solved: Data input macro help needed
  101. Plugging time in excel sheet
  102. Report Based on following sample of data
  103. Solved: VeryHiding Sheets after given date
  104. Unhide Hidden Rows
  105. SUMIF IN VBA with external references
  106. VBA - answer "yes" or "no"
  107. Mapping Values
  108. [SOLVED:] Circular reference in a formula
  109. How to create a UDF Function?
  110. Referring to an array in many subs
  111. excel formula in vba
  112. Solved: One variable defined as text, the other as integer Problem
  113. Solved: Nested IF function
  114. Restrict Worksheet Scrolling Help
  115. Solved: Question About Circular References
  116. Solved: How to calculate running totals
  117. Sleeper: Invalid references table and copy the valids to another table
  118. Solved: Managing the Case of First Letter
  119. Excel 2000 vs 2003; additional control; substitute
  120. Solved: Macro to sort data ascending
  121. Solved: Keep selected cell centred
  122. Solved: Inserting dynamic range into new table
  123. Solved: (location) inside of the combobox
  124. Solved: Debugging a VBA programm in Visual Basic Editor (VBA Excel )
  125. Solved: FILE DATE
  126. Solved: Finding Matching Date
  127. Solved: Sort Data Based on Value of a Cell
  128. Combining multiple worksheets WITHOUT the same arrangement.
  129. Solved: How modify VBA to split multiple cell?
  130. Solved: Calculating Hours Earned
  131. Create userForm by code
  132. Solved: Listing file/folder attributes from user input
  133. Solved: VLOOKUP in multiple arrays
  134. Autofilter, copy-paste to new sheet
  135. Solved: Problems with running pre-Excel 2007 macros
  136. Adding values
  137. Solved: Help With a Formula
  138. Display percent value
  139. Solved: QueryTable wont work in Excel 2007
  140. Solved: Move columns
  141. VBA Macro for Log File
  142. Solved: Calculating Hours Earned
  143. Solved: translate from Excel in VBA
  144. Instant messenger in EXCEL
  145. INDIRECT VLOOKUP formula problem
  146. mark duplicate row with condition
  147. Solved: Formula Problem
  148. Solved: DELETE LAST
  149. Solved: moltyply times
  150. Center userform using Printform
  151. Column to headings& heading contents to rows
  152. Solved: Populating a userform....
  153. [SOLVED:] Please Help with Checkbox Alternative
  154. Solved: Copy Sheets to new workbook and save copy
  155. display label as Year & text
  156. Solved: How to assign different face id to macros in a toolbar
  157. Solved: Misserable example....
  158. Solved: Convert time entered on row to ascending dates
  159. loop
  160. pivot table question
  161. Book Recommendation
  162. Sleeper: Get Combobox2 value if a value is selected in combobox1 in the WorkSheet
  163. [SOLVED:] Make Selection on sheet1 that will duplicate on all worksheets
  164. A macro code to check whether any workbook is currently open or not.
  165. Copy Colours
  166. Solved: Date Delete
  167. How to alter Paste Range in VBA
  168. copy transpose
  169. A macro to authorize a user to run another macro.
  170. Extract GPS data from jpeg file properties with VBA?
  171. Solved: How to create a VBA program based on lookup formula
  172. Solved: the number in this cell is formatted as text
  173. Text Format need help
  174. Strange things happening
  175. How to copy only the headers and columns of requested
  176. Calculating 99% in entire cell in Col M. Col M is filtered
  177. Solved: Restrict Saving WorkBook
  178. delete
  179. Holiday and earned time minor problem
  180. windows services in Excel VBA
  181. Solved: Extract data from Website to Excel
  182. How to get this formula shorter
  183. open multiple workbooks and enable macros, then close
  184. Solved: Checkbox control(s)........looping
  185. Paste Especial/Value/Transpose . . .
  186. Take the size of the Array
  187. VBA Date Range Argument
  188. [SOLVED:] Need macro to remove text
  189. Solved: Copy Worksheets from one Workbook to Another
  190. Sleeper: VBA code needed for creating references in Excel
  191. Need a code to place Excel charts to Powerpoint (Different Sizes)
  192. create list of references
  193. Partial format of cell
  194. Identify the write mode of a workbook
  195. uneditable comboboxes
  196. Solved: trim function.
  197. Using a defined string in a vlookup
  198. Solved: Change Values
  199. Extract from worksheet into new workbook, for daily reporting.
  200. Solved: Outputting Listbox values AND filtering using those values
  201. Solved: DOUBLE LOOKUP HELP
  202. Splitting summary sheet based on workorder ColA.
  203. Solved: Save As dialog help.......please!
  204. complicated Match
  205. Solved: Populate ListBox with Multiple Rows of Data
  206. Solved: Excel Scatter Graph Horizontal Line
  207. Solved: How to design a code based on excel formula?
  208. Rearrangement of Code & Immediate Windows!
  209. Solved: Email file with password HELP please
  210. Solved: Looping named cells
  211. Solved: FileSearch VBA
  212. Solved: Search all worksheets
  213. Solved: Add another sheet to the search
  214. Arrange sheet data
  215. Lookup from external text file
  216. Multiconditional sort, match and list with exceptions
  217. Populate ComboBox with contents of ListBox
  218. Dynamicly Fill Listbox with column headers?
  219. Solved: Import of csv file fails in 2007 only
  220. Solved: Rearranging columns
  221. Solved: A simple formula would probably do the trick
  222. Copy Data From Orders to Database
  223. Solved: MsgBox - Error
  224. Skipping the Browse For Folder
  225. Solved: Clear cell not entire row
  226. Solved: Class module for two-dimensional array
  227. Solved: Filter worksheet using List Box (multi select) Selections
  228. Nice image import code
  229. Solved: Multiple Column Colour Change
  230. Searching folders
  231. Solved: Reverse find
  232. Solved: Lookup Values Across Tabs and Set Flag
  233. Copy and paste data based on criteria
  234. Solved: Range Copy to different worksheets
  235. Solved: What's wrong with my copy/paste VBA code
  236. Groupwise VBA to Change "From" field
  237. [SLEEPER:] Email files with same names from folder
  238. Solved: Macro "Stautsbar" from ThisWorkbook i want for whole excel
  239. Solved: Date Problem In Chart
  240. Solved: How to stop nuisance warnings
  241. Terminate Excel Process
  242. Cell Format Number Issue
  243. Solved: dual purpose TextBox string
  244. Paste data in clipboard
  245. Solved: Binding Macros to Buttons
  246. Trial Code Error
  247. can't get caluclate event to fire vba
  248. Search and Replace Macro
  249. User form OHR and Password break.
  250. macro search