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