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